SUMMARY:

• Over 13 years of ERP experience with 10 years as Oracle applications functional consultant/solution architect with multiple Oracle functional modules (Rel 12.3, R12 and 11i) with 12 successful go lives.
• Over 10 years experience in Oracle Supply Chain Planning - Demantra, Inventory optimization (I/O), Strategic Network Optimization (SNO), Distribution Planning (DRP), Advanced Supply Chain planning (ASCP), Production Scheduling (PS), Collaborative Planning (CP), ASCP with EAM & Production Scheduler, Global Order Promising (GOP) and APCC (R12.1)
• Expertise in core manufacturing processes- forecast to plan, plan to replenish, design to release, standard costing to inventory valuation, schedule to build, demand to build, min max planning, Kanban Planning, Cycle counting to reconciliation, & replenishment planning, VMI Process, WMS driven WIP Picking, WMS driven receiving and shipping.
• Implemented Discrete Inventory, PLM, BOM, WIP, Engineering, Costing, Configurator, iProcurement, iSupplier, Oracle Quality, WMS, Spares Management, Asset Tracking & Installed Base
• Extensive supply chain experience in R12 environment with knowledge of Sub Ledger Accounting (SLA) set ups. Understanding of Cost Management Events - (Inventory, Purchasing, Receiving, Costing and WIP), and Create Accounting Program, Deferred Cogs and Revenue concepts.
• Extensive experience in Order management - Sales orders, Advanced Pricing, Order Import, Defaulting Rules, Scheduling, ATP, ATO/PTO, Price Lists, Multi Currency Conversions, Pricing Agreements, Multi-Org Setup, Modifiers, Pick Release, Shipping, WMS & Rules engine for shipping, WIP and receiving, Interface trip stop program, workflow background engine program, AR Auto Create Invoice program.
• Expertise in Order Management processes - Standard Order, RMA Return, Internal Order, Drop Ship, Order Import, Requisition Import processes, Intercompany ISO Invoicing process, OM workflows association to transaction types at header and line level.
• Extensive experience in Oracle Process Manufacturing (OPM 11i), Oracle Discrete Manufacturing (R12.3) and Oracle Flow Manufacturing (R12.3), Oracle Project Manufacturing (R12.3) and Oracle Configure to Order Manufacturing (CTO 12.3)
• Extensive experience in Oracle Process Manufacturing - Process Engineer, Formulator, OPM Inventory, OPM Process Planning, Production Supervisor, & OPM Quality
• Extensive experience in Purchasing: Supplier Master, Oracle Sourcing, PO’s, Requisitions, iProcurement, iSupplier, ASN/ASBN, Approval Hierarchies, RMA receipts, Drop Shipment logical receipt, Receipt Accounting,, ASL, Sourcing rules, Create Internal Order program, Purchase Release program, Define Lookup Codes Purchasing Services, & purchase order workflow technologies
• Expertise in purchasing processes-Requisitioning process, Standard Purchase order, Blanket Agreements, Contracts, min max driven requisition process, Receiving Process, Receiving transaction open interface (ROI) processes, ASN/ASBN processes using I-supplier portal, Oracle RFQ and sourcing solution.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Supply Chain Consultant

Responsibilities:

• Designed Inventory and procurement solution for Potash Corp in eAM Implementation
• Designed planning and replenishment solution for PotashCorp
• Designed eAM WIP auto allocation process for EAM work orders including one step and two step material allocation
• Designed eAM OSP process for shop floor work order for service procurement
• Designing oracle sourcing solution for client which includes RFIs, RFQs and Quotations to create BPA or Standard Purchase order

Confidential

Oracle GOP Consultant

Responsibilities:

• Designed preliminary GOP solution for ATO/Flow Manufacturing environment
• Configured ATO models BOMs, ATP rules and sourcing rules for resource and material multi-level ATP solution
• Designed option specific sourcing solution where GOP sourcing would only go to warehouses with correct component material availability
• Designed project allocated material solution for quick ship orders in order to prevent on hand allocation of quick ship inventory to other order types
• Set up OM defaulting rules and system parameters for GOP solution based on customer demand class
• Performed Fit/Gap analysis for Global Order Promising requirements

