Arbeitserlaubnis: EU-Staatsbürger - Arbeitserlaubnis nicht erforderlich
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.
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.
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.
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.
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.
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.
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.
This project involved refactoring an existing BI system in order to improve its performance and usability.
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.
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
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
Banking and Finance
Marketing
Air transport
Wholesale and retail trade
Consumer goods manufacturing
Arbeitserlaubnis: EU-Staatsbürger - Arbeitserlaubnis nicht erforderlich
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.
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.
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.
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.
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.
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.
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.
This project involved refactoring an existing BI system in order to improve its performance and usability.
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.
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
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
Banking and Finance
Marketing
Air transport
Wholesale and retail trade
Consumer goods manufacturing
"[...] 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 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
"[...] 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."— 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
"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 Global Environment for Accounting and Reporting, 06/02 - 03/03
Referenz durch IT Projektleiter (15MA), Schweizer Grossbank, vom 04.06.04
"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."
— Projekt Datawarehousing mit Oracle 8i, 06/00 - 12/00
Referenz durch Software-Architekt in Großbank vom 06.06.02
"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."
— Project Property Systems Database Administration, nearly 12 months
Reference by Royal Bank of Scotland Group, as of 2002-05-20