profile-pic

Sumit Kumar

Results-driven and detail-oriented Product Analyst with a proven track record of leveraging data & analytical skills to transform complex data sets into actionable business insights. Seeking a challenging role to apply my expertise in data analysis & business intelligence, to drive informed decision-making and contribute to the success of company.
  • Role

    Product Analyst

  • Years of Experience

    5.6 years

Skillsets

  • pandas
  • Jira
  • KPI
  • LLMs
  • Machine Learning
  • Metabase
  • metrics
  • MySQL
  • Notion
  • NumPy
  • Funnel analysis
  • PostgreSQL
  • Predictive Analytics
  • Product Analytics
  • Quicksight
  • ReDash
  • Redshift
  • Slack
  • SQL Server
  • User Segmentation
  • AWS
  • Python
  • Power BI
  • Data Modeling
  • Prompt Engineering
  • Root Cause Analysis
  • AB Testing
  • Airflow
  • Athena
  • automation
  • Python - 3.0 Years
  • ClickHouse
  • Cohort analysis
  • Confluence
  • customer insights
  • Data Pipeline
  • Documentation
  • Excel
  • Experiment Design

Professional Summary

5.6Years
  • Jun, 2025 - Present 9 months

    Product Analyst

    Snapmint
  • Apr, 2024 - May, 20251 yr 1 month

    Product Analyst

    Gokwik
  • Mar, 2022 - Mar, 20242 yr

    Senior Business Analyst

    Accordion
  • Oct, 2020 - Mar, 20221 yr 5 months

    Assistant Manager Operations Analytics

    JSW

Applications & Tools Known

  • icon-tool

    SQL server

  • icon-tool

    Redshift

  • icon-tool

    Athena

  • icon-tool

    Glue

  • icon-tool

    QuickSight

  • icon-tool

    Excel

  • icon-tool

    Pandas

  • icon-tool

    Matplotlib

  • icon-tool

    BitBucket

Work History

5.6Years

Product Analyst

Snapmint
Jun, 2025 - Present 9 months
    Analytics partner for checkout team supporting product strategy across 1000+ merchant integrations including enterprise clients and major D2C brands. Built end-to-end analytics infrastructure using Airflow DAG to extract logs into ClickHouse data models, reducing time-to-insight and accelerating product iteration speed. Identified high-impact product opportunities through analysis of checkout dropoff patterns, presenting data-driven PRD recommendations. Partnered with PM to define success metrics for payment features, establishing North Star metrics and guardrails. Analyzed transaction patterns across merchants, surfacing insights that informed PM's prioritization strategy and improved merchant activation. Created Redash dashboards enabling stakeholders to independently access insights, reducing analytics bottleneck. Partnered with Product, Engineering, and Business in sprint planning to instrument features, define KPIs, and establish data for feature launches.

Product Analyst

Gokwik
Apr, 2024 - May, 20251 yr 1 month
    Led experimentation and optimization initiatives for India's leading checkout platform serving major D2C brands. Designed and analyzed A/B tests on checkout flows, applying statistical rigor to validate conversion improvement. Led funnel analysis uncovering abandonment at payment stage, insights shaped PM's roadmap and informed UX redesigns. Performed root cause analysis when metrics deviated, diagnosing issues through SQL deep-dives enabling Product/Engineering response. Built dashboards tracking KPIs for weekly product reviews with C-suite. Analyzed retention patterns revealing higher repeat usage and retention, insights shaped PM's feature prioritization and retention strategy. Optimized AWS Athena models reducing query times and saving costs, while establishing experimentation best practices.

Senior Business Analyst

Accordion
Mar, 2022 - Mar, 20242 yr
    Analytics partner supporting strategic decision-making across multiple business units for enterprise consulting firm. Built Power BI dashboards with standardized KPI frameworks across departments, improving decision-making speed. Developed financial models for P&L reporting and competitive analysis, supporting strategic planning. Automated workflows reducing manual effort, enabling self-serve analytics and fostering data-driven culture.

Assistant Manager Operations Analytics

JSW
Oct, 2020 - Mar, 20221 yr 5 months
    Utilized SQL for supply chain optimization achieving efficiency improvement.

Major Projects

5Projects

Pizza Sales Dashboard

    Excel, SQL, Power BI

SQL Project on Zomato sales

    Excel, SQL

Data Analytics Project on Namma Yatri

    SQL, Power BI

IPL Data Exploration

    SQL

Various mini projects & case studies involving Data Analysis using Python Pandas

Education

  • B.Tech, Mechanical Engineering

    NIT Jamshedpur (2020)
  • Intermediate

    BSEB
  • Matriculation

    Manav Bharti National School

Certifications

  • Sql hackerrank 5 star gold badge

  • Sql hackerrank (intermediate) certificate

  • Sql hackerrank (basic) certificate

  • Microsoft power bi bootcamp - udemy

  • Advanced excel bootcamp - udemy

  • The complete sql bootcamp - udemy

  • Python bootcamp - udemy

  • Complete data science bootcamp 2024

  • Aws certified cloud practitioner clf – c02