|Overview : |
A. Project Title
DevLIVE+ for Local Planning and SDG Monitoring (00125762/120035)
B. Project Description
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.
UNDP will be providing technical support on mapping available data solution and databases of Vigan City and recommend enhancements for possible system integration. The assistance will also be extended on demonstrating how the existing information from the LGU’s local database could be visualized using the DevLIVE+ dashboards, upon identification of integration points.
UNDP will also provide technical assistance at key stages of the implementation from data collection, validation to management, through training, mentoring and coaching. This intensive training design is adopted to instill the processes within the LGUs for future updating of their data, to ensure sustainability of the system and to promote common data among departments.
To achieve the aforesaid support to the local government of Vigan City, UNDP Philippines requires the services of a qualified Training Specialist with supervision from the Team Leader of UNDP’s Institutions and Partnerships (I&P) Programme Team.
C. Scope of Work and Outputs
The Individual Consultant shall perform the following:
- Mapping of the available data sets from Vigan City for integration to the DevLIVE+ data dashboard
- Conduct scoping of existing local data and databases that can be relevant for planning and programming, in coordination with Vigan City LGU and I&P Programme Team; and
- Collaborate with the DevLIVE+ System Developer on the suggested data or database that can be integrated to the data dashboard.
- Conduct trainings to target participants on the following activities:
- Community preparation and orientation of the local DevLIVE+ team and barangay leaders;
- Geotagging of survey elements for the GPS operators;
- Digital survey enumeration using the ODK-based DevLIVE+ mobile app for the local enumerators;
- Data navigation and analytics using the Qlik data platform of the DevLIVE+ for the local data validators and managers;
- Data cleansing for the local data validators and managers;
- Training of trainors for the community validation; and
- Orientation on SDG using the data dashboard, with UNDP I&P Programme Team as training focals.
- Conduct pre- and post-skills assessment and post training report on lessons learned with recommendations for improvement.
D. Timetable of Deliverables
The Consultant shall implement the following activities and/or deliver on the following outputs:
Deliverables / Outputs
Expected Level of Effort
Review and Approvals Required
Programme Analysts and
Team Leader, Institutions and Partnerships
- Training1: Training on geotagging
- Training2: Training on enumeration surveys
- Training3: Training on analytics and visualization
- Training4: Training of trainors for community validation
- Orientation on SDG dashboard
TOTAL ESTIMATED LEVEL OF EFFORT
The estimated levels of effort, which also includes preparation and actual training, identified above are indicative and may be adjusted based on the situation and needs, but with prior decision by UNDP. The existing training manuals and modules of the DevLIVE+ will be shared with the Consultant as a guide which he/she could modify for the actual training.
E. Governance and Accountability
Overall direction and guidance shall be provided by the UNDP Team Leader for Institutions and Partnerships while day-to-day supervision shall be performed by the UNDP Institutions and Partnerships Programme Analyst.
Though the Consultant’s outputs and deliverables shall be reviewed, quality assured, and accepted in consultation with the consortium or its key members, this contract is executed and managed under the operations policies and procedures of UNDP. The Institutions and Partnerships Programme Analyst shall formally accept outputs and cause the processing of payments.
F. Expected Duration of the Contract
The consultant will be hired for an estimated 87 person-days over 5 months. The target start of work date is 01 September 2020 and the maximum end date is 01 February 2021.
G. Duty Station
The consultant will be home-based, but is expected to conduct on-site training, coaching and mentoring activities in Vigan City following guidelines set by the local government units.
In light of the COVID-19 pandemic and declaration of State of Public Health Emergency in the Philippines, all work and travel of the Individual consultant shall be done within the guidelines and protocols set by the local and national government. Field work, trainings, meetings, and coordination shall be done in compliance with community quarantine policies.
H. Scope of Price Proposal and Schedule of Payment
- The Consultant should send the financial proposal based on a lump-sum amount for the delivery of the outputs identified in Section D. The total amount quoted shall include all costs components required to deliver the services identified above, including professional fees (daily fee X number of person-days) and any other applicable costs such as health insurance, Covid test results prior to the field work, training manuals and kits (for 80 participants), communications, transportation (5 round trips to Vigan City) and accommodation, etc.
- Medical/health insurance must be purchased by the individual at his/her own expense, and upon award of contract, the contractor must be ready to submit proof of insurance valid during contract duration.
- The contract price will be fixed output-based price. Any deviations from the output and timelines will be agreed upon between the Contractor and UNDP.
- Payments will be done upon satisfactory completion of the deliverables by target due dates. Outputs will be reviewed and certified by the Team Leader, I&P Team, UNDP prior to release of payments as follows:
Deliverables / Outputs
Expected Due Date
(% of Total Contract Amount)
05 September 2020
- Highlights of the community orientation
25 September 2020
05 October 2020
- Highlights of the trainings 1 and 2
05 December 2020
- Highlights of the trainings 3 and 4, including the post training report (pre- and post-skills assessment, lessons learned and recommendations).
15 January 2021
- 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
- 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
Qualifications of Successful Consultant and Criteria for Selection of the Best Offer
Only those who will obtain 70 out of 100 obtainable points will be considered qualified and shortlisted for the post.
Please make sure your CV indicates compliance with EACH of the following minimum criteria.
At least a University degree in community development, development communication, sociology, psychology, industrial psychology or closely related fields; preferably with a certification on information technology, internet and web management, or data science.
14 points for University degree in relevant field
Additional 3 points for additional degrees
Additional 3 points for relevant certifications
- At least eight (8) years of professional experience in the conduct of trainings on data collection and data visualization for local and national government units; previous experience with the UN or any international non-profit organization would be an advantage
28 points for 8 years experience in conducting trainings on data collection and visualization for local and national government units
Additional point for additional year in conducting relevant trainings
Additional 5 points for previous experience with the UN or international non-profit organization
- At least five (5) years of relevant experience on the use of mobile survey applications, preferably in Open Data Kit (ODK) collect
14 points for 5 years experience on mobile survey apps
Additional point per additional year
Additional 5 points for experience in ODK collect
- At least five (5) years of relevant experience on the use of business intelligence platform; preferably in QlikSense
14 points for 5 years experience on the use of business intelligence platform
Additional point per additional year
Additional 5 points for experience in QlikSense
- Minimum: fluency in spoken and written English.
pass / fail
Assessment of best offer will be via Combined Scoring method – where the qualifications will be weighed 70%, combined with the price offer which will be weighed 30%.
Recommended Presentation of the Offer
The Consultant shall be jointly selected and agreed upon by UNDP. The prospective Consultant(s) shall provide the following:
- Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP;
- 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; and
- Financial Proposal that indicates the all-inclusive fixed total contract price, supported by a breakdown of costs (see H. Scope of Price Proposal), 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.
Offerors must upload in one (1) file the aforementioned documents on the following link:
Templates for a) P11 Personal History Form and b) Offeror's Letter to UNDP Confirming Interest and Availability and Financial Proposal are available through the link below. UNDP General Terms and Conditions for Individual Contractors are also available:
Incomplete submission of required documents may result in disqualification.
Please see deadline of submissions above.
In view of the volume of applications UNDP receives, only shortlisted offerors will be notified.