Mayank Shekhar

KPN Fresh - Manager, Data Analyticsmayankshekhar002@gmail.com +918373841632

strategy across Swiggy, Ola, and KPN Farm Fresh. Driving AI-powered analytics, automation, and revenue growth at scale. Specialized in AI-driven analytics, forecasting, monetization, and growth analytics, building scalable data systems using SQL, Python, Snowflake, and BigQuery. Proven track record of translating complex data into high-impact product, marketing, and revenue decisions.

Experience

KPN Fresh - Manager

Data Analytics

Bangalore, Karnataka

Analytics Automation & Data Infrastructure: Designed and

store launches, reducing manual reporting effort by ~70% and

09/2025 — Present

accelerating leadership decision cycles. Marketing & Growth Analytics: Conducted deep-dive analysis of YouTube Ads and Google PMAX campaigns, identifying optimization opportunities to improve reach, CTR, and conversion efficiency. Omnichannel Attribution Modeling: Developed attribution frameworks linking Meta store-visit campaigns to offline sales uplift, enabling accurate marketing ROI measurement and smarter budget allocation. mayankshekhar002@gmail.com Bangalore, India 560037 Linkedin.com/in/mayank1122/

Education

Kolkata, West Bengal

B.Tech.: Information Technology

Skills

SQLPythonForecastingPricing AnalyticsCohort AnalysisExcelSnowflakeBigQueryDatabricksMySqlPower BITableauLookerQlik ViewQlik SenseGA4AppsFlyerSwiggyStar Award - Aug'23Swiggy - ManagerCategory AnalyticsBangaloreKarnatakaSwiggy - Business AssociateBlackbuck - Business AnalystBuilt store-level analyticsframeworks to track salescustomer acquisitionand productperformance across cities and outletssupporting expansion andoperational strategy.Developed scalable analyticsworkflows using BigQueryand BI dashboardsenablingdriven decisions.driving category growthadvertising analyticsand inventoryoptimization across cross-functional stakeholders.Built Category Mitraan LLM-powered analytics assistant integrated with SnowflakeSQL analysis.Developed automated Brandvoiceretentionand customer mixinfluencing ₹1.8 Cr+ monthlybusiness impact.Designed Brand × Categoryplanning.Built assortment optimizationDeveloped campaign attribution andproperties enabling campaign optimization.weeklyand monthly business insights.uploadsdata accuracy and operational reliability.Built automated dailyand accurate insights.Apollo 247 - Business AnalystHyderabadTelanganaMedcords Healthcare - Business AnalystPuneMaharashtraOla Cabs - AnalystImplemented an audit mechanism tovalidate ground sales meeting recordsimproving accountabilityand data reliability.Developed automated data pipelines usingmultiple Google Sheets reportsenhancing operational efficiency.Led development of an automatedincentive payout system for ASMsTSLsand CROsreplacing a 3-day manual process with a scalableaccurate solution forperformance-based payouts.Delivered dailybiweeklymonthly performance reportsenabling stakeholders to maketimelydata-driven decisions.Built Google Data Studio dashboards toimprovingvisibility and saving ~3 man-hours daily.Led implementation of a scalablecollaboration and version control.Delivered data-driven analysis andactionable insights to solve business challengesidentify growthopportunitiesand support strategic decision-making.Mapped operationalworkflowsidentified bottlenecksand built an automated doctorallocation & case management systemsaving ~3 hours of dailyoperational effort.Developed analyticalguidestakeholdersand uncover sales optimization opportunities.Analyzed customer and partner behaviorcasesenabling targeted product fixes.Built SQL-based detection systems toidentify off-platform transactions and misusepenalties.Recommended processand financial risks.

✦Made with CVin.Bio