Pawan_CV_AM (1)
Pawan_CV_AM (1)
Pawan_CV_AM (1)
Program Manager with 8 years of experience in data analytics, business intelligence, and cross-functional team management. Proven
ability to drive data-driven decision-making, optimize business processes, and in Data Analytics & Science, having proficiency in Presto, Hive,
Python, SQL, advanced statistics, ML and Project Management.
Experience
Program manager Strategy & Growth
OYO, Gurgaon Aug/2022-Present
• Stakeholder Collaboration & Business Question Framing- Partnered with marketing and cross-functional stakeholders to frame critical business
questions, aligning data analysis with business objectives. Took initiatives impacting marketing strategies, achieving a 20% boost in reservations.
• Data Analysis & Storytelling-Conducted in-depth data trend analysis, translating complex unstructured data set into clear, actionable storylines.
• Reporting Automation & Visualization- Led the automation of recurring reports and developed interactive dashboards using Power BI, streamlining
analytics reporting like MAU, DAU and revenue. Also reducing RCA delivery time by 50%.
• Predictive Analytics - Created an advanced predictive model for inventory occupancy and upcoming contract expiry alert that increased revenue by
12% and decreases the annual churn rate by 15%.
• Regression and Machine Learning-Implemented a logistic regression model to for ticket identification on Homeowner support sorting into L1 and L2
categories, getting L1 solved from India reducing overhead cost of 60% resources of Europe location.
Business Analyst
Revv Self Drive Cars, Gurgaon June/19- Oct/2021
• Operational Efficiency & Process Optimization- Identified the core issues and upgraded the Revv sales support center, increasing operational
efficiency by 30% through process optimization and tech integration.
• Price Modelling-Refined a pricing model based on competitor analysis, resulting in a 15% revenue increase month-over-month (MoM).
• Marketing Strategies-Enhanced the revenue team's targeting strategy by introducing a data driven approach for marketing and campaigns,
resulting in a 5% conversion increase.
• Strategic Data Insights- Reduced operational costs by 12% by identifying operational gaps and eliminating redundancies. Implemented a customer
feedback system to identify product bugs, reducing customer service call volume by 15%.
Business Analyst
Eshopbox Ecommerce Private Limited, Gurgaon Mar/17- May/2019
• Prodcut Owner-Manage development and implementation of SaaS post-order customer experience for Ecommerce, boosting customer satisfaction
by 30%.
• Analysis and Reporting-Improved inventory forecasting accuracy by 25% through data visualization and optimization tools.
• Driving Impact-Reduced shipment returns rates by 10% using advanced notification systems and effective NDR management.
Skills
• Program Management & Intelligence: SDLC, MS Project, Stakeholder Management, Power BI, Tableau, Google Data Studio, Google Analytics
• Statistical Analysis & Mathematics: Hypothesis Testing, A/B Testing, ANOVA, Chi-square tests, Microsoft SQL Server, Excel, Statistical Modeling,
Regression, Machine Learning, NLP, Segmentation, Regression, Forecasting, Trend Analysis
• Programming & Tools: Python, Tableau, Power BI, Matplotlib, Hadoop, Spark, Hive, Apache Kafka, SQL, Alteryx
• Data Engineering: NoSQL, PostgreSQL, MySQL, Google Cloud Platform, Hadoop, Presto, Hive