Robert Erdman

Roswell, GA 404-***-**** ad4w2m@r.postjobfree.com

LinkedIn.com/in/RobertGErdman

SUMMARY

Supply Chain Analyst with success at reducing costs through trimming inventory, increasing labor efficiencies, and decreasing shipping expenses in a broad range of industries. Aligns sales forecasts with production capacity and materials availability. APICS certified CPIM. Six Sigma Black Belt with unique combination of Information Technology skills and plant floor project experience. Identifies solutions by applying operations research and statistical process control techniques.

Inventory Materials Management

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

Forecasted consumer demand in MRP for consumer healthcare company.

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

Planned and managed materials shipments to multiple offshore sites.

Logistics

Improved trans-Atlantic shipping costs by $150K annually.

Championed new purchasing system, reducing raw materials holdings by 45%.

Improved on-time order fill rates from 45% - 85%.

Process Improvement

Conducted Chi-Squared and ANOVA analysis of time-motion dataset.

Cpk and Pareto defects analysis uncovered QC issues, resulted in winning back $30M in business due to previously failed quality audit.

Designed and performed statistical audit of inventory count accuracy.

Tracked and analyzed quality defects from Chinese supplier.

Industries

Automotive

Steel Fabrication

Oil and Gas

Specialty Chemicals

Healthcare

Telecom

Technical

SAP MM.

Oracle Enterprise Business Planning (EBP).

Microsoft Office (Excel, Access, Word, Outlook, Visio)

Java, SQL, R studio, Tableau

PROFESSIONAL EXPERIENCE

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

Materials Manager

Monitor and set purchase item levels, set shop floor schedule, Forecast demand, and assist with shipping schedules.

Alcon, Atlanta, GA 08/2021-04/2022

SAP Testor/Trainer, Supply Chain 9 month contract

maintain and fix errors in SAP MRP. Monitor and fix production orders. Provide Code testing in Proton, training of users in new SAP implementation. data analytics support as needed.

Honeywell, Atlanta, GA 11/2020-4/2021

Sr Data Analyst, Supply Chain 6 month contract

Clean and maintain purchase orders in SAP. Provide data analytics support in MRP system as needed.

Cox Communications, Atlanta, GA 9/2018-7/2020

Data Analytics/Six Sigma Blackbelt 11 month contract

Conduct audit of software, process improvement initiative for hardware maintenance tickets in Network Operations Center. Data mining of network router/switch device performance and faults (Oracle and Tableau ETLs).

Publix Supermarkets, Atlanta, GA 10/2015-8/2018

Supply Chain Associate

Assist Operations Manager in forecasting, ordering and stocking purchased items. Currently training in supply chain analytics. 1. Enhanced metric for fresh and produce ontime delivery. 2. Assist in inventory audits.

3. Unload and move merchandise 4. Manage backfill and reverse logistics. 4. Set forecasts for seasonal items.

Sudbrink, LLC, Minot, ND 03/2013–11/2014

Assistant Geologist

Collected lithology samples and maintained drilling logs. Monitored gas levels and used gamma logs and rock structure to assist management in navigation of bit during drilling.

Because of prior expertise, provided technology support for databases, software, and hardware.

Randstad contract for Coca Cola Refreshments, Atlanta, GA 07/2012 – 12/2012

Supply Chain/Retail Operations Analyst (Contract)

Maintained and analyzed raw time-motion data of store merchandisers and presented findings to four workflow teams on the merchandiser optimization project. Authored standard operating procedures (SOPs) based upon best practices, created process flow diagrams, and data mined dataset for statistical variance and significance, including Chi-squared analyses and ANOVA.

Provided information that led to more efficient ways to transport, load, and stock in retail locations.

DS Waters, Atlanta, GA 02/2012 – 05/2012

Inventory Analyst (Temporary)

Performed analysis for ramp up and drawdown of inventory for changeover of beverage bottling plants.

Fulton & Douglas County Schools, Atlanta, GA. 09/2010–06/2012

Science Teacher

Taught Physical Science, Forensics, Geology, and Chemistry to at-risk children.

Pursued and received Master of Arts – Secondary Education 09/2008–08/2010

Value-Train, Atlanta, GA 08/2008–10/2008

Six Sigma Black Belt. Training and classes leading to certification.

Leggett & Platt, International Storage Systems, Covington, GA 07/2007–07/2008

Materials Manager

Directed crew of 7 purchasers, planners, and cycle counters; managed materials budget for a build-to-order storage solutions company. Prepared daily shipment, weekly shop floor completion and monthly inventory status reports.

Provided supply data for monthly S&OP meetings. Led production planning meetings with department leaders to develop capacity plan, production schedules. Coordinated quarterly physical inventory counts. Responsibility included both shop floor orders and inventory of purchased items from China and Mexico. Ensured inventory count accuracy and shipment order fill rates.

Reduced inventory by 11% while improving order fill rates from 45% to 85% by implementing new purchasing quantities from oversea providers based upon open orders. Oracle system maintenance and queries.

Improved count accuracy from mid 70% to nearly 95% by part location consolidation, resolving duplicate part numbers, better labeling and improved physical counts of inventory.

Repurposed or sold slow moving and obsolete inventory as a key member of an inventory improvement team.

Identified an accounting issue where raw materials converted to work in process were not properly costed.

Fulton County Public Schools, Atlanta, GA 09/2006–06/2007

Taught regular on-level and Advanced Placement (AP) science and math high school courses.

Various area hospitals, Atlanta, GA 10/2004–06/2006

Nuclear Medicine Technologist

Performed a wide variety of nuclear medicine scans; including cardiac, bones, gall bladder, lungs, renal, thyroids.

Other experience includes Materials and Logistics Planner for telecommunication manufacturer, Materials Manager and Supply Chain Analyst for specialty chemical manufacturer, Information Technology Supervisor of an automotive part manufacturer and Quality Control intern at automotive supplier.

Reduced raw inventory by 45% ($1.5M annually) by establishing a new forecasting procedure.

Implemented a monthly rolling forecast that provided materials to the over-seas customer on-time while reducing the shipping rate previously incurred of $750 to $85 per pallet.

Highlighted inventory turns issue and reduced inventory of raw materials by $1M annually, reduced buys, and eliminated unnecessary SKUs as a result of data mining 5 years of sales history.

Cpk and Pareto cause-of-defects analysis uncovered workstation issues that when remedied resulted in winning back $30M in business lost due to previously failed quality audit.

EDUCATION

Master of Arts – Secondary Education, Georgia State University, Atlanta, GA

Master of Science - Operations Research Case Western Reserve University, Cleveland. OH

Master of Science - Industrial Management, Georgia Institute of Technology, Atlanta, GA

Bachelor of Science - Geological Engineering, Colorado School of Mines, Golden, CO

Contact this candidate