Gerald Gastgeb

Data Warehouse Architect and Lead Data Modeler

Avatar placeholder
Vienna, Austria

Experience

Nov 2018 - Present
7 years 2 months
Heilbronn, Germany

Data Warehouse Architect and Lead Data Modeler

Lidl Stiftung & Co KG

  • Responsible for building and leading the architectural team at Lidl / Kaufland (about 15 architects and data modelers)
  • Defined architecture standards and modeling guidelines
  • Designed a conceptual enterprise data model and business glossary
  • Designed a semantic layer for the Lidl Enterprise Data Warehouse
  • Managed a team of 8 analysts and developers
  • Project planning and setup
  • Designed a dimensional data model for enterprise reporting
  • Responsible for analysis, data mapping, and development
  • Lead data modeler for building a logistics data warehouse
  • Architect for migrating the data warehouse from Teradata to Snowflake
  • Defined the target architecture consisting of a data lake in Microsoft Azure and a data warehouse in Snowflake
  • Architect for defining an integrated data quality concept based on Ab Initio Metadata Hub and Snowflake
  • Lead architect for designing a new enterprise data warehouse model
  • Led a team of about 15 architects and analysts
  • Created specifications and guidelines for a team of about 30 developers
  • Requirements analysis
  • Modeled an integration layer and a presentation layer
  • Responsible for business analysis and mapping of source data
  • Advised on designing an automated fraud detection system
  • Advised on implementing a data mesh concept
Aug 2018 - Oct 2018
3 months
Düsseldorf, Germany

BI Architect

Vodafone Deutschland

  • Architect for Vodafone Germany's GDPR program
  • Developed a concept for data deletion, masking, and encryption
  • Defined policies and architecture standards for a team of about 12 analysts
Aug 2016 - May 2018
1 year 10 months
Copenhagen, Denmark

Senior Data Model Consultant

Maersk Line

  • Responsible for designing an application layer for freight rate analysis
  • Solution architecture
  • Data modeling
  • Data mapping
  • Defined modeling guidelines and architecture standards
  • Responsible for designing Maersk Line's new enterprise data warehouse
  • Relational and dimensional modeling
  • Led a team of about 10 data modelers
May 2016 - Aug 2016
4 months
Vienna, Austria

Data Model Consultant

Erste Bank

  • Designed an application layer based on IBM BDW
  • Requirements analysis
  • Solution architecture
  • Trained client on using IBM BDW
Nov 2015 - Apr 2016
6 months
Vienna, Austria

Lead Data Modeler

Sberbank Europe

  • Logical and physical data modeling based on Teradata FSDM
  • Responsible for data mapping
  • End-user training
Sep 2015 - Nov 2015
3 months
Italy

Architect and Lead Data Modeler

Banca Intesa Sanpaolo

  • Functional leadership of a team of three data modelers and about 10 analysts
  • Definition of architectural standards and technical guidelines
  • Logical and physical data modeling based on Teradata FSDM
  • Responsible for data mapping
Jan 2015 - Jul 2015
7 months
Copenhagen, Denmark

Lead Data Model Consultant

unnamed telecommunications provider

  • Representation of the client towards the implementation partner
  • Responsible for creating a dimensional model based on IBM TDW
  • Control of data mappings
May 2014 - Dec 2014
8 months
Stockholm, Sweden

Lead Data Model Consultant

TeliaSonera

  • Definition of guidelines and data modeling standards
  • Representation of TeliaSonera towards implementation partners
  • Leading multiple data modelers in subprojects
  • Responsible for the core data model for the Carrier Services business unit
  • Responsible for the core and semantic data model for the Collections Services business unit
  • Control of data mappings
  • Responsible for data model governance processes
Jan 2014 - May 2014
5 months

Data Warehouse Architect and Lead Data Modeler

Vodafone Group

  • Responsible for expanding Vodafone Germany's data warehouse model into a standard solution for all Vodafone organizations in Europe
  • Design authority for the core data warehouse model
  • Definition of collaboration and governance processes
  • Advisory architect for Vodafone Greece's enterprise data warehouse
  • Advisory architect for Vodafone Turkey's enterprise data warehouse
Jul 2012 - May 2014
1 year 11 months
Düsseldorf, Germany

Data Warehouse Architect and Lead Data Modeler

Vodafone Germany

  • Responsible for defining the entire data warehouse architecture
  • Creating a conceptual data model based on business data elements
  • Training on data warehouse methodology, data modeling, and CLDM
  • Lead data modeler, responsible for creating the EDWH model
  • Leading a team of about 15 business analysts and data modelers
  • Logical data modeling based on Teradata CLDM
  • Responsible for data mapping and creating implementation guidelines
  • Responsible for creating the physical data model
Feb 2011 - Aug 2012
1 year 7 months
Vienna, Austria

Data Warehouse Architect and Lead Data Modeler

Raiffeisen Bank International

  • Pre-sales support for Teradata Austria
  • Solution architecture
  • Creating specifications and guidelines for a team of about 50 analysts and developers
  • Responsible for creating a conceptual data model using the Business Data Elements methodology
  • Lead data modeler responsible for creating the enterprise data warehouse model
  • Functional lead for a team of 8 data modelers and business analysts
  • Logical and physical data modeling
  • Responsible for data mapping and creating implementation guidelines
  • Training and coaching of RBI employees
Jan 2010 - Present
16 years

Owner and Principal Consultant

Gastgeb Consulting GmbH

Jul 2007 - Mar 2011
3 years 9 months
Vienna, Austria

Data Warehouse Architect and Lead Data Modeler

Bank Austria / UniCredit

  • Member of the architecture team
  • Adapting the Teradata FSLDM
  • Physical data modeling
  • Responsible for data mapping and implementation
  • End-user training and workshops
  • Technical lead for a reporting subproject
  • Technical project lead for a team of 4 consultants
  • Project planning
  • Requirements analysis and reverse engineering of existing processes
  • Architecture and design
  • Architect for the migration of the data warehouse to a new core banking system
  • Technical project lead for a team of about 15 analysts and designers
  • Logical and physical data modeling
  • Responsible for data mapping
  • Consulting architect for the UniCredit Italy data warehouse
  • Responsible for logical and physical data modeling
  • Responsible for data mapping
  • Architect for the Bank Austria CEE data warehouse (rollout in about 10 countries)
  • Logical and physical data modeling
  • Responsible for data mapping (about 10 analysts and developers)
  • Responsible for the design of a MicroStrategy application layer
  • Lead architect for expanding the data warehouse into a group-wide solution for UniCredit
  • Design authority for data warehouse architecture, data model, and mapping
  • Creating specifications and guidelines for a team of about 120 analysts and developers across multiple countries
  • Co-responsible for developing a new semi-automatic data mapping process, "Business Data Elements"
Aug 2006 - Apr 2007
9 months
Poole, United Kingdom

Data Warehouse Project

Barclays Bank

  • Database administration
  • Physical database design for an active data warehouse application
  • Database architecture
  • Design and implementation of a metadata management solution
Aug 2004 - Jun 2006
1 year 11 months
Düsseldorf, Germany

Data Warehouse Project

Vodafone Deutschland

  • Database administration for the largest Teradata installation in Europe (168 nodes)
  • Performance monitoring and optimization
  • End-user and production support
  • Design and implementation of a performance and workload management solution
May 2004 - Jul 2004
3 months
Sydney, Australia

Data Warehouse Project

Optus

  • Building an ETL architecture
  • Designing and developing loading and transformation jobs
  • Sizing
Jul 2003 - Apr 2004
10 months
Bangkok, Thailand

Technical Project Manager

