Data Architect, Business Intelligence and Analytics Scrum Master, Blockchain Consultant

1/2016 – 10/2017

Purpose of Tilney TOM is aiming at consolidating Tilney TOM using a shared IT Infrastructure, including Technology and Data. The final state architecture included a new CRM and Invest Management system extended with a state of the art Data Warehouse used for MI Reporting, Advanced Analytics and Data Visualisation.
Contribution: Overall owner of the E2E Data Warehouse Solution, I worked with the business and Senior Stakeholder (Directors and COO) in defining the business value and ultimate scope of the Data Analytics solution. I have defined the short and long-term Data Strategy, initiated the project, Designed and finalised the High Level and low-level data architecture in terms for Model, ETL Framework, Data Architecture and External services using MSSQL2016, SSRS, SSAS, SSIS, as well as C# RestAPI used for the Service Oriented Architecture. The solution was delivered using an Agile Methodology with Continuous Delivery and Integration.

Business Intelligence (BI), Data Warehousing, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), Agile Methodologie, Scrum, C#

2/2015 – 11/2015

Biggest Multiplatform Transformation Insurance Programme in Europe aiming at improving the value given to the customer.
I covered the position of Lead Data Architect, Lead Data Modeller – Enterprise Data Warehouse and Semantic Layer.
Responsible for delivering the Enterprise Data Model using Teradata FS-LDM Industry Standard: Work with client in defining requirements, mapping requirements to out-of-the-box FS-LDM, define needed customisations to Logical Model, define Physical structure best fit for access, ETL and performance, plan and manage ETL build activities, act as Functional SME, Orchestrate activities between different vendors, present and share decisions, activities and plans to senior stakeholder (Lead Data Architects, Program Managers).
Define together with Senior IBM and Client architects design principles and patterns for a near-Real Time EDW and Semantic Layer solution on the Teradata Cloud Data Warehouse.

Business Intelligence (BI), Data Warehousing, Teradata Sql, Agile Methodologie, Scrum

4/2014 – 2/2015

Project Description: Designing and delivery of the FATCA Reporting project for RBS. The project involved collecting and sending to the relevant tax authority data for FATCA Reportable customers. I was engaged from the early stages of the project, including the feasibility study, design phase till final delivery in February 2015.
My responsibility included gathering and documenting business requirements, define scope and functionality of the reporting solution, design data model, design ETL patterns and principles, lead team of Junior Architect, Test Managers and Developers for delivery the solution.
I was also involved in project estimation and planning and presenting the proposed solutions to senior client stakeholders.
The solution was designed and build in Teradata and Informatica.

Business Intelligence (BI), Data Warehousing, ETL, Teradata Sql

9/2013 – 4/2014

I was responsible for the design assurance of the material delivered by a third party client’s supplier for the due diligence FATCA project. My role included assessing design documentation, making sure they match the business requirements and suggesting industry best practice for solving technical challenges and problems. I have applied and reviewed client’s ETL, Data Warehouse and Modelling standards to design and code against the requirements

Data Warehousing, ETL, Teradata Sql, QoS (Quality of Service)

5/2013 – 10/2015

Design and Implement an Automotive Teradata EDW solution using mLDM.
Design and Implement 2 semantic layers for Business Objects reports related to Warranty Operational and Quality Reports.

Business Intelligence (BI), Data Warehousing, ETL, Teradata Sql

4/2013 – 5/2013

I worked on a BID for a prospect requesting information about best practice and methodologies for implementing a world-class Data Warehouse using Teradata and Informatica.
I have been engaged as a Teradata SME. Bid resulted to be positive.
Contribution: I have covered different section of the bid:
- Teradata and Informatica PowerCenter best practice and architecture
- Teradata fsLDM
- Teradata and Informatica PowerCenter implementations
- Teradata training and Knowledge Transfer

Data Warehousing, ETL, Teradata Sql

11/2012 – 1/2013

Initial phase of design, scoping and analysis for an integrated Enterprise Data Warehouse.
Contribution: Source system discovery and definition. Mapping between Business questions and Data Source items. Initial Logical data modelling for mortgage and customer data.

Data Warehousing, Teradata Sql

10/2011 – 11/2012

Design and build of a tactical data warehouse needed for analyzing customer information and handling PPI complaints. : Complaints/Policy/Customer data reconciliation data warehouse for insurance customer segmentation and contact.
Design of the Database structure, ETL Architecture and Process.
Teradata/Informatica ETL tech leader, Data Design, LDM and PDM Design.
Data requirements gathering. Semantic data layer design and development. ETL delivery team leader. Test Automation.

Teradata Sql, Agile Methodologie

2/2011 – 11/2011

Customer Matching Design Process (MDM): consolidation of different data sources in a single view of customer EDW. Identify business requirements for the Customer, Account and Household entities. Design a SQL framework for matching customers and prospect across the different data sources. Data Modelling and Mapping, SMX Design, SMX Views design and definition. Design and development of an ETL Auto generator script which creates ETL code using Metadata and Data Mapping rules.

Teradata Sql, Agile Methodologie, Jira

10/2010 – 2/2011

Designing Teradata’s mixed workload performance.
Integration of Teradata with SQL Server Analysis, Integration, and Reporting Services.
Design and development of ROLAP architecture in Teradata.
Benchmark performance tuning for Teradata ETL jobs and queries.

Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Online Analytical Processing, Microsoft SQL Server Integration Services (SSIS)

6/2010 – 9/2010

Designing the ETL solution for DataStage and Teradata. I have also designed and developed templates to be sent offshore. Part of my responsibility was to ensure that the code was following the best practices

Teradata Sql

2/2010 – 5/2010

TRM Tester and Test Manager: Managing the Test team during the System Test phase. In charge of defining System Test strategy and test cases. Management of 10 Testers and Defect Life Cycle and Resolution

Teradata Sql

4/2009 – 2/2010

The objective of the project Divisional Holding Data warehouse was to provide senior management the tools for monitoring the data of profitability. The project involved the construction of a fed by data coming directly from the Legal Entities. The main end-users were the CFO and the head of the corporate division. I initially started as a Data Modeller with the responsibility to deliver the SMX Mapping document. I also worked implementing the ETL solution using DataStage. The tool was used for transforming the source file received, load them into the Staging Area and apply the Transformation required in order to load the Industry Data Model (EDW). DataStage was also used for populating the Divisional Holding Data Mart which was used by end users as a reporting database (Microstrategy)

Microstrategy, Teradata Sql, UNIX

12/2008 – 4/2009

Datastage streams into Teradata Views and Stored Procedures using BTEQ
SQL Performance tuning. Improving SQL macros for the Marketing Daily Reports. Tuning SQL and definition of Secondary and Join Indexes. Definition of Rules in the Priority Scheduler.
Physical Data Model Analysis and Design: Improving user queries. Tables and index analysis and definition. Data Physical Distribution. Physical Design Tuning

UNIX

12/2008 – 4/2009

Design and deliver a Big Data Analytical EDW for a public sector administration which needed to analyze and actively monitor the environmental data for water management purposes. One of the first project of this type in Europe. ETL design and development using Teradata utilities.
Design of Data Transformation from source to target. Development of an ETL framework
using Teradata Utilities. Defining business requirements and Analytical report definitions. Design reporting dashboard feed by EDW and Big Data infrastructure

Teradata Sql, UNIX