Bluetab provides all departments of a telecoms operator’s Corporate Business Area with reporting services and developments with a special focus on the remuneration model of agencies, distributors and internal staff.

The creation of data marts and process automation enables updating and access to information at higher frequency, facilitating monitoring and decision-making. It also improves the reliability of the data due to the standardisation of their sources. As a general rule, the tools used are Teradata, Pentaho and Microsoft Power BI and, to a lesser extent, Talend and Azure cloud publishing.

Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is a need to integrate existing statistical data requirements, as far as possible, into a single, standardized reporting framework that would be applicable throughout the euro area and could also be adopted by other European countries, thus easing the burden of bank reports and improving the quality of the data reported to the authorities.

The project scope covers the main supervisory reports: the ECB’s granular credit and credit risk data collection (AnaCredit), the ECB’s stock trend statistics (SHS), the balance sheet items statistics of monetary financial institutions (BSI) of the ECB, as well as statistics of interest rates of the monetary financial institutions of the ECB (MIR); likewise, other needs are considered as a requirement, such as the balance of payments and national accounts.

Within our context as a benchmark technology partner in the Data field in the Corporate Investment Banking area for one of the leading Spanish financial institutions operating in the principal markets globally; a collaborative technology approach is being developed to rationalise the use of information acquired from external suppliers (Bloomberg, CMA, Markit, S&P, Fitch, Moody’s, etc.) and to impact the cost to final consumers based on the demand for and use of that information. The information is obtained from the original sources to provide the highest quality data at the lowest possible cost. 

Storage in the Data Lake is performed by ingestion and normalization of data from various sources, and modelling and population of the Common data layer. The information is made available by means of the application data layer (relational) feed, with development of microservices that expose this data via various APIs (mainly Rest API, Bulk and asynchronous for Events).

In the context of the implementation of a risk-based supervisory methodology known as the Comprehensive Supervisory Framework (MIS for its initials in Spanish), we collaborated with a leading Spanish financial institution to integrate the risks that could affect the institution and enable the construction and full evaluation of its corporate risk profile by bringing together all the information from the local entities that make up the financial group.

The contribution of the bank’s assets is monitored monthly for this purpose. A variety of corporate extraction, transformation and loading processes are performed to do this, providing a solution to budget team reporting times, due to the latent need of users to automate their reporting process, and translating their Excel Macro into a Spark/Scala process. 

In this field, we are involved in major Big Data lake developments, where the main users are the regulatory and risk departments associated with the growing need in the area to comply with the various standards and regulatory frameworks demanded by the legislators and federal reserves in these markets. 

We needed to adapt the Data Lake to be compliant with the new IOSCO regulation which requires the exchange of collateral (IM) between entities operating with derivatives at contract formalisation time.  The primary objective of this project is to provide the sensitivities information necessary to correctly calculate this Initial Margin and to perform the subsequent validation of the model using the Backtesting and Benchmarking calculations required by the regulator.

PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of ‘APIS’ or ‘Application Program Interface’ is acquiring in different financial sectors is once again evident.

Bluetab carries out the start of the project for the main Spanish Financial Institution. We generate the necessary documentation to determine the scope of the project, perform the analysis of the availability of information within the platform, as well as address the definition and analysis of requirements (KPIs, data source)