Distribution Analyst
CurrentDesigned, developed and maintained performance metrics, excel tools, account profitability worksheets, automation tools, interactive forms, and reporting workbooks.Developed and presented weekly and monthly productivity reporting, with a focus on KPI targeting and trending analysis, to the Distribution Center manager, co-managers and lead staff.Action: Designed graphical reports (such as line, bar graphs and pie charts) with data extracted from SAP that measured individual and team productivity (such as picked, packed, shipped units/hr alongside errors/hr) in real time. Utilized Excel database functions, macros and VBA (Visual Basic for Applications) to modify and enhance existing macros. Performed Pareto analysis to determine root causes of processing errors. Once reports were developed, team members utilized macros to run reports independently.Results: Revolutionized Easton, Baseball, Softball (EBS's) Distribution by introducing Lean Thinking, reducing processing cost per unit by 41%.Improved on time shipping percentage from 74% to 99.99% on time.Reduced the Distribution Center’s Cost per Unit (CPU) by 30% Consistent increase in operating efficiencies and reduction in operating costs Action: Designed a daily work prioritization scheme of customer orders in Excel that interfaced with SAP and utilized advanced formulas such as vlookup, conditional and nested formulas, macros, VBA, pivot tables and graphs clearly displaying which new orders were to be processed first based on order type and quantity.Result: Saved over $1M annually in lost business.Note: First six years via Infoway Software