SUMMARY

• Oracle PL/SQL Certified Developer with extensive 13+ years of experience in the analysis, design and development of Oracle 9i, 11g and 12c databases using advanced PL/SQL features.
• Additional expertise in Oracle Applications E - Business Suite Applications 11i and R12 Financials, Supply Chain Management and Manufacturing modules and data utilities including TOAD and SQL Developer.
• Expert in the analysis, design, development, customization and implementation of Oracle ERP applications (Oracle Inventory, Oracle Account Receivables, Oracle Order Management, Oracle Purchasing, Oracle Payables, Oracle General Ledger, Fixed Assets, Subledger Accounting, Cash Management, Costing, Install Base, OracleWork in Process, Oracle Bills of Material, Oracle Service contracts, Oracle Quality and Advanced Supply chain planning).
• Proficient in analyzing and translating business requirements into technical requirements and architecture.
• Hands-on experience in the development/customization of RICE components of Oracle Applications E-Business Suite using SQL, PL/SQL developer.
• Skilled in the Full Life Cycle Implementation and Support of Oracle Applications with proven ability to create high performing custom PL/SQL code and XML reporting.
• Expert in Oracle Forms Personalization and customization.
• Hands-on experience on Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• In-depth experience in developing and tuning Oracle database objects including Procedures, Functions, Packages and Triggers in PL/SQL.
• Skilled in developing UNIX FTP and Shell scripting.
• Expert in Inbound Data Migration using SQL* Loader and Outbound Interface using the UTL FILE package.
• Hands-on experience in Oracle Application Implementation Methodology (AIM 3.0).
• Expert in using Oracle advanced PL/SQL features like PL/SQL tables, records, Bulk collect, Pragmas for error handling and Cursors for data processing.

TECHNICAL SKILLS

Applications: Oracle Applications R12/11i, Oracle 12c

Technologies: SQL, PL/SQL, Oracle Forms, Oracle Reports, XML/BI Publisher and Workflow

Modules: PO, OM, AP, AR, INV, FA, CM, CST, BOM, WIP, SLA, IB, ASCP, QA and GL

RDBMS: Oracle 9i, 10g, 11g and 12c

Tools: & Utilities: SQL Loader, SQL*Plus, TOAD, SQL Developer, PLSQL Developer, Data Loader, More 4 Apps, Discoverer, Noetix, SSH client, WinSCP and Putty

GUI: 10g/12c Oracle Developer Suite, Workflow Builder

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle EBS Developer

Responsibilities:

• Analyzing and understanding business requirements.
• Customization of RICEW components for the new enhancements
• Developing design documents for each customized object.
• Developing new reports in EBS based on existing Cognos reports as per user requirements.
• Changing the custom business objects logic to support as per R12 Oracle application features.
• Developing the custom business objects.
• Understanding and writing the Performance testing scenario documents.
• Smoking the environments for new builds.
• Analysis and corrective action on Incidents logged in Serena.
• Understanding problems and suggesting solutions online.
• Wrote packages to develop conversion programs.
• Data fixes for issues that include correction and pushing the transactions.
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
• Loaded data into Oracle using Data Loader and More 4 Apps tools.
• Performed System testing and Integration.

Environment: Oracle Apps R12, SQL, PL/ SQL, Oracle 12c Database and XML Publisher.

Confidential, Rock Hill, SC

Oracle EBS Developer

Responsibilities:

• Analyzing and understanding business requirements.
• Customization of RICEW components for the new enhancements
• Developing design documents for each customized object.
• Working on the system integration and production issues.
• Developing new reports and fixing the existing issues in Noetix reporting tool as per user requirements
• Changing the custom business objects logic to support as per R12 Oracle application features.
• Developing the custom business objects.
• Understanding and writing the Performance testing scenario documents.
• Reporting the performance results with analysis and recommendations.
• Smoking the environments for new builds.
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Loaded data into Oracle using Data Loader.
• Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
• Performed System testing and Integration.

