Full-Stack Web Developer for Database Programming and Web Development of a Functional Prototype of an Integrated Web-Based Monitoring and Evaluation Dashboard in support of the National Disaster Risk Reduction and Management Plan- For Philippine Nationals


Location : Manila, PHILIPPINES
Application Deadline :24-Jun-21 (Midnight New York, USA)
Type of Contract :Individual Contract
Post Level :National Consultant
Languages Required :
English  
Starting Date :
(date when the selected candidate is expected to start)
02-Aug-2021
Duration of Initial Contract :65 working days of combined effort spread over approximately 4.5 months
Expected Duration of Assignment :65 working days of combined effort spread over approximately 4.5 months

UNDP is committed to achieving workforce diversity in terms of gender, nationality and culture. Individuals from minority groups, indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the strictest confidence.

UNDP does not tolerate sexual exploitation and abuse, any kind of harassment, including sexual harassment, and discrimination. All selected candidates will, therefore, undergo rigorous reference and background checks.


Background

Full-Stack Web Developer for Database Programming and Web Development of a Functional Prototype of an Integrated Web-Based Monitoring and Evaluation Dashboard in support of the National Disaster Risk Reduction and Management Plan (2020-2030)

Project Name: Recovery and Resilience-building in the Philippines

Project Description:

The recent review of the National Disaster Risk Reduction and Management Plan (NDRRMP) emphasized the “importance of institutionalizing feedback and reporting mechanisms to gauge the performance progress and gaps vis-à-vis the various targets identified in the plan.” The updated NDRRMP is a long-term plan that shall encompass political terms and administrations at the national and sub-national levels and would need to be “periodically reviewed regarding its relevance and impact on the changing realities locally, nationally and globally.

Given the lack of a results-based and harmonized Monitoring and Evaluation (M&E) System that links local and national outputs and outcomes, the review recommends developing an M&E system that will track the progress of implementing planned outputs and monitor progress towards the intended outputs and outcomes outlined by the NDRRMP. The review also called for the government to allocate funds for the development, mainstreaming, and implementation of an M&E system at all levels.

In coordination with the Office of Civil Defense (OCD), UNDP is currently developing a results-based M&E Framework and Plan that demonstrates accountability and transparency, ensures that tangible outcomes or outputs are achieved timely and efficiently, and promotes the achievement of program results. This M&E Framework and Plan shall engage the whole of government – at the national and local levels – to develop a culture of continuous improvement, data-driven decision-making and planning, and leveraging lessons learning from the plan implementation.

With the amount and complexity of data streams from various stakeholders, the need for digital infrastructures and virtual applications to support the implementation, monitoring, and evaluation of the NDDRRMP cannot be understated. To enable the practical delivery of the NDRRMP at all relevant levels and critical sectors of the government, UNDP is also currently undertaking a technical needs assessment (TNA) of users, stakeholders, and organizations in terms of their current capacity, mechanisms, and requirements for a web-based M&E dashboard that shall support the attainment of the NDRRMP. The TNA shall provide the critical benchmark for the development of the functional prototype for an integrated web-based M&E dashboard, with a combination of operational, analytical, and strategic functionalities.

To this end, UNDP is looking to engage with a Full-Stack Web Developer, who will design the functional prototype, including front-end and back-end development, of the mentioned integrated web-based M&E dashboard, which shall streamline key functions such as reporting, updating, collation, storage, presentation, and generation of DRR-related data from local stakeholders and key government agencies to the OCD. The Developer shall ensure that critical digital functions such as user credentials, data storage, accessibility, security, analytics, quality control and assurance, user experience (UX) design, overall system sustainability, and the likes are considered in developing the dashboard.


Duties and Responsibilities

Objectives:

