Review and rectification of GCF results and project management data and development of GCF portfolio data catalogue

The Green Climate Fund (GCF) has contracted AAE toreview, validate, construct, and or rectify the GCF’s results and project management related data for both Funded Activities (FA) and Readiness programme (currently stored in various formats) and deliver an updated clean version of the portfolio datasets along with an organized inventory of FA and Readiness programme data assets to enable the GCF to migrate all data into one depository location, namely integrated portfolio management system (iPMS).

Our team of experts has been assisting the GCF during the last two years on an independent results analysis achieved in the framework of the Readiness Programme. Now the GCF is integrating a tool that will improve the management of the data from its portfolio of both FAs and Readiness Programmes. As AAE has been closely working for the GCF to collect this data, it is now in charge of reviewing and rectifying the data converted by their tool. The project has two clear phases: Phase I applies to FAs and Phase II to the Readiness Programmes. Our team of experts combines professionals of monitoring and evaluation, finance, computer science and strategic planning. AAE will help the GCF to have a clean and organized dataset that will ensure the proper monitoring for the coming years and therefore, help them adequately measure the impact of the climate finance provided by the Fund.

Main activities

• Review the key results and project management related data stored in various formats against project/programme documents
• Validate the accuracy and completeness of the existing results and project management related datasets for both FAs and readiness grants in the original data formats and rectifying incorrect data to deliver an updated clean version
• Convert data points that are stored in PDF or MS Word format (i.e. legal agreements) to construct datasets in MS Excel or comma- separated values (CSV) format to enable immediate transfer of the datasets into iPMS
• Create a data catalog - an organized inventory of FA and readiness portfolio data assets which lists every data variable available from all clean/updated or constructed datasets as per the above

Main outputs

• Deliverable 1: Clean and rectified expenditure dataset. Summary report
• Deliverable 2: Newly constructed dataset of FA implementation-related schedules conditions and covenants
• Deliverable 3: Completion of missing data and data rectification (data re-entry) in iPMS∙ Summary report
• Deliverable 4: Reformatted readiness results dataset(s) against RRMF output indicators and reviewed and rectified keywords tagged to each readiness grant
• Deliverable 5: Constructed datasets (in MS Excel or CSV format) of readiness grants related schedules and a list of readiness grants categorized by logframe version.
• Deliverable 6: Completion missing data and or data rectification (data re-entry) in Fluxx to produce Excel based dataset that can be easily transferred to iPMS
• Deliverable 7: Completed FA and readiness data catalog