Summary
Overview
Work History
Education
Skills
Timeline
Generic
Puneet Virmani

Puneet Virmani

SENIOR MANAGER BI Reporting & Analytics
New Delhi

Summary

Senior Manager, Operations Analytics, overseeing certified data science, dashboarding, capacity analysis, and automated reporting for senior leadership, enabling faster and more informed decisions on performance priorities. Develops AI-enabled utilities and a portfolio of 100+ standardized tools in Python, RStudio, SQL, and Excel, reducing manual effort by 95% while improving reporting accuracy and consistency. Translates complex business questions into scalable analytics solutions that strengthen planning, control, and productivity review.

Overview

1
1
Language
17
17
years of professional experience

Work History

Senior Manager

Mercer
04.2025 - Current
  • Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.
  • Led cross-functional teams to achieve project milestones and deliver high-quality results.
  • Led cross-functional teams to implement strategic workforce planning initiatives.
  • Managed complex client relationships, delivering tailored solutions to meet organizational needs.
  • Developed and executed employee engagement programs to enhance retention rates.
  • Streamlined operational processes, improving efficiency and reducing turnaround times.
  • Improved team performance by providing comprehensive training and fostering a collaborative work environment.
  • Mentored junior managers, fostering professional growth and leadership skills within the team.
  • Achieved operational excellence by streamlining processes and implementing best practices.

Manager

Mercer
10.2021 - 03.2025
  • Lead and manage a team of Reporting Analysts to deliver timely and accurate reports to stakeholders.
  • Collaborate with business leaders to identify reporting & analytics need and provide actionable insights to drive business decisions.
  • Collaborated with business leaders to identify reporting and analytics needs, providing actionable insights that informed strategic business decisions.
  • Manage relationships with external vendors and ensure compliance with regulatory requirements.
  • Managed relationships with external vendors, ensuring compliance with regulatory requirements and fostering collaboration.
  • There was no standard dependable process to validate the quality of One on One connect of colleague & supervisor so I developed one stop shop in Python (including SQLite/Notepad/Excel/Outlook/PDF) to register, record the progress in partnership with the supervisor & colleague. Won a Maestro Award for the solution and delivering the independent utility for global employees.
  • Developed a Utility in RStudio (including SQLite/Excel/Outlook/PDF) which reduced the 90% of our manual work and saved more than 1699 hours yearly.
  • Developed a Utility in RStudio (including SQLite/Excel) to track daily BAU activities and delivering the Capacity Utilization for senior management.
  • Created multiple applications in Excel to automate generation of word documents for onshore stakeholders.

Manager

(Samsung Group) Cheil India Pvt. Ltd.
03.2021 - 03.2021
  • Sales Analysis to improve sales through all dimensions along with the seller’s performance.
  • Provide Project management of team activities while identifying areas in which analytics efforts can produce a strong value add
  • Supporting the team in the delivery of the current pipeline projects
  • Contribute in projects to ensure timely delivery.
  • Provide new ideas and operating models options to ensure the delivery of the solutions for BI in a cost-effective way.
  • Evaluated sources of information through social media platforms, built model, and applied data analytics to enhance automation and inform business decisions.
  • Developed new ideas and operational models to ensure effective delivery of BI solutions.
  • Automated trigger Reports to Stakeholders
  • Managed team activities while identifying areas where analytics efforts added significant value.
  • SEC control through FFM application
  • Market Share Analysis through Websites and Social Media Channels
  • Rise in CE Premium Products Sellout
  • SEC Relocation Analysis
  • Google Trends to a right market check/demand on right time :
  • Market Brand Value on Pan India Level
  • Preparing Presentations for Daily/Weekly/Month/Quarter Review.
  • Significant Accomplishments:
  • Worked on different business projects as mentioned below:
  • Revenue & Loss →
  • Manager since Mar'21
  • Market Brand Value on Pan India Level
  • Sales Analysis
  • Manager since Mar'21

Deputy Manager

Make My Trip
08.2018 - 05.2020

