European Investment Bank (EIB)

“In 2006 the European Investment Bank launched a public Call for Tenders for the selection
of a service provider to assist in the maintenance, support and development of the European
Investment Bank’s Operational Data Warehouse and of its PeopleSoft Enterprise Performance
Management suite.
The Operational Data Warehouse (DW) contains data related to the Bank’s financial
operations (mainly loans, borrowings, treasury and risk management information); Enterprise
Performance Management, a package from Oracle/PeopleSoft, contains data drawn from
the PeopleSoft HCM (Human Capital Management) and Financial (Purchasing, Accounting and Expenses) suites.
On both DW and EPM, the reporting is done using BusinessObjects XI.
The Bank selected Arηs Developments as its service provider for this contract following completion of the Call for Tenders (Ref: OJEU reference 2007/S 72-087378 from 13 April 2007).

The Arηs Team is responsible for the corrective maintenance and further development of the
DW which is fed by different operational databases:

• System for the input of loans (EIB in-house development),
• System for the management of back-office loans (EIB in-house development),
• Wall Street Systems Finance Kit package (borrowings and treasury),
• PICDB (reference database).

The DW is fed using transact-SQL scripts (approximately 200 000 lines of code) and Enterprise
Application Integration (EAI) interfaces (for the borrowings and treasury data extractions).
The transact-SQL scripts are scheduled by nightly batches using Unix Shell scripts plus
Autosys scheduler. The Bank is in the process of replacing transact-SQL by an extraction, transformation and load (ETL) tool, IBM Datastage.
This 2-man-year project should be completed at the beginning of 2009 and will result in decommissioning of all these transact-SQL and Shell scripts.
More than 1000 EIB users currently access the data in the DW / EPM on a daily basis. They
make use of more than 100 different BusinessObjects universes, producing a large number of
reports across various business areas (statutory reports, statistics for internal and external
use, follow-up of the Bank’s operations, risk management reports, management information, decision support, etc.).
A significant number of the end-users access data using queries integrated into the system for the input of loans, through a web-based interface.
A significant number of the end-users access data using queries available in a web-based interface integrated with the system for the input of loans.

Specifically, the Arηs team is responsible for:

• Feeding the DW: maintenance of the existing system, adaptations in line with upgrades or changes to the source systems, adding or replacing data, system documentation and technical migrations,
• End-user reporting: maintenance of the current universes and reports, end-user training, end-user support, creation of new universes and reports, technical migration or upgrade of tools.

Currently 4 Arηs FTEs are allocated to the maintenance of the DW and EPM, and between 4 and 8 consultants have been involved on various projects.”