Fernando H.

BI/ETL DEVELOPER

676 dollar
Freelancer
18 years
Bristol, UNITED KINGDOM

My experience

More

BristolNovember 2012 - Present

Solution Architect, Developer, Instructor

At SWBI we cover all UK but we focus in the South West area where there are

tons of companies that London consultancies do not give the attention that
they deserve.

At the moment we have experts on IBM Cognos, SAP Business Objects and

Microsoft BI (SSRS & PowerBI) Reporting and Analytics. We are a small team but we have an extended network of trusted experts who have experience in

Tableau, Qlikview, Jaspersoft and several other Analytics tools.

We are experts in Data Warehousing, project management and business

analysis. I personally have years of experience in Finance Performance

Management with Cognos Planning and later with TM1.

At the moment we are exploring expanding our capacity on Big Data, Artificial

Intelligence and Machine Learning. We are also working with several charities,

therefore we are starting to create a Cloud Datawarehouse Solution specific for

charities, proving high value with low overheads, after a fairly small investment.

We are also delivering IBM Cognos courses on Report Studio, Query Studio,

Workspace Advance, IBM Cognos Connection, Framework Manager, etc.. We

can also deliver courses on other Reporting, BI and Analytics technologies.
More

Plan InternationalFebruary 2013 - Present

I was contracted to replicate IBM Cognos reports in HTML using web services

and a license free chart application. The client also requested some advise to

deliver reports to the whole company without license restrictions.

The job involved some developments in Java (Web Services) using XML,

JSON, SQL, HTML and CSS. Very exciting!

It is a pleasure to work for a charity (or NGO) that does such as great work for

children all around the world.

Updates:

- In 2014 we upgrade their systems to Cognos 10.2.1.

- During 2013 and 2014 we keep developing reports based in an adhoc

application using webservices.

Parragon
More

Make-A-Wish® UKOctober 2018 - Present

Sector: Non for profit, Technology: MS SQL Server, Snowflake, Matillion, Power BI and Tableau.

As part of their digital transformation process I took requirements and I analysed the creation of a
cloud based Datawarehouse for data integration and reporting.
More

Information partnersJanuary 2012 - September 2018

IBM Cognos BI Developer, Solution Architect and Management
(6 years 9 months)
I was initially working in the loading of facts tables in the Data Warehouse

using SSIS according to Kimball methods and in the creation of several reports

in Report Studio.

After that positive experience we started giving them support as a consultancy

company, developing new features, like an integration with Censhare or the

inclusion of new financial data sources. We also delivered training for them

and provide them with temporary staff for report development.

Sector: Publishing, Technology: IBM Cognos 8.4 SQL Server 2008. Tools

used: SSIS, Framework Manager, Report Studio.

Target Group
More

GDPRFebruary 2018 - July 2018

SSRS, C#

I led a small team to develop a solution to obfuscate Data Warehouses in line

with the new GDPR legislation. Target keeps a Data Warehouse for each of

his clients therefore we designed and developed a general solution able to

obfuscate any table based in metadata.
More

WaterAidMay 2014 - June 2016

We give support to this charity about the development of a new Data

Warehouse connected to their new CRM (Microsoft Dynamics). The

project was a success therefore the client engaged us again to work in the

enhancement of their integration hub (SSIS and MS SQL Server).
More

Standard Bank GroupAugust 2013 - April 2014

I have been contracted by Standard Bank to do maintenance of their TM1
systems and to work in the export of data to a new SAP system.

I was also creating new cubes for Global Balance Sheet reporting.
More

Self-EmployedOctober 2010 - April 2014

My main areas of expertise are: Data Warehousing, Financial Performance Management (Forecast, Budget, Cash Flows, Balance Sheets) and Business Intelligence.
I am specialised in the construction of Data Warehouse using Kimball methods, mainly over MS-SQL Server and Oracle databases.
On Business Intelligence and Financial Performance, I am specialised in Cognos Software, mainly on Planning and TM1 software, offering a strong tool to make your Forecast, Budget, Cashflows, Balance Sheets, rolling Forecast, etc.
More

VictrexFebruary 2011 - September 2013

The company decided to switch to IBM Cognos Planning all their Budget, Cash

Flow and Balance Sheets. The project was managed by another consultancy

company but the project was highly delayed. I joined the project to give them

support initially for one month but I exceeded their expectations and stayed for

five months until the project was finished.

I am continuously doing enhancement, developing new applications and giving

support to this company.

My last work was the development of a Data Warehouse for the group,

including Cognos Framework Manager design and Report Studio advice.
More

LantaresOctober 2010 - February 2011

SQL Server, Cognos Planning (Analyst, Contributor, etc).

Freelance Business Intelligence Consultant

After moving to England I continued working for Lantares as a freelancer. I
did remote support and participated in small projects in Cognos Planning,

Transformer, Report Studio, SQL Server and Data Warehousing.
More

LantaresFebruary 2008 - July 2010

(2 years 6 months)

I worked for Lantares as a employee when I was living in Barcelona.
I was working with ETLs, Cognos Planning and Cognos Express (TM1). I also

worked with other Cognos software (Impromptu, Transformer, PowerPlay,

Framework Manager, Report Studio).
More

CapgeminiApril 2006 - February 2008

I was working on improving an existing application of management of investment funds. Our client was "La Caixa" bank.
I was programming in PL/SQL, PowerBuilder 9, C++ and Unix Shell Scripting.
Then I did an application to forecast cash flows where I did some functional analysis.
For more details see my CV at the bottom of this page.
More

IBMSeptember 2004 - February 2006

General IT technician, specialised in connectivity.

My stack

XML, Web Services, Visual Basic, Tableau, SQL Server Reporting Services, SQL Server Integration Services, SQL, Spanish, Software Development, Shell Scripting, SAP, Reporter, QlikView, Project Management, PowerBuilder, Oracle PL/SQL, Oracle Financials, Oracle, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server, Machine Learning, JSON, Java, HTML, ETL, Data Warehousing, Data Warehouse, Customer relationship management, Cognos Impromptu, Cognos, C++, Business Objects, Business Intelligence, Business Analysis, Big Data, Analytics