Sumit Kumar

Product Analytics Consultant for checkout team supporting product strategy across 1000+ merchant integrations including enterprise clients (Meesho, Ixigo, Magicpin, Zepto, Zomato - District, etc) and major D2C brands (Boat, Mivi, Limeroad). Built end-to-end analytics infrastructure using Airflow DAG to extract logs (Grafana Loki, MongoDB) into ClickHouse data models, reducing time-to-insight from days to hours and accelerating product iteration speed by >40%. Identified 3 high-impact product opportunities (projected 15% conversion improvement) through deep-dive analysis of checkout drop-off patterns across merchant cohorts. Partnered with PM to define success metrics for payment features, establishing North Star metrics and guardrails for go/no-go decisions framework adopted across 3 Enterprise. Created 15+ Analytics dashboards enabling stakeholders to independently access insights, reducing analytics bottleneck by >60% and accelerating iteration velocity. Partnered with Product, Engineering, and Business in sprint planning to instrument features, define KPIs, and establish data to 5+ Enterprise Integrations. Played a key role in migrating to MixPanel through creating Events for checkout product steps end-to-end and partnered with Engineering on its instrumentation.

Led experimentation and optimization initiatives for India's leading checkout platform serving major D2C brands. Designed and analyzed 15+ A/B tests on checkout flows, applying statistical rigor (sample sizing, significance testing) to validate drove 12% average conversion improvement across tested variants. Led funnel analysis uncovering 40% of abandonment at payment stage; insights directly shaped PM's quarterly roadmap and informed 3 UX redesigns with measurable conversion gains. Performed RCA when metrics deviated >10%, diagnosing issues through SQL deep-dives enabled Product/Engineering response within 24 hours maintaining >99% reliability. Built dashboards tracking 20+ KPIs that became single source of truth for weekly product reviews with C-suite complex data into clear narratives. Analyzed retention patterns revealing certain merchants had 3x higher repeat usage and 45% better retention; insights shaped PM's feature prioritization and retention strategy. Optimized AWS Athena models reducing query times by 40% and saving INR 400K annually, while establishing experimentation best practices adopted organization-wide.

Analytics partner supporting strategic decision-making across multiple business units for enterprise consulting firm. Built 10+ Power BI dashboards with standardized KPI frameworks across departments, improving decision-making speed by 40% - used by 50+ stakeholders including leadership. Developed financial models (Power Query, Power Pivot) for P&L reporting and competitive analysis, supporting strategic planning impacting $10M+ annual budget. Automated 20+ workflows reducing manual effort by 70% (saving 500+ analyst hours annually), enabling self-serve analytics and fostering data-driven culture.

Utilized SQL for supply chain optimization achieving 15% efficiency improvement.