Power BI Developer and Data Analyst - SQL & BI Reporting

SUNIL PARDESHI

Power BI Developer Data Analyst SQL & BI Reporting

Pune, India

+91-888**-***** *******************@*****.***

linkedin.com/in/sunilp2025

PROFESSIONAL SUMMARY

Power BI Developer and Data Analyst with 4+ years of experience in Power BI, SQL, and BI reporting across FMCG, Sales, Banking, and Finance domains. Strong expertise in data modeling, DAX, Power Query, and SQL performance optimization. Hands-on experience working with Snowflake and SSIS-based ETL pipelines, and exposure to Azure data ecosystem. Proven ability to build scalable dashboards that support business decision-making and reduce manual reporting.

CORE SKILLS

Business Intelligence & Visualization

Power BI Desktop & Power BI Service

Power Query (Data Cleaning & Transformation)

DAX (CALCULATE, SUMX, FILTER, Time Intelligence)

Data Modeling (Star Schema, Fact & Dimension tables)

Row Level Security (RLS)

Scheduled Refresh & Performance Optimization

SQL & Data Engineering

SQL Server, T-SQL

Joins, CTEs, Subqueries, Window Functions

Views, Stored Procedures

Query Optimization & Indexing

ETL using SSIS

Snowflake (Data Loading, Analytics & Reporting)

Azure & Power Platform (Exposure)

Azure Data Factory: Understanding of pipelines, datasets, and linked services

Worked with datasets sourced from ADF-managed pipelines

Power Apps & Power Automate: Basic awareness and integration understanding with Power BI

Other Tools

Advanced Excel (Pivot Tables, Power Query)

Python (Pandas – basic)

PROFESSIONAL EXPERIENCE

Power BI Developer

Cherise India Pvt. Ltd. – Pune

Dec 2023 – Mar 2025

Designed and deployed Power BI dashboards for sales, inventory, and operations, reducing manual reporting by 30%

Built Sales Performance Dashboards tracking CAC, CPL, ROI, MTD/YTD/MoM metrics

Performed data cleaning and transformation using Power Query

Created optimized SQL queries for reporting datasets

Collaborated with business stakeholders for KPI definition and dashboard validation

Supported scheduled data refreshes and handled large datasets efficiently

Power BI Developer (Sales & Banking Domain)

Unistar Softech Pvt. Ltd.

May 2022 – Nov 2023

Developed Power BI dashboards for sales, revenue, and banking KPIs

Worked with Snowflake for analytics and reporting consumption

Built SQL-based ETL logic and automated data flows using SSIS

Optimized SQL queries to improve dashboard performance

Delivered dashboards handling 50K+ records with daily refresh cycles

Power BI Developer (Finance Domain)

Unistar Softech Pvt. Ltd.

Dec 2019 – Jan 2022

Designed SQL-driven ETL pipelines for financial reporting

Built 10+ Power BI dashboards for branch performance and revenue tracking

Implemented star schema data models for reporting efficiency

Reduced reporting effort by 35% through dashboard automation

KEY PROJECTS

Sales Performance Dashboard

Tools: Power BI, SQL Server, Snowflake

KPIs: CAC, CPL, ROI, Revenue, Growth Trends

Features: MoM / YTD analysis, interactive filters, optimized DAX measures

Inventory & Admin Dashboard

Tracked real-time stock, inward/outward movement

Helped operations teams reduce stock mismatches

Banking & Finance Dashboards

Branch KPIs, revenue tracking, risk indicators

End-to-end SQL + Power BI based analytics

EDUCATION

MCA – Dr. Babasaheb Ambedkar Marathwada University: 6.4 CGPA

BCS – Dr. Babasaheb Ambedkar Marathwada University: 64%

HSC – Millind College of Science, Aurangabad (Sambhajinagar

SSC – Janta Vidyalaya, Yeola, Nashik

LANGUAGES

English Hindi Marathi

Contact this candidate