Detalle de oportunidad

DETALLE DE OPORTUNIDAD

Servicios de consultoría para Sistemas de Información de Gestión.

REQUEST FOR EXPRESSIONS OF INTEREST

(CONSULTING SERVICES – FIRM SELECTION)

 

 

INDONESIAN ENVIRONMENT FUND TECHNICAL ASSISTANCE PROJECT

Grant No.: TF0B5967

 

Assignment Title: Management Information Systems

Reference No.: ID-BLU BPDLH-245689-CS-QCBS

 

The Indonesia Environment Fund (Badan Pengelola Dana Lingkiungan Hidup, IEF) has received financing from the World Bank for the Indonesian Environment Fund Technical Assistance Project, and intends to proceed with consulting services, namely for Management Information Systems.

The consulting services (“the Services”) will be provided by a Management Information Systems Consulting Firm to support the IEF. The broad scope of work includes developing a high quality and tailored Management Information System (MIS) that supports the IEF to collect, manage and share data on its projects and programs and includes an M&E module to effectively support IEF’s M&E framework. Currently, the IEF has a specific system for revolving funds and uses a basic system with laptops, internet, and email. To ensure the IEF is able to manage a broader range of environmental and climate funds effectively and to track the funds from source to beneficiaries, a credible management information system is required.

The activity will be based mainly in Jakarta, Indonesia until December 2023. The detailed Terms of Reference (TOR) for the assignment are attached in Annex of this Request for Expression of Interest.

 

The IEF now invites eligible consulting firms (“Consultants”) to indicate their interest in providing the Services. Interested Consultants should provide information demonstrating that they have the required qualifications and relevant experience to perform the Services. Interested consultants must provide sufficient description of similar assignments (including location/country, name of the Employer/Client, type of services provided, period of contract, contract amount, starting and completion dates), and availability of appropriate skills among permanent staff, etc. The shortlisting criteria are:

  1. The firm should have at least 5 years of experience in working on the field of Management Information Systems (MIS) and similar systems.
  2. Solid Experience in MIS analysis, design, development, and support for system with high- volume transactions and/or data,
  3. Experience in development and implementation of various disciplines of large-scale bespoke and/or COTS (Commercial Off The Shelf) information systems,
  4. Experience in executing at least three complex enterprise-grade projects,
  5. Experience in developing and implementing complex web-based information systems,
  6. Sufficient professional expertise in developing M&E systems, including staff with experience in developing M&E systems,
  7. Adequate Financial Capacity: Proven financial capacity with total average annual consulting services turnover of minimum: US$ 308,144, calculated as total certified payments received for consulting services contracts in progress and/or completed within the last three (3) years, divided by three (3) years.

Key Experts will not be evaluated at the shortlisting stage.

 

The attention of interested Consultants is drawn to Section III, paragraphs, 3.14, 3.16, and 3.17 of the World Bank’s “Procurement Regulations for IPF Borrowers” November 2020 (“Procurement Regulations”), setting forth the World Bank’s policy on conflict of interest.

 

Consultants may associate with other firms to enhance their qualifications in the form of a joint venture or a sub-consultancy. In case of an association, the EOI must explicitly specify whether the association is in the form of a Joint Venture (all members shall be jointly and severally liable for the entire assignment), or Sub-consultancy. In the case of a joint venture, the member firm appointed to represent the joint venture must be clearly identified and all the partners in the joint venture shall be jointly and severally liable for the entire contract, if selected. Only the qualifications and experience of members of joint venture, but not of sub-consultants, shall be considered in the EOI evaluation process.

 

A Consultant will be selected in accordance with the Quality and Cost-Based Selection (QCBS) method set out in the Procurement Regulations.

Further information can be obtained at the address below during office hours

08.00 – 16.30 WIB.

Expressions of interest must be delivered in a written form to the address below (in person, or by mail, or by fax, or by e-mail) by June 14, 2022.

 

 

Wisma Antara Building, 14th Floor

Indonesia Environment Fund (BPDLH)

St. Medan Merdeka Sel. No.17, RT.11/RW.2, Gambir,

Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus

Ibukota Jakarta 10110

Website             : bpdlh.id

E-mail                : procurement.wb@bpdlh.id

Telp/fax             :  (+62 21) 3449230, 3864786 / (+62 21) 34834821

 

 

 

 

 

Annex A

Terms of Reference (TOR)

Consultancy Firm for the Design, Development and Commissioning of a Management Information System (MIS) to Support Monitoring & Evaluation (M&E) for the Indonesian Environment Fund (IEF)

 

 

 

  1. Background

Indonesia is the sixth largest greenhouse gas (GHG) emitter globally[1] and deforestation and forest degradation constitutes 53 percent of national GHG emissions[2]. The Government of Indonesia (GOI) has made ambitious international commitments to reduce its GHG emissions, recognizing that land use and forestry sectors are the primary sources of emissions. At the Conference of Parties meeting in Paris in 2015, the GOI pledged through its Nationally Determined Contribution (NDC) to reduce GHG emissions by 41 percent by 2030 with international assistance (29 percent with its own resources) relative to a business-as-usual (BAU) scenario.

To deliver against the GoI’s ambitious and long-standing sustainable development and green finance commitments, the GOI launched the Indonesian Environment Fund (IEF, or Badan Pengelola Dana Lingkungan Hidup (BPDLH)) through Minister of Finance Regulation No. 137/2019 in October 2019. The IEF which is under the Ministry of Finance (MoF), has an objective to increase the level of green finance in Indonesia and will become the official mechanism to manage and coordinate environmental and climate funds including from international sources

