Summary
Overview
Work History
Education
Skills
Accomplishments
Academiccredentials
Software
Timeline
Generic

Sandeep Agarwal

Workforce Optimization
Greater Noida,Uttar Pradesh

Summary

With more than 13 years in the Offshore Outsourcing industry, inclusive of almost 12 years’ experience in WFM, A Versatile Leader specializing in WFM and skilled at planning, implementing and overseeing key improvements to drive business growth and efficiency. History of cultivating an open culture with free exchange of information. Pursuing new professional challenges with a growth-oriented company.

Overview

17
17
years of professional experience

Work History

AVP (Senior Demand Planning Analyst)

Barclays Global Service Center
Noida
Oct2023 - Current
  • Led a successful transition of 10 Business Area from Onshore (UK) to India
  • Leading those transitioned Business Areas - providing consulting services to Leadership & Onshore counterparts along with BAU WFM activities
  • Standardized Forecasting practices and built a Forecasting model which has more than one Forecasting Algorithms like - XG Boost (Machine learning model), Holt’s Winter, Holt’s, Linear Regression, Time Series (Seasonality model)
  • Implementation of EUDA process (End User Developed Application) to ensure Business Continuity and fall back in case an automation fails
  • Competency Development Leader (conducted 3 upskilling sessions - 2 for Python and 1 for Forecasting)

