DL Billing Bloomberg
The Challenge
Following changes to Bloomberg’s billing system, BBVA lost visibility of consumption and billing by area and department. Billing needs to be optimised and reviewed, comparing data from the Data Licence in order to reconcile accounts and distribute costs according to the origin of the query.
The Strategy
The ARENA Financial Tech team designs and creates an ad hoc tool that allows large data files to be ingested for matching, sorting and allocation using lightweight processes. To achieve this, we work in the JAVA environment with Spring Boot and Spring Batch, using an in-memory database optimised for reconciliation. Once the ingestion process is complete, the data must be extracted.
The Results
This tool has made it possible to identify and classify the use of Bloomberg information by department. Certain uncontrolled areas of unnecessary queries were identified and costs were optimised, reduced and allocated. The automatic generation of reports and comparative graphs with monthly historical data led to a rethinking of the market data query strategy.
