SUMMARY:

• Confidential has over Fifteen years, and over ten full cycle implementation expertise as Lead Functional Consultant and Project Manager in Oracle Warehouse Management (WMS), Oracle Trade Management (TMA) / Oracle Channel Revenue Management (ChRM), Oracle Order Management (OM), Oracle Advanced Pricing (QP), Oracle Shipping (WSH), Mobile supply Chain Applications (MSCA), Inventory, Items, OPM/WIP etc. areas. He has been responsible for Innovative designs of complex systems that are customer focused and supported end - to-end business processes.
• He has over 20 years of Industry experience in Oracle ERP implementations as functional and techno-functional consultant, in Supply Chain and IT consulting, serving the Aerospace and Defense, Manufacturing, Agro based process manufacturing, Retail and Food Service industries. His industry experience includes business process reengineering, project management, and cost estimating.
• He has worked on multiple implementation, Consulting and Support projects in Oracle Applications in various capacities such as Functional Lead, Project Manager and Solution Architect.
• He has been lead for several successful on time, on budget delivery of numerous high-profile projects. He has a strong understanding of the integration between different Oracle modules.
• He has sound understanding of the functionalities, setups, table architecture and dependencies / integration issues among the Supply Chain / distribution and manufacturing modules in multi-org environment.
• He has good balance of functional, business and technical knowledge. Excellent presentation and communication skills. Good rapport with business users and developers to deliver solutions.
• He has sound understanding of all phases of end to end ERP implementation such as Business Process Remodeling, Gap Analysis - with respect to As-Is & To-Be Design, Development, Testing, Go-Live and Maintenance (User training & post production support). He has been responsible for Requirement Specifications, Setups/Configurations, Upgrades, Solution Design, Support, and Designing of Reports, Interfaces, Conversions and Extensions (RICE). He has used Oracle AIM methodology in various implementations.
• Having worked on diverse projects with in US, Europe (UK, Switzerland) and Asia-Pacific (Singapore and India) regions enables him to understand varied business requirements, value cross cultural sensitivity & share business best practices, while delivering cost effective and innovative IT solutions.

ENGAGEMENT EXPERIENCE:

• Business & Functional Process Reengineering
• Applications Implementation
• Fit/Gap Analysis
• Application Set-up
• Application Testing
• Project Management
• End User Training
• Conversion
• Support
• Forms Personalization
• Product Management and Development
• Interface design to third party solutions

SKILLS:

Oracle EBS R12.2: Oracle Channel Revenue Management (ChRm) / Oracle Trade Management (TMA),Oracle Order Management (OM),Oracle Shipping (WSH),Mobile Supply Chain Applications (MSCA),Warehouse Management (WMS),Oracle Advanced Pricing (QP),Oracle Purchasing (PO),Oracle Transportation Management (OTM),Oracle Process Manufacturing (OPM),Oracle Inventory

Oracle Products & Databases: Oracle Applications R12 (12.2), Oracle 11i

Operating Systems: Oracle Linux 6, AIX 6.1, HP-UNIX 11.20

Hardware: Linux X84-64, UNIX SVR4, HP 9000

Tools: SQL* Plus, PL/SQL, Unix shell, Discoverer, Workflow, Oracle Forms & Reports, User Productivity Kit - UPK, More4Apps, Data Loaders, HP Quality Center 9.2, Remedy 6.03 More4Apps (Sales Order Wizard)

PROFESSIONAL EXPERIENCE:

Confidential - Des Moines, IA

Lead Functional Consultant / Project Manager / Solution Architect

Responsibilities:

