Recruitment of a Consultant for the Updating of the Data Collection System for the... Tender

Procurement Summary

Country : Cote d'Ivoire

Summary : Recruitment of a Consultant for the Updating of the Data Collection System for the Statistical Directory, the Long Term Finance System and the African Infrastructure Knowledge System

Deadline : 15 Dec 2018

Other Information

Notice Type : Tender

TOT Ref.No.: 28908833

Document Ref. No. :

Competition : ICB

Financier : African Development Bank (AfDB)

Purchaser Ownership : -

Tender Value : Refer Document

Purchaser's Detail

Purchaser : AFRICAN DEVELOPMENT BANK
Département des Statistiques ECST.1 Tel: +225 2026 4634 Avenue Joseph Anoma 01 BP 1387 Abidjan 01
Cote d'Ivoire
Email :k.l.kouakou@afdb.org / b.adingra@afdb.org / c.baradandikanya@afdb.org
URL :http://www.afdb.org

Tender Details

Tenders are invited for Recruitment of a Consultant for the Updating of the Data Collection System for the Statistical Directory, the Long Term Finance System and the African Infrastructure Knowledge System.

1- OVERVIEW

As part of its work, the AfDB statistical department has set up a system for collecting data via the Internet from Excel templates

This system is currently used for independent data collection projects:

- Statistical Yearbook for Africa

- The Infrastructure Knowledge Program in Africa (AIKP)

- The Long Term Finance Project (LTF)

In all these projects involving partner institutions (CEA, African Union, FSDA, GIZ, MWFA, etc.), Ba Banque is responsible for collecting data that will feed the various processing, analysis and statistical publications as per example, the Statistical Yearbook for Africa and the Economic Outlook for Africa.

The implemented system is growing both in terms of the number of users involved (more than 200), in terms of new features to implement or in terms of collection system concerned to implement or improve (The Long Term Finance project being the last to join the platform).

In the context of the African Economic Outlook (AEP), the Department uses a model to forecast short and medium term (3 years) macroeconomic data for regional member countries. This model will be improved for long-term projections.

2. OBJECTIVES OF THE CONSULTATION

The purpose of the consultation varies according to the collection system

For the ASYB system, it is a question of putting into production the post-collection system for the validation of the data by the three partner institutions while accompanying the team on the IT level during the phase of generation of the statistical publications after the workshop of confirmation

For the AIKP system, it is to support the new IT team during the collection workshops, to develop the requested improvements and to provide Reporting functions.

For the finance system, the latest on the platform, it is to enter the production phase after a redesign of input templates. This step is necessary to be able to open the system to external users (the system is only used at the ADB level).

For the PEA model, it is a question of making an improvement on the model so that the department can make the projections in the long term (5 years and more).

Finally, it is a matter of leveling the systems upwards by making each of them benefit from the developments requested by the staffs of the other systems, such as e-mail notifications, progress reports and seizures on views. cross-tabs used to validate data for a given indicator and several countries (country collection templates are designed for a country with multiple indicators).

3. SPECIFICITY TASKS TO BE CARRIED OUT DURING THE CONSULTATION.

The specific tasks to be performed by the consultant are:

• As part of the Africa Statistical Year Book System (ASYB)

- Set up the configuration of the post-collection validation system. It will be a question of installing these functionalities on the client computers and to train the staffs of the 3 partner institutions (ADB, CEA and AU) in the validation phase where each one with the responsibility of a group of countries and a group indicators.

- Participate in the Collection Workshop (usually held in March), and assist country participants.

