Business Intelligence Data Management

TREVOR TAKAWIRA MUCHABAIWA

Address:

*** ****** ***** ******: +263*********

Emerald Hill E-mail: ****************@*****.***

Harare

Zimbabwe

PERSONAL PROFILE

Date of Birth: 22 July 1989

National ID Number: 63-2401981 G25

Clean Class 4 Zimbabwean Driver’s license: 75622JZ I am a young, energetic and highly motivated individual who is not afraid to tackle new challenges or obstacles that may come my way. I am enthusiastic to work with new software like Hadoop and closely follow technology and software trends like big data. Work experiences have enabled me to appreciate working independently and working in teams. I have extensive experience in Tableau Programming and Visualization, in programming languages like C++, Visual Basic as well as Command Line Interface programming for Cisco among others. I have network management experience using Datadog as well as Spiceworks. I am certified in the implementation, deployment, programming and maintenance of CISCO Equipment.

Key Skills

• Goal oriented and deliver on assignments timely to meet deadlines

• Ability to analyze complex matters, exercise sound judgment and decision making

• Good logical skills that can be applied in different situations in the work environment

• Strong oral and written communication skills, including the ability to write clear and concise reports and proposals EDUCATION

2022 – 2026 Master of Science – M.Sc. Public Health, University of Suffolk, United Kingdom

(In Progress)

2013 National Diploma in Engineering – Computer Systems, Vaal University of Technology, South Africa

2007 High School - St Mary’s Magdalene’s High School, Nyanga, Zimbabwe PROFESSIONAL CERTIFICATIONS

2013 IBM DB2 Academic Associate: DB2 database and application Fundamentals 2012 CISCO CCNA (Cisco Certified Network Associate) – ICND1 & ICND2 UNDSS (United Nations Department of Safety and Security) CERTIFICATIONS 2022 BSAFE

2020 Information Security Awareness – (Foundational, Advanced & Additional) 2020 Preparing and Responding to Active Shooter Incidents 2018 Basic Security in the Field II

WHO CERTIFICATIONS

2022 Cholera: Introduction

2022 Cybersecurity

2022 Introduction to Go.Data – Field Data collection, chains of transmission and contact follow up 2021 Management and Facilitation of a Country COVID-19 Intra-Action Review (IAR) 2021 Prevention of sexual exploitation and abuse (PSEA) 2020 United Nations Multilingual Course on Prevention of Harassment and Abuse of Authority 2022 Unite to Respect: Preventing Sexual Harassment and other prohibited conduct WHO INTERNATIONAL WORKSHOP AND MEETING PARTICIPATION HISTORY WHO AFRO EMR Review Meeting

• 09 – 10 October 2023 (Mombasa, Kenya)

WHO Global GIS Summit

• 23 – 27 July 2023 (Istanbul, Turkey)

AFRO Geographic Information Systems (GIS) Summit

• 21-24 September 2022 (Brazzaville, Congo)

Regional Workshop Boosting Information Systems, Geographic Information Systems (GIS) and Innovation in the African Region

• 26-30 September 2022 (Johannesburg, South Africa) Sub Regional GIS Training Workshop

• 08-15 April 2022 (Nairobi, Kenya)

Workshop on Training of Data Consultants to support Country NTD Programs

• 2-13 July 2018 (Brazzaville, Congo)

Workshop on Masterplans to Eliminate NTDS in selected Southern African Countries

• 16-20 April 2018 (Victoria Falls, Zimbabwe)

Participation in the 5th RPRG Meeting for PC NTD and ESPEN steering Committee

• 09-15 October 2016 (Dar es Salaam, Tanzania)

NTD Mapping Project Data review workshop

• 08-12 August 2016 (Brazzaville, Congo)

Participation in Experts meeting of NTDS in the African Region

• 03-07 May 2016 (Gaborone, Botswana)

EMPLOYMENT HISTORY

World Health Organization/Zimbabwe (Harare) Country Office – Consultant: Cholera Surveillance Team Lead