• Requirements gathering, Identification of gaps, develop CR/change request documents and MD50 design documents to support the customizations for WMS / MSCA / OPM / Purchasing / Shipping / Inventory process designs
• Discussions with business users to develop and document the current as-is and future to-be processes, and develop Business process flows, and Training documents.
• Develop RD50 Current Process Requirements, BP80 Future process, Solution Design, TE40 Test Scripts, CV40 Onhand conversion and other supporting documents, necessary for WMS/MSCA/Shipping/OM/Inventory. Used these documents during the configurations of various instances.
• Developed BR100 configuration document to setup organization, zones configuration, menus, responsibilities, all shipping setups, wms msca forms personalization, wms label setups and assigning to business events, barcode printer setups, etc.
• Developed Test scripts, CRP/UAT presentation decks and scenarios documents, and conducted these events with the support of key business resources.
• Plan and conduct various phases of the project such as CRP-I & II, UAT, Go-live implementation, Data conversion.
• Discuss, design, document and implement the various “Picking and Putaway” WMS rules to support the PO Receiving putaway, Manufacturing Picking and Putaway, shipping outbound business processes, and Move Order transfer processes.
• Design and implemented Labeling solution to support the barcode labeling needs such as WMS LPN Content labels in various formats, and to trigger them automatically during appropriate business events such as PO and Inventory receipts, Packing, Batch WIP Completions. Designed and implemented WMS rules to select necessary label formats based on business needs.
• Designed OPM processes to create manufacturing batches, issue ingredients, incremental backflush to auto issue ingredients during product completion, generate barcode labels during pallet completions, create tasks to issue ingredients to batches.
• Develop test scripts to support the project.
• Guide and Coordinate development and testing with offshore team members.
• Designed and built data loader conversion templates to support creation of Subinventories, Stock Locators (including dock doors and staging lanes), Item Sub inventory restrictions, Item Category assignments, to support cut-over activities.
• Supported Bartender label design, Hand held CK75 RF scanners, Zebra printer evaluation, procurement and setups.

Confidential - Hutchinson, KS

Lead Functional Consultant / Solution Architect

Responsibilities:

• Identification of gaps, develop Issue documents and MD60 design documents to support the customizations for OTC Order Management / WMS / Shipping / Inventory / EDI process designs
• Discussions with business users to document the future to-be processes, and develop Business process flows, and Training documents.
• Develop BR100 configuration document for capturing configurations necessary for WMS/Shipping/OM/Inventory and then use it during the configurations of various instances.
• Designed and implemented Vendor Managed Inventory (VMI) solution for customer Boeing/Spirit, through which appropriate material is produced and shipped from AAC and maintained Confidential a VMI warehouse based on customer demand and based on future aircraft build schedule. This solution was also enhanced to ship material to Freight forwarders as and when material is ready, for consolidation, and to be shipped to customers in Japan.
• Designed and implemented an EDI consumption solution, to accept electronic consumption signal of LPN’s and lots consumed by Aerospace customer, and then convert it into automated shipment by creating a sales order and ship the consumed inventory, to generate automatic Invoices, through a very user friendly web interface.
• Designed and implemented additional customization to support bundle breaking to support transfer of lot pieces between packages; customization to automatically receive (Miscellaneous receipts and PO receipts) material shipped from another parent plant on the same instance by passing trip number, and with minimum key strokes; customization to perform Physical Inventory to support unique aerospace industry needs by just scanning LPN’s and reporting the exceptions.
• Designed and implemented a shipping solution to support the Make to Stock and Make to Order models.
• Designed and implemented Barcode code labeling solution to support LPN inventory labels and Shipping Label needs.
• Design Interfaces between Oracle EBS and Shippers Common Wealth and Best Transport, for load planning and load tendering.
• Designed extensions to support data conversion activities for Price List, Sales Order and Onhand conversions Confidential cut-over.

Confidential - Columbus, OH

Lead Functional Consultant

Responsibilities:

