Currently an Extern @ExternSophomore studying finance, actively building technical skills through an Excel & AI financial-modeling externship and hands-on practice.
Portfolio of spreadsheets, model builds, and AI-assisted analyses completed during the externship and coursework, showing applied Excel techniques and modeling workflows.
Built and evaluated a simulated multi-asset portfolio using Malaysian equities and market index data while applying Sharpe Ratio, Treynor Ratio, and Jensen’s Alpha to assess risk-adjusted performance. Constructed efficient frontier models in Microsoft Excel to analyze return-risk trade-offs and identify optimal portfolio allocations across asset classes.
Integrated equity valuation, technical analysis, and macroeconomic indicators to evaluate investment opportunities and develop data-driven investment recommendations. Led team coordination across project milestones while maintaining quality standards and ensuring the timely delivery of all project deliverables.
Sophomore studying finance, actively building technical skills through an Excel & AI financial-modeling externship and hands-on practice.
I am Amalia Abdullah, a second-year bachelor's student focused on finance. I have limited work experience and am building technical and professional skills through an Excel & AI financial-modeling externship and coursework. I aim to develop practical finance skills that prepare me for an entry-level role.
Externships
Excel & AI Financial-Modeling Sprint
Extern
Experience
Intern, Business Development & Analyst
Bank Islam Malaysia Berhad (BIMB) · 03/2026 — 08/2026
Education
Universiti Teknologi MARA (UiTM), Segamat, Johor
Bachelor of Business Administration (Hons.) Investment Management CGPA: 3.55
Universiti Teknologi MARA (UiTM), Dungun, Terengganu
Diploma in Investment Analysis CGPA: 3.74
Skills
Built and evaluated a simulated multi-asset portfolio using Malaysian equities and market index data while applying Sharpe Ratio, Treynor Ratio, and Jensen’s Alpha to assess risk-adjusted performance. Constructed efficient frontier models in Microsoft Excel to analyze return-risk trade-offs and identify optimal portfolio allocations across asset classes.
Integrated equity valuation, technical analysis, and macroeconomic indicators to evaluate investment opportunities and develop data-driven investment recommendations. Led team coordination across project milestones while maintaining quality standards and ensuring the timely delivery of all project deliverables.
✅ Verified by Extern · ⏱️ In progress
Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.
The externship guided building a three-statement financial model, forecasting with driver assumptions, and performing a discounted cash flow valuation. Work combined Excel modeling with GPT-assisted workflows to produce forecast scenarios and valuation outputs. The deliverables included a model, DCF, and investor-facing materials.
.png)
I built a foundational dataset and reference for the model by extracting historical price and financial data from Yahoo Finance, cleaning the figures, and preparing them for projection assumptions.