(September 2023 –December 2024)

In February 2023, Zimbabwe started experiencing a cholera outbreak. The WHO CO established an Incident Management Systems (IMS) in September with different pillars based on the Health Emergency Preparedness, Response and Resilience

(HEPR). Collaborative Surveillance is a pillar with both Epi-Surveillance and Laboratory pillars. I was nominated based on past experience and competencies to be the Surveillance Team lead, responsible for both pillars. Part of the responsibilities tasked to me have been, production of a Weekly Bulletin that is disseminated at the WHO AFRO and WHO HQ levels, ongoing technical support in the updating of Ministry of Health and Child Care (MoHCC) data collection tools; CTC Register, Cholera Mortality Audit tool, Weekly lab summary form as well as Water Quality Monitoring Tool. Subsequently we have produced interactive dashboards that automatically update when there is any change in data reported.

Key Achievements:

• Finalized Cholera Guidelines

• CTC and ORP Mapping tool for use by both the MoHCC and partners.

• Repository for all IDSR weekly data for period 2018 to 2023 maintained.

• Production of a Weekly Cholera Operational Update to WHO AFRO and WHO HQ

• Trained 50 Health Information officers in advanced data analytics and visualization at Provincial and District level

• Produced 4/5W Partner mapping (Updated periodically)

• Provided technical support for the Zimbabwe OCV campaign for the Cholera outbreak

• Technical support for the tools used in the Post Campaign Coverage Survey (PCCS)

• Continued maintenance of Tableau live Dashboards in use by International Partners and the MOHCC.

• Providing predictive analysis and modeling of the outbreak on a monthly basis to improve planning and contingency stocking

Expanded Programme on Immunization (EPI) Key Achievements

• Production of weekly Integrated Supportive Supervision (ISS) data analysis

• Technical support to the MoHCC in the production of the weekly Polio Update

• On the job mentoring during site supportive supervision.

• Analysis of Polio Supplementary Immunization Activities (SIA) data 1. Administrative Coverage

2. Independent Monitoring (IM)

3. Lot Quality Assurance Sampling (LQAS)

to monitor as well as provide inputs to improve future SIAs planned in the country Other key duties assigned

• Sharing of weekly IDSR data to WCO and AFRO

• Nominated to be EMS2 focal point in WCO

World Health Organization/Zimbabwe (Harare) Country Office – Consultant: Data Manager (July 2022 –August 2023) After the successful fulfilment of my iMMAP contract I was engaged to resume my work as the WHO CO Zimbabwe Data Manager. With the wealth of information and training gained I manage to continue producing 4/5W Matrix data for the UN OCHA Zimbabwe Office. Coronavirus (Covid-19) outbreak in Zimbabwe is still ongoing however a decline in cases has been noticed. I was tasked to also assist the Routine Immunization Department at WHO, this deals with the Immunization of children from Birth until 5 years. I managed to develop a system in Tableau that can track field activities undertaken by colleagues. This includes the use of GPS to track movements and provide real time information regarding the number of sites visited. The system is also designed to capture the quality of service being provided to the clients at a health facility, and allows on the job mentoring and training to improve quality of care. As the rainy season approached towards the end of 2022, we needed to be prepared for Epidemic Prone diarrheal diseases. Part of the activities undertaken were the updating of National Typhoid and Cholera Guidelines. These are crucial to ensure continuity of care when some is tested positive for either Cholera or Typhoid. We developed line lists as well as analysis templates which will assist epidemiologists in responding to an outbreak. We also assisted the MoHCC in conducting a Routine Data Quality Assessment (RDQA). The RDQA process involves tracking 12 indicator values from Health facility level, to district, Provincial and National level. This is done at randomly selected heath facilities across the country. Where anomalies or data discrepancies are noted, we would highlight the cause and work back to ensure that data remains integral for use in Public health care.

Key Achievements:

• Updated Typhoid and Cholera Guidelines

