Local Consultant with Clinton Health Access Initiative

BTDC-ID: 5683

Closing Date: 18-Sep-2020

Local Consultant

Contact Name

Clinton Health Access Initiative - CHAI

Email

cambodiaoffice@clintonhealthaccess.org

Website

clintonhealthaccess.org

Announcement Description

The Clinton Health Access Initiative, Inc. (CHAI) is a global health organization committed to saving lives and reducing the burden of disease in low-and middle-income countries, while strengthening the capabilities of governments and the private sector in those countries to create and sustain high-quality health systems that can succeed without our assistance.

Local Consultant Apply Now

Category: Consultancy, Research / Development, Advisory
Type : Job Opportunity
Location: Phnom Penh
Schedule: Short-term
Salary: N/A

Scope of Work

Contractor will report to CHAI Program Manager (PM), Sivantha Hul, for the duration of this Agreement, with day-to-day tasks assigned by CHAI Senior Associate, Stanton Hor, and CHAI technical advisor, Emi Okamoto.

Project Goals:

CHAI is supporting the National Center for HIV/AIDS, Dermatology, and STDs (NCHADS) to improve the quality of care for HIV patients and improve ARV monitoring system.

Contractor Deliverable

The contractor will be asked to develop the excel-based dashboard which serves as the ARV monitoring tool, and provide an orientation on the manual to the end users (NCHADS and CHAI).

Timeframes: by 30 November 2020

Duties

Data Sources
LMU R & R ART site form
LMU ARV quarterly distribution plan
LMU Adult patients recorded from ART sites
LMU Pediatric patients recorded from ART sites
LMU ARV stock-on-hand recorded from ART sites
LMU ARV consumption recorded from ART sites
LMU pediatric weightband data.
Specific tasks:
Dashboard development: Dashboard should be able to receive inputs of data (R & R form) from ART sites which provide consumption, stock-on-hand and patient data. The dashboard should have the capability to explain and represent the outputs in a months-of-stock format for ease of viewing. Representing an ART site and ARV formulation stock status.
Dashboard should also contain the flexibility to account for introductions of new ARV formulations and especially ARV transitions.
Patient data: Each R & R form contains patient data which should also be consolidated from all 69 ART sites and represented in a summarized format.
Although the development of the dashboard can be done using any preferred software by the consultant. The preference is to use Microsoft Excel given the limited computer literacy of NCHADS staff who would be managing the tool going forward.
The prototype presentation to LMU staff should involve demonstrating the inputs from the R & R form and the calculated outputs for display. LMU staff can then determine how much stock to distribute to the sites. A final version of the Site level dashboard should completed by the stipulated deadline mentioned in deliverable D
On-going support will be required by LMU staff to ensure complete understanding and utilization of the dashboard.