We provide IT Staff Augmentation Services!

Oracle Applications Scm Lead Resume

SUMMARY

  • Oracle E - Business Suite R12 Supply Chain Certified Specialist: Oracle Inventory Management
  • Oracle E-Business Suite R12 Supply Chain Certified Specialist: Oracle Order Management
  • 17 years of IT experience involved in requirement analysis, design, development, testing, implementation, maintenance, production support
  • 13 years in Oracle Applications, worked on versions Oracle 10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10 and R12 on Supply Chain Management, Distribution, and Manufacturing modules for various projects
  • Mostly worked on Order to Cash, Procure to Pay and discreet Manufacturing business cycles
  • Expert in writing MD50 to design custom processes(interface/conversion programs) and also writing BR100 for system set up
  • Involved in Setup of various modules according to the requirement of the projects
  • Expert in solution design, Customization, Development, System/Acceptance Testing, and Post-Deployment Support.
  • Worked with process team and actively involved in requirements gathering, scripting as-is and to-be documents
  • Extensive knowledge on Oracle technical architecture, table structure, Oracle forms/reports, Unix scripts, AOL and PL/SQL
  • Worked as a team lead/Onsite coordinator for at least 3 projects where I was client facing and managed both clients and offshore simultaneously
  • Actively involved in conducting meetings with clients as well as other stakeholders of the projects, discussing present state of the projects and also future enhancements/opportunities

TECHNICAL SKILLS

Oracle Applications: PO, INV, OM, BOM, WIP, Oracle shipping, ASCP, AOL, iProcurement, Advanced Pricing

RDBMS: Oracle 8i /9i/10g/11g

Language/ Tools: PL/SQL, Workflow, Shell Script, Oracle Forms 4.5-11g, Reports 6i-10g, TOAD, Kintana, SQL*Loader, Appworx, AOL

Domain: Supply Chain Management, Distribution, manufacturing

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications SCM Lead

Environment: Oracle Applications R12.1.3 (OM, PO, INV, BOM, WIP, AP, AR, GL, FA)

Responsibilities:

  • Implementing and Setting up for INV, BOM, WIP, OM, Shipping, Costing, LCM and PO modules.
  • Working with users to formulate and document business requirements..
  • Actively participating in requirements gathering, CRPs and UAT
  • Developing MD50 Functional designs and getting sign off from Business stake holders.
  • Preparing the testing strategy and test scripts.
  • Preparing the BR 100 documents for Supply chain and manufacturing modules.
  • Also involved in data migration team and assisting them in different processes crossing SCM modules
  • Identifying and evaluating inefficiencies and recommending optimal business practices, and system functionalities
  • Conducting meetings with project team members and also with other stakeholders of the project including higher management
  • Conducting effective GAP assessments.
  • Actively assisting the developers for development of processes and preparing testing strategy for implementation.
  • Maintaining project tracker in every stages of project and sharing with project management in regular basis

Confidential

Oracle Applications SCM Lead

Environment: Oracle Applications R12.1.3 (ASCP, GOP, OM, PO, INV, WIP, OSFM, AP, AR, GL, BOM)

Responsibilities:

  • Worked on entire Supply Chain Management including Order management, manufacturing (BOM, WIP, Shop Floor Management and Quality), purchasing and VCP application includes ASCP and GOP.
  • Worked on data collection to pull data from Source and as well as legacy systems and DRP plans which generate demands for manufacturing plans for all Business units.
  • Also worked on various custom processes for firm/unfirm orders, converting OM demands to sales orders, forecasting, item substitution, create in-transit shipments, forecast consumption, safety stock update and operation network update
  • Here I worked as on-site coordinator and overseeing whole SCM and Manufacturing activities

Confidential

Oracle Applications OTC lead

Environment: Oracle Applications R12.1.3 (OM, INV, PO, AR, Shipping, BOM, WIP, ASCP, iStore, Quoting), Windows XP

