Gagan R

1. Portfolio Risk Estimator | Python, NumPy, Pandas, yfinance, Streamlit

• Built a quant tool to calculate portfolio expected returns, covariance matrix, and Sharpe ratio using live market data.
• Implemented Markowitz mean-variance optimization and visualized efficient frontier for optimal allocations.
• Deployed via Streamlit for interactive portfolio analysis and hosted on GitHub.

2. Financial Time Series Forecasting | Python, scikit-learn, statsmodels, pandas

• Developed ARIMA and LSTM models to forecast NAV / stock prices using historical financial data.
• Performed stationarity tests, hyperparameter tuning, and rolling forecasts to evaluate accuracy (RMSE, MAPE).
• Visualized trends and predictions to aid investment decision-making.

3. Cricket Companion | MySQL, Express.js, Node.js, HTML/CSS, JavaScript

• Designed relational schema and created MySQL tables (Teams, Players, Matches, Scorecards, Series) to support complex CRUD operations while maintaining referential integrity.
• Implemented database connection logic and query APIs using mysql2, enabling efficient execution of joins, inserts, updates, and deletes for backend endpoints.