International: Freelancer profile Gerald Gastgeb from Wien, Teradata Data Warehouse Consultang | Profiles from freelancers and companies

---

Abilities, knowledge, experiences:

Data Warehouse architecture, design, implementation and operation
Teradata
data modeling using the Teradata industry standard models, C-LDM, FS-LDM
Unix, MVS

---

References:

July 2007 -
data warehouse project for Bank Austria / UniCredit, Vienna
(project for Teradata Österreich)
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
- provided technical guidelines and specifications to a team
of ~50 analysts and developers in several countries
tools used:
Teradata V2R6.2, Linux, ERWin, DataStage


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

world-wide

---

Other:

To contact me, send a mail to gerald@gastgeb-consulting.com.