Aditya Shinde

Results-driven Data Analyst and Power BI Developer with hands-on experience delivering end-to-end business intelligence solutions — from SQL-based data extraction and ETL pipeline design to interactive Power BI dashboards with advanced DAX, Star Schema modeling, and Row Level Security (RLS). Proven ability to collect, clean, and validate data from multiple sources, identify trends and KPIs, and translate complex datasets into clear, executive-level reports and visualizations. Proficient in Python (Pandas, NumPy), REST API integration, and cross-functional stakeholder reporting.

Graduating B.E.

Computer

Science (2026). Immediately available for Data Analyst or BI roles in Pune / Remote.

End-to-End Retail Business Data Analysis

(2025-12 - 2026-01)

• Architected a complete ETL data pipeline processing 5 raw business datasets (Customer, Sales, Products, Inventory, Finance) — cleaning, transforming, and modeling data for BI consumption, ensuring data accuracy, integrity, and consistency throughout.
• Wrote 15+ complex SQL queries (multi-table joins, window functions, aggregations) to extract actionable KPIs including revenue trends, inventory turnover, and customer churn patterns.
• Built a multi-page Power BI dashboard with advanced DAX measures (YoY Growth, Profit Margin %, Customer LTV), replacing hours of manual Excel work and significantly reducing reporting time for stakeholders.
• Delivered data visualizations identifying top 10% revenue-driving products and flagging underperforming inventory segments — enabling data-backed decisions aligned with business KPIs.

Live Weather Analytics Dashboard — Power BI + REST API

(2025-01 - 2025-12)

• Engineered a fully automated real-time data pipeline connecting Power BI to REST API — eliminating manual data exports and enabling live dashboard refresh with up-to-date metrics.
• Built dynamic KPI cards tracking 8 weather metrics (Temperature, Humidity, Wind Speed, UV Index, Visibility, Pressure, Precipitation) with multi-city switcher across Delhi, Mumbai, and Pune.
• Integrated Air Quality Index (AQI) with pollutant breakdowns (PM2.5, PM10, SO2, CO, O3, NO2) and a color-coded Good / Moderate / Poor gauge — improving stakeholder readability and decision support.
• Authored custom M Language transformations in Power Query to parse and normalize complex nested JSON API responses into clean tabular format ready for DAX calculations.

Sales Analytics Dashboard — Sample Superstore

(2025-01 - 2025-12)

• Designed a professional 3-page Sales Analytics report (Sales Overview, Product Analysis, Customer Analysis) mimicking real-world enterprise BI deliverables for executive stakeholder reporting.
• Built a Star Schema data model with 5 tables (1 Fact + 4 Dimensions) and created 10+ DAX measures including Total Sales, Total Profit, Profit Margin %, and Order Frequency — aligned with business KPI requirements.
• Implemented Row Level Security (RLS) for region-based access control, demonstrating enterprise data governance and security practices for multi-user BI deployments.
• Deployed 7 visual types (KPI Cards, Line/Bar Charts, Donut, Map, Treemap) to communicate trends across product categories and customer segments in a clear, concise manner.

Bachelor of Engineering (B.E.) - Computer Science & Engineering - SKN Sinhgad College of Engineering (2022-01 - 2026-12) Pandharpur, Maharashtra