SUMMARY:

• 13 years of work experience in which 12 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 OPM SLA.
• 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), 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.
• Received Hands on access to pre-release version of Fusion Manufacturing participant with direct support from Fusion Development teams. Interacted with supply chain planning and requirements to support Oracle Fusion applications
• Experienced in Oracle Approvals Management Engine (AME) (11i and R12) Implementation.
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle Jdeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.

TECHNICAL SKILLS:

ERP Skills: Oracle Applications 11i and R12 and Fusion Procurement and Fusion Manufacturing.

Platforms: Windows, UNIX

Languages: PL/SQLOther Tools:HP QC, Oracle Reports Developer 10g. TOAD and SQL Developer

EXPERIENCE:

Confidential, Lexington, MA

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.

Confidential, PA

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.
• Working 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, Atlanta, GA

Responsibilities:

• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands.
• 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.
• Worked on Following SLA Custom Sources for generating the account Derivation Rules:
• SLA OPM Batch Close Cost Center Custom Source: This extension is a custom source SQL package is developed to retrieve the Cost Center of an OPM item for Batch Close transactions
• SLA OPM LCA Reason Custom Source: This extension is a custom source SQL package developed to derive custom accounting based on the reason code attached to a Lot Cost Adjustment

Confidential, TX

Responsibilities:

• Worked as SME in the purchase to pay cycle flow mapping to Patterson UTI 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 Patterson UTI 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 ’ 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. 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:

• Create notification to take sample of in-bound material receipts
• Change lot status in AMSS 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 AMSS to QO planned and in-process orders, Integrate material disposition decisions from core LIMS to the AMSS 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

Responsibilities:

• Sole responsible for Post Implementation support for INV, 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, CA

Responsibilities:

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

Confidential

Responsibilities:

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

Confidential

Responsibilities:

• Provided and prepared the following deliverables as part of the project:
• Future Design Document (BP.080) for OPM Product Development, OPM Formulator, OPM Costing and Distribution Modules.
• Application Setup Document (BR.100) for OPM Suite and Distribution Modules.
• Attended Exclusive in Oracle Application Modules ( ) - 5 Months
• Pharmaceuticals Industry Work Experience at AUROBINDO PHARMA as a Production executive and Procurement Executive and ERP Implementing Participant at various levels ( ) - 5 Years 3 Months