• Repository for all IDSR weekly data for period 2018 to 2023 maintained.

• Production of a Weekly Covid-19 Sitrep.

• Clean and up to date Covid-19 line-list.

• Continued maintenance of Tableau live Dashboards in use by International Partners and the MOHCC. World Health Organization/Zimbabwe (Harare) Country Office – iMMAP SBP (Stand-by Partner) Consultant: Information Management Officer (May 2021 – June 2022) The Health Cluster in Zimbabwe had been in operation without a full time IMO (Information Management Officer) and as result, iMMAP offered this role to supplement the existing data management role I had in the WHO Country Office Zimbabwe. I reported to the Health Cluster Coordinator. In addition to Covid-19 data management I coordinated with UN OCHA to ensure that the Health Cluster HNO (Humanitarian Needs Overview) and HRP (Humanitarian Response Plan) data needs for Zimbabwe were met. iMMAP also offered training on the PHIS (Public Health Information Systems) to build capacity. This training has helped me in my duties that included submitting additional 4/5W matrix data on a monthly basis to UN OCHA. During the training we also received skills for Data Management and visualization which were adopted in Sitreps as well as Dashboards that i managed. We also scaled up Covid-19 reports to include Hospitalization Data and Covid-19 vaccination coverage. We also provided technical assistance to the Ministry of Health and Child Care Zimbabwe

(MOHCC) by refining and updating Covid-19 surveillance forms. The forms served as an intermediate solution as we awaited the rollout of Go.Data to the rest of the country. The pilot phase was successful in Mashonaland East Province and was subsequently adopted in Bulawayo and Manicaland Provinces. The close monitoring and documentation of cases in Covid-19 admission sites was also important as it informed changes necessary in case management and as a result an online covid-19 admission data repository was created and we capacitated the MOHCC to manage the repository. As WHO CO we addressed vaccine hesitancy with the use of data and this improved uptake of the vaccine amongst the population. The adoption of resurgence thresholds analysis by the MOHCC really helped the country in identifying hotspots, in return WHO Country Office responded in identified areas by providing support that was tailor made for the different Provinces in the responding to Covid-19. Through the ongoing inter-cluster IMO meeting we have been able to collaboratively share and disseminate information

Key Achievements:

• Repository of ODK tools that are used in field activities

• Repository for all IDSR weekly data for period 2018 to date is maintained.

• Production of a Weekly Covid-19 Sitrep.

• Clean and up to date Covid-19 line-list.

• Routine monitoring of selected indicators that are analyzed monthly.

• Ongoing maintenance of live Tableau Dashboards that tracks Covid-19 for use by International Organizations as well as the MOHCC Zimbabwe.

World Health Organization/Zimbabwe (Harare) Country Office – Consultant: Data Manager (September 2020 – April 2021)

Coronavirus (Covid-19) outbreak in Zimbabwe has come with many challenges. One of them was the issue of Data management. Due to my previous experience with the Zimbabwe WHO Country Office, I was asked to come onboard to support as a data manager consultant reporting to the COVID-19 Incident Manager. My first task was to support with data analysis as well as visualizations for the covid-19 response, this has helped colleagues with key information to better assist the MOHCC of Zimbabwe in making data driven decisions regarding the actions to be taken and way forward in containing the virus. Current ongoing activities include assistance in the monitoring of routine indicators that are generated at a weekly as well as monthly basis. These are disseminated within the country office as well as shared with the AFRO level. There are two main types of indicators we are monitoring; disease specific indicators as well as those linked to the monitoring of access to essential health services. WHO Country Office supports all provinces and districts through trainings and supervised visits and as part of the various teams I have used the opportunities to train MOHCC cadres in Covid-19 related surveillance activities and to improve their data management practices. This has resulted in better reporting of data as well as timely submission to the next level. Other ongoing activities include training and capacity building of MOHCC staff in the use of Go.Data; a proprietary WHO application that is used in different disease outbreak situations for surveillance purposes.

Key Achievements:

