SUMMARY

• Oracle PL/SQL developer with 7 years of experience on Oracle 10g/9i, PLSQL, Oracle Forms 6i, Oracle Reports 6i and Oracle EBS
• Expert in functional and technical aspects of Oracle E - Business suite /Applications deployments, development, customizations, functionality testing and user training
• Experience with Oracle SQL and PL/SQL programming and used Databaseutility programs like TOAD and SQL Navigator
• Development experience in creating Procedures, Packages, Functions, Triggers, Views, Tables, Indexes, Cursors, PL/SQL collection and optimizing queries as part of performance tuning
• Worked extensively on Ref Cursor, External Tables, Collections and Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
• Expertise in creating XML/BI publisher reports having developed reports and created XML templates and XML data definitions
• Familiar with SQL*Loader to load data from external source like flat files to database tables
• Experience in developing and customizing Forms and Reports using Oracle Form Builder and Oracle Report Builder
• Understanding and collecting requirements from business user side and convert that requirement to SQL queries or PLSQL
• Developed adhoc reports to extract data from database using sql queries and deliver to user
• Proficient in Reports, Interfaces, Configuration, Enhancements(RICE) implementation and conversion
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX shell Scripting, SQL, PL/SQL and SQL Loader
• Expertise in customizing and developing interface programs from legacy applications to oracle applications for the EBS modules like Order Management, Purchasing, Receivables.
• Proficient in Oracle performance related features such as Query Optimizer, Executions plans and Indexes
• Hands on experience on advanced SQL/PLSQL concepts as materialized views, Records, Collections, Dynamic SQL, Ref Cursors, autonomous transactions.
• Experience in testing the existing code and making necessary enhancements for R12upgrade
• Experienced implementation documentation such as SDD(Solution Design Document), TDD(Technical Design Document) and support documentation such as KEDB(Known Error Database)
• Strong analytical, diagnostic, trouble shooting skills and ability to work in a dynamic as well as in team oriented environments
• Contributed and provided solutions at different phases of implementation, testing and go live phases of the project

TECHNICAL SKILLS

ERP: Oracle Applications EBS 11i and R12

Operating Systems: Windows OS 98/XP/7/8, Unix, Sun Solaris

Database: Oracle 9i / 10g

Tools: and Utilities: SQL *plus, Oracle Forms 6i, Reports 6i and PL/SQLDeveloper, Oracle Publisher, TOAD

Languages: C, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked on claims Authorization waive methods, added new rules as per the new requirements and modified the code to handle the new changes.
• Monitoring the claims entry and validating logs for the failed claims. Replicate the issues using claim submission tool.
• Worked on claims adjudication process and modified the PL/SQLpackages by developing the new procedures to handle the business requirements.
• Used query optimization techniques to increase the performance of the SQL query.
• Debugging the PL/SQL procedures and move the changes to production.
• Worked on PL/SQL Types, SubTypes, Collections, cursors and triggers
• Developed scripts for the manual member updates and for daily run jobs.
• Participated in code reviews and worked ontechnical design documents
• Analyzing complex business problems, debugging and optimization of SQL queries
• Understand the business requirements and function specifications of new projects and updates to existing solutions
• Worked on XMLTypes and reports for inbound and outbound process and made changes in existing procedures according to the new requirements.

Confidential, Milwaukee

Oracle PL/SQL Developer

Responsibilities:

• Developed user defined functions based on requirements. Developed backend interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Experience in using various oracle PL/SQL collections like Varrays, Nested Tables and Associative arrays
• Developed PL/SQL procedures for conversion of items using the open items import program.
• Designed and developed order management Interface for import of sales order information into the system. Used SQL*Loader for import into interface tables and PL/SQL block for complete validation of data.
• Used AOL & Sys Admin to register new reports, procedures, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Creating and customizing forms to search property and customer records based on several condition criteria.
• Responsible to create Unix Shell Scripts for code deployment of Packages, Procedures, SQL Files, Reports, XML Publisher reports and LDT files
• Created Staging tables to load legacy data, generated Control files and SQL*Loader scripts and registered them as concurrent program for data loading into the staging tables.
• Customized forms and workflows as per the business requirements and extensively involved in Production support.
• Developed and customized existing forms and reports using Oracle Developer tools.
• Registered customizedOracle reports and XML Publisher reports using System Administrator and Application Developer.
• Customized XML Publisher/BI Publisher reports like Invoices report, and Bill of Lading and Packing Slip Reports.
• Worked with Oracle support using the Service Request Process (creating SRs) to get resolutions on the bugs encountered in Oracle Applications system.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed Interfaces and Oracle client extensions to accommodate complex business requirements
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.Data optimization and manipulation of staged data using PL/SQL packages.
• Performance tuning for forms, reports and critical queries in production system.
• Worked on SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Developed programs using PL/SQL and many packages to do the validations as per requirements
• Good knowledge on APPS tables (OM, PO, INV, AR, Service Contracts)
• Worked on various tables to create Indexes to improve query performance. Also, worked on partitioning large tables using Range partitioning and creating Index Organized table
• Developed XML Publisher reports as per the user’s requirement
• Responsible for writing data conversion routines(APIs, Open Interfaces) to load data information from legacy system to Oracle Apps.
• Performed unit testing and supported integration testing and end user testing
• Generated SQL and PL/SQL scripts to install database objects including tables, views, primary keys, indexes, constraints and packages
• Configured scripts to monitor activity with database
• Monitor the data loading jobs and tuning the SQL queries

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Migration designing and strategy development of legacy data into Oracle Apps
• Changed views and tables as per R12 migration to ensure all programs are running fine.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL andfunctions and procedure for common utilities.
• Using FNDLOAD migrated concurrent programs, value set, RTF template and alerts to another environment.
• Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
• Developed packages and procedures and ensure the code reusability.
• Worked on Order Import APIs to load the orders from legacy system into OM.
• Developed and modified XML reports according to the user’s requirement
• Worked on bug fixes and code enhancements
• Testing the functionality for new enhancements
• Interacting with end users and move changes to production environment
• Monitoring scheduled concurrent programs and interfaces which sends and receive feeds from legacy systems

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Resolving technical and design issues in Oracle 11i of different modules like OM, INV across various instances
• Changing existing reports according to meet the new functionalities
• Wrote stored procedures according to specs and control files for input to SQL *Loader utilities for loading data from external files into the oracle database
• Developed packages and procedures and ensure the code reusability.
• Monitoring scheduled concurrent programs and interfaces which sends and receive feeds from legacy systems
• Expertise in using AOL and system administrator by creating the user and responsibilities which are required
• Added new concurrent programs to the responsibility to achieve the functionality required
• Planning and managing day to day activities.