PROFESSIONAL SUMMARY:

• Having 10+ Years of experience in the areas of analysis, design and development of Oracle Applications 11i and R12 Financial and Supply Chain Management Modules.
• Good Technical Development skills with hands on working experience on RICE Components in the domain of Oracle Applications E - Business Suite using SQL, PL/SQL Developer.
• Extensive experience with analysis, design, development, customization and implementation of ERP Oracle applications (Inventory, Oracle Account Receivables, Oracle Order Management, Oracle Purchasing, Oracle Payables, Oracle General Ledger, Fixed Assets, Cash Management, Costing, Install Base and Advanced Supply chain planning).
• Proficient in analysing and translating business requirements to technical requirements and architecture
• Involved in Full Life Cycle Implementations and Support of Oracle Applications.
• Worked on Forms Personalization.
• Worked on P2P and O2C cycle.
• Expertise in Developing Procedures, Functions, Packages and Triggers in PL/SQL.
• Good knowledge in developing UNIX FTP and shell scripting.
• Experience in Inbound Data Migration using SQL* Loader and Outbound Interface using UTL FILE package.
• Good knowledge in Development of XML Reports.
• Good exposure to Oracle Application Implementation Methodology (AIM 3.0).
• Experience with Oracle and other Utilities: TOAD, SQL Developer, PL/SQL Developer and SSH client.
• Used advanced PL/SQL features like PL/SQL tables, records, Bulk collect, Pragmas for error handling and cursors for data processing.

Applications: Oracle Applications (R12/11i) Technologies SQL, PL/SQL, Workflow, Oracle Forms and Reports and XML Publisher

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

RDBMS: Oracle 9i, 10g, 11g

Tools & Utilities: SQL*Loader, SQL*Plus, TOAD, WinSCP and Putty

GUI: 10g Developer Suite, Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential, Webster, NY

Oracle Apps Technical Lead

Responsibilities:

• Playing a role of Technical lead First Point of Contact on client location at Webster, New York.
• Working closely with the functional consultants to understand the requirements and design feasible solutions accordingly.
• Actively involved in the Core supply chain management and financial interfaces and processes.
• Preparation of Technical Documentation as well as development for the new enhancements.
• Registration of custom tables and concurrent programs which are required for the new enhancements.
• Creation of Value Sets in various modules of application.
• Creation of RICE components for the new enhancements.
• Involved in client meeting weekly and follow-up on the tickets.
• Involved in support of Customization.
• Developed conversions and Oracle client extensions to accommodate complex business requirements in Account Receivables Module
• Involved in the design and development of 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

Environment: Oracle Apps R12, SQL, PL/ SQL, UNIX Shell Script and 11g Data base.

Confidential

Oracle Senior Developer

Responsibilities:

• Involved in supply chain management and financial module interfaces, conversions, reports and forms.
• Worked on PO Sourcing Rules Interface to import sourcing Rules Information from Legacy systems.
• Worked on Cost Interface to copy cost details from one organization to other organization
• Worked on AR Transaction interface to load data from legacy system.
• Worked on GL outbound Interface to list Journal details along with source information.
• Developed AP Invoice Aging Report.
• Developed AP Accrual Aging Report.
• Developed PO SCM BOM Matrix Report.
• Developed OM Delivery note Report.
• Developed OM Open SO Report.
• Worked on Form Personalization in GL, OM, PO, AP module forms.
• Worked on Standard PO Import Conversion Program.
• Worked on PO Sourcing Rules Conversion.
• Worked on AR Transaction conversion program.

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

Confidential

P2P Analyst and Developer

Responsibilities:

• Development/Enhancement of the 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, GL modules
• Developed custom forms, reports, XML publisher reports.
• Involved in the Analysis, Design, Coding and Testing of the application.

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

Confidential

OTC Developer

Responsibilities:

• Worked on GL interface to import the Journals data from Legacy to Oracle Applications GL base tables using the standard program ‘Journal Import’.
• Developed Payment Details Out bound Interface
• Developed Supplier Outbound Interface
• Developed AR Invoice Outbound Interface.
• Developed AP Invoice Aging Report.
• Developed Printed Requisitions Report.
• Developed Supplier Payment Report.
• Developed Invoice details Report.
• Worked on Form Personalization to disable the Change Period button in Journal Entry screen.
• Worked AP Invoices Conversion.
• Worked on AR Invoices Conversion.
• Worked on Supplier Conversion

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

Confidential

Oracle Developer

Responsibilities:

• Worked on GL Daily Rates interface.
• Developed an Inbound Interface to Load Purchase Order Details into Purchasing Applications Base Tables from Legacy System.
• Developed Inventory Item Outbound Interface
• Worked on Item Conversion.
• Worked on Requisition Import to import Po requisitions data from flat files to ORACLE Applications.

Environment: Oracle Apps 11i, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i Data base.