Komerční banka (KB) is one of the three largest banks in the Czech Republic and is the leader in corporate banking. It is a member of the international group Société Générale, the fifth largest banking group in the euro zone. For such an institution, a data warehouse is an absolute necessity and comprises a highly complex system. Profinit assists Komerční banka in finding ways to obtain maximum information in order to build a competitive advantage.

Cooperation between Profinit and KB began with the Informatica Solution Upgrade project, the aim of which was to upgrade the integration tool used within the data warehouse. The result of this project is a more advanced, higher-performance ETL tool with higher availability. Profinit's consultants also developed a new system for planning data-warehouse processes, which enabled more effective management and monitoring of the warehouse's operation.

The success of this project led to further cooperation and Profinit's participation in the Central Banking System project. Within this extensive project, Profinit contributed to the data-warehouse solution. Our consultants delivered to Komerční banka tools based on the sophisticated PSAT (Profinit Syntax Analysis Tool) product. The tools perform automated modifications and inspections of the data warehouse's transformation code, which substantially saves time or, as the case may be, costs in the further development and maintenance of the data warehouse.

Within the subsequent project, our consultants collaborated on the upgrade of the data warehouse's database system. One of the tasks involved migration of data to the Unicode international character set. Thanks to an analysis of the data and all data flows, a unique solution was delivered that for the future represents a 30% savings on investments in database-platform hardware.

To a significant extent Profinit also played a role in the actual operation of the data warehouse.  Our consultants have long been involved in the main processes of the operations section, i.e. primarily testing, setup, maintenance and support. Within our work, we provided a range of suggestions for optimising and improving the efficiency of operation and for certain activities we developed tools for automating previously manually performed work, thus reducing overall operating costs.