Summary
Overview
Work History
Education
Skills
Live Projects
Interests
Certifications Professional Skills
Certification
Timeline
Generic

Shubhrangi Mishra

Senior Consultant
Gurgaon

Summary

Driven Senior Consultant with three years' experience in the business risk consulting field. Adept in collaborative problem solving, risk management and creative solutions. Passionate about bringing changes in businesses. Proficient in conducting primary and secondary research.

Overview

7
7
years of professional experience
9
9
years of post-secondary education
1
1
Certification

Work History

SENIOR CONSULTANT (Business Risk)

ERNST & YOUNG
05.2022 - Current

· Led a pan-India customer experience audit project for the pre-sales and after-sales functions of a leading German luxury automotive OEM, covering 800+ dealership audits annually; results directly influenced dealer bonus payouts

· Managed and mentored a cross-functional team, ensuring timely execution and adherence to audit protocols across diverse geographic locations.

· Designed and implemented audit frameworks for evaluating dealership performance on KPIs such as process excellence, CRM compliance, and customer satisfaction metrics.

· Prepared outlet-level reports and synthesized insights into strategic management dashboards, highlighting lost sales opportunities, dealer-wise performance trends, and key improvement areas.

· Conducted on-ground service audits by accompanying customers during their visits to service centres, identifying compliance gaps in the aftersales journey and CRM utilization.

· Collaborated with OEM client stakeholders to present findings, align on improvement strategies, and track implementation of corrective actions at dealerships.

· Conducted an IT General Controls audit for a major alcohol distillery, focusing on user access management, review of account provisioning/de-provisioning, and compliance with IT policies and controls.

Earned the 'Kudos' and 'Extraordinaire' awards in recognition of exceptional contribution to high-impact client engagements.

ETL DEVELOPER

TATA CONSULTANCY SERVICES
09.2018 - 07.2020
  • Built ETL flow to consume raw data provided from upstream and transformed them according to predefined business requirements for smooth operations in the downstream
  • Worked in Level 3 team which is critical to operations, as the last point of contact in case of issues in the production environment, this is a crucial point of risk management
  • Was the lead for a team of 5 and acted as bridge of communication between the team and the manager on the client-side, creating a sync between our capabilities and client’s requirements
  • Analyzed and resolved critical production issues in ETL workflows during peak times and have been lauded for my prudence despite being the junior-most resource in the team
  • Received ‘On the Spot’ award for quickly adhering to the project policies and delivering defect-free products, adhering to the highest standards of product development

E-COMMERCE MARKETING MANAGER

STAYFIT
04.2021 - 06.2021
  • Analyzed the company’s requirements and managed the building of an android app and website of the company from scratch by hiring a third-party vendor.
  • Observed current loopholes in the management of the company and worked upon the betterment of the organization as a whole (HR, Marketing, Sales, and Digital Platforms)

Education

MBA -

Indian Institute of Management
01.2020 - 01.2022

B.Tech - Electrical

Indira Gandhi Institute of Technology
01.2014 - 01.2018

XIIth - CBSE Board

Mother’s Public School
01.2012 - 01.2014

Xth - CBSE Board

ODM Public School
01.2011 - 01.2012

Skills

  • MS Excel
  • MS Powerpoint
  • Structured Query Language (SQL)
  • Informatica

Live Projects

BMGI Consulting, Conducted market research on education industry and submitted a 250 slide PPT. Recommended active areas of the industry for new business strategies., 01/21-03/21

Interests

Painting

Certifications Professional Skills

  • KPMG Lean Six Sigma Green Belt
  • PMP
  • Fundamentals of Digital Marketing – Google Digital Unlocked
  • Proficient in Structured Query Language (SQL)
  • Informatica
  • MS Excel
  • MS Powerpoint

Certification

PMP, Lean six Sigma - Green Belt

Timeline

SENIOR CONSULTANT (Business Risk)

ERNST & YOUNG
05.2022 - Current

E-COMMERCE MARKETING MANAGER

STAYFIT
04.2021 - 06.2021

MBA -

Indian Institute of Management
01.2020 - 01.2022

ETL DEVELOPER

TATA CONSULTANCY SERVICES
09.2018 - 07.2020

B.Tech - Electrical

Indira Gandhi Institute of Technology
01.2014 - 01.2018

XIIth - CBSE Board

Mother’s Public School
01.2012 - 01.2014

Xth - CBSE Board

ODM Public School
01.2011 - 01.2012
Shubhrangi MishraSenior Consultant