Piyush Sharma

About Piyush Sharma

About my Journey and Myself The years from 20••••22 have been a great learning curve…

Experience

1. Business Analyst

   Zomato

   Nov 2023 — Present · Gurugram, IN

   Category Growth & Supply Strategy a. Built and maintained the platform’s category structure by mapping dishes to cuisines and tagging restaurants based on top-selling items, enabling consistent classification for category-level insights. b. Rolled out an Event Planning Calendar to guide supply planning using past-year growth trends. c. Created a Category Share Dashboard and Item Count × ASV Framework to identify whitespace for emerging brands. d. Linked cuisine diversity to revenue: users who tried more cuisines showed +0.1% retention and +0.08% frequency (via LDC A/B tests). e. Mithai Category: Built a GMV-weighted scoring system to ensure dish/variant sufficiency across city- brand menus; supported targeted on-ground supply building. f. Cakes Category: Led Zero Spill Guarantee pilot by tagging low-ORS SKUs for refunds; scaled across multiple cities.2. Veg Flow & Product Analytics a. Developed a Veg Affinity Scoring Framework, expanding the targetable veg user base by 7.5% and supporting CRM & LDC campaigns. b. Analyzed banner funnel metrics and user response to experiments (e.g, Gross Negatives Removal) for high Veg Score users. c. Generated fallback veg image URLs for ~34K restaurants, improving listing hygiene and boosting App Opens → Menu Opens flow.3. Ops Enablement & Data Infrastructure a. Built scalable SQL pipelines and dashboards for Cuisine Share, Menu Score, and Bad Orders. b. Automated key trackers (Ads, DOTD scale-up), reducing update time from 1 hour to 20 minutes. c. Managed NKA JBPs, campaign performance, and ad-hocs with timely and high-quality delivery.

Education

• PEC University of Technology

  Bachelor’s Degree

  2012 — 2016