The IEF has a mandate to manage funds that contribute to improving the environment and cover green investment in sectors including forestry, energy and mineral resources, industry, transportation, agriculture, marine affairs and fisheries. The IEF is led by an Executive Director with oversight from a Steering Committee chaired by the Coordinating Ministry of Economic Affairs (CMEA) with key involvement of the Ministry of Environment and Forestry (MoEF). Although the IEF is situated under DG Treasury of MoF, it is expected to work with several line-ministries with mandates related to environment issues, subnational governments, civil society organizations, and local communities.

  1. Overview of IEF Operations

All potential funders expect the IEF to be able to do 2 things:

  1. Track the funds from source to beneficiaries; and
  2. Report what the funding has achieved.

IEF is establishing systems that will manage and monitor the sources and uses of funds as depicted in the diagram below:

 

Regarding the use of funds, the fund distribution scheme for IEF programs is shown below, where:

  1. IEF manages programs through direct funding for beneficiaries and indirect funding for intermediary agencies
  2. IEF issues calls for proposals  for programs to be implemented through intermediary agencies. Proposals are processed and evaluated by IEF’s Proposal Evaluation team.

   

The program cycle consists of the following key steps::

  1. Funding proposal management:
    1. Calls for proposals and submission of proposals
    2. Proposal evaluation and award of contract
  2. Disbursement of funds
  3. Program implementation and activity reporting
  4. Monitoring and evaluation and coaching
  5. Program closing

 

  1. Approach and Objective

The IEF has defined its monitoring and evaluation framework to measure its success in achieving its objectives as shown in the diagram below.

 

The IEF beneficiaries (benefit intermediaries or intermediary agencies) are expected to track and report on the results of the projects they receive funding for, and with the IEF aggregating the results to provide an overall picture of how the IEF is supporting Indonesia to achieve its environmental and climate objectives.

The objective of this assignment is to develop a high quality and tailored Management Information System (MIS) that supports the IEF to collect, manage and share data on its projects and programs and includes an M&E module to effectively support IEF’s M&E system as defined and implemented through the framework depicted above. Currently, the IEF has a specific system for revolving funds and uses a basic system with laptops, internet, and email. To ensure the IEF is able to manage a broader range of environmental and climate funds effectively and to track the funds from source to beneficiaries, a credible information system is required. The IEF therefore seeks to commission the design and implementation of a Management Information System (MIS), IT Roadmap and M&E system.

In the long run, it is expected that the MIS can accommodate blockchain-backed media storage of transaction data, data exchange system supported by digital certificates that is integrated with the management system of environmental funds.

The IEF is seeking the services of a consulting service firm, hereinafter referred to as “the Consultant”, to provide consultancy services for the design, testing and commissioning of a Management Information System (MIS) for the IEF which includes the design and delivery of a credible and high quality M&E module to support the IEF’s M&E system and framework.

  1. Expected Scope of the IEF MIS

