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
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…
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…
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…
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
Un grupo bancario multinacional español nos propone proporcionar a las diferentes entidades del grupo una infraestructura con los datos necesarios para construir “el journey” del cliente. Esta solución se podrá analizar el journey del cliente de principio a fin, es…
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…