Looking for a job

Khomotso Mohlahlana

@khomotsomohlahlana

Data Scientist at FNB turning insurance balance-sheet data into liquidity forecasts, regulatory reports, and automated Power BI dashboards.

South Africa

Message

At FNB, I support Life Insurance, Short-Term Insurance and FRISCOL through liquidity management, regulatory reporting, and balance-sheet performance analysis. I produce monthly and quarterly reports that help senior management understand the businesses’ financial positions and performance.

I lead a project to optimise minimum bank balances, analysing historical banking data to identify operating cash levels and opportunities to invest excess cash while maintaining liquidity. I also develop liquidity forecasts and calculate weekly Guaranteed Growth Plan pricing rates.

At FNB, I led the migration of legacy Excel reports into automated Power BI dashboards and calculate the quarterly Liquidity Shortfall Indicator. I prepare the monthly Prudential Authority Liquidity Template for submission to the South African Reserve Bank.

At Alexforbes, I analysed pension and retirement funds, including monthly valuations and fund solvency reporting. Earlier, at Andile Solutions, I worked on Calypso system analysis and financial risk modelling, including IFRS 9 expected credit loss calculations.

Experience

Work history, roles, and key accomplishments

Current

Data Scientist - Balance Sheet Management Analyst

Current

FNB (First National Bank)

Support the Insurance business across Life, Short-Term Insurance and FRISCOL by delivering analytical insights, liquidity management, regulatory reporting and balance sheet performance analysis. Produce monthly and quarterly balance sheet reports and lead the migration of legacy Excel reporting into Power BI.

SQL Excel Power BI Liquidity Forecasting Balance Sheet Management Regulatory Reporting Data Analysis Financial Modeling Performance Testing scenario analysis Data Validation Quality Assurance

Actuarial Analyst

Alexforbes

Conducted data analysis on Pension and Retirement funds, personally responsible for 32 funds. Used SQL, Python, Excel, and Power BI to analyze data, create visualizations, and communicate insights to stakeholders.

SQL Python Excel Power BI Data Analysis Data Visualization Actuarial Analysis Data Quality Root Cause Analysis Governance

Junior System Analyst

Andile Solutions

Conducted analysis on the banking system Calypso, implementing the Middle Office & Trading Risk component. Developed and implemented quantitative financial models for pricing and valuation of financial instruments, and conducted IFRS9 impairment modelling and ECL calculations.

SQL Python Calypso Treasury System Risk Analytics VARs Expected Shortfall Monte Carlo IFRS 9 ECL PD Modeling LGD EAD Basel III Basel IV CVA XVA Financial Modeling

Education

Degrees, certifications, and relevant coursework

Horberton School

Course, Software Engineering

Completed a 12-month Software Engineering course covering programming, web development, and database skills.

Corporate Finance Institute

Certification, Financial Modeling and Data Analysis

Earned certifications in Financial Modeling & Valuation Analysis and Business Intelligence & Data Analysis, covering financial analysis, modeling, and data analytics.

University of Pretoria

Bachelor of Science, Actuarial and Financial Mathematics

Completed a Bachelor of Science in Actuarial and Financial Mathematics, obtaining actuarial exemptions in statistics, business economics, finance, and financial mathematics.