Creating Enterprise Data Platforms for the Real World
Aktualisiert am 07.07.2024
Profil
Referenzen (5)
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 02.09.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Enterprise Data Architect
Enterprise Data Strategist
Solutions Architect
Datenintegration
Datenmodellierung
Datenanalyse
Oracle DBA
Oracle 19c
Oracle 12c
Azure
AWS
Metadaten
PL/SQL
ETL-Programmierung
Datenmigration
MDM
GDPR
BCBS 239
Deutsch
fließend (Wort und Schrift)
Englisch
Muttersprache
Französisch
gut (Wort und Schrift)
Italienisch
Grundkenntnisse
Spanisch
gut

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich

Arbeitserlaubnis: EU-Staatsbürger - Arbeitserlaubnis nicht erforderlich

möglich

Projekte

Projekte

2 Jahre 4 Monate
2021-12 - 2024-03

Creating technology independent enterprise data platforms

Enterprise data architect, metadata architect, chief data strategist
Enterprise data architect, metadata architect, chief data strategist
Working with a tech startup that is developing an enterprise data platform which allows users to manage data independently of technology; my role in this project has been to design and implement the metadata architecture which forms the foundation of this new system.
Azure various databases SOA/Microservices Oracle Designer
Alchemy Data Solutions Ltd
Remote
2 Jahre
2019-12 - 2021-11

Development of an enterprise-level CRM platform.

Enterprise Data Solutions Architect; Technical Project Leader. Oracle 18c/19c GCP Snowflake ...
Enterprise Data Solutions Architect; Technical Project Leader.

Working with a private bank to develop an enterprise level CRM architecture which supports users wishing to up-sell and cross-sell a wider range of products and services to new and existing customers.

The background to this project was the need to simplify, expand and automate the bank?s ability to carry out effective CRM campaigns, and this was achieved by creating an integrated business and technical data architecture based on shared metadata standards and protocols. The result was a ?seamless? platform which covers all aspects of CRM work from identifying data sources and potential prospects through to defining and monitoring campaigns, with all tasks and activities being defined in terms of the same metadata protocols, thus enabling a high degree of process automation and allowing users to collaborate much more easily on specific CRM initiatives.

Oracle 18c/19c GCP Snowflake SOA/Microservices
Private bank, Benelux
2 Jahre 2 Monate
2017-08 - 2019-09

Creating enterprise-level data strategy and data governance frameworks

Chief Data Architect for Group Technology Services (GTIS) Oracle 12c/18c SQL Server AWS ...
Chief Data Architect for Group Technology Services (GTIS)

Defining a comprehensive data strategy and data governance framework for the bank?s IT division.

I joined Barclays as the first ever chief data architect in a division that was run by technologists, most of whom believed that having to worry about data would just get in the way of the ?real work? of managing the bank?s IT infrastructure; in order to overcome this scepticism I had to devise a data strategy which would support BAU while at the same time laying the foundations for long-term digital transformation.

My solution to this challenge was based on the realisation that by creating parallel data architectures ? i.e. one reflecting data as defined by business users, another reflecting physical data sources ? it would be possible to gradually build an integrated data architecture without affecting BAU: GDPR for example could be documented and validated in business terms before it was put into practice incrementally, thus greatly simplifying what otherwise would have been a very complex task; and migrating legacy data sources to the cloud (specifically AWS) could be handled in the same, controlled way.

As well as designing and implementing this solution, I was also responsible for ensuring that all stakeholders understood how this new data architecture was intended to work, and how their data would ultimately be integrated into the overall logical and physical data architecture.

Oracle 12c/18c SQL Server AWS Collibra SOA/Microservices
Barclays Bank, London
2 Jahre 2 Monate
2015-05 - 2017-06

Create a data and technical strategy for real-time BI

Enterprise solutions architect, technical project leader Oracle 12c/18c SOA XML ...
Enterprise solutions architect, technical project leader

Define and implement a data and technical strategy for enterprise level real-time BI.

