Gerald Gastgeb, Data Warehouse Architect and Data Modeler on www.freelancermap.com

05/2016 - 08/2016

Data Model Consultant

Erste Bank, Wien (Banks and financial services, >10.000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Sberbank Europe, Wien (Banks and financial services, 1000-5000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Banca Intesa Sanpaolo (Banks and financial services, >10.000 employees)

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

Lead Data Model Consultant

major telecommunications provider in Copenhagen, Denmark (Telecommunications, 1000-5000 employees)

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

Lead Data Model Consultant

TeliaSonera AB, Stockholm (Telecommunications, >10.000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Vodafone Group (Telecommunications, >10.000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Vodafone Germany (Telecommunications, >10.000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Raiffeisen Bank International, Wien (Banks and financial services, >10.000 employees)

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

Data Warehouse Architect and Lead Data Modeler

Bank Austria / UniCredit, Wien / Rom (Banks and financial services, >10.000 employees)

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

Teradata Database Administrator

Barclays Bank, Poole, UK (Banks and financial services, >10.000 employees)

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

Teradata Database Administrator

Vodafone Germany (Telecommunications, >10.000 employees)

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

Data Warehouse Consultant

Optus, Sydney (Telecommunications, >10.000 employees)

ETL design
implementation of load and transformation jobs
sizing

technology used:

Teradata V2R5, CLDM, NCR MP-RAS, ERWin

07/2003 - 04/2004

Technical Lead

AIS, Bangkok (Telecommunications, 5000-10.000 employees)

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

Data Warehouse Consultant

Metro AG, Düsseldorf (Consumer goods and retail, >10.000 employees)

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

Data Warehouse Consultant

HP (Internet and Information Technology, >10.000 employees)

Consulting regarding the selection of implementation partners for a major DWH project

12/2001 - 03/2002

Senior Consultant / Technical Project Manager

Danet GmbH, Wien (Internet and Information Technology, 50-250 employees)

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

Billing Developer

atms Ges.m.b.H. (Telecommunications, 10-50 employees)

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

Data Warehouse Consultant

Netway AG (Internet and Information Technology, 500-1000 employees)

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

Data Warehouse Consultant

NCR / Teradata (Internet and Information Technology, >10.000 employees)

Working on various projects in the telecommunications industry

03/2000 - 09/2000

Data Warehouse Consultant

UTA (Telecommunications, 250-500 employees)

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

Data Warehouse Consultant

Telekom Austria AG (>10.000 employees)

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

Data Warehouse Consultant

Netway AG

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

Data Warehouse Consultant

UTA (Telecommunications, 500-1000 employees)

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

Gerald Gastgeb

Data Warehouse Architect and Data Modeler

Keywords

Attachments

Skills

Project history

Local Availability

Other

Gerald Gastgeb

Data Warehouse Architect and Data Modeler

Keywords

Attachments

Upgrade your account now

Skills

Project history

Local Availability

Other

Follow profile

Follow profile

Welcome to freelancermap!