Architectures: data warehouse

Project Name: Architectures: data warehouse
Client: ING Bank
Country: Luxembourg
Dates: 2005–ongoing
Project description: CRI’s team of BI Consultants strongly contributed to the modelling and implementation of a new data warehouse, for example in the following domains of activities within the bank: financial reports on margin calculation, commissions, costs, profitability (finance); client’s segmentation (retail/wholesale); legal reporting, fiscal certificates (legal). CRI has helped ING to create specific data marts per business lines. We also supported ING in the creation of multiple Univers and reporting under Business Objects (BO). The project equally included the dissemination of reports as well as the uploading of data into the warehouse and the set-up of a secure environment for protecting confidential data in the warehouse.
Technologies and tools: Unix/Windows 2000/Windows 2003 servers, Windows XP clients, Oracle 9i Enterprise Edition Release 9.2.0.6.0, Oracle Designer 6i, Creation of ODS/DW tables, Oracle Warehouse Builder 10g, Creation of mappings between ODS/DW tables, Tivoli, Mapping scheduling, BusinessObjects XI R2, Web Intelligence, Crystal Report, Xcelsius, Toad 8.6.1.0

Services