Italy: Profilo di Gerald Gastgeb da Wien, Teradata Data Warehouse Consultant | Profili di freelance, indipendenti e imprese
Gerald Gastgeb, Teradata Data Warehouse Consultant from Wien
Gerald Gastgeb
Gerald Gastgeb Consulting
Teradata Data Warehouse Consultant
1180 Wien
available
Tariffa oraria e giornaliera:
k.A.
Last update: 20.01.2011 14:24
Dati in allegato
Lingue straniere
tedesco (first language)inglese (business fluent)french (basic knowledge)
Capacità, conoscenze, esperienze:
Data Warehouse architecture, design, implementation and operation
Teradata
data modeling using the Teradata industry standard models, C-LDM, FS-LDM
Unix, MVS
Referenze:
July 2007 -
data warehouse project for 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 modeling
- 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 ~120 analysts and developers in several countries
- co-developed a new methodology of semi-automatic data mapping, which is currently incorporated into the
Teradata standard DWH-methodology
tools used:
Teradata V2R6.2, Teradata 12, FS-LDM 8.0 / 9.0 / 10.0, 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
disponibilità di tempo e di spazio:
world-wide
Ulteriori indicazioni:
To contact me, send a mail to gerald@gastgeb-consulting.com.
Data Warehouse architecture, design, implementation and operation
Teradata
data modeling using the Teradata industry standard models, C-LDM, FS-LDM
Unix, MVS
Referenze:
July 2007 -
data warehouse project for 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 modeling
- 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 ~120 analysts and developers in several countries
- co-developed a new methodology of semi-automatic data mapping, which is currently incorporated into the
Teradata standard DWH-methodology
tools used:
Teradata V2R6.2, Teradata 12, FS-LDM 8.0 / 9.0 / 10.0, 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
disponibilità di tempo e di spazio:
world-wide
Ulteriori indicazioni:
To contact me, send a mail to gerald@gastgeb-consulting.com.
 |
Registrarsi ora
Profile Navigation
Nuovo profilo
New Company Profiles
Statistica
La tariffa giornaliera dei nostri freelance ammonta a 221 €, La tariffa oraria a 30 €.
The facewall
Do you know someone?
Nuovi progetti
RSS Project-Feeds
Riceva i progetti più nuovi come RSS-News-Fedd per leggerli comodamente nel Suo Feed-Reader
 
|
|
Deutschland | Österreich | Schweiz | United Kingdom | USA | Russian Federation | España | Italy | Ukraine | Liechtenstein | Hungary | New Zealand | France | Slovakia | India | United Arab Emirates
Theme related Websites :