(Co)development and implementation of a Management Information Data Warehouse and related tool set in a bank
The staff department Client Management & Information Systems plays a crucial role in the support of the business unit Corporate Clients (the Dutch “large enterprise” segment, excluding multinationals). This department is specialised in detailed and complex management information reporting and development and support of tailor made front-end applications. Both activities are being supported by a financial data warehouse, developed in-house by permanent staff. Mid 2005, the development and support of this data warehouse and all corresponding front-end applications have been assigned to a dedicated support team of four people.
The assignment to my company was to (co)develop the data warehouse and all related front end user applications. All developments were done on a locally administered MS Access / VBA platform. At the input side, the data warehouse automatically retrieves various types of data from over thirty different source systems and departments within the bank. At the output side, dozens of databases, applications and automated reports are being distributed on weekly or monthly basis to over a hundred employees, among whom management teams, financial analysts, controllers, account managers and commercial staff.