SUMMARY:

As an IT professional, Mr. Welsh is an Oracle Supply Chain and Manufacturing Consultant with over 16 years experience in all phases of Oracle implementations from project management, ERP/integrated systems, Manufacturing, Distribution, SCM, Planning, business analysis/redesign, and resource management. He specializes in Oracle manufacturing and distribution modules with many implementations in the telecommunications, avionics and high tech and consumer goods industries. Mr. Welsh has a strong technical aptitude and in - depth knowledge in process reengineering, process design, and problem solving. His ability to interact with management, understand issues, and deliver solutions to complex problems are keys to his success. Dale is consistently viewed by his staff and peers as a leader, team player, counselor and mentor. He is recognized for his unparalleled quality of work.

TECHNICAL SKILLS:

Oracle Applications Release: R12/11i/11.0/10.7 (Inventory, Warehouse Management System, Distributed WMS, Mobile Apps, Order Management, Work in Process, Costing, Material Requirements Planning, Purchasing, Bill of Material, Quality, Engineering, Advanced Supply Chain Planning, Collaborative Planner, Demand Planner, Configurator, Configurator Developer, Depot Repair)

Oracle SSWA Applications: Collaborative Planner, Configurator Developer

Oracle Tools: SQL*PLUS, Discoverer, SQL Developer Strong technical skills in underlying tables for WMS, INV, SHP, OM, PO, WIP and BOM

Productivity Applications: MS Office-Word, Excel, Access, PowerPoint, MS Project, Visio

Languages: SQL, HTLM

Operating Systems: Window, Unix, Linux

Other Applications: SQL Navigator, TOAD, Bartender, Dataload, i2,Agile

Methodologies: CSC Catalyst, AIM

PROFESSIONAL EXPERIENCE:

Oracle Supply Chain Consultant

Confidential

Responsibilities:

• Oracle R12.1.3 INV, MSCA, Shipping for multisite pump manufacturer. Responsible for MSCA deployment, RF device configuration, label design, customer serial allocation design in MSCA, integration of legacy order configuration system to Oracle Order Managment, and cross functional support for Oracle Quality, MES and BOM.
• Responsible for project milestones-Design, CRP, UAT, RICE and setup and configuration documentation.
• Solutioned functional design to support complex operations using Oracle R12.1.3 MSCA, INV, Shipping as well as packaged software ShipExec for all domestic and international shipments.

Oracle Supply Chain Consultant

Confidential

Responsibilities:

• Oracle R12.2.4 BOM, WIP, ASCP for multisite window/door manufacturer. Responsible for CTO Bill of Materials structure, departments, resources and routings. Designed Work in Process flow to meet customer manufacturing design with multi operational steps to record both backflush and push supply types using MSCA.
• Responsible for all project milestones-Prototype, SIT, CAT/CRP, RICE design documentation, Oracle Training, Production support/transition
• Solutioned functional design to support complex operations using Oracle R12.2.4 BOM, WIP, CST, MSCA, and ASCP modules

Oracle Supply Chain Consultant

Confidential

Responsibilities:

• Oracle WMS, MSCA for OPM-2 month proof of concept project for multi-site aluminum manufacturing and distriubtion organization
• Functional consultant for large scale, multi-org ASCP implementation in a process manufacturing organization
• Oracle Supply Chain, Manf and Distribution Confidential to clients in varied industries, such as chemical, industrial, high tech and consumer goods. Responsible for Confidential for 6 R12 clients in the following modules: INV, PO, BOM, WIP, OPM, WMS, MSCA ASCP, OM, COST, Quality
• Responsible for all project milestones-Prototype, SIT, CAT/CRP, RICE design documentation, Oracle Training, Production support/transition

Supply Chain IT Lead

Confidential

Responsibilities:

• Responsible for implementation of Oracle R12 WMS, MSCA, Inventory,Shipping in Texas, London, Penang and Mexico distribution centers, as well as 10 Inventory orgs across in a large scale global implementation
• Solutioned functional design to support complex operations using Oracle R12.1.3 WMS, MSCA, INV, and Shipping modules
• Managed and directed team of 6 resources in Global roll-out of successful Oracle R12.1.3 implementation
• Responsibile for WMS rules design in a high volume cartonization environment using several methodologies such as pick in pass, pick by label and integration to automated conveyor system
• Responsible for all project milestones-Prototype, SIT, CAT/CRP, RICE, Oracle Training, Production support/transition.
• Backup lead for manufacturing BOM and WIP in complex discrete environment
• Import/Export integration with Vastera TradeSphere

Supply Chain IT Lead

Confidential

Responsibilities:

