Data Analyst Intern
Medha Tech Solutions · Jun 2025 – Aug 2025
- Conducted EDA on 630,000+ student quiz records using Python and Pandas, performing root cause analysis on error patterns and accuracy trends - findings directly informed quiz redesign by the instructional team.
- Engineered a 3-step automated preprocessing pipeline (JSON parsing → deduplication → normalisation), eliminating nearly all manual data correction and improving downstream data quality.
- Deployed self-service Streamlit dashboards to Streamlit Cloud, enabling real-time ad hoc analysis for content teams and cutting weekly manual reporting effort to zero.
- Restructured ETL pipeline to support chunked ingestion of a 1.9 GB dataset, reducing processing time from 8 hours (overnight) to 1 hour (8x improvement)