Environment: Oracle AppsR12, SQL, PL/ SQL, Oracle 12c Database and Noetix.

Confidential, Webster, NY

Oracle Applications Technical Lead

Responsibilities:

• Technical lead and First Point of Contact at client location.
• Collaborated with the functional consultants to understand the requirements and design feasible solutions accordingly.
• Developed Core supply chain management and financial interfaces and processes.
• Prepared Technical Documentation and development for the new enhancements.
• Registered custom tables and concurrent programs which are required for the new enhancements.
• Created Value Sets in various modules of the Oracle application and RICE components for the new enhancements.
• Supported customization, followed up on tickets and attended weekly client meetings.
• Developed conversions and Oracle client extensions to accommodate complex business requirements in Account Receivables Module
• Designed and developed Interface program in Oracle Account Receivables to import Invoices from Legacy to EBS.
• Developed interface program to import orders from Legacy to EBS in Order management module
• Developed custom PL/SQL and XML reports in Account Receivables and Order management Modules
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Prepared technical specifications including SDD and TDD from functional specifications received SRD from functional team.
• Performed System testing and Integration.

Environment: Oracle AppsR12, SQL, PL/ SQL, UNIX Shell Script, 11g Database and XML.

Confidential

Sr. Oracle Developer

Responsibilities:

• Responsible for supply chain management and financial module interfaces, conversions, reports and forms.
• Developed PO Sourcing Rules Interface to import sourcing Rules Information from Legacy systems.
• Developed Cost Interface to copy cost details from one organization to other organization
• Constructed AR Transaction interface to load data from legacy systems.
• Developed Discover reports in various EBS modules.
• Designed GL outbound Interface to list Journal details along with source information.
• Developed AP Invoice Aging Report, AP Accrual Aging Report, PO SCM BOM Matrix Report, OM Delivery note Report and OM Open SO Report.
• Created Form Personalization in GL, OM, PO, AP module forms.
• Developed Standard PO Import Conversion Program, PO Sourcing Rules Conversion and AR Transaction conversion program.
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
• Performed System testing and Integration.

Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i/11g.

Confidential

Oracle PL/SQL Programmer/Analyst

Responsibilities:

• Developed new applications per the customer requirements and provided support when required by the customer.
• Developed and enhanced Oracle interface PL/SQL packages and UNIX scripts for loading the data from external files into oracle applications database.
• Developed interface programs in AP, AR and GL modules
• Developed oracle reports and interface programs in WIP and BOM modules.
• Created custom forms, reports, XML publisher reports.
• Responsible for the Analysis, Design, Coding and Testing of the application.
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
• Performed System testing and Integration.

Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i/11g.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed GL interface to import the Journals data from Legacy to Oracle Applications GL base tables using the standard program ‘Journal Import’.
• Developed Payment Details Outbound Interface, Supplier Outbound Interface, AR Invoice Outbound Interface, AP Invoice Aging Report, Printed Requisitions Report, Supplier Payment Report and Invoice details Report
• Created Form Personalization to disable the Change Period button in the Journal Entry screen.
• Performed AP, AR Invoices Conversion and Supplier Conversion.
• Created oracle reports in WIP and BOM modules.
• Wrote packages to develop conversion programs.
• Created concurrent programs and defined value sets
• Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
• Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
• Performed System testing and Integration.

Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script, Oracle 9i /11g.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created GL Daily Rates interface and Inventory Item Outbound Interface.
• Developed an Inbound Interface to Load Purchase Order Details into Purchasing Applications Base Tables from Legacy System.
• Performed Item Conversion.
• Developed Requisition Import to import Po requisitions data from flat files to ORACLE Applications.
• Created concurrent programs and defined value sets.
• Developed PL/SQL code to obtain the required functionality and customization of Forms and Reports.
• Performed System testing and Integration.

Environment: Oracle Apps11i, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i.