Delivered a fully functional order tracking and visualization dashboard for Moderna within a 20-day deadline. Replaced inaccurate flat-table reporting with interactive Tableau dashboards showing KPIs for orders, deliveries, unique customers, and order aging over time. Identified and fixed duplicate records and incorrect SQL queries, improving data accuracy and reliability. Provided stakeholders with clear visibility into year-over-year and month-over-month trends, enabling faster, data-driven decision-making.
Project Overview
Challenges & Solutions
Challenges
Twenty-day deadline to design and deploy a full order tracking and visualization system
Existing flat-table reporting lacked KPIs and trend analysis
Data quality issues including duplicate records and incorrect SQL query logic
Need for accurate, real-time tracking of orders, deliveries, and unique customers
Required integration with MS SQL and a user-friendly interface for non-technical users
Solutions
Conducted rapid requirements gathering with Moderna stakeholders
Audited existing datasets to identify and resolve duplicates and query errors
Redesigned SQL queries for accuracy and efficiency
Built interactive Tableau dashboards with KPIs for orders, deliveries, unique customers, and order aging
Established secure, reliable integration with MS SQL
Validated compliance with privacy and cybersecurity teams before go-live