Data Warehouse Architecture for Financial Institutes to Become Robust Integrated Core Financial System using BUID

Abstract: This paper offers the concept of BUID (Bank unique Identification) code to unhide customer details and transactions from income tax department, government accountant and auditors, Government legal regulatory authority, all tax department and overall financial system using proposed data warehouse architecture for financial institutes. The proposed data warehouse architecture for financial institute will be well-built to execute a position to augment the present financial core system with BUID. The major advantage of this proposed architecture is that, the architecture will be identify customer various transactions and different accounts detail in different branches of different banks and financial institutions. We have tried to focus to remove the drawback by introducing the data warehouse architecture for financial institutes to maintain the Bank unique identification code (BUID code). This proposed data warehouse architecture for financial institute will help in decision making process by using OLAP and OLTP tools. The main advantage of this architecture is that the model with BUID can easily blend with current finance system. Thus the proposed data warehouse architecture for financial institute will become a robust to perform a role to enhance the present financial system.

Keywords: BUID, OLAP, OLTP