AIS

  • Technical project management for a team of 6 consultants
  • Creating technical concepts and guidelines for two external development partners (around 50 consultants and programmers)
  • Solution design
  • Hardware sizing
  • ETL concept
  • Backup concept
  • Operations concept
  • Database setup and administration
  • Physical data modeling
  • Quality assurance of implementation
  • Training and end-user workshops
May 2002 - Jul 2003
1 year 3 months
Düsseldorf, Germany

Data Warehouse Project

Metro AG

  • Redesign of the physical data model
  • Performance optimization
  • Designing and implementing data marts
  • Designing Metro-Link, a DWH portal for external partners
  • Migration from Teradata V2R3 to V2R4
  • Developing ETL jobs
  • Integration testing
Apr 2002 - Apr 2002
1 month
Austria

Consulting

HP Austria

  • Consulting on the selection of different implementation proposals as part of a DWH project
Dec 2001 - Mar 2002
4 months
Vienna, Austria

Senior Consultant / Technical Project Manager

Danet GmbH

  • Concept for migrating the Data Warehouse of Telekom Austria AG from Teradata to HP Superdome / Oracle 9i
  • Technical project management for a team of 9 consultants and subcontractors
  • Analysis of the existing system
  • Architecture concept
  • Redesign of the data model and ETL processes
  • Operations concept
  • Data Warehouse project for Raiffeisen Informatik Service International
  • Technical project management for a team of 4 developers
  • Requirements analysis
  • Data modeling
  • ETL process design
Feb 2001 - Dec 2001
11 months
Austria

Billing System Developer

atms

  • Requirements analysis
  • Design and data modeling
  • Development of the rating engine and billing database
  • Design and implementation of billing functionality
  • Hot billing
  • Simultaneous calculation of customer charges, interconnection charges, and service fees
  • Any bill cycles
  • Customer-specific rate design
  • Integrated data warehouse functionality
  • Integrated customer service portal via web applications
  • Quality assurance
  • Consulting
Jan 2001 - Dec 2010
10 years

Consultant

Self-employed Consultant

Sep 2000 - Dec 2000
4 months
Austria

Telephony Integration into Data Warehouse

Netway AG

  • Data modeling (logical and physical design)
  • Design and implementation of a freely configurable loading and transformation program
  • Implementation of all required transformations
  • Development of a frontend tool to configure the entire loading and transformation process
  • Consulting
Aug 2000 - Aug 2000
1 month
Austria

Data Assessment for Telephony Call Data

Netway AG

  • Loading scripts
  • Data analysis and definition of required transformation steps
  • Consulting on data usability and potential application areas
Mar 2000 - Aug 2000
6 months
Austria

Data Warehouse Project

UTA Telekom AG

  • Project planning
  • Requirements analysis
  • Data modeling (logical and physical design)
  • Loading and transformation scripts for CDRs and customer data
  • Loading program for CDR tickets (fastload-inmod)
  • Database administration
  • Evaluations and reports
  • Churn analysis
Aug 1999 - Sep 1999
2 months
Austria

Data Warehouse Project

UTA Telekom AG

  • Requirements analysis
  • Data modeling (logical and physical design)
  • Load and transformation scripts
  • Database administration
  • Analyses and reports
Jul 1997 - Sep 2000
3 years 3 months
Austria

Data Warehouse Project

Post und Telekom Austria

  • Responsible for the telephone call data area in the data warehouse
  • Data modeling (logical and physical design)
  • Designed and implemented a load and transformation program for CDR tickets
  • Ensured regular loading
  • Performance optimization
  • Analyses and user support
  • Integrated retail data from counter transactions at post offices into the data warehouse
  • Created load and transformation scripts
Jan 1997 - Dec 2001
5 years

Consultant for Data Warehouse Solutions

NCR / Teradata Austria

Jul 1996 - Sep 1996
3 months
Vienna, Austria

Project Work

Institut für Computergraphik, TU Wien

  • Analysis of measurement data samples
  • Comparison of different modeling methods
  • Comparison of different compression methods
  • Recommendation for selecting a method
  • Development of a prototype for encoding
