About
An analytical and strategic MBA candidate specializing in Data Analytics & Decision Science, with a proven track record of leveraging advanced analytics, machine learning, and product insights to drive significant business growth and operational efficiency. Adept at transforming complex data into actionable strategies, optimizing product funnels, and leading cross-functional initiatives to achieve measurable outcomes in dynamic environments.
Work
Gurgaon, Haryana, India
→
Summary
As a Senior Product Analyst, Shivam optimized product funnels and enhanced analytical coverage for the flights LOB, driving significant conversion rate improvements.
Highlights
Analyzed drops in 20+ Business Unit (BU) metrics and 10+ funnel conversion rates across multiple dimensions, identifying root causes and informing strategic optimizations for 100K+ monthly visitors.
Aided 5+ Product Managers (PMs) in optimizing 15+ funnel steps through Click-Stream data analysis, driving a 12% uptick in Conversion Rate (CR) based on statistical significance from 10+ A/B experiments.
Enhanced analytical coverage for the flights Line of Business (LOB) by 50% through implementing hit-level tracking across 6 product pages, improving data granularity and insights.
Reduced A/B result Turnaround Time (TAT) by 70% by automating A/B test readouts utilizing Python, accelerating PM decision cycles and improving efficiency.
Decreased analysis TAT by 50% through developing a unified scorecard to track funnel performance and Key Performance Indicators (KPIs) across 4 key LOBs, enhancing strategic oversight.
Bengaluru, Karnataka, India
→
Summary
As a Product Analyst at Spinny, Shivam spearheaded data analytics initiatives for consumer and CRM products, deploying ML models and automating dashboards to drive lead prioritization and operational efficiency.
Highlights
Broadened analytical coverage by 30% through implementation of 100+ GA4 events for Consumer & CRM products, ensuring comprehensive data capture and reporting.
Deployed 10+ data pipelines on Airflow, leveraging Python & SQL to productionize ML models and automate dashboards, enhancing data-driven decision-making processes.
Mentored 3 intern analysts, delivering comprehensive knowledge transfer and boosting onboarding efficiency for critical projects.
Presented monthly and weekly trends on 30+ business, product, and marketing KPIs to 10+ senior leaders for over 50+ weeks, influencing strategic direction and decision-making.
Minimized sales bandwidth by 25% through implementing a 90% accurate ML model for targeted lead prioritization, optimizing resource allocation and conversion.
Improved slot utilization rate by 20% through a 95%-accurate decision tree model, predicting and mitigating test-drive cancellations.
Enhanced analytical efficiency by 60% through designing 5+ master tables and automating hourly ETL pipelines, streamlining data processing and reporting.
Slashed high TAT inventory by 12% through clustering 10K+ cars and predicting impressions, optimizing visibility and redistribution.
Bengaluru, Karnataka, India
→
Summary
As a Business Analyst at Practo, Shivam developed and automated critical dashboards for LTV, churn, and funnel conversion, optimizing search and reducing uninstalls through data-driven insights.
Highlights
Developed and automated 10+ dashboards on Lifetime Value (LTV), churn, funnel conversion, and 5+ performance marketing reports, providing critical business insights.
Designed 5+ Business Intelligence (BI) dashboards on Net Promoter Score (NPS) and Customer Satisfaction (CSAT), detailing 10+ critical metrics consumed by 6+ cross-functional teams.
Optimized search by 25% by tuning Elasticsearch with historical search data, product metadata, semantics, and Named Entity Recognition (NER), significantly improving user experience.
Trimmed uninstalls by 15% through analyzing Clickstream & CRM data to identify churn drivers for targeted actions and retention strategies.
Bengaluru, Karnataka, India
→
Summary
As an Intern at Practo, Shivam streamlined operational processes and significantly reduced workload through automation, leading to a full-time offer.
Highlights
Streamlined payslip operations by 85% through automating delivery of 5000+ monthly surgery bills, driving process efficiency and accuracy.
Reduced operational workload by 70% through the automation of 5+ OPD and surgery BI reports, improving productivity and data availability.
Promoted to a Full-Time Employee (FTE) within 6 months, recognized for consistent high-impact work and exemplary performance.
Volunteer
Leo Club
|Club Member
→
Summary
Coordinated health and community initiatives, including HPV vaccine drives, health awareness campaigns, and community cleanups.
Highlights
Coordinated 10+ HPV vaccine drives, 5+ health awareness drives, and 7 community cleanups, promoting public health and environmental welfare.
CRB (Community Responsibility Body)
|Executive Member
→
Summary
Managed large-scale community service events, including blood donations, health camps, and fundraising initiatives.
Highlights
Managed 300+ blood donations, 10+ health camps, 500+ meal drives, and 5+ fundraising events, significantly impacting community well-being.
Education
Awards
SBI Green Marathon (Full Marathon)
Awarded By
State Bank of India (SBI)
Successfully completed the challenging 42 km full marathon at the SBI Green marathon event in Bhopal, demonstrating endurance and commitment.
Chegg Expert Stipend
Awarded By
Chegg
Delivered over 650 physics solutions as a Chegg expert, supporting students globally and earning a 50K+ stipend.
CAT Quantitative Aptitude Top 0.37% Aspirant
Awarded By
CAT Exam Board
Ranked among the top 0.37% aspirants in CAT quantitative aptitude, outperforming over 2.3 lakh aspirants nationwide.
NIT-W Inter-Section Football Tournament Runner-up
Awarded By
NIT Warangal
Secured the runner-up position in the NIT-W inter-section football tournament, outperforming 12+ teams.
SBI Meritorious Incentive Scholarship
Awarded By
State Bank of India (SBI)
Awarded the prestigious SBI meritorious incentive scholarship of 2 Lakh INR upon admission into NIT-W, recognizing academic excellence.
JEE Mains Top 0.7% Rank
Awarded By
JEE Mains Board
Secured top 0.7% rank (7342) out of 1.1+ lakh candidates in JEE Mains.
JEE Advanced Top 5% Rank
Awarded By
JEE Advanced Board
Secured top 5% rank in JEE Advanced, demonstrating exceptional academic proficiency.
Languages
English
Hindi
Skills
Data Analysis & Machine Learning
Python, SQL, R, Machine Learning, Deep Learning, Statistical Analysis, A/B Testing, Predictive Modeling, Data Visualization, ETL, GA4, Clickstream Analysis, CRM Analytics, NLP, Computer Vision, Elasticsearch, Apriori Algorithm, Decision Trees, Clustering, Data Pipelines.
Data Engineering & Tools
Airflow, SQL, Python, ETL Pipelines, Google Analytics 4 (GA4), Tableau (inferred), Power BI (inferred).
Product & Business Strategy
Product Analytics, KPI Tracking, Funnel Optimization, Market Research, Strategic Planning, Business Intelligence, Project Management, Stakeholder Management, Mentorship, Decision Science.
Software & Development
Python, SQL.