Skip to main content
Mayank ShekharMS
Looking for a job

Mayank Shekhar

@mayankshekhar3

Analytics leader at KPN Farm Fresh who cut daily BigQuery costs by over 80% and builds growth and retail analytics systems.

India
Message

At KPN Farm Fresh, I lead a three-person analytics team and build reporting and decision frameworks for store launches, sales, customer acquisition, and product performance. I automated new-store reporting and self-service analytics, reducing manual effort by approximately 70% and enabling same-day performance visibility.

I also optimized BigQuery queries and workloads, cutting daily compute costs by more than 80%, from approximately ₹15K to ₹2.8K. My work on subscription churn and targeted CRM initiatives increased redemption by 9 percentage points, from 38% to 47%.

At Swiggy Instamart, I led a five-person analytics team and built Brand Insight reports that supported a data monetization initiative generating ₹1.8Cr+ per month. I developed cohort and GMV-forecasting frameworks, and Python-based assortment, pricing, and attribution models that supported 14% higher customer retention, approximately 92% forecast accuracy, and 9.2% monthly GMV growth.

Experience

Work history, roles, and key accomplishments

SI

Manager, Category Analytics

Swiggy Instamart

Oct 2022 - Aug 2025 (2 years 10 months)

Led a five-person analytics team supporting category growth, advertising effectiveness, and inventory optimization. Built Brand Insight reports supporting a data monetization initiative generating ₹1.8Cr+ per month and developed cohort-analysis and GMV-forecasting frameworks that increased customer retention by 14%.

SI

Business Associate

Swiggy Instamart

Aug 2021 - Sep 2022 (1 year 1 month)

Built Power BI dashboards for ad performance across multiple properties, improving campaign visibility. Led NPI, BDPO, and SDPO tracking with automated data validation, cutting about 2 hours of manual work daily.

MH

Business Analyst

Medcords Healthcare

Nov 2019 - Jul 2020 (8 months)

Mapped clinic workflows and analyzed manual handoffs and scheduling bottlenecks to streamline daily coordination. Built an automated doctor-allocation system using SQL and data modeling to reduce 3 hours of daily operational effort.

OC

Analyst

Ola Cabs

Jul 2018 - Jun 2019 (11 months)

Built SQL-based fraud detection to flag off-platform transactions and booking misuse across Ola Cabs. Monitored suspicious booking patterns and transaction behavior to surface cases needing enforcement review.

Education

Degrees, certifications, and relevant coursework

NC

Netaji Subhash Engineering College

Bachelor of Technology, Information Technology

Bachelor of Technology in Information Technology from Netaji Subhash Engineering College, completed in 2016.

Tech stack

Software and tools used professionally

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan