Mayank Shekhar
Senior Analytics Manager | Data & Product Analytics | AI-Driven Decision
Bangalore
Summary
Senior Analytics Leader with 8+ years of experience driving data-driven strategy across e-commerce, mobility, and retail platforms including Swiggy and Ola. Proven track record of building AI-powered analytics systems, predictive models, and scalable data pipelines influencing ₹1.8Cr+ monthly business impact, improving retention by 14%, and delivering 70% automation efficiency.
Expert in SQL, Python, Snowflake, and BigQuery with deep experience in growth analytics, monetization, pricing strategy, forecasting, and experimentation. Experienced in leading analytics teams and partnering with product, marketing, and business leadership to translate data into high-impact strategic decisions.
Leadership Impact
- Built AI-powered analytics assistant (LLM + Snowflake) enabling natural language insight generation for business teams.
- Delivered ₹1.8Cr monthly revenue impact through brand intelligence analytics.
- Improved customer retention by 14% using cohort analytics frameworks.
- Built forecasting models with 92% prediction accuracy.
- Automated reporting pipelines reducing manual workload by 70%.
- Generated ₹4L weekly cost savings through operational automation.
Overview
8
8
years of professional experience
3
3
Languages
Work History
Manager, Data Analytics
KPN Fresh
Bangalore
2025.09 - Current
- Analytics Automation & Data Infrastructure:- Designed and deployed a Python + SQL automated reporting pipeline for newly opened stores, reducing manual reporting workload by 70% while accelerating leadership decision cycles.
- Marketing & Growth Analytics:- Led deep-dive performance analysis for YouTube Ads and Google PMAX campaigns, identifying optimization opportunities across reach, CTR, and conversion efficiency.
- Omnichannel Attribution Framework:- Developed attribution models linking Meta store-visit campaigns to offline sales uplift, enabling accurate measurement of marketing ROI and improving budget allocation decisions.
- Executive Performance Dashboards:- Built integrated leadership dashboards combining digital campaign metrics (CTR, CPC, Impressions) with retail KPIs (GMV, ABV, NOB) to provide a unified performance view across marketing and retail operations.
Manager, Category Analytics
Swiggy
Bangalore
2022.10 - 2025.08
- Team Leadership & Innovation: Led, mentored, and trained a 5-member analytics team responsible for category growth strategy, advertising analytics, and inventory optimization, strengthening the team’s analytical capabilities and enabling data-driven decision making across cross-functional stakeholders.
- AI & Decision Intelligence:- Built Category Mitra, an LLM-powered analytics assistant integrated with Snowflake, enabling business users to generate insights using natural language queries and reducing dependency on manual SQL analysis.
- Brand Intelligence Platform:- Developed automated Brand Insight reports across cities and dark stores, analyzing share of voice, retention, and customer mix — influencing ₹1.8 crore in monthly business impact.
- Customer Retention Analytics:- Developed advanced Brand × Category cohort SQL frameworks to analyze retention and behavioral patterns, improving category retention rates by ~14%.
- Predictive Forecasting:- Designed daily GMV and order forecasting models achieving ~92% accuracy, enabling proactive supply and inventory planning.
- Inventory & Assortment Optimization:- Built POD-level assortment optimization models improving product availability and driving 9.2% monthly GMV growth.
- Ads & Monetization Analytics:- Built campaign attribution and ROI measurement models linking ad spend to GMV growth, improving advertiser targeting efficiency and monetization strategy.
- Pricing Strategy Analytics:- Developed Python-based price elasticity models to guide pricing decisions across urban markets.
- Operational Automation:- Automated offer configuration workflows, eliminating manual errors and delivering ~₹4 lakh weekly cost savings.
Business Associate
Swiggy
Bangalore
2021.08 - 2022.09
- Built dynamic ads performance dashboards across multiple ad properties enabling campaign optimization.
- Designed automated sales reporting dashboards providing daily, weekly, and monthly business insights.
- Led the development of NPI / BDPO / SDPO operational tracking systems to streamline product launches and promotional offer uploads, improving workflow efficiency for category teams and saving ~2 hours of manual effort per day.
- Implemented automated data validation frameworks improving data accuracy and operational reliability.
Business Analyst
Blackbuck
Bangalore
2021.02 - 2021.08
- Reporting Automation: Streamlined reporting by building daily, weekly, and monthly performance reports, providing the sales team with timely and accurate insights.
- Data Audit Mechanism: Implemented an audit system to verify meeting records submitted by the ground sales team, strengthening accountability and documentation quality.
- Google Apps Script + MySQL Automation: Engineered automated workflows using Google Apps Script and MySQL to integrate data and generate multiple Google Sheets reports, significantly improving operational efficiency.
- Led the development of an automated incentive payout system for ASMs, TSLs, and CROs, replacing a 3-day manual compensation calculation process with a scalable automated solution, improving operational efficiency, accuracy, and transparency in performance-based payouts.
Business Analyst
Apollo 24|7
Hyderabad
2020.07 - 2021.02
- Performance Reporting: Delivered daily, weekly, biweekly, and monthly performance reports, enabling stakeholders to access timely and comprehensive insights for better decision-making.
- Dashboard Development: Built custom dashboards in Google Data Studio to track key metrics across multiple dimensions, improving visibility and supporting data-driven planning and saving 3 man hours per day.
- Pharmacy Performance Analysis: Conducted detailed analyses of pharmacy operations to evaluate key metrics, diagnose gaps, and recommend improvement opportunities.
- Led the implementation of a Drupal-based scalable CMS platform to centralize medicine content creation and publishing, eliminating manual workflows where multiple writers duplicated efforts, and enabling efficient collaboration, version control, and scalable content operations.
Business Analyst
Medcords Healthcare
Pune
2019.11 - 2020.07
- Business Analysis & Insights: Delivered comprehensive business analysis reports with clear, actionable recommendations to address challenges, unlock opportunities, and drive business outcomes.
- Process Mapping & Optimization: Applied data-driven process mapping to identify operational bottlenecks and proposed targeted improvements to enhance efficiency.
- Insightful Reporting: Produced detailed reports with concise insights and recommendations, guiding stakeholders toward effective solution implementation.
- Product Collaboration: Collaborated with product managers in a cross-functional environment to refine product features and align enhancements with market needs.
- Sales Optimization: Partnered with the sales team to apply data-driven methods for sales performance improvement, identifying growth opportunities through metric analysis.
- Led the development of an automated doctor allocation and case management system, optimizing resource utilization and replacing manual workflows, resulting in ~3 hours of operational time savings per day.
Analyst
Ola Cabs
Bangalore
2018.07 - 2019.06
- Fraud Pattern Analysis: Conducted deep analysis of customer and partner behavior to identify patterns and uncover potential re-completion fraud cases, enabling targeted product fixes.
- SQL-Based Fraud Detection: Led the development of SQL-based fraud detection systems to identify off-platform transactions and misuse patterns, enabling enforcement actions against drivers and resulting in ~₹5 lakh in average daily fraud penalties, significantly improving fraud compliance on the platform.
- Risk & Process Improvements: Recommended process enhancements based on analytical findings to proactively reduce operational and financial risks, supporting continuous improvement initiatives.
- Product Issue Resolution: Applied analytical insights to diagnose and resolve product issues, driving strategic fixes and improving overall product functionality.
Education
B.Tech. - Information Technology
Netaji Subhash Engineering College
Kolkata, West Bengal2016-08
Skills
Analytics: SQL, Python, Forecasting, Pricing Analytics, Cohort Analysis, Excel
Data Platforms: Snowflake, BigQuery, Databricks, MySql
Visualization: Power BI, Tableau, Looker, Qlik View, Qlik Sense
Marketing Analytics: GA4, AppsFlyer
Timeline
Manager, Data Analytics
KPN Fresh
2025.09 - Current
Manager, Category Analytics
Swiggy
2022.10 - 2025.08
Business Associate
Swiggy
2021.08 - 2022.09
Business Analyst
Blackbuck
2021.02 - 2021.08
Business Analyst
Apollo 24|7
2020.07 - 2021.02
Business Analyst
Medcords Healthcare
2019.11 - 2020.07
Analyst
Ola Cabs
2018.07 - 2019.06
B.Tech. - Information Technology
Netaji Subhash Engineering College
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English | Advanced
Bilingual or Proficient (C2)
Hindi | Native
Bilingual or Proficient (C2)
Bengali | Intermediate
Advanced (C1)
Honors & Awards
SwiggyStar Award - Aug'23
Honors & Awards
SwiggyStar Award - Aug'23