Aug 1994 - Sep 1994
2 months
Vienna, Austria

Internship

Danubia Ges.m.b.H.

  • Development of a control program for testing and calibrating electricity meters

Summary

25 years of experience in designing and implementing enterprise data warehouse solutions in banking, retail, logistics, and telecommunications

  • Data warehouse architecture
  • Technical project management
  • Data modeling
  • Relational and dimensional modeling, Data Vault, Anchor Modeling, semi-structured modeling (NoSQL)
  • In-depth knowledge of Teradata and IBM standard data models (Teradata FSDM and CLDM as well as IBM BDW and TDW)

Skills

  • Database Systems: Teradata, Snowflake, Netezza, Oracle, Mysql, Ms Sql Server, Ms Access, Mongodb
  • Cloud Environments: Microsoft Azure, Snowflake
  • Architectures: Data Warehouse, Data Lake, Data Lakehouse, Data Mesh
  • Case Tools: Erwin, Powerdesigner, Ibm Infosphere Data Architect, Idera Er/studio, Hackolade
  • Standard Data Models: Teradata Communications Logical Data Model (Cldm), Teradata Financial Services Data Model (Fsdm), Ibm Ifw, Ibm Tdw, Ibm Bdw
  • Etl Tools: Ab Initio, Datastage, Odi, All Teradata Utilities On All Platforms
  • Olap Tools: Microstrategy, Business Objects
  • Programming Languages: C/c++, Java, Visual Basic, Pascal, Perl, Python, Javascript
  • Operating Systems: Windows, Ms-dos, Os/2, Os/390, Unix / Linux
  • Others: Html, Unix Shell Scripting, Git, Crm, Ss7, Vhdl

Languages

German
Native
English
Advanced
French
Elementary

Education

Oct 1991 - Jun 1998

Vienna University of Technology

Electrical Engineering / Computer Engineering · Vienna, Austria

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Christian Mayr
Christian Mayr

Senior Feature Engineer - Banking

View Profile
Jorge Machado
Jorge Machado

Data Architect

View Profile
Nikolaus Jäger-grassl
Nikolaus Jäger-grassl

Integration Architect

View Profile
Marek Werulik
Marek Werulik

Data Management Solution Architect

View Profile
Henok Abraham
Henok Abraham

Founder and Managing Director

View Profile
Germo Görtz
Germo Görtz

BI Developer

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Simon Stegelmeier
Simon Stegelmeier

Cloud Data Platform Product Owner & Project Manager

View Profile
Ildar Allayarov
Ildar Allayarov

Senior Data Engineer

View Profile
Felix Bruckner
Felix Bruckner

Data Consultant & Technical Lead DataVerse

View Profile
Paul Webster
Paul Webster

Architecture Consultant (Freelance)

View Profile
Kenan Šabić
Kenan Šabić

Enterprise Architecture

View Profile
Jonathan Staude
Jonathan Staude

AI Consultant

View Profile
Yahya Vall
Yahya Vall

Co-founder & CEO

View Profile
Robert Wieland
Robert Wieland

Data Architecture Manager

View Profile
David Klemme
David Klemme

Head of Enterprise Architecture Management

View Profile
Jörg Schwingel
Jörg Schwingel

Interim Enterprise Architecture Manager

View Profile
Carlos Medina
Carlos Medina

Migration Zend Framework 2 /Laminas

View Profile
Jürgen Fey
Jürgen Fey

AR/VR/XR Architect

View Profile
Vitali Haberkorn
Vitali Haberkorn

Power BI Expert

View Profile
Louis Guitton
Louis Guitton

Freelance Solutions Architect and Machine Learning Engineer

View Profile
Andre Wroblewski
Andre Wroblewski

PRINCE2® Foundation Examination

View Profile
Jörg Trappschuh
Jörg Trappschuh

Database Expert and Software Developer

View Profile