Gerald Gastgeb available

Gerald Gastgeb

Data Warehouse Architect and Data Modeler

available
Profileimage by Gerald Gastgeb Data Warehouse Architect and Data Modeler from Wien
  • 1180 Wien Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: not provided
  • Languages: German (Native or Bilingual) | English (Full Professional) | French (Elementary)
  • Last update: 25.07.2020
KEYWORDS
PROFILE PICTURE
Profileimage by Gerald Gastgeb Data Warehouse Architect and Data Modeler from Wien
ATTACHMENTS
profile Gerald Gastgeb

You need an account to view this information.

Profil Gerald Gastgeb (EN)

You need an account to view this information.

Profil Gerald Gastgeb (DE)

You need an account to view this information.

SKILLS
20+ years of experience in design and implementation of enterprise data warehouse solutions based on Teradata (V2R2 - R.16.20) 
  • technical project management / team lead
  • data warehouse architecture
  • data modelling
    • relational and dimensional modelling, Data Vault modelling
    • detailed knowledge of the Teradata and IBM standard data models (Teradata FSDM, CLDM, IBM TDW and IBM BDW)
PROJECT HISTORY
  • 11/2018 - Present

    • Lidl Stiftung & Co KG
    • >10.000 employees
    • Consumer goods and retail
  • Data Warehouse Architect and Senior Data Modeler
    • 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
    • design of an enterprise data model (conceptual model) and a business glossary
    • consulting architect for the migration of the data warehouse from Teradata to Snowflake

    technology used:

    Teradata 16.20, Snowflake, PowerDesigner, Ab Initio Metadata Hub


  • 08/2018 - 10/2018

    • Vodafone Deutschland
    • >10.000 employees
    • Telecommunications
  • BI Architect
  • 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 R.13, IBM TDW


  • 08/2016 - 05/2018

    • Maersk Line
    • >10.000 employees
    • Transport and Logistics
  • Senior Data Model Consultant
  • Senior Data Model Consultant for Maersk Line's enterprise data warehouse
    • 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 Maersk Line’s new enterprise DWH (relational and dimensional modelling)
    • led and mentored a team of ~10 data architects

    technology used:

    Teradata 15.10, Erwin


  • 05/2016 - 08/2016

    • Erste Bank, Wien
    • >10.000 employees
    • Banks and financial services
  • Data Model Consultant
  • Data Model Consultant for the enterprise data warehouse program of Erste Bank, Vienna
    • design of an IBM BDW based application layer for Erste Bank's new EDWH
    • 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


  • 11/2015 - 04/2016

    • Sberbank Europe, Wien
    • 1000-5000 employees
    • Banks and financial services
  • Data Warehouse Architect and Lead Data Modeler
  • Data Warehouse Architect and Lead Data Modeler for the enterprise data warehouse program at Sberbank Europe, Vienna
    (greenfield project for Teradata Austria)
    • customization of the Teradata FSDM (logical and physical model)
    • supervised data mapping and implementation
    • conducted model training and workshops

  • 09/2015 - 11/2015

    • Banca Intesa Sanpaolo
    • >10.000 employees
    • Banks and financial services
  • Data Warehouse Architect and Lead Data Modeler
  • Architect and Lead Data Modeler for the enterprise data warehouse program of Banca Intesa Sanpaolo, Torino, Italy
    • led a team of 3 data modelers 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


  • 01/2015 - 07/2015

    • major telecommunications provider in Copenhagen, Denmark
    • 1000-5000 employees
    • Telecommunications
  • Lead Data Model Consultant
  • Lead Data Model Consultant for the enterprise data warehouse program at a major telecommunications provider in Copenhagen, Denmark
    • acted as the client's representative and design authority towards its implementation partner
    • supervised the creation of the dimensional warehouse model
    • supervised data mapping

    technology used:

    Netezza, IDA, IBM TDW, IBM DataStage


  • 05/2014 - 12/2014

    • TeliaSonera AB, Stockholm
    • >10.000 employees
    • Telecommunications
  • Lead Data Model Consultant
  • Lead Data Model Consultant for the enterprise data warehouse program at TeliaSonera, Stockholm
    • defined guidelines and modelling standards for Telia's data warehouse program
    • acted as TeliaSonera's representative and design authority to various vendors
    • led a group of data modelers 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 TeliaSonera's data model governance processes

    technology used:

    CLDM R.12, FSLDM R.12, Erwin, Teradata 14.10


  • 01/2014 - 05/2014

    • Vodafone Group
    • >10.000 employees
    • Telecommunications
  • Data Warehouse Architect and Lead Data Modeler
  • 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 R.13, IBM TDW, PowerDesigner


  • 07/2012 - 05/2014

    • Vodafone Germany
    • >10.000 employees
    • Telecommunications
  • Data Warehouse Architect and Lead Data Modeler
  • Data Warehouse Architect and Lead Data Modeler for the re-design of the enterprise data warehouse at Vodafone Germany, Düsseldorf
    • data warehouse architecture
    • created a business data model using the concept of business data elements
    • provided extensive training and mentoring to Vodafone personnel on data warehouse methodology, data modelling and CLDM
    • lead data modeler for the customization of the Teradata CLDM
      • leading a team of ~15 business analysts, data modelers and mappers
      • logical data modelling
      • supervised data mapping
      • led the creation of the physical data model

    technology used:

    Teradata 13.0, CLDM R.12 / R.13, IBM TDW, ERWin, PowerDesigner, Ab Initio

  • 02/2011 - 08/2012

    • Raiffeisen Bank International, Wien
    • >10.000 employees
    • Banks and financial services
  • Data Warehouse Architect and Lead Data Modeler
  • Architect and Lead Data Modeler for the enterprise data warehouse at Raiffeisen Bank International (RBI), Vienna, Austria

    (greenfield project for Teradata Austria)
    • pre-sales support for Teradata Austria
    • solution architecture
    • provided technical guidelines and specifications to a team of ~50 analysts and developers
    • supervised the creation of a business data model using the concept of business data elements
    • lead data modeler for the customization of the Teradata FSLDM
      • leading a team of 8 business analysts and data modelers
      • logical and physical data modelling
      • supervised data mapping and implementation
      • training and mentoring of RBI personnel

    technology used:

    Teradata 13.10, FSLDM R.11, Unix, ERWin, PowerDesigner


  • 07/2007 - 03/2011

    • Bank Austria / UniCredit, Wien / Rom
    • >10.000 employees
    • Banks and financial services
  • Data Warehouse Architect and Lead Data Modeler
  • Architect and Lead Data Modeler for the enterprise data warehouse at Bank Austria / UniCredit, Vienna / Rome

    (greenfield project for Teradata Austria / Teradata Italy)
    • member of the architecture team for the initial implementation of the data warehouse
      • finalized the customization of the Teradata 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 (rollout to ~10 countries)
      • logical and physical data modelling
      • supervised data mapping (~10 analysts and developers)
      • 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 has been incorporated into the Teradata standard DWH-methodology ("Business Data Elements")

     

    technology used:

    Teradata V2R6.2, Teradata 12, FSLDM R.8 / R.9 / R.10, Unix, ERWin, DataStage 8.0


  • 08/2006 - 04/2007

    • Barclays Bank, Poole, UK
    • >10.000 employees
    • Banks and financial services
  • Teradata Database Administrator
    • 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

     

     


  • 08/2004 - 06/2006

    • Vodafone Germany
    • >10.000 employees
    • Telecommunications
  • Teradata Database Administrator
    • 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, NCR MP-RAS, ERWin, C


  • 05/2004 - 07/2004

    • Optus, Sydney
    • >10.000 employees
    • Telecommunications
  • Data Warehouse Consultant
    • ETL design
    • implementation of load and transformation jobs
    • sizing

    technology used:

    Teradata V2R5, CLDM, NCR MP-RAS, ERWin


  • 07/2003 - 04/2004

    • AIS, Bangkok
    • 5000-10.000 employees
    • Telecommunications
  • Technical Lead
  • Architect and Technical Lead for the enterprise data warehouse at AIS, Bangkok (Thailand’s largest wireless phone provider) 

    (greenfield project for Eighty-Twenty-Plus Ltd. / NCR-Teradata South East Asia)
    • leading a team of 6 consultants
    • provided technical concepts and project management for two external implementation partners (~ 50 developers and consultants)
      • solution design
      • hardware sizing
      • ETL concept
      • backup concept
      • operational concept
    • supervised database setup and administration
    • physical data modelling
    • supervised implementation
    • end user training and workshops

    technology used:

    Teradata V2R5, CLDM, NCR MP-RAS, ERWin


  • 05/2001 - 07/2003

    • Metro AG, Düsseldorf
    • >10.000 employees
    • Consumer goods and retail
  • Data Warehouse Consultant
    • 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 testing

    technology used:

    Teradata V2R3, Teradata V2R4, NCR MP-RAS, ERWin, MicroStrategy 7.0

  • 04/2002 - 04/2002

    • HP
    • >10.000 employees
    • Internet and Information Technology
  • Data Warehouse Consultant
  • Consulting regarding the selection of implementation partners for a major DWH project

     


  • 12/2001 - 03/2002

    • Danet GmbH, Wien
    • 50-250 employees
    • Internet and Information Technology
  • Senior Consultant / Technical Project Manager
    • 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 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, CLDM

     

    • data warehouse project for Raiffeisen Bank
      • leading a team of four consultants
      • requirement analysis
      • data modelling
      • design of the ETL-process

    technology used: ERWin, Oracle 8i


  • 02/2001 - 12/2001

    • atms Ges.m.b.H.
    • 10-50 employees
    • Telecommunications
  • Billing Developer
  • Developing a billing solution for an Austrian telephone provider (atms GmbH)

    • 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


  • 09/2000 - 12/2000

    • Netway AG
    • 500-1000 employees
    • Internet and Information Technology
  • Data Warehouse Consultant
  • Integration of the telephony subject area of a major Austrian internet and telephone provider (Netway AG) into their data warehouse

    (project for NCR Austria)
    • 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


  • 07/1997 - 12/2000

    • NCR / Teradata
    • >10.000 employees
    • Internet and Information Technology
  • Data Warehouse Consultant
  • Working on various projects in the telecommunications industry

  • 03/2000 - 09/2000

    • UTA
    • 250-500 employees
    • Telecommunications
  • Data Warehouse Consultant
    • 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


  • 07/1997 - 09/2000

    • Telekom Austria AG
    • >10.000 employees
  • Data Warehouse Consultant
  • responsible for call data processing in the data warehouse

    • data modelling (logical and physical design)
    • design and implementation of a transformation program for loading CDRs (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 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, CLDM, NCR MP-RAS, C, shell-scripts, OS/390, TSO, JCL, MS Access, ERWin, Business Objects

     

     


  • 08/2000 - 08/2000

    • Netway AG
  • Data Warehouse Consultant
  • Data assessment on call detail data for a major Austrian internet and telephone provider (project for NCR Austria)
    • 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

  • 08/1999 - 09/1999

    • UTA
    • 500-1000 employees
    • Telecommunications
  • Data Warehouse Consultant
    • 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


TIME AND SPATIAL FLEXIBILITY
full time
world-wide
OTHER
www.gastgeb-consulting.com
gerald@gastgeb-consulting.com.
+43-699-11749146
GET IN TOUCH

Message:

Sender:

WEB PRESENCE