Shweta Dhavale
Senior Power BI / BI Developer
Pune
Summary
Results-driven Senior Power BI / BI Developer with 8 years of experience delivering data-driven BI solutions using Power BI, SQL, Snowflake, Tableau, and SSIS in financial and business sectors. Specializes in creating interactive dashboards, developing DAX measures, optimizing SQL performance, and automating reporting processes.
Overview
4
4
Certifications
8
8
years of professional experience
Work History
Senior Power BI / BI Developer
Accenture
08.2023 - Current
- Collaborated with stakeholders to gather business requirements and deliver interactive Power BI dashboards with 12+ KPIs, enabling self-service reporting using dynamic filters and slicers, reducing manual reporting effort by ~90%.
- Designed and developed enterprise-grade Power BI and Tableau dashboards for financial and retirement analytics, enabling executive reporting and business performance monitoring.
- Optimized SQL queries, hierarchical logic, and backend data models across Snowflake and MS SQL Server, improving report performance and reducing execution time by 65% across 50+ enterprise reports.
- Managed data integration and transformation processes across Snowflake, Salesforce, and SQL Server using SQL and Power BI dataflows, validating and reconciling data to ensure reporting accuracy.
- Developed semantic data models, DAX measures, calculated fields, and interactive visualizations, enhancing reporting flexibility and user experience.
- Optimised data cleansing, query performance, and transformation logic, leveraging indexing to support scalable BI reporting.
- Authored TDDs, FRDs, and data lineage documentation using Confluence and Snowflake.
- Worked in Agile environments and contributed to innovation initiatives (IDEAthon) and knowledge-sharing sessions.
SQL / BI Developer
Zensar Technologies
03.2022 - 08.2023
- Developed and maintained SQL database objects including tables, views, stored procedures, and functions to support SAFE regulatory reporting and business analytics.
- Optimized SQL queries, tuned performance, and validated data in MS SQL Server to enhance reporting accuracy.
- Automated data refresh processes with SQL Server Agent jobs to ensure timely availability of data.
- Designed and delivered Power BI dashboards for operational reporting and KPI visualization.
- Managed code deployment and version control using Azure DevOps and GitHub.
- Earned client appreciation for delivering critical contributions to Netherlands SAFE regulatory reporting project.
SQL & Power BI Developer
KPMG
06.2021 - 03.2022
- Designed and developed interactive Power BI dashboards using DAX, optimized data models, and KPI reporting.
- Optimized Power BI performance by refining measures and improving visuals.
- Enhanced dashboard interactivity by implementing drill-through, drill-down, and synchronized slicers.
- Developed and maintained SSIS ETL packages for efficient data extraction, transformation, and loading.
SQL & BI Developer
Bajaj FinServ Ltd.
10.2019 - 06.2021
- Developed BI and reporting solutions using MS SQL Server and SSRS to enhance data visibility.
- Optimized SQL queries and stored procedures, resulting in faster reporting performance.
- Integrated sales, customer, and clickstream data to enable unified analytics across platforms.
- Built real-time conversion funnel reports, improving email campaign conversion from 4% to 12%.
Trainee Engineer (SQL & Power BI)
Rainbow InfoTech
08.2018 - 10.2019
- Developed SQL and BI reporting solutions that facilitated data-driven decision-making across multiple client projects.
- Designed database objects, schemas, indexes, and views to enhance reporting efficiency.
- Performed ETL and data validation to ensure data accuracy from diverse sources.
- Published and maintained secure Tableau dashboards.
Education
B.E. - Computer Engineering
Zeal College of Engineering
Pune01-2018
HSC - undefined
Abasaheb Garware College
Pune01-2014
Skills
Power BI
Power BI platform
DAX
Power Query
Data modelling
SQL
T-SQL
MS SQL Server
SSIS
Data Extraction
Data warehousing
Snowflake
Tableau
Performance Optimization
Query tuning
Report optimization
Azure DevOps
Azure Repos
Git
Certification
Microsoft Certified: Power BI Data Analyst Associate (DA-100)
Timeline
Senior Power BI / BI Developer
Accenture
08.2023 - Current
SQL / BI Developer
Zensar Technologies
03.2022 - 08.2023
SQL & Power BI Developer
KPMG
06.2021 - 03.2022
SQL & BI Developer
Bajaj FinServ Ltd.
10.2019 - 06.2021
Trainee Engineer (SQL & Power BI)
Rainbow InfoTech
08.2018 - 10.2019
HSC - undefined
Abasaheb Garware College
B.E. - Computer Engineering
Zeal College of Engineering