1. Introduction
University of Maryland School of Medicine (UMB) was established in 1807 and is the 5th oldest medical schools in the US. The School of Medicine (SOM) was the founding school of the University of Maryland. The programs in Kenya have been developed under the Institute of Human Virology, housed within the School of Medicine
UMB international programs are delivered through a global health office (Maryland Global Initiatives Corporation – MGIC) Programs in Kenya implemented through Maryland Global Initiatives Corporation (MGIC – Kenya).

2. PACT ENDELEZA Project Overview
The University of Maryland has been awarded a 5-year grant by PEPFAR through CDC, from 2016-2021, under the Partnership for Advanced Care and Treatment (PACT) Endeleza program for the Implementation and Expansion of High Quality HIV Prevention, Care and Treatment Services in Nairobi County. This program will facilitate the Nairobi Health Management Teams to implement comprehensive HIV prevention, care and treatment at 48 health facilities within the county.
The following are the broad objectives for the project:
1) Identify and enroll PLHIV through targeted HIV testing and linkage strategies, including for children, KP and priority populations
2) Provide comprehensive HIV care and treatment services and linkage to community based and OVC Programs
3) Identify HIV-infected pregnant and breastfeeding women and initiate HAART and follow-up of HEI
4) Strengthen quality assured laboratory systems for HIV diagnosis and monitoring tests while integrating biosafety and infection control practices
5) Support and strengthen data management including high quality documentation, reporting, analysis, dissemination, and use
6) Train, mentor, and provide supportive supervision to CHMTs and SCHMT on the delivery and management of high quality technical and operational HIV C&T services
7) Provide comprehensive clinical services to People who inject drugs

3. The consultancy
The consultancy is for the migration and update of IQCare EMR system for enhanced clinical decision support. At the end of the consultancy, the EMR should provide:
• the right information (evidence-based guidance, response to clinical need)
• to the right people (entire care team – including the patient)
• through the right channels (e.g., EHR, mobile device, reporting portal)
• in the right formats (e.g., order sets, flow-sheets, dashboards, patient lists)
• at the right times (for key decision or action)

4. Specific terms of reference
1) To migrate IQCare
2) To Update the system to include new forms and queries
3) To incorporate Google maps and Dashboards
4) To implement a Data warehouse

5. Scope of work of the consultant
The consultant will use different methodologies to facilitate appropriate migration and upgrade of the System. The consultant will undertake the following activities to inform the IQCare migration and update for enhanced clinical decision support.
1) Develop and an inception report that will outline the proposed methodology to undertake this assignment to achieve the specific terms of reference outlined above.
2) In consultation with UMB staff, migrate the current system to an updated and integrated system
3) Implement a data warehouse and assist the SI team to remotely connect to and upload backups/merged databases
4) Build and design of new data collection forms to be used in IQCare EMR system
5) Develop new IQTools queries to address reporting requirements of various donors and IQCare database systems
6) Programming of SQL queries for all new clinical reports requested by the Clinical lead team and local partners
7) Using google maps to identify defaulters by village and sub-county to enable deployment of counsellors to follow up. Ref. Figure 1: Defaulter List and HCW assigned
8) Develop Visual Dashboards for Analysis, Automate reporting from electronic medical records (EMR) to the Dashboards and District Health Information System (DHIS2) using a mobile device Focus on patient safety, usability and speed.

6. Deliverables for the consultancy
1) Inception report detailing the methodology to be employed in conducting the assignment to achieve the expected deliverables.
2) An integrated, updated iQCare system
3) Dashboards/Googlemap for reporting and analysis and to identify trends-link defaulter data to average distance travelled or time taken to reach the site
4) Improved data quality and use at the facility level
5) New IQTools queries to address reporting requirements of various donors

7. Requirements for the consultancy
1) Experience working with Patient Management and Monitoring Systems (PMMS)
2) Skilled in .NET (C# /VB.NET), Java, php, CSS 2.0, 3.0, LINQ, SSRS, Business Intelligence, Entity Framework, django, python, RapidSMS and ICD10 standards.
3) Experience in enhancement of IQCare EMR software/Biometrics
4) Have a good understanding of iQtools/MSSQL and complex query development
5) Demonstrated ability to transfer knowledge through formal and informal training.
6) Demonstrated ability to work in a team as well as independently
7) Excellent written and oral communication skills.
8) Experience working with and designing tools for health information data entry and reporting
9) Ability to trouble-shoot, manage crisis, and problem solving
8. UMB’s support for the assignment
The consultancy shall be managed by UMB. In addition, UMB will provide the following:
1) Documents of reference relevant to the assignment.
2) Logistical support to the consultant while undertaking the field visits.
3) Support in the review of the process and final deliverables of the consultancy in addition to ensuring quality assurance.
4) Pay for the consultancy upon full completion of the exercise and submission of the deliverables to UMB.
9. Duration of consultancy.

The maximum number of days allowable for the assignment shall not exceed twenty (20) days, and (in any case) the consultancy must be finalized on or before 16th December 2016. The consultant must be ready to start work immediately upon engagement and can be an individual or a firm. The consultant will see to it that staffing will be carried- out on an as-needed basis. However, the Consultant has the right to add or withdraw project resources at any moment in time during the project after approval of UMB.
10. Expression of interest
Consultants who meet the above requirements should submit their proposal that include the following:
1) A capability statement (not exceeding one page), including a firm commitment to be available to undertake the entire assignment.
2) An understanding and interpretation of the ToR including methodology to be used in undertaking the assignment.
3) Time and activity schedule.
4) A detailed financial proposal, including consultant’s fees. The financial proposal should include cost per major activity. Quote in Kenya Shillings
5) Updated Company Profile/curriculum vita that clearly spells out qualifications and experience.
6)Executive summaries of 2 reports of previous work conducted in relevant assignments.
7) Contacts of at least 2 organizations previously worked for.

HOW TO APPLY:
Submission of expression of interest.
Interested and qualified consultants should submit EOI by 31st October 2016 between 8.00am to 5.00pm by email to: procurement@mgickenya.org, containing the technical and financial proposals. Please indicate the consultancy you are applying for in the title of your email.
The proposals should be addressed to:
The Tender Committee,
University of Maryland Programs/Kenya
P.O. Box 495-00606
Wood, Avenue. Nairobi, Kenya
Appendix 1-Defaulter follow up
Figure 2:Defaulter List and HCW assigned