Purpose of the Assignment:Plan International Nigeria is implementing the Global Affairs Canada funded Bauchi Opportunities for Responsive Neonatal and maternal health (BORN) project and Strengthening Health Outcomes for Women and children (SHOW) project in Sokoto state with support from Plan International Canada. The projects seek to contribute to the reduction of maternal and child mortality in targeted regions.As part of the processes for ensuring realization of its outcomes, the projects in partnership with the State Ministry of Health and other stakeholders, plans to contribute to the efficiency and effectiveness of human resource for health. One of the key factors militating against the effectiveness of human resources for health in the state is lack of data on number and cadre of trained health workers and other stakeholders such as community volunteers, traditional and religious leaders, resulting in duplication of similar training for same persons to the detriment of other untrained health workers. The absence of this centralized database affects planning for HRH strengthening by the State Ministry of Health, donors, implementing partners and other stakeholders. Currently WHO is implementing a five years Project on human resource for health in Bauchi state (funded by Global Affairs Canada) that has developed a Human Resource for Health Information System in Bauchi state. However, the database does not have the design to capture the data from numerous trainings that has been done in the state. Hence there is need to update the database with some key variables to suit the current need to accommodate all health sector trainings in the state using the same platform where possible or another platform as appropriate and acceptable to theState Ministries of Health in Bauchi and Sokoto.The objectives of this consultancy are to:Engage the Federal, Ministry of Health, Sokoto and Bauchi state Ministries of Health on the format and design of the training databaseWhere agreed, create a standardized and secure highly gender responsive training data sets that will fit to the current infrastructure and capacity requirements of the WHO HRHIS database, based on pre-determined indicators and reporting requirements of Bauchi and Sokoto state ministry of health for the purposes of online and readily accessible data storage, preservation, analysis/queries, visualization, and transfer/sharing. Where this is not possible, will utilise an open source program to create the training dataset.The training database will have an SMS feature that will enable the administrators send targeted messages to different categories of persons within the database.Develop standardized procedures and protocols to maintain the database by the State Ministries of HealthSupport Plan-International and MOH staff in developing needed competencies for using and maintaining the database.Train and transfer the required knowledge to MOH, SPHDA, and Plan-International database teams in the source code programming language to allow them to make further improvements or changes to the system.Under the guidance of the National Program managers and the direct supervision by Directors for Planning Research Statistics, the database developer will be responsible for the overall maintenance of the database, Communication and troubleshooting Access. The consultant will undertake necessary steps to ensure no damage to the WHO HRHIS database where this is the preferred platform by the States from amendments made to incorporate the training database.METHODOLOGYDevelop a written plan for the development and or upgrade of a database specific to the needs of the Sokoto and Bauchi State Ministry of Health, and other stakeholders as well as uploading and cleaning procedures. The database must be readily accessible online with the adequate security and access protocols and potential to be linked to the National Health Management Information System through open source coding.The plan must show how the consultant or firm will engage with relevant stakeholders in the development of the database.Issues to determine include:
What database platform will be used?
What data and metadata standards will be employed?
What procedures will be used to ensure quality (accuracy, integrity, completeness)?
How will data storage and preservation be handled?
How will data security management (access, erasure, security, privacy) be ensured?
How will long-term access be ensured?
What procedures will be used to upload/transfer/share data?
Standard operating procedures manual. The consultant will develop a standard operatingprocedures manual that will include but not be limited to an explanation on how:
data are entered
to use the data cleaning program
to download data to Micro softs Windows
to aggregate data from different time periods (Training organisations)
to aggregate data across different type of cadre of staffs/area of expertise
to transfer/sharing of data (e.g. via web, mobile devices and SMS)?
to store and freeze data
to protect data.
Capacity building and knowledge transferThe training methodology will includes capacity building and mentoring from the beginning to the end of the process to ensure transfer of adequate knowledge, skills and expertise by the end of the contract period, in order for the State Ministry of Health, Plan International Nigeria staff and relevant stakeholders to have relevant competences to update and manage the database including making source code amendments to change design.Deliverables, Time Frame and Level of EffortThe proposed methodology should clearly state the level of efforts required, duration to complete assignment within the minimum allowable time, and complete costs.2. Activities and OutputsDeliverables
Report of planning meeting with relevant
stakeholders
Submission of agreed timelines/tasks to
develop training database
Development of an online database
including piloting
Development of standard operating
procedures manual
Maintenance of database
Testing of database and training/ mentoring
of MOH,SPHDA, Plan-international staff
(MDAs WHO HRHIS Desk officers )
Support to roll out of the training database
Recommendations and final Detail report
summation
TimelinesMajor activities Timelines (by week)Discussion with Plan international Nigeria staff 4 th September 2017Planning meeting with Stakeholders in Bauchi 6 th – 8 th September2017Planning meeting with Stakeholders in Sokoto 12 th – 14 th September2017Submission of report including preliminary draft concept for online database for discussion and finalization18 th September 2017Development of online training database including piloting 20 th September to 3 rdOctober 2017Development of Standard operating manual 9 th to 12 th October2012Training of Plan International Nigeria and Bauchi stakeholders on database application16 th to 20 st October2017Training of Plan International Nigeria and Sokoto stakeholders on database application23 rd to 30 th October2017On site Mentoring support to the roll out in Bauchi and Sokoto states 6th to 17 th November2017Maintenance of database, including troubleshooting and off site support to use and maintenance of training database by state users and system maintenance.20 th November to 14 thDecember 2017Submission and finalization of final report and recommendation (all other documents to follow within stipulated days in the contract)18 th to 21 st December2017Qualifications of Consultant (firms(s)1. Key skills and experience required:
The consultant/firm should have the following skills and qualifications:
Demonstration of relevant expertise in a relevant field (computer science, data/information management, econometrics, advanced statistical analysis, information technology, software engineering).
Minimum 5 years’ experience related to data management/database development and archiving, including use of web-enabled platforms and common statistical analysis tools
Prior experience with data management of data sets from developing countries is highly desirable.
Excellent communication and writing skills
Prior experience within Global Affairs Canada or the United Nations system is desirable.
Application Package and ProceduresA completed application should contain the following:2. Names and contact information of three references who can be contacted regarding relevantexperience.3. A copy of a previous report of a similar nature undertaken in the area of online databasedevelopment and managementThe proposal will be scored on both technical and financial aspects weighted at 70% and 30%respectively.Complete applications should be submitted electronically to: Nigeria.consultant@Plan-international.org
Apply via :
Nigeria.consultant@Plan-international.org