SUMMARY:

• Over 10 years of experience as Oracle Applications Functional Consultant in implementation, upgrade and customization of Oracle E - Business Suite Applications. This includes system study, design, development, post-implementation, maintenance and support of Oracle EBS.
• Experienced in end to end implementation/Support/Maintenance of Modules like Inventory, Costing, BOM, WIP, Order Management, Warehouse Management System, Shipping, Advance Pricing, Account Receivables, Oracle Purchasing and I-procurement.
• Experienced in implementation/Support of Advance supply chain Planning (ASCP) and APCC Advance Planning Command Center (APCC) and providing on the same to the Business users and offshore team members.
• Strong working knowledge of end to end Order to Cash (O2C) and Procure to pay (P2P) business cycles.
• 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 Methodologies.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions).
• Experienced in Worked as a team member with Business super users to train them on the MFG / Distribution flow in Oracle Applications and creating the setup for the same based on the input from the business.
• Experience on Advanced Pricing Setups to update the sales order for special discount, promotion and freight charges.
• Review and enhance forecasting processes and tools like Xelus, Demantra, Forecast Set and MDS for use with Oracle Global Advanced Supply Chain Planning (ASCP) module.
• Experienced working in different inventory planning methods i.e. Min-Max Planning, what-if Planning, and Forecasting.
• Experienced working on Manufacturing Execution System(MES).
• Customized the order reservation and released process with WMS.
• Experience in creating WMS DOCK, WMS Order selection, WMS Batch and release order for WMS job.
• Substantial experience in SQL, Oracle forms, reports, workflow and Open Interfaces.
• Experienced in preparing a customized report based on different client requirement like Item Cost at every element level, COGS (Cost of Goods Sold), COP (Cost of Production), IR-ISO, ASCP Demand/Supply Pegging, ASCP Inventory Outlook, ASCP Buy Material Outlook, ASCP Material Shortage reports etc.
• Hands on experience in Business Intelligent tools like Microsoft Business intelligence.
• Strong Knowledge in third-party tools like Xelus and ALM (For tracking Issue Tickets and migration of scripts in Production Environment).
• Strong knowledge of the Oracle Multi-org Business Structure and 3PL for warehouse and GTM interfaces.
• Highly capable in understanding business operations and translating them into functional requirements.
• Strong problem solving and analytical skills with immense ability to grasp new concepts and apply them.
• Excellent communication, analytical and presentation skills and experience in communicating at all levels.

TECHNICAL SKILLS:

ERP Software: Oracle 11i, R12 Oracle Inventory (INV), Order Management (OM) and Shipping, Advanced Pricing, Purchasing (PO), Costing, Account Payable (AP), Bills of Material(BOM), Work in Process(WIP), Warehouse Management System (WMS), Advanced Supply Chain Planning(ASCP) and Advance Planning Command Center

Database tool: TOAD, SQL

Project Software: Microsoft Office, Microsoft Visio, TOAD, DataLoader, Microsoft BI Publisher etc.

PROFESSIONAL EXPERIENCE:

Confidential, California

Production support for Order Fulfillment

Responsibilities:

• Provided Production Support to End-Users on Oracle Supply Chain Application modules, Oracle Order Management (OM), Advanced Pricing, 3PL (Manhattan WMS), Oracle Inventory (INV) and Bills of Material (BOM)
• Gather, Analyze requirements for enhancements and development.
• Prepare solution requirement documents (SRD) and test documents for enhancements/ Developments.
• Part of Implementation team to evaluate the current California oracle supply chain system and implement same to Oregon and Washington operating Units.

Environment: Order Management (OM), Advanced Pricing, Bills of Material (BOM), Shipping, Oracle Inventory (INV).

Confidential, Carlsbad, California

Oracle Applications WMS Functional Analyst

Responsibilities:

• Define packing station to separate staging area across individual packers and shippers.
• Validate the existing warehouse shipping process and recommended to use Reconfigure LPN functionality. This helps to re-use the same LPN multiple time for new deliveries.
• Prepared the document for how to do backorder partial lines from a sales order. This will save time for customer service by avoiding backorder full sales order, exclude partial lines, re-release and pick/pack.
• Working on RF Device to trigger the cycle count and backorder sales order line if the location doesn’t have the quantity available for picking.
• Defined the new replenishment process (Min-Max planning) to move the SKU’s from bulk area to Prime location to make them ready for shipping.
• Setup new discount modifier in advanced pricing to give the discount for specific customers for new products.
• Prepared the current Agile shipping process flow document for domestic shipping. This document will be the roadmap to replace Agile with standard Oracle shipping process.
• Check the BOM structure and works with Engineering team to validate the new models.

Environment: Oracle R12, Oracle Warehouse Management (WMS), Oracle Inventory (INV), Order Management (OM), Engineering (ECO), Bills of Material (BOM), Advanced Pricing, Shipping.

Confidential

Lead Oracle Applications WMS Functional Analyst

Responsibilities:

• Part of daily Production Support Including Modules Oracle Warehouse transactions, Order Management, Inventory and Shipping.
• Analyzed the current Sales Order release process and suggested the use of advanced wave planning to improve the current process.
• Used Modifiers, Qualifiers and Pricing Formula for Advanced Pricing.
• Involved in data conversion of Advanced Pricing with data-loader for Modifiers and qualifier setup for the Modifiers.
• Prepared documents for future and provided on Advance Wave Planning i.e. to create the wave for sales orders based on customer, item categories and shipping priority.
• Provided on how to Plan/Update the sales orders wave before releasing to the warehouse and Create/ Assign/Track the task to multiple users from wave dashboard.
• Provided on Packing workbench for outbound functionality. This helps to split LPN, create master LPN, print package and shipping label.
• Update the current replenish move order and sales order pick rule from LIFO to FIFO by changing the profile and picking rules.
• Involved in creation of new report to check the material status in staged sub Inventory and used to transfer the unreserved/unpacked quantity to other subinventories.
• Worked with Oracle by creating Oracle SR to fix the application bug for issues related to Order management, Drop shipment Process, Shipping and Push replenishment.

Environment: Oracle R12, Oracle Warehouse Management (WMS), Oracle Inventory (INV), Order Management (OM), Advanced Pricing, Shipping.