Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sumit Kumar

Business Intelligence Engineer
Pune

Summary

Dynamic Power BI Engineer and Senior BI Analyst with over 5 years of experience in designing, developing, and deploying impactful Power BI reports and dashboards that transform complex datasets into actionable insights. Expertise includes Power BI Desktop, Power BI Service, DAX, Power Query, Azure SQL, and Snowflake, supported by a solid foundation in data modeling techniques such as star and snowflake schemas. Proven ability to collaborate with cross-functional teams to deliver high-quality analytics solutions that align with business objectives while ensuring optimal report performance and data protection. Committed to leveraging advanced visualization techniques and staying updated on industry trends in data analytics, with a strong interest in Microsoft Fabric.

Overview

5
5
years of professional experience
4
4
Certifications
1
1
Language

Work History

Senior Analyst (Power BI Lead)

Accenture Solutions Pvt Ltd
04.2024 - Current
  • Consumed data from SQL databases, Azure storage, and SharePoint for Power BI solutions.
  • Applied performance optimization techniques to ensure report efficiency.
  • Maintained technical documentation and source control in Git aligning with Microsoft Fabric deployment practices.
  • Leading BI team to deliver Power BI solutions for a US Utilities client, ensuring stakeholder needs are met.
  • Designed & optimized data models and implemented RLS & dynamic RLS.
  • Developed advanced Power BI reports with DAX calculations.
  • Built ETL pipelines using Azure Data Factory & Databricks.
  • Enforced best practices in Power BI development.
  • Acted as Scrum Master managing Agile ceremonies.
  • Mentored junior developers on Power BI and data pipeline best practices.
  • Collaborated with product management to prioritize Power BI delivery and improvements.
  • Applied innovative visualization techniques (bookmarks, drill-through, tooltips) to communicate analytics.

Analyst

Tredence Analytics Solutions Pvt Ltd
04.2022 - 02.2024
  • Designed & deployed Power BI dashboards for Kimberly Clark (CPG domain).
  • Implemented RLS, DAX calculations, and optimized data models.
  • Automated refresh schedules using Power Automate.
  • Integrated ADF pipelines with Snowflake for reporting.
  • Achieved 60% cost reduction in Power BI Service.

Sr. Product Compliance Associate

Amazon
02.2022 - 04.2022
  • Built Power BI reports to monitor compliance violations across multiple markets.
  • Applied SQL and Power Query for extracting and analyzing datasets.
  • Automated tracking of unauthorized listings, ensuring accuracy & compliance.

Operation Support Specialist

Citicorp Services India Pvt Ltd
03.2021 - 02.2022
  • Created Power BI & Excel reports to track fraud & security cases.
  • Automated fraud detection reporting, preventing $60K+ losses.
  • Worked with different divisions and channels to track down the fraud happened on Card.

Education

B.Tech - Electronics and Communication Engineering

Lovely Professional University
01.2020

Skills

  • Power BI Desktop & Service Power Query DAX Power Automate PowerApps Advanced Excel
  • Azure SQL Azure Data Factory Databricks (PySpark) SQL M Language Oracle SQL Developer Snowflake
  • ETL Development Data Modeling (Star & Snowflake Schema) Row-Level Security (RLS & Dynamic RLS)
  • Version Control: GIT CI/CD with Harness Agile-Scrum
  • Programming: Python (for data transformation & integration in BI)
  • CPG Finance Healthcare Retail
  • Microsoft Fabric SharePoint Data Protection Principles Statistical Analysis

Certification

Microsoft Power BI – Desktop & Service (Udemy)

Timeline

Senior Analyst (Power BI Lead)

Accenture Solutions Pvt Ltd
04.2024 - Current

Analyst

Tredence Analytics Solutions Pvt Ltd
04.2022 - 02.2024

Sr. Product Compliance Associate

Amazon
02.2022 - 04.2022

Operation Support Specialist

Citicorp Services India Pvt Ltd
03.2021 - 02.2022

B.Tech - Electronics and Communication Engineering

Lovely Professional University

Similar Profiles

CREATE PROFILE
Sumit KumarBusiness Intelligence Engineer