The background to this project was the need to provide UK police forces with a new BI platform which would provide

  • real-time information

  • the ability to securely share data between police forces

  • the ability for police forces to customise their KPI?s as and when needed

  • support for mobile devices?

  • the ability to reflect and respond to changes in legislation

As the project?s solutions architect I was responsible for designing and implementing the first version of this platform and then organising a series of workshops and seminars to demonstrate how this new platform differed from the data warehouses which police forces had used in the past.

Oracle 12c/18c SOA XML Big Data SOA/Microservices Oracle Designer
UK Police Forces
Home Office
2 Jahre
2013-04 - 2015-03

Create a metadata driven data hub for BCBS 239, market risk, asset management

BCBS 239 programme lead, data/solutions architect, data strategy consultant Oracle 12c Oracle Designer Power Designer
BCBS 239 programme lead, data/solutions architect, data strategy consultant

My work at Deutsche Bank involved creating a metadata driven hub for all market risk related data, both to meet BCBS 239 requirements and to provide asset management teams with more flexible market risk metrics. As the project?s data and solutions architect I was responsible for creating the logical and physical data models for all components of the new data hub, as well as implementing the system?s metadata layer.

Oracle 12c Oracle Designer Power Designer
Deutsche Bank, London
2 Jahre 6 Monate
2010-09 - 2013-02

Creating an integrated data hub for credit/market risk and asset management

BI solutions architect, technical project leader, development DBA Oracle 12c Oracle Designer Informatica
BI solutions architect, technical project leader, development DBA

This assignment involved migrating three legacy data warehouses into a new BI platform which could provide a 360 degree view of all credit and market risk data. As the project?s technical architect I was responsible for all data modelling and database design work as well as for defining the ETL roadmap which was used to migrate legacy data into the new BI architecture.

Oracle 12c Oracle Designer Informatica
Credit Suisse, Zurich
1 Jahr 11 Monate
2008-10 - 2010-08

Enterprise DWH, MDM, SOA, ODS, MiFID, data governance, data migration

Enterprise data architect, SOA architect, Oracle DBA, BI project leader
Enterprise data architect, SOA architect, Oracle DBA, BI project leader

The goal of this project was to create an integrated data hub which allowed the FSA to analyse credit and market risk patterns in the trading of financial instruments on the London Stock Exchange. As the lead data and technical architect I was responsible for: (1) creating the logical and physical data models for all components of the project?s ODS and data warehouse; (2) analysing source data; (3) defining the data quality standards which underpinned the system?s ETL processes.

Financial Services Authority (FSA) London
2 Jahre 1 Monat
2006-09 - 2008-09

Consultancy specialising in data quality (MDM, SOA, BI) and data migration

Solutions architect, technical project manager, enterprise data architect, DBA
Solutions architect, technical project manager, enterprise data architect, DBA

Matrix Data is an IT consultancy which specialises in data quality issues and I was engaged to work on a number of Oracle related projects for clients wishing to improve the quality and usability of their data.

Matrix Data, London
1 Jahr
2005-09 - 2006-08

Market risk reporting, asset management, MDM, BI refactoring, MiFID

Solutions architect, enterprise data architect, technical project leader, DBA
Solutions architect, enterprise data architect, technical project leader, DBA

This project involved refactoring an existing BI system in order to improve its performance and usability.

European Central Bank, Frankfurt
1 Jahr 1 Monat
2004-07 - 2005-07

Provide a single view of product data (MDM), CRM, SOA, data migration

Data architect, solutions architect, technical project leader, ETL architect
Data architect, solutions architect, technical project leader, ETL architect

The goal of this project was to create a new database which could provide a single view of product data for all Warner Bros offices worldwide. Within the project I was responsible for creating the required ETL architecture and for defining the data transformations in business and technical terms.

Warner Bros, London

Aus- und Weiterbildung

Aus- und Weiterbildung

Studium - Informatik

University of Salford, England

