Consultant to design, build and maintain an online city level greenhouse gas (GHG) emission reporting system


Location : Putrajaya, MALAYSIA
Application Deadline :29-Nov-19 (Midnight New York, USA)
Time left :10d 18h 24m
Type of Contract :Individual Contract
Post Level :National Consultant
Languages Required :
English  
Starting Date :
(date when the selected candidate is expected to start)
15-Nov-2019
Duration of Initial Contract :15 November 2019 – 14 November 2020
Expected Duration of Assignment :12 months


Background

The Green Technology Applications for the Development of Low Carbon Cities (GTALCC) project was initiated to generate direct greenhouse gas (GHG) emissions reductions from at least five Malaysian cities. The objective of the project is to facilitate the implementation of low carbon initiatives and showcase a clear and integrated approach to low carbon development. The project is implemented by the Ministry of Energy, Science, Technology, Environment and Climate Change (MESTECC), with the Sustainable Energy Development Authority (SEDA Malaysia) as the lead consultant.

Malaysia intends to reduce its greenhouse gas (GHG) emissions intensity of GDP by 45% by 2030 relative to the emissions intensity of GDP in 2005. The urbanisation rate of Malaysia increased from 66.5% in 2005 to 74.3% in 2015. Cities in Malaysia are significant contributors to the country’s GHG emissions. Cities and states have struggled to translate the national GHG emission reduction agenda into local action. This is due to lack of capacity and resources to undertake city-level greenhouse gas inventories. Cities such as Putrajaya, Iskandar Malaysia and Hang Tuah Jaya have developed city-level GHG inventories. 

MESTECC through the GTALCC project intends to develop an online city level GHG emissions reporting system which includes a web portal and web application. The web portal will be used to disseminate information on GHG emissions of Malaysian cities to the public. The web application will be used as a platform for local authorities to report their city level GHG emissions on an annual basis. The collected data from the system will be shared across with other ministries and agencies such as Ministry of Housing and Local Government, Ministry of Federal Territories, Ministry of Transport, Ministry of Economic Affairs, PLANMalaysia, Department of Statistics Malaysia and PLANMalaysia.

This work is part of Component 1 of the project which is policy support for the promotion of integrated low carbon urban development, which will enable cities to implement and adopt integrated low carbon urban development plans and programmes.

OBJECTIVES

The online city level GHG emission reporting system is intended to achieve the following objectives:

i.              To provide a platform to local authorities to report their city level GHG emissions on annual basis within their administrative boundary;

ii.             To enable local authorities to access data from providers i.e Tenaga Nasional Berhad on electricity consumption data;

iii.            To allow local authorities to benchmark their GHG emissions with other cities in Malaysia and globally; and

iv.           To support local authorities in formulating low carbon development plans. 


Duties and Responsibilities

The appointed web developer shall work closely with the GTALCC project team and the ICT department at SEDA Malaysia with the support of the ICT department and related departments under the Environment and Climate Change Sector of MESTECC. The web developer will design, develop and deploy the system which consists of a web portal and a web application covering the following:

  • Installation of content management system (CMS) and necessary modules/plugins for an optimal system performance.  SEDA Malaysia shall provide the domain and hosting of the system with guidance from MESTECC’s ICT department.
  • The CMS/Web Development Framework should be based on a widely used and open license PHP framework to allow future upgrades and modifications in the future.
  • Propose the design of the system for SEDA Malaysia’s review and approval.
  • Design and develop the system architecture and functionality based on SEDA Malaysia’s requirements.
  • Build a database to collect and store large datasets and filter data according to SEDA Malaysia’s requirements.
  • Perform preventive maintenance from time to time to ensure errors are fixed.
  • Develop necessary documentations which describes system architecture, user manuals, system installatons, system administrator, technical guides and training materials
  • Conduct trainings to local authorities and relevant data providers.
  • Perform daily administrative tasks such as correspondence with data providers, local authorities and relevant agencies with access to the system.
  • Continuous technical support and quality control within the period of contract.
  • Handover of full source code to SEDA Malaysia before the end of the project.

METHODOLOGY

Web portal (structure) – refer to APPENDIX B

  • General web layout in dual language (English and Bahasa Melayu):
    •  Home
    • About
    • Resources
    • Contact us
    • Login page
  • Map of Malaysia with state and local authorities boundaries.
  • Search button with drop down list of local authorities e.g Majlis Bandaraya Kuala Lumpur or cities e.g Cyberjaya
  • Button linked to the GHG emissions of the selected local authority or city