• Implemented Oracle R12 Distributed WMS in Chicago, IL distribution center. First Oracle customer to implement Distributed Oracle WMS (dWMS)
• Featured speaker at Oracle Open World 2010 on distributed WMS.
• Managed, lead and mentored a lean team of 5 resources for first successful dWMS implementation in under 6 months
• Performed all setup and configuration of dWMS from prototype to production deployment. This included OM configuration on dWMS side.

Supply Chain IT Lead

Confidential

Responsibilities:

• Functional lead for EMEA Oracle 11i WMS and Mobile Apps implementation in high volume complex distribution center.
• Responsible for solutioning complex Oracle WMS rules for picking and putway with most rules having embedded advanced SQL
• Managed functional and technical teams to deliver robust Oracle WMS solution meeting complex business requirements
• Responsible for business requirements gathering, solution design, map/gap analysis, functional specifications, conference room pilot, user acceptance testing, sustainment training and post production support in high order volume environment

Supply Chain IT Manager

Confidential

Responsibilities:

• Responsible for global application support and development for 125 applications in 10 facilities spanning 5 countries
• Responsible for managing design, development, and deployment of solutions for distribution and logistic applications both locally and globally
• Formalized business impact assesments, disaster recovery and business continuity plans. Create and manage statement of work (SOW), PO’s, maintenance agreements and licensing contracts.
• Developed and managed IT budgets while working to identify opportunities to cut costs and generate savings while meeting ever-changing technology needs to overcome internal system challenges
• Work closely with business teams to identify the needs of internal customers and users and develop effective plans to ensure that their requirements are met in a timely and cost-effective manner
• Responsible for leadership and management of 18 direct reports and 15 onshore and offshore contractors

Principle Oracle Consultant

Confidential

Responsibilities:

• Project lead for 11.5.9 WMS, MSCA, BOM and WIP implementation in a high volume multi-site distribution environment
• Responsible for implementation of Oracle WMS, OM, MSCA, PO, MRP, INV, WIP, COST and BOM. Developed business requirements documentation, map/gap analysis, functional specifications, test scripts, conversion, setup and user training material
• Setup Average costing by cost group and drove cost group rules using WMS. This allowed various costs by cost groups in same organization for same inventory item.
• Created over 200 WMS Rules to support put away, picking, cycle counting, cost group and label assignment in high volume, high shipping distribution facility
• Designed WMS labels and barcodes using third party label software, Loftware. Setup WMS business flows for auto printing of labels to over 20 Sato and Zebra label printers.
• Responsible for business requirements gathering, solution design, map/gap analysis, functional specifications, conference room pilot, user acceptance testing, sustainment training and post production support in high order volume environment
• OM setup of order types, customers, defaulting rules, price lists

Principle Oracle Consultant

Confidential

Responsibilities:

• Key Project lead for 11.5.9 Manufacturing and Distribution implementation in a highly configurable order environment. Track lead for Oracle Configurator, MRP, BOM, WIP (ATO), PO,WMS, CST and Order Management
• Responsible for developing prototype order configuration solution using Oracle Configurator Developer and Oracle Configurator
• Key architect of unique customer configurator between legacy order fulfillment system and Oracle Order Management. customer fulfillment model required
• Designed inbound interface from client order intake system to Oracle Order Management using newly developed custom configurator and Order Import API’s.
• Developed complex conversion strategy to load over 12,000 bills of materials, 1 million configuration rules and 12,000 category code combinations used in a unique bom category mass change function. High volume PTO/ATO environment
• Responsible for business requirements gathering, solution design, map/gap analysis, functional specifications, conversion, conference room pilot, user acceptance testing, deployment and post production support

Principle Oracle Consultant

Confidential

Responsibilities:

• APS lead for 11.5.9 ASCP (Constrained Based Planning) and Collaborative Planning applications.
• Designed APS solution to seamlessly collaborate sales forecast, sell-through forecast, and capacity between suppliers, planners and internal customers
• Worked with key supplies, such as Nokia and Confidential to develop supply capacity flat file used in the ASCP constrained based planning cycle
• Developed time phased replenishment solution utilizing sales history in Oracle Demand Planner to drive replenishment forecast in Oracle ASCP for 1000+ locations
• Deployed Oracle’s Collaborative Planner module to planners and trading partners to collaborate across one common platform and reduce demand oscillations
• Collaborative Planning software allowed trading partners to manage VMI inventory and release replenishment requisitions using the self service web application
• Responsible for business requirements gathering, solution design, map/gap analysis, functional specifications, conference room pilot, UAT and post production support in high volume order from stock environment
• Composed all setup and configuration documentation, as well as application module training material for planners, administrators and suppliers

Principle Oracle Consultant