Abschluss: Master of Science

Studium - Germanistik

University of Manchester, England

Abschluss: Bachelor of Arts (hons)

Position

Position

  • Technischer Architekt

  • Datenarchitekt

  • Datenmanager

  • Datenanalytiker

  • Datenmodellierer

  • Oracle DBA

  • PL/SQL Entwickler

  • SOA-Architekt bzw. Entwickler

  • Analyse von Geschäftsprozessen

  • Datenbankdesign und -administration

  • Technische Projektleitung

Kompetenzen

Kompetenzen

Top-Skills

Enterprise Data Architect Enterprise Data Strategist Solutions Architect Datenintegration Datenmodellierung Datenanalyse Oracle DBA Oracle 19c Oracle 12c Azure AWS Metadaten PL/SQL ETL-Programmierung Datenmigration MDM GDPR BCBS 239

Produkte / Standards / Erfahrungen / Methoden

IT Experience

  • Enterprise data architecture and data governance

  • Data solutions architect (MDM/BI/MI/ETL/ODS)

  • Data modelling (logical/physical/dimensional/network)

  • SOA/Microservices architect

  • Technical PM/Development DBA (Oracle)

  • Creating metadata driven corporate data hubs

  • Data profiling, data quality management

  • Mentoring/training users and developers in data best practices

  • Devising data strategies to enable digital transformation initiatives

Technische Erfahrung

  • Technischer Architekt (Oracle)

  • Datenarchitekt, Datenanalytiker

  • Datenmodellierung

  • Softwareentwickler

  • Entwicklungs-DBA (Oracle)

  • Business Analyst

  • Technischer Projektleiter

  • Architekt für Datenqualität

  • SOA-Architekt 

  • Oracle-Mentor

  • BI-Systeme erneuern

 

Fachliche Erfahrung

  • Datawarehousing (DWH), Business-Intelligence, Finanzhandel, Bilanzen, CRM

  • Erstellung von integrierten, unternehmensweiten Datenbanken (ODS, Data Hubs)

  • Master Data Management (MDM), Datenqualitätsanalyse

  • Datenmigration, Implementierung von ETL-Systemen auf Basis von SOA

  • Risikokontrolle im Finanzbereich (Basel II, Sarbanes Oxley)

  • Analyse von Daten und Geschäftsprozessen

  • Produktionssteuerung und Materialverwaltung für Fertigungsunternehmen

  • Wholesale financial markets: credit/market risk, KYC

  • Regulatory reporting: Sarbanes/Oxley, BCBS 239

  • Corporate data governance, data security, GDPR

  • Asset management: securities, commercial real estate, investment portfolios

  • Sales and marketing: retail sector, CRM, KYC

  • Travel and tourism: airlines, railways

 

Produktkenntnisse

  • Data/ Business Analysis

    • Data modelling (logical/physical)

    • DWH modelling (reporting/OLAP)

    • Data gap analysis

    • Data quality profiling

    • Data dictionary creation

    • Metadata governance

    • Master data management (MDM)

    • Enterprise data architecture

    • SOA project methodology

  • Development / ETL Tools

    • Oracle Designer (6.0, 6i, 9i)

    • Erwin/EA Studio/ PowerDesigner

    • Informatica

Berufserfahrung

1995-05 - 2017-06

Position: Freelance IT consultant

2017-07 - 2019-08

Firma: Barclays Bank

Position: Chief Data Architect

2019-09 - heute

Position: Enterprise Data Architect

Betriebssysteme

Unix
Linux/Red Hat, Solaris
Windows

Programmiersprachen

Java
Pascal
PL/SQL
UNIX shell scripting
SQL
XML
UNIX
Linux, Solaris, AIX, HP/UX
Json
Python

Datenbanken

Oracle RDBMS
11g, 10g, 9i
Oracle Utilities
Data Pump, RMAN etc.
Oracle Enterprise Manager
Toad
SQL Navigator
Oracle Datenbank- und Anwendungsoptimierung
Cloud platforms
AWS, Snowflake