Revenue & Loss →

  • Delivered backend support for various special projects, focusing on retargeting and hot leads.
  • Controlled GPM through analysis of outstanding amounts, GPM leakage, cashback, and losses reports
  • Data & backend support on special projects, retargeting, Hot Lead, etc.
  • Apprehend additional transactions for business through multiple drive. For E.g. Sellers Capsule, High Propensity etc.
  • Tactical offer communication( SMS, Email)
  • Score Cards & Dashboards
  • Business Connect with Product & channel of planning & execution of running activities & way forward

Discounting & Offers Strategies →

  • Offline Discounting Management
  • Consolidation of all type of sales & evaluation of impact through reporting
  • Data support on tactical offers to Product manager
  • Analysis on Customer segmentation and Repeat Customer Behavior to see the way forward in business

Automations →

  • Developed internal and external websites/applications to enhance user experience and operational efficiency
  • Automated reports and dashboards to streamline data reporting processes
  • Transforming data platform from excel/access to SQL Server
  • Automated trigger Reports to Stakeholders
  • Managing a team of AM’s & Associates, monitoring their performances to ensure efficiency in process operations & ensure meeting of individual / group targets
  • Preparing MBR’s & QBR’s in every month/quarter.
  • Google Trends to a right market check/demand on right time :
  • Used the Google Trends India Search data to see the travel searches across India
  • Amend respective theme Packages as per the market demand
  • Activate package from the respective hubs etc.
  • Repeat Customer Behavior
  • Raising Reconnect %age
  • Customers profiling on MMT1
  • FD Price Yield Management
  • Seller’s Capsule
  • GP Leakage
  • Aug'18-May'20

Assistant Manager

Mercer
07.2016 - 08.2018
  • Led cross-functional teams to enhance operational efficiency and streamline workflows.
  • Developed training programs to improve staff performance and ensure compliance with company policies.
  • Analyzed client feedback to identify opportunities for service improvement and drive customer satisfaction.

Assistant Manager

Make My Trip
12.2013 - 07.2016
  • Led team in developing strategic initiatives to enhance operational efficiency and service delivery.
  • Mentored staff on best practices, fostering a culture of continuous improvement and professional growth.
  • Collaborated with cross-functional teams to implement process improvements, resulting in streamlined workflows.

Senior Associate IT Operations

MetLife
06.2011 - 12.2013
  • Led cross-functional teams to improve operational efficiencies and streamline workflows.
  • Developed and implemented training programs for junior associates to enhance performance accuracy.
  • Analyzed complex data sets to inform strategic decision-making and optimize project outcomes.

MI Analyst

Vertex Customer Solutions
09.2009 - 05.2011
  • Analyzed customer feedback to identify trends and recommend improvements for service delivery.
  • Developed data models to enhance operational efficiency and optimize resource allocation.
  • Collaborated with cross-functional teams to implement strategic initiatives aligning with business goals.

Education

Bachelor of Commerce -

Punjab University
Chandigarh
01-2003

12th - undefined

Sanjay Public School
Chandigarh
01-1999

10th - undefined

Govt. Model High School -Sec 36
Chandigarh
01-1997

Skills

Sales analysis

Market research & analysis

Reporting & documentation

PMO

Growth analysis

Profit centre operations

Relationship management

Team management

Dashboard reporting

Process improvement

Data Visulization

Tableau

Power BI

Data governance

Master data management

KPI framework development

Predictive analytics

Business requirements analysis

Timeline

Senior Manager

Mercer
04.2025 - Current

Manager

Mercer
10.2021 - 03.2025

Manager

(Samsung Group) Cheil India Pvt. Ltd.
03.2021 - 03.2021

Deputy Manager

Make My Trip
08.2018 - 05.2020

Assistant Manager

Mercer
07.2016 - 08.2018

Assistant Manager

Make My Trip
12.2013 - 07.2016

Senior Associate IT Operations

MetLife
06.2011 - 12.2013

MI Analyst

Vertex Customer Solutions
09.2009 - 05.2011

10th - undefined

Govt. Model High School -Sec 36

12th - undefined

Sanjay Public School

Bachelor of Commerce -

Punjab University
Puneet VirmaniSENIOR MANAGER BI Reporting & Analytics