View Notice

National Power Platform and Database Consultant
Procurement Process :IC - Individual contractor
Office :UNDP Country Office - PHILIPPINES
Deadline :07-Oct-20
Posted on :01-Oct-20
Development Area :CONSULTANTS  CONSULTANTS
Reference Number :70877
Link to Atlas Project :
00101897 - ICT Investment Roadmap
Documents :
Offeror's Template/Financial Proposal
P11 Template
General Terms & Conditions for IC
Overview :

 

The United Nations Development Programme (UNDP) Philippines Country Office (CO) has developed several tools and systems to support the CO’s oversight, results-based management (RBM), and quality assurance (QA) function at the portfolio level. The Project Center SharePoint Site is composed of a Project Document Center that lays out the taxonomy of documents to ensure that UNDP projects comply with the organization’s programme and operations policies and procedures, a Country Programme Portfolio Review Dashboard that facilitates the timely monitoring of financial delivery, programme quality, and the various dashboard and oversight tools employed by UNDP, and a sensemaking exercise where insights, claims, and actionable items are drawn from project reflections.

 

The Project Center uses Microsoft Power Platforms (Power Apps, Power BI, SharePoint online), as part of UNDP’s digital transformation to improve the quality, relevance and impact of its work while also improving efficiency in its operational systems and internal processes. This is also consistent with UNDP’s Digital Lighthouse Initiatives (DLI), which aims to provide a common platform for solution development enabling a more collaborative approach between UNDP units and increase the speed and agility of UNDP ICT innovations.

 

Deliverables and Schedules/Expected Outputs

Listed below are the specific duties and responsibilities with target due dates.

 

 

Deliverables/ Outputs

 

Estimated Duration to Complete

 

Target Due Dates

 

Review and Approvals Required

 

Work Plan 

              2 days

9 October 2020

Results-Based Management (RBM) Analyst and Digital Services Analyst

Digitized visual guide to UNDP Standard Development Projects

             4 days

15 October 2020

Results-Based Management (RBM) Analyst and Digital Services Analyst

Develop localized productivity applications using Power Platform and Azure Data Warehouse, including the digitization of project-level annual work plans and progress reports

             10 days

30 November 2020

Results-Based Management (RBM) Analyst and Digital Services Analyst

Conduct trainings and submit the final report

             4 days

18 December 2020

Results-Based Management (RBM) Analyst and Digital Services Analyst

 

Governance and Accountability

The consultant shall work closely with the UNDP Philippines Results and Quality Team and Digital Services Team under the direct supervision of the RBM Analyst and Digital Services Analyst. The Consultant is expected to work closely and collaborate with the focals from UNDP Programme, Operations, and Procurement Teams.

 

Expected duration of the contract/assignment

The services of the consultant are required for an estimated period of 20 person-days spread over 3 months.

 

Duty Station

Home-based with few online meetings in the UNDP office with the UNDP Senior Management, Results and Quality Team and Digital Services Team. No travel outside Manila required.

 

Scope of Price Proposal and Schedule of Payments

The contract price shall be an all-inclusive lump-sum amount regardless of the extension of the herein specified duration. Payments shall be made upon submission and acceptance of outputs as specified in Part E.

Tranche

Percentage

                    Deliverables / Outputs

1

20%

Upon submission and approval of the Work Plan

2

30%

Upon submission and approval of the digitized visual guide to UNDP Standard Development Projects

3

30%

Upon submission and approval of the localized productivity applications using Power Platform and Azure Data Warehouse, including the digitization of project-level annual work plans and progress reports

4

20%

Upon submission and approval of the final report and successfully conducted trainings.

 

Duties and Responsibilities

Under the guidance and direct supervision of the Results Based Management Analyst (RBM) and Digital Services Analyst, the Power Platform and Database Consultant will be supporting the UNDP Philippines Project Center Project through the development of localized applications and enterprise-line of business apps.

 

