SUMMARY:

• More than 9 years of experience in the field of Oracle Manufacturing, Advance Supply Chain Planning (ASCP) and Supply Chain Management (SCM) modules like Inventory, Bills of material (BOM), Work in Process (WIP), Order Management, Available to Promise(ATP), Shipping, Costing, Engineering(ECO), Purchasing and i - Procurement.
• Expert in phases of implementing the Oracle APS systems with EBS modules: Advanced Supply Chain Planning (ASCP), ATP, Min/Max Planning, Collaborative Planning (CP), Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Purchasing (PO), Costing (CST)and Order Management(OM).
• Experience in end-to-end full lifecycle implementations and handled projects involving Upgrade, Rollout and Support/ Maintenance of Oracle ASCP, Demantra, Manufacturing and Supply Chain Management Modules.
• Worked with Business super users to train them on ASCP and MFG / Distribution flow in Oracle Applications and creating the setup for the same based on the input from the business.
• Expertise in configuring and maintaining the latest modules vizASCP and Demand Planning/Demantraand maintaining a separate Advanced Planning and Scheduling (APS) instance and Oracle Express Server
• Review and enhance forecasting processes and tools for use with Oracle Global Advanced Supply Chain Planning (ASCP) module.
• Experience on working with Oracle SO, PL/SQL and Open Interfaces.
• Experience on Oracle ASCP Legacy collections using IHUB third party tool integrated the Data from People Soft ERP to ASCP.
• Strong working knowledge of Receipt to Issue cycle, Order to Cash (O2C) and Procure to pay (P2P) business cycles.
• Hands on experience in Business Intelligent tools like Discoverer reports.
• Knowledge in third party tools like KINAXIS, TRI-2(For migration of scripts in Production Environment) and EDICOM and their integration with Oracle.
• Strong knowledge of the Oracle Multi-org Business Structure.
• Experienced in preparing documentation based on deliverables that are used to assess the level of fit between the detailed business requirements and standard application functionality using AIM.
• Strong knowledge of Application Object Library (AOL), Trading Community Architecture (TCA) and knowledge of System Administrator activities.
• Highly capable in understanding business operations and translating them into functional requirements.

TECHNICAL SKILLS:

ERP Software: Oracle R12, Oracle 11i, Advanced Supply Chain Planning (ASCP), ATP, Inventory (INV),Bills of Material (BOM), Work in Process (WIP), Purchasing (PO), Demantra, Collaborative Planning(CP), Order Management (OM), Engineering(ECO),i-Procurement, Costing, Order to cash (O2C) and Procure to Pay (P2P) Life Cycle, EDICOM, MSCA,Telnet and IHUB.Business Intelligence Tools: Discoverer Report, Qlickview.

Databases/Database tool: Oracle,MY SQL Server, Microsoft Access, Visio, Oracle, TOAD, SQL Developer.

Project Software: Microsoft Project,Microsoft Visio, TOAD, SQL Loader

Languages: C,C++,Visual Basic, VB.net,ASP.net, PL/SQL and SQL.

Operating Systems: Linux,Unix,Windows Server 2003/2008,Windows NT/2000/XP/7

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Lead Oracle Application Manufacturing and ASCP Consultant

Responsibilities:

• Involved in Business requirements gathering for ASCP and Manufacturing Modules Inventory, BOM, WIP and Costing implementation, Configuration changes, Technical Specifications, and generating Test Scripts.
• Prepare Fit/Gap analysis document to analyze the level of fit between the business Requirement and Standard Oracle Application.
• Prepared Functional document (SRD), Setups (BR100) and Oracle Responsibilities (BR120). Create ASCP and Manufacturing User Manual for Users Training and end Users references
• Involved in Coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications i.e. Customized Make to Order Process (Daikin Customer Order Process).
• Involved in Conversion of Items, BOM’s and Routings, Analyzed and coordinated with business to correct the legacy Data before converting them in Oracle Base Tables.
• Involved in conducting CRP’s and UAT sessions with Business users to do testing for ASCP and Manufacturing Modules like Inventory, BOM, WIP, Engineering (ECO) and Costing.
• Involved in Conducting Systems Integration Testing with cross functional Teams i.e. O2C, Sourcing and Finance Team to test the complete End to End Process Flow.
• Work with cross functional team (Finance team) to test the complete end to Scrap Process cycle.
• Preformed All the ASCP and Manufacturing related setups in the oracle Application as per business Process.
• Worked on Identifying many Gaps, Oracle Bugs and Enhancements in Oracle Manufacturing and ASCP processes including Scheduling Demand/Supplies Pegging and Optimization engine.
• Setup Constraint EDD ASCP plans for Benshaw Organizations (USA and Canada).This functionality provide the demand/supply view for multiple inventory organizations in single ASCP plan.
• Prepared Functional Document for ATP and configured it the system ad tested end to end ATP flow.
• Involved in Creation of MD50 and coordination with Technical team to prepare customer specific Shop Traveler Report, Component Pick List report, Intranet Production Report etc.
• Worked with Oracle by creating Oracle SR’s to Fix standard Bug and provide resolution of Issues.
• Prepare Test cases for Manufacturing and ASCP Process to Test various business Scenarios like Forecast to Build, Customized Make to Order Process etc.
• Prepared Documents on how to Create Folders, User defined Queries on Planner Work Bench Search Exceptions and Supply demand for Items and Release Planned order from the Planners Work Bench.
• Involved in testing Mobile Application though TELNET to test Shop Floor Transaction like Move order, Scrap Process and Job Completion with serial and non-serial control assemblies.
• Involved in Post Go-Live production Support for ASCP and Manufacturing modules.
• Prepared SOP Document for the Manufacturing Process and end to end ASCP process Cycles for reference for Business Users.

Environment: Oracle ASCP 12.1.3.9Modules: Advanced Supply Chain Planning (ASCP), Inventory (INV), Available to Promise (ATP), Bills of Material (BOM), Work in Process (WIP), Engineering (ECO), Costing (CST), Mobile Supply Chain Application (MSCA), SQL and PL/SQL.