freiberufler Data Architect, Business Intelligence and Analytics Scrum Master, Blockchain Consultant auf freelance.de

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

offline
  • auf Anfrage
  • 40457 Duesseldorf
  • Europa
  • it  |  en
  • 04.07.2019

Kurzvorstellung

A Scrum/Lean/Agile experience Data Architect with experience in delivering complex Data Warehouse, Business Intelligence and Data Analytics solutions across different sectors.

Qualifikationen

  • Big Data
  • Blockchain (allg.)
  • Business Intelligence (BI)
  • Datawarehouse / DWH
  • ETL
  • Lean Management
  • SCRUM
  • Teradata

Projekt‐ & Berufserfahrung

Blockchain Architect
Kundenname anonymisiert, Remote
8/2018 – offen (5 Jahre, 8 Monate)
Startup
Tätigkeitszeitraum

8/2018 – offen

Tätigkeitsbeschreibung

Working on a Blockchain solution for ICO based on Ethereum and Hyperledger Fabric. Defined Data Strategy and Solution Design. Created a working prototype and

Eingesetzte Qualifikationen

Blockchain (allg.)

Data Architect
Kundenname anonymisiert, Duesseldorf
2/2018 – offen (6 Jahre, 2 Monate)
Telekommunikation
Tätigkeitszeitraum

2/2018 – offen

Tä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

Senior Business Intelligence Data Engineer
Kundenname anonymisiert, Hamburg
10/2017 – 1/2018 (4 Monate)
Fintech
Tätigkeitszeitraum

10/2017 – 1/2018

Tä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

Data Services Delivery Manager and Product Owner
Kundenname anonymisiert, London
1/2016 – 10/2017 (1 Jahr, 10 Monate)
Wealth Managment
Tätigkeitszeitraum

1/2016 – 10/2017

Tä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.

Eingesetzte Qualifikationen

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#

Lead Data Modeler
Kundenname anonymisiert, London
2/2015 – 11/2015 (10 Monate)
Versicherungen
Tätigkeitszeitraum

2/2015 – 11/2015

Tä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.

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, Teradata, Agile Entwicklung, SCRUM

Lead Data Architect
Kundenname anonymisiert, Edinburg
4/2014 – 2/2015 (11 Monate)
Banken
Tätigkeitszeitraum

4/2014 – 2/2015

Tä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.

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, ETL, Teradata

Quality Assurance - Design and Delivery
Kundenname anonymisiert, Edinburg
9/2013 – 4/2014 (8 Monate)
Banken
Tätigkeitszeitraum

9/2013 – 4/2014

Tä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 requirements

Eingesetzte Qualifikationen

Datawarehouse / DWH, ETL, Teradata, QoS (Quality of Service)

Teradata Consultant
Kundenname anonymisiert, Coventry
5/2013 – 10/2015 (2 Jahre, 6 Monate)
Automobilindustrie
Tätigkeitszeitraum

5/2013 – 10/2015

Tä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.

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, ETL, Teradata

DWH Consultant
Kundenname anonymisiert, London
4/2013 – 5/2013 (2 Monate)
Banken
Tätigkeitszeitraum

4/2013 – 5/2013

Tä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

Eingesetzte Qualifikationen

Datawarehouse / DWH, ETL, Teradata

DWH Consultant
Kundenname anonymisiert, Edinburgh
11/2012 – 1/2013 (3 Monate)
Banken
Tätigkeitszeitraum

11/2012 – 1/2013

Tä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.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Teradata

Data Architect
Kundenname anonymisiert, London
10/2011 – 11/2012 (1 Jahr, 2 Monate)
Banken
Tätigkeitszeitraum

10/2011 – 11/2012

Tä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.

Eingesetzte Qualifikationen

Teradata, Agile Entwicklung

Data Modeler and MDM Consultant
Kundenname anonymisiert, London
2/2011 – 11/2011 (10 Monate)
Versorgungswirtschaft
Tätigkeitszeitraum

2/2011 – 11/2011

Tä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

Teradata Consultant - High Performance DWH
Kundenname anonymisiert, London
10/2010 – 2/2011 (5 Monate)
Banken
Tätigkeitszeitraum

10/2010 – 2/2011

Tä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.

Eingesetzte Qualifikationen

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

Teradata Consultant - Data Architect
Kundenname anonymisiert, London
6/2010 – 9/2010 (4 Monate)
Banken
Tätigkeitszeitraum

6/2010 – 9/2010

Tä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 practices

Eingesetzte Qualifikationen

Teradata

CRM Implementation Test Manager
Kundenname anonymisiert, Bristol
2/2010 – 5/2010 (4 Monate)
Banken
Tätigkeitszeitraum

2/2010 – 5/2010

Tä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 Resolution

Eingesetzte Qualifikationen

Teradata

Teradata Consultant - Data Modeller - Data Architect
Kundenname anonymisiert, Rome
4/2009 – 2/2010 (11 Monate)
Banken
Tätigkeitszeitraum

4/2009 – 2/2010

Tä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

Teradata Consultant
Kundenname anonymisiert, Siena
12/2008 – 4/2009 (5 Monate)
Banken
Tätigkeitszeitraum

12/2008 – 4/2009

Tä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

Eingesetzte Qualifikationen

UNIX

Professional Services Consultnat
Kundenname anonymisiert, Venice
12/2008 – 4/2009 (5 Monate)
Hochschulen und Forschungseinrichtungen
Tätigkeitszeitraum

12/2008 – 4/2009

Tä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

Eingesetzte Qualifikationen

Teradata, UNIX

Zertifikate

Scrum Product Owner
2017

Ausbildung

Computer Science and Business
Master of Science
2006
Lecce

Weitere Kenntnisse

Teradata Master, Scrum Product Owner

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Italienisch (Muttersprache)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2210
Alter
44
Berufserfahrung
15 Jahre und 3 Monate (seit 12/2008)
Projektleitung
5 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden