Bala Ram Serawat

Operations Associate

Bengaluru, Karnataka, India9 yrs 7 mos experience

Most Likely To Switch

Key Highlights

Delivered over 11K incremental orders through analytics.
Reduced query abandonment by 3.6% with data-driven insights.
Scaled MTUs by 3.8% at Airtel through strategic analysis.

Stackforce AI infers this person is a data-driven analytics expert in the E-commerce and Telecommunications sectors.

Contact

Skills

Core Skills

AnalyticsData AnalysisBusiness Analysis

Other Skills

A/B TestingMicrosoft ExcelBusiness IntelligenceProblem SolvingSQL/Hive/Snowflake/Data BricksFunnel Change RCASprint Prioritization and planningManaging Analytics team for Storefront and content PODStatisticsPython (Programming Language)TableauTeam ManagementLogical ApproachRequirements AnalysisVBA

About

With over 8 years of experience driving data-backed decisions across Swiggy, Airtel, Udaan, and Meesho, I specialize in solving complex business problems through analytics. My expertise lies in funnel optimization, personalization, and KPI tracking—supported by tools like SQL, Hive, Tableau, Power BI, and Python (Pandas). Currently leading analytics for Swiggy’s storefront and content, I’ve built frameworks that delivered +11K incremental orders, reduced query abandonment by 3.6%, and revamped rating systems to boost UX and engagement. At Airtel, I scaled MTUs by 3.8% and led clickstream instrumentation for the high-impact "Manage" section of the app. I take pride in blending strategic thinking with hands-on data work, mentoring analysts, and building systems that scale. Always curious, always optimizing.

Experience

9 yrs 7 mos

Total Experience

1 yr 11 mos

Average Tenure

2 yrs 7 mos

Current Experience

Swiggy

Analytics Manager

Nov 2023 – Present · 2 yrs 7 mos · Karnataka, India · Remote

Owns Storefront and content POD analytics, sprint prioritization, execution with leading team of 3 analysts
Created framework to identify connected customers to enhance personalisation, improve UX, and drive engagement, resulted in ~11k incremental orders(iOPD)
Revamped restaurant rating system to align with Zomato, boosting rating coverage by ~6%, M*C up by 30 bps
Introduced impact for like/dislike signals in item rating shown on app, booked 7.5k iOPD
Decreased Query Abandonment Rate (QAR) by 3.6% through data-driven analysis of pivotal factors
Design and Evaluated A/B experiments to inform product strategies and optimize user experience
Collaborated with cross-functional teams to drive analytics initiatives and enhance strategic planning

Data AnalysisA/B TestingAnalytics

Bharti airtel

Lead Analyst, Products

Sep 2022 – Nov 2023 · 1 yr 2 mos · Gurugram, Haryana, India · On-site

1. Leading Analytics charter for one of the big pods(Manage section) on the Airtel Thanks App
2. Improving digital penetration by optimising journeys like recharge or pay bills, change plan, manage family connections etc on Thanks App
3. Cohort identification and opportunity sizing for increasing app MTU by ~53%
4. Defining, Tracking(Tableau dashboard), and Improving KPIs
5. Leading team of 4 peoples for setting up clickhouse event tracking for new product/feature addition

Microsoft ExcelData AnalysisAnalytics

Udaan.com

Supply Analyst

Jan 2020 – Aug 2022 · 2 yrs 7 mos · Bengaluru, Karnataka

Responsible for active tracking of KPI like shipped %, FAP, O2RTS, returns, MR productivity etc for lifestyle category and highlighting gaps to respective stockholders, Setting up P&L tracking for the category, Formulating strategies for achieving top line, Driving category operations

Business IntelligenceProblem SolvingAnalyticsBusiness Analysis

Meesho

Business Analyst

Jun 2019 – Jan 2020 · 7 mos · Bangalore

Creating various algorithms for optimizing demand & supply data. Data analysis and solution building based on insights capture from data. Responsible for giving insights to management and help in strategic planning. Analyze metrics, key indicators, and other available data sources to discover root causes of process defects. Support business development and help to create efficient designs and solution processes. Determine the efficient utilization of resources. Actively engage with internal partners throughout the organization to meet and exceed customer service levels & transport-related KPI's. Research and implement cost reduction opportunities.

Analytics quotient

2 roles

Senior Business Analyst

Promoted

Apr 2018 – May 2019 · 1 yr 1 mo

Worked on multiple projects with the major beverage, telecom & financial services clients aimed at providing information on qualitative measures like Brand Imagery, Brand Equity, Brand Association, Brand Awareness, and Customer Experience Analysis (NPS). My primary responsibilities include understanding the client’s brand’s customer survey data, understanding the client’s requirement and problems. Getting information from the analysis of clients data and reports, handling a team of 7 members to process the data and prepare a marketing dashboard which would help my client to take major decisions regarding brand, marketing, and innovation. The work involves interacting with the client, data processing teams across geographies and internal technical & DV team.

Business Analyst

Aug 2016 – Mar 2018 · 1 yr 7 mos

I had an experience in data discovery, analyzing survey data using different tools like SQL, SPSS, Excel etc, defining calculation logic, making test cases, quality assurance and proactive communication of project status with the technology team.