This assignment aims to achieve the following objectives, which are defined further under the TOR’s Scope of Work:

  1. To enable the government to regularly, effectively, and efficiently track the progress of the NDRRMP implementation across all levels of government and different sectors through an integrated web-based M&E dashboard;
  2. To design both front-end and back-end development, leading to a functional prototype of the integrated web-based M&E dashboard, which streamlines the collection, storage, presentation, and generation of DRR-related data from both manual data uploads and from relevant databases through interoperability solutions;
  3. To support the generation and presentation of data analytics, insights, and trends that can facilitate the implementation and assessment of the NDRRMP in achieving envisioned thematic outcomes;
  4. To provide timely and evidence-based results that will enable effective and efficient implementation of changes and adjustments on activities to reach target outcomes/outputs of the NDRRMP.

 

Scope of Work

The Full-Stack Web Developer is expected to design a functional prototype, with both front-end and back-end programming, of an integrated web-based M&E dashboard that streamlines the collection, storage, presentation, and generation of DRR-data across the DRR government stakeholders at all levels. More specifically, the Developer is expected to perform and deliver the following:

  1. Coordinate with UNDP’s Consultant conducting the Technical Needs Assessment (TNA) of users, stakeholders, and organizations regarding their current capacity, mechanisms, and requirements for a web-based M&E dashboard that shall support the attainment of the NDRRMP. The Developer shall appropriately apply the key technical and institutional recommendations and findings of the TNA report, which will be produced by the TNA Consultant.
  2. Use the TNA report and digital mockup (to be provided by the same TNA Consultant) to initiate the development of the front-end and back-end development of the platform.

Front-end Development:

  1. Select an appropriate open-source dashboard that fully meets the specifications stated in the TNA and the stakeholders' required language and frameworks. The selected platform must be customizable, fully in compliance with the TNA specifications, and can be scaled into a full-fledged and functional integrated web-based M&E dashboard of the national government/OCD.
  2. Design the user-facing interface of the web-based M&E dashboard. The interface shall include, but is not limited to, the following minimum subpages:
    • About – describes the rationale, use cases, and stakeholders involved in developing the M&E dashboard in relation to the NDRRMP.
    • Monitoring and Evaluation – brings users to a log-in page where LGUs or the national government can report, transmit, retrieve, and store DRR data in relation to the objectives, outcomes, and activities of the NDRRMP. Access to this subpage shall change depending on the user type (e.g., LGU, national government). The specific categories that capture respective NDRRMP outcomes and indicators (which LGUs report on) shall be defined and specified during stakeholder consultations.
    • Analysis – allows users to access and download data analytics based on currently uploaded data from stakeholders and other relevant databases.
    • References – embeds links to relevant resources and references (e.g., national government webpages, etc.).
    • Contact Us – includes information on how to contact focal points for data requests, validation, etc.
  3. Design and develop additional modalities for the front-end interface for public viewing and feedback.
  4. Enable corresponding sample user access/credential functions for various user types, e.g., LGU, OCD, etc. Ensure the appropriate type of access is granted to the right user.
  5. Deliver a live demonstration of system features/capabilities during regular meetings with UNDP CO and local and national government representatives. Ensure that the interface results in positive user interaction and usability.
  6. Note that the system to be developed must be web-based, accessible via web browser, and is preferably built on open-source applications (latest versions) and a compatible SQL-based database platform.

Back-end Development:

  1. Enable the two streams of data upload namely (i) manual uploading into the dashboard from users and agencies with limited database capacity, and (ii) data transfer from other relevant government databases, ensuring interoperability solutions by covering ETL functions and APIs integration with existing databases.
  2. Ensure effective integration of the front-end code, (i.e., every functionality of the dashboard works and performs it in the most efficient and fastest way possible).
  3. Integrate code to automate specific functions such as notifications for new users, maintenance tasks, etc.
  4. Ensure robust database security features for data submitted, reported, and uploaded into the dashboard.
  5. Streamline the process of accessing data sets from the dashboard so that the website loads as fast as possible and its functionality is carried out as quickly as possible.

 

Approach and Methodology

An Individual Consultant (IC) will be engaged to perform assigned activities and deliver outputs outlined in this TOR. Through the submission of an inception report, the selected Consultant must describe how he/she will provide the activities and outputs outlined in this TOR; providing a detailed work plan including timelines, activities, outputs, list of stakeholders, data collection methodology appropriate to the work context, reporting condition, and quality assurance mechanism. The IC may have his or her support team to deliver the outputs of this project.

 

