Background
As part of its 10-point Economic Agenda from 2016-2022, the new Duterte administration targets to spend 5-7% of GDP on infrastructure. In line with this, there are several nationwide infrastructure programmes that are currently being implemented to deliver basic services to local communities. These programmes include the Department of the Interior and Local Government’s (DILG's) Assistance to Municipalities (AM) programme that is constructing evacuation centres, water and sanitation facilities, and roads for local communities; the Conditional Matching Grant to Provinces (CMGP) that is repairing and rehabilitating roads in provinces; and the Department of Education's (DepEd) K to 12 computerisation programme that is delivering IT equipment and solar panels to elementary schools. The Pipol Konek programme, led by the Department of Information and Communication Technology (DICT), is also providing free public Wi-Fi hotspots across the country.
NATIONAL PROGRAMME | GOVERNMENT AGENCY | DESCRIPTION |
K to 12 Computerisation Programme |
DEPED | Deliver computer equipment and solar panels to schools across the country. |
Assistance to Disadvantaged Municipalities. |
DILG | Which constructs evacuation centres, roads, and water facilities in over 1,300 municipalities. |
Conditional Matching Grant for Provinces. |
DILG | Repair and Rehabilitation of roads in 78 provinces. |
Pipol Konek |
DICT | Providing free public Wi-Fi to 6,000 sites across the country. |
To ensure that corruption is mitigated in these initiatives, UNDP has launched the project entitled “Development LIVE: Developing Infrastructure through Local Integrity, Innovation & Citizen Empowerment." Development LIVE is essentially an online data capture and visualisation platform that will allow citizens to upload their monitoring reports and live stream their monitoring activities online for public viewing and allow government personnel to respond to issues raised by the citizen reports to fast track project implementation. On the app itself will be a simple feedback survey for an everyday citizen to complete, as well as a technical feedback survey for qualified personnel (i.e. civil engineers) or trained CSOs to report on.
The development of the system has been ongoing since November 2017. There is now a need to enter phase 2.0 of the system to ensure the enhancement of features and customization for new projects. The current features of the web app are attached for reference.
Institutional Arrangements
For the duration of the contract, the Consultant shall report to the UNDP Philippines Data Group through the Institutions and Partnerships (I&P) Outcome Team, and in close coordination with the respective project managers of UNDP-DILG, and UNDP-DICT, in the delivery of the terms of reference. Reporting is output-based and all deliverables must be submitted to UNDP-I&P. Similarly, the final outputs should be formally accepted by the Outcome Lead of I&P, UNDP Philippines before any payment is made.
The contractor shall attend physical meetings twice a month, or as needed, in Metro Manila with UNDP and / or government partners, with travel costs built into the contract. The contractor shall coordinate with the Senior Software Developer for the Mobile Application to address issues and synchronize the development, pilot testing, and formulation of the software guides/user guides.
The contractor shall participate in at least four (4) training programmes in selected areas (Lanao del Sur, Palawan and Baguio), of three (3) days each, with travel costs (plane fare, meals, accommodation and transportation) built into the contract.
Duration of Work, Duty Station, and Travel
To undertake the tasks, procedures, and expected outputs, the Consultant shall be engaged for 200 man-days for 10 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 March 02, 2020 and the expected completion date is December 01, 2020.
The position will be based in Manila to allow accessibility and availability for discussions and reporting on the progress of activities as may be required by the UNDP. Though the consultant will not be required to report regularly at the Country Office but shall agree with the UNDP I&P Team Leader on a regular schedule to report on the status and provide feedback on the outputs.
Scope of Price Proposal and Schedule of Payments
The Consultant should send a financial proposal based on a lump-sum amount for the delivery of the outputs identified below. The total amount quoted shall include all costs components required to deliver the goods and services identified above, including professional fees and any other applicable costs (i.e., transportation/travel to and from residence for meetings and activities in areas mentioned in the previous sections, supplies, and materials, communications, etc.) to be incurred by the Consultant in completing the assignment.
The contract price will be a fixed output-based price. Any deviations from the outputs and timelines will need to be agreed upon between the Consultant and UNDP. Travel shall be included in the financial proposal, consistent with the areas mentioned in the previous sections.
Payments will be done upon satisfactory completion of the deliverables by target due dates. Outputs will be reviewed and certified by the Outcome Lead, I&P Team, UNDP prior to the release of payments.
Deliverables | Due Date |
10% Upon submission and approval of a proposed workplan and the inception reports for the four national programmes | March 17, 2020 |
30% Upon submission and acceptance of the progress report, including the enhanced prototype of the DevLIVE web app | May 17, 2020 |
30% Upon submission and acceptance of the progress report, including the final DevLIVE web app | October 17, 2020 |
30% Upon submission and acceptance of User’s Manual, Software/Technical Documentation, and conduct of User Acceptance Testing | November 20, 2020 |
Duties and Responsibilities
To achieve the above objectives, UNDP Philippines requires the services of a qualified Senior Software Developer for the following tasks, in coordination with the Software Developer for the Mobile Application and the UNDP Philippines Data Group led by the Institutions and Partnerships (I&P) Team:
- Review the current system design and infrastructure of the DevLIVE;
- Enhance the web application customized for four (4) national programmes, which includes but not limited to the following upgrades:
Item | Description |
System Architecture | Architectural design, information flow, institutional arrangements, and process design. |
Data compatibility | The system should be able to receive data formats from the mobile app. Capture and upload images on mobile applications. Uploading of images with geotagging capability. Reporter can load and save data of their reports from different projects. |
Project Administrator Access | The Project Administrator can log in to web admin console using email and password. |
Project Management | Project Administrators can add, modify or view project information (For DepEd, these are schools). |
Monitoring Form Encoding | Encode monitoring forms. |
Basic Data Visualization | Project Administrator can view data pertaining to readiness, delivery, installation and report cards in table format. The system should be capable to translate raw data gathered from mobile app to visual representations such as charts, graphs, histograms, etc. for the viewers to easily understand the information. |
User's Access Level | Project Administrator can filter data reports by level (national, regional, provincial, municipal, and project/site) and attributes/indicators. |
Basic Map Visualization | Project Administrator can view project information (i.e. project type, by survey questions showing the answers in percentage, etc.) on a GIS Interactive Map. |
Basic User Management | Project Administrator can create, read, update, and deactivate users. |
Project Status | Support Multi Project Status |
Monitoring Form Dependency with Project Status | The monitoring form should have a dependency on project status. |
Reporter Group Admin Access | Reporter Group Administrator can log in to web admin console using username and password |
Reporter Group Code Management | Project Administrator can create, update, and delete reporter group code |
Server Setup | Assist in setting up servers and necessary IT equipment for a testing environment and for turn-over purposes. |
Government dashboards | Reports from transmitted responses from monitoring form should be displayed on Dashboards. |
Social Media Sharing Post | Reporters can share posts on Facebook Twitter and Instagram. |
Response Validation | Reporter Group Administrator can view and change the status of incoming responses |
Change User Roles | Change Reporter Role to CSO Reporter and Reporter Group Administrator to CSO Administrator |
Support LGU Reporter Role | Add LGU Reporter role for LGU reporting module |
Support Validator Role | Add Validator role for LGU reporting module |
Support Registered User Role | Default user role from mobile application should be registered user. |
Import Projects (for all the national programmes) | Import projects from excel or CSV files provided by the government and by the national programme (i.e. DILG, contractor’s master list of final sites, among others). The system should also import and integrate datasets in KML/KMZ formats. |
Reporter and Validators Project List | LGU Users can view the list of projects assigned based on their access level |
LGU Reporting Form Encoding | Encode LGU reporting form on the google form. |
LGU Reporting Form Rendering | Render encoded LGU reporting form on the web console. |
Submission of LGU Report | LGU reporter can submit reports from the web console. |
Requesting to reopen LGU Report | LGU reporter can request to reopen report to Validator/MLGOO |
Requesting to revise LGU Report | Validator/MLGOO can request to revise the report to LGU reporter. |
Reopening of LGU Report | Validator/MLGOO can reopen report for LGU reporter. |
Passing of LGU Report | Validator/MLGOO can pass the submitted LGU report. |
DILG Dashboard: Project Type Report | The dashboard should have a Project Type Report |
DILG Dashboard: Financial Report | The dashboard should have a Financial Report |
DILG Dashboard: Physical Implementation Report | The dashboard should have a Physical Implementation Status Report |
DILG Dashboard: Time Series Data | Data on the dashboard should be in time series. |
SDG's Data | Mockup data for SDG's integration |
Citizen Dashboard | Mockup data for Usefulness, Timeliness and Quality Citizen Feedback |
Project Report Timeline | The project report should be viewable in a timeline format. |
Improve User Management | Improvement of user management for DILG users |
PSGC Code update | Update current data of the region, province, municipality and barangay |
Cross-Region Analysis | Admins can do cross analyzation by region with allocation and implementation datasets |
Citizen Feedback Pointing System | Support pointing system for citizen feedback form. Based on number of points from report flagging identify projects color scheme |
Feedback Filtering of Points | Feedback can be filterable by points accumulated in mobile application |
Data import | Import 2018 projects and users for beta testing |
Partial UI Implementation | Implement a new Logo and Color scheme provided by UNDP |
Basic Tracking using Google Analytics | Implement tracking activity using google analytics |
Flagging System | Support flagging rules of Citizen Feedbacking |
New UI Implementation | Implement new layout provided by UNDP |
LGU Reporting form adjustments | Adjust LGU reporter forms based on beta testing feedback |
Enhance Rendering of LGU Reporting form | Enhance rendering of LGU Reporting form from beta testing feedback. |
Fix Submission of Report | Prevent Duplicate of passing reports. Prevent the selection of radio buttons using the arrow down key. |
Enhance LGU Reporting | Add loader in the reporting page. Add Latitude and Longitude Validator |
Enhance DepEd's Dashboard | Adjust displayed data coming from sent CSO monitoring |
Security | Security: 3rd Party Security Audit and Fixes |
Exporting of reports in image format | Users can export reports (maps, charts, table lists) saved as an image |
Exporting of reports in CSV format | Users can export reports (charts, table lists) saved as CSV |
Exporting of reports in KML and Shapefile format | Users can export reports as Google Earth KML/KMZ and GIS shapefiles |
Monitoring Form Submission | CSO Reporter can submit monitoring forms from their mobile application |
Flagging System Implementation | Support flagging rules of reporting |
Uploading of KML file | The administrator can upload a KML file to the system. |
Displaying of uploaded KML file in the web console | Uploaded KML file will be shown through Google maps |
Accountable Government Personnel Management | The administrator will able to set who will be accountable personnel per level. |
Heat Map/ Hotspot Analysis | Users can view a heat map regarding the status of a particular program. |
Sending of alerts using the mobile application | Mobile application user will able to send alerts to accountable personnel |
Sending of alerts from the web console | Web console user will able to send alerts to accountable personnel |
Tracking of alerts | Users will able to track the status of sent alerts whether or not the concerned government agency has taken steps to address reports. |
Receiving of alerts via push notification | Government personnel will able to receive an alert from mobile and web console depending on their level. |
Citizen Dashboard | Citizen dashboard containing comments and status of sent alerts. |
Public Dashboard | The General Public can view information about various projects represented via charts, maps, etc. |
Map Visualization | The General Public can view projects in google map (street and aerial). |
Login and Registration | The General Public can register and login into the public portal. |
Viewing of project details | The General Public can view information about various projects. |
Citizen Comments | The General Public can post their opinion regarding the projects |
Server Setup | Setting up the server for the public portal. |
Uploading of document files | Website Administrator can upload resource files(e.g. PDF, Word Docs, Video files) |
Downloading of project resources | The General Public can view resources (i.e PDF, Word, Video files, KML/KMZ, Excel, CSV, JSON, Image (JPG, TIFF), PDF, among others) uploaded by a Website Administrator without logging in. |
Reporter Gaining Points | The reporter can gain points, badges and increase levels as they are contributing reports to the project |
Level Management | The Project Administrator can set up and management levels. |
Badge Management | The Project Administrator can set up and manage badges. |
Reward Management | The Project Administrator can set up and manage rewards. |
Post-Construction Technical Support | The team will focus on fixing issues and optimization found within the original scope of the project. |
System Requirements | Should be compatible with the following browsers: Google Chrome, Mozilla, Internet Explorer; Should be compatible with Windows Operating Systems: Windows 7,8,9,10; Should be compatible with HTML 5. |
- Ensure that the application is built using an open-source program and the user interface is dynamic enough for administrators to simply modify, add and customize to fit in future requirements of the program.
- Document the solution architecture and schema as well as the user’s manual;
- Provide training to UNDP and government partners on the use of the application;
- Provide inputs to crafting instructional videos, if the need arise; and
Serve as a resource person in activities identified by the national programme such as orientations, pilot testing, demonstration, etc.
Competencies
Corporate Competencies
- 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
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;
- 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 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
Offers will be evaluated based on the combined scoring method :
- Technical qualifications = 70%
- Financial Proposal = 30%
For the evaluation of the Technical Proposal, the selection of the successful consultant must be based in the following qualifications (with the appropriate obtainable points):
Qualifications | Points Obtainable (100) |
Education
|
20 |
Experience |
|
| 30 |
|
30 |
| 20 |
TOTAL | 100 |
Applicants who will only receive 70 points from the assessment of the CV and two (2) sample Portfolios of related communications work will be qualified for the assessment of the Financial Proposal.
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 Insterest and Availability for the IC by clicking on this link: http://gofile.me/6xdJm/bE9TCw8fU
- Duly accomplished Offeror's Letter to UNDP Confirming Insterest 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;
- Financial Proposal (Annex 2 of Offeror's Letter to UNDP Confirming Insterest and Availability)
- 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;
In view of the volume of applications UNDP receives, only shortlisted offerors will be notified.