Web application (functionalities) – refer to APPENDIX B

  • Login page – user name and password
  • Entering and control data of the following parameters:
    • Geographic boundary
    • Inventory year
    • Population
    • Types of greenhouse gases (GHGs) in terms of CO2 equivalent
    • Grid-supplied electricity consumption
    • Fuel sales – natural gas, petrol, diesel, etc
    • Transport activity data – vehicle kilometres travelled (VKT), mode share and energy intensity
    • Waste (solid waste and wastewater)
    • Amount of production output and raw material consumption of the identified industrial process
    • Amount of identified product use in the inventory year
    •  Land use and land change
  • Calculation of GHG emissions according to sectors outlined in the Global Protocol for Community-Scale Greenhouse Gas Emission Inventories (GPC).
  • Import of default values such as emission factors, global warming potential (GWP) of greenhouse gases based on IPCC Guidelines.
  • Database filtering i.e filtering of raw data from data providers to useable data (Refer to Figure 1 on data flow and management)
  • Analysis of GHG emission trend according to sectors outlined in the Global Protocol for Community-Scale Greenhouse Gas Emission Inventories (GPC).
  • Charting of GHG emissions – trendline, year to year reduction/increase,targets
  • Tracking of GHG inventory submissions from local authorities
  • Import of existing GHG inventories
  • Import of data from national agencies such Suruhanjaya Tenaga which hosts the Malaysian Energy Information Hub and Department of Statistics Malaysia
  • Excel, pdf data export
  • Import of GHG emissions calculation spreadsheets used by local authorities
  • Download of GHG emissions calculation template such as CIRIS and manuals

Figure 1. Data flow and managementAccess level

The system shall be able to solely provide information to those stakeholders who are allowed to access it. The standard classification of stakeholders is done according to the table below. Access to the respective information shall be given in line with the table below as an example:

Access Level

Information accessible

SEDA Malaysia (administrator)

Full access. Administrator shall be able to manage the group such as create, update, delete and grant the access. Access to raw data and reports

Local authorities 

Access by username and password granted by SEDA Malaysia. Access to data required to calculate GHG emissions – electricity data, fuel sales, waste generation. Input of data for calculation of GHG emissions. Upload of calculation spreadsheets

Data providers

Access by username and password granted by SEDA Malaysia. Access only for upload of raw data.

Public

Information dashboard which includes of GHG emissions of cities. Public should be able to download the GHG emissions data in PDF or XLS format. 

Training

The developer is required to develop the necessary documentation which describes the internal system architecture, user manuals, technical guides and training materials. The developer is required to carry out training workshops as follows:

  • Basic workshop (1 day)

This workshop is targeted at end users of the system which consists of personnel from selected local authorities, federal and state agencies and companies responsible in providing data to the system.

  • Advanced workshop (2 days)

This workshop is targeted at personnel from the ICT department of SEDA and MESTECC. This workshop is more technical which covers the internal system architecture and maintenance requirements.  

Example of a similar system developed in Denmark : https://sparenergi.dk/offentlig/vaerktoejer/energi-og-co2-regnskabet

DELIVERABLES AND TIMELINE

The Consultant shall be responsible for the delivery, content, technical quality and accuracy of the reports in accordance to the timeline in Annex I.

All outputs will be technically cleared by the GTALCC project team, verified and accepted by the National Project Director and the UNDP Assistant Resident Representative (Programme) before payment for each deliverable will be effected.

The project gantt chart is enclosed herewith as APPENDIX A.

TERMS OF PAYMENT

The fee is payable upon satisfactory completion and acceptance of the deliverables by SEDA/MESTECC and UNDP Malaysia. Please refer the below schedule of payments.  Prices should be in US Dollars Per day rate inclusive of all expenses (insurance, local travels and communications) related to the assignment. The consultant is responsible for payment of all relevant taxes. Breakdown and schedule of payments is in Annex I.

DURATION

The project is expected to be completed in the course of twelve (12) months after signing of work contract by successful consultant. The deliverables and timeline are as per the Financial Proposal form. The consultancy will take place from 15 November 2019.

ELIGIBILITY

The consultant shall have demonstrated a successful completion of similar system.   

 


Competencies

Functional Competencies:

  • Knowledgeable in building web applications.
  • Knowledgeable in various progamming language and standards  