• Identification of gaps and design CEMLI’s (customizations) for OTC Order Management / WMS / Shipping / EDI process designs
• Discussions with business users to document the future to-be processes, and develop BP80 document.
• Develop BR100 configuration document for capturing configurations necessary for WMS/Shipping and OM and then use it during the configurations of various instances.
• Designed shipping processes using WMS Direct Ship to support inter Org material movements between Plants and Warehouses. Also supported traditional shipping processes for supporting lot based shipments from Plants and 3PL’s to Customers. Configuration of mobile applications to support these activities.
• Design of complex validation processes for handling validations of inbound customers’ orders and for placing appropriate holds based on exceptions encountered. Supported validations through Order and Order line workflow customizations.
• Designed OM EDI Interfaces to facilitate business from 3PL (3rd Part Logistics) and integrating them with the standard EBS solution. Support of EDI 850 PO Inbound, 855 PO Acknowledgement, 940 Delivery Advice, 945 Ship Confirm, 856 Customer ASN, etc.
• Developed MD 50 design documents to bridge the missing standard functionality, develop Test Scenarios, and review the design with the business and technical development team, to ensure all business needs are fulfilled.
• Designed Interfaces between Oracle EBS and OTM (Oracle Transportation) to interface the system to communicate shipping information such as Orders and Deliveries between the two systems.
• Designed Advanced Pricing extension to import Off Invoice promotions from a Demantra system and import them in Oracle EBS advanced Pricing.
• Conduct and support CRP (Conference Room Pilot) and SIT (Systems Integration Testing) with business engagement.
• Design enhancement to standard COGS Workflow to in corporate customers specific business rules for deriving COGS account during ship confirmation and revenue recognition.

Confidential - New York

Lead Functional Consultant

Responsibilities:

• Identification of scope, timelines of OTC Order Management / Distribution designs
• Discussions with business users to document the current processes and requirements, and develop a BP80 document, and get user sign off.
• Develop BR100 configuration document for capturing configurations necessary for ChRM/TMA and OM and then use it during the configurations of various instances.
• Developed Test Scenarios, Test Scripts, End to end Scenarios, and get user sign off after reviewing with the business, to ensure all business needs were fully documented.
• Designed the Off Invoice offers, Accrual Offers and Lumpsum offer processes for NYB. Configured the Approval rules, and custom configuration processes to accommodate needs for various business units.
• Designed the Budgets process and funds allocations necessary.
• Designed the Claims process to ensure the accruals were consumed to AR Deduction Claims, and AP Claims.
• Ensure the proper accounting entries were created and transacted to GL.
• Developed MD50 and validated the solution after it was developed, to deliver ability to raise offers based on Custom Market category segment combinations (1, 2, 3, 4 or 5 segment combinations to apply offers). The standard functionality only allows offer against the default OM item category.
• Developed MD50 and validated solution after it was developed, for loading accrual, off invoice and lumpsum offers though a csv format file.
• Design Interfaces between Oracle EBS and OTM.
• Designed a hierarchical offers solution where an offer defined for a parent customer was made available to all its child customers based on parent-child relationship defined Confidential party level.
• Enhancement and support of WMS and MSCA (Mobile Supply Chain Applications) solution. Developed WMS BR100 and BP80 process design documents.
• Designed process to automate custom shipping solution using WMS direct Ship API’s to integrate various shipping stages on a single custom form. This provides ability to build trips/deliveries, move inventory to stage, monitor quality processes, load truck, ship confirm and trigger shipping documentation. Developed MD50 to support this design.
• Designed and implemented various WMS and MSCA features such as Inventory Move Orders, Picking and Putaway rules and strategies to handle LPN shipments as well as shipments for loose stock, Inventory moves.
• Designed and implemented interfaces to various third party systems from Oracle OM and shipping.

Confidential, Keene, NH

Lead Functional Consultant - Oracle Applications (Order Management/ Distribution/Pricing)

Responsibilities:

• Identification of scope, timelines of OTC Order Management / Distribution designs
• Discussions with business users and Mainframe IT staff to document the current processes and requirements.
• Develop MD50 design documents and review designs with business users, Mainframe IT and development team. Train business users on Oracle functionality.
• Design Sales Order conversion process to handle open sales order during implementation using High Volume Order Import.
• Design and implement different Customer Rebates functionality using Oracle Advanced Pricing and Oracle Channel Revenue Management.
• Design Ship Confirm Interface to receive Ship Confirm transactions from various WMS systems along with separate activities such as scratches, catch weights, cancellations, exceptions.
• Design a Pro forma Invoice to be sent along with the shipping paperwork which provides detailed information on the Order pricing, rebates, adjustment, taxes, to support needs of various different Customer chains.
• Design several business interfaces to support inbound data files from various Customers, and also out bound data files to Customers. These interfaces will be used to communicate Retail Pricing, Ads, Customer Rebates, etc. to and from the Customers.
• Requirements gathering and Design of Oracle Channel Revenue Management solution, specially Offers (Customer Rebates)
• Design and Implementation of Oracle EBS to WMS Interfaces.
• Coordinate development activities with offshore team members.

