Since May 2024, I have been leading the design of data models for the first business case of Allianz Spain's new data platform. This includes developing raw and business Data Vault models for deployment on Synapse, as well as a dimensional data model to support reporting and analytics.

I have been involved in two projects, both for spanish insurance companies, particularly in data modeling tasks using a data vault approach.Initially I was in charge of designing a Data Vault logical model for SegurCaixa Adeslas new data platform. My responsibilities encompassed designing functional areas such: policies, quotes, claims, health data. The model was finally deployed on Exadata.Up till may 2024, I contributed to Mutua Madrileña's new data platform initiative, where I was part of a team responsible for designing multiple Data Vault models for specific business domains. We used Erwin for model design and Snowflake for deployment.

During that period I worked exclusively at MITMA (Ministerio de Transportes, Movilidad y Agenda Urbana), I was involved in two pivotal projects. The first focused on providing technical and functional support for data analysis initiatives related to gender parity. In the second project, my main responsibility was designing and constructing analytical solutions to monitor European Next Generation Funds implementation.

Since November 2017, I am leading technical team to build Sea Chefs Data Warehouse. I take part and lead all technical aspects of the project: from professional analysis and deepen of business requirements to detailed technical designs and implementation. Some important Sea Chefs customers are TUI Cruises , Hapag Lloyd , Phoenix Reisen.The project evolved to a data hub to interconnect different company systems with different technologies: SFTP, web services (taking advantage of SQL Server JSON and XML features). Implemented with Microsoft stack for DWH ( SQL Server 2016 , SSIS , SSAS tabular and Power BI ) implementing Data Vault, and python (with Anaconda framework) to glue different software components. We use JIRA and Confluence for project management and documentation.On 2020 I carried out DWH migration to a Windows Server 2019 Datacenter with SQL Server 2017 on an Azure VM.

I was part of a BI Scrum Team of over 10 developers working for AIDA Cruises (from Carnival Maritime ). I worked for over 4 years on maintenance and evolution of a mature BI solution. Oracle stack (OWB , Oracle 12c , OBIEE ).