The MIS will need to support multiple IEF operations and functions and be an integral part of the IEF’s approach to knowledge management, transparency, and learning. It is anticipated that it will need to consider and capture (at minimum) the following areas depicted in the diagram below:

 

 

  1. Dashboard, providing the tool to present all key M&E information in a single place in an efficient manner, and empower management to make timely and data-driven decisions based on the latest information.
  2. Funding Proposal and Safeguards Management, including tracking and recording proposal submissions, evaluation, and approval, and ensures that project or activity proposals comply with national and international social and environmental safeguards and environmental management standards. It may be linked with the National Registry System (SRN).
    1. IEF’s environmental and social safeguards measures, implementation, and risks to enable effective management of safeguards in IEF operations and programs.
    2. Spatial System: Environment and geographical project data base that is structured to provide information for each funded project, as well as by geographical location.
    3. Environmental and Social Safeguards Screening, which will include risk categorization, where IEF will screen the proposed activity based on the exclusion list and determine the risk of the proposed activity. The safeguards risk rating should be categorized as Low, Medium, and High risk. The higher the risk, the more complex the safeguards requirements.
      1. All proposed activities are then reviewed based on safeguards requirements set by IEF. These requirements may vary depending on the risk category. The review process will include among others:
  • Fulfilment of legally valid safeguards document and permits
  • Assessment on the proposed Environmental and Social Management Plan (including impact management measures, monitoring plan, institutional arrangements, capacity building plan, and budget estimation)
  • Assessment on Grantee's or Intermediary Agencies' organization system, capacity, and competency for managing E&S aspects commensurate to the risks and impacts
  • Audit for current environmental and safeguards practices
  • Corrective Action Plan requirements. 
      1. This will also allow disclosure of related project’s safeguards documents upon IEF’s clearance.
      2. This safeguards screening process will be guided by IEF’s Environmental and Social Safeguards Specialists and Communication Engagement Strategy Specialist.
  1. Collateral Management, which will record, assess, evaluate, revalue, and manage collateral of beneficiaries from the proposal evaluation to project execution stages.
  2. Funds Management consisting of:
    1. Fund raising from multiple sources, with the system capturing:
      1. Funds from the State Budget, development partners, private sector, and/or other parties concerned with environmental issues.
      2. Different types of revenues, including, grants, fees, penalties, loans.
    2. Fund distribution, including fund flows from the IEF to the recipient, either directly to the beneficiaries, or to benefit intermediaries via a trustee bank. All transfers will be based on contracts between IEF and recipient/ intermediary. Each contract will include, at minimum: the amount, eligibility criteria, requirements prior to transfer, reporting requirement, role and responsibility of each party, M&E.
    3. Fund execution, for funds executed by IEF (e.g., grants from donors).
    4. Fund leveraging / accumulation for undistributed funds in the relevant year. The IEF can (based on contractual agreement) place undistributed funds in an investment instrument in order to optimize idle cash.
    5. Funds reporting, for reporting and/or extracting information on:
      1. The use of funds by the recipients by various categories such as per activity/project component noted in the contracts and other categories/classifications;
      2. Various aspects of funding such as, but not limited to, per funding source: funds received by BPDLH, funds disbursed by BPDLH to recipients, the use of funds reported by the recipient to BPDLH
  3. Loan Management, comprising of a solution that automates and manages the end-to-end steps in the loan process.
  4. E-Procurement and Vendor and Contract Management which consist of:
    1.  E-Procurement where goods and services may be procured for IEF’s own needs, or as part of the IEF providing an in-kind grant to beneficiaries.
    2. Vendor and Contract management to support vendor and contract management, contract lifecycle management, including contract payments processed through Financial Management.
  5. Financial Management to ensure that the IEF records all transactions as per accounting policies and standards. The accounting of IEF shall be linked to the MoF financial management systems such as SAKTI, SAIBA, SPAN, ATAP (revolving fund application system), E DIPA, etc. It will be not only for program funds but also for the revolving fund mechanism.
    1. Budgeting. For preparing and managing annual budgets and implementing budgetary control.
    2. Purchasing. Manages IEF’s purchases and contractual commitments.
    3. Payment Management. Manages all payments by IEF (payables).
    4. Receipts Management. Manages all receipts by IEF (receivables).
    5. Cash Management. Manages cash projections and cash flow.
    6. Accounting and Financial Reporting. Consists of the processes and procedures needed to prepare and generate fiduciary and financial reports as will be required by management and applicable regulations.
    7. Reconciliation, the process of matching transactions that have been recorded internally against monthly statements or other data from external sources to see if there are differences in the records and to correct any discrepancies.
  6. Human Resources & Payroll. To manage IEF human resources and payroll.
  7. M&E (Monitoring & Evaluation) to provide support for comprehensive monitoring and evaluation and results management, including:
    1. Recording project monitoring and results data produced by benefit intermediaries or beneficiaries at project start, annually, and at project closure based on agreed templates.
    2. The data should be recorded in a format that allows for annual aggregation to support IEF’s accountability and learning objectives.
    3. The data should also provide support to monitor environmental and social performance. The support to monitor environment and social performance will focus on the achievement of sustainable development goals related to environment and social safeguards aspects which are supported by the distribution of funds from IEF to benefit intermediaries or beneficiaries within the projects. Requirements include but are not limited to:
      • Implementation of safeguards measures must be recorded and reported to ensure compliance and effectiveness. IEF’s partners and beneficiaries are obliged to submit periodical implementation progress reports as well as fund utilization to IEF. Additionally, IEF will carry out periodical monitoring and evaluation on the implementation.
      • IEF will carry out assessment and management, monitoring, and annual review of the overall environmental and social risks and impacts of IEF activities and the portfolio. The project’s implementation report will be compiled and evaluated by IEF to assess the achievement of the IEF objectives.
      • IEF will utilize the MIS data to do monitoring and evaluation on environmental investment progress status both in term of result achievement and fund utilization.
      • The safeguards monitoring and evaluation process will be guided by IEF’s environmental and social safeguards specialists, communication engagement strategy specialist, and monitoring and evaluation specialists.
    4. Governance, including recording management information and decisions for all parts of the IEF’s governance system, including steering committee decisions; audit decisions; donor correspondence and any actions taken.
    5. Issues & Findings Monitoring, allows relevant parties in charge for the follow up action to input the actions and its resolution progress status.
    6. Feedback and Grievance Redress Mechanism, facilitates inputs of inputs of feedback and grievance from the public and track the status of the grievance redress process.
  8. Other supporting systems consist of, but may not be limited to:
    1. Knowledge Center of IEF. The section will contain IEF news, activities, reports, and publication as well as regulations.
    2. Internal Audit section will include the report of any audit or assessment of IEF.
  1. Expected scope of the M&E System to be supported by the MIS

To operate as a credible Environmental Funds Management Agency, the IEF needs a world class M&E system that is able to track and report results from project start to closure. The IEF has a Theory of Change that sets out how the IEF will achieve its objectives. This forms the foundations for the IEF’s approach to results and M&E. Each IEF funded project must report on results annually, against project specific core indicators and custom indicators that are informed by the Theory of Change. The reporting is done by the IEF beneficiaries or benefit intermediaries, and the IEF aggregates these results across the programs. Each program must use standardized templates.

 

Once the M&E system is fully conceptualized, and articulated, it should be translated into an information system design within the M&E module of the MIS.

  1. MIS Specification of Work

Features and Requirements from the MIS

No

Type of Work

Component

Requirements

1

Expected number of users (for determination of software licenses and workload estimates for capacity planning)

 

Module

User Types

Total

Named/Per Seat

Concurrent

Operational

Key Stakeholders

Public Access

Funding Proposal and Safeguards Management

130

 

 

130