Confidential, Seattle, WA

Lead Functional Consultant - Oracle Applications (Order Management/ Distribution)

Responsibilities:

• Identification of key business areas, stakeholders and parameters for ERP vendor selection
• Planning and execution of the key global business process standardizations and critical local business requirements
• Identification of scope, timelines of the global design and local regional designs
• Requirement gathering and its classifications with all key business stakeholders from all regions
• Identifications of DCLs ( Design candidate list), execution of solution designs that resulted into agreed upon solution design approach, business process workarounds and Oracle EBS customizations (RICEW)
• Design and development of all RICEW components with cost effective onsite offshore model
• Configuration of Order Management module including Processing Constraints, Defaulting Rules, Lookup codes and standard OM/Shipping Configurations.
• Preparation, planning and execution of various testing phases (System testing, integration testing, certification testing, regression testing and operation readiness testing)
• Prepare plan to convert various legacy and other related data to new platform
• Conversion planning for all master and transactional data
• Managing preparations, coordination with 3PLs and TSPs to meet timelines of various phases of the projects
• Planning for cutover, stabilization and transition plan to existing sustainment team.
• Designed Nissin Interface to supply Shipment data to TSP for generating Commercial Invoices and Packing List for International Customers.
• Designed and implemented Order Generation and Shipping process for International Joint Venture Customers (Asia Pacific and Latin America regions) to ship products from various Distribution Centers in US, China and Singapore.
• Designed International drop ship process to ship products to Joint Venture Customers from Domestic and International suppliers.
• Designed and implemented “Distribution Point Master” solution for Starbucks. This solution provides the ability to provide “Fixed Order and Delivery Schedules” throughout US and Canada, to receive timely products from Regional and Local Distribution Centers, & Suppliers across the country, to the Stores. This solution also enabled the 3PL’s to maintain their own delivery schedules.
• Integrating 3PL WMS (Warehouse Management Systems) with Starbucks EBS system.
• Designed and Implemented Starbucks Digital Ventures solutions to fully Integrate “Amazon.com” and “StarbucksStore.com” with Starbucks EBS system, for “North America”, “Canada” and “EMEA/Europe” markets. Provided training to internal and 3PL Partners, and support for successful implantation.
• Design and Implementation of “Pick Release”, “Ship Confirm”, “Inventory Adjustments” with 3PL WMS Systems.
• Design and integrating Oracle Purchasing with third party WMS systems.
• Design and integration of Oracle Receiving with third party WMS systems using Open Interfaces.
• Coordinate development and support activities with Infosys offshore team.

Confidential, Chicago, IL

Lead Senior Functional Consultant - Oracle Applications (Order Management/ Distribution/Manufacturing)

Responsibilities:

• Responsible for support and system enhancements of 11i Oracle Order Management/ Distribution (Purchasing, Shipping, Accounts Receivables) and Manufacturing Applications.
• Maintenance of SBT (Scan Based Trading) and Price point trading with stores (also called rooftops) all across the country for Customers like Walmart, Wind Dixie, Meijer and Target, through EDI transactions.

Confidential, Davenport, IA

Lead Functional Consultant - Oracle Applications (Shipping/WMS/MSCA/Order Management)

Responsibilities:

