Sakshi Pagar

Data Analyst

Pune, Maharashtra $100/hr Remote Full-time 1+ yrs exp 88 · Excellent

About

Results-driven Data Analyst with 1.5 years of experience across SQL development, Power BI dashboard design, Python-based data analysis, and Advanced Excel automation. Skilled in building scalable Star Schema data models, writing optimized SQL queries (joins, CTEs, window functions, stored procedures, triggers), and designing DAX-driven Power BI dashboards with 40+ KPI measures. Proven ability to turn raw business data into actionable insights that support Finance, Operations, Marketing, and Leadership decision-making, while automating recurring reporting workflows to reduce manual effort.

Skills & Expertise (34)

Power BI Desktop Advanced

8.5/10

1.5

Years Exp

Power Pivot Advanced

8.0/10

1.5

Years Exp

Pivot Tables Advanced

8.0/10

1.5

Years Exp

Advanced Excel Advanced

8.0/10

1.5

Years Exp

Star Schema Modeling Advanced

8.0/10

1.5

Years Exp

Power Query Advanced

8.0/10

1.5

Years Exp

DAX Advanced

8.0/10

1.5

Years Exp

SQL Intermediate

7.5/10

1.5

Years Exp

Bookmarks Intermediate

7.5/10

1.5

Years Exp

Drill-through Intermediate

7.5/10

1.5

Years Exp

Row-Level Security Intermediate

7.5/10

1.5

Years Exp

Data Cleansing Intermediate

7.5/10

1.5

Years Exp

Report Automation Intermediate

7.5/10

1.5

Years Exp

Business requirement analysis Intermediate

7.0/10

1.5

Years Exp

Views Intermediate

7.0/10

1.5

Years Exp

Window Functions Intermediate

7.0/10

1.5

Years Exp

CTEs Intermediate

7.0/10

1.5

Years Exp

Subqueries Intermediate

7.0/10

1.5

Years Exp

USERELATIONSHIP Intermediate

7.0/10

1.5

Years Exp

Python Intermediate

7.0/10

1.5

Years Exp

Pandas Intermediate

7.0/10

1.5

Years Exp

Data Validation Intermediate

7.0/10

1.5

Years Exp

Macros Intermediate

7.0/10

1.5

Years Exp

Joins Intermediate

7.0/10

1.5

Years Exp

Stakeholder Reporting Intermediate

7.0/10

1.5

Years Exp

VBA Intermediate

7.0/10

1.5

Years Exp

MySql Intermediate

6.5/10

1.5

Years Exp

Matplotlib Intermediate

6.5/10

1.5

Years Exp

NumPy Intermediate

6.5/10

1.5

Years Exp

Triggers Intermediate

6.5/10

1.5

Years Exp

Stored Procedures Intermediate

6.5/10

1.5

Years Exp

Temporary tables Intermediate

6.5/10

1.5

Years Exp

SQL Server Intermediate

6.5/10

1.5

Years Exp

Data Analysis & Visualisation

Work Experience

Data Analyst

Mobicool Software Solutions Private Limited

May 2025 - Present

Designed and developed interactive Power BI dashboards with optimized Star Schema data models and DAX measures to track business KPIs across sales, operations, and customer performance. Wrote and optimized complex SQL queries (joins, subqueries, CTEs, window functions, stored procedures, views, triggers) to improve data retrieval efficiency and support business reporting. Performed end-to-end ETL operations using Power Query, SQL, and Python (Pandas) to clean, transform, and load data from multiple sources. Automated recurring reports and workflows using Advanced Excel, Power Pivot, and VBA, reducing manual reporting effort. Built fact-dimension data models (Star Schema) with dynamic date tables for scalable, high-performance reporting. Implemented Row-Level Security (RLS), drill-through, bookmarks, and dynamic titles to deliver stakeholder-specific, interactive dashboards. Conducted data validation, cleansing, and reconciliation to ensure accuracy and consistency across reports. Applied performance-optimization techniques to SQL queries and Power BI reports to reduce load times.