Sumit Kumar

Built end-to-end analytics infrastructure using Airflow DAGs to extract logs from Grafana Loki and MongoDB into ClickHouse data models, enabling interactive dashboards and reducing time-to-insight from days to hours. Created 15+ analytics dashboards enabling stakeholders to independently access insights, reducing analytics bottlenecks by over 60% and accelerating decision-making cycles. Partnered with APMs and Product Managers to define success metrics for payment features, establishing North Star metrics and decision guardrails adopted across enterprise initiatives. Identified high-impact product opportunities through deep analysis of checkout drop-off patterns across merchant cohorts, driving significant improvements in conversion potential. Collaborated with Product, Engineering, Data Engineering, and Business teams to define KPIs, instrument features, and ensure data quality across enterprise integrations. Contributed to migration to MixPanel by building end-to-end checkout event tracking and partnering with engineering teams for implementation. Led a team of analysts to deliver proactive merchant insights and resolve merchant issues, improving responsiveness and operational efficiency.

Led experimentation and optimization initiatives for India's leading checkout platform serving major D2C brands, driving data-backed product improvements across the funnel. Optimized AWS Athena data models, reducing query times by 40% and generating annual cost savings of INR 400K while establishing SQL and experimentation best practices adopted organization-wide. Conducted end-to-end funnel analysis identifying 40% abandonment at payment stage, directly influencing product roadmap decisions and enabling multiple UX redesigns with measurable conversion improvements. Designed and analyzed 15+ A/B tests across checkout flows using statistical rigor including sample sizing and significance testing, validating hypotheses and driving consistent conversion improvements. Performed RCA for metric deviations exceeding 10% by conducting deep SQL analysis and collaborating with Product and Engineering teams to resolve critical system issues. Built dashboards tracking 20+ KPIs that served as a single source of truth for weekly product reviews and executive decision-making, translating complex data into actionable insights.

Built 10+ Power BI dashboards with standardized KPI frameworks across departments, improving decision-making speed by 40% and enabling usage by 20+ leadership stakeholders. Developed financial models using Power Query and Power Pivot for P&L reporting and competitive analysis, supporting strategic planning for $10M+ annual budget impact. Automated 20+ reporting and analytics workflows, reducing manual effort by 70% and saving 500+ analyst hours annually while enabling self-serve analytics adoption.