..

Qualifications

TERMS OF REFERENCE
INTERNATIONAL CONSULTANT FOR THE NATIONAL TUBERCULOSIS AND LEPROSY PROGRAMME DHIS2 TB TRACKER SYSTEM DEVELOPMENT
(OPEN TO NON-NAMIBIAN NATIONALS ONLY)

1.    BACKGROUND
The National Tuberculosis and Leprosy Program (NTLP) under the Ministry of Health and Social Services (MoHSS) is seeking a consultant, with the assistance of the World Health Organization (WHO) and Centers for Disease Control and Prevention (CDC).  The purpose of the consultancy will be to upgrade the existing MoHSS’ DHIS2 TB Tracker data system’s reporting and data export functionality, upgrade the current DHIS2 version to the latest reliable version, add a module to capture leprosy cases, and provide support to the local consultant with importing TB historical data from NTLP’s Excel sheets into the existing data elements in the DHIS2 tracker system, including the creation of an additional monitoring section capturing adverse drug reaction (ADR). The reporting and data exporting functionality will allow the data to be downloaded into excel and CSV format for easy data analysis.  Upgrading the current DHIS2 version will better system functionality, fix bugs, better performance, and user-friendly interface.  Whereas, addition of the leprosy module will allow the program to capture data of leprosy cases on the DHIS2 tracker system.

2.    OBJECTIVES AND PURPOSE OF THE CONSULTANCY
The main objective of the consultancy is to improve the MoHSS’ DHIS2 TB Tracker system reporting and data export functionality, upgrade the current DHIS2 version, add a module to capture leprosy cases, provide support to the local consultant as stated above.
Scope of work
The firms/ individual consultants will work to carry out the following tasks:
*    A comprehensive strategy along with the work plan at the start of the consultancy indicating the timelines and major milestones for the completion of the assignment.
*    Initial maintenance plan after final deployment, including necessary training for those tasked with maintaining the system.
*    Develop and configure the DHIS2 TB Tracker reporting and data export functionality into Excel and
CSV format.
*    Upgrade the current DHIS2 version to the latest reliable version
*    Add a module to capture leprosy data
*    Separate Kavango region (organization unit) into two separate regions (Kavango West and Kavango               East), and further organize the two groups base on the respective districts and health facilities
*    Develop a user training guide
*    Train MoHSS staff on development and customization of DHIS2 tracker and data use
*    Documentation of the whole programing process

Other tasks for consultant
*    Development of Data visualizations i.e., dashboards, and Standard and customized reporting functions
*    The consultant shall report and update the TWG, every week (To track progress made and address challenges encountered during the phase).
*    At the end of the above consultation, all parties (the Consultant, the TWG, and NTLP) must have common understanding about project deliverables
*    At the end of the project, the deliverables should meet the objectives of the project to be considered a success, thus these working deliverables should be submitted together with the hand over project files
*    A failure to deliver the specified objectives of the project, is considered unsuccessful
3.    Deliverables
Outline clear tasks and deliverables, to be carried out in the framework of the background described above.
The tasks to be conducted are outlined below.
MoHSS expects the consultant to complete and submit the following deliverables by 27 September 2023:
*    A fully functional DHIS2 TB Tracker reporting and data export functionality able to export/download data into Excel and CSV format.
*    A fully functional additional leprosy module being able to capture leprosy cases and reporting
*    Report of capacity building of staff covering development, customization, analysis, reporting and data export functionality.
*    Technical user manual on the TB/Leprosy DHIS2 tracker system
*    Final comprehensive report with recommendations

4.    DURATION OF THE ASSIGNMENT
The duration of the assignment, 31 DAYS (28 AUGUST to 27 SEPTEMBER 2023)
*    In-country throughout:  28 AUGUST To 27 SEPTEMBER 2023
5.    Qualifications, experience, skills and languages
Educational Qualifications
*    Bachelor of science in informatics
Desirable
*    Advanced degree (Masters level) in a relevant field (computer science, data/health information, advanced statistical analysis, information technology, and software engineering).

Experience
*    At least 5 years’ experience in information system management especially on web-based software platforms and database administration;
Desirable
*    At least 10 years’ experience in information system management especially on web-based software platforms and database administration;
*    At least five years’ experience in DHIS 2 configuration and server administration for health information systems;
Skills/Knowledge
*    Demonstrable skills in working with one or more programming languages including Java Runtime Environment (JRE 7 or higher) Tomcat server, Java, and PostgreSQL, web — Apache HTTP Server, Apache Tomcat, Databases — MySQL, PostgreSQL, Oracle.
*    Demonstrable skills in Programming and scripting — PHP, Java, Perl, JavaScript, Python
*    Development experience utilizing web-based applications such as J2EE, JDK, Struts, Spring, Hibernate, and HTML.

Languages and level required

*    Demonstrate excellent oral and written communication skills, including presentations in English
6.    Technical Supervision
–    Dr Sirak Hailu, Public Health Officer, WHO Namibia.
7.    Location
Please specify where the consultant will work: Works in Namibia during the full duration of the consultancy period
On site: WCO Namibia and Ministry of Health and Social Services during In-country:  28 August to 27 September 2023
Off site: N/A
On site for insurance purposes: WCO & MoHSS Namibia (please indicate location/address)

8.    Travel – If travel is involved, full medical clearance is required
Please specify any expected travel(s): dates, location and purpose.
*    Travel to Windhoek, Namibia upon inception of the contract, from 28 August to 27 September 2023
A living expense is payable to on-site consultants

9.    Remuneration and budget (travel costs excluded)
Rate [daily or monthly or for language and publishing services by word count or number of pages]: Grade P4 (Band B rate), monthly rate of 8,500 USD per month [TOTAL  =  8,500.00 USD). 25% of total to be paid upon signing of contract (2,125 USD) & remaining 75% (6,375 USD) upon submission of final report].

Additionally, DSA according to WHO rules will be provided during the full duration of in-country stay of the consultant.

Currency: USD

Work schedule (if applicable): 31 DAYS (28 August to 27 September 2023)