Working in IT consultancy from 2001 as Developer, Consultant and Architect in different platforms and technologies. From 2006 I was focused in BI technologies and I have got my Master of Business Intelligence in the University of Barcelona in 2012, as well as Microsoft certifications such as Microsoft Certified Solution Expert: SQL Server 2012 and Microsoft Certified Solutions Associate: SQL Server 2012
I was MVP of Integration Services (ETL) in Avanade, where I worked with Reporting Services and Analysis Services (2005/08/12) for more than 3 years within Avanade and Accenture projects. My skills as Database Architect are strong with more than 14 years’ experience in T-SQL Server with different DB engine such as SQLServer (05-14), Oracle, MySQL, Teradata, Hive… I have an excellent knowledge in Microsoft BI and a good understanding of the Data Warehouse cycle life following the Ralph Kimball methodology (Bus Architecture) and DataVault modelling by Dan Linstedt.
I specialised on creating BI/ETL frameworks in order to accelerate and automate the gathering as much data as possible, creating versioning of raw data and apply latest Data Modelling techniques to unify all the data giving a semantic understanding and providing automation even when creating data marts.
From August 2015 to August 2017, I was working in Rakuten, leading an ambitious project that aims to create Big Data as a Service Platform. Offering a unique centralize Enterprise Data Warehouse for all Rakuten business and divide big data into layers to easy access and governance. I am responsible for the EDW creation, history stage and many ETL automation processes that we are currently implementing, using Python, MySQL, Hadoop and Teradata. In Rakuten, I was using different technologies such as Hive, Spark, Airflow, Rundeck, Git, etc.
From 2017 to 2021 I was working in Swisscom Switzerland as Senior Data Engineer creating my own end to end solution to leverage a DV2.0 ecosystem on Hadoop/Hive.
Senior Data Modeller HelloFresh Nov 2022 – Present
Data Architect, Data, Analytics & AI Swisscom Aug 2017 – Nov 2022 (5 yrs 4 mos)
Working as Database Architect using Teradata and Hadoop technologies. I proposed to move to a new Generation Data Warehouse, moving all our Data into Hadoop/Hive using Data Vault 2.0. My key points on this ambitious project are:
- Design whole solution end to end alone (no expertise on Big Data Warehouses in-house)
- Brought my own (private) code which will accelerate and automatize the whole DW ETL and creation process.
- Swisscom evaluated a few other vendors such as “Data Vault Builder” and “VaultSpeed” and still we are working with my “Scalable Data Warehouse”
- Being Product Owner and taking care of the evolution of the platform, doing tasks like: o Setup a DevOps team capable of maintaining the code and working on Operations o Keep improving performance and capabilities on the tool o Modelling from scratch the whole new DW o Finding new stakeholders and use cases to grow the platform I did complete in the meantime various architect courses for MicroStrategy products, Scrum Master training from the Scrum Alliance, and I Certified on Data Vault 2.0 Practitioner (CDVP2)
Data Architect Rakuten Aug 2015 – Aug 2017 (2 yrs 1 mo)(Tokyo, Japan)
Database Architect in Big Data Department Designing Enterprise Data Warehouse with Data Vault 2.0 and ETL automation Working as Database Architect in the Big Data Department. Using technologies such as Hive, Hadoop, MySQL, Teradata, etc. Leading on the MDM implementation in order to have a highly governed Data Lake as well as ETL automation, EDW data modelling and providing vision for the future Rakuten Big Data as a Service Platform.
Working as an architect we are aiming to create what we called “Rakuten Data as a Service Platform” which has capability to get hundreds of databases from various sources into Hadoop/Hive to later consumption with Hive. Then I am also leading creating a unique Data Warehouse to unify with Data Vault 2.0 all the Rakuten’s ecosystem data (+800 businesses) so we can help or partially automate data mart creation (Star/Snowflake Schema). The project is ambitious, it did start with my vision and today’s budget and headcounts are increasing rapidly as the effectively (even in its beta phase) is notorious and famous in Rakuten internally.
Senior Business Intelligence Consultant Antares Solutions Oct 2012 – Aug 2015 (2 yrs 11 mos)
Designing Enterprise Data Warehouse with Data Vault and BIML. EDW using Data vault. Creating our own framework in order to generate dtsx quickly with BIML and recreating the DW (dimensional model) based on the DV design automatically using allways best practices. Build test solution with SVN using a Stage server to deploy our releases and test. Complete DW system provides a SCD everywhere (including facts) and data snapshots capabilities to inquiry the data “As of”. Migration from a third party CRM (SQL Server) to Sales Force using InformaticaCloud. Currently working as Business Intelligence Architect, creating a whole new reporting solution merging all the data from different sources (including SF Cloud) into a EDW in order to work with Tabular Cubes. SQL Azure experience, synchronizing on-premise SQL Server with SQL Azure on the cloud using MS Azure DataSync Agent.
- FUSE ARMS
MS Business Intelligence Consultant/Developer Fuse Farm Jun 2012 – Sep 2012 (4 mos)
SSAS cube development and reporting solution on a PHP server using SSRS (SDK) to meet their evolving reporting and analysis needs. During this project Albert was a senior consultant and developer.
- ANGRY KOALA
MS Business Intelligence Consultant/Developer Angry Koala Pty Ltd Jan 2012 – Jun 2012 (6 mos)
Albert worked in the implementation of a project with a customised reporting solution using SSAS, SSIS 2012 and C#.Net with Visual Studio 2010. The project was extracting data from multiple SAAS systems (like LinkedIn, Xero, SugarCRM, SAASU, Basecamp, and others) through an API using .NET and SSIS, in order to bring all the data into a unique Data Warehouse and OLAP Cube. The client considered this project a complete success, where for the first time, business users could see and consume data from many SAAS systems in a single merged dataset.
- INDEPENENT CONTRACTOR
MS Business Intelligence Consultant/Developer Independent contractor Dec 2011 – Jan 2012 (2 mos)
Working for an Australian IT company as a consultant/developer to solve problems and upgrade their current Business Intelligence solution, mostly with SSAS 2008.
BI & Web Architect Digital WavesJan 2011 – Jun 2011 (6 mos)
As team leader, working in Web and BI projects. Manager duties as responsible to find new employees to fill all the positions needed for our projects, doing interviews and teaching how and what to do in each project.
- GULF AROMA TRADING
Web Developer & Business Intelligence Consultant GULF AROMA TRADING Jan 2010 – Jul 2010 (7 mos)
Being Project Manager, I created successfully CMS websites and work on Business Intelligence DEMO and training as Microsoft BI Consultant.During all this period I had to lead a team of 3 resources.
Business Intelligence Consultant Avanade Sep 2006 – Sep 2009 (3 yrs 1 mo)
Avanade is a union from Accenture and Microsoft companies. My actual skill is a specialist in Microsoft technologies, like BI (Business Intelligence), Data ware House (Data mining), Visual Studio .NET (vb.net, c#.net, ado.net), SQL Server family like SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services and SQL Server Compact Edition (for pocket PC develop).
- ORAMA SYSTEMS SA
ASP.net Feb 2005 – Sep 2006 (1 yr 8 mos)
ASP.net Developer. Analyst developer functions. Lead a team of 3 persons. Work with Microsoft .NET Technologies: ASP.net, Compact Framework and SQL Server Data Engine. Documentation and Unit test. Using Crystal Report against ASP.net and Visual Studio for Smartphone and Pocket PC (CF). The project consists in creating and developing an own CRM for the company.
PC Developer Expectra Feb 2005 – Nov 2005 (10 mos)
Programmer in Compact Framework © Microsoft in Visual Studio 2003 and C#.net. Manage oracle database and using Web-Services. Analyst Developer and create documentation and Unit test.
Programmer Soluziona Feb 2004 – Apr 2005 (1 yr 3 mos)
Programmer TRANSACT-SQL in AUNA (under Zemsania and Soluziona). Programmer with SQL, KSH (UNIX SOLARIS), CPP y Vantive and system test.; BASIC-A [WEB AGENCY] (2003 – 2004)
Web Developer AD+ Mar 2003 – Aug 2004 (1 yr 6 mos)
Web Programmer and Application Developer.
- CATALANA OCCIDENTE SA
Junior developerJan 2001 – Jan 2002 (1 yr 1 mo)
Catalana Occidente SA (2001-2002) Junior programmer for Catalana Occidente (biggest insurance company in Catalonia). Using Cobol, systems CICS/DB2 and SQL. PREPERSA (2002). Junior Programmer for PREPER S.A. Project. Database management.
Universitat de Barcelona
Master, Business Intelligence2011 – 2012
Diploma in Information Technology, Information Technology1998 – 2001
Pedagogium Cos (Barcelona)
High Level Technical Degree; Diploma, Finance; Information Technology1996 – 1998
Licenses & certifications
- Microsoft Certified Solution Expert: SQL Server 2012 – MicrosoftIssued Sep 2014
- Microsoft Certified Solutions Associate: SQL Server 2012 – MicrosoftIssued Sep 2014Credential ID 70-457 and 70-458
- PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 – MicrosoftIssued Jan 2011Credential ID 70-452
- Technology Specialist: Microsoft SQL Server 2008, BusinessIntelligence Development and Maintenance – MicrosoftIssued Aug 2010Credential ID 70-448
- Scrum Master Certified (SMC) – Scrum AllianceIssued Dec 2018 – Expires Nov 2020Credential ID 874954
- Data Vault 2.0 PractitionerIssued Dec 2019
- Applied Machine Learning 1 of the Applied Data Science: Machine Learning program – EPFL Extension SchoolIssued May 2021
- Applied Data Analysis of the Applied Data Science: Machine Learning program – EPFL Extension SchoolIssued Nov 2020
- Introduction to Data Analysis with Python of the Applied Data Science: Machine Learning program – EPFL Extension SchoolIssued Oct 2020
- Applied Data Science: Machine Learning – EPFL Extension SchoolIssued Jun 2021Credential ID LFtQ5bSbpiiJ
Data Vault 2.0 Big Data Hadoop Hive Teradata SQL Python Microsoft SQL Server SSIS Business Intelligence Business Intelligence Tools
Honors & awards
Avanade Spain, Quarterly Delivery Excellence Award – Avanade Jul 2007Alberto García has been working on the creation of a mobile application for managing the Point of Sale requirements of the beverage area of Mahou-San Miguel. The team worked diligently to ensure that the delivery dates were met. These dates were much compromised due to delays in the design phase, but the team was successful in achieving every milestone