Datenkommunikation

Hardware

Design / Entwicklung / Konstruktion

Data Quality Profiling

Branchen

Branchen

  • Banking and Finance

  • Marketing

  • Air transport

  • Wholesale and retail trade

  • Consumer goods manufacturing

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich

Arbeitserlaubnis: EU-Staatsbürger - Arbeitserlaubnis nicht erforderlich

möglich

Projekte

Projekte

2 Jahre 4 Monate
2021-12 - 2024-03

Creating technology independent enterprise data platforms

Enterprise data architect, metadata architect, chief data strategist
Enterprise data architect, metadata architect, chief data strategist
Working with a tech startup that is developing an enterprise data platform which allows users to manage data independently of technology; my role in this project has been to design and implement the metadata architecture which forms the foundation of this new system.
Azure various databases SOA/Microservices Oracle Designer
Alchemy Data Solutions Ltd
Remote
2 Jahre
2019-12 - 2021-11

Development of an enterprise-level CRM platform.

Enterprise Data Solutions Architect; Technical Project Leader. Oracle 18c/19c GCP Snowflake ...
Enterprise Data Solutions Architect; Technical Project Leader.

Working with a private bank to develop an enterprise level CRM architecture which supports users wishing to up-sell and cross-sell a wider range of products and services to new and existing customers.

The background to this project was the need to simplify, expand and automate the bank?s ability to carry out effective CRM campaigns, and this was achieved by creating an integrated business and technical data architecture based on shared metadata standards and protocols. The result was a ?seamless? platform which covers all aspects of CRM work from identifying data sources and potential prospects through to defining and monitoring campaigns, with all tasks and activities being defined in terms of the same metadata protocols, thus enabling a high degree of process automation and allowing users to collaborate much more easily on specific CRM initiatives.

Oracle 18c/19c GCP Snowflake SOA/Microservices
Private bank, Benelux
2 Jahre 2 Monate
2017-08 - 2019-09

Creating enterprise-level data strategy and data governance frameworks

Chief Data Architect for Group Technology Services (GTIS) Oracle 12c/18c SQL Server AWS ...
Chief Data Architect for Group Technology Services (GTIS)

Defining a comprehensive data strategy and data governance framework for the bank?s IT division.

I joined Barclays as the first ever chief data architect in a division that was run by technologists, most of whom believed that having to worry about data would just get in the way of the ?real work? of managing the bank?s IT infrastructure; in order to overcome this scepticism I had to devise a data strategy which would support BAU while at the same time laying the foundations for long-term digital transformation.

My solution to this challenge was based on the realisation that by creating parallel data architectures ? i.e. one reflecting data as defined by business users, another reflecting physical data sources ? it would be possible to gradually build an integrated data architecture without affecting BAU: GDPR for example could be documented and validated in business terms before it was put into practice incrementally, thus greatly simplifying what otherwise would have been a very complex task; and migrating legacy data sources to the cloud (specifically AWS) could be handled in the same, controlled way.

As well as designing and implementing this solution, I was also responsible for ensuring that all stakeholders understood how this new data architecture was intended to work, and how their data would ultimately be integrated into the overall logical and physical data architecture.

Oracle 12c/18c SQL Server AWS Collibra SOA/Microservices
Barclays Bank, London
2 Jahre 2 Monate
2015-05 - 2017-06

Create a data and technical strategy for real-time BI

Enterprise solutions architect, technical project leader Oracle 12c/18c SOA XML ...
Enterprise solutions architect, technical project leader

Define and implement a data and technical strategy for enterprise level real-time BI.

The background to this project was the need to provide UK police forces with a new BI platform which would provide

  • real-time information

  • the ability to securely share data between police forces

  • the ability for police forces to customise their KPI?s as and when needed

  • support for mobile devices?

  • the ability to reflect and respond to changes in legislation

