a Randstad company

Rethinking IT for a data-centric world

Profil
Referenzen (5)
Project data analyst and ETL developer on CPM project, 07/04 - 07/05
Reference from Manager MIS, one of the world's largest producers of film and television entertainment, from 29.07.05
"[...] The key deliverable for this part of the project was a single migration process which could deal with the various national formats and successfully match a high proportion of the local products to the CPM master records. This consultant designed and implemented this process within the scheduled time, and achieved successful product load rates of between 96% and 100%, which represented a far better success rate than we had expected and helped the introduction of the CPM system. [...] From the beginning of his time here this consultant has shown considerable enthusiasm for his work and we feel that he has made a significant contribution to this phase of the CPM project. He introduced a number of the ideas which were used in this project and he was always willing to share his knowledge and experience with his colleagues. This consultant is leaving this company following the successful completion of his assignment but we would be happy to offer him another position should the opportunity arise. I have no hesitation in recommending him to anyone contemplating his employment."
Project technical architect/team leader on an financial data warehousing project, 06/03 - 06/04
Reference from Project Manager, American vendor of computers, computer components, computer software and information-technology services, from 30.06.04
"[...] Throughout the time that this consultant worked on this project, we were completely satisfied by the way in which he dealt with the various tasks entrusted to him: not only was his work always of a very high standard technically, but he consistently demonstrated high levels of initiative and motivation. He was able to grasp very quickly what work had to be done and could then be relied on to complete the resulting tasks effectively and within the agreed time frame. His knowledge of data warehousing in general and Oracle in particular allowed us to rely on him to define solutions and solve problems throughout the course of the project. In addition to his technical expertise, the consultant proved himself to be an effective team leader and co-ordinator. This was a multi-site project (the other sites being in Colorado and California) so it was important to ensure good communication between all the project teams, and the consultant was able to achieve this in all the areas for which he was responsible. The business users in particular expressed themselves very happy to be dealing with someone who noted their requirements and then provided solutions that did meet those requirements. All of us who were involved on this project found him a pleasure to work with. Although usually very busy, he could always be relied on to provide support to his colleagues.
It is partly as a result of the consultant's contribution that the first phase of this project was completed on schedule in June of this year. Unfortunately the project is now being moved to California and so this development team is being disbanded, but if a suitable opportunity were to present itself, we would have no hesitation in employing him again in the future."
Projekt Global Environment for Accounting and Reporting, 06/02 - 03/03
Referenz durch IT Projektleiter (15MA), Schweizer Grossbank, vom 04.06.04
"Projekt Datawarehousing (Oracle 9i) und ETL-Programmierung (PL/SQL)
Der Consultant hat an einem Projekt mitgearbeitet, wo es darum ging, ein Datawarehouse für finanzielle Informationen aufzubauen. Insbesondere beschäftigte es sich mit der Implementierung von Datenbankprozessen hauptsächlich in PL/SQL realisiert) für das Laden von Quelldaten bzw. für das Aktualisieren der Reporting Datamarts. Diese Prozesse basierten auf ein Metadatenmodell der Quell- und Zieltabellen. Der Consultant hat sich dank seiner langjährigen Erfahrung schnell in die Problemstellung eingearbeitet. Mit seinem fundierten SQL Background war in der Lage, im geplanten Zeitraum eine qualitativ hochstehende Lösung zu entwickeln. Als Mitarbeiter ein guter Teamplayer."
Projekt Datawarehousing mit Oracle 8i, 06/00 - 12/00
Referenz durch Software-Architekt in Großbank vom 06.06.02
"Der Consultant hat sich hervorragend in das international arbeitende Projektteam integriert. Als Oracle DBA und Entwickler leistete er einen unverzichtbaren Beitrag zu der termingerechten und erfolgreichen Produktionseinführung der Applikation."
Project Property Systems Database Administration, nearly 12 months
Reference by Royal Bank of Scotland Group, as of 2002-05-20
"The consultant worked on attachment to my unit for nearly 12 months. He supported our legacy ORACLE Databases running on Compaq TRUE64 Unix servers. The databases were Horizon - a Property database and accouting system; HEAT a helpdesk job control system; PRISM a supplier management/purchase ordering system and SUN Accounts a general ledger/accounts payable system. The consultant supported the permanent DBA and took full control when he was away. He was always very pleasant and appeared to have in depth knowledge of ORACLE and how to tune databases. The consultant left on good terms and I would consider re-employing him in the future should the opportunity arise."
Top-Skills
BI Architekt Datenarchitekt Technischer Projektleiter Datenintegration Datenmigration BCBS 239 Datenanalyse Oracle DBA ETL-Programmierung Metadaten PL/SQL Datenmodellierung MDM Oracle-12c GDPR Ansi SQL
Verfügbar ab
05.09.2022
Aktuell verfügbar - Der Experte steht für neue Projektangebote zur Verfügung.
Verfügbar zu
100%
davon vor Ort
100%
Einsatzorte

