PROFESSIONAL SUMMARY:

• Having 9+ years of experience in the Information Technology industry with expertise in design, analysis, development, testing, and implementation of Oracle EBS applications 11i / R12 versions.
• Proficient in Developing, Customizing and Implementation of Oracle Application Modules (Accounts Payables (AP), Account Receivable (AR), Oracle Purchasing (PO), Oracle Inventory (INV), General Ledger (GL), Bill of Materials (BOM), Work in Process (WIP), Order Management (OM), Quoting, ASCP, Oracle Projects (PA), TCA.
• Extensive Experience in Oracle Business flow in Order to Cash ( O2C ) and Procure to Pay ( P2P )
• Prepared MD70’s, MD120’s and other Technical documents during various phases of Implementation and Support activities.
• Extensively worked on CEMLI/ RICE components like Reports, Forms, Interfaces, Conversions, Customizations, Localization, Extensions and Workflows as per client requirements.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts, Alerts and other database objects using SQL and PL/SQL.
• Worked Extensively in creating and customizing various Reports for Oracle Applications
• Have good knowledge and experience using Oracle Application Framework (OAF).
• Worked Extensively on BI Publisher (XML Publisher) reports.
• P roficiency experience in customizing standard Oracle Forms with the use of custom.pll and Form Personalization.
• Expertise in bug fixing and interacting with oracle support , and experience in designing and developing inbound and outbound interfaces for Oracle Applications
• Excellent interpersonal skills and an innate ability to provide motivation, and open to new and innovative ideas for best possible solutions.
• Capacity of work - Meeting Dead lines.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i, R12

EBusiness suite Modules: PO, AP, AR, INV, GL, PA, OM, BOM, WIP, ASCP, SYSADMIN

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g

Operating Systems: Windows XP/2000/NT, Unix, Linux

Programming Languages: SQL, PL/SQL, Java

Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, SQL*Plus and SQL*Loader, JDeveloper, Oracle Workflow Builder, TOAD, XML Publisher, KINTANA, PVCS

Documentation: AIM Documentation (MD50, MD70, MD120,CV60,CV40)

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Oracle Apps Technical consultant.

• Customized Project Budget Approval workflow to follow Confidential DOA for approvals and include attachments.
• Developed check printing program for Confidential and RBC banks.
• Developed Custom AP Aging Report using BI Publisher.
• Developed custom AR Invoice Print Report using BI Publisher and sending documents to customers using XML bursting process.
• Customized the labor costing extension program to calculate the labor cost if rate is not available for the employee.
• Developed a conversion program to upload Suppliers, Supplier Sites and Supplier Contacts into EBS.
• Developed an interface to upload AP Invoices.
• Developed an interface to upload open Purchase Orders.
• Developed a custom program to import expense invoices coming from Concur.
• Customization of AP Invoice Approval Workflow to follow Confidential DOA for approvals and include attachments for PO matching invoices.
• Customized Standard Reports as per client requirements

Environment: Oracle Applications EBS R12.2.4 (AP, PO, PA, AR, GL), Oracle 11g, SQL, PL/SQL, SqlDeveloper, Workflow Builder, BI Publisher.

Confidential, Sunnyvale, CA

Oracle Apps Technical Consultant.

• Developed a custom package to track Gcard updates based on the data received from CITI bank and send email updates to the card holder.
• Developed an OAF page to track the headcount managers cost center wise.
• Integrated third party software Viewpost with Oracle Applications for importing payables invoices and exporting payments to Viewpost using outbound interface.
• Developed a conversion program to import Open Purchase orders into EBS.
• Provided efficient and quick Root cause analysis for High priority Issues.
• Involved in preparing Test plan and Test cases for Unit testing.
• Developed stored procedures and packages and scripts for database Objects like Tables, Grants, Synonym, Views, Indexes, Packages.
• Providing Support during Migration of code to the production environment.
• Developed new enhancements starting from gathering requirements, writing MD70 and assisting users in UAT.

Environment: Oracle Applications EBS 11i (AP, PO, INV), Oracle 10g, SQL, PL/SQL, JDeveloper, SqlDeveloper

Confidential, Cincinnati, OH

Oracle Apps Technical Consultant.

• Developed programs which will create and update the work orders and creating reservations against the items and sales orders.
• Modified the custom hook to create internal requisitions for the customer orders placed at the distribution centers in ASCP instance.
• Did form personalization on User creation form and ASCP work bench.
• Developed interface for uploading BOM and Routings.
• Involved in developing new reports and customizing standard reports like AP invoice print report, Purchase order detail report, Sales Order Acknowledgement.
• Worked with Oracle on demand team to get the patches for the bugs raised.
• Provided efficient and quick Root cause analysis for High priority Issues.
• Developed new enhancements starting from gathering requirements, writing MD70 and assisting users in UAT.
• Developed stored procedures and packages and scripts for database Objects like Tables, Grants, Synonym, Views, Indexes, Packages.
• Providing Support during Migration of code to the production environment.

Environment: Oracle Applications EBS R12.1.2 (PO, AP, INV, BOM, WIP, OM, ASCP), Oracle 10g, SQL, PL/SQL, BI Publisher, Toad

Confidential, Sunnyvale, CA

Oracle Apps Technical Consultant.

• Involved in development of integration (QTOP) which converts the R12 Quote to 11i Sales Order.
• Involved in developing custom wrapper APIs and Biz Events for integrating Order / Quote Status between R12 and 11i.
• Customized custom pll to add mandatory validations at Order Header prior to progressing the order further.
• Customized custom pll to make changes to order status to make to sync with SFDC portal.
• Involved in developing various interfaces like Item Conversion, Open Purchase Orders import, Pricelist Conversion which are used for interfacing the master data between 11i and R12
• Involved in preparing Test plan and Test cases for Unit testing.
• Involved in Bug fixing during System Integration Testing (SIT).
• Migrated User, Responsibilities, Concurrent Programs using FND LOAD.
• Post Production support after migration of code to production environment.

Environment: Oracle Applications EBS 11.5.10.2 / R12 (AP, INV, PO, PA, OM, QP), Oracle 10g, SQL, PL/SQL, SQL* Loader, SQL Developer, Toad

Confidential

Oracle Apps Technical Consultant.

• Developing and Customizing Oracle reports in AP, PO, AR, GL and INV using XML Publisher, Reports Builder and PL SQL.
• Upload the data from legacy system into Oracle base tables using procedures, Packages and Standard APIs.
• Developed Procedures, functions, packages and triggers on conditional requirements.
• Suppliers and Customers master data migration.
• Migration of open purchase orders.
• Raising SRs with Oracle, following up with them to a logical closure.
• Providing Post-Production Support.
• Participating in the analysis and design of various reports using Reports 6i, Discoverer, and XML Publishers.
• Participated in the preparation of technical specifications by understanding the requirements from functional.
• Responsible for Design documentation
• Participated in testing in all the phases such as development, testing, and SIT
• Interact with users and design the process flows.
• Involved in Functional/Technical Requirements Analysis, Clarifications, Design, Development and Unit Testing phases.
• Follow up with Users, Oracle Support and Testing team and made sure that process is working as expected.
• Involved in MD70 and User manual documents preparation.

Environment: Oracle Applications EBS R12.0.4 (INV, PO, AP, AR, GL), Oracle 10g, UNIX, XML Publisher, Discoverer, SQL, PL/SQL, Developer 9i, SQL* Loader, SQL Developer, Toad

Confidential

Oracle Apps Technical Consultant.

• Developed several reports based on customer requirements including:
• Sales Order Report as per the client’s custom layout which also segregates export and domestic orders.
• Report for Proforma Invoice for payment.
• Report for Order Acceptance (Domestic, Export).
• Excise Invoice Report
• Interface to Upload Routings.
• Responsible for data migrations Suppliers master data, etc.
• Participated in the preparation of technical specifications by understanding the requirements from functional.
• Responsible for Design documentation
• Developed Procedures, functions and packages on conditional requirements.
• Participating in customization and development of reports as per requirements
• Participated in testing in all the phases such as development, testing, and SIT
• Involved in registering Interfaces and Reports, development and defining of value sets.

Environment: Oracle Applications EBS R12.0.4 (OM, PO, BOM, AP), Oracle 10g, SQL, PL/SQL, Developer 9i, SQL* Loader, SQL Developer, Toad

Confidential

Oracle Apps Technical Consultant.

• Developed several reports based on customer requirements. Some of them included are
• Pending Orders Report having LD (Late Delivery) clause in a given period.
• Report containing details of Supplementary Invoices in a given period (when retention payments are done).
• Report containing details of Invoices which contain VAT between a given period.
• Production schedule report for a specified period for given schedule designator.
• Goods Inward Register report for OSP items.
• Material return note when the material is returned back to supplier.
• Check Printing
• Interface to upload Items.
• Participating in customization and development of reports as per requirements
• Created deliverables such as MD70 and MD120 pertaining to all developments
• Involved in registering Interfaces and Reports.
• Involved in development and defining of value sets.

Environment: Oracle Applications EBS 11.5.10.2 (OM, AR, WIP, PO, AP, INV), Oracle 9i, SQL, PL/SQL, Developer 6i, XML Publisher, SQL* Loader, SQL Developer, Toad

Confidential

Oracle Apps Technical Consultant

• Involved in development of several Reports and Interfaces.
• Involved in development and defining of value sets.
• Participated in the registration of DFFs, creating users, responsibilities, and assigning responsibilities to users
• Participated in defining new menus and assigning them to responsibilities and in setting the printers at application level.
• Developed SQL queries according to the client requirements
• Participated in the preparation of technical specifications by understanding the requirements from functional.
• Created deliverables such as MD70 and MD120 pertaining to all developments.

Environment: Oracle Applications EBS 11.5.10 (OM, INV, AP, AR), Oracle 8i, SQL, PL/SQL, Developer 6i, SQL Developer, Toad

Confidential

Oracle Apps Technical Consultant

• Developed several reports based on customer requirements. Some of them included are
• Report on purchase order which has the details of purchase order along with the supplier details printed on a preprinted purchase order form.
• Developed a Delivery Challan Report which contains the vehicle number and details of the items of that delivery.
• Customized a stock ledger report which shows the opening balance/closing balances and the transaction details between them.
• Developed a report for material that has been rejected and sent back to the supplier with respect to the purchase order. The report was taken on a preprinted stationary material.
• Developed a report which creates returnable receipt memo of the items which are brought to the client for processing and returned back to the party.
• Participated in the preparation of technical specifications by understanding the requirements from functional.
• Defining Concurrent Programs, Executables.
• Involved in development and defining of value sets.
• Participated in the registration of DFFs, creating users, responsibilities, and assigning responsibilities to users
• Participated in defining new menus and assigning them to responsibilities.

Environment: Oracle Applications EBS 11.5.10 (PO, INV, AP, AOL), Oracle 8i, SQL, PL/SQL, Developer 6i, SQL* Loader, SQL Developer, Toad