Development and Operational Effectiveness:

  • Relevant experience in developing web applications.  
  • Demonstrate strong analytical skills

Management and Leadership

  • Focuses on impact and result for the client and responds positively to feedback;
  • Consistently approaches work with energy and a positive, constructive attitude; and
  • Demonstrates strong oral and and written communication skills.


Required Skills and Experience

Education Requirement:

  • Degree in Information Technology, Computer Science, Management Information System or similar qualification.

Experience:

  • Possess at least 5 years of relevant experience in IT development
  • Strong technical knowledge in PHP Development and MySQL
  • Completed at least 5 full end to end project life cycle and demonstrated knowledge of SDLC Scrum/Agile experience is an added advantage
  • Familiarity and relevant experience in using different Content Management Systems (CMS).
  • Prior experience in designing web applications related to environment and climate change is an added advantage.
  • Possess a broad knowledge of current web development technologies and design tools in the field.
  • Expert in the following programming language and standards: PHP, HTML (including version 5), Javascript, CSS (including version 3), AJAX, XML, XHTML, Python
  • Expert in the database applications: MySQL
  • Capable in dealing with large datasets
  • Expertise in Adobe Illustrator, In-Design and Dreamweaver is an added advantage
  • Knowledge in greenhouse gas accounting is an added advantage but not required. The consultant will be given a crash course on greenhouse gas accounting methodologies.

REQUIRED DOCUMENTS

Interested individuals must submit the following documents/information to demonstrate their qualifications:

Interested individual applicants must submit the following documents/information to demonstrate their qualifications:

  1. Completed Letter of Confirmation of Interest and Availability (Annex 1) provided by UNDP;
  2. Technical Proposal on how your qualifications, experience and list of track records can lead to successful deliverables of this assignment within the required timeframe, and provide a methodology and approach on how you will approach and conduct the assignments;
  3. Financial Proposal (Annex 2) should specify unit price (daily professional fee in USD), travel and relevant costs using the financial proposal template in Annex 2.
  4. Personal CV including areas of expertise and past experiences in similar projects and at least three (3) references.
  1. Technical Proposal:

    • Cover page (max. 2 pages): Explaining how their qualification and experience in research/ project coordination makes them suitable for the work and can lead towards the successful deliverable of this assignment within the required timeframe.

  2. Financial proposal: 

    Specify a daily fee amount which is all inclusive and take into account various expenses the candidate expect to incur during the contract, including:

    • The daily professional fee;

    • Living allowances needed at the duty station, if applicable; 

    • Communications, utilities and consumables;

    • Life, health and any other insurance;

    • Risks and inconveniences related to work under hardship and hazardous conditions (e.g., personal security needs, etc.), where applicable;

    • Any other relevant expenses related to the performance of services under the contract).

  3. Personal CV indicating all past experience from similar projects as well as the contact details of the candidate and at least (2) professional references.
  4. Portfolio of previous work.

Note: Incomplete applications will not be considered for shortlisting.  

How to Apply:

  • Kindly download the Letter of Confirmation of interest and availability, Financial Proposal Template and General Terms & Conditions mentioned below;
  • Read and agree to the General Terms & Conditions;
  • Click the ‘apply’ icon and complete what is required;
  • Scan all documents into 1 pdf folder and then upload;
  • For clarification question, please email to procurement.my@undp.org. The clarification question deadline is three (3) days before the closing. When emailing for clarification questions, please put "MyIC/2019/066" as the subject matter.

Forms and General terms & conditions to be downloaded:

Individual consultants will be evaluated based on the following methodology:

Total Points: (Technical Grand Total x 70%) +  (Financial Grand Total 30%)

Technical  score

Score weight

Points obtainable

1

Experience of bidder

35%

250

2

Technical capability

35%

250

Financial score

 

 

1

Bid price

30%

-

UNDP applies a fair and transparent selection process that will take into account the competencies/skills of the applicants as well as their financial proposals. Qualified women and members of social minorities are encouraged to apply.


UNDP is committed to achieving workforce diversity in terms of gender, nationality and culture. Individuals from minority groups, indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the strictest confidence.

UNDP does not tolerate sexual exploitation and abuse, any kind of harassment, including sexual harassment, and discrimination. All selected candidates will, therefore, undergo rigorous reference and background checks.


If you are experiencing difficulties with online job applications, please contact erecruit.helpdesk@undp.org.

© 2016 United Nations Development Programme