Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Websites
Timeline
Generic

Amar Nath Bharti

Pune

Summary

Data Analyst with 3.8 years of experience in SQL, Power BI, and Excel. Demonstrated success in improving SQL query performance by 25% and managing datasets of over 10,000 records daily, with 99% accuracy. Skilled in building interactive dashboards, automating reports, and supporting strategic decisions. Eager to enhance business intelligence capabilities and collaborate in dynamic IT environments.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Senior Analyst

Capgemini
Pune
10.2021 - Current

Sr. Analyst – Capgemini (Client: GE Vernova), Pune Aug 2023 – Present.

  • Developed interactive dashboards in Power BI from scratch, using advanced features like joins, Level of Detail (LOD) calculations, and parameter controls.
  • Implemented Row-Level Security (RLS) in Power BI for secure, role-based access to data.
  • Configured and scheduled data extract refreshes, and subscriptions to automate the delivery of key reports.
  • Customized Power BI reports to stakeholders' needs, improving data interpretation by 20%.
  • Designed and executed complex SQL queries to extract and analyze large datasets.
  • Collaborated with cross-functional teams, reducing database issue turnaround time by 15%

Analyst – Capgemini (Client: GE Capital), Pune, Oct 2021 – Aug 2023.

  • Utilized SQL for the extraction and analysis of large datasets, boosting reporting accuracy by 75%.
  • Crafted robust queries to maintain 99.5% data integrity for databases with over 100,000 records.
  • Built Power BI dashboards to visualize key metrics, leading to a 20% reduction in customer churn.
  • Integrated Power BI with SQL Server and other sources for cohesive visual insights.

Education

Bachelor of Engineering - Electronics And Communications Engineering

Rajiv Gandhi Prodyogiki Vishwavidyalaya
Bhopal
09-2020

Skills

  • SQL and Python programming
  • Power BI and Excel proficiency
  • Data cleaning and modeling
  • Dashboard creation and automation
  • Row-level security and DAX
  • ETL processes and SQL querying
  • Data visualization and analysis
  • Database management
  • Stakeholder engagement
  • Business intelligence

Certification

  • Microsoft Power BI Data Analyst Associate
  • Google Data Analytics Professional Certificate
  • Power BI Data Analyst certification

Accomplishments

  • Awarded "Best Team Member" for exceptional performance and collaboration.

Timeline

Senior Analyst

Capgemini
10.2021 - Current

Bachelor of Engineering - Electronics And Communications Engineering

Rajiv Gandhi Prodyogiki Vishwavidyalaya

Similar Profiles

CREATE PROFILE
Amar Nath Bharti