Summary
Overview
Work History
Education
Skills
Accomplishments
Reading
Timeline
BusinessAnalyst
Mokopu Mashilo

Mokopu Mashilo

Analyst
Randburg

Summary

I have five years work experience within the Retirement Administration industry where I had grown from being an Administrator to an Analyst. My expertise include the processing transactions, tracking the unit prices, monitoring that the portfolio are in line with the regulation 28 and creating the regulation 28 reports and SARB report


I also have two and a half years work experience in the Reinsurance industry where I gained experience in SAM (Solvency Asset Management) calculation, Assets and Liabilities matching, reviewing and drafting investment guidelines, creating dashboards for tracking portfolio movements against their trackers, forecast and plans.


I am a dedicated and motivated Data Analyst and Operations Analyst, with proven skill driving process and data integrity improvements. Exceptional skill in SQL, PowerBI, PowerQuery.


I consider myself a people's person, always helping my team members and at times leading the team to achieve best results. Currently I am pursuing a PDBA post graduate degree at Wits University and I would also studying CFA 1.

Overview

7
7
years of professional experience
3
3
years of post-secondary education

Work History

Data Analyst

Clientele Life
Johannesburg
07.2022 - Current
  • Understand accounting records and add value through management reporting.
  • Interpret data, analyse results using statistical techniques and provide ongoing reports.
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
  • Acquire data from primary or secondary data sources and maintain databases/data systems.
  • Identify, analyse, and interpret trends or patterns in complex data sets.
  • Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
  • Locate and define new process improvement opportunities.
  • Drive automation projects.
  • Collaborate with Finance, Actuarial, Management Information Systems and Project Office

Investment Operations Analyst

Hannover Re South Africa
Johannesburg
02.2020 - 07.2022
  • Confirming and settling trade instructions
  • Maintaining liquidity in various investment portfolios in line with Strategic Asset Allocations
  • Provide information to Asset Managers
  • Document and provide payment instructions
  • Perform checks to ensure all investment guidelines are adhered to
  • Assist support in supporting the Investment Committee achieve its objectives
  • Assist and complete financial statements, SAM reports, forecasting and plan for the investment committee.
  • Automate (SQL and VBA) reports
  • Rebalancing of the portfolio in accordance to the mandate.
  • Monthly Bill Analysis.
  • Sending out the trade files to the relevant internal and external parties.

Investment Operations Specialist

Liberty Corporate
Johannesburg
06.2018 - 01.2020
  • Completion of SARB Recon, and communicating the discrepancies to internal parties.
  • Allocation of transactions on External Investment.
  • Completion of the monthly Compass Summary.
  • Completion of Monthly External Investment reconciliations.
  • Creation and setup of new External Investment portfolios.
  • Daily Unit price tracking and communicating any discrepancies to the Unit Pricing team.
  • Performing work on portfolio closures process: identifying the portfolios to be closed, identify the portfolios to be merged and communicating to Client Relation Managers to communicate to the external clients on their new investment portfolio choices.
  • Preparation of Asset Data and Issuer Data for both SARB reporting and Regulation 28 reporting.
  • Rebalancing of the portfolio in accordance to the mandate that was initially selected.
  • Rebalancing of portfolios for Setup or closure.
  • Completing the monthly fee check and send for payment, investigating of the fee structure setup and update.
  • Monthly Bill Analysis.
  • Sending out the trade files to the relevant internal and external parties.

Investment Accountant

MMI Holdings
Johannesburg
08.2015 - 08.2017
  • Daily monitoring of market process and investigation of discrepancies of unusual movement in market prices.
  • Ensuring the correctness of market values of investments.
  • Preparation and submissions of daily cash flows for daily unit prices.
  • Monthly and quarterly calculation as well as payment of management fees.
  • Finalizing the monthly trial balance per asset manager.
  • Maintaining financial control procedures and compliance with IAS as well as the approved policies and procedures.
  • Perform monthly balance checks of the trial balance.
  • Controlling income and expense accruals to ensure correct and complete cash flows.
  • Compiling investment notes for inclusion in financial statements.
  • Compiling quarterly reports to comply with Pension funds Act and to submit with SARB.
  • Liaise with and provide internal and external auditors and stakeholders.
  • Reconciliation of data as well as inter fund transfers and cash flows
  • Compiling and completing the Compliance in relation to Pension Funds Act Regulation 28 report
  • Completion of SARB Recon
  • Completion of External Investment recon
  • Daily Unit price tracking

Fund Accountant (1 Year Learnership)

Sanlam Employee Benefits
Pretoria
07.2014 - 07.2015
  • Capturing of bank items and bank reconciliations
  • Updating the investments with market and unit prices changes
  • Updating the investments with new trades and withdrawals
  • Opening and closing of journals
  • Updating the month end files (General Ledger recons)
  • Provide the information requested by the auditors
  • Attend to auditor queries
  • Perform bank analysis on a monthly basis for the fund
  • Capture and pay the relevant invoices
  • Perform manual disinvestments with Investment pricing
  • File all the relevant invoices and bank statements
  • Complete the trustee report file accurately and on time
  • Implementation of New Funds
  • Completion of SARB Recon
  • Completion of External Investment recon
  • Daily Unit price tracking

Education

Bachelor of Commerce - Business Statistics

University of Pretoria
Pretoria, South Africa
01.2011 - 06.2014

Skills

Data quality assurance processes

undefined

Accomplishments

  • CFA ethics Challenge 2021 Top 25 Finalist
  • MMI Way Award 2017
  • MMI Way Best Operations Team

Reading

Online business newspapers

Investment Journals

Analytics Journals

Biographies

Novels

Timeline

Data Analyst

Clientele Life
07.2022 - Current

Investment Operations Analyst

Hannover Re South Africa
02.2020 - 07.2022

Investment Operations Specialist

Liberty Corporate
06.2018 - 01.2020

Investment Accountant

MMI Holdings
08.2015 - 08.2017

Fund Accountant (1 Year Learnership)

Sanlam Employee Benefits
07.2014 - 07.2015

Bachelor of Commerce - Business Statistics

University of Pretoria
01.2011 - 06.2014
Mokopu MashiloAnalyst