Eric Gerstein Email & Phone Number

St. Louis, Mo, Us

▪ Successfully managed 9 projects ensuring on-time delivery, achieving companywide integration. ▪ Developed Tableau stories for production scheduling, enhancing real-time updates, accuracy, and inventory management. ▪ Developed companywide employee point and PTO tracking software using Visual Basic. Automated conversion of Excel workbooks into data frames using Python and Task Scheduler. Created views in Microsoft SSMS from data frames and integrated with Tableau, enhancing visibility into current employee standings, facilitating the establishment of staffing goals. ▪ Engineered Tableau stories from Microsoft SSMS developed tables to visualize real-time inbound and outbound employee performance, identifying trends, hourly patterns, and weekly fluctuations. Using advanced SQL scripting, established production standards after removing outliers to ensure accuracy and implemented automated quarterly updates for ongoing relevance.

St. Louis, Mo, Us

▪ Companywide owner of management of change, ergonomics, and personal protective equipment. ▪ Engineered initiatives by structuring workflows, developing SOPs, and creating engineering aids, raising Fire business revenue from $60 to $120 million in a year, clearing a $35 million backlog. Managed demand planning alongside lead engineering duties, ensuring workflow efficiency. ▪ Optimized staffing levels and part allocation with weekly data analysis, and enhanced inventory management by introducing a storage quantity system and Kanban parts for supermarkets. ▪ Developed Tableau dashboards for production as well as market trend analysis in South America.

Lowell, Ar, Us

▪ Conducted weekly meetings to optimize truck mileage distribution, ensuring contract compliance. ▪ Used JMP for data analysis, with a Monte Carlo simulation for three-year driving route estimates. ▪ Developed greedy algorithms for bi-weekly tractor assignments within locations and crosslocation swaps over three-month periods. Created Visual Basic code to perform six-month, one year, and three-year simulations. Exported the results of the simulation to Power BI for further analysis and visual representation, enhancing data-driven decision making. ▪ J.B. Hunt approved the results and planned to trial the system in the Midwest before expanding.

Bridgeton, Missouri, Us

• Created process flows and work instructions for every operation on the manufacturing floor.• Performed time studies to update work rates to be more accurate.• Created a blueprint for a visual signaling two-level flow rack.• Converted every work instruction into the inventory and operator tracking software, FactoryLogix.• Reorganized and restructured the mail and print rooms to increase efficiency.• Researched and purchased various supplies needed throughout the warehouse.

Olivette, Mo, Us