PRANEETA GUPTA
-
www.linkedin.com/in/praneetagupta/
-
Gurgaon
WORK EXPERIENCE
ZOMATO
Senior Data & Business Analyst
( 2022 - 2024)
Developed customer intelligence & delivered actionable insights via SQL queries (mealtime analysis, funnel metrics), to
evaluate the success of campaign performance
Monitored business KPIs, including promo spend per order, and conducted root cause analysis (RCA) to address
deviations, achieving a 30p reduction in spend and enhancing overall ROI
Collaborated with the Sales team to identify new opportunities, driving an 8% expansion in restaurant coverage across
Indian tier-2 cities, directly contributing to revenue growth
Automated manual processes by developing Python scripts and scheduling DAGs in Airflow, optimizing resource
allocation and saving over 100 man-hours per month
Designed and maintained interactive dashboards in Google Sheets, Superset, and Tableau, providing real-time tracking
and data visualization to enhance decision-making across teams
Major Projects Undertaken :
Competitor Discount Analysis - Developed a real-time monitoring framework to study the competitor discount
strategies. This enabled swift adjustments to the central team’s investment tactics, resulting in a 10% overall revenue
increase by optimizing discount offerings and maintaining market competitiveness.
Targeted promo discounts - Analyzing ordering behavior across user cohorts, customer average order value, and
merchant economics to recommend tailored promos to restaurant partners, driving overall growth in cart-to-order
conversion
UBER TECHNOLOGIES
Senior Business Analyst
( 2021 - 2022 )
Managed the 'Bugs & Outages' division within the Global Analytics team:
Supervised tracking and prompt resolution of data discrepancy bugs reported on JIRA
Achieved a 70% reduction in issue closure time by implementing robust processes to enhance accountability
Data Infrastructure Team Analyst
Collaborated with global stakeholders to standardize KPI definitions, including CSAT.
Utilized SQL to conduct impact analyses for finalized changes and coordinated seamless implementation in
the production environment
DELOITTE CONSULTING USI
Consultant
( 2017 - 2021 )
Led cross-functional workshops with teams and clients to align data strategy and analytics solutions, driving
cohesive decision-making and improving project outcomes
Subject Matter Expert for data health assessment projects for Fortune 500 clients across manufacturing &
energy sectors
Managed a 5-member team in data analysis using Excel, SQL, and SAP BODS, correcting inconsistencies in
client data, and improving data quality by 87%
Directed end-to-end ETL process, transforming unstructured data into SAP Hana and SuccessFactors,
enhancing data integration
Spearheaded the migrating of sensitive client HR data for 25,000 employees across 20 countries, achieving
99.7% accuracy and ensuring compliance
SKILLS
Programming Languages: Advanced SQL, Python Basics (Pandas, Numpy, EDA)
Visualization Tools: Microsoft Excel, Google Sheets, Power BI, Tableau, Excel, Superset
Soft Skills: Leadership, Client Presentation, Consulting, Project Management, Stakeholder
Management
Platforms & Tools: Redash, Github, Airflow, JIRA
EDUCATION
Manipal Institute of Technology, Karnataka
B.TECH | ELECTRONICS & COMMUNICATIONS
ACHIEVEMENTS
PROFESSIONAL AWARDS:
APPLAUSE AWARD - 2019, 2020, 2021
SPOT AWARD - 2018, 2019, 2020
INTERNATIONAL AWARD FOR YOUNG PEOPLE - BY HRH THE DUKE OF EDINBURGH
( 2013 - 2017 )
