View Notice

System Developer for PDNA Computer Application Tools (For Filipino Nationals Only)
Procurement Process :IC - Individual contractor
Office :UNDP Country Office - PHILIPPINES
Deadline :10-Jul-18
Posted on :03-Jul-18
Development Area :CONSULTANTS  CONSULTANTS
Reference Number :47707
Link to Atlas Project :
00065172 - Enabling Regions X and XI to Cope with Climate Change
Documents :
Terms of Reference
Financial Proposal Template
P11 Form
IC-TErms & Conditions
Overview :

Project Title

Project Climate Twin Phoenix – Resilience and Preparedness towards Inclusive Development (PCTP-RAPID)

 

Project Description

The Resilience and Preparedness toward Inclusive Development (RAPID) Program is an expansion of the Project Climate Twin Phoenix (PCTP) that was implemented in response to the impacts of Tropical Storm Washi and Typhoon Bopha that devastated many areas in Region 10 and 11, particularly Cagayan de Oro City, Iligan City, Compostela Valley and Davao Oriental. The RAPID program, on the other hand, is a capacity development program in support of the long-term recovery of Local Government Units (LGUs) and communities in Yolanda-affected areas, namely municipalities located along the coastline of San Pedro Bay and Leyte Gulf which are: Tacloban City, Palo, Tanauan, Tolosa, Mayorga, MacArthur, Dulag and Abuyog in Leyte, Basey and Marabut in Samar, and Lawaan and Balangiga in Eastern Samar. The Program commenced its implementation in 2014 and was expected to be completed by the end of 2017. The Program has been extended to be completed by end of 2018. It is implemented by the United Nations Development Programme (UNDP) in the Philippines, through its Project Management Unit (PMU), in partnership with the Australian Government through its Department of Foreign Affairs and Trade (DFAT).

The Program has seven project outputs and these are as follows:

Output 1: Climate/Disaster Risk and Vulnerability Assessment

Output 2: Priority Preparedness and Mitigation Actions

Output 3: Awareness Raising and Capacity Building

Output 4: Mainstreaming Climate/Disaster Risk in Land Use and Development Plans

Output 5: Building Resilience of the Poor and Vulnerable

Output 6: Knowledge and Information Sharing

Output 7: Community-Based Disaster Risk Reduction and Management

 

During the extension period, two new policy-oriented activities, the Public Financial Performance Management Review of DRR/CCA and the Review of Post Disaster Needs Assessment Methodology have been added under Output 4, as part of the policy formulation and intervention component of the RAPID Program. Likewise, the integration of the ClimEx.Db or the climate exposure database development into a national system will also be attempted.

In relation to PDNA, the experience from Yolanda and other major disasters after that has showed a significant delay of completing the conduct of the PDNA that would support a timely and complete rehabilitation and recovery plan thereby prolonging the sufferings of those affected. In most cases, the main factor that hinders the timely delivery of PDNA is the absence of baseline data. It takes a substantial amount of time for the interdisciplinary/sectoral PDNA Teams just to gather the baseline data, thus giving them a hard time to assess the cost of damages. The Guidelines being used and followed by the National Disaster Risk Reduction and Management Council (NDRRMC) and the Office of Civil Defense (OCD) in conducting PDNA is the one developed by the World Bank, European Commission and the UN Development Group. In consultation with OCD focal officers, the guidelines per se is not the problem, in fact it is very comprehensive and can easily be followed. In addition to difficulties in getting data sets for damages and losses, there is no accurate baseline information at the LGU level. What is lacking is an electronic/computer-based tool that would assist PDNA teams to access electronic information from databases and record information gathered from the field. Therefore, the RAPID Program intervention for enhancement of PDNA Tool and Methodology is the development of anIT-based system to support and dedicated for the conduct of PDNA and compatible and/or inter-operable with ClimEx.Db (exposure database) to serve as source of baseline information.

To ensure that the technology-based data gathering tools to be developed will be adopted by the NDRRMC, OCD primarily, and other concerned agencies that form part of the PDNA Teams, will be consulted in the process. Upon the development of the system, it will be presented to the Technical Management Group of NDRRMC and the Council itself for acceptability and adoption, and a corresponding capacity building activity to utilize and administer the system in the conduct of the PDNA.

 

Objectives and Scope of Work of the Development of the IT-enabled Post Disaster Needs Assessment Tool and Its Methodology

The main objective of the Development of the IT-enabled Post Disaster Needs Assessment (PDNA) and Its Methodology is to ensure availability of an updated local dataset from the local communities in a timely manner to assist and hasten the conduct of PDNA activities.

