Mahak Agrawal

Business Development Executive

Gurugram, Haryana, India11 yrs experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Led transformative projects saving millions.
  • Expert in data analytics and forecasting.
  • Proven track record in enhancing customer experience.
Stackforce AI infers this person is a Business Analyst specializing in Data Analytics and Forecasting within the SaaS industry.

Contact

Skills

Core Skills

Business AnalysisData AnalyticsForecasting

Other Skills

Data AnalysisCustomer NPS AnalysisSQLTableauReportingCohort AnalysisExcelData StudioStatistical ModellingRoracle epbcsStrategic PlanningProject ManagementCC++

About

As an experienced Business Analyst with rich work experience in Data Analytics, I try to find optimal solutions for issues faced by clients, both internal and external. With good leadership and team building abilities, I am in a constant pursuit of new challenges leveraging my entrepreneurial mindset. I aim to utilize technology, innovation and knowledge ensuring comprehensive growth and all round development. Skilled in MS Excel, Tableau, Data Studio, Airflow, R programming, PowerBI, and SQL

Experience

11 yrs
Total Experience
1 yr 6 mos
Average Tenure
5 yrs 1 mo
Current Experience

Airbnb

2 roles

Senior Analyst, Advanced Analytics

Promoted

Jul 2022Present · 3 yrs 10 mos

  • Codify Project – Led the overall analysis for Codify Project which transformed the way in which Service Ambassadors operate, pegged to bring 35M USD in savings
  • Helped achieve NPS 60 from 45 from my recommendations derived from Customer NPS Analysis vis-à-vis various dimensions, such as resolution time, survey responses, SLA, Agent touches and tenure, Escalations, contact reasons for different service tiers and channels
  • Conducted a study of TTR (Total Time to Resolution) of customer tickets, wherein I drew parallels between Ticket closure time and actions taken by Customer Support, and recommended steps to bring down TTR from 5 days to 2 days
  • Led the analysis to increase resolution rate from 72% to 77% by studying the relation between TTR, Expenses and Cancellation Policy for different scenarios raised/faced by the Customer
  • Brought down Support Messaging SLA from 24 hours to 2 hours by presenting data backed evidence on how it would lead to a 10-point NPS increase
  • Awards:
  • 1. Q3'25 Global Operations Award
  • 2. Above and beyond Award - Q4 2022
Data AnalysisCustomer NPS AnalysisSQLTableauBusiness AnalysisData Analytics

Senior Forecast Analyst

Apr 2021Jul 2022 · 1 yr 3 mos

  • · Responsible for the end-to-end creation of Airbnb’s monthly forecast in the FP&A Forecasting team, to forecast metrics from nights booked to revenue which is used for budgeting, goal-setting, staffing, and valuation (time saving ~1 hr/day)
  • · Built an automated model to capture revenue forecast by currency for all regions, and many other visual cuts
  • · Leveraged my skills on SQL and Tableau to migrate entire processes from legacy systems, making reporting easier
  • · Owned crucial reporting artefacts from ensuring upload, data sanctity, and sense checks to creating the right view for CFO
  • · Projects include segmenting guests leveraging cohort analysis using their booking behaviour, to help forecast nights booked · Development and analysis of the Lead time for Nights Booked using Tableau Dashboards
  • · Migration of Forecasting Models and Dashboards from Google sheets to Oracle EPBCS Systems
SQLTableauForecastingReportingData Analytics

Ht digital streams

Senior Business Analyst

Sep 2019Apr 2021 · 1 yr 7 mos · New Delhi Area, India

  • · Analytics lead for Subscription on LiveMint, Hindustan Times and Live Hindustan (leading Indian Dailies) · Highlighted product features and funnel enhancements that were included in the Subscription Product
  • · Developed analytics capability for integration of 3rd party tools – WebEngage, Deep.bi, Zoho desk, etc. which helped in enhanced tracking and uncover insights on customer behaviour
  • · Helped in forecasting the churn, retention, and up-sell/cross sell opportunities for subscribers
  • · Identified the key factors responsible for driving traffic and provided key insights which helped in increasing the
  • engagement for HT Websites- Live Hindustan, LiveMint, and Epapers
  • · Designed meaningful metrics indicating product health and developed business reports on Tableau to track the movement of
  • these metrics on a regular basis
  • · Winner, Business Enabler Award, HT Digital Streams (July’20) · Winner, Q1 Digistar Award, HT Digital Streams (May’20)
Data AnalysisTableauCohort AnalysisBusiness AnalysisData Analytics

Paytm

Business Analyst

May 2018Sep 2019 · 1 yr 4 mos · Noida Area, India

  • Responsible for growth of movie ticketing business
  • · Designed dashboards, leveraging Excel, Tableau, Hive, Data Studio, and automated reports that allowed leadership to monitor the business in real time
  • · Drove product improvement features to enhance user experience, traffic, and conversion, coordinating with multiple teams
  • · Studied User Retention by categorizing new, and dormant users and devised strategies to drive retention
  • · Customer Segmentation & Cohort Analysis – Analysis of buying behaviours of customers (basis demographics and spend pattern) · Affinity model - Analysing target customer’s buying preferences in other categories on Paytm; other online merchants and
  • facilitators (wallets/banks/cards) for cross-sell/up-sell opportunities
  • · Cashback Analysis – Optimizing cashback to retain existing users as well as engaging new users
  • · Competition Analysis – Basis research on competition’s offers, I was instrumental in devising the counter-active strategy to generate new customer base for Paytm