Senior Manager - Service Delivery (Planning & Part

SBI Cards & Payment Services Limited
Gurugram
11.2021 - 09.2023
  • Headed team of 3 Managers and 10 Assistant Managers – managing business in 7 sites across Pan India
  • Long term and Short term Planning for 22 lobs with 43 queues of India’s 2nd largest Credit card business organization of 3.6 billion $ Net worth, handling all WFM verticals like – Capacity Planning, Forecasting, along with Budget Planning, Costing, Headcount saving Projects
  • Planning, Transition & Onboarding lead for new partners which includes – SOW, MSA’s and R & P grid closures
  • Outbound Dialer Strategy planning for Sales, Services, & Retention to optimize Connect & Connect rate to achieve maximum Revenue, this includes regular monitoring and strategy changes with regards to Data penetration, Coverage and Amount
  • Ensuring Service thresholds are met like – Service level, Adherence, Schedule efficiency, Outbound Connect/Contact & Idle %, Wrap time

Manager - Service Delivery & Vendor Management

Make My Trip Inc. Now Go-MMT
Gurugram
04.2021 - 10.2021

Pre Covid - Managing 10 vendors in different locations with HC of over 2800 Ftes in 10 lobs and a Span of 35 WFM professionals (upto Manager level)

  • Post Covid – 4 vendors with 900+ HC
  • Planning for 17 lobs with 156 queues of India’s largest OTA (Online travel agency) of 3.32 billion $ Net worth organization handling all WFM verticals like – Capacity Planning, Forecasting, along with verticals like – Budget Planning, Costing, facilitating SOX Audit conducted by a third party.
  • Fortnightly review with Senior management to update them about variance in Actual cost vs Planned (if any), Cost per booking, Cost per Fte (Actuals vs planned)
  • To raise alert in system & revise the planning if any metrics is not within threshold, Weekly analysis to internal stakeholders to give a view of their lob's performance and suggesting the workaround for miss in any metric like Abn
  • Ensuring Fte readiness at centres for 90 days rolling as per trending assumptions
  • Implemented different performance matrices across sites such as – Schedule efficiency, Adherence , Fte delivery

Achivements

  • Effectively planned and execution of Work from Home model at all Call centres post Covid Lockdown ensuring business continuity across LOBs even after running operations with 12% Fte against Feb - which included call routing management, Cross utilization, merger of lobs, Hygiene drive, Increasing Occupancy from 75% to 90%, ID deletion at mass level ensuring 100% SOX compliance
  • Ramping down In AMJ and again ramping up in OND’20 and JFM’21 increasing HC from 12% to 30% ensuring HC pipeline is as per plan, coordinating and liaising with training, CC heads, CC HR
  • Cost Saving of approx. 20 Cr. in FY 18-19 by consistently revising planning and HC reduction because of drop in call/email ratio along with the help of cross utilization of Voice resources in email and by movement of resources from one lob to another in lieu of less vol & occupancy. With this Occupancy at centres also increased from 55% to 70% during this period
  • Introduced seasonality based Budget planning which was earlier planned flat across most of the months (only peak travel seasons were inflated like – Dec & May). This led to improved service delivery i.e. SL increased from 63% to 74% and abn% dropped by 3% (comparison against last yr. same month with approx. same actual vol against forecast)
  • Introduced variable AHT concept for planning i.e. Inflating AHT due to attrition/OJT on floor during ramp to cater high volume basis season (earlier it was considered flat irrespective of tenure vs OJT ratio)
  • Ensuring Sop’s,version controls and Standardized methodology and calculations at Centres
  • Successful implementation of Adherence model at centres which led to a jump of 26% from May – Nov’17 (80% from 54%), ensuring effective service delivery

Deputy Manager - Service Delivery (Planning & Partner Management)

Make my Trip Inc. (Apr’18 – till Mar’21) now Go-MMT Group
Gurugram
04.2018 - 03.2021

Assistant Manager - Service Delivery (Planning & P

Make My Trip Inc. (Oct 2016 – Mar’18)
Gurugram
10.2016 - 03.2018

Resource Planner Analyst (Assistant Manager)

Convergys India PVT. LTD.
06.2016 - 09.2016
  • Handling Resource Planning for a US based Medicare business with over 250 FTEs

WFM Analyst – Planning, Forecasting and Scheduling

CWT India PVT. LTD.
06.2014 - 05.2016
  • Responsible for end to end activities related to Planning for accounts in Asia Pacific Region, like – Forecasting and Capacity Planning for a business year and reviewing & revising it on quarterly basis (controlling).
  • Headed the Business transition from AU/NZ to Manila and successfully transited almost 80% of the Domestic business.
  • Successfully handled the Project of setting up multiple centralized MSC centers for Overall APAC Region business, which includes AU/NZ, SEAH countries (South-East Asia + Hong Kong) in Manila, which saved quite a handful of FTEs by increasing the Occupancy of these centers
  • Cost saving of NORAM Business accounts by migrating the Aftrhrs and Non-Peak volume to Manila, as labor cost in Manila is cheap in comparison to North America
  • Presentation of some very meaningful What- If analysis to the Leaders and recommending them best practices to improve efficiency, ensuring business deliverables are met.
  • Ensuring high Quality checks in all the Reports/Dashboards like – error and validation check, font type, color, size, border, Company logo etc. 5 Kaizens (Japanese term – Change for good) submitted and got them approved for automation which saved a total time of 929 min in a month

WFM Executive – Real Time Analyst

Wipro BPO
03.2009 - 12.2010

Customer Service Representative (Executive)

Wipro BPO
08.2007 - 03.2009

Education

Skills

In depth understanding of RFP process flow and ability to prepare competitive WFM solutions

Have good understanding of Erlang methodologies, WFM Aspect tool

Strong analytical abilities to provide strategies based on historical and current data

Subject matter expert with thorough understanding of workforce planning programs and principles

Ability to coordinate with the Management team to ensure effective execution in order to achieve the desired goals and objectives

Excellent knowledge of all phases of Workforce Management; forecasting, manpower planning, scheduling, reporting and real time functions

Accomplishments

  • Participated in the Six-Sigma Project for Kodak Service Level improvement.
  • Certificate of Appreciation from Vice President (CWFM) for being a part of top RTA team for Quarter.
  • Awarded Best Real Time Analyst for two consecutive quarters.
  • Implemented two Pragati improvement ideas implemented-Daily Absenteeism Tracker and Revenue Leakage Tracker (Pragati-an idea for continuous improvement in the workplace).

Academiccredentials

  • Pursuing PGDM in AI/ML from Upgrad
  • MBA in International Business
  • Graduate in B.A (Hons.) from Aligarh Muslim University (AMU)
  • 2007 - Diploma in Aviation & Hospitality Management (AIR HOSTESSACADEMY)

Software

Python

VBA

Timeline

Senior Manager - Service Delivery (Planning & Part

SBI Cards & Payment Services Limited
11.2021 - 09.2023

Manager - Service Delivery & Vendor Management

Make My Trip Inc. Now Go-MMT
04.2021 - 10.2021

Deputy Manager - Service Delivery (Planning & Partner Management)

Make my Trip Inc. (Apr’18 – till Mar’21) now Go-MMT Group
04.2018 - 03.2021

Assistant Manager - Service Delivery (Planning & P

Make My Trip Inc. (Oct 2016 – Mar’18)
10.2016 - 03.2018

Resource Planner Analyst (Assistant Manager)

Convergys India PVT. LTD.
06.2016 - 09.2016

WFM Analyst – Planning, Forecasting and Scheduling

CWT India PVT. LTD.
06.2014 - 05.2016

WFM Executive – Real Time Analyst

Wipro BPO
03.2009 - 12.2010

Customer Service Representative (Executive)

Wipro BPO
08.2007 - 03.2009

AVP (Senior Demand Planning Analyst)

Barclays Global Service Center
Oct2023 - Current
Sandeep AgarwalWorkforce Optimization