Automated the weekly KPI reporting of the marketing team by replacing manual entry Google Sheets workflow with SQL and Python, reducing data delivery time from 12+ hours to under 2 hours enabling reviews at the start of the week. Optimized the testing strategy of AB Testing by identifying Q4 as the most effective period due to it enabling the tests to complete 62% faster due to the 26% increase in organic page views. Collaborated with cross functional teams to execute all marketing team’s data analysis and delivered timely ad-hoc analyses using SQL, Python and Excel to guide content strategy with actionable insights.

Redesigned maintenance operations based on analysis with Excel via queueing theory, implementing a new workflow that led to a 40% reduction in wait time through improved work methodology of the maintenance technicians. Created a regional quality dashboard in PowerBI for manufacturing facilities across two cities with their internal Sharepoint data records for quality and defects. Developed the first real time maintenance dashboard displayed on facility TVs visualizing technician activities and key queueing metrics to improve operational awareness for employees.

Developed the first quality department dashboard in Excel to compile and display in an easily digestible manner each customer service representatives’ performance for weekly reviews and 1-on-1s with supervisors. Determined on a weekly basis the categories in which the agents were having issues interacting with customers by reviewing a sample of calls and compiling the data into insights with Excel to identify the next training to be scheduled by visualizing notable performance gaps across multiple customer service employees.