Antecedentes

Project Title: Strengthening National and Local Resilience to Risks of Violent Extremism in Southern Philippines (JAPAN-PVE Project)

Project Description

Relative to efforts to strengthen the national and local resilience to risks of violent extremism in the Philippines, the Japan-PVE Project will assist the establishment of an information system that will enable planning, monitoring and evaluation of programs on socio-economic inclusion, empowerment and social cohesion in the province of Lanao del Sur and contribute towards the development of local government approaches on recovery and rehabilitation.

As such, the United Nations Development Program (UNDP) through the Japan-PVE Project will be supporting the Lanao Returnee Reintegration Program. This initiative aims to determine the urgent needs of the Maute-ISIS Returnees as part of the requirements to provide immediate assistance that will gradually pave the way to long-term solutions for peace in the region. 

To serve as a data source for the formulation of effective projects and programs for the returnees, database development will be done to contain all necessary information such as personal, demographic and socio-economic details of the returnees. This will include the following processes:

  1. Questionnaire/ Survey Form Development;
  2. Local Server Setup and Installation;
  3. Pulling and Exporting Data from Server;
  4. Data Uploading to an Analytics Software; and
  5. Preparation of a Visualization Template

The outcome will be a reliable basis that will provide a solid framework for the development of cohesive socio-economic plans and initiatives.

Institutional Arrangement

For the duration of the contract, the consultant shall coordinate with the PMU, in the delivery of the terms of reference. All work-related travel expenses will be borne by UNDP. Outputs must be submitted to the PMU for review. Final outputs of the consultant should be formally accepted prior to any payments made.

Duration of Work 

To undertake the tasks, procedures, and expected outputs, the consultant shall be engaged for a period equivalent to 85 days (spread over 4 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 8, 2019 and the expected completion date is November 7, 2019.

Duty Station 

Duty station is in Manila but the consultant is expected to be regularly deployed in Mindanao.

Scope of Price Proposal and Schedule of Payments 

The proposed contract price is based on a lump sum amount. Payment will be made in installments based on the following milestones/ outputs: 

% of the Contract Fee

Deliverable/Milestone Output

Target Completion Date

10%

Signed contract; submission and approval of a proposed workplan and system design

July 13, 2019

20%

Submission and acceptance of the electronic survey form

July 24, 2019

30%

Submission and acceptance of an activity report for the server setup and installation

August 8, 2019

30%

Submission and acceptance of a data visualization template

September 30, 2019

10%

Submission and acceptance of a database training report

October 14, 2019

 

Deberes y responsabilidades

Scope of Work

UNDP will need the services of a qualified Systems Developer to build a database that will contain information for the Returnee Program. Specifically, the consultant will perform the following duties:

  1. Improvement of the current survey forms and conversion to an electronic form with the use of open-sourced platforms.
  2. Creation of a local server that will host the survey forms once finalized and submitted.
  3. Consolidation of all the gathered data from the different survey forms and exporting to CSV/ spreadsheet-ready format.
  4. Uploading of data to an analytics/ visualization software with a ready-made template that will reflect significant indicators from the survey.
  5. Troubleshoot problems and glitches that the system may encounter during field deployment.
  6. Provide trainings/ workshops and other capacity development activities on how to operationalize the database.

Competencias

Corporate

  • 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

Functional

  • Strong interpersonal and communication skills;
  • Strong analytical, reporting and writing abilities skills;
  • Ability to plan, organize, implement and report on work;
  • Ability to work under pressure and tight deadlines;
  • Comprehensiveness knowledge of IT systems and internet service provision in remote contexts;
  • Outstanding communication, project management and organizational skills;
  • Demonstrates integrity and ethical standards;
  • Positive, constructive attitude to work;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability.

Habilidades y experiencia requeridas

Qualifications of the Consultant

The Systems Developer should have the following qualifications. Minimum passing score is 70 out of 100 points.

Education

Graduate of information technology, application development, computer science, or related field (15 points)

Experience

At least two (2) years of working knowledge of any analytics application such as Qlik Sense or Tableau (35 points)

At least two (2) years of working knowledge of any open-source software for collecting, managing and utilizing data (30 points)

At least two (2) years of experience in conducting and facilitating community trainings and workshops (15 points)

Language

Fluency in English and Tagalog (5 points)

Evaluation Method and Criteria

Combined Scoring Method:

Qualifications and Methodology (70%)

Price Offer (30%)                                  

Criteria

Allocated Weight/Points

Graduate of information technology, application development, computer science, or related field

(50 points will be given for certificate courses in IT)

 

Weight: 15%, Max. 75 points

At least 2 years of working knowledge of any analytics application such as Qlik Sense or Tableau, (200 points will be given for minimum of 2 years; additional points for additional years)

 

Weight: 35%, Max. 250 points

At least 2 years of working knowledge of any open-source software for collecting, managing and utilizing data

(150 points will be given for minimum of 1 year; additional points for additional years)

Weight: 30%, Max. 200 points

Two years of experience in conducting and facilitating community trainings and workshops

(100 points will be given for minimum of 1 year; additional points for additional years)

Weight: 15%, Max. 150 points

Fluency in English and Tagalog

Weight: 5%, Max. 25 points

 

The maximum points that can be achieved in the desk review is 700 points.

Candidates obtaining less than 490 points during the desk review (70% of points obtainable during the desk review) will be disqualified.
Only those candidates who obtain a total technical score of 490 points and above on the technical evaluation will be considered for financial evaluation.

Recommended Presentation of Offer 

  1. Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP;
  2. 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;
  3. Financial Proposal that indicates the all-inclusive fixed total contract price, supported by a breakdown of costs, as per template provided.

Incomplete proposals may not be considered.

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 Interest and Availability for the IC by clicking on this link: http://gofile.me/6xdJm/bE9TCw8fU

  1. Duly accomplished Offeror's Letter to UNDP Confirming Interest 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 Interest 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

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