Alpheus Legoke (Al) Mokgalaka

Data Specialist (Data Steward/Data Support)

DPME•  July 2010 - Present

Key Responsibilities are: Data Collection: Expertly gather data from various sources to fuel our analytics efforts. Data Manipulation: Skillfully manipulate and transform complex datasets to extract valuable insights. Data Analysis & Reporting (MS Excel): Proficiently use MS Excel to conduct in-depth data analysis and generate comprehensive reports. Data Visualization: Leverage data visualization tools such as Matplotlib, Seaborn, Plotly, Tableau, QlikView/Sense, and MS Excel to create visually compelling representations of data. Data Quality Management (DQM): Ensure the integrity and quality of data through rigorous data quality management practices. Executive Data Insights: Communicate data insights effectively to executives, empowering them to make informed decisions. Application and Data Tool Development: Develop and build data tools, dashboards, and data visualization reports to facilitate data collection (ETL), manipulation, and analysis. Data Pipeline Construction: Construct data sources and data pipelines, enabling seamless data flow between sources and data warehouses or analysis platforms. Statistical Modeling (Machine Learning): Apply statistical modeling and machine learning techniques to automate processes and predict outcomes, enhancing efficiency and decision-making.

Data Quality Specialist: SAS & SQL (Teradada)

SARS•  March 2007 - June 2010

Key Responsibilities were: SAS Programming: Develop SAS programs to access, import, extract, transform, and load data, facilitating the data preparation process. Data Exploration and Manipulation (EDA): Conduct in-depth data exploration and manipulation to uncover insights and patterns within the data. Data Analysis: Perform comprehensive data analysis using tools such as SAS, MS Excel, Oracle SQL, MS Power BI, and Tableau. Data Visualization and Reporting: Create visually compelling data visualizations and reports using SAS, MS Excel, Oracle SQL, MS Power BI, and Tableau to convey insights effectively. Data Quality Management: Ensure data quality and integrity by implementing rigorous data quality management practices. Executive Insights: Share data-driven insights with executives to support informed decision-making. Key Achievements/Accomplishments: Conducted thorough data profiling and successfully identified risk trends. Enhanced risk detection related to income tax, leading to a 15% reduction in fraud associated with income tax payments. Contributed to improved tax collection revenues during the 2008/9 financial year. These achievements underscore my ability to leverage data analysis and reporting to drive positive outcomes and contribute to organizational success.

IT Corporate Training Specialist/Instructional Designer

Telkom SOE•  August 1998 - February 2007

Key Responsibilities were: Learning Material Development: Collaborate with the Centre of Learning team to design and create both formative and summative learning materials. E-Learning Management System (e-LMS) Tools: Utilize various e-LMS tools such as Articulate Rise, Articulate Storyline 360 for storyboarding, Adobe Captivate 360, Camtasia, Coassemble, Elucidate, Gomo, and Lectora Online to develop engaging and effective learning content. ADDIE Model: Apply the ADDIE (Analysis, Design, Development, Implementation, Evaluation) model to ensure the systematic development of high-quality learning materials. Storyboarding: Utilize tools like Articulate Storyline 360 for storyboarding and creating interactive learning experiences. Multimedia Content: Incorporate multimedia elements, including video, audio, graphics, and animations, to enhance the learning experience. Quality Assurance: Conduct thorough testing and quality assurance to ensure the functionality and effectiveness of e-learning materials. Continuous Improvement: Collaborate with the CFL team to assess the impact of learning materials and make continuous improvements based on feedback and evaluations.

Part-time Tutor

University of South Africa (UNISA)•  May 1996 - November 2003

Key Responsibilities were: Mentorship and Knowledge Sharing: Share expertise with students and fellow team members, providing guidance and mentorship in computer science fundamentals, theory & concepts, logic, program instructions, C++/Delphi/Python syntax and rules (write code, run/test code, edit code, add comments for readability/or explain what code does and rerun code until code successfully passes sample test cases), data types (literals: int, float, str), print statement (' ', end=''), print variable (assign a value to a variable/write an assignment statement), change the value of a variable, conditional statements/If- else Statement, For Loop and While statement, hardware and software systems, computer programming (e.g., Delphi, FoxPro, DB2, Visual Basic), and applied statistics (define hypothesis, formulate a problem, take an educated guess/apply machine learning:write a functional model,test and train model, deploy and interpret results). Software Development: Collaborate with the software development team to design, develop, and maintain software solutions. Code Review: Engage in code reviews to ensure code quality, adherence to best practices, and efficient software development processes. Technical Training: Offer training sessions or workshops to enhance the technical skills of team members, fostering a culture of continuous learning and improvement. University Partnerships: Explore opportunities for partnerships or collaborations with universities or educational institutions to bridge the gap between academic knowledge and practical software engineering skills.

Analyst Programmer: Natural Adabas

StatSA•  July 1995 - July 1998

Key Responsibilities were: Design and develop new systems (code using Natural and Natural Construct programming language), maintain and support existing system using ADABAS (Adaptable Data Base System/Inverted list) for database management system. Investigate programming issues and providing solution for issue found, design, programming and testing. Adhered to company standards and best practice when designing and coding. Knowledgeable of PREDICT softwares (R, SAS, SPSS, SQL) with ability to build and deliver high quality robust statistical models, reports and documentation (= support and maintain library awareness, its usage for continuous development). Experience and knowledgeable in Job Control Language (JCL) and File Transfer Protocol (FTP) processing through JCL. Ability to coordinate change management protocols and work within a team-oriented structured environment. Experienced analyst programmer in public sector environment (Statistics South Africa) open for banking opportunities in order to gain experience in W2 processing/reporting and other end of year federal reporting (including electronic funds processing and addendum records). Knowledgeable of TSO, CICS, VSAM/VTAM and Switch. Query Development: Create and optimize queries for the development and testing of the Natural Adabas Functional System (UFTS: User Functional Testing Specification). Functional System Testing: Participate in UFTS testing, which includes acceptance, integration, and unit testing, ensuring the software meets quality assurance (QA) standards. Test Case Development: Collaborate with the QA team to develop test cases that effectively validate the functionality of the Natural Adabas system. System Optimization: Continuously work on system optimization to improve performance, efficiency, and reliability. Code Review: Engage in code reviews to maintain code quality and adhere to development best practices.

University of South Africa

Computer Information Systems, BS•  January 2000 - December 2003

BSc degree in Statistics, Applied Statistics (ANOVA & Regression with SPSS/SAS JMP) & Information Systems (Database Design, SQL Implementation, Software Project Management)), +Submajor in Computer Science - Nov 2003 (graduated on the 25th May 2004). BCom degree in Quantitative Management (Operations ResearchDecision Sciences) - Nov 2010 (graduated on the 23th May 2011).