Confidential

VCP Solution Architect

Responsibilities:

• Designed global demand to build process for client, which included re-implementing Demantra DM, ASCP, CP, DPP, Purchasing and WMS Work in Process and Receiving.
• Collected client demand planning, supply planning, purchasing, receiving and WIP requirements, and conducted fit-gap analysis for complete supply chain.
• Designed product levels, customer levels, and org levels for demand management solution. The solution used both product category level aggregation as well as product family level aggregation which satisfied multiple client requirements.
• Designed worksheets to satisfy client reporting requirements. Fine tuned analytical engine to improve forecast accuracy, of baseline forecast, thereby eliminating need for manual overrides to baseline forecast
• Designed CP Customer VMI planning solution for big box retailers
• Developed innovative solution for data management and disaggregation at interface table level
• Designed DRP solution for client which included introducing inventory rebalancing functionality enabling material sharing capability across various manufacturing orgs in preferential order.
• Conducted pre-assessment exercise for client and identified distributed planning/purchasing/receiving/shipping/order management/demand planning related issues
• Designed supply chain solution for ASCP, Purchasing, I-Supplier, BOM, OM, WIP and Receiving WMS
• Automated purchasing and planning releases from ASCP/DPP workbench, including automating blanket purchase releases
• Demonstrated ATP/GOP functionality in ASCP and OM for Sales order schedule dates.
• Conducted pre-assessment exercise for client and identified distributed planning and purchasing related issues
• Designed preliminary planning and purchasing solution to address the planning and purchasing issues
• Demonstrated Planning to Purchasing automation solution using release from ASCP workbench and automatic blanket release document creation
• Demonstrated WIP OSP solution to client including purchase order creation and subsequent receiving and put away
• Recommended automating purchasing and planning releases from ASCP/DPP workbench, including automating blanket purchase releases
• Demonstrated ATP/GOP functionality in ASCP and OM for Sales order scheduling

Confidential

Oracle ASCP/PS Consultant

Responsibilities:

• Designed ASCP planning solution for 6 manufacturing sites and 2 distribution centres for plumbing line of business.
• Designed level loading capability for flow lines based on pre-defined production line daily production loads.
• Designed flow sequencing rules for level loaded line scheduling for flow lines.
• Designed Production Scheduler (PS) solution for 6 manufacturing sites including flow manufacturing orgs. The overall solution involved allowing level loading flow assemblies with capacity planning capability in flow manufacturing and discrete assemblies to be finite scheduled in production scheduler. PS plan for different manufacturing plants is driven off ASCP plan with each PS plan scheduling based on bottleneck resource planning.
• Created documents and provided hands on to end business users
• Designed ASCP driven material planning solution for project manufacturing-aerospace industry. Solution includes providing material sharing capability based on planning group for hard pegged items and borrow payback solution to satisfy project costing requirement.
• Designed R12.1.3 advanced scheduling for client using constrained plan with Detailed Scheduling functionality
• Demonstrated Production Scheduler 8.12.1 tools for project environment to client
• Implementing routing design for top level finished product for project manufacturing environment. The design is to support multi stages of the project in terms of fixed lead times and also ensuring item component MRP requirement at correct operation steps.
• Designed Inventory management planning - min max planning, replenishment count planning, cycle counting and kanban pull sequences using kanban plans to determine kanban card sizes.
• Designed WMS solution for receiving and WIP material picking and movement. Created multiple wms rules, strategies for wip and receiving. Solution included same project, same task rules, planning group rules, and custom hard pegged and soft pegged item picking rules.
• Designed WMS WIP to WIP opportunistic cross-docking rules for fulfills WO backorder demands for project work orders.

Confidential

Oracle Senior Supply Chain Functional Consultant

Responsibilities:

