Background

The Development through Local Indicators and Vulnerability Exposure Database (DevLIVE+) is a system and a tool that is used to collect, organize, visualize and manage baseline data and information on the household, building structures and production areas for monitoring access to and delivery of basic services, assessing vulnerabilities and exposures to hazards and risks, and creating development pathways toward sustainable and progressive communities. It was developed as an expansion of the Climate and Disaster Exposure Database (ClimEx.db) from the United Nations Development Programme, Australian Government, and Climate Change Commission’s Resilience and Preparedness toward Inclusive Development (RAPID) program which is focused as an exposure database.

 

The DevLIVE+ generates socio-demographic profiles, not only at the municipal or barangay level, but up to the household level. It also provides disaggregated data by sex, age, work, educational attainment, or spatial location through charts, lists or even map locations that would facilitate analysis in crafting the local land use and development plans. Considering that significant socio economic indicators can be captured related to access to basic services among others, local decision makers have found the tool essential in resource allocation, prioritization of barangays and delivery of services, or justify their programs, projects and activities using the DevLIVE+ to improve the conditions of  communities who are either most vulnerable, left behind, or lacking in access to government services.

 

Originally designed to assess risks and exposure of households to natural hazards, the DevLIVE+ was further enhanced and expanded to collect data on non-residential structures i.e. commercial, institutional and industrial, and agricultural production areas i.e. livestock, poultry and fishing which are significant information to the exposure database of an LGU. The DevLIVE+ is implemented for a detailed evaluation of potential risks in an automated manner, which would significantly enhance development of future local plans and programs.

 

Furthering its applications, localized Sustainable Development Goals (SDG) indicators i.e. poverty incidence, unemployment rate and presence of informal settlers among others could easily be monitored. Decision makers could now have a tangible data and statistics to further track and provide appropriate solutions to this SDG indicators. Because the system uses open source software, and data visualization tools, it is flexible enough to accommodate the needs and priorities of the local government units (LGUs) and agencies, by simply making adjustments in the data gathering tool, and writing the analytics.

 

This innovation requires an upgrade to the system to further expand the utility of the DevLIVE+. This engagement is expected to enhance the current DevLIVE+ indicators, field protocols and its accompanying manuals based on the following aspects:

i.    Alignment with the applicable requirements in formulating local land use and development plans;

ii.    Localization of the appropriate indicators of the Sustainable Development Goals;

iii.   Integration with relevant dashboards and databases from government agencies; and

iv.  Utility in local service delivery and monitoring.

The main outcome of the proposed intervention is the enhanced capacities of the local decision makers in crafting sound and data driven plans, policies and programs, in providing and prioritizing services to be offered, and in monitoring status and progress of local indicators, through an effective, accurate and reliable data collection and visualization tool. While there may be numerous factors that would significantly contribute to achieve the targeted outcome, this intervention will focus on the DevLIVE+ as a system that is implemented and sustained by a local government unit to further increase their decision-making skills.

 

This initiative will also contribute to the achievement of the Country Investment Facility – Leapfrogging Service Delivery’s objectives on prototyping innovative solutions to facilitate service delivery and in local planning as well as on the digital monitoring and mapping of localized SDG indictors.  

 

Institutional Arrangements

For the duration of the contract, the Consultant shall report to the UNDP Philippines Data Group through the Institutions and Partnerships (I&P) Outcome Team in the delivery of the terms of reference. Reporting is output-based and all deliverables must be submitted to UNDP-I&P. Similarly, the final outputs should be formally accepted by the Outcome Lead of I&P, UNDP Philippines before any payment is made.

 

It is expected that the Consultant shall inform UNDP-I&P of the schedule with government agencies, non-government organizations and local government units for the meetings and consultations.

 

Duration of Work, Duty Station, and Travel

To undertake the tasks, procedures, and expected outputs, the Consultant shall be engaged for 90 man-days for six months. This should also include a total of 15 man-days site visits (inclusive of travel time) for the Mindanao leg (covering the Mindanao State University – Iligan Institute of Technology in Lanao del Norte and 3 LGUs in Lanao del Sur) and Eastern Visayas leg (covering the 2 LGUs from each of the provinces of Leyte, Samar and Biliran) for the consultation with pilot users of the system. Effectivity of the engagement will be upon signing of the contract and will be valid until all outputs have been delivered and accepted. The target start-of-work date is December 16, 2019 and the expected completion date is June 15, 2020.

 

The position will be based in Manila to allow accessibility and availability for discussions and reporting on progress of activities as may be required by the UNDP. Though the consultant will not be required to report regularly at the Country Office, but shall agree with the UNDP I&P Outcome Lead on a regular schedule to report on status and provide feedback on the outputs.

 

Travel expenses during field works and monitoring visits as well as materials and related costs for the engagement shall be borne by the Consultant.

 

Scope of Price Proposal and Schedule of Payments

