John Spessard
Dallas, TX *****
***********@*****.***
Summary:
Industry Experience: Manufacturing, Construction, Telecommunication, Military, Management Consulting, and Property Restoration.
Business Skillsets: Manufacturing/Production Planning, Master Scheduling (MRP I, MRP II, ERP including Oracle and SAP), Statistical Quality Control, Inventory Management, Freight Purchasing (Air/Ground, Foreign/Domestic), Metrics Implementation, Project Management, Procurement.
Professional Experience
Data Analyst: Hyphen Construction Group (2013-Present)
Create MS Exel Pivot Table Reports to analyze cash position of company, project status, and other financial related information.
Log and monitor lien notice status.
Marketing Director: Response Restoration Services (owned by Hyphen Construction Group)
Increased internet sales from 0 to $52K per quarter using social proof marketing and other internet marketing tactics.
Wrote and implemented processes
Self Employed: Various Failed Business (2003-2011)
I’ve learned I’m a worker bee not an entrepreneur.
Project Manager: Level (3) Communications (2000-2002)
Project Manager for the Los Angeles Gateway and later project manager for the Atlanta Gateway.
Managed the installation, testing, and Network Operation Center acceptance of ADM (Add Drop Multiplexors), DACS (Alcatel and Ciena), Long Distance equipment (Nortel).
Designed and managed the installation of infrastructure necessary to install DACS, ADMs, and long distance equipment. All installations were completed on or under budget.
Received highest ratings for all quarterly reviews.
Master Scheduler: Alcatel USA/ DSC Communications Inc. 1995 – 2000
Responsible for Master Scheduling for the Alcatel Access Division and special projects representing $500M in annual revenue. This included monitoring forecasts, altering production plans, minimizing stranded inventory for product lines being phased out of production, and coordinating the introduction of new product lines into production.
Ran weekly MRP II (Material Resource Planning) runs.
Project manager for 20 member international project team to transfer “Airspan” product line from UK factory to USA factory. Team consisted of development engineers, manufacturing engineers, inventory planners, shipping planners, and key purchasing management.
Personally developed multiple relational data base reports for inventory tracking, materials receipt, and sales order analysis (used MS Access). These reports decisions regarding inventory levels.
Facilitated the software implementation and testing team to install Oracle 10.7 Master Scheduling module for all USA plants.
Facilitated the international implementation team to install Oracle 10.6 Master Scheduling module in the UK and Ireland factories.
Materials Planner: Micrografx, Inc 1992-1995
Managed the forecasts and execution of the MRP (Material Requirement Planning)
Transportation Purchasing (International freight forwarding, ground, and domestic air transportation).
Responsible for purchasing printed material, CD-ROMs, freight services, and disk duplication services. Approximately $350K per year.
SAP department coordinator. Developed and implemented MRP implementation project plans. Developed and implemented PO (purchase order) approval plan.
Reduced PO (purchase order) billing disputes by 87%.
Total Quality Management (TQM) facilitator. Created and implemented random sampling plans to measure various department metrics. Inventory accuracy improved from 69% to 98.8%.
Analyze inventory usage and implemented inventory/production changes resulting in an inventory reduction from $4.5M to $1.8M.
Developed and implemented cycle count program.
Industrial Engineer: EDS (Electronic Data Systems) 1988-1991
Provided process improvement consulting services for EDS customers in the lending and insurance industries.
Project Team Leader for the GMAC Remittance Processing Center studies at the California, Michigan, and North Carolina sites.
Conducted multiple productivity improvement studies that resulted in savings of $235K.
Developed and documented customer process flows to facilitate process improvement. These studies were the foundation and prerequisite of all productivity studies.
Software Expertise
Microsoft Excel (Pivot Tables, VLOOKUP), Word, MS Access (basic), ABC Flowcharter, Visio (basic), Oracle (ERP)
Education/Certifications
Bachelor of Science in Industrial Engineering, Texas A&M University, College Station, TX, 1987.
APICS CPIM Certification, Expired (American Production & Inventory Management Society)
Total Quality Management Certification, Richland Jr. College (Statistical Quality Control)
United States Army, 1st Lieutenant