Praneeta Gupta

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 )