Collateral Management

30

 

 

30

Funds Management

30

 

 

30

Loan Management

130

 

 

130

e-Procurement, Vendor, and Contract Management

130

 

 

130

Financial Management

10

 

 

10

Human Resources

130

 

 

130

M&E

130

 

 

130

Other supporting systems

30

 

 

30

Total

130

 

 

130

 

 

2

After the M&E System is designed,  translate it into an Information System Design for the M&E module of the MIS

  1. Translate the Theory of Change and results framework into information system design
  2. Design of data sources and reporting on performance indicators
  3. Feedback to the Theory of Change and results framework as required based on inputs from their applicability to the information system design of the M&E module of the MIS

The M&E System must fit with the IEF objectives and be integrated in the MIS through its M&E module. The MIS application must be able to be linked to other relevant systems

3

Design, Development and Commissioning of the MIS to support operations of IEF (including the M&E module)

  1. Analysis & Design of a web-based MIS
  2. Development & Testing/Quality Assurance of the web-based MIS
  3. Go-live

The MIS should satisfy the following inherent features:

  1. Paperless, electronic, and web-based solution
  2. Cost-efficient. It’s preferable to use high-performing open source solutions with licenses and adequate support for the development of its application, middleware, and database systems, or a combination of COTS (Commercial Off The Shelf) and open source solutions to deliver a robust and reliable MIS for IEF.
  3. High scalability
  4. Modular (if deemed appropriate)
  5. High user-friendliness and operationality. The MIS shall be accessible via a browser using internet protocols to allow key users to have access to the system and documents at any time. User can also access it through smart gadgets (smart phones, tablets, etc.)
  6. The system and database can accommodate geographical and spatial data.
  7. Complete system documentation.
  8. Interconnection capability (future) with other institutions’ information systems
  9. Enable e-signatures
  10. Incorporate a Document Repository and Management System which allows for easy coding, uploading, safekeeping, sharing, processing and retrieval, amongst others, of data and information relating to the day-to-day operations
  11. The MIS should enable various types of documents such as text, spreadsheets and presentations to be managed (created, edited, updated, shared, emailed, transferred, deleted etc.) in a paperless, integrated and user-friendly manner.
  12. The MIS shall provide sufficient security to keep all information confidential and accessible to privileged users only as controlled and configured by the systems admin. In this respect, a suitable Information Security Management System (ISMS) (based on ISO 27001 information security guideline) should therefore form integral part of the MIS and the solution proposed
  13. The MIS shall be effectively secured to prevent possible fraudulent access and software attack. Minimum physical protection should include surge protectors, UPS backup and redundancies.
  14. Minimum software level protection should include latest Antivirus incorporating anti-spyware, ransomware and other malwares.
  15. The Consultant shall handover to IEF the final product, source code and all system documentation.

4

Capacity Building which covers Support/Training to users at IEF and related ministries/agencies.

  1. User Manual and Maintenance & Troubleshooting Manual.
  2. Training for key users from IEF and related ministries/agencies (max 3 batches with max 35 participants each batch).

 

        1. The MIS shall be equipped with a fully-fledged manuals and training kit that includes support information to assist users to use the system effectively.
        2. The MIS manuals and training kit should be in Bahasa Indonesia and available in printed and softcopy versions.
        3. The Consultant will provide the training materials and trainers during the training. Participants should provide travel, accommodation, equipment  (laptops/notebooks), and other costs as required.

 

The Consultant should submit additional staffing requirements for the MIS operations and assistance in the drafting of TOR(s) (roles and responsibilities) for any future MIS staff to be recruited, as required.

5

System Maintenance

        1. Software maintenance
        2. Database maintenance
        3. Operational maintenance

The MIS must be run during the course of the assignment without major disruption at all times. Should there any changes required due to changes in policies/regulations, the changes must be done less than one month after the instruction from IEF to the Consultant unless the changes are substantial.

 

  1. MIS Modules to be developed

The proposed application modules and main menus or features required are set out below, with possibility for modification subject to the result of System Analysis and Design done at beginning of the consultancy work:

 

No

Application Modules and Main Menu / Feature

Key Users

Requirement

1

Dashboard

    1. Summary of Results
    2. Summary of Financial Status (Revenue, Funding, etc.)
    3. Summary of Activity Progress
    4. Analysis on key data
    5. Other Management Information
    6. Information for Public

Board of IEF, Steering Committee, Donors, DG Treasury/MOF, relevant Ministries/Agencies, Public

  1. The dashboard should allow management of IEF to read, print, and save the information.
  2. The dashboard uses graphical presentation or other proper method supported by relevant table of data/information.
  3. There will be dashboard for main stakeholders (IEF, relevant ministries/agencies/donors/etc.) and for public which access level to be defined as per relevant regulations.

Funding Proposal and Safeguards Management

2

Proposal Management

 

    1. Proposal Submissions
    2. Proposal Evaluation
    3. Proposal Approval

Beneficiaries, Intermediaries, IEF

The module enables:

  1. Proposal to be submitted to IEF or other institutions (KLHK, Province Govt, etc.)
  2. Proposal submission in electronic format.
  3. Proposal form can be downloaded and filled off-line. The filled in proposal form can be uploaded and submitted directly.
  4. Proposal revision.
  5. Proposed activity must have output and outcome indicator(s) which match with IEF indicator(s)
  6. Proposal evaluation processes for certain aspects to be done by the system which provide the aspects and parameters for the evaluation. The system will compare the data from proposal and the requirement and then provide the evaluation summary. For other aspects (such as qualitative aspect) Evaluator needs to provide judgement.
  7. IEF can receive approved proposal from other agencies to be evaluated for funding decision.

