Curriculum Vitae: Roy M. Hildestad

Profile

Senior Implementation Consultant

• Document Business Requirements
• Design Solution (Functional and Technical)
• Plan projects, develop statement of work, estimate budget
• Manage implementation project teams

 

Functional / Management Expertise
Project Mgmt	Distribution	Manufacturing	Business Process Analysis
Sales Orders/Invoicing	Shipping	DRP	MRP
Items and Product Structures	Routings/Formulas	Costing	Quality Assurance
Inventory	Forecasting	EDI/EMT	Purchasing
Adv. Repetitive	System Interfaces
Technical Expertise
Progress 4GL SQL	C++ Perl	XML, HTML Php, .Net, Java	Unix Scripting Linux Scripting
Vertical Expertise
Life Sciences	Electronics / Industrial Manufacturing	Food and Beverage	Consumer Products
Languages N = Native, F = Fluent, I = Intermediate, B = Basic spoken, R = Read and understand
English – N	French – F	Spanish – B	Italian – B
German – R	Japanese – R
Certifications
QAD Distribution

 

Recent Projects

Project Manager –Johnson & Johnson, Invensys, Mark Anthony Grp, Tex-Tube

• Managed software upgrades, new implementations
• Designed and managed development of custom subsystems

 

Johnson & Johnson: Alza Pharmaceuticals – Innovative drugs delivery technology

Lead consultant for implementation of MfgPro for inventory control and work order processing at the research center.  (Eliminated manual data transfer between systems, improved inventory accuracy, cut cost of setting up test runs by 50%)

 

Invensys – Semi-conductor Fab

Lead consultant for implementation of MfgPro for distribution, purchasing, inventory, manufacturing and financials.  (Cut monthly financial close from 2 weeks to 3 days, introduced MRP, streamlined quote-to-cash and purchase-to-pay cycles.)

 

Mark Anthony Group – beverage importer, distributor, and wine maker

MAG is the largest alcoholic beverage importer and distributor in western Canada. 

Managed implementation of MfgPro eB2 using ‘domains’ to support financial separation of subsidiaries.

Designed interfaces to POS systems and distributors.

Designed global inventory strategy to track lots by age from raw material receipt to 3rd party retail sale.

 Benefits: Introduced a new level of inventory control requiring half the previous staff, eliminated manual data transfer, installed low-cost warehouse bar-coding system replacing manual shipping doc preparation, reduced financial close time and finance staffing requirements, eliminated IT cost of managing multiple business systems.

 

Tex-Tube – steel pipe manufacturer

Implemented eB2 to support multiple independent business units.

Designed customizations to support palleting and material certification documents.

Designed an implementation of true commodity-based Average Costing to meet financial auditor’s reqm’ts.

Benefits: Upgraded key reports, eliminated Baan system and consulting support cost in sales business unit, developed automated subcontract manufacturing processes, isolated company P/L from short-term commodity and scrap cost fluctuations.

Implementation Consulting – Dacor, Black & Decker, Amvac Chemical

• Performed business process analysis
• Implemented standard and custom functionality to meet requirements
• Trained users and IT staff

 

Dacor – high-end kitchen appliance manufacturer

Performed full business process analysis and solution design

Designed bar-coded Distribution Order implementation integrated with Advance Repetitive.

Designed real-time n-level, parameter-driven back-flush for Advance Repetitive.

Developed Lean Replenishment algorithm for national distribution centers.

Benefits: Elimination of plant to warehouse transfer data entry and inventory errors, 20% reduction in excess parts inventory, replacement of work order documents with Advanced Repetitive cutting production record keeping by 90%, reduced stock-outs at distribution centers.

 

Amvac Chemical – organic chemical manfacturer

Developed true commodity-based Average Costing to meet industry accounting standards.

Eliminated previous spreadsheet-based manual process.

 

Black & Decker – tool manufacturer

Designed re-implementation of Purchasing module.

Benefits: Full support of the multi-dimensional chart of approval structure.

 

Global Strategy Architect – Avery-Dennison, FEI, Schlumberger

• Consulted to IT Departments at multi-national customers.
• Designed global application and infrastructure architecture for Distribution systems.

 

Avery-Dennison – Office Supplies Manufacturing and Distribution

Appointed as the MfgPro functional expert to the multi-national design team for interfacing the IBM WebSphere e-Business portal with QAD’s DOM (Distributed Order Mgmt) and MfgPro.

 

Wrote both technical and functional design documents for the DOM and MfgPro components of this integration.

 

FEI – Electron Microscope Manufacturer for Intel and major semi-conductor fabs

 

Lead the global business solution design project for the FEI upgrade and reimplementation of MfgPro from version 8.6 to EB2.

 

Effort covered 3 large, loosely-coupled manufacturing business units in the US, Netherlands and Czech Republic, and 12 sales offices in ASIA/PAC, EMEA, and AMER.  Separate regional QAD consulting teams performed local business process analysis and solution design drafts.  The regional studies where harmonized and combined to produce a fully documented solution and project plan for FEI globally.

 

The project required design and development of custom integration of BOM/Routings with Engineering systems as well as custom automated data integration between ‘domains’ in the MfgPro DB.

 

Schlumberger – Oil Field Exporation Services Company

 

After the acquisition of all major drill-bit manufacturers in Houston, my team converted all the acquired firms to MfgPro in a back-to-back series of high-speed implementations.

 

Personally delivered all Quote-To-Cash, Purchasing, Inventory and MRP process training.

 

 

Relevant Work History

Implementation Consultant – QAD, 1999-2009

• MfgPro Implementation and Project Management for QAD customers

IT Managment – QAD – 1998-1999

• Manage internal IT groups and global projects
• Example: global implementation of Microsoft SMS

Operations Management – QAD – 1994 to 1998

• Manager of Distribution Department including:
  • Maintenance Billing
  • Software CD Production
  • Global Order Fulfillment and Shipping
  • Inventory: Documentation, Marketing material, software
  • On-Demand Printing facility and service
• Note: QAD grew from $40M to $150M during my tenure in this position requiring redesign of all processes and upgrading of all equipment.

Software Architect – Flow General – 1990 to 1994

• Design and Develop special-purpose software languages
• Design and Develop custom large database applications

Programmer – General Research – 1980 to 1990

• Application and Operating System programming
  • c++, c, FORTRAN
  • 8086 assembler
  • CDC Assembler

 

Education

Westmont College, B.A. Psychology, Statistics

Patents

US 10,053,854 Beam Connector for Arch Structure, 2018.

ZL 201780032653X (Grant No. CN 109196173 B) Beam Connector for Arch Structure, 2020.