Mutual Fund Analytics Platform
An end-to-end ETL & risk-analytics engine on 1,00,000+ AMFI records.
- 01
Ingested and cleaned 1,00,000+ rows of real AMFI mutual fund data across 10 datasets using Pandas; designed a SQLite star schema with 6 tables and a fully automated ETL pipeline via SQLAlchemy.
- 02
Computed institutional-grade risk metrics — Sharpe, Sortino, Alpha, Beta, CAGR, Max Drawdown — for 40 funds; built a composite 0–100 weighted scorecard ranking all funds.
- 03
Delivered 9 interactive Plotly / Seaborn visualisations covering AUM distribution, investor demographics, fund correlation heatmaps and benchmark comparisons.
- 04
Wrote 10 analytical SQL queries surfacing YoY SIP growth, category-wise expense ratios, and top-fund rankings.