3

Spatial System

IEF,
Intermediaries,

Beneficiaries

The module facilitates management of spatial information, including geographical location, for each funded project

4

Environmental and Social Safeguards Screening

IEF,
Intermediaries,
Custodian Bank,

Beneficiaries

  1. The module provides:
    1. Exclusion list checklist;
    2. categorization of risk rating;
    3. standard safeguards documents and requirements;
    4. Fulfilment of legally valid safeguards document and permits;
    5. IEF’s assessment on the proposed Environmental and Social Management Plan;
    6. IEF’s assessment on Grantees’ or Intermediary Agencies’ organization system, capacity, and competency for managing E&S aspects;
    7. IEF’s audit for current environmental and safeguards practices;
    8. Corrective Action Plan requirements for each proposed activity.
  2. The module connects to module of ‘proposal selection’, ‘M&E’, and ‘information for public’

Collateral Evaluation and Management

5

Collateral Evaluation and Management

Beneficiaries, Intermediaries, IEF

The module facilitates assessment and evaluation of beneficiaries’ collateral during the proposal evaluation process and management and revaluation of the collateral during the project’s lifetime

Funds management

6

Funds Distribution Management

 

6.1 Expenditure / Grant
6.2 Financing / Revolving Fund
6.3 Monitoring on Funding

6.4 Funds Reporting

IEF,
Intermediaries,
Trustee Bank,

Beneficiaries.

 

  1. The module can facilitate fund flows from IEF to the recipient which may go directly to the recipient bank or through intermediary institutions.
  2. The module will manage contract between IEF and recipient/ intermediary. Each contract will include, at minimum: the amount, eligibility criteria, requirements prior to transfer, reporting requirement, role and responsibility of each party, M&E.
  3. The module can facilitate distribution of environmental fund to beneficiaries. For grant it’s done through custodian bank; while for distribution of reforestation fund through revolving fund facility managed by IEF.
  4. Funds reporting, for reporting and/or extracting information on:
    1. The use of funds by the recipients by various categories such as per activity/project component noted in the contracts and other categories/classifications;
    2. Various aspects of funding such as, but not limited to, per funding source: funds received by BPDL, funds disbursed by BPDLH to recipients, the use of funds reported by the recipient to BPDLH

7

Fund Collection

 

    1. Environmental Pollution/Damage Mitigation and Restoration Funds
    2. Trust Fund/ Conservation Grant

IEF
Trustee Bank
 

The module facilitates:

  1. IEF in receiving funds from State Budget, donor countries/ institution, private sector, and/or other parties concerned with environmental issues.
  2. IEF in collecting a) mitigation for environment pollution and/or damage and rehabilitation fund, and b) trust fund/conservation support fund.

8

Fund Nurturing

 

    1. Fund Investment Plan
    2. Investment Monitoring

IEF
Trustee Bank

The module facilitates:

  1. The estimation and calculation of undistributed fund in the relevant year,
  2. Placement of the undistributed fund in the relevant year in an investment instrument.  Investment can be short term or long term in banking instruments, stock market instruments and other eligible financial instruments.
  3. Investment performance monitoring.

Loan Management

9

Loan Management

IEF
Trustee Bank

The module facilitates:

  1. Management of the end-to-end steps in the loan process – from the application, verification, approval, documentation, pricing, funding, and administration.
  2. Automation of the entire approved loan lifecycle, including processing customer information, create new loans, accurate statements, reports, manage interest rates, and other tools to generate or export loan data.
  3. Management, monitoring, and control of delinquent loan accounts and automation of collection processes.
  4. Integration with Financial Management

E-Procurement and Vendor and Contract Management

10

E-Procurement

 

The module facilitates:

  1. Preparation of general procurement plans from approved budgets
  2. Preparation of bid/tender packages from the general procurement plans
  3. Invitations to bidders. Bidders are potential and current (awarded) vendors managed through Vendor and Contract Management
  4. Evaluation of bids
  5. Award of bids
  6. Other procurement methods such as direct procurement, auctions, etc.
  7. Integration with Vendor and Contract Management and Financial Management

11

Vendor and Contract Management

 

The module facilitates:

  1. Registration and on-boarding of potential and current vendors
  2. Vendor qualification
  3. Contract initiation
  4. Contract negotiation and approval
  5. Vendor performance analysis
  6. Integration with E-Procurement and Financial Management

Financial Management

12

Financial, Accounting & Asset Management,

 

    1. Budgeting
    2. Purchasing
    3. Payment Management
    4. Receipts Management
    5. Cash Management
    6. Accounting
    7. Financial Reporting

 

 

IEF,

Steering Committee,

Oversight Committee,

Donors,

MOF

The module facilitates:

  1. Budgeting, purchasing (as part of the procurement process), cash projection, revenue, transaction approval, transaction processing, accounting, asset recording, financial reporting and other aspects relate to financial and accounting. Each of the elements can be accounted by source of funds.
  2. Payroll payments (integrated with the HR & Payroll module).
  3. Tax calculation and link to e-filing of tax.
  4. Link to SPAN, SAKTI, ATAP etc. to prevent re-entry of data onto those applications.
  5. The module must comply with relevant accounting standards and FM policies.
  6. Integration with Loan Management, E-Procurement and Vendor and Contract Management, and other modules as required that provide source data for the various financial management functions.