As the project?s solutions architect I was responsible for designing and implementing the first version of this platform and then organising a series of workshops and seminars to demonstrate how this new platform differed from the data warehouses which police forces had used in the past.

Oracle 12c/18c SOA XML Big Data SOA/Microservices Oracle Designer
UK Police Forces
Home Office
2 Jahre
2013-04 - 2015-03

Create a metadata driven data hub for BCBS 239, market risk, asset management

BCBS 239 programme lead, data/solutions architect, data strategy consultant Oracle 12c Oracle Designer Power Designer
BCBS 239 programme lead, data/solutions architect, data strategy consultant

My work at Deutsche Bank involved creating a metadata driven hub for all market risk related data, both to meet BCBS 239 requirements and to provide asset management teams with more flexible market risk metrics. As the project?s data and solutions architect I was responsible for creating the logical and physical data models for all components of the new data hub, as well as implementing the system?s metadata layer.

Oracle 12c Oracle Designer Power Designer
Deutsche Bank, London
2 Jahre 6 Monate
2010-09 - 2013-02

Creating an integrated data hub for credit/market risk and asset management

BI solutions architect, technical project leader, development DBA Oracle 12c Oracle Designer Informatica
BI solutions architect, technical project leader, development DBA

This assignment involved migrating three legacy data warehouses into a new BI platform which could provide a 360 degree view of all credit and market risk data. As the project?s technical architect I was responsible for all data modelling and database design work as well as for defining the ETL roadmap which was used to migrate legacy data into the new BI architecture.

Oracle 12c Oracle Designer Informatica
Credit Suisse, Zurich
1 Jahr 11 Monate
2008-10 - 2010-08

Enterprise DWH, MDM, SOA, ODS, MiFID, data governance, data migration

Enterprise data architect, SOA architect, Oracle DBA, BI project leader
Enterprise data architect, SOA architect, Oracle DBA, BI project leader

The goal of this project was to create an integrated data hub which allowed the FSA to analyse credit and market risk patterns in the trading of financial instruments on the London Stock Exchange. As the lead data and technical architect I was responsible for: (1) creating the logical and physical data models for all components of the project?s ODS and data warehouse; (2) analysing source data; (3) defining the data quality standards which underpinned the system?s ETL processes.

Financial Services Authority (FSA) London
2 Jahre 1 Monat
2006-09 - 2008-09

Consultancy specialising in data quality (MDM, SOA, BI) and data migration

Solutions architect, technical project manager, enterprise data architect, DBA
Solutions architect, technical project manager, enterprise data architect, DBA

Matrix Data is an IT consultancy which specialises in data quality issues and I was engaged to work on a number of Oracle related projects for clients wishing to improve the quality and usability of their data.

Matrix Data, London
1 Jahr
2005-09 - 2006-08

Market risk reporting, asset management, MDM, BI refactoring, MiFID

Solutions architect, enterprise data architect, technical project leader, DBA
Solutions architect, enterprise data architect, technical project leader, DBA

This project involved refactoring an existing BI system in order to improve its performance and usability.

European Central Bank, Frankfurt
1 Jahr 1 Monat
2004-07 - 2005-07

Provide a single view of product data (MDM), CRM, SOA, data migration

Data architect, solutions architect, technical project leader, ETL architect
Data architect, solutions architect, technical project leader, ETL architect

The goal of this project was to create a new database which could provide a single view of product data for all Warner Bros offices worldwide. Within the project I was responsible for creating the required ETL architecture and for defining the data transformations in business and technical terms.

Warner Bros, London

Aus- und Weiterbildung

Aus- und Weiterbildung

Studium - Informatik

University of Salford, England

Abschluss: Master of Science

Studium - Germanistik

University of Manchester, England

Abschluss: Bachelor of Arts (hons)

Position

Position

  • Technischer Architekt

  • Datenarchitekt

  • Datenmanager

  • Datenanalytiker

  • Datenmodellierer

  • Oracle DBA

  • PL/SQL Entwickler

  • SOA-Architekt bzw. Entwickler

  • Analyse von Geschäftsprozessen

  • Datenbankdesign und -administration

  • Technische Projektleitung

