Data Analyst proficient in building end-to-end BI solutions using Power BI, SQL, and Python. I specialize in designing Star Schema data models, engineering ETL pipelines, and automating reporting workflows.
My expertise spans across Power BI, SQL (PostgreSQL, MySQL), Python (Pandas, SQLAlchemy), and advanced concepts including Window Functions, Stored Procedures, and Row-Level Security (RLS).
I excel at transforming raw datasets into actionable insights through advanced visualization and complex DAX calculations. I have successfully delivered dashboards and analyses that drive business decisions and optimize operations.
From designing normalized database schemas with thousands of records to implementing complex ETL pipelines and creating interactive dashboards, I focus on data quality, performance optimization, and actionable insights.
When I'm not analyzing data or building dashboards, you'll find me exploring new data technologies and business intelligence trends.
Power BI
PostgreSQL
Python
Pandas
Excel
Tableau
NumPy
Jupyter
Insurance Premium & Payout KPI Dashboard ↗
End-to-end Power BI dashboard analyzing policy performance with Star Schema data model, complex DAX measures, and Row-Level Security for 10-year dataset across multiple dimensions.
Advanced Amazon Ecosystem Sales Analysis ↗
Normalized database schema with 9 relational tables, 21,000+ sales records, advanced SQL with Window Functions, and Stored Procedures for real-time data integrity and complex business problem solving.
Walmart Sales Data ETL Pipeline ↗
Complete ETL pipeline using Kaggle API to extract 10,000+ sales records. Data cleaning and feature engineering with Pandas, database connections with SQLAlchemy, and advanced SQL analysis for revenue insights.
Dynamic Executive Sales Dashboard ↗
Interactive Excel dashboard with dynamic toggle switches, advanced formulas (XLOOKUP, TEXTJOIN), conditional formatting, custom chart logic, and VBA Macros for seamless filtering and user experience.