Objectives and specific tasks:

  • Provide technical expertise in the implementation of database management system that meets the data requirements of the UNDP Philippines SharePoint Site:
    • Support in transitioning datasets of disparate systems to UNDP’s Corporate Azure Data Warehouse.
    • Identify Dashboard bubble automation needs, and coordinate automatic data extraction with OIMT, BRH, thus ensuring optimal automation of the Dashbords of Dashboards.
    • Define data elements and their relationship that meets the requirements of specified app and systems that will be developed
  • Develop localized productivity applications using Power Platform and Azure Data Warehouse.
  • Support in automating business processes by developing no-code / low-code applications using canvas and model-driven apps in PowerApps, including the digitization of project-level annual work plans and progress reports
    • Conduct hands-on training sessions to the Results and Quality Team and the Digital Services team, as well as other app users to encourage developing capacity for citizens-developer in the office.
  • Accomplish all tasks as assigned by the RBM Analyst and Digital Services Analyst in coordination with the different team’s focal in developing, improving, and refining the online platform to ensure an easy and user-friendly experience.
  • Digitize the Visual Guide to UNDP Standard Development Projects using Microsoft Visio to allow for linking of the visual guide to relevant sections in the UNDP Programme and Operations Policies and Procedures.
 

Competencies

Corporate competencies

  • Demonstrates integrity by modeling the UN's values and ethical standards;
  • Promotes the vision, mission, and strategic goals of UNDP;
  • Displays cultural, gender, religion, race, nationality, and age sensitivity and adaptability;
  • Treats all people fairly without favoritism.

Functional and technical competencies

  • Ability to work in a diverse and multi-cultural environment;
  • Self-motivated and ability to work under pressure and to meet strict and competing deadlines;
  • Displays analytical judgment and demonstrated ability to handle confidential and politically sensitive issues in a responsible and mature manner;
  • Demonstrates openness to change and ability to manage complexities;

 

 

Required Skills and Experience

Candidates will be evaluated based on the Combined Rating methodology:

 

  • Technical qualifications = 70%
  • Financial Proposal =    30%

For the evaluation of the Technical Proposal, the selection of the successful consultant must be based on the following qualifications (with the appropriate obtainable points):

 

                Qualification

      Points Obtainable

             (100 points)

Education

Bachelor’s Degree in Computer Science, Information Technology, Creative & Design, or related field experience.

                 10

Experience

  • At least of 7 years’ experience in IT-related work and/or a combination of Website or Application Development.
  • At least 7 years’ experience on the following programming models: JavaScript, ASP.NET, .NET Framework, Windows PowerShell.

 

                   30

 

 

  • At least 3 years’ experience in IT Systems Analysis and Design or SharePoint application development.
  • At least 3 years’ experience in Power Apps, Power Automate (formerly known as Power Flow), and Power BI.
  • Experience in database design is a plus.
  • Experience working with international non-profit agencies an asset.

 

                   40

 Has developed at least 1 mobile application for different mobile platforms like Windows Phone, IOS, and Android. Candidates need to specify the applications in the CV or P11.

                   20

TOTAL

                   100

 

Applicants who will only receive 70 points from the assessment of the CV will be qualified for the assessment of the Financial Proposal. 

 

Recommended Presentation of Offer

Interested applicants must submit the following documents/information to demonstrate their qualifications. Please group them into one (1) single PDF document as the application only allows to upload maximum one document. 

  1. 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
  2. Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP; ?Financial Proposal that indicates the all-inclusive fixed total 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. 
  3. Brief description of why the individual considers him/herself as the most suitable for the assignment, and a methodology, if applicable, on how they will approach and complete the assignment. A methodology is recommended for intellectual services but may be omitted for support services. Please provide sample work if available.

 

Interested applicants to note that personal Medical/health insurance (to be purchased by the individual at his/her own expense) is mandatory for the issuance of contracts. Upon award of the contract, the consultant must be ready to submit proof of insurance valid during the contract duration.

The following templates / Annexes and IC General Terms & Conditions can be downloaded from http://gofile.me/6xdJm/bE9TCw8fU:

  • General Terms and Conditions for Individual Contract
  • Letter of Confirmation of Interest and Availability
  • P-11 form

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