Thapelo Maphankgane
Junior accountant
Hire this person
Send a job offer directly to this candidate
About
I started as an accountant then Deloitte introduced me into data analytics which kept me interested and I never looked back as I grow in this profession I have worked on easy and difficult projects with Deloitte: leave provision, Recons, pension funds, and with EY there was a big project called Tshwane prepaid smart meter were I did Revenue Assurance, clearing suspense account, Allocating payments and Recons, Making recommendation to improve the system. I joined Nedbank in 2016 managing information and producing automated various reports using SAS Enterprise 9.3 from a star schema warehouse and extracting, transforming and loading data into warehouse. Then in 2020 I moved to home loans division to expand my exposure by building dashboards using power BI and understanding the business till I got promoted to CISO in 2022 (Cyber Information Security Office) to manage the models build by ETLs which I subsequently use to analyse and produces reports for our BISO to action and also do data quality as part of our data governance.
Experience
Junior accountant - Minatlou Accounting and Consulting service
(2013-07 - 2014-01)
- Basic bookkeeping
- Compiling financial statements such as GL Trial Balance, Basic Income Statement and Balance Sheet using Excel & Pastel Partner
- Calculating VAT and doing Various forms, namely VAT 101, VAT 201, EMP 101, EMP 201, IT 12, IT 14 (manual completion)
Junior Data analyst - Deloitte
(2014-03 - 2015-02)
- Trial Balance and General ledger reconciliation (Tools: SAS, excel)
- General data reconciliation (Tools: SAS)
- Data Validation of Government Employment pension fund (tools: SAS, excel)
- FNB Africa leave provision analytics (tools: SAS, excel)
- Standard bank innovation: creating customer profile for group marketing (tools: SAS, QlikView)
- Computer assisted audit technique (tools: SAS)
- Data for all projects was Imported into SAS and manipulated and report to excel/QlikView
Consultant– Data Analytics (Advisory) - Ernest and Young (set secondments)
(2015-04 - 2016-05)
Industry: Consulting
- Allocating Payment for Tshwane Prepaid smart meter (Tools: Stadium)
- Clearing suspense account through my investigation (Tools: Stadium)
- Bank, Revenue and suspense reconciliation (Tools: Stadium, SQL AND Excel)
- Electricity consumption analysis (Tools: SQL AND Excel)
Data Analyst (MIS) - Nedbank SA (MFC Division)
(2016-06 - 2020-02)
Industry: Banking
- Deliver on client engagements
- Write programs to import Data into SAS and create accumulating permanent data set that can be loaded into sas warehouse for analysis and reports (ETL)
- Write programs to scrub, manipulate, and analyse data in SAS, to find specific areas with regards to the request either from my manager or the client
- Track down exceptions and analyse why the exceptions should be reported from analytical programs written in SAS and create daily weekly and monthly report to different departments for managers to make informed strategic decision
Management Information Specialist - Nedbank SA (Home Loans)
(2020-03 - 2022-06)
Industry: Banking
- Stakeholder Engagement management - MIS support partner to business units and representative on projects
- ETL
- Creation and distribution of reports and dashboards (varying frequencies)
- Creation and distribution of monthly management packs
- Writing of SAS scripts and analysis of Home Loans data for information requests
- Provision of new insights to Home Loans business
- Optimisation and Automation of recurring reports and SAS scripts
- Review and Validation of business rules on all reporting
- Dealing with all queries relating to MI produced
- End to end and specialist understanding of the data structures
- Data quality reporting
Data Analyst - Nedbank SA (CISO Office)
(2022-07 - 2025-09)
Industry: Banking
- Stakeholder Engagement management - MIS support partner to business units and representative on projects
- ETL on SAS VIYA
- Writing of SAS scripts and analysis of Cyber data for information requests
- Optimisation and Automation of recurring reports and SAS scripts
- Review and Validation of business rules on all reporting
- Dealing with all queries relating to MI produced
- End to end and specialist understanding of the data structures On DENODO Views
- Data quality reporting
Education
N. Dip - Financial Information Systems - TUT (2011)
FASSET - Trainee Accountant - Guarantee Trust (PTY) Ltd (2013)
BTech - Financial Information Systems - TUT (2017)
Globally Certified - SAS Base and SAS Advance Programming - SAS Global (2020)
Globally Certified - SAS Data Science (AI & Machine Learning) - SAS Global (2026)
