Decision support system for the Bank based on Big data

Project background

Institutions in the Banking and Financial domain obtain a huge amount of data. Unfortunately, it is raw and unstructured that does not provide business growth and potential benefits realization.

Our customer – a European Bank and a leading player in the banking market since 1995 (further referred to as the Bank) – has encountered a similar issue. 

For the last 20 years, the Bank has collected a large volume of data about its customers. But all the data was unstructured and fragmentary. A smart tool with Big Data analysis support was needed to process the information.

Challenge

The Bank management wanted to increase sales and consequently revenue. For this purpose, it was necessary to:

• implement an instrument for data collection,
• design and deploy a tool for Big Data analysis,
• develop a software solution for data interpretation,
• build and deploy a program for finding dependencies in collected data,
• develop and implement a tool for data visualization,
• create an integrated solution for decision making using the results of data analysis and processing.

We had to perform a not trivial mission. RNDpoint’s team had to become a mediator between parties to ensure effective Data Mining and Analysis. 

To increase the accuracy of results, we used the database of another partner of ours – Telecom operator. After a series of meetings, the agreement between the Bank and Telecom operator was achieved. They agreed that analytical data, received during the project, will be shared between parties and further used by both of them.

Solution

As known, Telco – the Telecom operator – has got a vast user database, which consists of the following  data: 

• user-behavior;
• age and sex;
• location;
• family status;
• purchase history, etc. 

Our solution combines a database processing module and a custom software platform. The software platform includes the following subsystems:

• Business Intelligence (BI);
• Corporate performance management (BPM);
• Business Analytics (BA).

Business Intelligence gives the capability to collect, integrate, and analyze information at the enterprise level. The Bank’s employees have an option to explore, accumulate, and interact with the information. The Business Intelligence platform allows compiling on-demand reports and visualizing data to increase workflow efficiency and speed.

Business Analytics is used to exploit the most sophisticated statistical techniques. Innovative and smart data analysis approaches make a significant impact on data processing quality and predictive insights.

Business Planning Module is used to simulate, plan, and monitor the impact of decisions made by the management on the overall organization performance. BPM effectively links the core decision-making process at strategic key points with financial controlling, and profitability analysis with sales and operational planning.

RNDpoint’s developers, business analysts, and scientists worked hard to interconnect and make these all work together in a single integrated environment to support better decision making. As a result, the Bank got the unique software solution designed from scratch and smoothly integrated into existing banking infrastructure.

The Technologies

 DB: Neo4j, MongoDB, Cassandra, Hbase, Redis

Hadoop: MapReduce, Yarn, Hive, Impala, Spark, Flink

Search engine: ElasticSearch (ELK), Solr

Adobe tools: Adobe Experience Manager, Sightly, etc.

SCALA: akka

Java: Spark, Drools, Jersey, Swagger, Jenkins

Oracle ATG Web Commerce

JavaScript: Node.js, jQuery, Angular, Knockout

Results

After thorough testing, the Platform enabled the Bank to make better, faster, and more accurate decisions with scalability and development potential.

The Platform implementation provided the Bank with advantages, such as:

• pin-point 97.8% accuracy in decision making;
• decision-making process became 3 times faster;
• data storage was increased due to cloud-based repositories;
• streamlining of workflow processes increased employees effectiveness by 32%;
• the Bank acquired a reliable partner – Telco – for further profitable user data exchange.