Designed transportation solutions for a chain of retail stores.- Built Python script that generates optimal delivery patterns for 1000+ stores to balance volume. Reducing resource needs and associated costs by 10%.- Optimized driver schedules with Excel VBA for 200+ delivery drivers. Automated manual scheduling process and shortened work time by 80%.- Completed transportation routing design on over 100 delivery routes and cost modeled operations with annual spending of over $50 million dollars.Re-engineered transportation solution for a wholesale auto auction company.- Used SQL to extract, filter, and clean over two million shipment data for regression analysis.- Generated insights from shipment consolidation and market rate analysis that led to 12% cost savings.

Developed tools to increase work efficiency and automate manual processes.- Standardized data reporting process with Power BI, reduced work time by 50%.- Created shipment consolidation tool using Excel VBA, which continues to generate 5%-20% potential savings across projects.- Developed mapping tool for interactive location visualization using R.

Project management and data analysis.- Managed communication with cross-functional teams to ensure successful completion of project deliverables.- Shipment data analysis on multiple transportation accounts.