SUMMARY:

• Senior Oracle Application Consultant with 7+ Years of experience in Oracle Applications 11i and R12.
• Extensive experience in Order Management (OM), Purchasing (PO), Inventory (INV), Shipping (WSH), Account Payables (AP), Account Receivables (AR), General Ledger (GL).
• Very good experience in Implementation projects, Upgrade projects, Support projects and Rollout projects with Oracle Applications 11i (11.5.10 and 11.5.9) and recently R12 (12.1.3).
• Very good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flow.
• Expertise in Developing Custom components like Interfaces for Order Management & Account Receivables.
• Experienced in developing RDF reports using XML/BI Publisher
• Experienced in developing Discoverer reports.
• Experienced in SQL, PL/SQL for writing and customizing program units like procedures, functions, interfaces.
• Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the Oracle Applications.
• Expertise in Developing Shell Scripts.
• Expertise in applying AOL standards and developing RICE components.
• Experienced in working on Alerts, XML bursting and Form personalization.
• Experience in developing and customizing Oracle Forms.
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization and extension of existing OA Framework pages.
• Good at creating technical guides, user manuals and other related technical documentation.
• Experience in handling tickets for support projects and also able to prioritize the tickets based on the SLA.
• Experience in grooming newly joined associates and guided them well which helped in betterment of project.
• Experienced in Agile methodology way of implementing project.

TECHNICAL SKILLS:

ERP Oracle Applications: R12 (12.1.3) & 11i (11.5.10 and 11.5.9)

Development Tools: Reports 10g/6i, Forms6i, Discoverer 10g/9i, TOAD, Oracle SQL Developer, XML Publisher, JDeveloper9i

Packages: MSOffice

Database: Oracle 8i/9i/10g

PROFESSIONAL EXPERIENCE:

Oracle Applications Technical Consultant

Confidential, Windsor, CT

Responsibilities:

• Developed and worked on autoinvoice inbound interface which interfaces the open invoices/receivable from 3rd party into Account Receivables.
• Designed and worked on customer master outbound interface which extracts the new customer and changes from EBS and interface to 3rd party system using the UTL files.
• Developed and modified Discoverer reports related to Account receivable and payables.
• Worked on performance tuning of existing Discoverer reports.
• Designed and developed the customer invoice and customer statements reports as per client business needs using the XML/BI Publisher.
• Developed Shell script which sends emails with report outputs as attachment to the users using uuencode and mailx.
• Extensively involved in systems testing and CRP’s etc.
• Developed MD70 documents for the objects handled.

Environment: Oracle Applications 11i (AR), Reports, Oracle SQL developer, SQL*Plus, XML Publisher, PL/SQL Developer.

Oracle Applications Technical Consultant

Confidential, San Jose, CA

Responsibilities:

• Involved in the Supplier migration from legacy system into Accounts Payables using Supplier interface.
• Worked on Open AR Invoices migration from legacy system to AR using Auto Invoice Interface.
• Designed and documented the technical specifications documents (MD70) using the available functional specification (MD 50).
• Developed UNIX Shell script to transfer files across directories.
• Developed AP On holds Invoices report using XML Publisher report.
• Created custom Reports related to Oracle AR module to allow users to get the required invoice and customer information when required using XML Publisher.
• Developed Discoverer reports.
• Developed a program to attach the Purchase order report output to the Purchase order Form attachments, So that user can view the output in the Standard Form itself
• Created Event Alerts to trigger concurrent programs based upon the action.
• Involved in extensive Testing and documentation of the objects.
• Responsible for the development of GL related programs
• Code Migration activities across the CRP environments.
• Involved in client meetings which helped me understand the clients business.
• Worked on OAF customization (VO Extension) to add a date field.
• Developed XML Publisher Reports based on the Client Requirements on OM, AR, PO and AP.
• Worked on FNDLOAD to create LDT files for the migration of code from instance to instance.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Applications 12.1.3 - (AP, AR, PO, OM), Oracle 10g, XML/BI Publisher, Reports 10g, SQL*Loader, TOAD, Discoverer 10g

Oracle Applications Technical Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Implemented XML bursting to send the copy of the report output as an email attachment to the user.
• Worked on Custom API to add new Suppliers, Update (either Supplier site address or Supplier name), and Delete (Deactivate) Supplier.
• Developed UNIX Shell Scripts for moving and copying files from server to client and from client to server.
• Upgraded the existing 11i XML reports to R12.
• Upgraded existing Discoverer reports to R12.
• Developed UNIX Shell Script and created soft link to it for better and easy performance which takes parameters.
• Created custom Reports related to Oracle AR and OM modules using XML Publisher and PL/SQL procedures.
• Worked on Data migration for Customers and Item master using standard API’s.
• Created Control files, Sql loader scripts and validation programs.
• Created few Event and Periodic alerts upon the requirement.
• Worked on Form personalization on standard forms by creating special menus on which by clicking submits the concurrent program.
• Involved in extensive Testing and documentation of the objects.
• Worked on performance tuning of discoverer reports and XML Publisher reports.
• Involved in client meetings which helped me understand the clients business.
• Developed XML Publisher Reports based on the Client Requirements.
• Worked on FNDLOAD to create LDT files to migrate the code from instance to instance.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Application 11i/R12.1.3 (AP, AR, GL, PO, OM), Reports PL/SQL, SQL* Loader, Discoverer 10g/11g.

Oracle Applications Technical Consultant

Confidential

Responsibilities:

• Worked on Supplier data migration using Supplier interface.
• Worked on AP and AR open invoices migrations.
• Developed an OM interface program which creates the Sales order in the Oracle system based upon the Customer and Item data provided by the legacy system.
• Developed an Automated sales order creation program which covers the complete O2C cycle. Creating the sales order, does Pick release and ship confirm and creating invoice using Auto invoice program.
• Developed XML Publisher report which restricts for only 9 lines for each page.
• Implemented Barcode functionality in the Packing slip report
• Developed UNIX Shell Scripts for moving and copying files.
• Developed EFT payment format Program for Banks for Payables, which generates the Text Output in the pre-defined format and send it across to the bank server through FTP.
• Created few Event and Periodic alerts upon the requirement.
• Worked on Form personalization on standard forms.
• Involved in extensive Testing and documentation of the objects.
• Developed Oracle Form using Master detail relationship.
• Customized Reports, Flex fields and Registered with AOL.
• Involved in creating concurrent programs, Value sets, lookups and request sets.
• Involved in handling support tickets.
• Proactively used to assign tickets and work on them based upon the SLA.
• Created few SR’s and co-ordinated with Oracle support closely to get issue resolved.
• Worked on performance tuning of few concurrent programs using PL/SQL procedures.
• Involved in client meetings which helped me understand the clients business.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Apps 11.5.10, Manufacturing Modules OM, INV, PO, Oracle Financials AP, AR, GL, Order Management(OM), Inventory (INV), XML/BI publisher, Reports 6i, Oracle SQL Developer, Windows XP, Oracle 10g, SQL Loader,SQL Plus.