Consultant (#VN033) (WHO and RTSL)

1. Background

To have good system for reporting on NCD management, MOH got support from the WHO to develop the Online NCD Reporting (ONR) system based on DHIS2 in 2021. This system went to operation since middle of July 2021. As of May 2023, there are nearly 3.500 commune health stations (CHSs) in 55 provinces using the software to generate real-time report on NCD management. Data on NCD management have been automatically transferred from the ONR into the national health statistics software to reduce the workload for health workers.

In 2022, the WHO signed contract with the Health Information System Program Viet Nam (HISP) to developed indicators requested by WHO and the Resolve To Save Live (RTSL)- the donor for hypertension management in Viet Nam. Most of these indicators need cumulative data so that Structured Query Language (SQL) hook had to use for the purpose. As a result, the data download very fast compared to traditional one and this is very convenient for users. However, one of the disadvantages is that the dashboards to monitor the progress of these indicators are unable to create by users but the professionals. Furthermore, this year WHO has been supporting for quality improvement of hypertension management at commune health stations (CHSs). The support will focus on all CHSs of a district in 8 provinces. Monitoring progress in these CHSs using ONR is critical. Therefore, disaggregated report in ONR into focused CHSs and remaining CHSs so that health authorities at provincial, regional and national level can follow is needed. In order to making the ONR more convenient for users, we would like to seek consultant(s) to

add key indicators requested by MOH to the report using SQL hook
create dashboards for indicators requested by the WHO and the RTSL
develop disaggregated report in ONR into focused CHSs and remaining CHSs so that health authorities at provincial, regional and national level can follow
provide technical support for users nationwide to reach more and more commune health stations.

2. Planned timelines

Start date: 15 July 2023
End date: 31 Dec 2023

3. Work to be performed

The contractor in close collaboration with the WHO technical team to perform the following key actions:

Activity 1: Create additional key indicators requested by MOH to the report using SQL hook.

The key indicators include:

Total number of CHSs (for each district, province and nationwide)
Percentage of CHSs reported.
Total patients detected (cumulative)
Percentage of cumulative detected patients compared to estimated number of patients.
Newly detected patients
Patients visited this month
- Number of patients visited this month with blood pressure control (new standard)
- Number of patients visited this month with blood pressure control (new standard).
- Number of patients visited last 3 months with blood pressure control (new standard).

Activity 2: Edit custom reports.

Edit the custom reports disaggregated by Focused CHSs and Remaining CHSs (G1 and G2) to evaluate the effectiveness of the program of quality improvement of hypertension/diabetes management at CHS, includes:

Edit custom report disaggregated by G1 and G2 until provincial level

Activity 3: Develop dashboards for indicator requested by WHO and the RTSL.

Develop dashboard to provide a visual representation of key indicators requested by WHO and the RTSL in a concise and easily understandable format, which support for monitoring performance and decision-making. Main activities include:

Requirements Analysis
Dashboard interface design
Develop charts and tables
Decentralize and deploy the dashboard

Activity 4: Provide technical support for users nationwide.

Support for users: To provide online support for users nationwide in applying the NCD software:

Support for reporting and statistics of NCD.
Create or update information, lock user accounts, decentralize user rights according to regulations.
Receive, check and support for the requests for instructions on using functions on the software or checking data.
Perform data control and reconciliation according to available/existing tools and solutions.
Verify problems and fix errors arising in the course of using software.

System administration assistance: Technical support/assistance for maintain the system

Support connection, data transfer/integration.
Check the software's activity log.
Check the service status on the server of operating system.
Backup database, periodical source code, check the integrity of databases after backup.
Check the performance and load capacity of the software.
Check and update patches, patches for information security vulnerabilities for operating systems, database management systems, web servers (webservers), ... and the components of the software system

Deliverables

Report using SQL hood with new indicators and disaggregated into focused CHSs and remaining CHSs.
Dashboard for indicators requested by the WHO and the RTSL.

4. Specific requirements

The requirements of the consultancy team members:

At least 5 years’ experience in design and maintenance of database using DHIS2 platform.
Experience in supporting users of health facilities nationwide for using a software.
Directly involved in development of the Online NCD Reporting system is an advantage