Objective 1. Prepare the ClimEx.Db platform for adoption and roll out. Exposure data base and use of a technology-based data gathering tools for PDNA recording of information will be automated as well as processing the datasets gathered to significantly reduce the time required to complete the PDNA process.

Objective 2. Creation of IT-based PDNA tools which will comprise the following: 1) Mobile/Web-based Survey Application to gather data; 2) Desktop Application to process, extract, and visualize data locally; and 3) Data Server to receive and store all the gathered and submitted/transmitted data.

Objective 3. Assist in developing the capacity of the implementing partner to implement and manage the Survey Application, Desktop Application and Data Server and to develop and initialize a sustainability plan.

 

Scope of Work of the Consultant

To achieve the above objectives, UNDP will need the services of a qualified System Developer to develop the computer-based PDNA Application Tools under the RAPID Program. In close consultation and partnership with OCD, specifically from the Rehabilitation and Recovery Management Services (RRMS), the System Developer will generally follow the processes/phases of Systems Development Life Cycle (SDLC) of the IT-based PDNA Tools, namely:

 

  • Planning – To define the product scope, project deliverables, acceptance criteria, resources, schedule, cost, and identification of the different stakeholders of the project.
  • Systems analysis & requirements – To conduct elicitation process where the team will gather the functional and non-functional requirements of the system. To analyze the needs of the end-users and to ensure that the system will meet the expectations of the stakeholders.
  • Systems Design - To formulate the conceptual and logical design of the PDNA IT-based tools (prototyping); to translate specification into functional and non-functional features to look at interoperability of the system with existing database such as the ClimEx.Db, CBMS (Community-Based Monitoring System) of DILG and REDAS (Rapid Earthquake Damage Assessment System) of PHIVOLCS.
  • Development – To execute the development phase, programming of the different modules based on the scope and deliverables.
  • Integration and Testing – Systems integration with other external systems; system testing or pilot testing.

  • Implementation – implementation and installation of the system including its hardware components.

  • Operation and Maintenance – Fine-tuning of the system, development of a sustainability plan to operationalize ClimEx.Db and PDNA IT-enabled system such as but not limited to Training of Trainers (TOT). Formulation of user-friendly manuals to operationalize the IT-based PDNA Tools, training modules for the conduct of training of PDNA Teams.

 

Specifically, the System Developer is expected to work on the following:

 

1.   Develop the IT-based PDNA Tools in the following platforms: mobile and web-based application; desktop application; and data server application. The System Developer must ensure that the system for PDNA tools are compatible and/or interoperable with the upgraded ClimEx.db app, also developed under RAPID. The IT-based PDNA Tools will (at least) have the following features;

 

  1. Functional Requirements

    1. Design of user interface: interactive map interface for data and way point reviewing;

    2. System compatibility:

      1. operates in Android devices, Ice Cream Sandwich (API Level 14) and up, in desktop computers

      2. import base maps (i.e. google maps, etc)

      3. import geotagged data from the pre-survey activity

      4. sync capability with the mobile/desktop app/data server

    3. Survey logic system:

      1. optimized survey questions used in PDNA based on the respective needs of the end users

      2. appropriately designed question type and styles (e.g. drop down, grids, single response, multiple response, time, date, open ended, free-text and semantic scales)

      3. question routing or skip logic (show/hide questions depending on the previous answers)

      4. in-survey calculations

      5. adding supplementary textboxes as needed in the survey answers

      6. integrated reference materials (e.g. user’s manual, PSIC and PSOC)within the system

      7. auto-save capability at key stages of the survey/interview

      8. linkable survey items on household, building, critical facilities, and natural resources sectors (including agriculture)

    4. Data management:

      1. complete security model support: secured login, users, groups & permissions on all objects;

      2. integrated with comprehensive data validation mechanism through response specific validation checks (e.g. quantity or date range) and alerts;

      3. online and offline data upload from mobile to the desktop app and/or server;

      4. data linkage of survey items on household, building, critical facilities and natural resources sectors (including agriculture), including sectoral variables and constants used to estimate damage.

      5. Exploring Cloud Technology for data storage as compared to using data server.

    5. Other features:

      1. manual GPS location capture

      2. integrated camera function with features that adjust photo resolutions and enable element-reference images during interview

      3. per surveyor quota management

      4. real time computing capacity, its data analytics and visualization

         

  2. Non-Functional Requirements

    1. User-friendliness of the interface (intuitive even to first time users)

    2. Interoperability with other system

    3. Security of the system

    4. Recoverability in case of failure

      Compliance and adherence to standards and regulation of concerned agencies

       

  3. Product Constraints

    1. Stakeholders are those concerned agencies which include NDRRM, ODC, and LGUs.

    2. Interoperability with other systems that are already in place

    3. The system will run in a local server but there is an intention to migrate it in the cloud

    4. Other relevant constraints

       