Human Resources & Payroll

13

  • Employee information and statistics including employee capacity
  • Performance
  • Paid Leave
  • Payroll

 

 

IEF

 

The module facilitates:

  1. Recording and management of IEF human resources information and statistics.
  2. Identify and map the capacity of IEF.
  3. Human Resources Planning.
  4. Record the performance for each employee.
  5. Integration with Financial Management.

Monitoring & Evaluation and Results Management

14

Result Management & Monitoring and evaluation

 

    1. Results Framework (Indicators & Targets)
    2. Beneficiaries Result Reporting, Monitoring & Evaluation
    3. IEF Result Reporting, Monitoring & Evaluation

IEF,
Intermediaries,
Beneficiaries.

  1. The module obliges proposal from beneficiary to include proposed output(s) and outcome(s) which refer to certain indicator(s) of IEF.
  2. The module enables Beneficiaries to submit report on progress of activity, output achievement and fund utilization.
  3. The module enables IEF to compile and evaluate the report to assess the achievement of the IEF objectives.
  4. The module enables IEF to do monitoring and evaluation on environmental investment progress status both in term of result achievement and fund utilization.
  5. This module will also include monitoring and evaluation of environmental and safeguards performance:

a) Allow IEF’s partners and beneficiaries to submit periodical implementation progress reports to IEF.

b) Allow IEF to record results of its own periodical monitoring and evaluation on the implementation.

c) Allow IEF to utilize the MIS data to do assessment and management, monitoring, and annual review of the overall environmental and social risks and impacts of IEF activities and the portfolio. The project’s implementation report will be compiled and evaluated by IEF to assess the achievement of the IEF objectives.

  1. The module connects to module of ‘safeguards screening’

 

15

Governance

 

Records management information and decisions for all parts of the IEF’s governance system, including steering committee decisions; audit decisions; donor correspondence and any actions taken

16

Issues & Findings Monitoring

    1. List of Issues / Findings and Follow Up Actions
    2. Summary of Resolution Status

IEF,
Steering Committee,

Oversight Committee.

It allows relevant party in charge for the follow up action to input the actions and its resolution progress status.

 

 

17

Feedback and Grievance Redress Mechanism

 

 

IEF,
Intermediaries,
Custodian Bank,

Beneficiaries,

Public

This module facilitates:

  1. This will allow inputs of feedback and grievance from public.
  2. This will also provide tracking of status for grievance redress process.

This will be guided by IEF’s environmental and social safeguards specialists and communication engagement strategy specialists.

Other Supporting Systems

18

Knowledge Centre

  • Regulations
  • News
  • Publications

 

IEF, Donor, Beneficiaries, Public

The module will need to be updated for every regulation, news, activity, etc.

19

Internal Audit

 

Includes reports of any audits or assessments of IEF

 

  1. Structure and timeline for development of the MIS

It is proposed that the Management Information System (MIS) for the IEF will be developed and implemented using a phased approach. The following 2 phases should be considered:

Phase

Scope

Time

Phase 1

Development and implementation of the main application modules to support IEF key operations and results management (as set out in the scope above).

Jul 2022- Jun 2023

Phase 2

        1. Development and implementation of any additional modules to support environment database consolidation, existing Vendor Management System and e-procurement, contract management, risk management, safeguards screening, audit management, knowledge management, human resources, and other functions of IEF;
        2. Development of feature for electronic approval and signatures.
        3. Development and implementation of geographical information system-based dashboard and environment database,
        4. Strengthen the interlink between IEF MIS with other agencies’ systems.

Jul – Dec 2023

 

  1. Proposed Sequence for development and implementation of the MIS

It is proposed that the MIS be developed and implemented in four stages as follows for each phase above

 

Stage I – System Analysis & Design

 

  1. A thorough review of IEF’s business processes and requirements. This also includes review all relevant regulations and SOPs relate to IEF operations, results, monitoring & evaluation, financial, safeguard, data & information flow;
  2. Review, revision and structuring of the IEF M&E system, Theory of Change, templates, and other related M&E materials prepared by IEF as inputs to the information system design of the M&E module;
  3. Identification of user needs and requirements. This will involve review, discussion, and consultations with key stakeholders, and duly adapted to the agile methodology;
  4. Preparation of feedback to the M&E System materials for improvements/revisions as required based on user needs and requirements and inputs from the M&E System’s applicability to the information system design of the M&E module of the MIS.
  5. Conceptual design of MIS which include but not limited to the following: System architecture, design of application modules, design of database, design of system interfaces, design of reports, etc. The Consultant might use a prototype, conference room pilot (CRP), or other approach to enable easy communication of the proposed solution(s) to the management of IEF.
  6. Capacity plan for the IT infrastructure (servers, storage, networks, etc.) to support and sustain full deployment and operations of the MIS over the next 5 years, including the workload from public access to the Feedback and Grievance Redress Mechanism.

 

Stage II – Software development

 

  1. Development of application and database structure (coding) based on the agile methodology divided into sprints; and approved system design, which is versatile, modular, user-friendly, upgradable, and scalable (amongst others);
  2. Creation of an electronic/web-based Document Repository and Management System (DRMS) as well as setting up of a proprietary File Coding System at IEF;
  3. Up-loading, testing (including system integration tests), and deployment using pipelines;
  4. Completion and presentation of the Phase 1 beta version.

 