Kompetenzen

Kompetenzen

Top-Skills

Enterprise Data Architect Enterprise Data Strategist Solutions Architect Datenintegration Datenmodellierung Datenanalyse Oracle DBA Oracle 19c Oracle 12c Azure AWS Metadaten PL/SQL ETL-Programmierung Datenmigration MDM GDPR BCBS 239

Produkte / Standards / Erfahrungen / Methoden

IT Experience

  • Enterprise data architecture and data governance

  • Data solutions architect (MDM/BI/MI/ETL/ODS)

  • Data modelling (logical/physical/dimensional/network)

  • SOA/Microservices architect

  • Technical PM/Development DBA (Oracle)

  • Creating metadata driven corporate data hubs

  • Data profiling, data quality management

  • Mentoring/training users and developers in data best practices

  • Devising data strategies to enable digital transformation initiatives

Technische Erfahrung

  • Technischer Architekt (Oracle)

  • Datenarchitekt, Datenanalytiker

  • Datenmodellierung

  • Softwareentwickler

  • Entwicklungs-DBA (Oracle)

  • Business Analyst

  • Technischer Projektleiter

  • Architekt für Datenqualität

  • SOA-Architekt 

  • Oracle-Mentor

  • BI-Systeme erneuern

 

Fachliche Erfahrung

  • Datawarehousing (DWH), Business-Intelligence, Finanzhandel, Bilanzen, CRM

  • Erstellung von integrierten, unternehmensweiten Datenbanken (ODS, Data Hubs)

  • Master Data Management (MDM), Datenqualitätsanalyse

  • Datenmigration, Implementierung von ETL-Systemen auf Basis von SOA

  • Risikokontrolle im Finanzbereich (Basel II, Sarbanes Oxley)

  • Analyse von Daten und Geschäftsprozessen

  • Produktionssteuerung und Materialverwaltung für Fertigungsunternehmen

  • Wholesale financial markets: credit/market risk, KYC

  • Regulatory reporting: Sarbanes/Oxley, BCBS 239

  • Corporate data governance, data security, GDPR

  • Asset management: securities, commercial real estate, investment portfolios

  • Sales and marketing: retail sector, CRM, KYC

  • Travel and tourism: airlines, railways

 

Produktkenntnisse

  • Data/ Business Analysis

    • Data modelling (logical/physical)

    • DWH modelling (reporting/OLAP)

    • Data gap analysis

    • Data quality profiling

    • Data dictionary creation

    • Metadata governance

    • Master data management (MDM)

    • Enterprise data architecture

    • SOA project methodology

  • Development / ETL Tools

    • Oracle Designer (6.0, 6i, 9i)

    • Erwin/EA Studio/ PowerDesigner

    • Informatica

Berufserfahrung

1995-05 - 2017-06

Position: Freelance IT consultant

2017-07 - 2019-08

Firma: Barclays Bank

Position: Chief Data Architect

2019-09 - heute

Position: Enterprise Data Architect

Betriebssysteme

Unix
Linux/Red Hat, Solaris
Windows

Programmiersprachen

Java
Pascal
PL/SQL
UNIX shell scripting
SQL
XML
UNIX
Linux, Solaris, AIX, HP/UX
Json
Python

Datenbanken

Oracle RDBMS
11g, 10g, 9i
Oracle Utilities
Data Pump, RMAN etc.
Oracle Enterprise Manager
Toad
SQL Navigator
Oracle Datenbank- und Anwendungsoptimierung
Cloud platforms
AWS, Snowflake

Datenkommunikation

Hardware

Design / Entwicklung / Konstruktion

Data Quality Profiling

Branchen

Branchen

  • Banking and Finance

  • Marketing

  • Air transport

  • Wholesale and retail trade

  • Consumer goods manufacturing

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.