• Functional Go.Data system that is in use in Mashonaland East and awaiting rollout to the rest of Zimbabwe

• Repository for all IDSR weekly data for period 2018 to 2020 created.

• Production of a Weekly Covid-19 Sitrep.

• Clean and up to date Covid-19 line-list.

• Repository for all ZIRP Databases as well as tools inclusive of indicators in one central place.

• Training MOHCC staff in good data management at Health facility, District as well as Provincial level.

• Routine monitoring of selected indicators that are analyzed monthly.

• Setting up a live Dashboard that tracks Covid-19 for use by MOHCC. Independent Consultant: (September 2019-August 2020) During this period, I was busy with report writing for the consultancies that were undertaken in 2019 for the World Health Organization as well as finalization of Datasets that were in turn submitted to the WHO AFRO ESPEN Data Manager. I also took the time to reinforce existing knowledge about Data management as well improve my proficiency in the use of Tableau. I have also completed courses and received certification from UNDSS for Information Security awareness. Since the outbreak of Coronavirus (Covid-19) I realized there was a need to visualize the available data from the Ministry of Health and Child Care of Zimbabwe (MOHCC). I proceeded to create a new database, produced Info-graphs as well as interactive Dashboards in Tableau. The data I used was freely and publicly available through the Ministry’s webpage as well as their social media platforms. I published these dashboards onto Tableau public website and maintained the dashboards daily with new and available data. I believe that at the time the dashboards gave insight into the disease and MOHCC colleagues used them.

Key Achievements:

• Establishment of a Coronavirus (Covid-19) info-graph and interactive dashboards using data from the Ministry of Health and Child Care of Zimbabwe for tracking and monitoring of the disease on Tableau Public. World Health Organization/Congo (Brazzaville) Country Office – Data Consultant: Disease Control and Prevention

(August 2019)

The first task was to conduct sub-district level analysis using spatial prevalence data district by district using ArcGIS as well as Tableau, in turn to describe districts that should adjust their implementation strategy to shrink the country Schistosomiasis map. The second task was to update sub-district level planning for participating countries. I was also tasked to update the JRSM (Joint Request for selected medicines) based on sub-district data. Another task was to present precision mapping gaps in each of participating countries. Lastly, I had to revise Praziquantel needs based on map shrinking using available data. Data management was done using Microsoft Access and Alteryx. Key Achievements:

• Analyzed sub district level data for selected countries.

• Provided training modules for different country Program managers.

• Updated sub-district level implementation planning for participating countries.

• Updated Joint request for selected medicines (JRSM) based on prevalence data delineated to sub- district levels

• Updated and refined of Praziquantel needs based on map shrinking using available data. Updated sub district level endemicity maps.

World Health Organization/Kenya Country Office – Data Consultant: Disease Control and Prevention (June 2019) Reviewing and validation of historical and current available data at ESPEN database for the 5 PC-NTDs has been a very important step towards elimination of NTDs in Kenya. One of the steps involved developing an implementation unit level roadmap for the control/elimination of the 5 PC-NTDs, this roadmap provided insight into the necessary steps needed to accomplish elimination. I was also tasked in preparing a multiannual NTD budget using the Tool for Integrated Planning and Costing (TIPAC), this assisted in making sure enough funds were allocated for different activities to be done over the next 3 years. I was also tasked in strengthening the capacity of national teams in data management. Lastly, I was involved in identification and resolving discrepancies between WHO/ESPEN NTD data and the MOH Kenya NTD Data. Key Achievements:

• Creation of Implementation Unit roadmap towards the elimination for the 4 PC NTDs that are endemic for Kenya.

• Harmonization of demographic data at the implementation unit Mapping data flow from the site and schools all the way up to the national level

• Completion of the Partner Matrix in order for the identification of where areas are being supported as well as identifying funding gaps that exist

• Training in the use of the JAP (Joint application Package) for the reporting of previously completed MDAs as well as for requesting Medicines for the oncoming year.

