Data Analyst Intern at Filo Edtech (2025-09 – Present)
Data Pipelines, SQL, Analytics (Metabase)
- Resolved critical LaTeX rendering issues in the MCQ database, ensuring accurate mathematical notation display across 500+ questions and improving student learning experience by eliminating formatting errors.
- Engineered end-to-end data workflows for scraping, preprocessing, and analysis using Google Cloud BigQuery, processing 50,000+ real-time user login events daily and reducing query execution time by 40% through optimized SQL queries.
- Created modular scripts for large-scale data collection using Selenium, Playwright, and Puppeteer for web scraping, improving data quality and acquisition speed across 300+ universities.
- Analyzed weekly funnel metrics tracking student engagement from page visits to subscriptions, identifying a 25% drop-off and implementing interventions that improved conversion rates by 12%.
- Scaled Previous Year Paper product from 300 to 840 universities (180% growth) through automated workflows, processing 15,000+ exam papers using Vision API and OCR with 95% accuracy.