Retail Supply Chain Data Warehouse & BI

•Architected enterprise data warehouse using Bronze, Silver, and Gold medallion layers; standardized data

ingestion and transformation processes for supply chain analytics

•Engineered scalable ETL pipelines with T-SQL implementing comprehensive data validation, cleansing, and

derivation of business metrics; reduced query processing time by 40%+

•Designed Star Schema with optimized fact and dimension tables enabling real-time analytical reporting on

sales, profitability, delivery performance, customer lifetime value, and product performance

•Deployed Power BI dashboards connected to Gold layer enabling stakeholders to track KPIs and drive supply

chain optimization decisions