End-to-end sales pipeline using Medallion Architecture. Transformed messy CRM & ERP data into actionable business insights using SQL Server and Excel.
This project builds a complete SQL Server data warehouse using the Medallion Architecture, transforming 6 fragmented CRM/ERP source files (75,000+ raw records) into a clean, analytics-ready Star Schema. Using that warehouse, I analyzed $29.35M in revenue across 18,484 customers to uncover concrete business insights — from a near-total revenue dependency on two bike product lines, to a bimodal dead-stock pattern signaling planned product discontinuation — each backed by a specific, actionable recommendation.