Explore my data analytics projects showcasing SQL Server, Microsoft Fabric, Power BI, and modern data architecture.
SQL Server → Microsoft Fabric
Complete data platform migration implementing Medallion Architecture (Bronze/Silver/Gold) with automated ETL pipelines, managing 2,000+ transactions and 2 years of historical data.
Part of Flower Shop Platform
Implemented RFM (Recency, Frequency, Monetary) analysis to segment 500 customers into 5 distinct behavioral groups, enabling targeted marketing strategies.
Power BI Direct Lake
Real-time sales dashboard using Power BI Direct Lake mode, featuring revenue trends, product performance, and KPI tracking across 2 years of business operations.
Fabric Data Pipelines
Designed and implemented automated ETL pipeline with Bronze/Silver/Gold data layers, using PySpark transformations and Delta Lake for efficient data processing.
SQL Server Tuning
Optimized SQL Server database performance through strategic indexing, query optimization, and stored procedure implementation, improving query response times significantly.
Operational Metrics & KPIs
Built comprehensive delivery operations dashboard tracking success rates, delivery times, driver performance, and operational efficiency across 1,500+ deliveries.
Throughout these projects, I've gained hands-on experience with modern data technologies and best practices in analytics and data engineering.
Database design, T-SQL, stored procedures, optimization
Lakehouses, data pipelines, Delta Lake, OneLake
Dashboard design, DAX, Direct Lake, semantic models
Data transformations, ETL, notebooks, automation
Medallion pattern, data modeling, warehouse design
Customer segmentation, KPIs, trend analysis, insights
I'm actively seeking data analyst opportunities where I can apply these skills.
Get in Touch