Management reporting with cost apportionment
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 consists of the design and implementation of a microservices solution that meets the scalability, flexibility and versatility requirements defined under the client’s requirements for creation of a product that generates the entity’s cost information by running an ETL job.
Bluetab performed the analysis of the group’s global cost information, extracting indicators of interest to senior management and identifying areas where to reduce those costs, providing graphical reports in ppt, with a multi-user, scalable, generalised solution to enable rapid adaptation to new analytics or new changes in requirements.
A state-of-the-art solution was implemented, reducing development time in the process of developing new analytics and algorithms by the user, proposing an App in which the user has a catalogue of functions to use and can combine them to form a pipeline with the processing they want.
Our fully compatible architecture uses Docker and Kubernetes (OpenShift) containers to enable horizontal scaling based on microservices that expose the data through various APIs and with a scalable, document-based database to solve the problem of the mutability of data sets and concurrency. Persistence is based on indexing the information; we performed code refactoring using atomisation and parametrisation of functions, and for DevOps scopes, deployment pipelines are created and configured.
The main technologies applied are: Python, django, Apache Airflow, mongoDB, PostgreSQL, and RabbitMQ as the messaging protocol.
SUCCESS STORIES
Quality of insurance information data
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…
Leading multinational in beverage sales and distribution
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…
MULTI-BRAND NDWH
mong 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…
Unified Data warehouse
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 with…
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…
Corporate banking market supplier information
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…
Regulatory Capital Calculation
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…
Investment and Corporate Banking Regulations
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 regulations
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…
Retail Banking Regulations
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…
Management reporting with cost apportionment
Construcción de plataforma Global para uno de los bancos más relevantes del mercado Español. El sistema debe permitir la generación de reports (pdfs, ppts, msgs) a la capa ejecutiva de la entidad Bancaria a partir de un pipeline basado en…
Virtual remote desktop
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 corresponding…
Omnichannel infrastructure
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.…
360° customer vision model
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…
Information system exploitation and reporting
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…
Utilities sector Data Lake
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 from…