Expected Outputs and Deliverables

Deliverables/Outputs

Estimated Duration to Complete

Target Due Dates

Name/s and email of the designated person who will review and accept output

Starting Date:

August 2, 2021

15% Work Plan, covering but not limited to the following:

  • Summary of functional requirements and stakeholder mapping based on the TNA document
  • Product backlog cover scrum of user stories/features
  • Prioritization of implementation sprints and test plans.
  • Dashboard release plan/timeline
  • Communication plan
  • Risk/issue register

5 working days

August 9, 2021

UNDP Country Office (CO) Climate Action Programme Team (CAPT) Team Leader

15% Solution Architecture and Mockups covering:

  • Front- and back-end wireframes
  • Database schema
  • Description of APIs for data integration and related services
  • Color scheme and other design features
  • Updated risk/issue register

15 working days

August 27, 2021

UNDP Country Office (CO) Climate Action Programme Team (CAPT) Team Leader

20% Alpha Release featuring:

  • 35% of implementation sprints completed
  • Test and UX reports
  • Updated product backlog
  • Updated risk/issue register

15 working days

September 17, 2021

UNDP Country Office (CO) Climate Action Programme Team (CAPT) Team Leader

20% Beta Release featuring:

  • 70% of implementation sprints completed
  • Test and UX reports
  • Updated product backlog
  • Updated risk/issue register

15 working days

October 08, 2021

UNDP Country Office (CO) Climate Action Programme Team (CAPT) Team Leader

30% Full Release featuring

  • 100% functional prototype
  • Test and UX reports ensuring bug-free product
  • Technical manual covering detailed product description, APIs, final database design, code, etc.
  • End-User tutorial
  • End-User training
  • Project closure report addressing plans for scaling up the prototype into a production environment and addressing any implementation concerns such as security, backups, disaster management, etc.  

15 working days

October 29, 2021

UNDP Country Office (CO) Climate Action Programme Team (CAPT) Team Leader

Total Working Days

65 working days

 

 

 

Institutional Arrangement

  1. The Developer’s activities will be coordinated, monitored, and assessed for completion by the UNDP CO CAPT Team Leader and the Recovery and Resilience-building Project Manager (RR PM) from UNDP CO.
  2. The Resilience-building Project Manager (RR PM) from UNDP CO will supervise the Consultant.
  3. The CO will organize a TWG to review submitted Outputs/Reports.
  4. All outputs in this TOR will be submitted to the UNDP CO CAPT Team Leader RR PM and discussions/ presentations to the TWG may be scheduled.
  5. A final version of the output with implemented revisions from comments and suggestions of the TWG will be submitted and an acceptance letter will be issued to the contractors
  6. The Consultant is responsible for liaising and setting up meetings and stakeholder consultations with national agencies, communities, local government units, NGOs, and other identified stakeholders. The CO may provide key persons to contact in selected organizations.

 

Facilities to be provided by UNDP

  1. Due to the ongoing COVID 19 pandemic and the restrictions in place for meetings and gatherings, meetings will be done using online applications.
  2. The Consultant is expected to use his/her computer and communication equipment and other resources that are required and may be needed to conduct activities in this TOR

 

Expected Duration of Contract

  1. It is estimated that the work shall involve a total of 65 working days of combined effort spread over approximately 4.5 months including a period for output reviews and approvals.
  2. The UNDP CO and TWG members will review and give comments on outputs maximum of four (4) working days

 

Duty Station

  1. The duty station is in Metro Manila.
  2. The engagement may be home-based and for accessibility and availability to allow for discussions and reporting on the progress of activities regular online meetings shall be conducted.
  3. The majority of activities will be done in Metro Manila.
  4. Considering the COVID-19 pandemic and declaration of State of Public Health Emergency in the Philippines, all work and travel of the Contractors shall be done within the guidelines and protocols set by the local and national government.
  5. The Consultant will not be required to report to the office regularly but a status report on the outputs shall be expected monthly.