• Establishment of the CIND (Country integrated Neglected Tropical diseases database) as well as training MOH staff in the use of the CIND for the use of storing data as well as producing reports

• Training MOH staff in the use of TIPAC (Tool for Integrated Planning and Costing) to be used in the production of multi-year plans as well as budgeting for activities in a clear and transparent way.

• Training in advanced Microsoft Excel skills as well as good data management practices that will be useful in the day- to-day activities that are data related.

World Health Organization/United Republic of Tanzania Country Office – Consultant: Data Analytics and Dashboards Consultant for Cholera Outbreak (September 2018 to December 2018) The establishment of a robust Database system to be used in the fight to control Cholera was very important. The skills I used to achieve this were a combination of Microsoft Access as well as Alteryx to clean the data, test for duplicates as well as give an informative summary of where data had been misplaced within the various fields. The tableau dashboards included GIS maps as well as interactive views. GIS maps where created using spatial data collected in the field during the outbreak to visually show distribution within various districts. Dashboards produced provided visuals for existing as well as new indicators that were presently not being monitored within Cholera Control in Tanzania. These new indicators are being used elsewhere in the World in the control and management of Cholera to make informed decisions. Dashboards for forecasting and predicting outbreaks where produced and importantly helped the country to better prepare for the likelihood of a breakout in a certain season or area based on epidemiological and environmental evidence while considering WASH data as well as social based factors. Data management was done using Microsoft Access and Alteryx. Key Achievements:

• Establishment for the first time in Tanzania a Cholera Database

• Produced Outputs for Weekly Cholera Situation Report and Weekly Datasheet for WHO AFRO

• Trained Tanzania WCO Data managers and an epidemiologist in use and deployment of Tableau

• Formulated data verification checklist that are being used at Cholera Treatment Centers we visited

• Mentored District Health officers in the line listing of data

• Formulated Tableau Dashboards that are used by High level ministry officials as well as WCO staff to make informed decisions as well as provide appropriate response to cholera affected areas World Health Organization/IST Regional Office Harare- Consultant: Data Management (January 2017 to December 2017)

Due to the extensive knowledge of the WHO NTD database system, I was asked to consult in the exercise of Data Management as well as Tableau Management. GIS maps where developed using Tableau in the form of dashboards this helped decision makers make evidence-based decisions in the continued fight against NDTs in Africa. Due to lack of funding a formal post could not be established however most of the year was spent helping out by producing outputs that were used in reports as well as presentations by the WHO IST Harare Office. World Health Organization/IST Regional Office Harare- Special Services Contractor: Tableau Data, Visualization and Business Intelligence Officer (September 2016-December 2016) The Neglected Tropical Diseases (NTD) Mapping Project had concluded the data cleanup and verification process and was in need to start the first step in making this data useful for action especially for stakeholders as well as decision makers within the different ministries of Health across Africa. Tableau was chosen as the main Data visualization and business intelligence platform. I received training through the World Health Organization and began use of Tableau. The Analysis of Data was important and assisted in countries receiving appropriate needs based on the data. As a result, the data helped the organization cut costs that were unnecessary and focus funds on key priorities within the NTD. Key Achievements:

• Formulating and generating code used to create different analysis areas for the Neglected Tropical Diseases Mapping Project using Tableau.

• Analysis produced from the code resulted in the generation of GIS Maps, Charts and Graphs in Tableau. These where used by Neglected Tropical Diseases experts to produce peer review papers.

• Maps, Charts and Graphs produced in Tableau were also used in designing dashboards. These dashboards are available online on the Neglected Tropical Diseases Mapping Portal for the World Health Organization Staff, Neglected Tropical Diseases experts as well as International partners of the World Health Organization for use today.

World Health Organization /IST Regional Office Harare- Temporary Advisor: Data Manager (October 2015-August 2016)

