SUMMARY

• Over 9 years of IT work experience as Oracle Apps Technical Developer using Oracle Applications 11i and R12.
• Experienced in developing and enhancing OAF pages using Oracle JDeveloper.
• Worked on Oracle Application Framework (OAF), which includes customization and personalization
• Experience as a Techno - Functional consultant/Architect in Oracle EBS with major focus on Financial & SCM modules, Oracle Process Manufacturing (OPM), Order Management (OM), Inventory (INV), Oracle Pricing (QP), General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), and Procure to Pay (P2P) cycle, Order to Cash Cycles (O2C).
• Worked on Form Development and Customization using Custom.pll and Forms Personalization.
• Good Support, Development and up gradation experience.
• Extensive experience in RICEW components, TAR support, UNIX, Oracle SQL/PLSQL, Workflow, Forms and Reports 6i/10g and SQL Loader, Project assignments include Implementation, upgrade, conversion and support of Oracle Apps systems.
• Extensive experience in creating Discoverer Reports/ XML Publisher(BI Publisher) reports and using various templates to publish the reports as per user requirements
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development
• Having the good experience in all the Conversion/Interfacing activities using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Involved in designing the process flow for the legacy systems and creating the bridges between the legacy systems to oracle applications.
• Designed and developed the release process for the objects migration using the various tools and created the centralized documentation.
• Very strong experience in understanding the business, requirements, GAP analysis & Mapping and led the POC for several complex business processes and Data Integrations/CEMLI/RICEW/BI.

TECHNICAL SKILLS

Technologies: SQL, PL/SQL, Forms 6i/10g, Reports 6i/10g, XML publisher, Workflows

Functional Expertise: Order Management, Oracle Process Manufacturing Inventory, Advanced Pricing, Discrete Inventory, Account Receivable, Account Payables.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Development of POS Sales order Import, pricing import, OPM recipe, routing, validity rules and formula import programs using APIs.
• Developed Custom OAF Pages for the Invoice inquiry
• Worked Developing outbound interface such as Inventory extract programs, purchasing and sales extracts as part of Global supply chain extract.
• Involved in developing 3PL interfaces (Shipping execution, shipment confirmation and Advance shipment notice and Receipt creation..etc.) as part of 3rd party to logistics interfaces,
• Worked on UNIX scripts and commands at the time of installation of objects.
• Worked as SCM consultant on trouble-shooting of various support issues encountered during UAT.
• Prepared Unit Test Case document for all objects.
• Prepared MD-70 and MD-120 for the objects developed.
• Worked on XML Reports, SQL reports.
• Interact with the onsite Team on offshore based development, issue resolutions etc. on daily basis.
• Customized the below reports in Order Management using the BI/XML Publisher report
• Sales Order Acknowledgement report
• Bill of Lading
• Pick Selection List Generation
• Pick Slip Report
• Mismatched Item Densities report
• Shipping Execution reports
• Batch card Ticket Report
• Created the Shell Scripts to invoke mailer notifications for the standard/custom program for shipping documents and other custom reports.
• Created change management custom workflow process for new change request sand approvals.
• Designed and developed the new interface for Open Invoice Import program (AP), Extremal/Internal banks interface from the Legacy system as part of R12 upgrade.
• Worked on form personalization and customizations in various forms such as Mismatched item densities in Item UOM conversion screen, credit hold checks in sales order screen, on hand quantity information check SO screen and formula holds in formula screen...etc. .
• Developed various new forms such as Material request creation and maintenance forms, Data collections screen for Technical parameters and item categories and Formula approval custom screens etc.
• Created formula explosion extraction program up to 6 levels.
• Customized the reports ie Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management in oracle rdf and xml publisher
• Involved in Performance tuning and explain plan to improve the performance by analyzing the trace file/tkprof.

Confidential

Responsibilities:

• Worked on Conversion objects from Oracle Apps 11i to R12 in OPM inventory and AR, AP
• Worked on Discoverer reports and Xml Publisher reports
• Worked on form personalization and customization
• Worked on Interfaces and data conversions.
• Worked on various objects in Migration 11i to R12

Confidential

Technical Support consultant

Responsibilities:

• Support to the client during UAT and deployment in DEV and PROD instances.
• Resolved Issues related to iExpense report creation and approval process, iProcurement, requisition creation & requisition approval related issues.
• Worked on purchase order creation and approval workflow issues.(such as Invalid distribution accounts, invalid department number, issues with user name having more than 30 characters)
• Involved during the testing of the reports with the functional team.
• Technical Documentation Preparations (MD.070), Unit Test Plans and Installation Documents (MD120)
• Worked with Payables accounting process and resolve the issues for invoices stuck in interface tables of service contracts and Order Management.
• Worked with OTL, access and environment related issues where time sheet transactions are struck in interface tables which are not imported to project Accounting. Worked on Interface issues and cleared the data which are in interface tables in AR, AP, GL and from service contracts.
• Worked with oracle support and raised various SR's and CR's to handle various patch and bug related issues.
• Involved in managing the tools GCN, Bugster, CM tool etc.,

Confidential

Technical Consultant

Responsibilities:

• Creating new reports for Finance and HRMS Modules as per client requirements using XML publisher and report builder.
• Developed inbound and Outbound interfaces such as AP Invoice Import, sales and Inventory extract programs
• Preparing the test cases and preparing the final review for the objects.
• Involved in preparing the Delivery package for all the objects.
• Creating the LDT scripts for the concurrent programs and request groups and preparing Delivery package for all the objects.
• Developed New Reports in PO and AP and customization of the standard are reports.
• Involved in the Documentation (Preparing MD070, MD120, Creating the Scripts).
• Involved in preparing the MLS Reports in PO, GL using XML Publisher.
• Preparing the Lookup values, Parameters and registering the reports.
• Involved in Preparing the Packages, Procedures, and Functions to implement MLS Concept through backend.
• Preparing the KM Assets for organizational review based on the Project.
• Developed Inbound Interfaces for Oracle Receivables, Oracle Payables and Oracle General Ledger based on requirements submitted by the client.

Confidential

Technical consultant

Responsibilities:

• Development of RICE components as per the client requirement including End to End Testing.
• Development of Technical Unit Test cases for the Objects.
• Create Delivery Bundles for different objects
• Developed MD 70 CV 60, TE20, and MD 120 As per Client requirement.
• Involved in Customization of the existing and developing the new reports sql and Oracle D2K in Purchasing.
• Involved in Developing the interface in CE, Bank Statement Import & Auto Reconciliation Interface.
• Involved in Developing the Supplier Conversion from the Legacy database i.e 11.0.3 to 11.5.10.
• Preparing the MD70, MD120 documentation and preparing the FUT’s, good perspective on converting the functional specifications into technical design and development using SQL, PL/SQL and Developer 6i.
• Preparing the CV 60 documentation and the CV70 for the test cases.
• Application System Administration activities like application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs and printers
• Created SQL*Loader control programs and PL/SQL validation scripts.
• Worked on Multi Org Tables.
• Review the code and test the functionality of the applications.
• Rectifying the errors of inbound and out bound interfaces and resolving them