Gourab Mondal — Business Development Executive

A passionate data enthusiast madly in love with data driven insight. With 3 years of experience in customer insights analysis, I specialize in understanding customer behavior and journey patterns across websites and apps. I focus on customer segmentation based on ad exposure, demographics, activity recency, and loyalty, delivering actionable insights to drive business growth. I analyze how customers interact with platforms, including active times, preferred days, and preferences, to help clients optimize their strategies. My expertise includes full-funnel analysis, where I examine customer behavior and the impact of campaigns on transactional paths, from adding items to the cart to conversion rates, abandonment rates, and competitor switching. I also have experience in innovative automation projects that streamline processes and improve customer engagement. I have worked with the growth team at Swiggy Instamart, focusing on customer segmentation based on recency, frequency, and monetary value. I work on retention analysis, customer acquisition, churn prevention, and revenue optimization. I also conduct in-depth analysis of daily traffic trends, conversion rates, and the underlying causes of fluctuations in performance. Additionally, I'm involved in forecasting and strategizing for the future plan, while providing quick RCA for any unexpected issues that arise. Currently I'm working in building one of the most premier, lovable and Rewarding Earned Loyalty Programme in India. My skill set includes proficiency in SQL, Excel, Python, and Power BI. I hold a Bachelor's degree in Chemical Engineering from NITDGP (batch of 2022) with a first-class distinction. During my leisure time, I enjoy Modelling and Dancing.

Stackforce AI infers this person is a data-driven analyst specializing in customer insights within the e-commerce and food delivery sectors.

Location: Bengaluru, Karnataka, India

Experience: 3 yrs 10 mos

Skills

Data Analysis
Business Strategy
Customer Insights

Career Highlights

Expert in customer insights and behavior analysis.
Proficient in SQL, Python, and data visualization tools.
Led innovative automation projects for customer engagement.

Work Experience

Flipkart

Senior Business Analyst - Loyalty and Subscription (9 mos)

Swiggy

Business Analyst - Growth and Strategy (8 mos)

Tredence Inc.

Senior Business Analyst - Marketing (5 mos)

Business Analyst - Display & SP Ad (2 yrs)

Education

Bachelor of Technology - BTech at National Institute of Technology Durgapur

Higher secondary at Fatepur sreenath institution

Secondary education at Sarisha Ramkrishna mission sikhamandir

Gourab Mondal

Business Development Executive

Bengaluru, Karnataka, India3 yrs 10 mos experience

Key Highlights

Expert in customer insights and behavior analysis.
Proficient in SQL, Python, and data visualization tools.
Led innovative automation projects for customer engagement.

Stackforce AI infers this person is a data-driven analyst specializing in customer insights within the e-commerce and food delivery sectors.

Contact

Skills

Core Skills

Data AnalysisBusiness StrategyCustomer Insights

Other Skills

SQLExcelPythonPower BIMySQLGoogle BigQuery

About

Experience

3 yrs 10 mos

Total Experience

1 yr 6 mos

Average Tenure

9 mos

Current Experience

Flipkart

Senior Business Analyst - Loyalty and Subscription

Aug 2025 – Present · 9 mos

1. Built and automated the Plus Program Health Tracker, covering plus inflow/outflow trends, transacting base growth, GMV, and plus share in the overall Flipkart platform.
2.Built an end-to-end analytical framework to evaluate TREAT- (milestone gift to form a habit )performance across offer, claim, and redemption funnels, measuring retention, frequency uplift, and incrementality to drive customer stickiness and journey optimization
3.Developed an analytical framework to track partner bank offer adoption, burn, and retention, benchmarking against non-PBO PLUS and non-PLUS cohorts to quantify incremental uplift driven by PBO.
4.Led data-driven PLUS AOP 2026 planning by forecasting GMV, orders, active customers, and Super Coin burn under multiple scenarios, including monthly earn-cap simulations driving ~3.2% cost savings and instant downgrade logic for Gold members delivering ~3.5% savings, to optimize growth within budget constraints.
5.Led P&L-driven simulations for the Black subscription program to evaluate pricing and benefit redesign, modeling Super Coin benefit changes to quantify impact on adoption, monthly active customers, and Super Coin cost savings using percentile-based burn analysis.
6.Built an automated real-time reporting framework for Event Day performance, enabling hourly and daily tracking of GMV, burn, adoption and customer metrics.

SQLExcelPythonPower BIData AnalysisBusiness Strategy

Swiggy

Business Analyst - Growth and Strategy

Dec 2024 – Aug 2025 · 8 mos · Banglore

Designed and owned retention analytics framework across weekly/monthly cohorts segmented by lifecycle stage (New, Repeat, Dormant) and order frequency; tracked M0/M1 KPIs (D+1, 2nd order in 14 days, 5 in 35 days) and built cohort movement dashboards to quantify reactivation impact.
Built advanced user segmentation models (VH/HF/MF/LF) using behavioral and frequency signals; conducted intervention impact analysis to measure lift in order frequency, wallet share, and repeat rate.
Performed deep funnel diagnostics (Visitor → Menu → Cart → Order), quantifying stage-wise conversion drop-offs; analyzed sensitivity to surge pricing, delivery fee thresholds, and PSLA to recommend data-backed optimization levers.
Led experimentation & marketing analytics using test vs control frameworks across Meta, Google, Push, and WhatsApp; evaluated incremental TU%, GMV/user, retention lift, and CPS efficiency through structured experiment design.
Developed behavioral scorecards for early (<10 orders) and matured (10+ orders) users, identifying churn signals and predictive indicators to inform personalized CRM triggers and lifecycle nudges.
Owned GMV and customer base forecasting using top-down and bottom-up models; translated projections into campaign-level targets and budget allocation guidance across Tier 1 vs Tier 2 and Shell vs Super App cohorts.

MySQLSQLCustomer InsightsData Analysis

Tredence inc.

2 roles

Senior Business Analyst - Marketing

Promoted

Jul 2024 – Dec 2024 · 5 mos

MySQLSQL

Business Analyst - Display & SP Ad

Jul 2022 – Jul 2024 · 2 yrs

Performed transactional analysis across new, repeat, and reactivated customers to identify sales trends, AOV movement, and customer behavior shifts supporting data-driven media decisions.
Built detailed media audience profiles and conducted competitive benchmarking to assess brand health, mitigate churn, and optimize media planning toward high-value customer segments.
Analyzed end-to-end customer journeys including search behavior, traffic sources, and path-to-conversion to measure the impact of advertising exposure on conversion and ROAS across app and dotcom platforms.
Evaluated traffic and conversion trends across app vs. dotcom and brand vs. category views to understand customer engagement patterns relative to competitors.
Conducted search trend and keyword performance analysis, tracking search volume growth and conversion rates to inform sponsored search and media activation strategies.
Analyzed add-to-cart behavior, abandonment, and competitor switching to identify drop-off points and recommend actions to reduce churn post cart-addition.
Assessed the combined impact of display, sponsored, onsite, and offsite media on conversion rates, AOV, and brand spend, quantifying how multi-touch exposure influences purchase decisions.

MySQLGoogle BigQueryData AnalysisCustomer Insights