PLZ-Gebiete
Länder
Ganz Deutschland, Österreich, Schweiz

Arbeitserlaubnis: EU-Staatsbürger - Arbeitserlaubnis nicht erforderlich

Remote-Arbeit
möglich
Art des Profiles
Freiberufler / Selbstständiger
Der Experte ist als Einzelperson freiberuflich oder selbstständig tätig.

2 Jahre 3 Monate

2019-09

2021-11

Development of a CRM architecture

Enterprise Data Solutions Architect Oracle 18c/19c GCP Snowflake ...
Rolle
Enterprise Data Solutions Architect
Projektinhalte

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.

Kenntnisse
Oracle 18c/19c GCP Snowflake SOA/Microservices
Kunde
Private bank, Benelux
2 Jahre

2017-08

2019-07

Comprehensive data strategy and data governance frameworks

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

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.

Kenntnisse
Oracle 12c/18c SQL Server AWS Collibra SOA/Microservices
Kunde
Barclays Bank, London
2 Jahre 2 Monate

2015-05

2017-06

Define and implement a data and technical strategy

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

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.

Kenntnisse
Oracle 12c/18c SOA XML Big Data SOA/Microservices Oracle Designer
Kunde
UK Police Forces
Einsatzort
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
Rolle
BCBS 239 programme lead, data/solutions architect, data strategy consultant
Projektinhalte

My work at DB 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.

Kenntnisse
Oracle 12c Oracle Designer Power Designer
Kunde
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
Rolle
BI solutions architect, technical project leader, development DBA
Projektinhalte

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.

Kenntnisse
Oracle 12c Oracle Designer Informatica
Kunde
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
Rolle
Enterprise data architect, SOA architect, Oracle DBA, BI project leader
Projektinhalte

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.

Kunde
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
Rolle
Solutions architect, technical project manager, enterprise data architect, DBA
Projektinhalte

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.

Kunde
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
Rolle
Solutions architect, enterprise data architect, technical project leader, DBA
Projektinhalte

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

Kunde
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
Rolle
Data architect, solutions architect, technical project leader, ETL architect
Projektinhalte

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.

Kunde
Warner Bros, London

Studium - Informatik

University of Salford, England

Abschluss: Master of Science

Studium - Germanistik

University of Manchester, England

Abschluss: Bachelor of Arts (hons)

  • Technischer Architekt

  • Datenarchitekt

  • Datenmanager

  • Datenanalytiker

  • Datenmodellierer

  • Oracle DBA

  • PL/SQL Entwickler

  • SOA-Architekt bzw. Entwickler

  • Analyse von Geschäftsprozessen

  • Datenbankdesign und -administration

  • Technische Projektleitung

Deutsch fließend (Wort und Schrift)
Englisch Muttersprache
Französisch gut (Wort und Schrift)
Italienisch Grundkenntnisse
Spanisch gut

Top Skills
BI Architekt Datenarchitekt Technischer Projektleiter Datenintegration Datenmigration BCBS 239 Datenanalyse Oracle DBA ETL-Programmierung Metadaten PL/SQL Datenmodellierung MDM Oracle-12c GDPR Ansi SQL
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

  • Banking and Finance

  • Marketing

  • Air transport

  • Wholesale and retail trade

  • Consumer goods manufacturing

Ihr Kontakt zu Gulp

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

Jetzt bei GULP Direkt registrieren und Freelancer kontaktieren