EXPERIENCE SUMMARY

• An accomplished Oracle Applications Techno - Functional Consultant, with 7.5 years of proven expertise in design and, development as Oracle Apps Developer and experience in Software Lifecycle Development of Oracle Applications Software Design, Development, Testing and Implementation.
• Strong Hands on Implementation and Support of ERP packages in the functional & technical areas of Financials (AP, GL, FA, AR and CM), Sub Ledger Accounting (XLA), Project Costing, Oracle Customers Online (OCO), Trading Community Architecture (TCA) and Application Object Library (AOL).
• Possesses good knowledge of the User Management Module (UMX) in defining Roles and Responsibilities to implement Segregation of Duties.
• Involved in requirements gathering, analysis and development.
• Good exposure to Procure-to-Pay (P2P) life cycles.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions and Extensions as per client requirements.
• Hands-on experience in Data Conversion, Data Migration and Developing Interfaces, Extensions in various Oracle ERP modules.
• Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL and Form Personalization.
• Hands-on experience in creating and customizing various Reports for Oracle Applications including XML Publisher Reports.
• Experience in creating RTF templates using XML Publisher as also ETEXT output.
• Extensive experience in developing Technical Specification Documents, Gap Analysis and Application Design (MD, CV, BR) using AIM/ OUM Methodology.
• Excellent Hands on Trouble shooting and Defect fixing experience.
• A well-organized, detail-oriented team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

ERP: Packages 11.5.9, 11.5.10, R12

Modules: General Ledger, Accounts Payables, Sub Ledger Accounting (XLA), Fixed Assets, Accounts Receivables, Project Costing, Cash Management

Language: PL/SQL, SQL, UNIX Shell scripting

Database: ORACLE 9i, 10g, 11g

Operating System: Windows, Unix

GUI: XML Publisher, Oracle Reports, Oracle Forms, Discoverer, Forms Personalization.

Tools: SQL *LOADER, PL/SQL Developer, SQL Developer, TOAD, HP Project Portfolio Management (PPM)

Versioning Tools: IBM Rational Clear Case, Win CVS, VSS

Testing Tools: HP Quality Center (QC), Application Lifecycle Management (ALM), Test Direct.

PROFESSIONAL EXPERIENCE

Confidential

Onshore Support Analyst

Environment: Oracle Applications R12 (12.1.3)

Responsibilities:

• Mentored a team of 3 offshore team members for Production Tickets resolution.
• Performed bug-fixing and handled change requests for Oracle Report modifications.
• Worked on trouble shooting an issue with a complex customized Form using Oracle Forms 10g.
• Worked on modification to existing SQL*Plus reports.
• Worked on several tickets involving debugging the code from Java side all the way to the PL/SQL packages and making appropriate code changes in the procedure/ functions.

Confidential, Cincinnati, OH

Onshore Tech Analyst

Environment: Oracle Applications R12

Responsibilities:

• Worked on defining Roles and Responsibilities for the security and login and edit access using the new User Management (UMX) module. Validated the setup steps required for setting up Roles using the UMX module in Oracle EBS R12 and prepared SQL queries which can be used in any Oracle environment to validate the setup data as required.
• Prepared Technical Design and unit tested GL to Essbase interface using UTL FILE package along with a wrapper PL/ SQL package.
• Prepared Technical Design, developed and unit tested TSYS Payment Confirmation interface using XML Publisher (ETEXT format) in AP module.
• Developed a generic UNIX Shell Script for file transfer using the Printer options in the Concurrent Program setup along with custom lookups and DFFs.
• Prepared Technical Design and unit tested a custom interface using a PL/ SQL package to load Assets in FA.
• Prepared Technical Design, developed and unit tested the Check Printing solution for Vantiv that included printing the checks directly from Oracle R12 using the output of Format Payment Instructions concurrent program as the check to be sent to suppliers along with postscript and the remittance stub being printed.
• Successfully handled configuration management on IBM Rational Clear Case tool and review of deliverables.

Confidential

Onshore Tech Lead

Environment: Oracle Applications R12

Responsibilities:

• Lead a team of 1 onshore and 2 offshore team members in the GL Track.
• Since RBS employed the OUM methodology, analyzed the AN-100 analysis specification document for a custom mapping solution and prepared the DS-140 document for the solution that was achieved by leveraging custom OAF forms.
• Also developed the SQL*Loader script for loading test data to perform testing for custom mapping solution.
• Carried out performance tuning of the queries used in the reports using explain plans and hints.
• Developed Custom Value Sets to support the Custom Mapping Solution.
• Prepared Technical Design, developed and carried out end to end unit testing of Oracle Cost Ledger to Walker and Oracle Cost Ledger to OFSAA interfaces involving PL/ SQL packages employing PL/SQL tables and SQL*Loader
• Prepared Technical Design, developed and unit tested a custom XML Publisher report - Inter-Entity Invoices report using the RTF layout capturing Sub Ledger Accounting (XLA) Details and Projects information. This report spanned across GL, XLA and Project Costing modules.
• Using the FNDLOAD commands to download all the LDT files, prepared the code packs for migration between environments.
• Prepared the TE-020 and IM-90 documents to support the migration of code packs.
• Developed a Unix Shell Script for placing output of concurrent programs in required directories as per the RBS directory structure.

Confidential, MN

Onshore Tech Analyst

Environment: Oracle Applications R12

Responsibilities:

• Created the Unbilled to Billed Movement Report using XML Publisher - RTF layout.
• Carried out performance tuning of the queries used in the reports using explain plans and hints.
• Prepared the TD for EOD offset setting program which was a Concurrent Program with execution method as 'PL/SQL Stored Procedure'.
• Prepared the TD and UTP for Manual transactions program which was also a Concurrent Program with execution method as 'PL/SQL Stored Procedure'.
• Developed a custom PL/SQL procedure and created a Concurrent Program with execution method as 'PL/SQL Stored Procedure' for updating user-entered Approver and Reviewers.
• Prepared custom Value Sets for parameters of above concurrent programs.
• Worked on modifying an existing custom PL/SQL procedure for the Money Transfer Receive to Card (MTR) project which would determine the Settlement to be paid to the Partner for each transaction with the introduction of the new payout method - MTR. This was part of the Accounts Receivables track.
• Involved in Requirements Gathering and preparing Functional as well as Technical Specifications documents for the Partner Automation project.
• Developed the Error Correction form for Partner Automation Project where users could correct the failed records and run the load procedure once again for the corrected records, using Oracle Forms 10g. This was on similar lines of the GL Interface form.
• Prepared the TD for a PL/SQL procedure for Partner Automation project which would validate the raw data loaded from an Excel spreadsheet before loading it to the custom Partner data tables. This was part of the Oracle Customers Online (OCO) track and involved extensive knowledge of Trading Community Architecture (TCA).
• Prepared table creation scripts for creating custom tables for Partner Automation project.
• Conducted the Knowledge Transition sessions for the Offshore Production Support teams from onshore for both, the MTR and Partner Automation projects.
• Create packages in the HP Project Portfolio Management (PPM) tool for migration of components between environments.

Confidential

Offshore Developer

Environment: Oracle Applications 11.5.9, Oracle Applications 11.5.10

Responsibilities:

• Developed and modified Custom Reports that included Oracle Reports 6i and XML Reports in the Oracle Process Manufacturing and Supply Chain Management modules.
• Created custom Value Sets to be used for parameters for Concurrent Programs.
• Developed Interfaces that related to PL/SQL packages and stand alone procedures in Order Management module.
• Also created Profile Options that the interface required.
• Modified existing custom Forms using Forms 6i.