Keywords
Skills
- technical project management / team lead
- data warehouse architecture
- data modelling
- relational and dimensional modelling, Data Vault modelling
- detailed knowledge of the Teradata and IBM standard data models (Teradata FSDM, CLDM, IBM TDW and IBM BDW)
Project history
- defined architectural standards and modelling guidelines
- design of a semantic model for Lidl’s enterprise data warehouse
- led a team of 8 analysts and developers
- project planning and setup
- design of a dimensional model
- responsible for analysis, data modelling, mapping and implementation
- design of an enterprise data model (conceptual model) and a business glossary
- architect for the migration of the data warehouse from Teradata to Snowflake
- led a team of ~10 architects and analysts
- definition of the target architecture on Snowflake and Microsoft Azure
- design of an Enterprise DWH model
- definition of an integrated data quality approach
technology used:
Teradata 16.20, Snowflake, Microsoft Azure, PowerDesigner, Ab Initio
- solution design for data deletion, masking and encryption in Vodafone’s BI landscape
- provided guidelines and architectural standards for a team of ~12 analysts
technology used:
Teradata 15.10, PowerDesigner, CLDM R.13, IBM TDW
- responsible for the design of a set of reporting applications for revenue optimization
- solution architecture, data modelling and mapping
- defined architectural standards and data modelling guidelines
- led the design of Maersk Line’s new enterprise DWH (relational and dimensional modelling)
- led and mentored a team of ~10 data architects
technology used:
Teradata 15.10, Erwin
- 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
(greenfield project for Teradata Austria)
- customization of the Teradata FSDM (logical and physical model)
- supervised data mapping and implementation
- conducted model training and workshops
- 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
- 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
- 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
- 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
- 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 InitioArchitect 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
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
technology used: Teradata V2R5.1, Teradata V2R6.1, NCR MP-RAS, C, JCL, TSO, ERWin, ER Studio
|
- 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
- ETL design
- implementation of load and transformation jobs
- sizing
technology used:
Teradata V2R5, CLDM, NCR MP-RAS, ERWin
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
- 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
Consulting regarding the selection of implementation partners for a major DWH project
|
- 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
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
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
- 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
responsible for call data processing in the data warehouse
integration of retail data from post offices into the DWH
technology used: Teradata V2R2, CLDM, NCR MP-RAS, C, shell-scripts, OS/390, TSO, JCL, MS Access, ERWin, Business Objects
|
- 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- 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
Local Availability
world-wide
Other
gerald@gastgeb-consulting.com.
+43-699-11749146