Skip to content

Contract notice: 2019/S 126-307799: Open procedure: Tender for Datawarehouse for Analysts - NABU

05.07.2019  09:29
Deadline for applications: 29 August 2019, at 14:00, local time 
Description of the procurement:
The EU Anti-Corruption Initiative (hereinafter — EUACI) is the largest EU supported programme in the area of anti-corruption in Ukraine so far. The overall objective of the EUACI is to improve implementation of anti-corruption policy in Ukraine, thereby ultimately contributing to a reduction in corruption. Consequently, the Danish Ministry of Foreign Affairs, Danish Embassy in Kiev (MFA) wishes to procure a Data Warehouse system (DWH), including hardware, integration, maintenance, support and development related to the DWH.

This procurement is aiming to design, develop and supply a DWH for the National Anticorruption Bureau of Ukraine (NABU). The DWH is supposed to provide extensive functionality for automation of processes for obtaining, systematizing, storing and analysing data.

The scope of the procurement includes:

— supply, install and configure of hardware required for the proper functioning of the DWH including, but not limited to servers, storages, backup tape library and other,

— supply, install and configure of software components, including but not limited to operating systems, databases, ETL, BI, backup and restore tools,

— analyse data sources, design and implement logical and physical Data Warehouse model, develop metadata and reference data, configure ETL processes to integrate data sources, develop and implement data cleansing and de-duplication rules in order to obtain ‘golden record’, create data marts, configure BI tools and develop statistical reports,

— provide documentation for each component of the system related to the DWH installation, system maintenance, user manual, technical manual, design, process and operating manuals,

— conduct trainings to NABU's representatives along with appropriate course materials for all the components being implemented as part of the project.

The DWH shall provide the following functionality:

— extracting data from state registers and databases (or electronic copies), taking into account the variety of formats and mechanisms of exchange, other operating restrictions of the said sources data,

— processing of accumulated data, including for the purpose of building a coherent information picture on the basis of data collected from different sources for the purpose of further intelligent information search, the formation of operational reports (hereinafter — or) according to approved templates,

— creation and support of reliable, relevant and consistent information (so-called ‘golden record’) for objects (dimensions),

— access to information for NABU’s analysts and detectives to support the processes of NABU. Also using BI providing opportunities for the use of modern data analysis and visualization techniques, data mining technology, statistical processing of data, association and grouping of or, search of hidden patterns, visualization of links, etc.,

— ensuring a comfortable work while generating reports and high-speed DWH, taking into account the large volumes of analysed data. The time to calculate complex indicators shall not exceed 12 hours and shall take place at non-working hours,

— maintaining the relevance of information about data sources,

— functioning of processes and procedures to be launched by schedule, by the event, by condition, by a signal received from an external information system (application),

— generate reports and enable the export of data from external information systems (applications). Please refer to Appendix 3 of the Draft Contract for a more detailed description of the object of the procurement.

Deadline for applications: 29 August 2019, at 14:00, local time

Contract Notice:
https://ted.europa.eu/TED/notice/udl?uri=TED:NOTICE:307799-2019:TEXT:EN:HTML

Tender material, communication and electronic tendering system:
https://www.ethics.dk/ethics/eo#/396aa4db-f74f-465c-b880-c188831e8337/publicMaterial