• Design extensions to integrate the Transportation Management System (TMS) products such as Shippers Common Wealth load planning optimization, Best Transport carrier tender and accept, and CT Logistics freight payment.
• Cross track Interaction with Finance, Inventory, Item Configuration and Approval, Quality, and Supply Chain Planning tracks to ensure the integrity of the solution. Interacted with client’s corporate Project Management Office for customization approval and leveraging common procedures and enhancements. Interacted with client’s on shore and off shore development teams.
• Solution Architect responsible for requirements gathering, functional gap analysis, module setup, generation of system test scripts, designing new process flows, and end user training
• Responsible for developing Business Process documents (BP80), Issue documents after performing gap analysis, Design Documents (MD60) to aid developers in building the solutions, and Training documents
• Responsible for Integration testing and implementing the solution through CRP, UAT, Implementation and then post Production Support
• Responsible for designing custom Discoverer reports and providing tech team with report design document (RD60)
• Coordinate development and support activities with offshore TCS and Oracle team members.
• Designed and implemented complete shipping solution from material selection to shipping paperwork generation
• Designed Export Vessel Booking process to help the client with Export shipments and Ocean Freight Forwarding with 3rd party forwarders and steamship lines.
• Designed a manual shipment process to provide ability to easily perform all shipping functions including LPN selection, pick release, carrier tendering, ship confirm and document generation from a single form
• Ability to transact shipments and invoices in actual quantities for dual units of measure in dual units of measure, while keeping the primary unit of measure of “pounds” consistent across all the items
• Ability to ship only full LPN’s, to the top of the shipping tolerance as much as possible (to increase revenue)
• Ability to ship to Plant Warehouses Confidential different locations by planning loads/trips, tendering Carriers, and then automatically receiving material Confidential the warehouse
• Designed a simple process to ship Aluminum Scrap and Dross material and generate shipping documents in a single transaction
• Designed a simple process to provide ability to ship miscellaneous material not existing in the system inventory
• Designed a process using WMS RFID functionality to provide ability to easily Invoice Consumption shipments, for material Confidential the Customer, when consumed by the Customer
• Designed and implemented a process to automatically generate Invoices based on EDI consumption signal from the Customer, for material Confidential the consignment warehouses
• Ability to build phantom loads/trips and tender them to request the Carriers for material to Critical Customers, that is not yet available, but will be available when the Carrier arrives
• Ability to consolidate shipments Confidential the Freight Forwarder location to minimize transportation costs
• Ability to perform dock scheduling to avoid carrier delays during loading
• Ability to easily detect incorrectly loaded material Confidential the dock before the carrier leaves the plant
• Ability to sequence shipping documents and then group them by stop-offs within a trip during printing
• Functionality to submit different shipping document sets based on whether a shipment is domestic US, Canadian, European, etc.
• Design and enhance customer facing shipping documents such as Bill of Lading, Master Bill of Lading, Shipping Manifest, Customs Invoice, Commercial Invoice, etc., based on customer requirements
• Designed a “Shipping Workbench” tool to provide ability to easily select unpacked loose lot numbers, perform Quality processes and certification, and ship them using a single form
• Designed a “Make and Hold” process to provide ability to make material for specific high value customers, and then ship specific LPN’s based on Customer request to specific sites
• Involved in the design and implementation of OSP processes using 861, 856 and 870 EDI transactions
• Setup of WMS/Shipping profile options.
• Setup of Dock doors, Staging Lanes, Equipment items, Ship methods, Carriers
• Designing and setup of Shipping Documents, Pick Release Rules, Ship Confirm Rules, Shipping Parameters, Global Parameters, Shipping Roles
• Designing and setup of freight charges and handling
• Designing and Setup of WMS Picking and Putaway Rules and Strategies. Auto Cost group update rules. WMS Rules simulation
• Designing and Setup of Task type Assignments
• WMS setups for providing Staging functionality
• Materials Work Bench, Transact Move Orders, WMS Control Board usage
• WMS Direct Ship and related RFID setups and use in performing automated shipments with minimum user intervention
• Setup for barcode label generation and printing
• Configuration and Set up of mobile handheld Scanners
• Designing mobile responsibilities based on Business needs
• Coordinated setups for Processing Constraints, Holds, and Defaulting rules
• Coordinated setups of Order types
• Coordinated Quality setups - Collection Elements, Collection Plans, Collection Plan transaction association, and Actions.
• Designed Quality interface to import Collection Plan Quality results from third party manufacturing system into Oracle Quality using open interface.
• Responsible for setup of shipping network, items
• Coordinating setups of Warehouses, Locations, Subinventories, Stock Locators, Cost Groups, Account Aliases, Transaction setups with Inventory and Costing Tracks
• Coordinating setups for Departments, Resources with Mfg Track
• Best Transport is a Freight Carrier tendering system. Designed extensions to integrate Oracle Applications with Best Transport
• Shippers Common Wealth is a Load planning Optimizing tool. Designed extensions to integrate Oracle Applications with Shippers Common Wealth
• CT Logistics is a freight payment tool. Designed extensions to integrate Oracle Applications with CT Logistics.
• During Davenport, IA facility implementation the Manufacturing processes were operational from the Legacy systems. Only OM/Shipping was implemented in Oracle. Designed extensions to bring over inventory from Legacy, and then communicate shipped status to Legacy.
• Coordination of defining users, responsibilities, request sets, roles and grants
• Responsible for troubleshooting and resolving production issues on multiple modules
• Responsible for coordinating with oracle support and logging tars, enhancement requests on various issues
• Designed queries for the Discoverer Reports team while requesting reports for Shipping Track

