Lulutho Mfazwe
Data Analyst
East London
Summary
Dedicated and results-driven Data Analyst with 5+ years of experience in analyzing complex datasets, generating actionable insights, and driving data-driven decision-making. Proficient in statistical analysis, data visualization, and programming languages such as Python and SQL. Seeking to leverage analytical skills and expertise to contribute to a dynamic team and support organizational growth
Overview
6
6
years of professional experience
7
7
years of post-secondary education
Work History
Data Analyst
Transnet National Ports Authority
07.2022 - 06.2024
- Extensive experience working with MySQL in production environments - Expertise in query optimization and performance tuning
- Proficiency in database administration tasks such as replication, clustering, and high availability - Designing and implementing advanced stored procedures and triggers
- Experience with scaling MySQL for high-traffic applications - Implementing advanced database features such as partitioning and full-text search
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Evaluated the effectiveness of marketing campaigns using A/B testing methodologies, optimizing strategies for higher ROI.
- Reduced operating costs by automating manual data processes using scripting languages such as Python or R.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Optimized company resources allocation with detailed forecasting models based on historical data analysis.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Used statistical methods to analyze data and generate useful business reports.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Collaborated with stakeholders to identify business needs and data sources.
Data Analyst
Standard Bank Group
01.2019 - 12.2020
- Led data analysis projects, including data collection, cleaning, and preprocessing, resulting in actionable insights that informed strategic decision-making processes
- Developed predictive models to forecast customer behavior and identify potential opportunities for revenue growth and cost optimization
- Collaborated with cross-functional teams to define project requirements, conduct data analysis, and present findings to stakeholders
- Created interactive dashboards and visualizations using Tableau to communicate key performance metrics and trends to executive leadership
- Conducted ad hoc analyses to support business initiatives and address specific questions from stakeholders, providing actionable recommendations based on data insights
- Contributed to the development of data governance policies and procedures to ensure data quality, integrity, and security across the organization
- Used statistical methods to analyze data and generate useful business reports
- Worked with management team to create a prioritized list of needs for each
- Used data to create models that depict trends in the customer base and the client population
- Documented effective and replicable methods for extracting data and organizing data sources.
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
- Developed and implemented data governance policies and procedures.
- Designed and developed data pipelines to acquire, clean and process data.
- Proactively analyzed data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance
- Developed and maintained databases by acquiring data from primary and secondary sources and build scripts that will make our data evaluation process more flexible or scalable across data sets.
Database Analyst Intern
NWU
01.2018 - 12.2018
- Evaluated new technologies for potential implementation into the company''s database environment.
- Performed regular maintenance on databases to ensure optimal performance and prevent issues before they arose.
- Conducted research on industry trends, keeping up-to-date knowledge on advancements in database management techniques.
- Assisted in data analysis for informed business decisionmaking.
- Developed custom SQL scripts to automate routine tasks and improve productivity.
- Optimized backup strategies, enhancing data recovery capabilities and minimizing downtime during unforeseen events.
- Provided timely and accurate updates to project managers regarding progress made on various tasks assigned, ensuring all deadlines were met in a satisfactory manner.
- Collaborated with cross-functional teams for seamless integration of new applications and systems with existing databases.
Education
Certificate - Data Science
Stellenbosch University
Cape Town, South Africa 01.2022 - 04.2022
Certificate - Diploma in Project Management, Certificate
Allison University
01.2022 - 04.2022
Certificate - Advance diploma in Industrial Engineering Principles, Certificate
Alison Univesity
01.2022 - 04.2022
Bachelor of Science - BSC Honors in Mathematical Statistics ( Data Science), Honors
Nelson Mandela University
Port Elizabeth, South Africa 04.2020 - 04.2022
Bachelor of Science - BSC in Mathematics and Statistics, Bachelor
Northwest University
Northwest,Potchestroom 04.2016 - 04.2020
Skills
Mathematical Modeling
undefinedAccomplishments
- Improvements to the Capital Expenditure Procurement Processes Equating to shorter cycle time in Capex.
- Utilities Recovery Cost Reduction projects to have cost savings within TNPA organization.
- Section 56 CPM Optimization of concessions using Business Process Management, to achieve a milestone reduce from 18 months to 6 months 24 days.
- Solving Tool and Lean workflow
- Lean Methodology
- Business Process Management mapping As is processes, optimizing, develop To-be Processes and run SOPs.
- TNPA Customer Survey Study Analysis
- Longitudinal Study research
- Lean Techniques Systematic and Scientific Thinking
Personal Information
- Passport Number: 9812295281081
- Date of Birth: 12/29/98
- Gender: Male
- Nationality: South Africa
- Marital Status: Single
References
- Continous Improvement Executive Manager, bheka.mpaza@transnet.net, +27828565078
- Continuous improvement Manager, vuyokazi.sabani@transnet.net, +27 66 186 1227
- Continuous improvement Manager, percy.mdunge@transnet.net, 076 387 5107
- Lecture, Martin.Chanza@nwu.ac.za, +27 82 512 0581
- Principal, +27634380166
Timeline
Data Analyst
Transnet National Ports Authority
07.2022 - 06.2024
Certificate - Data Science
Stellenbosch University
01.2022 - 04.2022
Certificate - Diploma in Project Management, Certificate
Allison University
01.2022 - 04.2022
Certificate - Advance diploma in Industrial Engineering Principles, Certificate
Alison Univesity
01.2022 - 04.2022
Bachelor of Science - BSC Honors in Mathematical Statistics ( Data Science), Honors
Nelson Mandela University
04.2020 - 04.2022
Data Analyst
Standard Bank Group
01.2019 - 12.2020
Database Analyst Intern
NWU
01.2018 - 12.2018
Bachelor of Science - BSC in Mathematics and Statistics, Bachelor
Northwest University
04.2016 - 04.2020
Similar Profiles
Siyabulela MhlalukaSiyabulela Mhlaluka
Managing Executive: Central Region Ports at Transnet National Ports AuthorityManaging Executive: Central Region Ports at Transnet National Ports Authority
Salmaa VincentSalmaa Vincent
OPERATIONS CENTER MANAGER at Transnet National Ports AuthorityOPERATIONS CENTER MANAGER at Transnet National Ports Authority
Thina QandasheThina Qandashe
PROJECT MANAGER at TRANSNET NATIONAL PORTS AUTHORITYPROJECT MANAGER at TRANSNET NATIONAL PORTS AUTHORITY