Summary
Overview
Work History
Education
Skills
Timeline
Generic

SHUBHAM AGARWAL

Noida

Summary

Data Analyst with over 5 years of experience in data visualization and process automation. Expertise in leading BI product development and optimizing data models to enhance reporting efficiency. Proficient in Power BI, SQL, Alteryx, Power Query, and DAX, delivering actionable insights that drive cost savings. Recognized for strong cross-functional leadership and commitment to data-driven decision-making in dynamic environments.

Overview

6
6
years of professional experience

Work History

Senior Data Analyst

Innovaccer
Noida
08.2024 - Current
  • Spearheaded design and implementation of standardized Quality Dashboard for performance metric monitoring.
  • Constructed a detailed metric dictionary with SQL- and DAX-based definitions for key performance indicators.
  • Developed sophisticated data models, insightful reports, and dynamic dashboards using SQL and Power BI.
  • Ensured data accuracy and reliability by implementing rigorous audit and validation procedures.
  • Automated data processes, enhancing efficiency of data collection, cleaning, and analysis.
  • Optimized report refresh processes by 25%, improving access to critical business insights.
  • Collaborated with Client Success team to troubleshoot dashboard issues, achieving 90% resolution rate.
  • Implemented a data quality framework that minimized discrepancies, ensuring reliable information for decision-making.

Data Analyst

Gartner
Gurugram
10.2021 - 08.2024
  • Automated engagement report generation using Power Query, saving over 1,000 hours annually.
  • Delivered high-quality Power BI dashboards aligned with key performance indicators for global leadership.
  • Created comprehensive end-user documentation and training materials adopted by three teams, ensuring consistency.
  • Designed automated reporting systems to provide real-time insights with minimal manual effort.
  • Collaborated with cross-functional teams to translate business needs into data-driven solutions.
  • Maintained thorough documentation of data sources and methodologies to ensure transparency and reproducibility.
  • Streamlined data collection methodologies, reducing report development time by 40% and enhancing productivity.
  • Optimized complex SQL queries, improving dashboard responsiveness and user experience by 30%.

Data Analyst

CBRE
Gurugram
12.2019 - 10.2021
  • Implemented advanced anomaly detection workflow to enhance quarterly data audit quality.
  • Designed Power BI visualizations to uphold data quality standards and provide clear insights.
  • Maintained internal databases, rigorously verifying data accuracy post-updates for reliable reporting.
  • Onboarded and mentored new analysts in established data practices to promote excellence.
  • Automated engagement reporting processes, saving over 1,000 hours annually for strategic resource allocation.
  • Instituted comprehensive training program for data management best practices, achieving 90% accuracy improvement.
  • Enhanced data visualization techniques, increasing stakeholder engagement by 95% during presentations.

Education

PGDM -

I.T.S Mohan Nagar
Ghaziabad
01.2020

B.B.A -

Maharaja Agrasen Mahavidyalaya
Bareilly
01.2017

Skills

  • Power BI and Power Query
  • DAX and SQL
  • Alteryx
  • Workflow automation
  • Data modeling and optimization
  • Microsoft Excel proficiency
  • Process automation
  • Stakeholder engagement
  • Cross-functional collaboration

Timeline

Senior Data Analyst

Innovaccer
08.2024 - Current

Data Analyst

Gartner
10.2021 - 08.2024

Data Analyst

CBRE
12.2019 - 10.2021

PGDM -

I.T.S Mohan Nagar

B.B.A -

Maharaja Agrasen Mahavidyalaya

Similar Profiles

CREATE PROFILE
SHUBHAM AGARWAL