Portfolio

Retail Store Consulting Project Link

Created 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 & analyzed store performance using Visual Studio, PowerBI, Tableau, SSAS, SSRS.

Built robust scripts & performed Galera clustering for EC2 server infra using MariaDB to handle customer data.
Implemented ETL, views, indexes, DML, DDL, Stored Procedures, JSON objects, CI/CD pipelines, Triggers & complex queries on the server using SQL & Python to optimize database functionality.
Optimized code on a key-value DynamoDB database to improve consistency & reliability w.r.t. data structures

Created Data Structures for a retail organization down to 1NF, 2NF, 3NF normalizations.
Developed and executed Python Scripts with Pandas, Seaborn, MatPlotLib libraries to manipulate, optimize, and visualize insights.
Generated Data-driven actionable recommendations for the organization to improve operations and profits.