SUMMARY

• Having 9+ years of relevant experience with Oracle Applications 11i and R12 Financial and Distribution 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 (Oracle Account Receivables, Oracle Order Management, Oracle Purchasing, Oracle Payables and Oracle General Ledger).
• Proficient in analyzing 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.

TECHNICAL SKILLS

Applications: Oracle Applications (R12/11i)

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

Modules: PO, OM, AP, AR, INV, CM,CST, FA, IB and Confidential

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

OTC Senior Developer

Responsibilities:

• Playing a role of Onsite Coordinator 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 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

Confidential

Developer

Responsibilities:

• 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 Confidential 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 Confidential, OM, PO, AP module forms.
• Worked on Standard PO Import Conversion Program.
• Worked on PO Sourcing Rules Conversion.
• Worked on AR Transaction conversion program.
• Worked on CM Bank and Branches migration.
• Worked on CM Bank statement load program.

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

Confidential

OTC Developer

Responsibilities:

• Worked on Confidential interface to import the Journals data from Legacy to Oracle Applications Confidential 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

Confidential

Oracle Developer

Responsibilities:

• Worked on Confidential 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.