20+ years experience in design and implementation of enterprise data warehouse solutions based on Teradata
Data Modeler / Architect / Senior Consultant / Technical Lead for various projects in Europe, Asia and Australia
Teradata V2R2 - R.16.20

Movember 2018 - Data Warehouse Architect and Senior Data Modeler for Lidl Stiftung & Co KG location: Heilbronn, Germany industry: retail	defined architectural standards and modelling guidelines design of a semantic model for Lidl’s enterprise data warehouse led a team of 8 analysts and developers project planning and setup responsible for analysis, data modelling, mapping and implementation technology used: Teradata 15.10, PowerDesigner
August 2018 - October 2018 BI Architect for Vodafone Germany location: Düsseldorf, Germany industry: telecommunications	architect for Vodafone’s GDPR program solution design for data deletion, masking and encryption in Vodafone’s BI landscape provided guidelines and architectural standards for a team of ~12 analysts technology used: Teradata 15.10, PowerDesigner, CLDM 13, IBM TDW
August 2016 - May 2018 Senior Data Model Consultant for Mærsk Line location: Copenhagen, Denmark industry: shipping	responsible for the design of a set of reporting applications for revenue optimization solution architecture, data modelling and mapping defined architectural standards and data modelling guidelines led the design of Mærsk Line’s new enterprise data warehouse (relational and dimensional modelling) solution architecture led and mentored a team of ~10 data architects technology used: Teradata 15.10, Erwin
May 2016 - August 2016 Data Model Consultant for Erste Bank location: Vienna, Austria industry: banking	design of an IBM BDW based application layer for Erste Bank’s new enterprise data warehouse requirements definition solution architecture mentored the customer’s architecture team on the use of IBM BDW technology used: IBM BDW, IDA, PowerDesigner, Erwin, Oracle 12c
November 2015 - April 2016 Architect and Lead Data Modeler for the enterprise data warehouse at Sberbank Europe location: Vienna, Austria industry: banking	customization of the Teradata FSDM (logical and physical model) supervised data mapping and implementation conducted model training and workshops technology used: FSDM 13, Teradata 15.10, Erwin
September 2015 - November 2015 Architect and Lead Data Modeler for the enterprise data warehouse at Banca Intesa SanPaolo location: Torino, Italy industry: banking	led a team of 3 data modellers and ~10 analysts defined architectural standards and guidelines responsible for the customization of the Teradata FSDM (logical and physical model) supervised data mapping technology used: FSDM 13, Teradata 15.10, Erwin
January 2015 - July 2015 Architect and Lead Data Model Consultant for the data warehouse project at a major telecommunications provider in Denmark location: Copenhagen, Denmark industry: telecommunications	acted as the client’s representative and design authority to the implementation partner supervised the creation of the dimensional warehouse model supervised data mapping technology used: Netezza, IDA, IBM TDW, DataStage
May 2014 - December 2014 Lead Data Model Consultant for the data warehouse project at TeliaSonera location: Stockholm, Sweden industry: telecommunications	defined guidelines and modelling standards for Telia’s data warehouse program acted as Telia’s representative and design authority to various vendors led data modellers in several sub-projects supervised the creation of the core model for Telia’s carrier service business supervised the creation of the core and the semantic model for Telia’s debt collection business supervised data mapping established and extended Telia’s data model governance processes technology used: CLDM 12, FSLDM 12, Erwin, Teradata 14.10
January 2014 - April 2014 Architect and Lead Data Modeller for data warehouse solutions at Vodafone Group location: Newbury, UK / Athens, Greece industry: telecommunications	architect for the extension of the data warehouse of Vodafone Germany to a group-wide solution for all European markets of Vodafone design authority for the core data warehouse model established governance and collaboration processes consulting architect for the re-design of the enterprise data warehouse at Vodafone Greece consulting architect for the re-design of the enterprise data warehouse at Vodafone Turkey technology used: Teradata 13.0, CLDM 13, IBM TDW, PowerDesigner
July 2012 - April 2014 Architect and Lead Data Modeller for the re-design of the enterprise data warehouse of Vodafone Germany location: Düsseldorf, Germany industry: telecommunications	data warehouse architecture created a business data model using the concepts of business data elements (BDEs) provided extensive training and mentoring to Vodafone personnel on data warehouse methodology, data modelling and CLDM Lead Data Modeller for the customization of the Teradata CLDM leading a team of ~15 business analysts logical data modelling supervised data mapping led the creation of the physical data model technology used: Teradata 13.0, CLDM 12/13, IBM TDW, Erwin, PowerDesigner, Ab Initio
February 2011 - August 2012 Architect and Lead Data Modeller for the enterprise data warehouse project at Raiffeisen Bank International location: Vienna, Austria industry: banking	pre-sales support for Teradata Austria solution architecture enterprise data warehouse architecture - supporting both head office and 17 independent country organizations data modelling standards database structure and setup ETL architecture data quality architecture application architecture supervised the creation of a business data model using the concept of business data elements (BDEs) Lead Data Modeller for the customization of the Teradata FSLDM leading a team of 8 business analysts and data modellers design authority for logical and physical database desgin supervised data mapping and implementation provided technical guidelines and specifications to a team of ~50 analysts and developers technology used: Teradata 13.10, FSLDM 11, Erwin, Sybase PowerDesigner, Unix
July 2007 - March 2011 Architect and Lead Data Modeller for the enterprise data warehouse project at Bank Austria / Unicredit location: Vienna, Austria / Rome, Italy industry: banking	Member of the architecture team for the initial implementation of the data warehouse finalized the customization of the FSLDM physical data modelling supervised data mapping and implementation (~15 analysts and developers) supervised MicroStrategy implementation Technical Lead for a reporting sub-project leading a team of 4 consultants project planning and setup requirement analysis and reverse-engineering of existing processes architecture and design Architect for the migration of the data warehouse to new core banking systems leading a team of ~15 analysts and designers logical and physical data modelling supervised data mapping Consulting Architect for the data warehouse of UniCredit Italy supervised logical and physical data modelling supervised data mapping Architect for the data warehouse of Bank Austria CEE logical and physical data modelling supervised data mapping (~10 analysts and developers) rollout to various countries in Eastern Europe supervised the design of a MicroStrategy application layer Lead Architect for the extension of the data warehouse to a group-wide solution for UniCredit design authority for DWH architecture, data model and data mapping provided technical guidelines and specifications to a team of ~120 analysts and developers in several countries co-developed a new methodology of semi-automatic data mapping, which is currently incorporated into the Teradata standard DWH-methodology technology used: Teradata V2R6.2, Teradata 12, Unix, ERWin, FSLDM 8/9/10, DataStage 8.0
July 2006 - April 2007 Data warehouse project for Barclays Bank location: Poole, UK industry: banking	database administration physical database design for an Active Warehouse Application architecture consulting design and implementation of a metadata management system technology used: Teradata V2R5.1, Teradata V2R6.1, NCR MP-RAS, C, JCL, TSO, ERWin, ER Studio
August 2004 - June 2006 Data warehouse project for Vodafone Germany location: Düsseldorf, Germany industry: telecommunications	database administration for Europe’s largest Teradata site (168+ nodes) performance monitoring and optimization end user and production support design and implementation of a performance and workload management solution technology used: Teradata V2R5.1, Teradata V2R5.0, NCR MP-RAS, ERWin, C
May 2004 - July 2004 Data warehouse project for Optus location: Sydney, Australia industry: telecommunications	ETL design design and implementation of load and transformation jobs sizing technology used: Teradata V2R5.0, NCR MP-RAS, ERWin, CLDM
July 2003 - April 2004 Technical Lead for the data warehouse project at AIS (Thailand’s largest mobile phone provider) location: Bangkok, Thailand industry: telecommunications	leading a team of 6 consultants providing technical consulting and project management for two external implementation partners (~50 developers and consultants) hardware sizing database setup and administration physical data modelling ETL concept backup concept operational concept consulting end users training and workshops technology used: Teradata V2R5.0, NCR MP-RAS, ERWin, CLDM
May 2002 - July 2003 Data warehouse project for Metro AG location: Düsseldorf, Germany industry: retail	re-design of the physical data model performance-tuning design and implementation of data marts design of "Metro-Link" - the Metro collaboration portal for external partners migration from Teradata V2R3 to V2R4 developing ETL-jobs integration tests technology used: Teradata V2R3, Teradata V2R4, NCR MP-RAS, ERWin, MicroStrategy 7.0
April 2002 Consulting HP Austria	Consulting regarding the selection of implementation partners for a major data warehouse project
December 2001 - March 2002 Senior Consultant / Technical Project Manager for danet GmbH, Vienna, Austria location: Vienna, Austria industries: telecommunications, banking	preparing a concept for the migration of the data warehouse of Telekom Austria AG from Teradata to an HP Superdome / Oracle 9i platform leading a team of nine consultants and various sub-contractors re-engineering of the existing system architecture review re-design of the data model and the ETL-process operational concept technology used: Erwin Datawarehouse project for Raiffeisen Bank leading a team of four consultants requirement analysis data modelling design of the ETL-process consulting technology used: Erwin, Oracle 8i
February 2001 - December 2001 Developing a billing solution for an Austrian telephone provider (atms GmbH) location: Vienna, Austria industry: telecommunications	requirement analysis design and data modelling developing the rating engine and the billing database design and implementation of the billing functionality hot billing customer charges and IC-charges various bill cycles individual tariffs per customer integrated data warehouse functionality integrated customer service via web applications quality assurance consulting technology used: Linux, C++, shell-scripts, perl, Erwin, MS Windows 2000, MS SQL-Server 2000, MySQL
September 2000 - December 2000 Integration of the telephony subject area of a major Austrian internet and telephone provider (Netway AG) into their data warehouse location: Vienna, Austria industry: telecommunications	data modelling (logical and physical design) design and implementation of a configurable data transformation program load jobs (including accumulation of partial records and update of re-rated CDRs) design and implementation of a front end tool used as a single point of configuration for the entire load and transformation job consulting regarding reports and applications technology used: Teradata V2R3, NCR MP-RAS, C++, Shell-scripts, ERWin
August 2000 Data assessment on call detail data for a major Austrian internet and telephone provider (Netway AG) location: Vienna, Austria industry: telecommunications	load scripts data analysis defining all necessary load and transformation processes consulting regarding potential DWH implementations technology used: Teradata V2R3, NCR MP-RAS, shell-scripts, NCR Teraminer Stats
March 2000 - August 2000 Data warehouse project for a major Austrian telephone provider (UTA) location: Vienna, Austria industry: telecommunications	project planning requirement analysis data modelling (logical and physical design) implementation of load and transformation scripts for CDRs and billing data design and implementation of a loading program for call detail records (fastload inmod) database administration queries and end user reports churn analysis technology used: Teradata V2R3, NCR MP-RAS, C++, shell-scripts, ERWin
August 1999 - September 1999 Data warehouse project for a major Austrian telephone provider (UTA) location: Vienna, Austria industry: telecommunications	requirement analysis data modelling (logical and physical design) implementation of load and transformation scripts database administration queries and end user reports technology used: Teradata V2R2, NCR MP-RAS, perl, shell-scripts, ERWin
July 1997 - September 2000 Data warehouse project for Post und Telekom Austria (PTA) / Telekom Austria AG (TA) location: Vienna, Austria industry: telecommunications	responsible for call data processing in the data warehouse data modelling (logical and physical design) design and implementation of a transformation program for loading CDR-Records (C under OS/390) design and implementation of load and transformation scripts quality assurance performance tuning queries end user support consulting about possible queries and applications (with special emphasis on competitive analysis against upcoming alternative network providers) integration of retail data from post offices into the DWH data modelling load and transformation scripts consulting about potential applications technology used: Teradata V2R2, NCR MP-RAS, C, shell-scripts, OS/390, TSO, JCL, MS Access, ERWin

download a detailed profile in MS Word format