John Patten Email & Phone Number

St. Louis, Mo

• Functional Lead for one of the nation’s leading supplier of food, personal care products, electronics and clothing to the correctional commissary market; a manufacturer of luggage, backpacks, travel gear and accessories; and a distributor of hotel guest room coffee.• Project scope includes the conversion of a highly customized (ALICE) system with operations in multiple US facilities to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts… Show more • Functional Lead for one of the nation’s leading supplier of food, personal care products, electronics and clothing to the correctional commissary market; a manufacturer of luggage, backpacks, travel gear and accessories; and a distributor of hotel guest room coffee.• Project scope includes the conversion of a highly customized (ALICE) system with operations in multiple US facilities to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Discrete Manufacturing (Bills of Material, Work In Process, Cost Management – Average Costing), Purchasing, Order Management, Release Management, Shipping Execution, Advance Pricing, Advance Supply Chain Planning, and Warehouse Management.• Worked closely with key Supply Chain and Cost subject matters in Material Operations, Manufacturing, and Cost to determine and coordinate the best in practice methods of reporting of material transactions, operational reporting of production and standardization of product cost from a Standard Cost environment into Average Cost environment.• Documented all business requirements onto BR100 specs• Recommended strategies for future improvements to the existing business processes and system configuration. • Setup multiple test environments to demonstrate the functionality of Oracle Inventory, Supply Chain - Bills of Material and Work in Process, and Cost Management.• Assisted in planning and preparation of requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots, Integration and UAT.• Worked with key Material Control, Manufacturing Operations and Financial users to fulfill their requirements for reporting of Material Transactions, Production Reporting and Cost Analysis, utilizing most reports out of Oracle.• Coordinated efforts for complex data cleansing and mapping from legacy systems to parent company. Show less

Lancaster, Oh

• Project scope is to provide services to better utilize its investment in the Oracle EBS Procurement products; and to replace the two legacy Anchor Hocking MRO and spares inventory systems in Lancaster, OH.• Review existing purchasing processes for MRO and Spares Inventory at the Lancaster facility• Map/Gap them to standard Oracle Purchasing functionality• Team closely with Anchor Hocking IT, Finance and Procurement to achieve a common solution design to use out of the box… Show more • Project scope is to provide services to better utilize its investment in the Oracle EBS Procurement products; and to replace the two legacy Anchor Hocking MRO and spares inventory systems in Lancaster, OH.• Review existing purchasing processes for MRO and Spares Inventory at the Lancaster facility• Map/Gap them to standard Oracle Purchasing functionality• Team closely with Anchor Hocking IT, Finance and Procurement to achieve a common solution design to use out of the box functionality with the intent to minimize any customizations• Retire the two legacy systems• Utilize Purchase Requisition functionality in core Purchasing• Establish Purchase Requisition and Order approval hierarchies• Setup Purchasing accounting to support business requirements• Establish an inventory for the spares area (the “cage”)• Creating new items in Oracle Purchasing as necessary• Importing “cage” inventory into Oracle (Anchor Hocking assisted)• Import vendors into Oracle (Anchor Hocking assisted)• Establish 3 way match for appropriate MRO and Spares items and update Receiving procedures as required• Coordinated efforts for complex data cleansing and mapping from legacy systems to parent company. Show less

Prescott, Az