Confidential, Bloomington, IN

Lead Functional Consultant - Oracle Applications (Shipping/WMS/MSCA)

Responsibilities:

• Aggressive implementation using least customization
• Responsible for Integration and Implementation of 11i Oracle Shipping/WMS/Mobile Supply Chain Applications Confidential for the Bloomington, IN facility.
• Interaction with other tracks to ensure the integrity of the solution
• Responsible for requirements gathering, functional gap analysis, module setup, generation of system test scripts, and super user training
• Responsible for Integration testing and implementing the solution through CRP, UAT, Implementation and then post Production Support
• Ability to perform Cartonization Confidential the time of shipping
• Ability to automatically trigger replenishment of FG subinventories, when the product falls below the minimum threshold, to ensure constant supply in the shipping bins
• Ability to print different documents Confidential shipping from different trays of a printer to use different stationary, and then group documents by delivery
• Ability to perform auto Pick Release of Orders, every day in the morning, based on business specified rules
• Provide easy shipping for Large customer orders using WMS Direct Ship
• Ability to perform automatic Staging, using WMS private API’s. This saved the organization about 4 scans per LPN shipped to the Customer.
• Setup of Dock doors and Staging Lanes
• Designing and setup of Shipping Documents, Pick Release Rules, Ship Confirm Rules, Shipping Parameters, Global Parameters, Shipping Roles
• WMS Configuration and Setups
• Designing and Setup of WMS Picking and Putaway Rules and Strategies
• Designing and Setup of Task type Assignments
• Configuration and Set up of mobile handheld Scanners
• Performed setups of Warehouses, Locations, Subinventories, Stock Locators, Cost Groups, Account Aliases, Transaction setups
• Performed setups for Departments and Resources
• Coordination of defining users, responsibilities, roles and grants
• Responsible for troubleshooting and resolving production issues on multiple modules
• Responsible for coordinating with oracle support and logging tars, enhancement requests on various issues
• Train developers and local IT staff during post production transition

Confidential

Senior Consultant - Oracle Applications

Responsibilities:

• Performed lead role in analyzing, designing, building, testing and implementing several add-on modules/interfaces/customizations in an effort to implement Order Management, WMS, Shipping, WIP, Order Entry, Inventory, Bill Of Materials, Purchasing, Accounts Receivables
• Responsible for Gap Analysis, Requirement Specifications, Setups, integrations with 3rd party solutions, Data Conversion, Development and Maintenance of Oracle Applications System
• JIT program implementation and interfaces with client’s customer partners.
• Performed lead role in Upgrading the Existing Oracle applications from prior versions to later versions several times
• Mostly responsible for designing and developing solutions based on business requirements, and to provide continuous production support
• Jul 90 to Jan 94 experience has been with designing and developing custom applications using Oracle database. After that the experience has been designing and development in Oracle Applications environment.
• Designed and developed mobile barcode applications to integrate with Oracle applications using standard API’s. Also designed and implemented barcode labels.
• Designed Oracle Quality interface to import results from “Tensile Tester” and “Spectrometer” through open interface. Performed necessary Collection Elements, Collection Plans, and Specifications setups.
• All this experience has been Techno-functional.