The Neglected Tropical Diseases Mapping Project ended in August 2015. After this period, we received unprocessed data in the form of Word Documents, Excel and PDFs. Our task was to clean the data, process it into usable data using Alteryx Designer and then transformed it into Access database tables. Pre-existing data from before the mapping project was also available and we were tasked to harmonize this historical data with the current data into the same format for use. Our data preparation process included removal of duplicate records, reassignment of misclassified data as well standardization of data. Individual data included Geo coordinates and we used ArcGIS as well as Tableau to visualize the distribution of the PC NTDs across Africa. The GIS maps were produced for all African countries at district level and this provided insight into where action was needed to alleviate the burden of the disease through MDA (Mass Drug Administration) Key Achievements

• This resulted in a consistent state of data was maintained across the different hierarchical levels that data was available at. We worked with data at the Country, Province, District/Implementation Level, Location level that included schools and villages and lastly at an individual level.

• A GIS map-based Atlas was produced for all WHO AFRO countries that showed disease burden to assist in the implementation of MDA (Mass Drug Administration)

Independent Consultant (February 2014 to September 2015) Undertook various projects as an independent consultant for a few companies in South Africa. Most of the work was Web based Applications. I was also involved in developing Moodle E-Learning sites using HTML5 and CSS for a few high schools. Newco, South Africa - IBM BPM Designer and IBM BPM Administrator (August 2013 – January 2014) Newco was tasked by the Vaal University of technology to build an HR (Human Resources) system for the HR Department. As a team, we built the system for both Permanent and Non- Permanent Staff. We used coach designs, data mapping implementation of Business Data, HTML amongst others. In this project we implemented JAVA, HTML and applied skills that are related to object-oriented modelling. I was personally responsible for all BPM server installations, Websphere networking and communication between virtual machines using VMware, maintenance of the BPM Server and concise documentation of processes.

Newco, South Africa – P1 Intern Group Leader (January 2013 – July 2013) We were tasked with the modelling of an SRS (Student Registration System). As the leader, I delegated and divided the system into separate components in terms of use cases. Pre-Register was my assumed use case. In this project, we focused on UML (Unified modelling Language) Our system assisted in the improvement of what was at the time the existing Registration System which was slow and inefficient. Vaal University of Technology, South Africa – Tutor (August 2012 – August 2013) As a tutor for Database Administration as well as System Software, I tutored first year students and my roles entailed helping students weekly with assignments as well as end of semester projects. Sebcon Engineering – Personal Assistant to the Director (January 2008 – July 2009) This was my first job after High School with the goal of raising school fees for university as well as to obtain basic working skills. Duties included taking minutes of meetings, answering calls and taking messages, sorting out mail, and delivering to appropriate recipients. Additionally, my other responsibilities were maintaining computers, which included updating Software, recommending hardware Purchases. Project planning and streamlining project activities to ensure an efficient working environment.

HOBBIES

Rugby, Cycling, Soccer, Chess and distributing Literature. SOCIAL NETWORKS

Linkedin: https://www.linkedin.com/in/trevor-muchabaiwa-2232a47b/ REFERENCES

Dr. Lincoln Charimari

EPR Team Lead

World Health Organization Intercountry Support Team for Eastern and Southern Africa 82 - 86 Enterprise Rd, Corner Enterprise & Glenara Road Highlands, Harare, Zimbabwe

P.O. Box CY348, Causeway, Harare, Zimbabwe, Tel: +263-***-***-***/32 Email: **********@***.***

Mr. Nkosi Mpala

Public Health Officer- Planning, Budget, Monitoring and Evaluation (PME) World Health Organization

Syria

Whatsapp: +263-***-***-*** Mobile: +963-********* Email: ******@***.***

Mr Robson Mukwiza

Health Information Officer

Ministry of Health and Child Care Head Office

Harare, Zimbabwe. Tel: +263-*********

Email: *********@*****.***

Mr Levison Nkoma

Senior ICT Officer

Ministry of Health Ndeke House

P.O Box 30205 Lusaka, Zambia. Tel: +260-*********/5 Email: ******@***.***.** ********@*****.***

Contact this candidate