• Functional Lead for one of the nation’s leading manufacturers of high-quality firearms for the commercial sporting markets.• First Phase of Project scope includes implementing Oracle into 5 US facilities – 3 manufacturing, 1 warehouse and 1 corporate HQ - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Cash Management, Fixed Assets, iExpense, Bank Reconciliation, ADP Payroll Journal to GL, Inventory Management, Discrete Manufacturing… Show more • Functional Lead for one of the nation’s leading manufacturers of high-quality firearms for the commercial sporting markets.• First Phase of Project scope includes implementing Oracle into 5 US facilities – 3 manufacturing, 1 warehouse and 1 corporate HQ - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Cash Management, Fixed Assets, iExpense, Bank Reconciliation, ADP Payroll Journal to GL, Inventory Management, Discrete Manufacturing, Purchasing, iProcurement, iSupplier Portal for Purchasing, Order Management, Depot Repair, Advanced Pricing, ASCP.• Second Phase of Project scope includes the Quality Module which consists of Vendor Performance Report Card - the measurement of Vendor Performance of On Time Delivery and Material Quality; Management of Material Scrap; and Managing the performance of every manufacturing firearm.• Worked closely with key Quality subject matters in Material Receipts, Material Inspection, and Manufacturing Operations to determine and coordinate the best in practice methods of reporting of material transactions.• Documented all business requirements onto BR100 specs• Recommended strategies for future improvements to the existing business processes and system configuration. • Setup multiple test environments to demonstrate the functionality of Oracle Quality.• Assisted in planning and preparation of requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots, Integration and UAT. Show less

Waconia, Mn

• Functional Lead for an industry leader who designs, manufactures, and markets a complete range of cabinetry and plumbing kitchen products.• Project scope includes the conversion of a highly customized SAP and DEC systems with operations in multiple US facilities to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Discrete Manufacturing (Bills of Material, Engineering, Work In Process, Cost), Purchasing, Order… Show more • Functional Lead for an industry leader who designs, manufactures, and markets a complete range of cabinetry and plumbing kitchen products.• Project scope includes the conversion of a highly customized SAP and DEC systems with operations in multiple US facilities to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Discrete Manufacturing (Bills of Material, Engineering, Work In Process, Cost), Purchasing, Order Management, Release Management, Shipping Execution, Advance Pricing, Advance Supply Chain Planning, and Warehouse Management.• Worked closely with key Supply Chain and Cost subject matters in Material Operations, Manufacturing, and Cost to determine and coordinate the best in practice methods of reporting of material transactions, operational reporting of production and standardization of product cost.• Documented all business requirements onto BR100 specs• Recommended strategies for future improvements to the existing business processes and system configuration. • Setup multiple test environments to demonstrate the functionality of Oracle Inventory, Supply Chain - Bills of Material and Work in Process, and Cost Management.• Assisted in planning and preparation of requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots, Integration and UAT.• Worked with key Material Control, Manufacturing Operations and Financial users to fulfill their requirements for reporting of Material Transactions, Production Reporting and Cost Analysis, utilizing most reports out of Oracle.• Coordinated efforts for complex data cleansing and mapping from legacy systems to parencompany. Show less

Stoughton, Wi

• Functional Lead for an industry leader who designs, manufactures, and markets a broad range of high performance exhaust products and tubing for OEM and aftermarket use for the global on-highway and off highway markets.• Project scope includes the conversion of a highly customized Oracle 11i – 11.5.10 with operations in multiple US facilities and India to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Human… Show more • Functional Lead for an industry leader who designs, manufactures, and markets a broad range of high performance exhaust products and tubing for OEM and aftermarket use for the global on-highway and off highway markets.• Project scope includes the conversion of a highly customized Oracle 11i – 11.5.10 with operations in multiple US facilities and India to a common system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Human Resources, Inventory, Discrete Manufacturing (Bills of Material, Engineering, Work In Process, Flow, Cost), Purchasing, Order Management, Release Management, Shipping Execution, Advance Pricing, Advance Supply Chain Planning, and Warehouse Management.• Worked closely with key Supply Chain and Cost subject matters in Material Operations, Manufacturing, and Cost to determine and coordinate the best in practice methods of reporting of material transactions, operational reporting of production and standardization of product cost.• Documented all business requirements onto BR100 specs• Recommended strategies for future improvements to the existing business processes and system configuration. • Setup multiple test environments to demonstrate the functionality of Oracle Inventory, Supply Chain - Bills of Material and Work in Process, and Cost Management.• Assisted in planning and preparation of requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots, Integration and UAT.• Worked with key Material Control, Manufacturing Operations and Financial users to fulfill their requirements for reporting of Material Transactions, Production Reporting and Cost Analysis, utilizing most reports out of Oracle.• Coordinated efforts for complex data cleansing and mapping from legacy systems to parent company. Show less

