Columbus, Ohio, United States
• Led a year long project team of 5 analysts, implementing digital performance boards at 15+ sites in the Ecom Sector • Supported the integration of a Machine Learning Cycle Count Model that assigns predictive error rates to locations into the site’s WMS system & visualize results • Developed sector level PowerBI reporting for the executive team that visualizes sites’ monthly & weekly performance • Provided predictive staffing plans and building capacities to site leadership by leveraging scenario planning of forecasting, production rates, and volume profile assumptions • Performed ad hoc data analysis and collaborated with operational leaders, systems, finance, inventory, labor management, and Locus Robotics teams to support the business • Trained and mentored new analysts while supporting the startup of 2 new sites within the same customer network
• Built the analytics & reporting structure for the startup of a new customer and 555k sq. ft. warehouse • Designed 10+ PowerBI Reports, labor planning tool, and efficiency reporting to support the operation of 500 associates and 20 million outbound units annually • Queried SQL reports from the Manhattan WMS system to analyze operational performance and processes • Created and maintained dim and fact tables that stored 100k+ rows of operational data in an Azure datamart
• Identified and explored new ways to improve the course: Business Analytics: Data Mgmt. & Descriptive Analysis • Recommended and designed activities/assignments to enhance student learning • Supported professor in grading assignments and offering feedback to students
• Designed a Tableau dashboard that provided visibility and insights for Honda’s supplier visits and activities • Programmed Excel VBA solutions to automate the tracking of employee training compliance and budgeting reports • Collaborated with associates and leveraged data tools to provide more efficient and automated business solutions
• Developed a monthly report in Spotfire, for the executive team, that highlighted key supply chain metrics, trends, and project initiatives for each strategic customer • Analyzed customer ordering patterns and behaviors to identify case pick inefficiencies (estimated annual cost savings of $300,000) • Built an interactive dashboard in Spotfire to simulate the different cost impact scenarios when changing the TI/HI’s for items to reduce case pick
• Communicated efficiently and effectively to guests and staff in a professional manner, responding to customer inquiries and resolving customer problems • Promoted current and future activities and offerings across the YMCA • Performed administrative duties: answering phone calls, registering guests, handling cash, preparing reports • Improved day-to-day desk operations through implementing new procedures and continuous organization