Dipuo Maphutha
Data Analytics/Science
Edenvale
Summary
I am an experienced and skilled BI Data Analyst/Data Scientist with over 8 years of expertise in business intelligence, data analytics, and data science. I have a strong background in developing data models, dashboards, and visualizations, automating end-to-end data processes (ETL), and building predictive models using advanced statistical and machine learning techniques. Extensive experience working with Banking and Finance dataset. Dedicated to delivering actionable insights aligns with Standard Bank’s commitment to leveraging data for innovative and customer-centric solutions.
Overview
9
9
years of professional experience
4050
4050
years of post-secondary education
2
2
Certifications
Work History
Analytics Support Specialist
South African Reserve Bank
08.2023 - Current
- Built and optimized Power BI dashboards for time-series analysis and financial forecasting
- Automated data pipelines using SQL, Python, and Oracle for efficient processing and analysis
- Developed ARIMA and SARIMA models for interest rate forecasting and statistical validation
- Processed and analyzed unstructured data to support monetary policy research and decision-making
- Applied statistical techniques to create predictive models and validated their performance
- Involved in Testing of Time Series System deployment and proving Data Analysis and Application Supports on data requirements
- Collaborated with stakeholders to integrate model outputs into production systems
- Supported business-as-usual (BAU) requirements with robust data-driven solutions
- Monitor, measure and report on analytical results to ensure appropriate business recommendations and insights
- Deploy, maintain, enhance, optimise and automate analytics solutions
BI Data Analyst
Nedbank
01.2020 - 07.2023
- Developed Power BI dashboards and models for transactional insights and profitability tracking
- Designed and implemented machine learning models for churn prediction and profitability analysis
- Development of LSTM and BI-LSTM machine learning models for prediction of ATM Profitability
- Built and monitored SSIS packages and SSRS/SSAS reports for enhanced reporting
- Performed ad hoc data extraction and cleaning to meet stakeholder requirements
- Designed models and dashboards for IT and executive reporting, ensuring alignment with business goals
- Streamlined reporting processes through automated pipelines and data validation
- Conducted regression and performance testing for new data science models
- Building Recon reports across Systems and Data Teams to ensure that the numbers being provided to stakeholders match to minimize variances
- Provide Support by building Service Provider Models within Nedbank insurance for reporting, this includes Monthly, Quarterly and Year to date Reporting
- Development of Quality Sales Model to track New Sales within the bank and prediction on their product interest within the bank
Developer MIS Analyst
ABSA
10.2017 - 12.2019
- Provided BI consultation and implemented reporting solutions using SQL and QlikView
- Built ETL processes and validated BI requirements for analytics and reporting
- Enhanced existing BI solutions, including predictive models and QlikView dashboards
- Conducted financial reporting and reconciliation for improved data accuracy
- Support and enhancement to existing BI Development Solutions such as Qlikview Models and SQL scripts
- Provide Input on various BI Methodologies to meet BI Requirement in the distribution as centralised MIS Analyst with Wealth and Investment
- Development of a Qlikview Debit Order Model for tracking Collection
- Creating Qlikview Models for Monitoring Call Centres
- Creating and Maintenance Reports for Score card of Financial Bankers wishing Wealth and Investments
- Development of a Qlikview Model for Fiduciary business within Wealth for Wills, Estates and Trusts within the Bank
Data Analyst
PWC (PricewaterhouseCoopers)
02.2016 - 09.2017
- Imported, cleaned, and transformed data to enhance data quality and integrity
- Developed Power BI and QlikView dashboards and relational databases for client monitoring
- Conducted revenue assurance activities and designed dashboards for billing oversight
- Delivered actionable insights through data validation and reporting
- Improvement methods that improve profits, revenues and cash flows without influencing demand
- Checking completeness and integrity on margins and profitability of investment in networks and information systems
- Revenue Assurance Recon for both private and public sectors
- Development of Qlikview dashboard for Clients as a Revenue tool for Monitoring Customer Billing and Invoicing
IT Technician
Polokwane Municipality
10.2015 - 01.2016
- Maintained IT infrastructure and resolved technical issues
- Monitored network utilization to ensure system performance
Education
Masters of Applied Data Science -
University of Johannesburg
BSc Honours - Computing
University of South Africa
BSc - Computer Science and Mathematics
University of Limpopo
Skills
- Programming and Big Data: Advanced skills in SQL, Oracle, SAS, Python, and R and intermediate experience in distributed systems such as Hadoop
- Data Science Expertise: I am skilled in hypothesis testing, statistical validation, and developing advanced machine learning models
- Data Analysis and Insights: Expertise in identifying data patterns, trends, and actionable insights to inform strategic business decisions
- Statistical and Machine Learning Models: Proficient in ARIMA, SARIMA, Artificial Neural Network and regression models for forecasting, as well as other advanced machine learning techniques such as Decision Trees and Naive Bayes algorithm for predictive analytics
- Data Visualization and Reporting Solutions: Development of interactive dashboards using Power BI, QlikView, QlikSense and Tableau to drive business intelligence
- Data Governance and Compliance: Adherence to metadata standards and risk mitigation practices ensuring ethical data usage
- Technology Platforms: Experience with tools such as SSIS/SSRS, Oracle, and SAS as well as cloud-based platforms like AWS and Azure
Certification
Qlik Sense Visualization
Additional Information
- MR THABANG MATJILA, SENIOR ANALYST, +27 81 4255 377
- MR OWEN RAMPORA, MENTOR/BI DEVELOPER, +27 73 7488 719
- MR BRIAN MCLEARN, PRODUCT MANAGER, +27 66 4726 260
Timeline
Analytics Support Specialist
South African Reserve Bank
08.2023 - Current
BI Data Analyst
Nedbank
01.2020 - 07.2023
Developer MIS Analyst
ABSA
10.2017 - 12.2019
Data Analyst
PWC (PricewaterhouseCoopers)
02.2016 - 09.2017
IT Technician
Polokwane Municipality
10.2015 - 01.2016
BSc - Computer Science and Mathematics
University of Limpopo
Masters of Applied Data Science -
University of Johannesburg
BSc Honours - Computing
University of South Africa
Similar Profiles
Henrietta Annelize BotesHenrietta Annelize Botes
Senior Administrative Assistant at South African Reserve BankSenior Administrative Assistant at South African Reserve Bank
KGOMOTSO KGATITSOEKGOMOTSO KGATITSOE
Specialist Information Management Consultant at South African Reserve BankSpecialist Information Management Consultant at South African Reserve Bank
NONTUTHUZELO CYNTHIA DAUNONTUTHUZELO CYNTHIA DAU
Analyst at SOUTH AFRICAN RESERVE BANKAnalyst at SOUTH AFRICAN RESERVE BANK
Masego SefoloMasego Sefolo
Senior Project Manager at IN2IT Technologies, South African Reserve BankSenior Project Manager at IN2IT Technologies, South African Reserve Bank
TIISETSO THOBELATIISETSO THOBELA
Assistant Cooker and Decorator at Risiva Events CompanyAssistant Cooker and Decorator at Risiva Events Company