East Greenville, Pa

• Project scope includes the migration of customized global operations to a common ERP system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Bills of Material, Engineering, Work In Process, Purchasing, Planning, Order Management, Shipping, Advance Supply Chain Planning, Transportation & Logistics, Warehouse Management, and Product Information Management.• Key objectives would be to create process maps of the key business functions;… Show more • Project scope includes the migration of customized global operations to a common ERP system - R12 Oracle E-Business Suite including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Bills of Material, Engineering, Work In Process, Purchasing, Planning, Order Management, Shipping, Advance Supply Chain Planning, Transportation & Logistics, Warehouse Management, and Product Information Management.• Key objectives would be to create process maps of the key business functions; to identify and document pain points, inefficiencies, and key business rules for these processes; and to draw out key decision points for the future state design process.• Deliverables are Visio diagrams documenting high-level as-is process flows; detail Future Process Business Flows and documenting any possible gaps between the current as-is process to the future to-be process; documented all business requirements for the Office, Studio and Textile business units; coordinated efforts for complex data cleansing and mapping from legacy systems to parent company; and recommended strategies for future improvements to the existing business processes and system configuration. Show less

Berwyn, Pa

• Conducted a proof of concept for using Oracle Standard Cost system versus Oracle Average Cost system software to run the Engineering to Order business for a leading global manufacturer of electronic instruments. • Project scope was to augment the current user base of the Oracle eBusiness Suite in operation within the Power Instrument and Solid State Instrument business units to incorporate the Oracle 11i Release 11.5.10 Inventory, Bills of Material, Engineering, Work In Process… Show more • Conducted a proof of concept for using Oracle Standard Cost system versus Oracle Average Cost system software to run the Engineering to Order business for a leading global manufacturer of electronic instruments. • Project scope was to augment the current user base of the Oracle eBusiness Suite in operation within the Power Instrument and Solid State Instrument business units to incorporate the Oracle 11i Release 11.5.10 Inventory, Bills of Material, Engineering, Work In Process, Purchasing, Order Management, Shipping, Project Manufacturing and Cost Management Modules. The Oracle applications will replace the related legacy applications in multiple locations in the US, Scotland, United Kingdom, Mexico, and Argentina.• Performed diagnostics requirements / concept of operations and preliminary design for the Cost Management module.• Provided analysis and recommendations for Multi-org /Applications configuration and inventory locations. • Setup multiple test environments to demonstrate the functionality of Oracle Cost Management and Project Manufacturing for the Average Cost environment for the Solid State Instrument business.• Setup multiple test environments to demonstrate the functionality of Oracle Cost Management and Project Manufacturing for the Standard Cost environment for the Power Instrument business.• Documented all business requirements onto BR100 specs• Assisted in planning and preparation of Con-ops / Requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots, Integration and UAT.• Created training documentation and trained all super users at multiple Inventory Organizations.• Assisted with Data mapping and conversions of legacy data into Oracle. Show less

Fairfax, Va

• Project scope was to augment the current user base of the Oracle eBusiness Suite in operation within the Intelligence and Information System (IIS) business unit to incorporate the Oracle 11i Release 11.5.10 Inventory, Project Manufacturing and Cost Management Modules. The Inventory module will replace the related legacy inventory applications in place in Aurora, CO and Garland, TX.• Performed diagnostics requirements / concept of operations and preliminary design.• Provided analysis… Show more • Project scope was to augment the current user base of the Oracle eBusiness Suite in operation within the Intelligence and Information System (IIS) business unit to incorporate the Oracle 11i Release 11.5.10 Inventory, Project Manufacturing and Cost Management Modules. The Inventory module will replace the related legacy inventory applications in place in Aurora, CO and Garland, TX.• Performed diagnostics requirements / concept of operations and preliminary design.• Provided analysis and recommendations for Inventory Multi-org /Applications configuration and Sub-inventory locations, setups, and inventory processes. • Setup multiple test environments to demonstrate the functionality of Oracle Inventory, Projects and Average Cost between Garland and Aurora Inventory Organizations.• Documented all business requirements onto BR100 specs• Assisted in planning and preparation of Con-ops / Requirements sessions and Conference Room Pilots (CRP).• Create test plans and test scripts for Conference Room Pilots and UAT.• Created training documentation and trained all super users at multiple Inventory Organizations.• Assisted with Data mapping and conversions of legacy data into Oracle. Show less

