Mpumelelo Adons
Bloemfontein
Summary
Detail-oriented Data Analyst with strengths in data extraction, transformation, and analysis. Generates actionable insights through SQL, R, and Python, enhancing decision-making for academic and administrative departments. Designs interactive dashboards in Power BI, simplifying complex data for stakeholders.
Overview
5
5
years of professional experience
10
10
Certification
Work History
Data Analyst
Central University of Technology, Free State
Bloemfontein, South Africa
09.2025 - Current
- Data Analysis & Reporting: Extract, transform, and analyze large datasets using SQL, R, and Python to generate actionable insights for academic and administrative departments.
- Data Visualization: Design and develop interactive dashboards and reports using Power BI to present complex data in a clear, compelling way for line manager.
- Database Management: Write and optimize SQL queries to efficiently retrieve data from LMS database, ensuring data integrity and accuracy.
- Process Improvement: Automate data collection and processing tasks with R and Python to improve efficiency and reduce manual workload.
Online Statistics Tutor
TeachMe2
Bloemfontein, South Africa
10.2021 - Current
- Tutored students in statistics from first year to postgraduate level, enhancing understanding of concepts and R programming skills.
Assistant Researcher (Data Science & Analysis)
University of the Free State
Bloemfontein, South Africa
11.2022 - 08.2025
- Creating master datasets by integrating multiple data sources for Blackboard analytics.
- Preprocessing and standardizing data for thorough analysis.
- Designing and implementing data pipelines for efficient data flow in Blackboard.
- Performing data visualization with Tableau & Power BI for strategic reporting.
- Crafting insightful reports and interactive dashboards using Power BI.
- Communicating complex data analytics to line managers with clarity.
- Conducting statistical programming and advanced data analysis using Python and R.
- Ensuring data integrity through rigorous data cleaning and quality checks.
- Machine learning & Data modelling.
- Running Impact analyses.
- Integrating Google's generative AI capabilities within Python applications.
- IImplemented AI-driven solutions using Python and the LLM (Gemini API) for efficient processing, grading, and feedback extraction from large datasets of essays
Statistics Junior Lecturer
University of the Free State
Bloemfontein, South Africa
07.2022 - 10.2022
- Conducted engaging teaching sessions, personalized tutoring and precise marking for first year statistics students.
Data Management Intern
Free State department of Health
Bloemfontein, South Africa
01.2021 - 08.2021
- Developed a COVID situational reporting tool using RMarkdown.
- Conducted comprehensive data capturing and processing.
- Performed rigorous data quality checks for health systems.
- Executed detailed data analysis using R.
- Engaged in statistical programming with R.
- Updated and maintained health systems.
- Compiled and updated monthly HIV reports.
- Gained exposure to key health systems including Tier.net, DATCOV, GoData, EVDS, and Bed Management.
Education
Master of Science - Applied Statistics
University of the Free State
Bloemfontein, South Africa01-2026
B.Sc Honours - Applied Statistics
University of the Free State
Bloemfontein, South Africa01-2022
Bachelor of Science - Biochemistry, Genetics & Mathematical Statistics
University of the Free State
Bloemfontein, South Africa01-2020
Skills
- Data analysis
- Data visualisation
- SQL database management
- Power BI
- PYTHON
- R programming
- Process improvement
- Front-end development
- Back-end development
Languages
English
Advanced
C1
Xhosa
Proficient
C2
Afrikaans
Intermediate
B1
Certification
- R for Data Science: Analysis and Visualization
- Python Data Analysis
- Complete Guide to R: Wrangling, Visualizing, and Modeling Data
- PowerBI Essential Training
- Advanced Power BI: DAX Language, Formulas, and Calculations
- CDISC ADaM (Analysis Dataset Model)
- CDISC SDTM (Study Data Tabulation Model)
- Machine Learning and AI Foundations: Prediction, Causation, and Statistical Inference
- Microsoft SQL Server 2022 Essential Training
Accomplishments
- Developed a full functional system: "Kasi Solutions" which provides fast-food businesses with a specialized Sales Data Intelligence System. We capture, consolidate, and store daily sales transactions in a reliable MySQL database, transforming raw Point-of-Sale (POS) figures into interactive, real-time dashboards (like PowerBI). Our system empowers fast-food managers and owners to make instant, data-driven decisions on inventory, staffing, promotions, and profitability to drive operational efficiency and growth.
Timeline
Data Analyst
Central University of Technology, Free State
09.2025 - Current
Assistant Researcher (Data Science & Analysis)
University of the Free State
11.2022 - 08.2025
Statistics Junior Lecturer
University of the Free State
07.2022 - 10.2022
Online Statistics Tutor
TeachMe2
10.2021 - Current
Data Management Intern
Free State department of Health
01.2021 - 08.2021
Master of Science - Applied Statistics
University of the Free State
B.Sc Honours - Applied Statistics
University of the Free State
Bachelor of Science - Biochemistry, Genetics & Mathematical Statistics
University of the Free State