Might be available
(Updated 2023-02-28)Ingeniero de Datos
Organyà, Spain
Beginner French, Catalan; Valencian, English, Spanish
- Profesional independiente con experiencia en proyectos internacionales
- 15 años de experiencia en ETLs y Data Warehousing
Skills (35)
MS SQL SERVER 2012
TIME MANAGEMENT
SQL Server
PRICING
CUSTOMER RELATIONSHIP MANAGEMENT
DDL
MICROSOFT SQL SERVER 2005
MS SQL Server
BUDGET
STORED PROCEDURES
SQL
FINISHING
PRODUCTION MANAGEMENT
ACCOUNTING
INVENTORY
ORACLE 10
INSTRUCTOR
INVESTMENT BANKING
CRYPTOGRAPHIC
BUDGETING
CRM
MENTORING
Balance Sheets
PL/SQL
Oracle
MS SQL Server 2005
PUBLISHING
BI
POLYMER
Business Intelligence
DATABASE
MS SQL SERVER 2008
SQL SERVER 2008
FORECASTING
MySQL
Summary
I started my career as a developer (software and SQL), evolving to Business Intelligence, Data Warehouse developer, Data
Engineering etc. In 2012 I set up my own BI company in the UK with two business partners and teams varying from 1 to 5
developers. I was mainly in charge of running workshops with clients, designing solutions, pricing these and overseeing the
projects. I never lost touch with the development aspects of the solutions though, sometimes leading the team myself and in
some cases coding the solutions myself.
Nowadays I am not leading the company anymore, working only remotely as a freelancer.
Professional Experience
Tech
AWS Redshift, Matillion
2022-01 - Present
Supporting the team with the development of an ELT solution to report on Services KPIs. Querying different sources, like SharePoint, MS-SQL, MySQL, APIs, CSV, transforming the data and presenting it for reporting in PowerBI.
I also implemented a Development Environment separated from Production and source control using GIT.
I also implemented a Development Environment separated from Production and source control using GIT.
Tanzania, Expedition Leader
Camps International
2022-01 - Present
4 weeks) I led a trip that involves adventure activities and volunteering on sustainability projects with 24 students, 3 teachers and a junior leader.
Tech
Alzheimer's Research UK
2020-01 - 2021-01
In 2020 I designed a system (using Azure) to replicate a local Raiser's Edge database in the cloud (Snowflake). In 2021 I designed a Data Warehouse for them that was coded by a junior person that I was mentoring.
Cognos
2010-11 - 2019-01
10-11 (2019-2021) ● I got contracted to assess their poor system performance. Now ETL processes are running twice as fast and the reporting tool is smooth to use.
● I updated their systems to Cognos 11 Analytics.
● I designed a Near Real Time solution to bring data from different sources into the corporate Data Warehouse.
● I design their new, Cloud based, BI platform (still to be implemented)
● I updated their systems to Cognos 11 Analytics.
● I designed a Near Real Time solution to bring data from different sources into the corporate Data Warehouse.
● I design their new, Cloud based, BI platform (still to be implemented)
Trainer / Instructor
NERC, SNS Bank
2015-01 - 2019-01
I have been delivering IBM Cognos reporting courses at beginner & advanced level to a number of clients, these courses were tailored to the needs of the client, which often meant I would provide ongoing remote support where I would develop complex reports using Cognos 10.2.
● WaterAid, Sector: NGO-Charity, Technology: MS SQL Server 2012, SQL SSIS (2015-2016) I developed a new Data Warehouse (DWH) following a CRM migration. I worked with the client closely as they wanted to enhance their own technical knowledge as part of the project. The project was a success and I was contracted to improve other areas of their "Integration Hub", an ETL tool that works as an interface between WaterAid and marketing agencies.
● WaterAid, Sector: NGO-Charity, Technology: MS SQL Server 2012, SQL SSIS (2015-2016) I developed a new Data Warehouse (DWH) following a CRM migration. I worked with the client closely as they wanted to enhance their own technical knowledge as part of the project. The project was a success and I was contracted to improve other areas of their "Integration Hub", an ETL tool that works as an interface between WaterAid and marketing agencies.
Bud Systems
2018-01 - 2019-01
Sector: Technology, Technology: Azure SQL & Data Factory, PowerBI T-SQL, (2019) Bud is a platform to manage apprenticeships. They wanted to improve their reporting capabilities through a Data Warehouse.
This was a greenfield project. Together we decided on the technologies to be used and I developed the DWH. After finishing the project, the company contracted a permanent DWH developer and a PowerBI developer to maintain and expand their systems.
All their systems are in the Cloud.
● Make a Wish, Sector: Non for profit, Technology: MS SQL Server, Snowflake, Matillion, Power BI (2018-2019) As part of their digital transformation process, I took requirements and designed a cloud based Datawarehouse for data integration and reporting. Afterwards I supported my team on the development of the solution.
● Secure Cloud +, Sector: IT, Technology: SQL Server 2016 (2018-2019) Secure Cloud provides secure solutions for the British Government.
In 2018 I participated in the evaluation and design of few solutions. For one of the projects, we assessed WebFOCUS, SSRS and PowerBI, finally creating a solution in Power BI. For another project we assessed a solution coded in Java and R, finally using mainly R.
In 2019 I collaborated with them on a short project for the Home Office where we evaluated cryptographic solutions.
This was a greenfield project. Together we decided on the technologies to be used and I developed the DWH. After finishing the project, the company contracted a permanent DWH developer and a PowerBI developer to maintain and expand their systems.
All their systems are in the Cloud.
● Make a Wish, Sector: Non for profit, Technology: MS SQL Server, Snowflake, Matillion, Power BI (2018-2019) As part of their digital transformation process, I took requirements and designed a cloud based Datawarehouse for data integration and reporting. Afterwards I supported my team on the development of the solution.
● Secure Cloud +, Sector: IT, Technology: SQL Server 2016 (2018-2019) Secure Cloud provides secure solutions for the British Government.
In 2018 I participated in the evaluation and design of few solutions. For one of the projects, we assessed WebFOCUS, SSRS and PowerBI, finally creating a solution in Power BI. For another project we assessed a solution coded in Java and R, finally using mainly R.
In 2019 I collaborated with them on a short project for the Home Office where we evaluated cryptographic solutions.
Target Group
2012-01 - 2018-01
Technology: MS SQL Server 2016, SQL SSIS, (2018) In this project a led a team of 3 people to develop a solution to meet the new GDPR legislation in their Data Warehouses and Reports. One part of the solution was to deliver reports in SSRS and to generate CSV files. A second part of it focused on the obfuscation of personal data in the data warehouse using a combination of SSIS, Stored Procedures and MS Master Data Services (Master Data Management).
● Parragon, Sector: Publishing, Technology: IBM Cognos 8.4&10.2.1, SQL Server 2008 (2012-2018) I have been working with this client for a number of years on a variety of projects covering areas such as inventory, finance, production management and sales. I have developed processes and systems to add new data to the DWH (from MS SQL Server, Oracle and flat files), applied complex business logics to the ETL process, developed the BI infrastructure, and deployed associated technical solutions for different areas of the business.
I have been also heavily involved in the design of different Framework Manager models and a variety of Report Studio reports, dashboards, scorecards and Active Reports. A key recent project has focused on evaluating the inclusion of accounting information into the Data Warehouse to easily create P&Ls, Balance Sheets, Consolidations, Aggregations, etc.
● Parragon, Sector: Publishing, Technology: IBM Cognos 8.4&10.2.1, SQL Server 2008 (2012-2018) I have been working with this client for a number of years on a variety of projects covering areas such as inventory, finance, production management and sales. I have developed processes and systems to add new data to the DWH (from MS SQL Server, Oracle and flat files), applied complex business logics to the ETL process, developed the BI infrastructure, and deployed associated technical solutions for different areas of the business.
I have been also heavily involved in the design of different Framework Manager models and a variety of Report Studio reports, dashboards, scorecards and Active Reports. A key recent project has focused on evaluating the inclusion of accounting information into the Data Warehouse to easily create P&Ls, Balance Sheets, Consolidations, Aggregations, etc.
Tech
Plan International
2013-01 - 2018-01
I was contracted to create reports in HTML using Java web services and a chart application, with Cognos as the underlying metadata management tool. After this initial successful project I retained an advisory role for the client guiding them to use the best business intelligence solutions to meet their needs.
In 2014 I migrated their BI systems to Cognos 10.2 (new installation). In 2016 I migrated their cubes to Dynamic Cubes to support multilingual reporting.
In 2014 I migrated their BI systems to Cognos 10.2 (new installation). In 2016 I migrated their cubes to Dynamic Cubes to support multilingual reporting.
Standard Bank
2014-01 - 2014-01
Maintenance of their TM1 systems, development of a data export process to a new SAP system and the creation of a new application for Global Balance Sheet reporting.
Tech
Overheads and Payroll
2010-01 - 2011-01
2013) In 2011 the company decided to switch all their Budget, Cash Flow and Balance Sheets to IBM Cognos Planning. I created the necessary applications and processes to ensure accuracy and currency of the data.
In 2012 the Invibio division engaged me to develop enhancements to their current applications and to design the new Reforecast models for Revenue, Overheads and Payroll. Later the group contracted me to develop a consolidation application.
In 2013 I developed their corporate Data Warehouse. I also provided them with support on the creation of Framework Manager models and Report Studio reports in IBM Cognos.
In 2012 the Invibio division engaged me to develop enhancements to their current applications and to design the new Reforecast models for Revenue, Overheads and Payroll. Later the group contracted me to develop a consolidation application.
In 2013 I developed their corporate Data Warehouse. I also provided them with support on the creation of Framework Manager models and Report Studio reports in IBM Cognos.
Volunteering for NGO, Role
2011-01 - 2011-01
I worked in the setup of two computer rooms and the sponsorship of 300 bicycles for schools in the outskirts of Ouagadougou, Burkina Faso (West Africa).
Other personal projects
Novartis
2008-01 - 2010-01
Sector: Pharma, Technology: IBM Cognos 8.3, .Net (VB) and Oracle 10 (2008-2010) Development of the DWH using Kimball methodology and the design of .Net programs and reports.
Other personal projects
Other personal projects
Tech
Barceló Hotels & Resorts
2009-01 - 2010-01
I developed several Forecasting and Budgeting applications for the whole company (Hotels management, HR, Marketing, CAPEX, etc). I was responsible for the software infrastructure (5 servers), the construction of the DWH using SSIS and the development of a variety of EP applications.
Dimensions, Cubes and Planning Contributor Administrator
DWH
2009-01 - 2009-01
collecting information from several sources using T-SQL, feeding applications developed in Cognos Planning. Working closely with the Enterprise Planning developers I guided them in the administration of EP, loading Dimensions, Cubes and Planning Contributor Administrator.
Certifications
MS SQL Server 2008, BI Development and Maintenance (70-448: SSIS, SSRS, SSAS)
MS SQL Server 2008, Implementing and Maintenance (70-432: DBA)
IBM Certified Solution Designer - Cognos Planning 8
Methodology of tests and inspection of software
Oracle DB 10i administration and development
IBM Certified Developer - Cognos TM1
IBM Certified Solution Designer
IBM Certified Developer
Certified Developer
Time management
PowerBuilder 9
IBM Certified
Team work