Responsibilities:

  • Responsible for ongoing functional support on the OM and SCM modules
  • Very closely working with entire offshore team on daily basis
  • Extensive user interaction for understanding and resolving production issues
  • Conducting and attending meetings with business users to discuss current projects and also future enhancements
  • Also provide training to users in the execution of Oracle transactions, preparing training documentation and Test Scripts
  • Prepared MD50 for custom processes in order management and pricing modules
  • Actively involved in setting up new processes and enhancements
  • Worked on refreshing models in Oracle configurator, custom inter-company drop-ship transactions and custom inter-company holds, consolidated invoice billing, Oracle bidding and quoting, advanced pricing as well as interaction between iStore and order management
  • Raised Service Requests with Oracle to resolve critical issues

Confidential

Oracle Applications Manufacturing Functional Consultant

Environment: Oracle 11.5.10 BOM, WIP, INV, Costing, Quality

Responsibilities:

  • Responsible for ongoing functional support on the Inventory, BOM & WIP, Costing, OM modules
  • Lead an offshore team to complete the execution of the RICEW objects.
  • Developed MD50 to roll up physical attributes of option choices to the configured items of existing sales orders and also for customized Archive and Purge process of Inventory transactions
  • Analyzed and Configured Setups in Inventory, OM, BOM and WIP modules and making use of them in interfaces design and development.
  • Worked extensively on WIP Backflush and Routing issues
  • Setup item attribute controls, item templates and analyzed the need for sub inventories and setup shipping networks for inter-org transfer.
  • Performed Form Personalization on Move Transaction screen to in corporate scrap account functionality
  • Conversion activities to load the Routings/Bills of Materials utilizing the Routing API and the Bills of Material API.
  • Supported conversions like Items, Item Categories, BOM, Routing, Cost, Item transaction default & On-hand quantity.
  • Assist in month end tasks to the inventory team. Documented month end reconciliation tasks list to the team.

Confidential, Cincinnati OH

Oracle Development group

Environment: Oracle 11.5.10 (OM, Advance Pricing, Oracle Forms 6i and 11g, Reports 6i & 11g, Oracle Fusion Platform 11g, Toad, Shell Scripts

Responsibilities:

  • Interacting with Epsilon clients and providing them application, functional and technical support which includes taking initiative to improve processes, code base and application performance
  • Production support of complete LSP loyalty system which consists of standard Oracle 11i modules (OM, Advanced pricing, INV, shipping) including customizations of interface and conversion programs and reports
  • Participated in design discussions with business team and performed impact analysis
  • Extensively worked on AOL in setting up concurrent programs, creating key and descriptive flex fields, value sets etc. in both development and production environment
  • Developed interface programs to import pricelists, pricing formulas, custom prices pricing attributes and modifiers from legacy systems
  • Actively involved in conversion and interface projects from LSP to Grand Central including writing technical design documents and development of the processes
  • Worked with Oracle support for issues for the resolution of issues. Review and research patches and performed dependency analysis before applying them on environment
  • Complete production support process through Review, walkthrough of documents / programs as part of QA

Confidential

Oracle Supply Chain Techno-Functional Consultant

Environment: Oracle 11.5.9 and 11.5.10 (Order Management, Purchasing, Inventory, Warehouse Management), Oracle 9i and 10g, Windows XP

Responsibilities:

  • Working in both upgrade and implementation projects
  • Extensive involvement in upgrade project (from 11.5.9 to 11.5.10) through testing in upgrade instance as per test scripts and bug fixing and setting up the new system
  • Working in core development team of warehouse implementation, involved in development of custom interface and conversion programs in order management, shipping, inventory and warehouse management
  • Developed the entire custom Oracle Order management and shipping using shipping APIs to create deliveries, trips and firming deliveries
  • Created a custom Pick release program which does the pick release for all the trips associated with the ship method
  • Worked in iProcurement and modified workflows to change the approval routes of purchasing documents for a particular source
  • Working closely with functional team and wrote technical design documents of interface conversion programs
  • Worked on EDI Gateway to transfer Pyxis purchase orders to suppliers
  • Production support of Pyxis system handling mainly supply chain issues

Hire Now