Visual Basic 6x
Mohlomi Moloi
Data Specialist
Johannesburg, Gauteng,Gauteng
Summary
Detail-focused Data Specialist with knowledge in data collection, data processing, data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
20
20
years of professional experience
4
4
Languages
Work History
Data Analyst
Health Information Systems Program
Johannesburg
05.2021 - Current
- Migrated legacy systems to modern platforms, minimizing downtime while preserving crucial business information.
- Responsible for collecting, organising, and interpreting statistical information to make it useful for internal and external clients
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Brings technical expertise to ensure quality and accuracy of that data, provide input on structure of database to facilitate best reporting outputs, design and present it in ways to help people, businesses, and organisations make better decisions
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Developed and maintained data warehouses and data marts to support business operations.
Data Manager
Health Information Systems Program
Johannesburg
11.2016 - 05.2021
- Enhanced data security with stringent protocols and regular system updates to prevent breaches and unauthorized access.
- Provide technical front-end support to District Health Information Systems (DHIS) Users
- Led technical upgrade projects for clients by working and coordinating with consultants and developers for integrations.
- Review data collected in DHIS and report on data quality issues
- Importing of data into database and combining databases
- Interpret data looking for patterns and giving feedback on quality of data
- User feedback that will encourage defaulting clients to correct data / or submit data on time
- SQL view queries for reporting purposes
- Manage and control software versions
- Assisting with management and control of DHIS upgrades and version control of software and databases
- DHIS testing (WAR and DB changes) before new versions are released
- Provide data reports in such format that will encourage use of data by client
- Implementation and use of data in DHIS (version specific)
- Data quality checks, profiling and preparation of analytical data sets
- Provision of customized reports to clients
- Report writing
- Presentation of data in formats such as graphs etc.
- That will enhance data interpretation and understanding
- Provide training and facilitation such as: Conduct data review workshops
- Conduct workshops to facilitate use of data / information.
Data Analyst
National Health Laboratory
Johannesburg
04.2014 - 10.2016
- To provide database programming and analysis for various projects in Centre for Tuberculosis especially design of data systems and formatting of data from various sources to produce regular surveillance outputs
- To provide analytical support to projects and activities required
- Assist with implementation of surveillance plan for DRS in conjunction with implementation partners
- Co-ordinate and manage data collection from clinics, provinces and laboratories for DRS and design data capturing system as required
- Manage, maintain and update DRS database by: Setting up and running checks
- Regular cleaning of databases
- Correcting records
- Correlating data against laboratory records, M&E forms and various other data recourses
- Performing daily back up of databases
- Data audit of M&E forms as required
- Improve quality of data and conduct mini data cleaning projects
- Development of DataFax/ Oracle APEX data management SOPs
- Developing database, data entry forms and preparation of analytical datasets
- Conduct performance appraisals and supervise database administrators and other staff.
Data Manager
Contracting at Eskom
Johannesburg
03.2012 - 05.2014
- Provide Data Management services, Optimise Project Systems and Tools, and Support User Group within Primavera and Prism Systems
- Ensure data assurance that supports CARAT PRINCIPLE (Complete, Accurate, Relevant, Accessible, and Timeous) within Primavera and Prism Systems: Gather Data, Analyse Data, Identify Exceptions, Facilitate Data Correction, Pro-active Data Monitoring
- Optimise Primavera and Prism System: Integration between Primavera and SAP Module, Reporting, System Performance
- Centralisation of Primavera
- Primavera System capacity
- USVD report (prioritising)
- Mobilise Primavera End Users: Coordinate Primavera NUG (National User Group) and NUG Work Groups
- Facilitate requirements between Primavera end users and Group IT
- Support system super users
- Facilitate SME input into training material.
- Established consistent naming conventions and metadata standards for improved organisation and searchability of data resources
- Developed information extraction and monitoring practices based on up-to-date InfoSec standards
Data Manager
KHULISA MANAGEMENT SERVICES, PTY LTD.
Johannesburg
01.2007 - 12.2012
- DATA PROCESSING and DATABASE DESIGN
- Database design (according to client specified and research driven indicators)
- Create custom extraction queries that can be used by project team(using advanced SQL statements and data mining tools)
- Transformation and Integration of databases from diverse platforms (Excel, QlikView, Access, MSSQL 2000/2005, PostgreSQL, DBbase)
- Creating relational database, and application interfacing (data modelling, OLE DB, ODBC, JDBC, RDBMS)
- OLAP cube and dashboard design
- Maintenance of data values according to data model and data type
- Responsible for passing PEPFAR Web Application tests on Development, UAT or Live environment
- Development of Online Surveys using Open Source Survey Software Tools
- Preparation of qualitative data and implementation of quality assurance
- Preparation of tabulations, analyse survey data and prepare summary reports
- GIS
- Performing all GIS-related requirements
- Data compilation (integrating outside data sources)
- Data analysis (spatial querying, statistical analysis, database querying)
- Database Management (MS Access, MSSQL 2005 and PostgreSQL)
- Consolidating Geodatabases
- Producing spatial data (imaging, graphical outputs)
- Fulfilling mapping requirements
- Khulisa uses TELEform product from Cardiff Software for questionnaire design and subsequent automated data capture through use of high-speed scanners and TELEform's optical character recognition (OCR) and optical mark recognition (OMR
- Responsible for all management of TELEform and Instrument design
- TELEform uses programming language (i.e. Basic Script) similar to Visual Basic, that scripting depending on instrument/form design requirements
- Responsible for all data management and integrity.
Education
National Diploma Information Technology - Software Development And Information Systems
Mangosuthu University of Technology
Durban, South Africa 01.1999 - 01.2001
Successful Assessment Methods And M in E (SAMMIE). - Assessment Methods And Measurement in Evaluation
Ohio State University Extension
Ohio State 01.2009 - 01.2010
Skills
Data Cleaning
undefinedCountries Of Work Experience
- South Africa
- Zambia
- Lesotho
- ESwatini
- Rwanda
Summary Profile
Mr. Mohlomi Moloi joined HISP-SA in Nov 2016 as a data manager and has since expanded his knowledge and experience to a data analyst. As a data analyst for HISP SA his responsibilities include management of various databases i.e. ICSP Online system, the system was developed to help manage the internship and community service programme so that the application and allocation of posts is fair and equitable. He is currently working on development of an eIDSR and Event Management System to strengthen countries capacity for early detection of public health threats and media scanning. This involves customising existing DHIS2 instance eIDSR, EBS tracker app. Set up Programs, Program Rules and Program Indicators. Mine and analyse large datasets, draw valid inferences, and present them successfully to management using BI reporting tool(s). He has over 15 years of experience in data management and analytics of different data sets. He started his career as a database administrator at the Africa Centre for Health and Population Studies. In February 2014 he joined National Health Laboratory Services (NHLS) as a data analyst for the Centre for Tuberculosis. Mr. Moloi has completed several short courses focusing on administering MS SQL Server 2000/2005/2008 R2 (DTS, SSIS & SSRS), Python, SAS (Prog 1&2), STATA, Power BI, Super Set, DataFax, REDCap, TELEform Manager, Introduction GIS applications (including Arc Editor 9.3), Project Management, Postman API calls, Performance Management, Leadership Training and Development of Standard Operating Procedures (SOP). He was responsible for managing the TB Unit's data management activities at NHLS. As a data manager, he provided data management support to the projects to ensure that their research data is processed and managed efficiently according to the data management policy and standard operating procedures and analytical datasets are ready for analysis when required. He served on the Primavera and Prism National User Group at Eskom. He was also driving the relevant integration points with the SAP module and improving access to data in Eskom Project Management Office (PMO), System and Data. He has also been responsible for creating and populating a MySQL and PostgreSQL database for the PEPFAR/South Africa Data Warehouse at John Snow Inc., (JSI). Mr Moloi has been responsible for obtaining, capturing and entering partner and site information for all the PEPFAR partner organisations into PIMS system. This database, running alongside the data warehouse, provides added analysis and presentation dimensions for the site information, captured by individual partners, where the PEPFAR is carried out in South Africa. Mr. Moloi's database, GIS and reporting knowledge were key components in creating this feature of the PEPFAR Data Warehouse.
Short Courses
- Data Science with Python, University of Cape Town, South Africa, 09/2020
- DHIS2 Maps Academy, Level 2, DHIS2 Academy, South Africa, 05/2023
- Introduction to QGIS, GIMS, South Africa, 02/2007
- SAS Programming 1 and 2, SAS South Africa, South Africa, 05/2013
- TELEform Manager, Vox Telecommunications, South Africa, 02/2008
- Introduction GIS applications (including Arc Editor 9.3), GIMS, South Africa, 02/2007
- Data Management, Microbicide Development Programme, South Africa, 06/2005
- Project Management, Durban Institute of Technology, South Africa, 08/2003
- Administering MS SQL Server 2000/2005/2008 R2, IT Intellect, South Africa, 02/2002
Transport
Yes
Personal Information
- Available: Negotiable
- ID Number: 7802205450085 (South African)
- Date of Birth: 02/20/78
- Driving License: Yes
References
- Bavuyile Norubela, HISP, Data Science Coordinator, 073 500 8747, bavuyile@hisp.org
- Djibril Dione, Health Information Systems Program, Database Specialist, 071 711 5421, djibril@hisp.org
- Comfort Mankga, Health Information Systems Program, Lead Software Developer, 072 635 3487, comfort@hisp.org
Software
Python
Oracle 12g (APEX-forms, APEX-reports)
Transact/PL SQL, SQL 2008 R2
Power BI
Superset
Qlikview
SAS (Pro1&2)
STATA
QGIS
Introduction GIS applications (including Arc Editor 93)
Postgres SQL
Jira project management
REST API
TELEform Manager
REDCap
DHIS2 Software
Postman
PENTAHO
Timeline
Data Analyst
Health Information Systems Program
05.2021 - Current
Data Manager
Health Information Systems Program
11.2016 - 05.2021
Data Analyst
National Health Laboratory
04.2014 - 10.2016
Data Manager
Contracting at Eskom
03.2012 - 05.2014
Successful Assessment Methods And M in E (SAMMIE). - Assessment Methods And Measurement in Evaluation
Ohio State University Extension
01.2009 - 01.2010
Data Manager
KHULISA MANAGEMENT SERVICES, PTY LTD.
01.2007 - 12.2012
National Diploma Information Technology - Software Development And Information Systems
Mangosuthu University of Technology
01.1999 - 01.2001
Similar Profiles
Mihlali DhlaminiMihlali Dhlamini
IT Support Technician at Health Information Systems ProgramIT Support Technician at Health Information Systems Program
Sivuyile MemelaSivuyile Memela
IT Technician at HEALTH SYSTEMS TRUSTIT Technician at HEALTH SYSTEMS TRUST
Tomeka HenriquezTomeka Henriquez
Project Manager at EGT, at National Institute of Health, Information Systems Distribution and Procurement (ISDP) ProgramProject Manager at EGT, at National Institute of Health, Information Systems Distribution and Procurement (ISDP) Program