Global model of banking supervision

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.

Our team carries out the project based on persistence in a big data lake, with ingests and transformations of the information in scala / spark technology. The transformation rules to create additional information have been defined based on “Validation and Transformation Language (VTL)” with minor adaptations to improve ease of use and end-user readability.

The generated system that follows this process begins by feeding the input layer from the banks’ internal IT systems, following the structure of the defined input layer cubes. The data processes can be divided into layers (input, enriched layer and output layer) and three phases that separate those layers: transformations in the input layer, output layer and the assignment application that describe the relationships between them. All phases can include validations, for example validations that ensure the integrity of the input layer, validations that ensure the consistency of the enriched input layer, validations that apply the validation rules (external) in the non-reference output layer.

SUCCESS STORIES

Nuestro cliente es una multinacional mexicana referente del sector de la venta y distribución de bebidas, con importante implantación en América y recientemente adquirida por un grupo estadounidense líder en el sector. En su proceso de optimización continua ha emprendido…

El cambio del mercado retail desde la situación pre-COVID ha supuesto la necesidad de transformar los negocios de venta física, a negocios on-line. Muchos de los líderes han tenido que cambiar modelos de distribución y venta en tienda por modelos…

Our client is a major financial institution with presence mainly in Europe and America; among the three largest insurers in the market in Mexico and also a leader in the regions where it operates. It has undertaken a digital transformation…

Optimisation of Supply Chain processes.Our client is a Mexican multinational leader in the beverage sales and distribution sector, with a major establishment in America and recently acquired by a US group. In its continual optimisation process, it has embarked on…

Among the emerging operators in the telecommunications business, there has been an initiative that allows a single entity to integrate several commercial brands, integrating the processes common to all of them and making them as efficient as possible.So, for the…

The telecommunications sector has always been a very dynamic sector. In this sense, they have always had an urgent need to analyze their information in a convergent and unique way. To this end, an agile end-to-end collaboration has been consolidated…

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…

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…

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…

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…

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…

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…

A regulatory project to respond to Spanish Royal Decree-Law 19/2017, on basic payment accounts, transfer of payment accounts and comparability of commissions, for customers to be able to compare products more easily and move within the Union, benefiting from an internal…

Construction of Global Platform for one of the leading banks in the Spanish market. The system has to enable generation of reports (pdfs, ppts, msgs) to the Bank’s executive layer from a monolithic application-based pipeline with django as the framework.The project primarily…

Because there is no integrated CRM for corporate banking that contains customer data, opportunities, visits and all customer relationship information, this generates the need for this project with the aim of providing global multi-entity coverage. Bluetab is developing the part…

A Spanish multinational banking group asked us to provide its various group entities with an infrastructure with the necessary data to construct its customer’s “journey”. This solution will make it possible to analyse the customer journey from start to finish, i.e.…

We are the primary Big Data platform partner to one of the leading global financial institutions in technology. In the framework of our collaboration, the various group entities are provided with an infrastructure with the data necessary to build the…

Within financial institutions, the Data Units or Information Systems areas develop reports and scorecards to facilitate user areas’ work. Once the reports are in production, a security and governance framework needs to be established that defines the permissions for access…

The scenario of banking concentration in Europe and Spain, with the resulting mergers and acquisitions, has forced financial institutions to revisit their risk metrics systems. In this context, Bluetab has been involved with one of the leading banks in the Spanish…

One of the leading Financial Institutions in the Spanish domestic market decided to perform a split of the services of its new information platform with the aim of ensuring technical-functional understanding of the various layers, as well as to ensure…

Balancing customers and expansion activity is a necessary exercise to enable understanding of the actual situation of assets, as well as to match commercial activity with the actual situation of the supply points.Bluetab has developed operational reporting for one of…

Within the digital transformation process, the option was taken to build a Data Lake to serve various departments in a cross-cutting manner. Bluetab has developed a Data Lake in AWS for a leading Spanish energy companies, which gets its data…