Sr Oracle Applications Scm Functional Lead Resume
Tulsa, OklahomA
PROFESSIONAL SUMMARY:
- Around 10.10 years of total work experience of which 9.3 years of IT experience as Oracle EBS Functional Consultant in supply chain Management and ERP systems, which includes ERP support and implementations (Oracle Applications e - Business Suite Supply Chain Management modules), focusing on analyzing business requirements, testing, implementation and post production projects in Oracle Applications R12, and 11i in SCM an VCP(Value Chain Planning) module.
- Hands on functional expertise in various modules with primary focus on Discrete Manufacturing - Distribution and Supply Chain Management (SCM) modules which include Inventory (INV), Order Management (OM), Advanced Supply Chain Planning (ASCP), Work In Process (WIP), Purchasing (PO) and Bills of Material (BOM), APCC (Advanced Planning Command Control)
- Expert in OBIEE-Noetix reports, real time reporting development.
- Expert in Noetix Views, pertaining to Supply ChainViews and Financial Views.
- Expert in p2p (Procure to Pay) cycle.
- Implemented VMI (Vendor Managed Inventory) solution.
- Expert in o2C (Order to Cash) cycle.
- Expert in OSP (Outside Processing).
- Implemented Drop-Shipment and Back-to-Back solution.
- Expert in Replenishment (Min-Max Planning replenishment).
- Expert in Forecast to build process.
- Expertise in Oracle Inventory, Order Management, Purchasing, Payables, WMS, Advanced Supply Chain Planning (ASCP), Bill of Materials,Collaborative Planning and Work in Process
- Expertise in performing gap analysis, business requirements gathering, business requirements mapping, documentation and testing of Manufacturing and Distribution / Supply Chain modules.
- Excellent understanding of cross-functional dynamics of Supply Chain (processes such as picking, receiving, packing, handling returns, cycle counting, etc.) and Logistics gained through working experience.
- Expert in understanding of S & OP (Sales and Operations Planning)
- Expertise in business process analysis, requirement analysis (AS-IS) system, (TO-BE) mapping, Integration testing, UAT, system configuration, master data loading, regression testing, Go-live support and production support.
- Define and specify the implementation of standards, industry best practices, methods and procedures for inspecting, testing and evaluating application development.
- Excellent problem solving, analytical, interpersonal & leadership skills
- Excellent Communication, conflict resolving and people management skills.
TECHNICAL SKILLS:
Primary Skills: Oracle Applications ERP - 11iand R12.2 SCM /VCP modules
Operating Systems: Windows-7/8
Languages: SQL,PL/SQL
Development Tools: TOAD, Oracle SQL Developer
Databases: Oracle 11g
Documentation: QA tools
MSOffice: HP Quality Control (HPQC)
Version Control: Reporting Tool
QueSTAT: OBIEE - NOETIX Views
PROFESSIONAL EXPERIENCE:
Confidential, Tulsa, Oklahoma
Sr Oracle Applications SCM Functional Lead
Responsibilities:- Enable the Lot Control functionality for 1800 existing items at ONEGas.
- Modify the organization parameter setup to enable Lot generation.
- Modify the item attribute to enable Lot Control.
- Create a Template for items which are supposed to be enabled for Lot transactions.
- Modify Lot Transaction Register XML report to capture the Vendor Lot number.
- Modify Pick Slip Report (XML) report to capture the Vendor Lot number.
- Modify the Material workbench to display Lot number and Supplier Lot number.
- Modify the Lot Entry form to enable the Supplier Lot Number field mandatory.
- Create a New Attachment Category for TVC project in Oracle EBS anddevelop interface between EBS and ECM application.
- Redesign the Interface between EBS and Maximo to facilitate the TVC project.
- Assist in Inventory Period Close activity which involved clearing Unprocessed Shipment Transactions, Transactions stuck in Open Interface.
Confidential, Boca Raton, Florida
Sr Oracle Applications SCM Functional Consultant
Responsibilities:- Implemented Vendor Managed Inventory (VMI) process solution involving Oracle Inventory, Oracle Purchasing, Oracle Payables and Oracle WMS module which saved around 50 million USD dollars in transportation cost.
- Played a lead role in R-12 Upgrade project, delivered the project on time and without any issue, responsibility included developing the test case, test scripts for Oracle Inventory, PO, Order Management and Oracle WMS modules and regression testing of all critical business process pertaining to Supply Chain, logging defects and resolving the defects.
- Implemented Interface between Oracle Shipping and Kewill, 3PL logistics vendor.
- Implemented Interface between Oracle Order Management, Oracle Inventory, Oracle Purchasing and QGistix system, Refurbish and Reverse Logistics vendor.
- Played a lead role in deploying the OBIEE/Noetix for reporting requirement for Supply Chain operations in replacing the Discoverer tool.
- I played a resident SME for OBIEE/Noetix.
- I played a resident SME for VCP (ASCP, IO and APCC) and Supply Chain modules like INV, PO, OM and WMS.
- Assist in Inventory Period Close activity which involved clearing Unprocessed Shipment Transactions, Transactions stuck in Open Interface.
Confidential, Pittsburgh, PA
Sr Oracle Applications SCM Functional Consultant
Responsibilities:- Create and update functional design documents, BR100 and user training material.
- Dealt with stuck and pending transactions such as requisitions, and purchase orders at different stages of the business process
- Administered the business process and the different transactions through workflow and suggested modifications in workflow.
- Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies across different plants.
- Studied the existing business process & conducted meetings on client business overview.
- Process Mapping: Developed the client specific Process Analysis Questionnaires
- Developed a number of personalizationson the INV forms in order to meet the business requirements.
- Performed the functional setup and Documents setups for Inventory INV.
- Configured the modules for client’s specific process requirements. Performed the functional testing for various scenarios
- Provided support on purchasing issues like MO’s stuck in workflows.
- Setup Subinventory, Stock locators and Item templates.
- Assist in Inventory Period Close activity.
- Requirement gathering and handling enhancement requirements.
Confidential
Oracle Application SCM Functional Consultant
Responsibilities:- Assist the configuration team in creating and executing system test scripts and system integration test scripts for ASCP and IO module during UAT and SIT phase.
- Prepared test scripts and conducted unit and integration testing
- Involved in configuration of Production system.
- Prepared training documents for the users for future reference
- Assisted in post-production go-live support.
Confidential
Oracle Application SCM Functional Consultant
Responsibilities:- Setup sub-inventory, Stock locators, Item templates, Picking Rules, and Shipping Networks.
- Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies across different plants.
- Developed custom reports like Daily Inventory Stock and Asset Summary report by coordinating with technical team.
- Developed a number of personalizationon the Inventory forms in order to meet the business requirements.
- Document user requirements and subsequent process flows (using MS Visio)
- Perform Oracle Inventory setup- customer item, cross reference and UOM
- Assisted in integrating ASCP module to Purchasing module, also developed test scripts for the same.
- Create test user scripts for INV, EAM and ASCP modules
Confidential
Oracle Application SCM Functional Consultant
Responsibilities:- Performed the functional Unit Testing, Integration testing and Performance Testing of SCM and Planning system.
- Involved in Pre-sales and getting the contract of SunPower Corporations.
- Review and scope new requirements, requests for change and problems for modules already implemented.
- Excellent coordination with offshore technical resource.
- Creating new responsibilities and defining the required system profile options.
- Enabling Key Flexfield and Descriptive Flexfield.
- Conducted comprehensive user training with super users and users on ASCP and WIP.
- Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
- Efficient Post-production support for the Business User’s in ASCP, Inventory, Order Management, Purchasing, and WIP
- Analyzed and resolved problems related to Drop Shipment and OSP business processes.
- Executed various test cases and developed test scripts and test plans for Oracle SCM and VCP modules.
- Enhancement of the Min Max planning solution at Confidential by combining the vendor management / consigned inventory process.
Confidential
Oracle Application SCM Functional Consultant
Responsibilities:- Day to day support of production issues in Order Management, Inventory and Purchasing module
- Month end support for close and reconciliation for Inventory (INV), Purchasing (PUR) and Order Management.
- Configuration and data setup of the Inventory module which included the setup of items, category set, category codes, item templates, Sub inventories, Locators, Departments, resources, standard operations, routings
- Modified PO approval workflow as per new requirement during Roll-out.
- Resolved issues related to drop shipment process in Order Management post 11.5.10.2 upgrade
- Work with end users to gather requirements on functionality enhancements in Order Management, Purchasing and Inventory modules
- Interact with the end users and demonstrate the changes in functionality in details
- Involve in unit testing and integration testing on various modules
- Testing the functionalities as per the change in requirements
- Prepare training materials with screen shots, exercises and presentations for critical end users
Confidential
Oracle Application SCM Functional Consultant
Responsibilities:- Support the User Base for day-to-day activities.
- Assist in Inventory Period Close Activity.
- Handled a most critical issue related to testing the performance of instances created in Oracle Installed Base (IB) after the items shipped from Order Management.
- Involved in preparing the test cases for Oracle Order Management, Oracle Inventory and Oracle Purchasing module.
Confidential
Jr. Engineer
Responsibilities:- Planning and Procurement of Materials and Components for X-Ray Generators, MR Bed, MR Coils
- Driving New Products / Parts through different milestones from Proto stage till Mass Production
- Sourcing parts from the best available supplier in terms of Quality, Price and Delivery performance
- Ensuring timely reporting on value of item wise purchases and vendor wise purchases
- Extracting delivery score card for local and import supplies and analyzing the lead time, material cost etc.
- Controlling and improving the delivery performance of the vendor.
- Involved in GAAP Audit.
- Preparation of RFQ’s
Confidential
Graduate Apprentice Trainee
Responsibilities:- I worked as a graduate engineering intern.