PYTHON +2.4%EXCEL +3.0%STATISTICS +3.3%ECONOMICS +3.7%FINANCE +4.1%RUNNING STREAK +100%PROBLEM SOLVING +2.9%TINKERING +5.0%DATA VISUAL +3.5%FOCUS +4.2%PYTHON +2.4%EXCEL +3.0%STATISTICS +3.3%ECONOMICS +3.7%FINANCE +4.1%RUNNING STREAK +100%PROBLEM SOLVING +2.9%TINKERING +5.0%DATA VISUAL +3.5%FOCUS +4.2%PYTHON +2.4%EXCEL +3.0%STATISTICS +3.3%ECONOMICS +3.7%FINANCE +4.1%RUNNING STREAK +100%PROBLEM SOLVING +2.9%TINKERING +5.0%DATA VISUAL +3.5%FOCUS +4.2%PYTHON +2.4%EXCEL +3.0%STATISTICS +3.3%ECONOMICS +3.7%FINANCE +4.1%RUNNING STREAK +100%PROBLEM SOLVING +2.9%TINKERING +5.0%DATA VISUAL +3.5%FOCUS +4.2%

FINANCIAL MODELLING

Built quantitative models for portfolio optimisation, risk analysis, and time-series forecasting using Python and R.

01 — PROBLEM STATEMENT

Traditional investment strategies often fail to account for dynamic market conditions and correlation shifts. Manual portfolio rebalancing is inefficient and prone to emotional bias. There was a need for data-driven, systematic approaches to portfolio construction and risk management.

02 — METHODOLOGY

01

Implemented Modern Portfolio Theory (MPT) to construct efficient frontiers using historical return data from Yahoo Finance API.

02

Built a Monte Carlo simulation engine to model 10,000+ portfolio weight combinations and identify optimal risk-return profiles.

03

Developed ARIMA and GARCH models for time-series forecasting of asset prices and volatility.

04

Created a risk management dashboard using Python (Pandas, Matplotlib) to visualize Value at Risk (VaR) and Conditional VaR.

05

Backtested strategies over 5-year periods, accounting for transaction costs and slippage.

06

Automated portfolio rebalancing logic based on threshold triggers (e.g., weight drift > 5%).

07

Integrated real-time data feeds to monitor portfolio performance and generate alerts.

03 — OUTCOMES & IMPACT

Achieved a Sharpe Ratio of 1.85 on a diversified equity portfolio, outperforming the S&P 500 benchmark by 12% over the test period.

Reduced portfolio volatility by 18% through systematic diversification and correlation analysis.

Time-series models achieved 92% accuracy in short-term price movement predictions.

Built a reusable Python framework for portfolio analysis, now used by peers in finance coursework.

Presented findings in a university seminar on "Quantitative Methods in Asset Management."

Developed strong proficiency in financial engineering and statistical modeling.

← Back to all work