NATIONAL IT CONSULTANT TO PROVIDE QUALITY ASSURANCE FOR THE PROGRAMS AND PROJECTS MONITORING SYSTEM PHASE II

Background

NATIONAL IT CONSULTANT TO PROVIDE QUALITY ASSURANCE FOR

THE PROGRAMS AND PROJECTS MONITORING SYSTEM PHASE II

 

A.Project Title: Using Strategic Monitoring & Evaluation (M&E) to Accelerate the Implementation of the Philippine Development Plan (PDP) 2017-2022 (Strategic M&E Project)

 

B.Background and Description

The National Economic and Development Authority (NEDA) and the United Nations Development Programme (UNDP) Philippine Country Office (“UNDP Philippines”) embarked on a partnership to strengthen the conduct of monitoring and evaluation (M&E) of the country’s milestone programs and projects. Financed by NEDA and implemented with the support of UNDP Philippines, this partnership - the Strategic M&E Project - seeks to strengthen the capacities of NEDA and select government agencies through a host of interventions, one of which is the development and integration of the National Government’s digital platforms and data ecosystems relating to key government programs and projects.

 

The development of an information system is only the first step in the broader mission to develop and integrate the National Government’s digital platforms and data ecosystems relating to programs and projects. After the completion of PPMS Phase I – PPMS 1.0 Development and Business Analysis for the evolution of PPMS, the Project will be implementing PPMS Phase II.

 

PPMS Phase II scope will cover the following:

 

Data Governance and Migration

• Data Governance - Data Migration preparation involving (i) data profiling and standardization, and (ii) data discrepancy handling protocols.
• Data Migration - Actual Migration of (i) Loans information, (ii) Grants information, (iii) Project Static Information, (iv) existing Project Documents, and (v) Historical Project Workflow Reports from the past Data Call submissions.

 

PPMS Enhancement: Project Record

• Expansion of the Project Record (i) to relate to other PPMS-recorded data, and (ii) to utilize Data Visualization features for performance analysis.
• Some visualization features:

• Financial and Physical S-curve visualizations
• Correlation of physical and financial performance
• Data visualization of other KPIs (including SDG indicators and PDP chapter outcomes)
• Location information in photos (geotagging)
• Other visualizations as may be required by NEDA (e.g. Gantt charts, milestone tracker)

 

Other PPMS enhancements that may be identified by NEDA and UNDP

Currently, the Project is engaging a service provider for Phase II. The project now requires an IT Consultant who will assist UNDP in providing quality assurance review of outputs for key project milestones for PPMS Phase II. The Consultant is also expected to be on call to respond to technical concerns of the Contract Managers and to provide assistance in communicating and translating outputs to recommended action points for the NEDA and UNDP Management.

Duties and Responsibilities

Scope of Work

The QA Consultant for PPMS Workstream 2 shall perform the following services:

• Review technical and financial proposals for the procurement of a service provider for PPMS Phase II and provide timely and relevant inputs and advice to UNDP and NEDA based on the review
• Provide QA review of the major outputs and reports of the firm, such as but not limited to:
•  

Data Governance and Migration

1. Inception Report
2. Data Profiling Report
3. Initial Cleansed / Converted Data Set
4. Data Discrepancy Log
5. Data Migration Plan
6. Final Cleansed/Converted Data Set
7. Completed Data Migration to PPMS
8. Report on Migration Issue Resolution and Support

 

PPMS Enhancement: Project Record

1. Requirements Documentation
2. Report and UI Mockups
3. Demonstration to NEDA-MES Month 4
4. UAT Results
5. Source Code
6. Technical Documents

 

• Provide assistance in communicating and translating outputs to become understandable and relevant action points for the NEDA, DBM, and UNDP Management; and
• Provide on-call support for technical concerns related to PPMS Phase II procurement and implementation

 

Expected Outputs and Deliverables

The Consultant is expected to deliver the following:

 

Deliverables / Output	Level of Effort (person-days)	Target Due Dates	Review and Approval
Quality assurance reports on the following:
DATA GOVERNANCE AND MIGRATION
QA Report 1	Technical and Financial Proposals	3 days	June 2021
	Inception Report	3 days	Aug 2021
	Data Profiling Report	3 days	Oct 2021
QA Report 3	Data Discrepancy Log	2 days	Dec 2021
	Data Migration Plan)	3 days	Jan 2022
QA Report 4	Report on Migration Issue Resolution and Support	4 days	April 2022
PPMS ENHANCEMENT: PROJECT RECORD
QA Report 1	Requirements Documentation	3 days	Aug 2021
	Report and UI Mockups	2 days	Aug 2021
QA Report 2	Demonstration to NEDA-MES	1 day	Nov 2021
	UAT Results	2 days
	Source Code	2 days
	Technical Documents	2 days
		30 days

 

Institutional Arrangement

