Background

Cambodia’s progress towards the Cambodian Millennium Development Goals (CMDGs) has been substantial but varied. Analysis of Cambodia’s progress towards CMDG1 reveals that Cambodia has achieved impressive growth and significant reduction of poverty over the past decade. Cambodia’s uneven growth dynamics have a strong geographic dimension.

Important capacity gaps across all levels of government and society hinder the development of strategies to address these challenges. It is increasingly acknowledged that MDG targets can only be achieved fully if services and inputs are available to, and managed byall levels of government and communities and if their capacities to do so are further developed.

At sectoral level, while targets have been set for NSDP/CMDG at the national level, there are currently no sub-national targets to support sub-national planning and monitoring of progress. Localizing the MDG monitoring and connecting it to national MDG monitoring would help improving integration of sectoral strategies.

The NSDP/CMDG Monitoring Support Program (NMSP) is a five-year programme (2011-2015) designed to support the Ministry of Planning to address key challenges in achieving NSDP/CMDG targets. The goal of the NMSP is to support monitoring and policy dialogue on NSDP implementation to accelerate achievement of CMDG at both national and sub-national levels.

Public Investment Programme (PIP) is a forward three year rolling programme of capital and technical investment by the Government designing to support the implementation of NSDP.

The PIP, as set up under the PIP Manual in 2000, represented a comprehensive and rigorous approach to the management of public investment.  The key function of the PIP database (as currently applied) is to produce the tables required for the PIP.  It does not function as an ongoing database with information on all PIP projects (completed, ongoing, committed, and planned). Reinstating the ability of the database to track all PIP projects (rather than covering only the ongoing and planned projects submitted for the current PIP exercise), The PIP would then return to being a report extracted from the ongoing database, as under the original PIP process.

The NMSP has two objectives:

  • Strengthen the monitoring and analysis of the NSDP by the Ministry of Planning (MoP) and Line Ministries leading to evidence based policy decisions to accelerate progress in lagging NSDP/ CMDG areas
  • Use of sub-national scorecards and other products to assess budget allocation and NSDP / CMDG performance at the sub-national level

Duties and Responsibilities

Scope of Work:

The consultant will work closely with General Directorate of Planning (GDP) of the Ministry of Planning to carry out the assigned tasks. Also, she/he will work with UNDP programme and project staff for any information and guidance.

The consultant will be responsible for the effective delivery of the following tasks:

  • Review current PIP database to capture the relationship of the programme and its codes
  • Review existing PIP’s related forms to understand database structure
  • Modify/revise the current PIP database to be an ongoing database with information on all PIP projects (completed, ongoing, committed, and planned) in both Khmer and English. The revised database need to be developed on website interface.
  • Create security option for each user by a username & a password.
  • Create tables/reports of PIP which are derived  from the data entry
  • Develop reporting format in the system that can track progress of PIP implementation of line ministries/agencies.
  • Templates of report to be exported to MS Excel is to be developed as part of database
  • Produce a revised PIP database prototype
  • Produce a simple manual for operating the revised PIP database
  • Train relevant line ministries/agencies on the use of revised PIP database

The consultant needs to discuss and work in close collaboration with the GDP of Ministry of Planning before producing the outputs. Throughout the consultancy period the consultant is expected to strengthen capacity of the Ministry of Planning staff involved in the operation of revised PIP database. The consultant needs to take this in mind while performing his/her assignment.

Expected Outputs and Deliverables:

The consultant will be responsible for the effective delivery of the following outputs:

  • Submission of Conceptual model/prototype of revised PIP database before going to detail steps of revision of current PIP database
  • Submission of completed database a long with a simple operation manual of the revise PIP database
  • Training on PIP database operation conducted for relevant line ministries/agencies staff

Institutional Arrangement:

The Consultant will work closely with the General Directorate of Planning, the project team of the NSDP/CMDG Monitoring Support Programme (NMSP) and UNDP programme analyst and work under direct supervision of the Assistant Country Director and Poverty Team Leader.
The NMSP project team will support the Consultant to produce the expected outputs by providing coordination and logistic supports as necessary during the assignment.

The consultant will bring his/her own personal computer and will also make his/her own travel arrangement by him/herself.

Duration of the Work:

  • The assignment will be 40 working days from 3rd week of April to mid-August 2015
  • The consultant is expected to be on board from 20 April and complete assignment not later than mid-August 2015. She/he has to submit the work plan prior to the assignment.
  • Consultant has to submit her/his outputs in accordance to the defined work plan and payment is issued only with satisfactory outputs accepted/approved by MOP/UNDP.
  • All expected outputs could not be delayed as result of assignment; therefore, the consultant has to commit to deliver these outputs as planned.

Duty Station:

The consultant will be based in Ministry of Planning and some time in UNDP Country Office.

Competencies

Functional Competencies:

  • Outstanding interpersonal, analytical, communication skills and ability to work with people from different backgrounds to deliver quality products within short timeframe
  • Excellent organizational and time management skills.
  • Be flexible and responsive to changes and demands.
  • Be client oriented and open to feedback.

Corporate Competencies:

  • Demonstrates commitment to UNDP’s mission, vision and values;
  • Exerts strict adherence to corporate rules, regulations and procedures;
  • Familiarity with the internal control framework and results-based management tools is a must;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability.

Required Skills and Experience

Education:

  • At least Bachelor Degree in the field of Computer Science or equivalent, especially in programming.

Experience:

  • Minimum of 3 years (Master’s degree) or 7 years (Bachelor degree) of experience in Database development & maintenance;
  • Excellent understanding of web based database design, development and management.
  • Proven ability to translate technical needs into database specifications and to develop a fully functional and user friendly database application, including appropriate reports with web-based interaction
  • Knowledge and experience with Web based applications development and languages, MS Access and MS Excel.
  • Understanding of government and the United Nation System

Language Requirement:

  • Full proficiency in Khmer and English, and excellent report writing skills.

Important note:

Interested offeror is strongly advised to read the Individual Consultant (IC) Procurement Notice, which can be viewed at http://procurement-notices.undp.org/view_notice.cfm?notice_id=21366 for more detail about term of references, instructions to offeror, and documents to be included when submitting offer.

Documents to be included when submitting the application:

Interested offeror/individual must submit the following documents/information.

UNDP reserves right to reject any applications that is incomplete.

Please be informed that we don’t accept application submitted via email.

Interested candidate is required to submit application via UNDP jobsite system, because the application screening and evaluation will be done through UNDP jobsite system. Please note that UNDP jobsite system allows only one uploading of application document, so please make sure that you merge all your documents into a single file. Your on-line applications submission will be acknowledged where an email address has been provided. If you do not receive an e-mail acknowledgement within 24 hours of submission, your application may not have been received. In such cases, please resubmit the application, if necessary. Please group all your documents into one (1) single PDF document as the system only allows to upload maximum one document.

Any request for clarification/additional information on this procurement notice shall be communicated in writing to UNDP office or send to email vannara.chea@undp.org and/or procurement.kh@undp.org. While the Procurement Unit would endeavor to provide information expeditiously, only requests receiving at least 5 working days prior to the submission deadline will be entertained. Any delay in providing such information will not be considered as a reason for extending the submission deadline. The UNDP's response (including an explanation of the query but without identifying the source of inquiry) will be posted in Individual Consultant (IC) Procurement Notice page as provided above. Therefore, all prospective Offerors are advised to visit the page regularly to make obtain update related to this Individual Consultant (IC) Procurement Notice.