Supply Chain Data Analytics

Robert Erdman

Atlanta, GA ***** 404-***-****

*********@*****.*** Linkedin.com/in/RobertGErdman

Supply Chain Analyst with success at reducing costs through trimming inventory, increasing labor efficiencies, and decreasing shipping expenses in several industries. Experience aligning sales forecasts with production capacity and materials availability. APICS certified CPIM, Six sigma black belt with combination of data analytics and plant floor experience. Trained in quality control (SPC) and Operations Research.

Skills Matrix:

Inventory/Materials Management:

Reduced inventory levels by 11%, savings of $1.5M annually at steel fabrication plant.

Forecasted demand in MRP system for consumer healthcare company.

Decreased raw materials by $1M, trimming SKUs and improving inventory turns at chemicals plant.

Championed hew purchasing system, reducing raw material holdings by 45%.

Logistics:

Improved trans-Atlantic shipping costs by $150k annually by converting from air to fast marine lanes.

Managed shipping/receiving team of 13 individuals.

Improved order fill rates from 45 to 85% by forecasting raw materials and production schedules.

Process Improvement:

Conducted time-motion study of plant floor labor capacity.

Ran Cpk and Pareto defects analysis for machine operations, helping to win back $30M of lost business.

Designed and performed statistical audit of inventory count accuracy.

Tracked and analyzed quality defects from overseas supplier, resulting in corporate action.

Industries Served:

Automotive Steel Fabrication Oil & Gas Specialty Chemicals Healthcare Telecom

Technical Skills:

SAP MM. Syspro MRP.

Oracle Enterprise Planning (EBP)

Proficient in SQL, Java, R, Tableau, Power BI. Microsoft SQL developer certificate.

APICS CPIM, Six Sigma Black Belt.

Employment History:

SPP Pumps, Norcross, GA 10/2022-02/2024

Materials Manager

Monitored and set purchased item stock levels, recommended shop floor schedules for shop managers, and assisted with shipping schedules. Conducted projects to reduce $300 k in unnecessary purchases, and to monitor consigned (customer-supplied) parts for custom products.

Alcon, Johns Creek, GA 2021-2022

SAP tester/trainer, 9 month contract

Logged and fixed errors in SAP MRP. Monitored production orders, trained users in new system. Tested code using Proton tool, and provided data analytics as needed.

Honeywell, Atlanta, GA 2020-2021

Sr. Data Analyst, Supply Chain, 6 month contract

Cleaned and maintained purchase orders in SAP. Uncovered pricing fraud in European field office. Provided data analytics as needed.

Cox Communications, Atlanta, GA 2018-2020

Data Analytics/Process Improvement Engineer, 11 month contract.

Conducted audit of software, root cause analysis of hardware maintenance tickets in network operations center. Undertook data mining of network router/switch device degradation and faults. Additional cyber security analysis of unauthorized IPs on network, passed along to security for further investigation.

Publix Supermarkets, Atlanta, GA 2015-2018

Supply Chain Associate

Assisted manager in forecasting, ordering and stocking purchased items. Trained in analytics. Enhanced metrics for fresh and produce on-time delivery. Assisted in inventory audits. Unloaded and moved merchandise. Set forecast for seasonal items.

Sudbrink, LLC, Minot, ND. 2013-2014

Assistant Geologist

Collected and logged lithology samples, and maintained Gamma logs. Used gamma logs and structure to assist geo-steering during drilling. Due to prior expertise, provided computer hardware and database support as needed.

Coca Cola, Atlanta, GA 2012-2012

Supply Chain/Retail Merchandising Analyst, 6 month contract.

Wrote SOP work procedures for store merchandisers. Analyzed raw time-motion data for four store workflow teams. Data mined dataset for statistical root causes. This led to more efficient ways to transport and move stock in retail locations.

Other Experience:

Materials and Logistics Planner for telecom manufacturer

Materials Manager & Supply Chain Analyst for specialty chemicals co.

IT supervisor for tier 2 automotive supplier.

QC intern for automotive supplier.

Highlights:

Reduced raw materials by 45% ($1.5M annually) by new forecasting procedure.

Implemented a monthly rolling forecast that provided on-time materials to overseas customer while reducing shipping costs from $750 to $85 per pallet. Highlighted inventory turns problem and reduced inventory of raw materials by $1M annually. Implemented and conducted QC audit that won a back a lost customer worth $30M.

Education:

Master of Science – Operations Research Case Western Reserve University

Master of Science – Industrial Management Georgia Institute of Technology

Bachelor of Science – Geological Engineering Colorado School of Mines

Contact this candidate