Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Timeline
Generic

Umang Gupta

Bengaluru

Summary

Experienced Senior Analyst with 5+ years of expertise in data analysis, sales operations, and business reporting. Proficient in Power BI, Excel (Power Query, Power Pivot), SQL, and data visualization with a strong focus on sales performance tracking, reporting automation, and process improvement. Recognized for strong client management, cross-functional collaboration, and the ability to deliver actionable insights that support business growth.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Analyst

Capgemini Technology Services India Ltd.
11.2019 - 02.2025
  • Produced and delivered standardized and customized business reports, providing actionable insights to support sales and operational decision-making.
  • Designed and maintained Power BI and Excel dashboards (Power Query, Power Pivot) to create personalized, on-demand reports for stakeholders.
  • Organized and documented regular communication updates with stakeholders, ensuring key sales insights and opportunities were accurately tracked and shared.
  • Collaborated with global teams to monitor customer master data, sales opportunities, and risks, ensuring timely reporting for account managers.
  • Acted as the point of contact for ad-hoc data and sales reporting inquiries, providing accurate and timely responses to support client teams.
  • Streamlined reporting workflows, implemented automation solutions in SQL and Power BI, and introduced best practices that reduced manual effort and improved reporting accuracy.
  • Partnered with business leaders to understand priorities, enabling alignment of sales reporting with business objectives.
  • Managed and coached a team of 10+ professionals, enhancing their skills in reporting, analytics, and sales data management while ensuring delivery excellence.
  • Implemented quality control checks in reporting processes, ensuring data accuracy and consistency in sales dashboards.
  • Assisted leadership in forecasting and demand planning by providing predictive insights using historical sales data.
  • Collaborated with IT and data teams to enhance reporting tools and integrate automation, reducing reporting turnaround times.
  • Ensured compliance with process orientation and audit requirements by maintaining documentation, templates, and reporting standards.

Education

Bachelor of Technology - Electronics & Communications Engineering

Jamia Hamdard University
08.2019

Skills

  • Sales Operations & Reporting
  • Business Analysis & Data Insights
  • Power BI, Excel (Power Query, Power Pivot), SQL
  • Dashboard Development & Automation
  • Sales Opportunity Tracking & CRM Reporting
  • Process Improvement & Efficiency Optimization
  • Client Relationship Management
  • Cross-functional Collaboration & Stakeholder Management
  • Data analysis

Affiliations

Capgemini

Certification

  • Microsoft Azure Fundamentals (AZ-900)
  • Microsoft Azure Administrator (AZ-104)
  • Python Developer Certification
  • Data Analyst Certification

Timeline

Senior Analyst

Capgemini Technology Services India Ltd.
11.2019 - 02.2025

Bachelor of Technology - Electronics & Communications Engineering

Jamia Hamdard University
Umang Gupta