MABONTLE NTHODI
Principal Data Analyst
Johannesburg
Summary
Highly analytical and results-driven Principal Data Analyst with expertise in data engineering, business intelligence, and reporting. Demonstrated skills in data quality assurance, business process analysis, and creating impactful dashboards using Power BI. Passionate about utilizing data to uncover valuable business insights, enhance decision-making processes, and optimize operational performance. Excels in engaging stakeholders, documenting findings, and efficiently managing projects within fast-paced environments.
Overview
7
7
years of professional experience
2032
2032
years of post-secondary education
3
3
Certifications
2
2
Languages
Work History
Principal Data Analyst
SAGE SA
07.2022 - Current
- Elevated to a senior role, working closely with development and project management teams to design and implement end-to-end data solutions that enhance organizational systems
- Lead stakeholder engagement for the reporting and data analytics team, ensuring clear communication on project scopes and priorities, and aligning data requirements with business needs
- Gather business requirements, develop clear documentation, and ensure seamless coordination between cross-functional teams, including customer support and customer services, to address system issues and improve workflows
- Actively involved in troubleshooting and resolving system failures by collaborating with the EAD team to identify and implement fixes to internal processes
- Scope out new data-driven projects with project managers, providing insights and solutions to optimize business processes and support decision-making
- Lead the creation of advanced reporting tools and dashboards, optimizing internal systems and data pipelines for better performance and usability
- Serve as a key point of contact for internal stakeholders, presenting data insights and reports to senior management
Premium Services Analyst
Kurtosys
08.2021 - 07.2022
- Analyst for all US Asset management clients
- Manage the client’s asset management portfolios
- Main clients TROWEPRICE, SALI and WILLIAM BLAIR
- Produce monthly and quarterly factsheets based on their share classes
- Analysing portfolio data sent by the client for us to load
- Investigate data source failures in SQL
- Run monthly production of receiving client’s portfolio data, loading it on Kurtosys systems, and making sure the client’s data is accurate enough to be pushed onto their own web portals
- Load client portfolio data onto web
- Debugging and fixing client request on incidents
Data Analyst
DDS
09.2020 - 08.2021
- Data Analysis duties:
- Compile daily UNILEVER statistics reports
- Champion for all UNILEVER and SAB Draught Reporting and analysis
- Extract data from various company source systems, merge the data and store it in central database to use for analysis
- Do weekly investigations on SAB activities for previous weeks that weeks’ deleted from system or activity dates moved (Communicate with managers)
- Compile weekly SAB Sanitations Reports which include Planned vs Actual Sanitation Activities report and FEEDBACK Sanitation Activities report (these reports look at what was planned to be serviced at SAB outlets Vs what was actually done)
- Updating DDS Ethiopia Towns to align with geographical locations that currently exists (Done is SQL)
- Conducting UNILEVER Test cases to ensure that unilever app integrates with the companies’ system
- Validation and updating into Outlets, SABOutletsDr, SABSlush and SABSlushHistory Tables (running check scripts in the backend using TSQL)
- Creating KPI and SLA Dashboards for management which focuses on the operations of the business
- Creating a powerBI model for unilever tickets that have since been in service and not closed and affecting branches SLA
- Create weekly Removals and Installations Reports to Gap Draught
Data Analyst
Standard Bank – through Khonology
10.2019 - 08.2020
- Global Markets (Equities)
- Creating Documentation for all the data and systems that lie in the Global Markets (Equities) space
- Data analysis
- Business analysis- Analysing the business process and rules to access if they are in line with our warehouse solution
- Creating visual flow diagrams using Microsoft Visio of how all the different trade systems interact with each other
- Creating stakeholder metrics for the equities space
- Analysing the Risk component (Murex) and how trades from all different desks are booked, what is their source system and how do downstream systems receive it
- Creating source to target mappings for the source systems
- Creating one consolidated pipeline through which all the trade data can flow
- Analysing the different holidays that might affect trading on all exchanges that the JSE and SBGS are linked with
- Stakeholder interactions and meetings and presentations
- Optimisation of MUREX
- Put together a useful view of risk information which assists stakeholders to make decisions on risk areas in the business
- This view of risk information will feed into a comprehensive information architecture
- Calculate the Population Size, Dimensions and Completeness of each Dataset
- Identify the Unique Key Field(s) and common/similar fields in each Dataset
- Analyse the overall structure of each dataset to identify similarities to be used for referential a data labelling web application using label studio
- Analysing previous historical risk incident data that will be used in the application
- Developing backend for application to read and write data to and from PostgreSQL Database
- Developed ORM functions in python that will connect to database
- Creating an Azure SQL repository
- Maintaining of database that contains historical incident data
- Creation of front end for web application in react.js
- FOREX EXCHANGE CONTROL
- Data analysis on incoming payments from different forex payment channels
- BOTTS
- ICM
- RAVN
- ITRADE
- BOL/NBOL
- WORKFLOW
- SBG MOBILE
- Analysing historical data stored in Standard bank source systems to see if the incoming payment samples are correctly mapped to their respective vex source systems
- Do a percentage completeness check data stored in the different source systems that link to forex payments
- I.e.: Goldtier, SAP, LIBRA, ISW
- Assessing and analysing given set of rules to assess the POC of validating whether the process can be automated
- ETL on sample data given
- Building of an automated system that will process forex payments faster
- Creating functional and Nonfunctional spec of required system
- Creating a common field analysis across all source systems
- Analysing the referential integrity of the source systems
- Assessing data quality to discover anomalies, gaps within the data as well perform data clean-ups
- Data profiling to determine the accuracy, completeness, and validity of the data
Data Engineer
PBT Group
01.2019 - 09.2019
- Creating queries and procedures in Microsoft SQL management Studio to validate data in the warehouse
- Collaborate with other development and research teams
- Creating stored procedures and views for daily and monthly Datawarehouse loads
- Monitoring performance and advising any necessary infrastructure changes
- Create and maintain optimal data pipeline architecture
- Analysing the business process and rules to assess if they are in line with our warehouse solution
- Assessing the integrity of the data and if it matches what is in the source system
- Generating reports in Excel for client performance
- Creating dashboards for the client in Microsoft Power BI to analyze service products such as SLAs, KPIs, employee performance, service management data i.e
- (calls, responses, issues logged, resolutions, statuses)
- Creating documentation for the existing Datawarehouse projects (technical specs, project planning, source to target mappings)
- Investigate and resolve data quality issues and escalate situations according to department processes
- Provide meaningful and accurate interpretations of analyses data
Web Developer
Neutrinos SA
04.2018 - 12.2018
- Writing code and developing web applications for various clients using HTML5, CSS3, JavaScript and Angular
- Evaluating the applications and ensuring they work perfectly to the client’s requirements
Education
National Diploma - Information Technology (Business Applications)
Tshwane University of Technology
Matric - Bachelor’s Pass
Willowridge High School
04.2001 - 01.2014
Skills
- Data Analysis
- SQL
- Power BI
- Tableau
- Excel
- Data Engineering
- Microsoft SQL Server Management Studio
- Talend
- Informatica Cloud
- Business Intelligence
- Data visualization
- KPI & SLA tracking
- stakeholder reporting
- Programming & Database Management
- Python
- PL/SQL
- MySQL
- C
- C#
- Azure
- Project & Process Management
- Agile
- SDLC methodology
- business process analysis
- ETL & Data Warehousing
- SSIS
- SSRS
Technical Skills Matrix
- SQL (MySQL, PL/SQL, Microsoft SQL Server) Expert
- Power BI Expert
- Excel Expert
- Microsoft Word Advanced
- Microsoft Azure Advanced
- AI & Analytics Tools(Azure) Intermediate
- Python Advanced
- Tableau Advanced
- Talend Studio Advanced
- Informatica Cloud Intermediate
- Data Warehousing Expert
- Snowflake Intermediate
- Cloud Solutions (Azure, AI) Intermediate
- C++, C#, JavaScript, Angular Intermediate
- Salesforce Intermediate
- HTML Intermediate
- Css Intermediate
- Oracle Advanced
Certification
Microsoft Azure Fundamentals, 2020
Drivers License
Yes, Code 8
Availability
Immediately or as per notice period
Timeline
Principal Data Analyst
SAGE SA
07.2022 - Current
Premium Services Analyst
Kurtosys
08.2021 - 07.2022
Data Analyst
DDS
09.2020 - 08.2021
Data Analyst
Standard Bank – through Khonology
10.2019 - 08.2020
Data Engineer
PBT Group
01.2019 - 09.2019
Web Developer
Neutrinos SA
04.2018 - 12.2018
Matric - Bachelor’s Pass
Willowridge High School
04.2001 - 01.2014
National Diploma - Information Technology (Business Applications)
Tshwane University of Technology
Similar Profiles
Thobile MwaleThobile Mwale
Accounting Renewal Advisor at Sage SAAccounting Renewal Advisor at Sage SA
Innocentia Busisiwe MaphosaInnocentia Busisiwe Maphosa
DEBIT ORDER AND REFUNDS ANALYST at Sage SADEBIT ORDER AND REFUNDS ANALYST at Sage SA
NEO JAFTANEO JAFTA
Retention Advisor - Accounting at Sage SARetention Advisor - Accounting at Sage SA
Thanduxolo MhlangaThanduxolo Mhlanga
Packer at &BAMPacker at &BAM
Primrose RadebePrimrose Radebe
Commercial Excellence Specialist at Roche DiagnosticsCommercial Excellence Specialist at Roche Diagnostics