Stage III – Operation Manual, UAT
 

  1. Following successful installation, development, and testing of the MIS, a User Acceptance Test (UAT) is to be carried out (either as part of the commissioning or after) and a UAT report submitted for review and approval by the clients;
  2. Submission of a comprehensive Operation and User – Maintenance Manual. The Consultant is expected to submit an Operation and Maintenance Manual for the operation of the overall MIS at IEF.
  3. Submission of a M&E and indicator manuals.

 

Stage IV Launching & Training


The Consultant shall provide training/capacity building to staff of IEF on the use of new software installed for the operationalization of the MIS. This will include a training plan and in-house workshops/ training sessions for key users (staff of IEF and other relevant Ministries/Agencies). The final report on training will include both the training plan as well as contents of the in-house workshops/ training sessions in PowerPoint format and detailed training material in MS-Word format.

  1. Expected Deliverables

The Consultant is expected to submit the following deliverables during the course of the project:

 

    1. A detailed workplan for the development and setting up of the MIS. The Workplan shall consist of the following:
  1. A detailed Gantt chart showing milestones/major deliverables and activities and highlighting the critical path and version number as well as the duration for the assignment and expected start and completion dates;
  2. Project Implementation Methodology;
  3. Schedule, type, and context of consultations with stakeholders (for approval by client)
  4. Any other relevant sections, documents, procedures, processes, literature, and references

 

    1. Upon approval of preliminary design, the Consultant shall submit a detailed design document based on the agile methodology which shall include the following (but not limited to):
      1. Detailed process mapping for IEF towards implementation of the MIS;
      2. Detailed technical design on monitoring & evaluation system, and all materials (including templates),
      3. Detailed design (architecture, layout, content, modules, layers, functionalities etc.) of the proposed MIS;
      4. Detailed formats for user interfaces (data entries and reports);
      5. Detailed mechanism for e-signature to be used on process of approvals, comments, edits / revisions, etc.;
      6. Requirements documentation for hardware, software, co-hosting, and data communication;
      7. Detailed design for security, backups, and continuity plan;
      8. Any other relevant information and details which are pertinent.

 

    1. Based on the approved detailed design of the MIS, the Consultant shall develop and conduct testing & quality assurance on the application, database, and other required systems. The Consultant shall submit a detailed system documentation and report indicating user acceptance.

 

    1. Development of a detailed user-maintenance and operational manual with as-made system layout/schematics and user-maintenance and troubleshooting procedures for the overall MIS.

 

    1. A report on training delivery for key users, training evaluation result and soft copy of training materials.

 

    1. Future IT staffing requirements and draft ToRs explaining the roles & responsibility for future system administrator and technical staff of the MIS.
  1. Submission Procedure

All outputs/deliverables should be submitted to the Project Manager and copied to the CEO of IEF. The team will review all outputs/deliverables and their comments shall be communicated to the consultants within 7 days of submission of the output/deliverable. The consultants will then have to consider and incorporate the comments within a period of 7 days from the date of receipt of comments. The consultants will have to provide for justifications when comments are not incorporated in the output/deliverable.

  1. Delivery and Payment Schedule

Deliverables will be the basis for the payment schedule. All reports will be submitted in draft (for comments) and then final.

 

The Deliverables shall be submitted in electronic format (MS Word, and Pdf versions) to the following recipients. The address for delivery is:

 

Director of Finance, General Affairs and Information Systems, IEF

Email: contact.us@bpdlh.id

 

 

No

Deliverable/Milestone

Payment %

Time Schedule

1

Presentation and Approved Workplan

5%

2 weeks after signing contract

2

Approved detailed analysis and system design and report of the MIS

15%

Wk 12

3

Conceptual design (prototype or CRP version) of the MIS

10 %

Wk 20

4

Beta version of MIS Phase 1 presented

15%

WK 32

5

User Acceptance on final MIS version – User Acceptance Note (Berita Acara Persetujuan Aplikasi MIS);

20%

WK 42

6

Approved Operation and maintenance manual for the MIS; Approved Training Plan

5%

Wk 56

7

Implementation trial and training completion report

10%

Wk 62

8

Completion of assignment – Handover Note (Berita Acara Serah Terima) of MIS application (Phase 1 and Phase 2) including system documentation, source code, database structure, and other related items.

15%

Wk 70

9

Maintenance and support completed

5%

Wk 78

 

  1. The above timeline and schedule of payment are for guidelines only. The consultant might finish the work earlier than the schedule as long as they maintain a high quality of work and will accept full payment of contract amount.
  2. Any problem or delay occurred should be immediately notified to the IEF MIS Project Coordinator. Failure to provide report in a timely manner will be noted in the Contractor performance assessment.
  3. The contractor is fully responsible for all tax associated with this work.
  4. In line with Intellectual Property Rights, the contractor is obligated to use legal or properly licensed software, tools, etc.
  1. Reporting, Presentation, and Language

All project implementation documents such as progress reports, draft project documents, templates (website, MIS), preliminary and intermediate designs, layouts, specification documents etc. shall be submitted in PDF Version, and in hard copy and in soft copy. The soft copy should not be secured with password(s) to allow printing or copy and paste of extract from the reports.

 

The language of the assignment shall be in Bahasa Indonesia and English. All the outputs and deliverables shall be written in Bahasa Indonesia and English language and should be presented in a format acceptable by IEF.

  1. Logistical Arrangements

