Jyotirmayi Patil

Power BI and ETL Developer

Pune 4+ yrs exp 90 · Outstanding

About

Data professional with 4.8 years of expertise in data analysis, SQL-based data modeling, and Power BI dashboard development. Demonstrated ability to transform raw business data into actionable insights using DAX-driven reports and Power Query. Proficient in Python and ETL processes (Informatica, AWS), ensuring efficient data extraction and stakeholder reporting. Skilled in data quality validation, root cause analysis, and designing Star and Snowflake schemas to enhance descriptive analytics and support strategic business decisions. Adept at leveraging technical and analytical skills to drive data-driven growth and operational excellence.

Skills & Expertise (17)

Power BI Advanced

8.4/10

4.8

Years Exp

Data Visualization Advanced

8.4/10

4.8

Years Exp

Data Modeling Advanced

8.2/10

4.8

Years Exp

Power Query Advanced

8.0/10

4.8

Years Exp

ETL Advanced

8.0/10

4.8

Years Exp

SQL Advanced

8.0/10

4.8

Years Exp

DAX Advanced

8.0/10

4.8

Years Exp

Advanced SQL Queries Advanced

8.0/10

4.8

Years Exp

Data Analytics Advanced

7.8/10

4.8

Years Exp

Healthcare Analytics Intermediate

7.5/10

4.8

Years Exp

Data Analysis Intermediate

7.5/10

4.8

Years Exp

Python Intermediate

7.0/10

4.8

Years Exp

Root Cause Analysis Intermediate

7.0/10

4.8

Years Exp

Teradata Intermediate

6.5/10

4.8

Years Exp

AWS Intermediate

6.5/10

4.8

Years Exp

Visualization RCA

Work Experience

Power BI and ETL Developer

Tata Consultancy Services (TCS)

Dec 2021 - Present

Migrated 25+ legacy TIBCO Spotfire dashboards to Power BI, improving report load time by 30% and enhancing usability for 100+ enterprise business users. Designed scalable Star and Snowflake data models and built advanced DAX measures to accurately surface cross-functional KPIs and business trends for the healthcare domain. Accelerated report refresh cycles by optimizing Power Query transformations and deploying refined incremental data refresh strategies. Partnered directly with business stakeholders and QA teams to gather reporting requirements, coordinate UAT cycles, and ensure 100% compliant production rollouts. Supported ETL processes using Informatica PowerCenter, assisting with mapping design, workflow scheduling, and data quality monitoring to ensure accurate reporting. Supported data validation, reconciliation, and ad-hoc business analysis by utilizing Python scripts and standard SQL queries within Teradata environments. Conducted root cause analysis on data incidents, optimizing incident management and reducing SLA breaches by 25% over a 6-month period. Navigated cloud-based reporting pipelines, gaining exposure to data staging and processing workflows within AWS environments (S3, EC2).