Summary
Overview
Work History
Education
Certification
Achievements And Awards
Projects
Timeline
Generic

Pranav Kaushal

Summary

Strategic and results-driven Consulting Analyst at Deloitte USI with expertise in data automation, financial modeling, and performance optimization. Proficient in SQL and Anaplan, transforming incentive compensation, workforce planning, and financial analytics. Spearheaded process automation and data-driven decision-making, cutting manual effort, enhancing reporting speed and optimizing resource allocation. Recognized for delivering scalable, high-impact solutions in the software and cloud computing industries.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Consulting Analyst

Deloitte USI
Gurugram
11.2022 - Current
  • Automated incentive compensation models in Anaplan, cutting manual effort by 30% and increasing payout accuracy by 25%, ensuring error-free compensation for 1,000+ employees across software and cloud computing industries.
  • Engineered SQL-based ETL pipelines in SnapLogic, automating data integration for 100K+ daily records, reducing processing time by 20% and improving financial planning accuracy.
  • Developed predictive forecasting models for territory quota and workforce planning, leveraging historical sales trends and advanced modelling techniques to improve resource allocation efficiency by 15%.
  • Designed real-time performance dashboards in Anaplan, reducing reporting lag by 40% and enhancing executive decision-making, enabling more accurate sales planning.
  • Optimized SQL queries and database architecture for financial models, increasing data processing efficiency by 30% and accelerating financial reporting timelines for key stakeholders.

Semester Intern

Verzeo Edutech Pvt. Ltd.
Bengaluru
01.2021 - 07.2021
  • Developed a lead-scoring model using historical interaction data and predictive analytics, improving targeting accuracy by 15%.
  • Automated data processing workflows, reducing manual effort by 40% and improving response time by 25% through real-time validation and integration.
  • Designed interactive dashboards to track engagement trends and operational efficiency, improving data visibility by 30% and enabling real-time decision-making.

Education

B.Tech - Electronics & Communication Engineering

Punjab Engineering College (PEC)
Chandigarh
05-2022

Class 12th -

Army Public School
Ambala Cantt
03-2018

Certification

  • Programming & Data Tools: SQL, Anaplan, Varicent, Tableau.
  • Data Visualization & Analytics: Excel, Google Cloud (Basic)
  • Software & Productivity Tools: MS Office Suite (Excel, PowerPoint, Word)
  • Certifications: Database Management, Business Management, Project Management, Data Analysis

Achievements And Awards

  • Recognized with 2 Applause Awards and 2 Spot Awards at Deloitte for delivering high-impact client solutions and driving measurable business improvements.
  • Awarded a Spot Award at Deloitte for successfully leading and executing practice co-location, enhancing team collaboration and operational efficiency.
  • Received Appreciation Awards at Verzeo for outstanding performance and contributions to data-driven process optimization.

Projects

  • Automated Entry Solution for COVID-19: Engineered a smart system integrating automated door control, sanitizer dispensing, mask recognition, and attendance monitoring
  • Sales Performance Analytics Dashboard: Developed a Tableau-based dashboard for tracking sales incentives, compensation structures, and quota attainment, leading to better sales strategy alignment

Timeline

Consulting Analyst

Deloitte USI
11.2022 - Current

Semester Intern

Verzeo Edutech Pvt. Ltd.
01.2021 - 07.2021

B.Tech - Electronics & Communication Engineering

Punjab Engineering College (PEC)

Class 12th -

Army Public School
Pranav Kaushal