Khathutshelo Prince Mathoni
Data Specialist
Johannesburg
Summary
Experienced data specialist with expertise in Big Data development and analysis. Proficient in Hadoop stack tools such as Oozie Workflow, Sqoop, Hive, Pig, Flume, Kafka, and Spark. Skilled in relational and NoSQL databases, Hadoop Framework, and Big Data concepts. Experienced in writing HIVE queries, SQL queries, and Pig scripts, with a background in building ELT solutions. Strong analytical, troubleshooting, and debugging skills, with hands-on experience in MapReduce Programming Model. Proficient in Linux/Unix Administration and Cloudera Support. Knowledgeable in Data Mining, Machine Learning, and Text analysis. Able to analyse large data sets to understand customer behavior. Thrives in problem-solving environments, applying creative and analytical thinking skills while demonstrating a strong aptitude for quick learning and teaching.
Overview
12
12
years of professional experience
4019
4019
years of post-secondary education
4
4
Languages
Work History
Data Engineer
Vodacom SA
Johannesburg, Gauteng
12.2024 - Current
- Extract and consolidate critical data to support the Forensic Department in ongoing investigations.
- Prepare and deliver weekly and monthly reports detailing fraud incidents, root causes, statistical trends, and recommended corrective actions.
- Automate recurring processes, identify inefficiencies, and implement enhancements to streamline and optimize data workflows.
- Coordinate and report on improvement initiatives across Online, Consumer Business Unit (CBU), and Enterprise Business Unit (EBU) channels.
- Identify system and process vulnerabilities, assess their potential revenue impact, and recommend mitigation strategies.
- Proactively detect and evaluate risks related to revenue loss resulting from system flaws or process deficiencies, driving corrective initiatives accordingly.
- Language: SQL
- Tools: Oracle Developer
Data Engineer
ABSA (via QUADRANT SYSTEMS)
Johannesburg, Gauteng
01.2024 - 09.2024
- Creation of data ingestion pipelines between legacy data warehouses and the big data stack.
- Development and deployment of data applications.
- Automation of application back-end workflows.
- Language: Scala, SQL
- Tools: Oracle Developer, Hive, HDFS, Visual Studio Code, UNIX
Data Engineer
South African Reserve Bank (via BICRM Consulting Services)
Johannesburg, Gauteng
11.2022 - 01.2024
- Participate in the interpretation of business requirements and functional specifications.
- Execute the data preparation, data integrations and data interoperability.
- Guide and facilitate activities and deliverables in the data migration workstream.
- Building and maintaining optimised and highly available data pipelines, that facilitate data management and data analytics solutions against very large data sets.
- Prepare data for use in predictive and prescriptive modelling.
- Conduct research to answer industry and business questions.
- Recommend ways to improve data reliability, efficiency, and quality.
- Develop and manage stakeholder relations effectively to promote data management across the organisation and support reliable decision making and appropriate data usage.
- Collaborate with AWS team in developing AWS Landing Zone and Control Tower.
- Providing AWS Support.
- Language: SQL
- Tools: Oracle Developer, AWS, Draw.io
Data Analyst
ABSA (via ITQ Consulting)
Johannesburg, Gauteng
08.2022 - 10.2022
- Data Cleaning
- Help creating STTM during the process of data migration.
- Process documentation.
- Language: SQL
- Tools: Oracle Developer, Hive, Excel
Big Data Developer (Technical Lead)
S&P Global (via InfyStrat Software Services and Wipro)
Johannesburg, Gauteng
01.2022 - 06.2022
- Design and develop efficient and scalable data pipelines between enterprise systems and analytics platform.
- Ensure data governance principles adopted, data quality checks and data lineage implemented in each hop of the data.
- Ensure compliance through the adoption of enterprise standards and promotion of best practice/guiding principles aligned with organization standards.
- Participate in evaluation of new big data and cloud technologies.
- Language: Scala
- Tools: Databricks, MicroStrategy
Big Data Cloud Engineer
Amazon Web Services
Johannesburg, Gauteng
11.2020 - 12.2021
- Apply advanced troubleshooting techniques to provide unique solutions to our customers’ individual needs.
- Facilitate Post-Mortem/Root Cause Analysis after each event to mitigate problem recurrence.
- Partner with Amazon Web Services teams to help reproduce and resolve customer issues.
- Monitor and manage communications during high impact events via relevant channels.
- Drive customer communication during critical events.
- Drive down mean time to engagement and communication for all incident types.
- Collaborating with key stakeholders around documentation and processes regarding recurring issues as well as new service updates.
- Language: Scala, SQL
- Tools: EMR, Amazon Athena, AWS Glue, Amazon S3, Amazon Quick Sight
Data Analyst
Standard Bank
Johannesburg, Gauteng
05.2019 - 10.2020
- Stakeholder Management
- Analyse business needs and provide solutions.
- Produce Data Specifications and Business Rules for ETL Developers.
- Create Source to target mapping for NICE Actimize AML project.
- Perform gap analysis and create data catalogue.
- Document and implement business rules based on the data requirements.
- Involved in data migration, data processing and data management.
- Conduct root cause analysis and give actionable insights.
- Language: SQL
- Tools: Oracle Developer, Power BI, Excel, NICE Actimize
Data Analyst
Pick n Pay
Johannesburg, Gauteng
09.2016 - 05.2019
- Provided data, reports and dashboards to help the business.
- Collaborated with a variety of business stakeholders to identify data insight requirements, design and prototype, visualize and interpret data to create actionable insights.
- Extracted data from Greenplum Database and do analysis, visualize the solution using Tableau or Excel for further customer analysis used APT application or Shopper center performance application.
- Implement and analyses surveys and social network data, with the aim to identify trends as well as area of improvements within the business.
- Created BRS to help during migration.
- Language: SQL
- Tools: POSTGRES, Tableau, Excel
Big Data Analyst
Deloitte
Johannesburg, Gauteng
11.2015 - 08.2016
- Created dashboards using Zoomdata, Datazen and SAS VA as well as writing queries.
- Extracted data from different sources, profiling data as well as modelling.
- Manage the cluster using Cloudera manager.
- I was involved in data cleaning using PigLatin.
- Involved in data profiling and management using HiveSQL and Impala.
- Language: SQL
- Tools: Zoom Data, Impala, Hive, DataZen, SAS VA
Graduate Trainee
MTN South Africa
Johannesburg, Gauteng
04.2013 - 10.2015
- Graduate - IP Core Planning Engineer - (November 2014 – October 2015): Developed reports to monitor the network using Facts application. Designed Excel dashboards to check the network performance. Monitored APN traffic in different servers and network planning. Assisted during APN migration as well as involved in roaming testing.
- Graduate- Big Data Developer and Analyst – (April 2013 – October 2014): Extracted data from external sources using Flume. Extracted data from relational database tables using Sqoop. Data pre-processed using Pig-Lasting language and provides ad-hoc analysis. Designed and developed Map Reduce programs with Java. Wrote custom SQL function (Hive UDF, UDA/UDTF). Organized and displayed data using Hive query and Impala language. Found trends, correlations and patterns in complicated data sets. Built oozy workflows to automate jobs on Hadoop and basic Hadoop administration. Researched, Online research of Big Data and its environment including how MTN and other businesses (Facebook, Yahoo, Google) value big data, how they use the Big Data environment to perform fast and efficient Data Analytics. Provided oversight and managed technology risks and issues. Developed and mentored individuals from the team through knowledge sharing sessions.
- Language: Java, SQL, PigLatin
- Tools: Facts reporting tool, Impala, Hive, HDFS, Excel
Education
Bachelor of Science - Computer Science and Information systems
University of KwaZulu-Natal
Durban, South Africa11.2012
Grade 12 -
Dimani Agricultural High School
Limpopo, South Africa11.2004
Skills
ETL development
Educational Qualifications
Dimani Agricultural High School, Grade 12, 12/2005, University of KwaZulu Natal, BSc in Computer Science and Information systems, 11/2012
Disclaimer
I Khathutshelo Prince Mathoni hereby declare that the above are true and correct to the best of my knowledge and belief and in the event of any information being found false or incorrect, my candidature will be liable to be cancelled.
Personal Information
- Criminal Record: None
- Gender: Male
- Nationality: South African
- Marital Status: Single
Timeline
Data Engineer
Vodacom SA
12.2024 - Current
Data Engineer
ABSA (via QUADRANT SYSTEMS)
01.2024 - 09.2024
Data Engineer
South African Reserve Bank (via BICRM Consulting Services)
11.2022 - 01.2024
Data Analyst
ABSA (via ITQ Consulting)
08.2022 - 10.2022
Big Data Developer (Technical Lead)
S&P Global (via InfyStrat Software Services and Wipro)
01.2022 - 06.2022
Big Data Cloud Engineer
Amazon Web Services
11.2020 - 12.2021
Data Analyst
Standard Bank
05.2019 - 10.2020
Data Analyst
Pick n Pay
09.2016 - 05.2019
Big Data Analyst
Deloitte
11.2015 - 08.2016
Graduate Trainee
MTN South Africa
04.2013 - 10.2015
Bachelor of Science - Computer Science and Information systems
University of KwaZulu-Natal
Grade 12 -
Dimani Agricultural High School
Similar Profiles
Asanda Auldrin SwaartbooiAsanda Auldrin Swaartbooi
Specialist: Core Network Management at Vodacom SASpecialist: Core Network Management at Vodacom SA
Muhammed ChoonaraMuhammed Choonara
Senior Credit and Risk Controller at Vodacom SASenior Credit and Risk Controller at Vodacom SA
Pontsho LebakaPontsho Lebaka
Scrum Master & Project Manager at Vodacom SAScrum Master & Project Manager at Vodacom SA
Palesa LegariPalesa Legari
Sales Representative at MMTSales Representative at MMT
Sinobom LibalaSinobom Libala
CAO HR Generalist - People Management at Transnet Freight RailCAO HR Generalist - People Management at Transnet Freight Rail