Case studies
Each case study documents the problem, my role, the decisions made and what was learned. Unknown details are marked, never filled in.
Integration of each tenant's operational PostgreSQL data from a pricing platform into Snowflake, maintaining isolation between tenants and automating the onboarding of new clients.
Data platforms · Cloud architecture · Automation & AI
Optimisation of numerous reports and of the daily C# processes that pre-compute their data with advanced queries, combining PostgreSQL and Snowflake according to compute needs; includes pruning, joins, data types, VARIANT columns and analysis of warehouse and storage costs.
Architecture & performance · Data platforms · Cloud architecture
Python tooling to discover, migrate, reconcile and validate older and newer generations of event tables across hundreds of tenant schemas, with hundreds of millions of records, without loss or duplicates.
Data platforms · Automation & AI
Data re-architecture in Snowflake and new cost accounting features for the entire multinational (hyperinflation in Turkey and Argentina, country-specific taxes, valuation in hub countries that distribute to the rest), with a Java/Spring backend and migration from Oracle and DB2.
Backend & integrations · Data platforms · Architecture & performance
Large-scale migration of applications to key-pair authentication in Snowflake with keys stored in AWS, and a proposed per-tenant user and role architecture with least privilege and credential rotation.
Cloud architecture · Data platforms
Development and maintenance of C#/.NET microservices and Lambda functions across several areas of a pricing platform, AWS infrastructure support in several regions, integration of ML pipelines with SageMaker and Step Functions, and delivery with Azure DevOps.
Backend & integrations · Cloud architecture · Automation & AI
Anomaly detection on telemetry from industrial assembly and welding machinery to anticipate mechanical failures, together with an on-premise IoT infrastructure for real-time ingestion and analytics.
Automation & AI · Data platforms
Analysis of customer usage behaviour, segmentation, cross-selling opportunities and churn prediction models, with analytics infrastructure on AWS.
Automation & AI · Cloud architecture
Sales forecasting models by store, product, category, section and promotion to understand demand, seasonality and the effect of promotions.
Automation & AI
ETL processes with Spark and data quality validations over large volumes of banking information on BBVA's Big Data platform.
Data platforms
Python tools for solving mathematical boundary value problems with the Finite Element Method, in the esys-escript / Finley environment at the University of Queensland.
Architecture & performance
Image processing and analysis tools for the Visual Monitoring Camera of ESA's Mars Express mission, studying clouds, atmospheric dynamics, aerosols and the polar caps of Mars.
Internal tool that analyses repositories and discovers and visualises the dependencies between microservices, endpoints, Lambda functions, shared libraries and infrastructure resources.
Automation & AI · Architecture & performance
Experimentation with software development workflows in which one agent implements and another audits, iterating until the criteria are met, with a human in the loop.
Automation & AI
A multilingual portfolio with an experience explorer, case studies and an AI assistant that answers only from an approved knowledge base, with cost controls.
Automation & AI · Backend & integrations · Architecture & performance
Trilingual online shop (Basque, Spanish, English) and admin panel for an independent handmade candle brand: catalogue, basket, binding orders, unit-level inventory, shipping and email notifications with a transactional outbox.
Backend & integrations · Architecture & performance
Mobile-first PWA for the JF Bihotzetan padel team to organise its internal matches: slot-based sign-up, court booking, per-match chat, push notifications and sharing via WhatsApp.
Backend & integrations