Diya Mittal

Data and Product Analytics professional with hands-on experience using SQL, Python, Pandas, NumPy, Apache Spark, Databricks and Excel to solve product and business problems. Experienced in cohort analysis, retention analysis, customer segmentation, KPI tracking, query optimization, and operational analytics. Analyzed 83K+ shows at PocketFM and developed an e-commerce analytics solution covering 100K+ order events, customer retention, dark-store operations, and unit economics.

Product Analyst Intern, Scout Platform - Pocket FM - Bengaluru, India

(2026-03)

• Analyzed retention, listener, throughput, benchmark, and content-performance metrics across 83K+ audio shows to support product and content decisions.
• Developed and optimized 120+ SQL queries across Databricks, Apache Spark, and Delta Lake, supporting 60+ analytics metrics and 20+ product features.
• Engineered reusable data models and metric pipelines for cohort analysis, retention benchmarking, show segmentation, and performance tracking across multiple business dimensions.
• Reduced search latency by 73% from 750ms to 50 to 200ms through candidate filtering, indexed MySQL retrieval, and optimized data access workflows for large show datasets.
• Collaborated with Product and Content stakeholders to define KPIs, investigate performance gaps, and translate business questions into analytical solutions and reporting workflows.

B.Tech. - Computer Science and Engineering - Vellore Institute of technology (2022 - 2026)