Webster, Ny

• Conducted a proof of concept for using Oracle Discrete Manufacturing software to run the EIA Equipment business for Xerox. • Setup a test environment to demonstrate the functionality of Oracle Discrete Manufacturing using data from Xerox’s EIA Equipment business. • Demonstrated the Oracle Discrete Manufacturing Inventory, Bill of Material, Work In Process, Standard Cost, Order Management and Shipping modules for Xerox.

Glenshaw, Pa

• Completed a detail study of a Business Process Transformation and R12 ERP Vendor Selection for a Multi-country manufacturing / distribution company. The project scope was to understand and transform the company’s business processes and requirements for the functional areas – General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Inventory, Bills of Material, Engineering, Work In Process, Cost Management, Planning, Sales Order Management, Sales Force Automation, Pricing, Service… Show more • Completed a detail study of a Business Process Transformation and R12 ERP Vendor Selection for a Multi-country manufacturing / distribution company. The project scope was to understand and transform the company’s business processes and requirements for the functional areas – General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Inventory, Bills of Material, Engineering, Work In Process, Cost Management, Planning, Sales Order Management, Sales Force Automation, Pricing, Service Management, Call Center Management, Shipping, and Incentive Compensation• Select an ERP Solution that will support the company’s transformation• Create a high-level implementation plan for the ERP Solution• Performed a detail analysis complete with defining the process architecture, understanding and define the As-Is process flow, development of the To-Be process flow, define business requirements, collect vendor requirements, assess functionality and technology, and perform vendor demonstrations and make recommendation of ERP Solution Show less

Lancaster, Pennsylvania Area

• Completed a detail Oracle ERP Relational Migration Roadmap to migrate JDE and HP systems into Oracle Release 11i 11.5.9, Oracle Manufacturing and Financial applications – Oracle General Ledger, Accounts Receivable, Accounts Payable, Inventory, Bills of Material, Work In Process, Cost Management, Purchasing, Planning, Order Management, Advance Pricing, and Warehouse Management.• Performed a detail analysis complete with project plan on Training, Database Migration, Application Migration… Show more • Completed a detail Oracle ERP Relational Migration Roadmap to migrate JDE and HP systems into Oracle Release 11i 11.5.9, Oracle Manufacturing and Financial applications – Oracle General Ledger, Accounts Receivable, Accounts Payable, Inventory, Bills of Material, Work In Process, Cost Management, Purchasing, Planning, Order Management, Advance Pricing, and Warehouse Management.• Performed a detail analysis complete with project plan on Training, Database Migration, Application Migration, Testing, Transition and Project Management to migrate a JDE and HP systems into Oracle Release 11i 11.5.9, Oracle Financial and Manufacturing applications - Oracle General Ledger, Accounts Receivable, Accounts Payable, Inventory, Bills of Material, Work In Process, Cost Management, Purchasing, Planning, Order Management, Advance Pricing, and Warehouse Management• Coordinated efforts for complex data cleansing and mapping from legacy systems to parent company.• Worked with client’s hosted partner and their off shore teams to achieve objectives.• Attended weekly status meetings to discuss identified risks, issues, and resolutions.• Recommended strategies for future improvements to the existing business processes and system configuration. Show less

Bachelor Of Applied Science (B.A.Sc.), Accounting And Business/Management

Associate Of Science (A.S.), Accounting And Business/Management