Data aggregation hub for treasury

  • 99%

    99% data errors reduction
  • 100%

    100% duplication elimination
  • 1 day

    Value updates in the Golden Source dictionary within 1 day
  • 100%

    100% increase in manual processing time

Project overview

Data aggregation hub for treasury is a high-load secure web-based system that ensures seamless data access, validation, verification, processing, storage, and manual amendment.

Client information

Under NDA

Business challenge

With a growing sensitivity to data collection and protection, banks face a pressing need for powerful and secure systems for data aggregation. Our customer required a system that would arrange data feed from the existing databases and match them against the Golden Source dictionaries. Next, these matched values had to be aggregated and stored for further reference and reporting.

Technical challenges

It is known that banks are enterprises with high-load infrastructure. Some of the customer’s data feeds contained over 1M records. Thus, we had to ensure the highest level of performance.

Solution delivered

To meet the client’s requirements for seamless data aggregation and high performance, we built a high-load secure web-based system with a user-friendly interface. The solution allows amending data manually in case some values don’t match with the Golden Source, for example, new books or counterparties.

data aggregation hub for traesury solution
Claim a 30-minute talk with our experts and get a step-by-step strategy for your project for free!

Key features

data aggregation hub for traesury key
  • Data access

    With data access, users can store and amend the stored data. We implemented the relevant technology for clear authorization procedures involving different types of data access rights.

  • Data validation

    The system ensures that the required data type undergoes data cleansing while following all the validation rules deployed as a set of stored procedures.

  • Data verification

    The system is empowered with data check procedures to verify the accuracy and consistency of the input data. Proofreading and double-entry check are mainly used to verify data.

  • Data processing

    The system ensures end-to-end data processing (DP), including manual data amendments. It involves data validation, aggregation, and reporting, along with other fundamental functionalities.

  • Data storage

    Now, the customer can be sure that the important information is kept safe. A user-friendly interface was developed to provide users with intuitive experience for data storage and processing processes.

  • Manual data amendment

    Users can retrieve data manually and get system notifications of all the modifications done. The ability to manually check and edit data reduces the number of errors.

Value to our client

  • Reduction of data errors by 99%

    Sophisticated data validation and data verification processes realized in the system allowed to reduce the number of data errors by 99%.

  • Total duplication elimination

    Duplicate records are now effectively encountered in the system, which allows for eliminating errors and data silos.

  • Increase of manual processing time by 100%

    In cases when data values don’t match with an allocated data set, users can manually amend those.

  • 1-day updates

    New values were updated in the Golden Source dictionary within 1 day, instead of 1 month.

Our tech stack

  • angular js Angular
  • oracle Oracle
  • nodejs NodeJS
  • pl-sql PL/SQL

Software solutions bringing business values

6 reviews
47 reviews

    Contact us

    100% data privacy guarantee

    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447


    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7


    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław


    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands


    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien


    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344


    +4366475535405 Vatslava Havela Boulevard, 4,