Client is a privately owned bank and was founded in 1590. It is one of Europe’s leading private banks with 1600 employees in different departments. Its headquarters is located in Hamburg where it is led by managing partners. It has offices in Frankfurt, London, New York and Zurich, among other financial centers.
About the Client
Problem Statement
The current database did not support the above use cases due to its following design constraints:
- Data quality and scalability
- Single-table storage systems with huge amounts of data were harder to maintain
The Challenge
- Limited memory to store data
- The code was not accessible to everyone
- Due to limited disk storage, complex calculations become a problem
The Solution
- An agile approach to manage projects into fixed-length sprints
- A high performance system regardless of volume and velocity
- A flexible data model that has no limitation to add new data and refactor existing data
- A reference architecture that has the capability to support big data concepts and supports the integration of NoSQL data sets and real time data
Tangible Results for the Client
- The bank was able to create auditible solutions
- Fully-automated parts of the data warehouse were able to help the client make less errors as compared to manual development of SQL statements and ETL processes
- The bank was able to achieve a higher level of data security and privacy
Technologies used
- MID
- AnalytixDS
- Wherescape
- Excel
- Tableau
- SaaS
- QlickView
Trung Ta
Senior Consultant
Phone: +49 511 87989342
Mobile: +49 170 7431870
Free Initial Consultation