Gerald Gastgeb available

Gerald Gastgeb

Teradata Data Warehouse Architect and Data Modeler

available
Profileimage by Gerald Gastgeb Teradata 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: 08.09.2019
KEYWORDS
PROFILE PICTURE
Profileimage by Gerald Gastgeb Teradata Data Warehouse Architect and Data Modeler from Wien
ATTACHMENTS
profile Gerald Gastgeb
The download of this file requires a paid membership.
Profil Gerald Gastgeb (EN)
The download of this file requires a paid membership.
Profil Gerald Gastgeb (DE)
The download of this file requires a paid membership.
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)
REFERENCES
  • 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

    technology used:

    Teradata 15.10, PowerDesigner


  • 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


  • 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


  • 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

  • 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


  • 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

  • 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


  • 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


  • 07/1997 - 12/2000

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

  • 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

     

     


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

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge

WEB PRESENCE