- Led a team of 6 to create the logical & physical database design using STAR/Snowflake schema for a real-time retail store.
- Implemented Extract, Transform, and Load methodology using SQL Server, SSMS, and, SSIS to create/load dimension & fact tables.
- Analyzed and predicted store outcomes, trends, and forecasts, for different products, financial quarters, and geographical locations.
- Visualized results on Visual Studio, PowerBI, Tableau, SSAS, SSRS, to perform critical analysis of the store’s performance.
