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 market, producing a report from the entity’s Unified Risk System. The project arose due to the need to redefine the current information system associated with the new risk metrics, allowing both the integration of information from Spain and other from geographic areas and the inclusion of this information and its adaptation to the new information architecture defined for the future.

The project scope includes both gathering of requirements and prior technical-functional analysis to lead to the design and construction of a data mart that provisions the reports required by the Risks Department as applicable to the new unified system defined. 

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 the level of efficiency and demand on suppliers. The latter point refers to demanding service level agreements that are measured by daily levels according to an internal ticketing process.

Within the organised services structure, we are responsible for the platform outputs, which involves developing all the information system operation and reporting projects. Our team designs the logical model, building the data extraction and transformation processes through the DataStage (IBM) product and generates the scorecards.

Within the service, user areas’ projects are addressed, mainly Risks, Commercial and Finance, as well as common services such as the administration of on-premises and cloud tools, attention to incidents and centre of excellence (or expert support).

Under this schema, the generation of reports and scorecards is “industrialised” following a well-defined working methodology that enables simplification of maintenance, speeding up of developments and delivery of a homogeneous product to the end user that conforms to the style guides defined by the institutions.

The main technologies applied for reporting are MicroStrategy and WebFOCUS; IBM DataStage and Db2 Warehouse for the processing and storage part.

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 Spain’s largest energy companies, enabling daily tracking of its expansion activity, grouping of the various types of customers based on the situation of the contracted services and also allowing the specific customer detail to be reached.

Project scope includes functional analysis, infrastructure deployment in AWS, data modelling, development, and preparation of reports in Power BI.

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 the on-premises commercial systems, from database and file sources, through continual, daily ingestion processes.

The project scope includes functional analysis, deployment of infrastructure in AWS and development of data consolidation processes in Data Lake using fully scalable technologies.