Sumit Naugain
Product Analyst
Gurgaon,HR
Summary
Data-driven Product Analyst experienced in SQL, BigQuery, A/B testing, and RCA, with strong expertise in dashboarding and product analytics using Metabase and Power BI.
Overview
6
6
years of professional experience
2
2
Certifications
2
2
Languages
Work History
Data Analyst / Product Analyst
Physicswallah Ltd
Noida, India
03.2024 - Current
- Analyzed product usage, student engagement, and learning behavior data across 30M+ users and 15M+ events per day to identify trends and improve product performance.
- Wrote advanced SQL queries on BigQuery and Trino to extract and analyze over 50 million records, generating actionable insights for product and business teams.
- Built 20+ interactive dashboards using Superset, Metabase, and Power BI to monitor KPIs such as DAU, retention, feature adoption, and conversion rates.
- Designed and evaluated 20+ A/B tests and product experiments, measuring the impact of new features and product changes on user engagement and retention.
- Conducted root cause analysis on key product metrics, identifying 10+ issues affecting student engagement, and course consumption, and recommending corrective actions.
- Collaborated with product managers, engineers, and business stakeholders across five or more cross-functional teams to define product metrics, track experiments, and support data-driven product decisions.
- Developed scalable data models and analytics frameworks to track user behavior across 15+ product features, and monitor product performance.
- Delivered data-driven insights that improved student retention by approximately 1.2% and feature adoption by approximately 2% through targeted product optimizations.
Business Analyst / Team Lead Business Analyst
Physicswallah Ltd
Noida, India
04.2022 - 03.2024
- Extracted and analyzed over 20 million records using SQL and BI tools, generating actionable insights for product and business teams.
- Built 12+ dashboards and automated reports to track key metrics, such as enrollments, retention, DAU/MAU, and course completion rates.
- Analyzed student engagement, course performance, and product usage data across over 1 million active learners and over 500 courses to identify trends and improve learning outcomes.
- Collaborated with business and academic stakeholders to translate business requirements into data-driven solutions.
- Created 5+ BRDs, user stories, and functional documentation for product features, platform improvements, and internal tools.
- Monitored content quality and faculty performance across 200+ educators, improving course delivery and student learning outcomes.
- Mentored 20+ analysts and operations team members, ensuring accurate reporting and data-driven decision-making across teams.
Management Information System Analyst
PenPencil Company
New Delhi, India
03.2021 - 03.2022
- Prepared daily, weekly, and monthly MIS reports tracking performance across 50+ faculties and 100+ batches, enabling data-driven decision-making for management.
- Developed a Faculty Management System to monitor schedules, activities, and deliverables for over 50+ faculty members, improving operational visibility and coordination across teams.
- Built 6+ interactive dashboards in Looker Studio, tracking faculty workload, backlog, and performance across 100+ courses and batches.
- Identified and tracked over 80 pending deliverables per week, escalating delays to ensure a 25% improvement in timely completion.
- Automated MIS reporting using advanced Excel, reducing manual reporting time by 60% (from approximately 5 hours to approximately 2 hours per report cycle).
Executive Support Specialist
Concentrix Daksh India Pvt Ltd
Noida, India
07.2020 - 02.2021
- Provided customer support through chat and email for over 50 users daily, assisting with product inquiries, technical issues, and service requests.
- Resolved 88–92% of customer issues on the first response, maintaining high customer satisfaction and service quality standards.
- Handled 35+ customer interactions per day while ensuring accurate and timely responses.
- Logged and tracked over 150 weekly customer queries in CRM systems to ensure proper documentation and follow-up.
- Escalated 10–15% of complex issues to relevant teams, and ensured timely resolution.
- Maintained up-to-date knowledge of all the relevant information and internal policies to provide accurate information to customers, and contributed to achieving team KPIs, including.
- Contributed to achieving team KPIs, including an average response time of less than 2 minutes, a resolution time of less than 24 hours, and a CSAT score of over 90%.
Education
MBA - Data Science
Shoolini University
Distance Education07-2026
Bachelor of Commerce - Commerce
DRONACHARYA GOVT. COLLEGE
Gurgaon, India05-2020
Skills
Advanced SQL, BigQuery & Trino
DBT Model Development & Data Modeling
GA4 Data Analysis
Meta-base, Power BI, Looker Studio & Qlik Sense
Certification
Certificate in Management Information Systems
Languages
5,6
Timeline
Data Analyst / Product Analyst
Physicswallah Ltd
03.2024 - Current
Business Analyst / Team Lead Business Analyst
Physicswallah Ltd
04.2022 - 03.2024
Management Information System Analyst
PenPencil Company
03.2021 - 03.2022
Executive Support Specialist
Concentrix Daksh India Pvt Ltd
07.2020 - 02.2021
Bachelor of Commerce - Commerce
DRONACHARYA GOVT. COLLEGE
MBA - Data Science
Shoolini University