Summary
Overview
Work History
Education
Skills
Software
Accomplishments
Certification
Timeline
Generic
Monika Dutta

Monika Dutta

Gurgaon

Summary

Dynamic and skilled Technology Consultant with a 7+ year experience in driving results through analytics, cross-functional collaboration, and client-focused advisory & consulting solutions. Demonstrated success leading diverse projects in ende-to-end ETL design, data analysis & optimization and data migration. Successfully partnered with international clients across Finance, CX Benchmarking, Digital Analytics, HR, Supply Chain, and Healthcare domains, delivering data driven solutions.

Overview

7
7
years of professional experience
1
1
Certification

Work History

SENIOR ASSOCIATE

BAIN & COMPANY
02.2023 - Current

CX Benchmarking Product/Operations Management for 8+ Telecom Clients:

  • Managed multiple B2B and B2C projects across Telecom and Insurance domains, delivering high-quality, zero-defect results and helping clients optimize their customer experience metrics.
  • Led biggest account of team (US Telecom Giant, generating ~1.5 million USD revenue), successfully delivering project in 2023. Addressed crucial client concerns, created apt advisory solutions to increase their NPS score
  • Proactively planned and executed daily work plans for my team, identifying and resolving roadblocks to avoid delays by helping team build QC and process automation
  • Mentored junior team members, by sharing technical knowledge and building reusable capabilities.
  • Helped design and execute new benchmarking surveys, crafting primary research instruments and sample specifications
  • Responded to inquiries from onshore teams and clients regarding data and insights, ensuring clarity and satisfaction.
  • Collaborated with Leadership team as presenter to win firm-wide Results challenge (3 lakh prize).

SENIOR ASSOCIATE

PRICEWATERHOUSE COOPERS SERVICES LLP
08.2021 - 02.2023

Risk & Independence Visualization tool:

  • Designed and implemented KPIs, created data model, and user-friendly reporting layers to improve engagement tracking and visibility.
  • Provided tailored demo sessions, equipping managing partners across all PwC lines of services with knowledge to leverage the dashboard's functionalities.
  • Designed and implemented a robust security model for Power BI tool, safeguarding sensitive information.

Data Migration Project for a European giant:

  • Led successful bulk migration and transformation of data from legacy systems to Oracle ERP cloud platform, ensuring data accuracy and efficiency.
  • As Subscription lead for more than 10+ business units, actively collaborated with stakeholders, designing optimal workflows and data mappings for smooth transition from onshore team to Indian functions.
  • Designed and implemented various ETL frameworks (like Error Handling, Batch & Parameterized Input) to schedule and automated assessment reports for Clients, which improved loading time by 30 %.

SENIOR ANALYTICS ADVISORY ANALYST

ACCENTURE SOLUTION PVT. LTD
09.2016 - 08.2021

Healthcare Analytics for UK Supply chain client:

  • Designed concise Qlikview data model to optimize the process and provide the end users with detailed analysis of different Key performance indicators. The reports helps Philips streamline investments on material purchase cost & production cost.
  • Facilitated effective client communication, planned and met the deliverable timelines and effectively customized dashboards to accommodate user requests and innovative features.
  • Set the stage for augmented analytics projects for this client by developing an interactive Qliksense POC on Augmented analytics which helped in creating road map for future projects.

HR Data Analytics & reporting for US Software Solutions Client:

  • Led the initiative to improve crucial hierarchy/taxonomy modifications whose objective was to plan and deploy the new organizational hierarchy in relevant objects in the reporting database, SSRS reports and applications).
  • Facilitated effective stakeholder communication, coordinated and streamlined the deliverables managed by the 8- member technical team, efficiently and ensured on-time delivery for crucial reports and applications.

Social Media Analytics & reporting:

  • Implemented centralized ETL flow for processing of data across all the verticals and horizontals from large unstructured data sources as opposed to manual data cleansing, which reduced the processing time by 40%
  • Involved in different phases of project from requirement gathering, designing and QC of SSIS Tableau solution and database architecture to store social media campaigns, traffic metrics and visits data segregated by locations, operating groups and business functions.

Education

BE - Chemical Engineering

BIRLA INSTITUTE OF TECHNOLOGY MESRA
Ranchi

Class XII (CBSE) - PCM With Computer Science

DELHI PUBLIC SCHOOL R.K. PURAM
New Delhi

Class X (CBSE) -

DELHI PUBLIC SCHOOL KORBA
Korba

Skills

  • QlikView/Qlik Sense
  • MS/PL SQL
  • SSIS and SSRS
  • Power BI
  • Microsoft Office
  • Tableau

Software

Team Management

Data driven decision making

Stakeholder Management

Analytical Mindset

Effective Communication

Collaborative Learning

Accomplishments

  • CO-CURRICULAR:
  • Won Star of the Business for Q1'19 in Accenture
  • Gold Medalist, Chemical Engineering Department, BIT Mesra
  • Served as Student Training and Placement Coordinator, BIT Mesra
  • Served as Vice President, Dance club, BIT Mesra
  • Gold medal award for achieving above 85% for consecutive 8 years,DPS Korba & DPS R.K. PURAM
  • EXTRA CURRICULAR:
  • Dance: Trained in Classical & Semi-Classical dance forms and won 3rd prize in the Bharatnatyam & Kuchipudi category in All India Classical dance event.
  • Student's Quality Circle:1st prize in Case study presentation, Poster and Drama events, International convention on Students’ Quality Control Circle, held in Mauritius and Lucknow.
  • Sports: Participated in South & Central zone Inter- DPS Swimming competition (under 14) and won several accolades in athletics events conducted on school level.

Certification

Google Data Analytics Specialization

Timeline

SENIOR ASSOCIATE

BAIN & COMPANY
02.2023 - Current

Google Data Analytics Specialization

06-2022

SENIOR ASSOCIATE

PRICEWATERHOUSE COOPERS SERVICES LLP
08.2021 - 02.2023

SENIOR ANALYTICS ADVISORY ANALYST

ACCENTURE SOLUTION PVT. LTD
09.2016 - 08.2021

BE - Chemical Engineering

BIRLA INSTITUTE OF TECHNOLOGY MESRA

Class XII (CBSE) - PCM With Computer Science

DELHI PUBLIC SCHOOL R.K. PURAM

Class X (CBSE) -

DELHI PUBLIC SCHOOL KORBA
Monika Dutta