All transportation costs and administrative costs related to the execution of the assignment are to be borne by IEF. In case any additional workshops/ training sessions have to be organized, all costs will be borne by IEF.

 

  1. Criteria and Requirements for the Consultant

To effectively perform the tasks and achieve the intended goal and objectives the IT Firm is required to have the following qualifications:

  1. Mature in business:
    1. Minimum 5 years of establishment (including parent/group company);
    2. Solid Experience in MIS analysis, design, development, and support:
      1. Experience in development and implementation of various disciplines of large-scale bespoke and/or COTS (Commercial Off The Shelf) information systems,
      2. Experience in executing at least three complex enterprise-grade projects,
      3. Experience in MIS analysis, design, development, and support for system with high-volume transactions and/or data,
      4. Experience in developing and implementing complex web-based information system;
  2. Sufficient professional expertise in developing M&E systems, including staff with experience in developing M&E systems.
  3. Adequate Financial Capacity: Proven financial capacity with total average annual consulting services turnover of minimum: US$308,144, calculated as total certified payments received for consulting services contracts in progress and/or completed within the last three (3) years, divided by three (3) years

 

  1. Key Positions Required

The list of key positions whose CV and experience would be evaluated is as follows:

 

No.

Key Position & Roles

Indicative minimum No. of staff[3]

Desired Minimum Qualification and Professional Experience

1

Project Manager

Lead the whole process, solve any problems/issues, manage the MIS consulting team and its performance, manage the project administration, support for capacity building, advice the best course of action plan considering current and future technology available as well as become the focal point.

1

Bachelor’s Degree in computer science / computer management / other related discipline with about minimum 8 years’ experience in IT industry. About 3 years’ experience in web-based MIS development. Skills: IT project management, identification of system and user requirements, identification of IT solutions, applications integration, open source, and IT quality assurance, portal / web design, MIS project Implementation, and handle a small team of about 10 people.

National and International certification in relevant field(s) preferred.

2

Scrum Master

Lead the agile development processes,  skillfully removes obstacles and distractions that may impede the team from meeting goals. This individual is the liaison between the Scrum team and people or teams outside the Scrum team.

2

Bachelor’s Degree in computer science / computer management / other related discipline with about minimum 5 years’ experience in IT industry. About 3 years’ experience in agile development. Skills: Scrum Master.

National and International certification in relevant field(s) preferred.

3

Business Analyst / Information System Analyst

Identify user requirement on information, educate high level officers to use information, simplification of forms and processes, develop MIS conceptual design, support for capacity building on the MIS use.

2

Bachelor’s Degree in information system / Information Communication Technology or related field, min 5 years’ experience in Business Analyst / Information System Analyst / IT Infrastructure design. Skills: system analysis and design, data base design, portal/web design, communication, monitoring & evaluation, system documentations, use and support of open source. National and International certification in relevant field(s) preferred.

4

Database Engineer

Determine the size and requirement of the data base generated, design the database structure.

3

Bachelor’s degree In Information System / Information Communication Technology or related field, min 5 years’ experience in modern centralized Database system. Experiences in database design and programming for Governmental agencies. Skills: Data base system analysis and design, database and application integration design, use and support of reliable open source database. National and International certification in relevant field(s) preferred.

5

Programmers

Develop necessary application, conduct application tests and ensure application functionality and fitness to the needs.

15

Bachelor’s degree In Information System / Information Technology / Business Administration / Engineering or related field, 5 years’ experience of successful application system programing and/or web programming with significant experience in application system programing and/or web programming for Governmental agencies. Skills: advanced computer programming, web programming, use of open source programming language. National and International certification in relevant field(s) preferred.

6

Quality Assurance

Provide quality assurance from the beginning to the end of project to ensure its quality and timelines of service delivery as well as ensure the adequate provision of required infrastructure and capacity building.

2

Bachelor’s Degree in information system / Information Communication Technology or related field, minimum 5 years’ experience in IT Quality Assurance / IT Auditing. Skills: IT quality assurance, software testing, system testing, IT audit. National and International certification in relevant field(s) preferred.

7

IT Security

Ensuring the security of system

1

National and International certification in relevant field(s) preferred.

 

Important Notes:

 

Bidders are advised, when preparing the proposal, to ensure that sufficient information is provided in the CVs of the Consultant’s staff for the positions to support any qualifications and experience claimed.

 

 

[1] Indonesia is the country with the highest carbon intensity (1,000 tonnes of carbon dioxide equivalent (tCO2e) per million USD of GDP; roughly twice the global average) and has contributed 4 percent of cumulative (1990-2011) global GHG emissions, ranking sixth globally (WRI, 2011).

[2] Indonesia’s third national communication to the UNFCCC (2017).

[3] These are indicative numbers of staff. Firms may propose the appropriate number of staff as suitable for the positions.

icon

Servicios personalizados

 

Los servicios personalizados de ICEX son soluciones a tu medida desarrollados por las Oficinas Económicas y Comerciales de las Misiones Diplomáticas de España en el exterior...

 

icon

eMarket Services

 

eMarket Services es un programa de ICEX para facilitar a las empresas españolas, especialmente pymes, la venta a través de canales online y especialmente la utilización de los mercados electrónicos...

 

icon

Presentación simulador de costes

 

Se trata de un servicio online que te permite conocer el coste aproximado de la instalación de tu empresa en cualquier mercado y compararlo con otros países.