Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Amar Nath Bharti

Pune

Summary

Data Analyst with four years of experience in SQL, Power BI, Python, and Excel, specializing in data analytics, automation, and business intelligence. Skilled in developing interactive dashboards, automating reporting pipelines, and delivering actionable insights that drive business decisions. Proven track record in improving data accuracy, reporting efficiency, and KPI tracking for enterprise clients. Experienced in ETL design, Azure integration, and metrics governance.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Senior Analyst

Capgemini
Pune
10.2021 - Current

GE Vernova, Senior Analyst|Aug. 2023 – Present

  • Designed and deployed 10+ interactive Power BI dashboards using advanced DAX, bookmarks, and RLS, improving executive-level decision visibility across finance and operations.
  • Automated recurring reporting tasks via SQL pipelines and Python scripts, reducing manual effort by 40%, and ensuring daily KPI refresh.
  • Partnered with database and cloud teams to integrate SQL Server and Azure sources, enhancing data availability, governance, and security compliance.
  • Optimized complex SQL queries for performance, improving report execution speed by 60% for large-scale datasets (greater than 500K records).
  • Documented reporting processes, built user guides, and maintained consistent metrics governance across dashboards.

GE Capital, Analyst | Oct 2021 – Aug 2023

  • Developed Power BI dashboards and ETL processes for datasets exceeding 100,000 records, improving reporting accuracy by 75%.
  • Built data models (Star Schema, Fact-Dimension), enabling scalable BI solutions aligned with business strategy.
  • Implemented validation checks, ensuring 99% data integrity across multiple sources (Excel, SQL Server, CSV).
  • Collaborated with stakeholders to define KPIs, automate recurring reports, and track business performance metrics.

Education

Bachelor of Engineering - Electronics & Communication Engineering

Rajiv Gandhi Proudyogiki Vishwavidyalay
Bhopal
10-2020

Skills

  • Languages and tools: SQL, Python (Pandas, NumPy, Matplotlib), DAX, Power Query
  • Visualization and BI: Power BI(Adv), Tableau (basic), Excel (Power Pivot, Power Query)
  • Automation and ETL: Alteryx, Power BI Service, Azure Data Factory, SSIS
  • Database systems: SQL Server, MySQL, PL/SQL
  • Data skills: data modeling (star schema), cleansing, transformation, validation, governance
  • Other: Agile SDLC, stakeholder communication, KPI reporting & metrics

Certification

  • Microsoft Certified: Power BI Data Analyst Associate (Coursera)
  • Google Data Analytics Professional Certificate (Coursera)

Accomplishments

  • Awarded 'Best Team Member' for analytics delivery and collaboration on enterprise BI initiatives
  • Received the “Gladiator Award” among 12 peers for automating recurring reports and improving accuracy by 75%

Timeline

Senior Analyst

Capgemini
10.2021 - Current

Bachelor of Engineering - Electronics & Communication Engineering

Rajiv Gandhi Proudyogiki Vishwavidyalay
Amar Nath Bharti