ExcelTableauData StudioBusiness AnalysisData Analytics

Credit suisse

Business Analyst

Jun 2017Mar 2018 · 9 mos · Mumbai, Maharashtra, India

  • · Worked directly with Asia Senior Management and their teams to develop insightful reports and dashboards using Tableau for gauging Relationship Manager’s performance/productivity and ad-hoc analysis on clients, products, and human capital
  • · Worked on finance controller’s assignments such as Expense Accruals & Review, Insurance Amortization, Equity Broking journal, Revenue Accruals, MF Debtors Recon, PB to IB transfers, GST calculations on MF receipt, RM Scorecard calculation and CAMS
  • · Created periodical reports ensuring accuracy and timelines across different dimensions such as costs/clients/ products/markets
TableauReportingData AnalysisBusiness AnalysisData Analytics

Indiamart intermesh limited

Business Analyst

Apr 2016Feb 2017 · 10 mos · Noida Area, India

  • · Worked on assignments involving Statistical modelling (predictive analytics, forecasting, segmentation, and data analysis)
  • · Successfully managed complete implementation of Suspect-Prospect-Approach-Negotiate-Closure-Order Won/Lost (SPANCO), an online tool for tracking the entire selling cycle
  • · Applied techniques such as regression modelling, cluster & factor analysis, time-series analysis, using R language
  • · Analysed the existing Keyword Premium Listing customer profiles, customer queries and feedback and established the
  • relation between marketing spend to listing on the portal and the return generated
  • · Analysed the customer engagement parameters to locate customers who can spend more on the company’s products and
  • mapped their usage patterns with other products which could be sold or renewed
Statistical ModellingData AnalysisRData AnalyticsBusiness Analysis

Videocon consumer durables

Talent Acquisition

Aug 2015Sep 2015 · 1 mo · Gurgaon

  • Worked with Talent Acquisition Team to hire Sales Representatives for Videocon AC Channel Sales division at different locations.

Grofers

Grofers Brand Ambassador Program :- Expand Market Consumption through Strategic Engagement

Aug 2015Sep 2015 · 1 mo

Baxter (india) pvt. ltd.

Summer Intern

Apr 2015Jun 2015 · 2 mos · Gurgaon, India

  • I have worked on two different projects in the Human Resource Department of Baxter India Pvt. Ltd.
  • 1. Standardization of Policies across Manufacturing Plants
  • 2. Analysis of competitor's Rewards and Recognition Policies to enhance Baxter's current practices

Roads less travelled

Digital Marketing

Apr 2015May 2015 · 1 mo

  • As a part of the project I have completed all three following levels of the project.
  • 1. Improving Social Signals on Online Travel Product.
  • 2. Understanding Consumer flow on website using Google Analytics.
  • 3. Understand & implement social signals from Third-Party Travel App.

Channel play ltd.

Retail Engagement Representative (RER)

Sep 2014Oct 2014 · 1 mo

  • The objective of the project was to spread awareness about Android Technology among various retailers. The key responsibility was to approach & train designated retailers on various aspects of Android Software, which primarily focused on features & benefits of this technology.
  • Key Learning:
  • Opportunity to understand the Android penetration level in the Indian mobile market
  • Engagement & interaction opportunity with big mobile retailers
  • Opportunity to appraise & train the retailers on this technology
  • On-field exposure of how, product marketing happens

Indus valley partners

Associate Software Engineer

Jun 2013Jun 2014 · 1 yr · Noida Area, India

  • · Owned end-to-end implementation of IVP- Recon by analysing trade and cash reports
  • · Interacted with international clients to understand and capture their functional & technical requirements, trading
  • strategies, broker relations, reporting needs for powerful reconciliation
  • · Worked closely with the QA team to automate the Recon Creation process to minimize the testing lead time

Gmr group

Intern

Jul 2012Dec 2012 · 5 mos · New Udaan Bhawan, Opposite IGI terminal

  • Operation and Maintenance of Baggage Handling system at the Indira Gandhi International Airport

Rockwell automation

Summer Trainee

Jun 2012Jul 2012 · 1 mo

  • Study of PLC and Power Plants Board Manufacturing circuiting.

Education

Thapar Institute of Engineering & Technology

Bachelor of Engineering (B.E.) — Electronics Instrumentation & Control

Jan 2009Jan 2013

FORE School of Management, New Delhi

PGDM — Finance-HR

Jan 2014Jan 2016

The Hong Kong Polytechnic University

Jan 2015Jan 2015

Netaji Subhash Institute of Technology

Bachelor of Engineering (B.E.) — Manufacturing Process and Automation

Jan 2009Jan 2010

Bal Bharati Public School

Modern Public School, Shalimar Bagh

Stackforce found 100+ more professionals with Business Analysis & Data Analytics

Explore similar profiles based on matching skills and experience