GarantiBank International N.V. (“GBI”), based in Amsterdam and founded in October 1990, is wholly owned by Turkiye Garanti Bankasi A.S. (‘Garanti’). GBI is a globally active niche player in the fields of trade finance, structured finance, private banking, and retail banking. In the Netherlands, GBI is known for its savings products and deposits for both individuals and businesses.
The Challenge Facing Garantibank
Due to the significantly increased importance of data management and reporting, Alistar was commissioned by GBI to deliver a data warehouse solution that guarantees the reliability and traceability of the data. This is necessary for both internal and external reporting. In addition, the solution had to be capable of generating ad hoc reports. Speed, accuracy, and transparency were key objectives in this project.
We focused on creating an improved and more structured data warehouse platform, and we achieved our goal thanks to the professional and dedicated efforts of Alistar's consultants.
Gürbüz Salman, Director of Operations & ICT at GBI
The Solution
The technical solution consists of Microsoft SQL Server with high-speed data storage and SAP BusinessObjects reporting software. To save a significant amount of time, Alistar has developed ‘data warehouse automation’ components. These allow the ETL logic for thousands of tables to be generated with just the push of a button. In addition, well-designed hierarchies have been used to easily create and maintain report definitions. Various checks have been built in to ensure the required data quality. Furthermore, various layers of metadata—such as formulas and descriptions—have been added to achieve maximum transparency. ’Data lineage’ ensures that it is possible to trace where the data comes from and what processing it has undergone.
The result
Improved data management processes: Structured data storage and the implementation of data quality controls ensure consistency with the source system.
Flexible and reliable reporting environment: Standard and ad hoc reports are generated directly from the data warehouse using SAP BusinessObjects. Making the necessary data available for this purpose is
Fully automated. A number of existing reports have even been converted to this new, flexible, and transparent reporting environment. All data attributes related to bank accounts, loans, deposits, transfers, etc., are now readily available for any type of reporting. This allows reports to be generated more efficiently.
User Adoption: Alistar has supported GBI in every aspect of this significant change in their reporting process by conducting the right conversations, providing technical support, and offering on-the-job training
Users have quickly adopted and embraced the new features of the reporting environment. They see the varied ways their data is visualized and the ease with which they can analyze it in a variety of ways as a major advantage.