Summary
Overview
Work History
Education
Skills
Certification
Timeline
Associate Consultant

Ankit Kumar Jha

KPMG Assurance and Consulting Services LLP
Gurugram
2
years of professional experience
1
Certification

Associate Consultant with 2+ years of experience at KPMG, turning complex data into clear insights and business decisions. Skilled in SQL, Power BI, Excel and Python, with a strong record of building dashboards, uncovering financial impact and presenting recommendations to senior leadership.

Work History

Associate Consultant

2 Years 4 Months
KPMG Assurance and Consulting Services LLP | 07.2024 - Current
  • Quantified ZAR 84M (~USD 5M) in historical excess payments across 151 sites by consolidating 26 years of payment records using advanced SQL (joins, window functions, multi-level aggregations) and mapping management responses to each site; ZAR 27M (~USD 1.6M) already recovered/adjusted by the client.
  • Diagnosed 16+ root causes across network, contract management and account payable, presented findings to the CFO, and supported implementation of 25+ recommendations that streamlined the client’s accounts payable process.
  • Developed master database integrating network, vendor and accounts payable data, providing teams with consolidated cross-functional view and identifying 9 observations worth ZAR 35M in potential financial impact.
  • Built a live-connected network performance dashboard in Power BI and Grafana for the CTO of a Cambodian telecom operator, converting raw counter data into 27 KPIs via custom formulas and giving leadership the first end-to-end view of network health across 3000 sites.
  • Designed a two-layer view: an executive map flagging sites green/red by network health, with hourly/daily/weekly/monthly and province/region filters, and a KPI-level layer for drill-down and root-cause investigation.
  • Conducted on-site verification of 300+ telecom sites, validating operational status, electricity meters against power payments, and vendors against contracts, identifying ZAR 11M (~USD 0.65M) in potential financial impact.
  • Supported As-Is assessment and To-Be design for the NOC across RAN, Core and Transport, standardizing incident, change and alarm management and replacing undefined workflows with clear end-to-end flows.

Education

Bachelor of Technology - Computer Science And Engineering

DIT University | Dehradun | 07-2024

(With Specialization in Data Science & Analytics)

CGPA: 7.7

Higher Secondary(CBSE) - Chandigarh

Stepping Stones Senior Secondary School | Chandigarh | 01-2020

Percentage: 72%

Skills

Data Analytics: SQL (joins
window functions
CTEs
aggregations)
Advanced Excel (pivot tables
lookups
Power Query)
data cleaning and reconciliation
Visualization and Reporting: Power BI (DAX
interactive dashboards)
Grafana
Programming: Python (Pandas
NumPy)
MySQL
Business and Consulting: Requirements analysis
Process mapping
Root cause analysis
stakeholder management
Executive presentations

Certification

  • Microsoft Certified : Power BI Data Analyst Associate - PL 300
  • PCEP: Certified Entry-Level Python Programmer (PCEP-30-02), Python Institute, 2025

Timeline

Associate Consultant

KPMG Assurance and Consulting Services LLP
07.2024 - CurrentRead More

DIT University

Bachelor of Technology from Computer Science And Engineering
Read More

Stepping Stones Senior Secondary School

Higher Secondary(CBSE) from Chandigarh
Read More
Ankit Kumar Jha