• Saltar a la navegación principal
  • Saltar al contenido principal
  • Saltar al pie de página
Bluetab

Bluetab

an IBM Company

  • Soluciones
    • DATA STRATEGY
    • DATA READINESS
    • DATA PRODUCTS AI
  • Assets
    • TRUEDAT
    • FASTCAPTURE
    • Spark Tune
  • Conócenos
  • Oficinas
    • España
    • Mexico
    • Perú
    • Colombia
  • talento
    • España
    • TALENT HUB BARCELONA
    • TALENT HUB BIZKAIA
    • TALENT HUB ALICANTE
    • TALENT HUB MÁLAGA
  • Blog
  • English

Casos

PSD2 regulations

septiembre 11, 2020 by Bluetab

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 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)

The development of the project is based on the design and programming (data modeling, ETL processes), tests and putting into production (deployment, process optimization, etc.). All based on processes under Powercenter, in a Teradata database with reports to the end user in Microstrategy.

SUCCESS STORIES

Publicado en: Casos Etiquetado como: data-fabric

Retail Banking Regulations

septiembre 11, 2020 by Bluetab

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 market in the financial services field. This directive is intended to

  • barra-bluetab Make access to basic banking services easier for potential customers
  • barra-bluetab Improve the transparency and comparability of commissions applied to payment accounts
  • barra-bluetab Improve the transfer of payment accounts

The objective is “to establish common rules of the game for all credit institutions and payment service providers”.

We participated in the process of setting the functional requirements in terms of the products affected, customers (natural persons), level of application (at the “account” level) to ensure proper project execution. With that starting point, we carried out the analysis of the entity’s information platform to determine how to extract the information necessary for the report, requesting the necessary information that does not exist at source. To ensure that the information is correct and necessary for the report, sampling or sets of information specimens are taken with the users.

In the project context, the transformation is also modelled and implemented in PowerCenter, for development of the modelling processes to enable the commercial product, customer, commissions associated with each product in the application period, interest charged and paid, interest rates to be obtained, as well as the loading and extraction of information that is not on the platform. Our team creates final tables and defines the output and reporting structure. 

To ensure the performance of the developments, a recovery of the entire volume of information associated with an account (several customers associated with it) in one year needs to be addressed. Similarly included within the scope of the collaboration are the necessary technical and functional documentation for the developments, the execution of comprehensive testing, test documentation and troubleshooting.

Transfer of the information is carried out by consolidating the information obtained and it is loaded in final tables, downloading information from final table to flat file for transfer. Exploitation of the information is finalised in MicroStrategy with availability of information detail for customer queries, as well as the creation of reports for exploitation of the information in reporting.

SUCCESS STORIES

Publicado en: Casos Etiquetado como: data-fabric

Management reporting with cost apportionment

septiembre 11, 2020 by Bluetab

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

Publicado en: Casos Etiquetado como: data-fabric

Virtual remote desktop

septiembre 11, 2020 by Bluetab

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 to persistence, transformations and transfers from the big data platform to the Institution’s Salesforce CRM. This project originated with mobility capacity to get close to the customer, a collaborative environment where several people can help manage the opportunity (Executive + Product Specialists).

It supports start-to-end processes by recording traceability of opportunities at each part of the process.

SUCCESS STORIES

Publicado en: Casos Etiquetado como: data-fabric

Omnichannel infrastructure

septiembre 11, 2020 by Bluetab

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. from the time the customer displays an announcement or an advertising campaign until they acquire a banking product.

In this project, data ingestions are performed from external sources such as: Salesforce Marketing Cloud (a marketing tool that lets you manage marketing campaigns across multiple channels), Adobe Analytics (an analytics tool that gathers all information relating to user activity on the web or in mobile applications), and Marketing Channels (Facebook, Sizmek, Google AdWords, Search Console, etc.).

The development is based on preliminary analysis and design of the data model for the external sources; a comprehensive security analysis that determines the sensitive information for the model that will need to be encrypted; naming assignment in the corporate dictionary with registration of the reference physical model in RAW and Master for external sources. An analysis was also conducted for mastering and generation of the guidance document for mastering development.
The main technologies in this environment are HDFS databases, Avro and Parquet; ETL processing in Scala/Spark in the corporate Data Lake, with exploitation in the corporate CRM-Salesforce and MicroStrategy.

SUCCESS STORIES

Publicado en: Casos Etiquetado como: data-fabric

360° customer vision model

septiembre 11, 2020 by Bluetab

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 Manager-Customer relationship. This solution will make it possible to analyse a 360º view of the customer-manager relationship from start to finish, i.e. from the time the web manager displays an announcement or an advertising campaign to a customer until they acquire a banking product.

We developed the project based on a definition of variables, alignment of concepts, importance of the customer relationship and contactability by means of face-to-face and digital means; with subsequent naming in the corporate dictionary and subsequent registration of the reference physical model in RAW and Master for external sources. We executed an analysis for mastering and generation of the guidance document for mastering development.

The main technologies in this environment are HDFS databases, Avro and Parquet; ETL processing in Scala/Spark in the corporate Data Lake, performing planning in Control-M.

SUCCESS STORIES

Publicado en: Casos Etiquetado como: data-fabric

  • « Ir a la página anterior
  • Página 1
  • Páginas intermedias omitidas …
  • Página 3
  • Página 4
  • Página 5
  • Página 6
  • Página 7
  • Página 8
  • Ir a la página siguiente »

Footer

LegalPrivacidadPolítica de cookies
LegalPrivacy Cookies policy

Patrono

Patron

Sponsor

Patrocinador

© 2025 Bluetab Solutions Group, SL. All rights reserved.