Confidential

Responsibilities:

• Project Manager and function consultant responsible for solution design using Oracle MRP with Seiban Numbers in a complex assemble to order/engineer to order manufacturing environment
• Able to institute process reengineering throughout the planning department to support both a vertical and horizontal planning approach
• Designed and composed functional specifications for project number regeneration program, as well as functional specifications for several Oracle Reports
• Developed project plan, CRP and UAT test scripts, Issues log and production cutover documentation
• Developed MRP training material and hosted multiple CRP and UAT sessions to Planners and key Product Managers. Worked heavily with WIP (ATO) and BOM as part of the MRP implementation
• Composed all setup and configuration documentation and identified all touch points requiring data scrubbing as part conversion
• Composed a Seiban Manufacturing White Paper that was submitted to Confidential and eventually OAUG (Oracle Applications User Group)

Senior Consultant

Confidential

Responsibilities:

• Responsible for solution design using Oracle WMS, Shipping and MRP in a high volume shipping and manufacturing environment
• Solution involved a high degree of problem solving and design to configured Oracle WMS Rules Engine and Shipping to support 300,000 orders per day
• Designed and configured multi-site MRP solution involving both client owned and operated locations as well as 3rd Party Logistic Provider locations
• Supply Chain solution provided client completed visibility to supply and demand activities throughout the planning process
• Involved in Supply Chain process re-engineering to stream line planning operations in a multi-site environment
• Completed Business Requirements, Gap Analysis as well prepared and presented MRP solution demonstrations to key Supply Chain Business Users

Senior Consultant

Confidential

Responsibilities:

• Project Lead for team of 4(client) resources in one of the largest 10.7 to 11i upgrades in the Pacific Northwest. Supported the upgrade of Oracle Inventory, Work in Process (ATO), Bill of Material, Cost Management and Oracle Shipping
• Responsible for the upgrade of 950+ locations running Oracle Inventory, with over 3000+ concurrent users
• Designed BOM structure with ATO configuration in a high volume Telecommunication environment
• Setup all costing (Standard Costing) with Supply Chain Cost Rollup across all inventory organizations
• Prepared and presented Conference Room Pilot (CRP) 1st and 2nd iterations to an audience of 10-15 key Business Users. Competed 100+ CRP test scripts that were converted into HTML online training material
• Completed Business Requirements, Gap Analysis, System Design and Functional Specs. within tight project due dates
• Responsible for sustainment strategy of supply chain, production support and the writing of Interface Error Handling documentation that is used by Sustainment Analysts.
• Designed and developed several custom reports, as well as operational metrics used in the manufacturing and distribution of terminal equipment

Senior Consultant

Confidential

Responsibilities:

• Functional Warehouse Management and Manufacturing Consultant on Major Wireless Implementation.
• Responsible for performing gap analysis on various warehouse management systems, such as Red Prairie, Oracle Warehouse Management System and Infoflo (client legacy system). Designed 5 multi-directional interfaces from Oracle to Red Prairie (WMS)
• Designed Oracle solution to mirror the transactions occurring in the 3rd party WMS software, allowing complete inventory visibility for purchasing, planning and order entry
• Implemented Oracle MRP/MPS, BOM and WIP, interfacing to warehouse management system, Red Prairie
• Led Warehouse and Manufacturing team through Business Requirements gathering, System Requirements and Proof of Concept (Gap Analysis) of the Phase II ERP implementation
• Developed all setup and configuration as well as performed gap analysis, developed functional specifications, test scripts and end user training

Senior Consultant

Confidential

Responsibilities:

• Functional Consultant on the Oracle Supply Chain implementation. Directly responsible from Oracle Inventory, Costing, Order Entry setup and configuration
• Designed several multi-directional interface solutions to multiple legacy systems. Wrote test script for system testing, integration testing and regression testing
• Instrumental in designing and deploying an Oracle Inventory solution for over 700 retail stores, using only one operating instance
• Documented business requirements, performed gap analysis, functional specs, developed training materials, configured software, identified customizations and worked closely with the development team and data conversion team

Supply Chain Analyst/Warehouse Materials Manager

Confidential

Responsibilities:

• i2 Supply Chain Analyst. Analyzed demand forecast and created the MPS before releasing it to Global Planning. Ran “What If” scenarios looking at all variables to see what the optimal plan would be.
• Directed production control, material handling, kitting, inventory control, and shipping/receiving.
• Implemented JIT demand-pull system utilizing Kanban for flow of materials.
• Provided direction and leadership for two warehouse and manufacturing locations. Assisted with the Oracle implementation at the manufacturing site and was responsible for Oracle INV, CST, OE and WIP