loading

Back to Top







International: 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

User Gerald Gastgeb, Teradata Data Warehouse Architect and Data Modeller hasn\'t uploaded an image yet
Gerald Gastgeb
Gastgeb Consulting GmbH

Teradata Data Warehouse Architect and Data Modeller

1180 Wienat
 
 
 

available
Hourly-/Daily rates: k.A.
Last update: 11.10.2014 23:23
Database development
Datawarehouse
Reporting
Other (OLAP & Business Intelligence)

Attachments
Only visible for logged in users
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
data modeling using the Teradata industry standard models, C-LDM, FS-LDM
Unix, MVS


References of Gerald Gastgeb

May 2014 -
Lead Data Model Consultant for the data warehouse project at TeliaSonera AB, Stockholm
* defined guidelines and modelling standards
* acted as TeliaSonera's representative to various vendors
* led data modellers in several sub-projects
* established and extended TeliaSonera's data model governance processes
technology used:
cLDM R.12, FS-LDM R.12, Erwin, Teradata 14.10


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
tools used:
cLDM R.13, PowerDesigner, Teradata 13.0


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
tools used:
Teradata 13.0, cLDM R.12 / R.13, ERWin, PowerDesigner, Ab Initio


February 2011 - August 2012
Architect and Lead Data Modeller for the enterprise data warehouse of Raiffeisen Bank International, Vienna
(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 FS-LDM
- 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
tools used:
Teradata 13.10, FS-LDM R.11, Unix, ERWin, PowerDesigner


July 2007 - March 2011
Architect and Lead Data Modeller for the enterprise data warehouse of Bank Austria / UniCredit, Vienna / Rome
(project for Teradata Austria / Teradata Italy)
industry: bank
* member of the architecture team
* finalized the customization of the NCR 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

* 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 is currently being incorporated into the Teradata standard DWH-methodology (\\\"Business Data Elements\\\")
tools used:
Teradata V2R6.2, Teradata 12.0, FS-LDM R.8. / R.9. / R.10, Linux, ERWin, DataStage 8.0


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


August 2004 - June 2006
data warehouse project for Vodafone, Düsseldorf
(project for Eighty-Twenty-Plus Ltd.)
industry: telecommunications
* database administration
* performance monitoring and optimization
* design and implementation of a performance and workload management
solution
tools used:
Teradata V2R5.1, NCR MP-RAS


May 2004 - July 2004
data warehouse project for Optus, Sydney
(projekt für NCR Australia / Eighty-Twenty-Plus Ltd.)
industry: telecommunications
* ETL design
* design and implementation of load and transformation jobs
* database sizing
tools used:
Teradata V2R5, NCR MP-RAS


July 2003 - April 2004
Technical Lead for the data warehouse project at AIS, Bangkok
(project for NCR South East Asia / Eighty-Twenty-Plus Ltd.)
industry: telecommunications
* leading a team of six consultants
* providing technical consulting and project management for two
external implementation partners (~ 50 developers and consultants)
* hardware sizing
* database setup and administration
* physical data modelling
* ETL concept
* backup concept
* operational concept
* training and workshops
tools used:
Teradata V2R5, NCR MP-RAS, Erwin, MS Project


Mai 2002 - Juli 2003
data warehouse project for Metro AG, Düsseldorf
industry: retail
* 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 tests
tools used:
Teradata V2R3 and V2R4, NCR MP-RAS


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


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
tools used:
ERWin

* datawarehouse project for Raiffeisen Bank
- leading a team of four consultants
- requirement analysis
- data modelling
- design of the ETL-process
- consulting
tools used:
ERWin, Oracle 8i


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
tools 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 Austria)
industry: ISP / telecommunications
* 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
tools used:
Teradata V2R3, NCR MP-RAS, C++, shell-scripts, Erwin


August 2000
data assessment on call detail data for a major Austrian internet and
telephone provider (Netway AG)
(project for NCR Austria)
industry: ISP / telecommunications
* load scripts
* data analysis
* defining all necessary load and transformation processes
* consulting regarding possible DWH implementations
tools used:
Teradata V2R3, NCR MP-RAS, shell-scripts, NCR Teraminer Stats


March - August 2000
data warehouse project for a major Austrian telephone provider (UTA)
(project for NCR Austria)
industry: telecommunications
* 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
tools used:
Teradata V2R3, NCR MP-RAS, C++, shell-scripts, Erwin, MS Project


August - September 1999
data warehouse project for a major Austrian telephone provider (UTA)
(project for NCR Austria)
industry: telecommunications
* requirement analysis
* data modelling (logical and physical design)
* implementation of load and transformation scripts
* database administration
* queries and end user reports
tools used:
Teradata V2R2, NCR MP-RAS, perl, shell-scripts, Erwin


July 1997 - September 2000
data warehouse project for Post und Telekom Austria (PTA) / Telekom Austria AG (TA)
(project for NCR Österreich)
industry: telecommunications
* 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 special
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
tools used:
Teradata V2R2, NCR MP-RAS, C, shell-scripts, OS/390, TSO, JCL, MS Access,
Erwin, MS Project


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 modeling algorithms
* comparing different compression algorithms
* recommending a solution
* developing a prototype for coding
tools 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
tools used:
MS-DOS, Pascal


Temporal and spatial availability of Gerald Gastgeb

full time
world-wide


Other information of Gerald Gastgeb

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

 


Powered by Shutterstock

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