Competencies

Competencies

  • Must have strong leadership and project management skills;
  • Strong proficiency in various programming languages, including but not limited to Ruby, HTML, CSS, and JavaScript
  • Advanced understanding of SQL, advanced algorithms, UI/UX design principles, and web platforms management
  • A keen eye for details;
  • Excellent analytic skills, especially in understanding complex information and managing multiple data sets

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;
  • The 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 a 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

Qualification of the Successful Individual Contractor

The successful IC should meet the following minimum qualification:

Education

A Bachelor’s degree in Computer Science, Computer Engineering, Information Technology, Economics, Statistics, Industrial Engineering, or other relevant fields.

Experience

  • Must have at least six (6) years of experience developing digital platforms for monitoring and evaluation/ and or development program purposes
  • Minimum of two (2) completed projects on digital M&E systems, platforms, dashboards, or any similar solutions

Language

  • Proficiency in English

Scope of Price Proposal and Schedule of Payments

  • The agreed and final contract price is a fixed output-based price regardless of an extension of the project or changes in cost components.
  • Final acceptance and approval of Outputs is required for processing and releasing each payment

 

Criteria for Selection of Best Offeror

Offerors will be evaluated based on a combined scoring method wherein qualifications of the candidate will be weighted a maximum of seventy percent (70%) then combined with the submitted financial proposal which will be weighted a maximum of thirty percent (30%).

The technical proposal will have a total of 100 points and shall include the following documents:

The technical proposal shall be evaluated based on the following criteria:

Allocation Points

1. Background/experience of Individual per submitted CV/ P11

60 points

2. At least two final/published version of similar digital solutions will be required for submission to provide UNDP an idea of how the prospective IC will package the expected outputs (only two submissions will be evaluated at a maximum of 20 points each). The applicant can give links to his/her finished work.

40 points

TOTAL

100 points

The CV / P11 shall be evaluated based on the following criteria:

Qualifications

Points Obtainable

(60 points)

Education

A Bachelor’s degree in Computer Science, Computer Engineering, Information Technology, Economics, Statistics, Industrial Engineering, or other relevant fields

 

(Minimum 14 points for bachelor’s degree, additional two points for additional degree, maximum of 20 points)

20 points

Experience

Must have at least six (6) years of experience developing digital platforms for monitoring and evaluation/ and or development program purposes

 

(Minimum fourteen (14) points for six (6) years’ experience, additional two points for any additional year, maximum of twenty (20) points)

20 points

 

Minimum of two (2) completed projects on digital M&E systems, platforms, dashboards, or any similar solutions

 

(Minimum fourteen (14) points for two (2) completed projects, additional two points for additional projects, maximum of twenty (20)

points)

20 points

TOTAL

60 points

Only candidates with a minimum of 70 points from the overall evaluation of Technical Proposal that includes CV and submission of two (2) similar digital solutions will be eligible for review of financial proposals.

Recommended Presentation of Offer

The financial proposal should indicate both breakdown and total costs of the engagement. It should be all-inclusive covering professional fees (including those of his/her support team), and other related administrative-logistical expenses.

Interested parties are required to submit the following:

  1. Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP;
  2. Personal CV (using template of UNDP), indicating work history as well as competencies related to this engagement, contact details of the proponent and at least three (3) professional references; and,
  3. Financial Proposal that indicates the all-inclusive lump-sum amount commensurate to the scope of work, 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.
  4. Submission of two (2) similar digital solutions

 

Offerors must upload in one (1) file the aforementioned documents.

Templates for a) P11 Personal History Form and b)  Offeror's Letter to UNDP Confirming Interest and Availability and Financial Proposal (Annex 2) are available through the link below. UNDP General Terms and Conditions for Individual Contractors  are also available: http://gofile.me/6xdJm/bE9TCw8fU

Incomplete submission of required documents may result in disqualification.

Please see the deadline of submissions above.

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



If you are experiencing difficulties with online job applications, please contact the eRecruit Helpdesk.

© 2016 United Nations Development Programme