Advanced SQL Data Warehouse & Business Analytics

Designed and implemented an enterprise-grade analytical relational database for executive reporting and KPI monitoring using an optimized Star Schema architecture. Transformed operational retail data into a fully normalized data warehouse structure consisting of 5+ relational tables with clearly defined primary and foreign key constraints. Developed an extensive suite of over 15 advanced SQL queries utilizing complex multi-table JOINs, subqueries, Common Table Expressions (CTEs), and conditional CASE statements to analyze profitability, customer behavior, and multi-period sales trends. Programmed reusable SQL views and dynamic stored procedures for automated KPI calculations and dashboard metrics, while performing query optimization and index tuning to ensure maximum performance and minimal latency across large datasets.