Senior Supply Chain Business Intelligence Analyst

• Jan 2023 - Present

• Reconcile data between different tables in Snowflake to ensure accuracy of cost of goods sold.• Lead centralization of slow-moving engine parts in Louisville for seven distribution centers in US based on a 12-month demand, analyzing demand per engine part at each location using Python.• Mentor three associate analysts, training them on Excel, SQL, Tableau, and GitHub.• Created a dashboard that gives metrics such as fill, backorders, in transit, past dues, and demand.• Developed a report that shows current, past due, and backorder dollars, by item level. Show less

Service Management Analytics Lead

• Nov 2021 - Jan 2023

• Built reports and dashboards to enable visibility around repaired trucks, % of fleet down, distance traveled, service cases, and customer service using Tableau, Python, Snowflake, and SQL.• Led Six Sigma projects and automated Tableau dashboards, reducing creation time by 83%.• Wrote and edited Python scripts to automate reports, increasing efficiency by 50%.• Built and tested process to see real-time truck status updates for all 700+ dealers using SQL and API from Decisiv vendor.

Database Administrator/Technical Business Analyst

• Apr 2019 - Nov 2021

• Built out an SSRS report via SQL to forecast amount of paint and colors to mix for each set of frame rails, reducing paint usage and production time and saving $50,000 per year. • Designed a compliance dashboard using SQL and PowerBI to enable visibility on patching and version and missing database owners. • Created a stored SQL procedure to automate process of fixing broken login permissions for users, saving ~three hours per week. • Built Visual Studio packages using SSIS with processes such as ETL to merge data into data warehouse. Show less

Designated Broker

• Sep 2016 - Mar 2019

Project Coordinator

• Jun 2016 - Sep 2016

• Managed MS Teams Excel database for 100+ internal teams by using Lookups and creating pivot tables to pull and organize data. • Developed an onboarding plan and rollout timeline for 1,000+ teams to clarify team’s questions at weekly informational sessions. • Managed MS Teams Excel database for 100+ internal teams by using Lookups and creating pivot tables to pull and organize data. • Developed an onboarding plan and rollout timeline for 1,000+ teams to clarify team’s questions at weekly informational sessions.

Product Compliance Analyst

• Jul 2015 - Mar 2016

• Used SQL and Excel daily to pull contractor accuracy scores from Amazon Redshift to track contractors’ efficiency over time. • Audited and classified 10,000+ hazardous products per day to ensure compliance with DOT, ADR, and IATA regulations. • Categorized data sets pulled from multiple sources and compiled them into charts and reports for supervisors. • Used SQL and Excel daily to pull contractor accuracy scores from Amazon Redshift to track contractors’ efficiency over time. • Audited and classified 10,000+ hazardous products per day to ensure compliance with DOT, ADR, and IATA regulations. • Categorized data sets pulled from multiple sources and compiled them into charts and reports for supervisors.