AI-based Financial Data Management Platform

Functionality Overview

Our team delivered a frontend part for the platform that is able to pull large amounts of financial information from the client’s database and provide a comprehensive visualization. The visualized data is then made available to end users (e.g., banks and financial institutions) via a paid subscription.

The biggest challenge of the project was finding a technical solution that would enable fast and seamless data transfer from the client’s API (which generates data in the JSON interchange format) to the interface (where the collected data is visualized in multiple forms, diagrams, and charts).

As direct communication between the frontend and the API would hinder the system’s real-time updates and user experience, our engineers suggested adding backend functionality to the system.

The backend communicates with the client’s API, sends requests to the server, and receives data from the client’s system. On top of that, the solution features a PostgreSQL-based database, which stores pre-aggregated data. The system’s backend structure validates and filters the collected data before transferring it to the frontend. As a result, the database’s performance and user workflow is no longer impeded by time-consuming data migrations.

For the frontend part of the solution, we used a combination of the React framework and the Redux library. The backend part is built on the Django REST framework.

Development Process

Architecture Highlights

Reporting

For data reporting, our team implemented multiple types of data presentation, including diagrams for personal data, credit rating changes, and other metrics. The components came from the Recharts library and the React-Vis library, selected by Itexus’ frontend developers and designers, and subsequently customized in accordance with the platform’s visual style.

UI/UX

While the client’s in-house team created the graphic design, Itexus was responsible for design review and implementation, as well as user experience enhancements. We used Ant Design as the main library for UI components (e.g., buttons, headers, sidebars, tables).

Customizable workspace

Once subscribed, end users can filter the information presented inside data blocks and personalize data visualizations. In other words, they can choose data sets and rearrange data blocks in accordance with their preferences.

Results

Working with the Itexus team, the client managed to create a custom, easy-to-use, AI-driven financial data management platform that is suited to the needs of their end users: banks and financial institutions. The solution enables end users to quickly receive and view requested data about their clients.

Currently, work is underway to implement functionality enhancements and new UI elements.