- Respond to the needs for changes expressed (new indicators, update of growth rate calculation rules, new presentations of statistical publications and assist the team throughout the generation phase of statistical publications (generally April).

- Set up and set up the rules for e-mail notifications for the tracking of shipments by country and the validation phase.

- Offer a Reporting on the progress of the countries (missing countries, indicators not sufficiently informed etc ...)

• As part of the AIKP system:

- Participate in the various collection Workshops, install and train new participants that are regularly performed by the Statistics Department

(ECST) Ensure the proper functioning of the Data Submission Tool (DST) and propose solutions to problems encountered during its use by national experts.

- Strengthen the post-collection phase with progress reports.

- Integrate messaging rules into the administration interface (these rules were hard-coded in the urgency of the last workshop).

- Meet the new needs of the new AIKP team in terms of training, new developments and Reporting.

-

• Under the LTF system (Finance)

- Make an overhaul of the input templates following the lessons of the first collection and input test. The new templates, designed to eliminate the errors and shortcomings encountered, will have to be parameterized and introduced in the collection system to replace the old ones.

- Set up and set up the rules for e-mail notifications for the tracking of shipments by country and the validation phase.

- Set up cross templates (1 indicator, several countries, several years) that will allow to integrate data from sources other than countries and manage the calculated indicators (ratios, growth rates, etc.).

- Develop a mini data portal.

• As part of the common platform

- Migrate the system to a new server with the latest versions of Microsoft SQL Server according to the general policy of the Bank. For example, the current system base is still on Microsoft SQL Server 2008 while the Bank's servers are progressively migrating to SQL Server 2016.

- Resolve, in collaboration with CHIS, access problems encountered from some partner institutions where access to the ADB server is prohibited. It's about putting the site in a trusted domain and adapting the code accordingly.

- Work on error messages and the interface to allow a better identification of the problem. As users are very numerous, it is important that the error message accurately informs the cause of the error (not

Internet access, server access impossible, ) to limit the claims. These problems did not arise during the testing phase because they are caused by network administration at the country focal points and not by the AfDB computer network side.

• In the context of PEA and other publications

- Add to the macroeconomic model another 3 years so that we can make the projections for the next 6 years.

- Improve the Compendium and Gender Publications Template.

4. EXPECTED RESULTS

The consultant will produce a new version of the data collection and archiving management application that meets the latest needs expressed and adapted to the following frameworks:

- ASYB

-Long Term Finance

- Infrastructure Knowledge Program in Africa (AIKP).

It will also produce a user manual, aimed at empowering the experts who will use this tool. The manual will include opportunities for collection and management development, other indicators and other time periods.

It will provide the PEA model with the requested improvement.

The consultant will produce an administration application for the entire system. He will provide a manual specific to the administration of the entire system.

The consultant will finally train the future users of this system.

5.- CONSULTANT QUALIFICATIONS

The consultant should have the following skills for setting up this system:

• Holds a degree in statistician and / or computer engineer with a competence in database management and application development in Excel.

• Proven experience (5 years) in development under EXCEL and VBA.

• Mastery of the Microsoft SQL SERVER business intelligence platform (Database Engine, Integration Services, Reporting Services and Analysis Services).

• Proven experience in setting up a Datamart / Datawarehouse. 5) A good knowledge of statistical surveys.

A. The Statistics Department invites Individual Consultants to apply for the services described above. Interested Individual Consultants must produce information on their ability and experience demonstrating

they are qualified for the services (documentation, reference of similar services, experience in comparable missions, etc.).

B. The eligibility criteria, the shortlisting and the selection procedure will be in accordance with the Rules and Procedures for the use of Consultants for projects financed by the African Development Bank window, revised 2008 edition. 2012, which are available on the Bank's website at http://www.afdb.org. It should be noted that the interest shown by an Individual Consultant does not imply any obligation on the part of the Bank to include it on the shortlist.

C. Benefit duration is estimated at 180 days and start date is December 22, 2018.

D. Interested Individual Consultants may obtain additional information at the following address at the following local business hours: 09: 00-17: 00 hours

E. Expressions of interest must be submitted to the address mentioned below no later than 15:00 local time on 15 December 2018 and expressly mention: Demonstration of interest in the management mission (collection, processing and harmonization) and compilation of Economic Accounts data from Regional Member Countries.

A Attention:. Adingra Miss Rose-Marie African Development Bank Statistics Department,

ECST.1

Avenue Joseph Anoma 01 BP 1387 Abidjan 01

Ivory Coast

Such. : +225 20 20 46 34

E-mail: b.adindra@afdb.org; c.baradandikanya@afdb.org;k.l.kouakou@afdb.org

[Disclaimer: The above text is machine translated. For accurate information kindly refer the original document.]

Documents

 Tender Notice