EXPERIENCE SUMMARY:

• 16 years of work experience in which 14 years into IT, as an ERP Consultant in implementing diverse ERP applications like Oracle Applications e - Business Suite.
• Around 7 Implementations experience in Oracle R12 in which 3 implementations are into Oracle Process Manufacturing (OPM) Modules and 3 Implementations are into Procure to Pay including Purchasing, iProcurement, AME, iSupplier and Sourcing and has Strong Implementation experience in Sub Ledger Accounting.
• Responsible for implementations of R12 OPM Modules and ASCP utilizing the Oracle Application Implementation Methodology (AIM).
• Has strong functional experience in Oracle financial modules in P2P, Purchasing (PO), Payables (AP), and iProcurement coupled with the critical knowledge of the integration between finance and other modules.
• Vast experience in leading fit/gap analysis, Solution design, configuration, requirements gathering, running CRPs, driving testing and troubleshooting issues and preparing User Guides.
• Experienced in Oracle Approvals Management Engine (AME) (11i and R12) Implementation.

ERP SKILLS:

Oracle Applications 11i, R12 and Fusion Procurement and Fusion Manufacturing.

PROJECT EXPERIENCE:

Confidential

OPM Consultant

Responsibilities:

• Given Solution to Cycle Count by Stock Locator and Implemented.
• Worked on Custom Cycle Count Listing Report by Stock Locator and Cycle Count Details Report
• Worked on Product Produced and Consumed Custom Report
• Working on Building an interface between PI System (Production Information) and OPM Batches.
• Re-Designing the SLAs and Derivation Rules.
• Working as a Solution Architect for upcoming Re-Implementation of Oracle R12.

Confidential

Oracle Post Production Support & Oracle Quality Implementation

Responsibilities:

• Working on Oracle Quality Module to implement Nonconformance and Corrective actions for their Quality Operations.
• Re-designing the Oracle Quality Workflow to enable approvals in the Nonconformance and Corrective action cycle.
• Designing the Reports to match the business requirements to eliminate third party software interfaces.

Confidential, Lexington, MA

Implementation and Production Support

Responsibilities:

• Re-designing SLA Rules based on New COA structure to match Cubist’s Complex CMO (Contract Manufacturing Operations) across the Globe.
• OPM Costing Module Implementation for Lot Costing and Standard Costing.
• Implementing Outside Processing in OPM (New Feature Released by Oracle).

Confidential, PA

Post Production Support

Responsibilities:

• Troubleshoot issues with run time performance of Create Accounting Program (XLAACCPB)
• Worked on Improving Performance of Lot Cost Process Program (GMFRLC) by creating Multiple Indexes and Changing the Lot Cost Start Date in the Program.
• Worked on Preliminary Own Scrap Breakdown Report which shows Preliminary Own Scrap Breakdown loss for batches in summary mode in Excel format
• Working on OPM Sub Ledger Inventory Valuation Report, This report gives inventory value by inventory organization, subinventory, and item for a particular date displayed in a detail or summary form, this Report created using Oracle Reports Builder tool.
• Worked on Month End True Up Scrap Extension, this extension will: (A) receive and store true-up data, (B) extract and store OPM transaction level details, (C) complete and store calculations related to true-up, (D) create and store OPM batch adjustments, (E) Support Reports and Look-ups related to Month End True Up, (F) (Existing) Oracle OPM API to allow OPM Batch Adjustments to be loaded into OPM.

Confidential, GA,

Post Production Support

Responsibilities:

• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Developed Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.

Confidential, NY

Responsibilities:

