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
Technical Writing
Technical Analysis
Data analysis
GAAP and statutory reporting
Data trending
Financial and operational reporting
Strategic financial planning
Industry analysis experience
Multitasking Abilities
Excellent Communication
Self-Motivated
Planning and Coordination
Account reconciliation processes
Cash Flow analysis
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