1. The Consultant shall be directly supervised by the Project Coordinator of the NEDA-UNDP Strategic M&E Project and the Project Officer for PPMS, with whom all outputs shall be submitted and through whom all communications shall be coursed or copied.
2. The Consultant shall report progress, provide updates, or raise issues to the Project Coordinator and Project Officer for PPMS on at least a weekly basis. The Consultant is expected to be accessible to the UNDP Project Coordinator via phone, mobile, or internet, and may be asked to report physically to UNDP on an agreed schedule and when required.  
3. The Consultant may also be required to coordinate with the Institutions and Partnerships Programme Team Lead, and other officials and staff of UNDP, the Director and staff of the MES, other officials and staff of NEDA, and other relevant stakeholders.
4. In performing his/her functions, the consultant is expected to coordinate, consult, and/or collaborate with members of the Project Management Team, and other external stakeholders.  
5. The Consultant is expected to have his/her own workspace, computer, and other facilities. 

 

.Duration of the Work

1. The consultant will be engaged for a maximum of thirty (30) person-days spread over eleven (11) months.
2. The target start of work date is 01 June 2021 and the maximum end date is 30 April 2022.

 

Duty Station

1. The Consultant is ideally based in Manila to participate in meetings, consultations, and other in- person activities required.
2. In light of the COVID-19 pandemic and declaration of State of Public Health Emergency in the Philippines, all work of the individual consultant shall be done within the guidelines and protocols   set by the local and national government. During the quarantine period, the IC shall NOT engage in any meetings or activities OUTSIDE THEIR HOMES. Coordination/meetings shall be done through phone or online communication until such time that the quarantine is lifted, during which this will be STRICTLY a HOME-BASED assignment; NO TRAVEL IS REQUIRED for the IC to complete their abovementioned tasks.
3. Similarly, once the community quarantine is lifted, the Consultant may be required to report physically to UNDP when physical participation in activities is necessary. 

 

 

Competencies

Competencies

Corporate Competencies Demonstrates integrity by modeling 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; 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

Qualifications of the Successful Individual Contractor

The offer will be evaluated based on a Combined Scoring method where the technical proposal will be weighted 70% and combined with the price offer which will be weighted 30%.  

The technical evaluation (70%) will comprise the following: 

 

Qualifications based on CV	28%
Interview	42%

 

For the evaluation of the CV the point system below will be used. The Consultant to be hired shall have the following minimum qualifications. Only those who will score at least 70 out of 100  obtainable points will be shortlisted and invited for an interview.

Qualification	Points Obtainable (100 points)
Education   At least undergraduate degree in computer science, information technology, or information systems development related field.   (21 points for minimum degree, additional points for additional degrees, maximum of 30 points)	30 points
Experience   At least five (5) years of total professional experience in data management, software application, web development, UX/UI, and in project management systems.   (21 points for 5 years, additional points for additional years, maximum 30 points)   At least three (3) years of quality assurance consultancy experience in the government, international development organizations, non-profits, among others. Experience in UN agencies is an advantage.   (28 points for 3 years, additional points for additional years, maximum of 40points. Additional 3 points for experience in UN Agencies)	30 points                 40 points
Language   Fluent in English and Filipino	Pass / Fail
TOTAL	100

 

• Only candidates that will receive 49% from the overall evaluation of the technical qualification (CV score + interview score) will be eligible for financial evaluation. 

 

B.Scope of Price Proposal and Schedule of Payments

1. Financial proposals must be expressed as a per person-day rate which includes professional fees, allowances, income tax, communications expenses, etc.
2. Medical/health insurance must be purchased by the individual at his/her own expense, and upon award of contract, the consultant must be ready to submit proof of insurance valid during contract duration.
3. Payment to the Consultant shall be fixed and output-based regardless of extension of the specific duration herein. Cost components of the Proposer’s computation of the contract price shall include professional fees, inclusive of travel, living allowances and similar costs.  

The consultant will only be paid upon full acceptance of UNDP of the following outputs: 

 

Tranches	Target Outputs/ Deliverables	Schedule	Payment
1	Upon submission and acceptance of  QA report 1 and inputs to Technical and Financial Proposals, and Inception Report	Aug 2021	20%
2	Upon submission and acceptance of QA report 2 and inputs to Demonstration to NEDA-MES, UAT Results, Source Code and Technical Documents for PPMS Enhancement: Project Record	Nov 2021	30%
3	Upon submission and acceptance of QA Report 3 and inputs to Data Discrepancy Log and Data Migration Plan	Jan 2022	20%
4	Upon submission and acceptance of QA Report 4 and inputs to Report on Migration Issue Resolution and Support	April 2022	30%

All other workshop expenses (venue, food, transportation, etc.) shall be borne by UNDP.

 

C.Recommended Presentation of Offer

Interested bidders must submit 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;

• Financial Proposal that indicates the all-inclusive fixed total contract price, supported by a breakdown of costs, as per template provided.

 

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.