The Consultant should send a financial proposal based on a lump-sum amount for the delivery of the outputs identified below. The total amount quoted shall include all costs components required to deliver the goods and services identified above, including professional fees and any other applicable costs (i.e., transportation/travel to and from residence for meetings within Metro Manila, supplies and materials, communications, etc.) to be incurred by the Consultant in completing the assignment.

 

The contract price will be fixed output-based price. Any deviations from the outputs and timelines will need to be agreed upon between the Consultant and UNDP. Travel shall be included in the financial proposal.

Payments will be done upon satisfactory completion of the deliverables by target due dates. Outputs will be reviewed and certified by the Outcome Lead, I&P Team, UNDP prior to release of payments.

Deliverables

20% Upon submission and approval of a proposed workplan

20% Upon submission and acceptance of the initial SDG dashboard based on existing data sets;

30% Upon submission and acceptance of the enhanced DevLIVE+ mobile app;

10% Upon submission and acceptance of the final DevLIVE+ dashboard;

20% Upon submission Submission and acceptance of the draft user’s manual and documentation of updated schema and data dictionary.

 

Duties and Responsibilities

To achieve the above objectives, UNDP Philippines requires the services of a qualified System Developer for the following tasks, in coordination with the Subject Matter Expert and the UNDP Philippines Data Group led by the Institutions and Partnerships (I&P) Outcome Team:

  • Review the current system design and infrastructure of the DevLIVE+;
  • Participate in field meetings to document proof of concept (technical aspect) of the existing DevLIVE+ in selected LGUs in the Eastern Visayas and Lanao del Sur;
  • Develop the enhanced mobile application in an open source program i.e. ODK Collect or KoBo Collect;
  • Develop the enhanced desktop application in an open source program i.e. QlikSense, Tableau or Power BI;
  • Develop dashboards specific to monitoring of access to basic services, visualization of SDG indicators, risk assessments and planning options;
  • Update the IT infrastructure for the analytics portal;
  • Document the solution architecture and database schema;
  • Identify security guidelines and mechanisms for data sharing;
  • Provide inputs on the formulation of the training design and user’s manuals; and

Participate in collaboration meetings with other partners on the development and/or enhancement of other innovation tools.

Competencies

Corporate Competencies

  • Demonstrates integrity by modelling the UN mission, vision, values, and ethical standards
  • Displays cultural, gender, religion, race, nationality, and age sensitivity and adaptability
  • Promotes UNDP’s agenda in meetings

 

Other Competencies

  • Ability to work in close collaboration with a group of national and international experts, to meet strict deadlines and plan the work according to priorities;
  • Demonstrates capacity to plan, organize, and execute effectively;
  • Initiative, good analytical skills, mature judgment and ability to work under tight schedule while respecting deadlines achievement, ethics and honesty;
  • Ability to establish effective working relations in a diverse environment
  • Consistently approaches work with energy and a positive, constructive attitude;
  • Builds strong relationships with internal and external clients;
  • Demonstrated ability to function in a team environment and to deal with complex multi-stakeholder environment
  • Good ability to use information and communication technologies as tools and resources;

Excellent written communication and presentation/public speaking skills, focus on results, ability to interact productively in a teamwork environment

Required Skills and Experience

 

Offers will be evaluated based on combined scoring method :

  • Technical qualifications = 70%
  • Financial Proposal =    30%

 

For the evaluation of the Technical Proposal, the selection of the successful consultant must be based in the following qualifications (with the appropriate obtainable points):

 

Qualifications

Points Obtainable (100)

Education

  • Bachelor’s degree in Computer Science, Information Technology, Industrial Electronics Technology, or any related field

               20

Experience

 

  • At least 5 years of experience on developing and/or implementing the mobile survey tool using ODK, Kobo Collect or similar applications 

               30

  • At least 5 years of experience on developing and/or implementing the database using QlikSense Desktop, Tableau Desktop or similar applications

               30

  • At least 2 years working experience on programming and web server development

               20

TOTAL

              100

Applicants who will only receive 70 points  from the assessment of the CV will be qualified for the assessment of the Financial Proposal.

 

Recommended Presentation of Offer

Offerors must upload in one (1) file the documents below:

You may download the editable version of the Offeror's Letter to UNDP Confirming Insterest and Availability for the IC by clicking on this link: http://gofile.me/6xdJm/bE9TCw8fU

 

  1. Duly accomplished Offeror's Letter to UNDP Confirming Insterest and Availability for the IC that indicates the all-inclusive lumpsum contract price, supported by a breakdown of costs, as per template provided; If an Offeror is employed by an organization/company/institution, and he/she expects his/her employer to charge a management fee in the process of releasing him/her to UNDP under Reimbursable Loan Agreement (RLA), the Offeror must indicate at this point, and ensure that all such costs are duly incorporated in the financial proposal submitted to UNDP;
  2. Financial Proposal (Annex 2 of Offeror's Letter to UNDP Confirming Insterest and Availability)
  3. Personal CV or P11, indicating all past experience from similar projects, as well as the contact details (email and telephone number) of the Candidate and at least three (3) professional references;

 

In view of the volume of applications UNDP receives, only shortlisted offerors will be notified.