Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Debarati Das Gupta

Debarati Das Gupta

Analytics & Program Manager
Bangalore

Summary

Detail-focused Data Analyst with knowledge in data mining, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Meticulous and accomplished in compiling, transforming and analyzing complex information. Demonstrated success in identifying relationships and building solutions to business problems.

Overview

6
6
years of professional experience
4
4
Certificates

Work History

Analytics & Program Manager (Global COO Office)

Capgemini
Bangalore
01.2022 - Current

I report to the Global Chief Of Operations and lead the Analytics & Transformation team
Analytics Developments for Global COO Office:

  • Developed monthly forecasting model which models workforce scenarios, factors in deals and projects to establish comprehensive cost portfolio for senior leadership, leading to 15% saving arenas & strategy formulations
  • Developed yearly budget automation template which takes into account key factors such as hiring strategies, attrition outlook, hiring premium, projects/deals projections and establishes overall cost portfolio for each major centre of org - this lead to setting pro-active goals for each centre thereby helping save 2% of budget allocated overall
  • Ideated, Designed & Created the Practice based Economic Model which helped to set revenue targets and manage savings, used by CXOs to strategize on market competitiveness
  • Developed monitoring Practice model which set cost, hiring and talent management goal for each practice, region wise and helped to real-time track their progress - this led to clear and pro-active strategic and action-oriented insights for senior leadership
  • Developed CART model for Attrition using 5 year pipeline to better understand course of decision- making made by exited employees - this helped HR team set better retention targets and strategies based on phase of life of employee

Transformation Projects:

  • Lead development and automation of Demand Forecast for each region and practice units onto automated platform
  • Developed target monitoring tool for Practices on their Talent Delivery pipeline and Management
  • Created and automated data visualizations to present insights and tell compelling stories Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms Interpreted business questions and collaborated with engineering teams to identify data sources
  • Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices. Lead development and automation of Demand Forecast for each region and practice units onto automated platform
  • Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms
  • Interpreted business questions and collaborated with engineering teams to identify data sources
  • Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices.

Freelance Analytics Projects

Freelance
Bangalore
  • Online retail Orders Analysis To collate different data-tables and generate insights on orders and customers based on region and price buckets Skills- SQL, mySQL
  • E-Commerce Revenue Management Solution of a business problem to identify which region has maximum sales volume, which type of products are sold the most, how much revenue the E-Commerce Company makes, and the brands that use its portal. Skills- Python, CART
  • Auto-Car Customer Insights To identify which type of car, model is picked by which customer segment and show price analytics as well Skills- Python, EDA
  • Women's behavioral project on Contraceptives Using Classification techniques to classify how many women use or not use contraceptive and their path of decision Skills- Python, EDA, CART

Senior Transformation Lead

Infosys
Bangalore
11.2018 - 01.2022

In this role, I reported to the Head and Globally managed the Separations, Benefits & Abscond process delivering Automations, Digital Transformation on the projects and Analytics:


Notable Achievements:

  • Restructured procedures through coordination with compliance director to create and execute projects: Relieving Letter, Resignation Letter, Exit process automations which saved 2,000,000 INR per year
  • Compiled research data and gave professional presentations highlighting finds and recommended optimizations: Created and Developed Dashboards generating talent insights for high performers who exited bring down manual efforts to 0% and 100% automations freeing up 15% weekly bandwidth
  • Conducted thorough reviews of operations to devise and deploy improvement strategies. Leveraged on-site observation and personal interviews to identify team and individual strengths.
  • Created an Insider-Threat Detection model which allowed to leverage IT infrastructure and create potential data-leakage risk based profiles of support teams such as HR, Legal, Finance, etc. saving 500,000 annually in legal costs
  • Created and Deployed Talent Engagement Survey for top Accounts of Infosys and generated account-specific insights for Talent retention thereby streamlining retention processes that helped retain 2% more talent than in 2020

Employee Relations Manager

ICICI
Kolkata
04.2018 - 10.2018

Analytics:

  • Created a fraudulent management dashboard to track region and branch wise activities week-on-week
  • Created a robust talent engagement survey specifically designed separately for Sales, Mid-Management and Senior-Management
  • Created a weekly Sales Dashboard that help pro-actively strategize goals and provide insights to leadership which reduced manual tasks to 0%

KPIs:

  • Delivered team member services and customized employee programs focused on optimizing labor relations and communications.
  • Developed comprehensive employee relations programs and initiatives to increase organizational engagement.
  • Monitored and enforced company policies and procedures to determine compliance with applicable laws and regulations.
  • Devised robust training programs to strengthen investigatory skills, legal understanding, and motivational strategies.

Research Analyst

Indian Council for Social Science Research
Bangalore (Remote)
02.2015 - 02.2016
  • Participated in data mining activities to uncover insights from various sources.
  • Prepared detailed reports summarizing research findings and recommendations for further action.
  • Created visualizations to present research data and findings to stakeholders.
  • Developed survey instruments and designed experiments to test hypotheses and measure outcomes.
  • I analyzed statistical data that was collected on a Pan-India basis from different tea, rubber and coffee plantations on
    o Profile of women workers - education, health, sanitation and other socio-economic factors.
    o The welfare measure taken by Trade Union and the Management over a period of 5 years.
    o Health issues, absenteeism an productivity
    o Gender difference in working environment of labor rights and unionism.
    o Role of NGOs in augmenting social defense was assessed.

Education

Master of Science - Data Science

Deakin University, Australia
10.2022 - Current

Online Masters from Deakin University pursuing while working

EDP Data Science - Data Science

XLRI, Jamshedpur
02.2021 - 01.2022

MBA - HR

International Management Institute (IMI), New Delhi
06.2016 - 04.2018

HR (Major) IT & Analytics (Minor)

Master of Science - Chemistry

North Eastern Hill University, Shillong
06.2012 - 06.2014

Bachelor of Science - Physics-Chemistry-Math

Christ University, Bangalore
06.2009 - 06.2012

Skills

    Excel

undefined

Accomplishments

Capgemini:

  • Awarded the “Out of the Box” award for exceptional performance in 2023
  • Awarded the “Out of the Box” award for exceptional performance in 2022
  • Chosen amongst women top performers globally and chosen into Capgemini's Avancer Women Leadership Program

Infosys:

  • Awarded the “Insta Award” for exceptional performance in project management role in 2021
  • Awarded the “Insta Award” for exceptional performance in project management role in 2019

Certification

Understanding and Visualizing Data using Python (University of Michigan)

Timeline

Deakin University - Master of Science, Data Science
10.2022 - Current

Understanding and Visualizing Data using Python (University of Michigan)

06-2022
Analytics & Program Manager (Global COO Office) - Capgemini
01.2022 - Current

People Analytics (Infosys)

09-2021

Data Manipulation with Pandas (Datacamp)

05-2021

Intermediate Python-Data Science (Datacamp)

05-2021
XLRI - EDP Data Science, Data Science
02.2021 - 01.2022
Senior Transformation Lead - Infosys
11.2018 - 01.2022
Employee Relations Manager - ICICI
04.2018 - 10.2018
International Management Institute (IMI) - MBA, HR
06.2016 - 04.2018
Research Analyst - Indian Council for Social Science Research
02.2015 - 02.2016
North Eastern Hill University - Master of Science, Chemistry
06.2012 - 06.2014
Christ University - Bachelor of Science, Physics-Chemistry-Math
06.2009 - 06.2012
Freelance Analytics Projects - Freelance
Debarati Das GuptaAnalytics & Program Manager