Customer 360 system for bank
Project overview
Customer 360 is a sophisticated integrated software solution for displaying information about each client of the bank in the front bank system. Customer and product data is processed and displayed in real-time.
Business challenge
Earlier, our client had to manually gather analytics. They didn’t have historical data, which could be used to build algorithms for forecasting. The old front system didn’t store the data about accounts but yet it allowed for effective collaboration between the front office and bank’s clients. However, it was not optimized for efficient work. We had to migrate from a Siebel CRM system to Appian.
A new system, based on BPM principles, is more agile and user-friendly. Our objectives were to ensure the smooth flow of business data to a new system, create analytics, reporting, and other modules important for customer’s business processes.
Technical challenges
There was a strong need to develop and implement the data marts that will keep historical and real-time information about the client in the data warehouse, develop and implement an interface for aggregating the client’s data about transactions and operations.
We have to incorporate a few systems together for structuring the information during the operational workflow of the bank. All the systems had to work 24×7 taking into account that the online systems were located in different time zones.
Solution delivered
We have developed and implemented ETL processes for the transformation and preparation of data marts for the customer data. The final solution has a new interface for collecting historical and real-time data about the customers from different sources, its aggregation and further transfer to the front system of the bank.
Let’s discuss how we can help with your project
Key features
Quick data access
Convenient and fast access to information about customers and their accounts by a wide range of bank employees from retail to back-office and risk managers.
Improved usability
Customers have a better experience with receiving real-time information about their interactions with the bank, accessing the information is much faster.
Customer segmentation
All the customers are divided into groups according to their operations, incomes, and spendings. There’s a history of operations for marketing analysis.
Single data mart
A single data mart is based on online-DWH and offline-DWH. We eliminated time delays for the data updates for global processing through Swift, VISA, and MC.
Value to our client
Our tech stack
Oracle Database
Oracle Apex
Oracle SQL Developer
Git
Jira
Microsoft Project