2.   Review and upgrade further the ClimEx.Db system to accommodate information requirements of PDNA, as well as other existing databases such as CBMS and REDAS as sources of baseline information;

3.  Install and set-up the ClimEx.Db system, web portal, and PDNA mobile app to the android phones/tablets;

4.   Facilitate pilot-testing of the PDNA computer App in a selected area with the RAPID program, including inter-operability with ClimEx Db.

5.   Update or formulate the User’s Manual and documentation of the schema; and

6.   Provide training and technical support to identified project implementation partners and end users/trainors.

7. Formulate sustainability plan to operationalize and manage the PDNA App computer system.

 

Institutional Arrangement

For the duration of the contract, the System Developer shall work in close coordination with OCD, specifically the Rehabilitation and Recovery Services, identified members of the PDNA Team of NDRRMC, the Project Management Unit, and if necessary with Local Government Units.

The cost of the contract shall cover services rendered only, travel costs and costs to be incurred during training will be covered by the project.

Duration of Work

To undertake the tasks and deliver the expected outputs, the consultant shall be engaged for a period of five (5) months. 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 July 15, 2018 and the expected completion date is December 15, 2018.

Duty Station

The position is Manila-based for accessibility and availability to allow for discussions/reporting on progress of activities as may be required by the PMU and UNDP.  Domestic travel may be required during the pilot testing of the tools.

The System Programmer will not be required to report to office regularly but status report on the outputs shall be expected from time to time.

 

SCHEDULE OF PAYMENTS

Payment will be made in installments based on the following milestones/outputs:

  • 20% Upon signing of contract and submission of proposed program design and workplan;
  • 20% Upon submission and acceptance by OCD and UNDP-PMU of the Conceptual and Logical Design of the IT-based PDNA Tools (mobile app, desktop app and server app);
  • 20% Upon submission and Acceptance of PDNA Tools and results of pre-testing (mobile app, desktop app and server app);
  • 20% Upon Installation and acceptance of pilot testing of computer based PDNA Tools (mobile app, desktop app and server app);
  • 20% Upon submission and acceptance of user-friendly manuals (mobile app, desktop app and server app), Completion of Training activities and sustainability plan.

 

CORPORATE COMPETENCIES

  • Commitment to UNDP’s mission, vision, values and ethical standards
  • Sensitivity to cultural, gender, religion, race, nationality and age differences
  • Treat all stakeholders fairly and without prejudice
  • Maintains objectivity and impartiality in handling evaluation processes

FUNCTIONAL COMPETENCIES

  • Experience in project development, implementation and evaluation--particularly in directly managing results-based monitoring and evaluation methodologies
  • Demonstrated experience in conducting evaluation of multi-year and multi-component programmes and projects
  • Familiarity with the norms and issues in early recovery and rehabilitation work in disaster-affected areas
  • Ability to process large amounts and diverse set of data and documents related to infrastructure development, livelihood, resettlement, disaster risk reduction and management, and governance

  • Demonstrated strong coordination and facilitation skills

  • Strong interpersonal skills and the ability to initiate discussions with national/local governmental officials, peoples organizations and communities

  • Demonstrated ability to function in a team environment and to deal with complex multi-stakeholder environment

  • Demonstrated ability to prepare and present comprehensive reports

 

QUALIFICATIONS

Education:

  • Bachelors’ Degree on Information Technology and/or actual work experience on programming and software development

Experience:

  • At least five (5) years’ experience in developing Android mobile applications related to socio-economic gathering tool;

  • Experience in coordinating with and training the government agencies and local government units;
  • Knowledge in the survey process;
  • Knowledge in data processing and mapping

Language:

  • Fluency in written and spoken English and excellent technical writing skills

 

Criteria for selection process:

The offer will evaluated based on the Combined Scoring method – where the qualifications will be weighted a max. of 70%, and combined with the financial offer which will be weighted a max of 30%.

Application requirements:

  • Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP (Financial Proposal Template);
  • 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.

Application requirements should be emailed to procurement.ph@undp.org and registry.ph@undp.org on or before  10 July 2018.

Attachments in this link:

- Terms of Reference, Financial Proposal Template, P11 Personal Histiory Template and Terms and Conditions for Consultants.

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