loading

Back to Top

Freelancer profile Gerald Gastgeb from Wien, Teradata Data Warehouse Architect and Data Modeller | Profiles from freelancers and companies

You are here:  Freelancers  »  Gerald Gastgeb

 
 

Gerald Gastgeb, Teradata Data Warehouse Architect and Data Modeller from Wien

Profileimage by Gerald Gastgeb Teradata Data Warehouse Architect and Data Modeller from Wien
Gerald Gastgeb
Gastgeb Consulting GmbH

Teradata Data Warehouse Architect and Data Modeller

1180 Wienat
 
 
 

available
Hourly-/Daily rates: k.A.
Last update: 29.06.2015 20:09

Attachments
The download of this file requires a paid membership.
The download of this file requires a paid membership.
Language skills
German (first language)English (business fluent)French (basic knowledge)

Abilities, knowledge, experiences of Gerald Gastgeb

Data warehouse architecture, design, implementation and operation
Teradata
Logical and physical data modelling, including Teradata industry standard models (C-LDM, FS-LDM) and IBM TDW, dimensional modeling


References of Gerald Gastgeb

January 2015 - 
Lead Data Model Consultant for the enterprise data warehouse program of a leading telecommunications provider in Denmark
  • acted as the client\'s representative and design authority towards the implementation partner
  • supervised the creation of the dimensional warehouse model
  • supervised data mapping
technology used: Netezza, IDA, IBM TDW, DataStage
industry: telecommunications


May 2014 - December 2014
Lead Data Model Consultant for the enterprise data warehouse program at TeliaSonera AB, Stockholm
  • defined guidelines and modelling standards for TeliaSonera\'s data warehouse program
  • acted as TeliaSonera\'s representative and design authority to various vendors
  • led a group of data modellers in several sub-projects
    • supervised the creation of the core model for TeliaSonera\'s carrier service business
    • supervised the creation of the core and the semantic model for TeliaSonera\'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
industry: telecommunications


January 2014 - May 2014
Architect and Lead Data Modeller for data warehouse solutions at Vodafone Group
  • 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: CLDM R.13, PowerDesigner, Teradata 13.0
industry: telecommunications


July 2012 - May 2014
Architect and Lead Data Modeller 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 modeller for the customization of the Teradata CLDM
    • leading a team of ~15 business analysts, data modellers 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, ERWin, PowerDesigner, Ab Initio
industry: telecommunications


February 2011 - August 2012
Architect and Lead Data Modeller for the enterprise data warehouse of Raiffeisen Bank International, Vienna

(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 modeller for the customization of the Teradata FSLDM
    • leading a team of 8 business analysts and data modellers
    • 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
industry: banking


July 2007 - March 2011
Architect and Lead Data Modeller for the enterprise data warehouse of Bank Austria / UniCredit, Vienna / Rome

(greenfield project for Teradata Austria / Teradata Italy)
  • member of the architecture team
    • finalized the customization of the Teradata FS-LDM
    • physical data model
    • supervised data mapping and implementation
    • end user training and workshops
  • technical lead for a reporting sub-project
    • leading a team of 4 consultants
    • project planning
    • requirement analysis an 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 ~50 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.0, FSLDM R.8. / R.9. / R.10, Linux, ERWin, DataStage 8.0
industry: banking


July 2006 - April 2007
Data warehouse project for Barclays Bank, Poole, UK
  • database administration
  • physical database design for an Active Warehouse application
  • architecture consulting
  • design and implementation of a metadata management solution
technology used: Teradata V2R5.1 and V2.R6.1, NCR MP-RAS, ERWin, ER Studio, C, JCL, TSO
industry: banking


August 2004 - June 2006
Data warehouse project for Vodafone Germany, Düsseldorf
  • database administration for Europe’s largest Teradata site (168+ nodes)
  • performance monitoring and optimization
  • design and implementation of a performance and workload management solution
tools used: Teradata V2R5.1, NCR MP-RAS
industry: telecommunications


May 2004 - July 2004
data warehouse project for Optus, Sydney

(projekt for NCR Australia)
  • ETL design
  • design and implementation of load and transformation jobs
  • database sizing
technology used: Teradata V2R5, NCR MP-RAS
industry: telecommunications


July 2003 - April 2004
Technical Lead for the enterprise data warehouse project at AIS, Bangkok

(greenfield project for NCR / Teradata South East Asia)
  • leading a team of six consultants
  • providing technical consulting 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
  • training and workshops
technology used: Teradata V2R5, NCR MP-RAS, Erwin, MS Project
industry: telecommunications


Mai 2002 - Juli 2003
Data warehouse project for Metro AG, Düsseldorf
  • re-design of the physical data model
  • performance tuning
  • 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 and V2R4, NCR MP-RAS
industry: retail


April 2002
Consulting HP Austria
  • Consulting regarding the selection of implementation partners for a major data warehouse project
industry: IT


December 2001 - March 2002
Senior Consultant / Technical Project Manager for Danet GmbH, Vienna
  • 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
industry: telecommunications
  • data warehouse 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
industry: banking


February 2001 - December 2001
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 SQL-Server 2000, MySQL


September - December 2000
integration of the telephony subject area of a major Austrian internet and telephone provider (Netway AG) into its data warehouse

(project for NCR / Teradata 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 whole load and transformation job
  • consulting regarding reports and applications
technology used: Teradata V2R3, NCR MP-RAS, C++, shell-scripts, Erwin
industry: ISP / telecommunications


August 2000
data assessment on call detail data for a major Austrian internet and telephone provider (Netway AG)

(project for NCR / Teradata Austria)
  • load scripts
  • data analysis
  • defining all necessary load and transformation processes
  • consulting regarding possible DWH implementations
technology used: Teradata V2R3, NCR MP-RAS, shell-scripts, NCR Teraminer Stats
industry: ISP / telecommunications


March - August 2000
data warehouse project for a major Austrian telephone provider (UTA)

(project for NCR / Teradata Austria)
  • 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, MS Project
industry: telecommunications


August - September 1999
data warehouse project for a major Austrian telephone provider (UTA)

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


July 1997 - September 2000
data warehouse project for Post und Telekom Austria (PTA) / Telekom Austria AG (TA)

(project for NCR / Teradata Austria)
  • 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 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 possible applications
technology used: Teradata V2R2, NCR MP-RAS, C, shell-scripts, OS/390, TSO, JCL, MS Access, Erwin, MS Project
industry: telecommunications


July 1996 - September 1996
University project at the Department of Computer Graphics, University of Technology Vienna

developing a data compression algorithm for data acquisition at an electron collider at Laboratori Nazionali di Frascati, Rome
  • analysis of samples of sensor data
  • comparing different modelling algorithms
  • comparing different compression algorithms
  • recommending a solution
  • developing a prototype for coding
technology used: MS-DOS, Pascal


August 1994 - September 1994
working for Danubia Ges.m.b.H., Vienna

developing a script file interpreter used for controlling a test and calibration system for power meters
technology used: MS-DOS, Pascal
 


Location flexibility of Gerald Gastgeb

full time
world-wide


Other information of Gerald Gastgeb

www.gastgeb-consulting.com
gerald@gastgeb-consulting.com.
+43-699-11749146

 



freelancermap footer border
www.freelancermap.de | www.freelancermap.at | www.freelancermap.ch | www.freelancermap.com