• Led the implementation of OPM, includes, Inventory, Quality, Product Development, Production Execution, Costing and Sub Ledger Accounting (SLA) modules for Topps Company.
• Assist in development of use cases, GAP analysis and extension design through CRP1 for Inventory, Product Development and Production Execution Modules for Topps Candy Business.
• Responsible for all strategies related to production and costing. Participated in the strategy to integrate Oracle Process Manufacturing with the Financial and Agile applications.
• Assist client in the deployment of OPM Product Development, Production Execution, and Inventory.
• As a functional lead consultant setup the OPM System for the Following Business flow Cycles:
• Concept to Release
• Schedule to Produce
• Quality Issue to Resolution
• Sampling to Acceptance
• Product Costing to Inventory Valuation.
• Documented BR100’s for OPM modules. Conducted business workshops on OPM process functionality.

Confidential, TX

Responsibilities:

• Worked as SME in the purchase to pay cycle flow mapping to Confidential business.
• Providing solution for Procurement Operations for Projects using Procurement Modules Purchasing, iProcurement, iSupplier, AME
• Worked on Req/PO Account Generator Workflow Customization with Projects
• Configured AME for Requisition Approvals to match the Region specific Approvals requirement from Confidential to have both CAPEX and Inventory Purchases.
• Performed Month end closing procedures in PO, AP and GL. provided post production support by troubleshooting and resolving issues by analyzing transactions at the table level. Extensively used SQL to query tables for data.

Confidential, Manila City, Philippines

Responsibilities:

• Worked on Key Business Requirement “Cake By Design” and Provided “Make-to-Order” functionality to Process Special Orders for Cakes (Wedding Cakes & Birthday Cakes)
• Perform key users and end users ‘Basic First-cut training’ in OPM modules.
• Prepared a detailed costing procedure and extensively worked on SLA integration with the following business Flows Concept to Release, Schedule to Produce, Sampling to Acceptance, Inspect to Disposition, Quality Issue to Resolution, Costing to Valuation and Make to Order for Cake by Design (Special Orders)
• Manually release ASCP suggestions in Advanced Planning Scheduling (APS) and manually accept some, all, or none of the ASCP suggestions in OPM.
• Training end users with common processes involved in day-to-day business and Preparing standard operating procedures (SOP), Test scripts etc for processes involved in SCM modules.

Confidential, NJ

Responsibilities:

• Confidential ’s Quality Operations are integral to supply chain processes. The sampling and release of product will be facilitated through Confidential .
• Create notification to take sample of in-bound material receipts
• Change lot status in Confidential to reflect lot disposition, Manage lot status in inventory to reflect holds/release after investigation, Manage recall functionality within the plant warehouse management system.
• Provide visibility in Confidential to QO planned and in-process orders, Integrate material disposition decisions from core LIMS to the Confidential software.
• Preparing functional (MD050) and technical (MD070) design documents for customizations.

Confidential

Responsibilities:

• Configuring the setups for Inventory and Price Lists (Advanced Pricing)
• BR-100 documentation for Field Service module.
• MD-050 documentation for Reports

Confidential

Production Support

Responsibilities:

• Sole responsible for Post Implementation support for Confidential, PO and iProcurement modules.
• Analysis & resolution of various functional issues on a day-to-day basis including month end closing.
• Suggesting proper work around wherever required and recommended business need for the same.
• Creation of Inventory Organizations for business needs and testing the org’s with ‘Procure to Pay’ and ‘Order to Cash’ cycles.
• Gathering functional specifications from the business for developing custom reports and preparing MD 050 documents for change requests.

Confidential, Tencor, CA

Responsibilities:

• Led Offshore P2P team in user adoption of Oracle EBS and other enterprise systems and provide technical/ functional support and user training on all aspects of Oracle Financial System.
• Manage Oracle E-Business Suite including Ariba Purchase Orders, AP Invoices, iSupplier and Inventory transactions.
• Leading the offshore team for Procure to Pay (P2P) for Confidential -Tencor Application Delivery.
• Configured Test & Production Environments.
• Performed and documented fit/gap analysis for Confidential, PO.

Confidential

Responsibilities:

• System Study and detailed analysis of business requirements
• Liaison with Confidential Integration and Business Information Competency Centre teams to define integration and BI requirements respectively