Projekt‐ & Berufserfahrung
8/2018 – offenTätigkeitsbeschreibung
Working on a Blockchain solution for ICO based on Ethereum and Hyperledger Fabric. Defined Data Strategy and Solution Design. Created a working prototype andEingesetzte Qualifikationen
2/2018 – offenTätigkeitsbeschreibung
Designing and implementing the IFRS15 Semantic model based on the Teradata LDM and IBM Comms Dimensional Modelling, using WhereEscape, Python and BTEQ as ELT tools. I worked together with senior architects and product owners in defining key components and delivery strategy; I have followed with the design and implementation of the Prototype solution, which allowed delivering value to the business in quick iterations and small sprint. I acted as a Teradata SME and Technical team lead for design and implementation, guiding the group of developers. I have designed and implemented Solution Design for ETL Architecture, Data Modelling, Data and Test Automation, and Code Simplification.Eingesetzte Qualifikationen
Business Intelligence (BI), Datawarehouse / DWH, Teradata, SCRUM
10/2017 – 1/2018Tätigkeitsbeschreibung
I the most successful fintech startup in Europe I helped in re-designing and implement a new Data Warehouse and Analytics solution. Designed and implemented a state of the art cloud based Analytics solution based on the Data Lake and Data Vault approach. The Data Warehouse, fed by Artificial Intelligence and Web-Based data sourced, analysed and reported in near-real-time data for over 30 million customers and prospect.Eingesetzte Qualifikationen
Data Science, Business Intelligence (BI), Datawarehouse / DWH, SCRUM, Python
1/2016 – 10/2017Tätigkeitsbeschreibung
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), Datawarehouse / DWH, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), Agile Entwicklung, SCRUM, C#
2/2015 – 11/2015Tätigkeitsbeschreibung
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), Datawarehouse / DWH, Teradata, Agile Entwicklung, SCRUM
4/2014 – 2/2015Tätigkeitsbeschreibung
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), Datawarehouse / DWH, ETL, Teradata
9/2013 – 4/2014Tätigkeitsbeschreibung
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 requirementsEingesetzte Qualifikationen
Datawarehouse / DWH, ETL, Teradata, QoS (Quality of Service)
5/2013 – 10/2015Tätigkeitsbeschreibung
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), Datawarehouse / DWH, ETL, Teradata
4/2013 – 5/2013Tätigkeitsbeschreibung
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
Datawarehouse / DWH, ETL, Teradata
11/2012 – 1/2013Tätigkeitsbeschreibung
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.
Datawarehouse / DWH, Teradata
10/2011 – 11/2012Tätigkeitsbeschreibung
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, Agile Entwicklung
2/2011 – 11/2011Tätigkeitsbeschreibung
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.Eingesetzte Qualifikationen
Teradata, Agile Entwicklung, Jira
10/2010 – 2/2011Tätigkeitsbeschreibung
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 (OLAP), Microsoft SQL Server Integration Services (SSIS)
6/2010 – 9/2010Tätigkeitsbeschreibung
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 practicesEingesetzte Qualifikationen
2/2010 – 5/2010Tätigkeitsbeschreibung
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 ResolutionEingesetzte Qualifikationen
4/2009 – 2/2010Tätigkeitsbeschreibung
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)Eingesetzte Qualifikationen
MicroStrategy, Teradata, UNIX
12/2008 – 4/2009Tätigkeitsbeschreibung
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
12/2008 – 4/2009Tätigkeitsbeschreibung
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