• Implemented WIP module using Discrete Workstation functionality to allow clients to capture actual labour hours
• Designed custom MD50 to provide actual clock in clock out functionality to shop floor in 11.5.10 environment
• Tested Discrete Workstation functionality to work with Oracle Quality Collection plan in order to capture move transactional data for WIP In process Inspection plans
• Implemented I/O, DRP, GOP (ATP) solution, ASCP and SNO and Demantra demand management
• Designed I/O Service level set functionality to drive safety stocking levels based on fulfillment lead time and service level targets for different customer class (Class A 95% 5 days, Class B 90% 8 days)
• Designed demand to build solution for client including Demantra, ASCP and discrete manufacturing modules
• I/O safety stock recommendations considered variability in demand, supplier lead time and transit lead time
• Configured Strategic Planner module and set up SNO plan and plan options and executed SCP Connector process to create SNO models automatically. Multiple scenarios of the model were executed for simulation and accepted scenario assignment sets published back to APS for optimized sourcing results to be further used for DRP
• Designed DRP solution for 4 distribution centres and 1 manufacturing org. This included load consolidation based on ship method utilization constraints with container patterning to internal orgs based on shipment dates.
• Designed DRP solution supporting inventory planning for different kind of item types (max, target and safety stock driven planning. Design also supported fair share allocation for different distribution centres, circular sourcing,
• Designed GOP solution based on APS planned output for the client considering supply consideration in a multi org environment where any of the warehouses can ship to the end customer
• Designed GOP solution for CTO environment where PTO Model is not ATP enabled but components are. The solution supported group ship date capability to allow a availability based on complete PTO Model supporting OM ship set functionality
• Designed auto create PO from planned order solution in planning based on blanket agreements at ASL level
• Designed contract manufacturing solution which included supplier capacity planning solution to provide ramp up and ramp down planning capability with days in advance functionality to support seasonality in the client business.

Confidential

Oracle Senior Supply Chain Functional Consultant

Responsibilities:

• Implemented Internal order process for the third party logistics centre for shipping to US customers
• Developed functional design document for EDI shipment and receipt of internal orders and Purchase orders using Receiving Open Interface (ROI), with third party logistics warehouse, leveraging Oracle’s receiving transaction processor seeded functionality
• Set up Direct Delivery, Standard, Inspection Receipt for different item types and supplier combinations
• Set up Intercompany Invoicing process for shipping from Canadian OU to US OU, with Intercompany receivable Invoice generation at selling OU and payable invoice at shipping OU at transfer price upon running of Create Intercompany AR Invoice
• Implemented Plan to replenish process using min max driven inventory replenishments
• Implemented Cycle Counting process driven off ABC compile based on inventory value criterion
• Designed transaction reconciliation process to troubleshoot pending and error transactions in interface tables
• Designed shipping WMS solution for the client for internal order shipments

Confidential

Oracle Senior OTC Consultant

Responsibilities:

• Supply Chain lead for order to Cash solution with 8 functional consultants and a business team of 15 people.
• Designed OTC solution for client which including implementing Order Management, Configurator, Shipping, and WMS modules
• Implemented Promotions and Discounting based advanced pricing to facilitate seasonal promotions
• Implemented oracle Asset Tracking solution for tracking of serialized finished goods from manufacturing to shipping
• Designed WMS shipping solution, which included creating WMS rules for picking and put away, container and license plate management using LPN, task creation and prioritisation.
• Created configuration models based on BOM PTO and ATO models, added configuration rules on top to allow guided selling ability to end level customer
• Implemented Production Scheduler solution in OPM environment. Led OPM and ASCP team from client side to develop the OPM/ASCP integration with Oracle Production Scheduler
• Implementation lead in EBS Integration involving 3 separate Oracle Apps - ASCP/OPM and PS/SNO
• Finalised initial design of PS Scheduler finite scheduling package for Teva Pharmaceuticals
• Mapped Teva’s scheduling business requirements with PS/OPM/ASCP functionality. Teva’s business needed alternate resource offloading capability based on load %, running simulation sets based on floating bottlenecks, firming OPM WIP batches within the scheduling horizon, allowing bottleneck resource firming for PD/validation batch runs. Most functional requirements were satisfied by using functionalities available in PS, ASCP or OPM Production Scheduler.
• High level design included using ASCP for mid range and long range planning, OPM for batch execution and PS Scheduler for short range batch scheduling only
• Created SNO models with multiple scenario for optimizing forecast based on single sourcing constraint
• SNO optimized model was then fed into ASCP manufacturing plan as demand schedule for execution

Confidential

Canadian Business lead

Responsibilities:

• Implemented ASCP constrained planning for multiple manufacturing sites Implemented ASCP constrained planning for multiple manufacturing sites under a nested supply chain planning environment. This entails pulling ODP demand schedule into market plan, using this plan output as a demand schedule into the manufacturing plans and generating a constrained manufacturing plan. (The objective of nested plan structure is to allow site level plan independence for all manufacturing units. Constrained plan at manufacturing level allows for resource level constrained planning.)
• Implemented OPM Manufacturing - This involved designing OPM item master, Discrete item master, recipes, routings, formulas & validity rules (Process Engineer, Formulator, OPM Inventory, OPM Process Planning, & Production Supervisor) to suit Teva’s generic pharmaceutical business environment.
• Teva’s business process for manufacturing supports different scenarios where single bulk lots feed multiple packaging lot sizes, as well as scenarios where multiple bulk lots feed single packaging lots called super lots. It also supports scenarios where there are dedicated lines for product families, with one to one link between bulk and packing lots. Oracle OPM and ASCP design supported different above scenarios.
• Designed detailed end to end “as is” and “to be” manufacturing process flows for Teva’s Canadian manufacturing site in discussion with business, which included process flows for dispensing, compounding, encapsulation, tablet coating, tabletting/slugging, tablet printing, and QC process flow with integration to LIMS system.
• Designed business processes for new product evolution from regulatory stage, to pilot batches, technical services, and validation batches to build towards a successful product launch. The complete business process included planning, manufacturing batch approval from pilot to validation stage, with ERES functionality for multiple recipe/recipe validity rule based approval. This also included complete OPM Quality functionality for WIP and yielded lots based on test specs and sampling plans.
• This project involves six manufacturing sites, two distribution centres, and an implementation team of 50 people including consultants, business analysts and subject matter experts under a nested supply chain planning environment. This entails pulling ODP demand schedule into market plan, using this plan output as a demand schedule into the manufacturing plans and generating a constrained manufacturing plan
• Implemented OPM Manufacturing - This involved designing OPM item master, Discrete item master, recipes, routings, formulas & validity rules (Process Engineer, Formulator, OPM Inventory, OPM Process Planning, & Production Supervisor) to suit Teva’s generic pharmaceutical business environment.
• Designed business processes for new product evolution from regulatory stage, to pilot batches, technical services, and validation batches to build towards a successful product launch.
• Implemented Oracle procurement and receiving for purchased finished goods
• Defined -Locations, Buyers, approval groups and assigned limits to approval groups, receiving options, receiving tolerances, approval hierarchies, requisition templates, defined document types controlling Purchasing Periods, sourcing rules, approved supplier lists (ASL), ASL level Blanket Agreements, item org level assignment set, defined multi-sourcing set up for planning
• Implemented collaborative planning and I-supplier portals between different manufacturing sites with internal customer- supplier relationships
• Designed complete ASN functionality from I-supplier portal based on PO from suppliers
• Set up VMI item functionality on I-supplier portal using Purchasing ASL level set up, and running the VMI replenishment engine and releasing planned order from I-supplier portal
• Provided continuous production support for Procurement, Receiving, Oracle Demand Planning, OPM Inventory, & Order Management
• Experience in System Upgrades/Patches assess functional / application upgrades/patches for impact on functionality process,, customizations and assist with implementation of new releases and upgrades and applying patches.
• Liaised with Business SMEs to review and analyze business requirements, and developed FDS (Fun. Design Specs) this includes application configuration changes to forms and reports