2023-2024, A1 – Project “Data Minions”

Project Scope:

Design and lead development of an internal data ingestion framework for the A1 Data Platform (Cloudera, Azure Synapse, Teradata DWH). This strategic tool replaced the existing ETL/ELT processes and handles loading for both the data lake and the DWH, ensuring unified and scalable data integration. The core principle: “Easy data staging by specification, not implementation.” All required software components are provided within the framework – the data engineer or scientist only specifies the source, basic transformations, and target platform. Execution is performed automatically by the framework via specific Airflow operators.

Tasks & Responsibilities:

• Architecture and design ownership for the framework
• Lead development with Python, Apache Airflow, and Kubernetes
• Migration and decommissioning of existing ETL processes
• Coaching and technical support for other developers

Key Skills & Expertise:

• Big Data Engineering (Hadoop, Spark, Kafka)
• Python, Airflow, Kubernetes
• Data Governance & Data Ingestion
• Leadership & Coaching

---

2018-2024, ongoing, A1 – Lead Data Engineer

Scope & Focus Areas as Lead Data Engineer:

Design and implementation of big data solutions in the Hadoop ecosystem for both batch processing and near real-time use cases. Knowledge transfer and quality assurance as tutor and coach for the Data Engineering group.

Tasks & Responsibilities:

• Development of data pipelines with HDFS, Spark, Kafka, Hive, and Impala
• Building scalable, fault-tolerant data processes
• Implementation of data analytics use cases in close collaboration with business units
• Development and rollout of pragmatic design guidelines and frameworks for the entire engineering team
• Onboarding, tutoring, and coaching of new team members
• Quality assurance in the Data Engineering group through solution design workshops, code reviews, and knowledge transfer in regular team meetings.

Key Skills & Expertise:

• Hadoop ecosystem (HDFS, Spark, Hive, Kafka, Impala)
• Data pipeline design & implementation
• Near real-time data processing
• Collaboration with business units
• Team leadership & coaching
• Quality management

---

2022, A1 – Project “Netscout Data Integration”

Project Scope:

Near real-time integration of 3.5 billion Location Session Records (LRS) per day from the network management system Netscout into the A1 Data Lake. The data includes geolocation and network performance metrics and forms the foundation for numerous analytical use cases.

Tasks & Responsibilities:

• Development of large-scale data extraction and integration
• Performance optimization for high-volume data streams
• Use of modern platforms (Kubernetes/OpenShift, HDFS, Spark, Linux shell)
• Collaboration with analytics teams for downstream data processing

Key Skills & Expertise:

• High-volume data engineering & streaming
• Kubernetes, OpenShift, Apache Spark
• Near real-time data integration
• Use case enablement for analytics

---

2018-2024, A1 – Data Lake Platform Migrations

Repeated need to migrate the A1 Data Lake: Hortonworks >> Cloudera >> Cloudera CDP >> Microsoft Azure Synapse.

Tasks & Responsibilities:

• Leading role in planning and executing the migrations
• Ensuring data quality and business continuity
• Adapting data pipelines (batch and streaming) to new platform architectures
• Knowledge transfer and training for the teams

Key Skills & Expertise:

• Migration of big data platforms
• Cloudera, Cloudera CDP, Azure Synapse
• Cloud data architecture & data engineering
• Project management & change management

---

2017-2018, A1 – Data Lake Build-Out

Scope & Focus Areas:

Initial setup of the A1 Data Lake based on the Hortonworks platform. The objective was to create a central, scalable data foundation for big data analyses and advanced analytics.

Tasks & Responsibilities:

• Design and build of the technical architecture
• Implementation of central data pipelines and governance mechanisms
• Coordination with business units for data provisioning
• Performance and scalability testing

Key Skills & Expertise:

• Data lake architecture & build-out
• Hadoop & Hortonworks ecosystem
• Data governance & security
• Cross-department collaboration

---

2016-2017, A1 – Data Governance Organization

Scope & Focus Areas:

Step-by-step build-out of a data governance organization at A1. Introduction of roles such as data owners and data stewards for core master data (e.g., customer master data).

Tasks & Responsibilities:

• Development of an organizational structure for data governance
• Definition of roles, responsibilities, and processes
• Support in establishing data owners and data stewards
• Enabling the organization via guidelines and best practices

Key Skills & Expertise:

• Data governance & information management
• Enterprise architecture & corporate data model
• Process design & organizational development

---

2015-2017 (ongoing), A1 – Transformation to a Data-Driven Company

Scope & Focus Areas:

Consulting for multiple transformation projects with a focus on data management. Key was the identification of business-critical information for the shift to a “data-driven company” and ensuring these data could be efficiently integrated into the central information pool.

Tasks & Responsibilities:

• Analysis and identification of relevant transformation data
• Consulting on projects to integrate data into central systems
• Ensuring data quality and long-term usability
• Contribution to the strategic transformation toward a data-driven company

Key Skills & Expertise:

• Enterprise information architecture & data strategy
• Business analysis & data integration
• Consulting in transformation projects
• Communication & change management

---

2015-2016, A1 – MDM Project “Partymaster”

Project Scope:

Architecture support for the first master data project “Partymaster.” Migration of customer master data from the host system to a new master data system. Challenge: Many legacy systems were directly integrated with the host and had to be migrated to new interfaces and technologies.

Tasks & Responsibilities:

• Architecture support for MDM system integration as a central component of the “data-driven company”
• Design of integration strategies
• Support for the migration of customer master data
• Consulting on governance and master data quality

Key Skills & Expertise:

• Enterprise information architecture & MDM
• System integration & interface design
• Data migration & governance
• Stakeholder management between IT and business units

---

2014-2015, A1 – Master Data Management (MDM) Awareness & Community Building

Scope & Focus Areas:

Building awareness for the necessity of company-wide master data management. Initiation of an MDM community to anchor the topic across the organization.

Tasks & Responsibilities:

• Conducting workshops, awareness campaigns, and stakeholder management
• Building an MDM community across business units
• Definition of initial use cases and guidelines for master data management

Key Skills & Expertise:

• Data governance & data management
• Enterprise architecture & business alignment
• Communication & change management

---

2014/02-2017/05 (ongoing), A1 – Enterprise Information Architect

Scope & Focus Areas as a member of the Enterprise Architecture team:

• Definition, implementation, and ongoing evolution of the Information Target Architecture.
• Close integration of information architecture with other architecture disciplines (business [processes, capabilities], applications, technical, integration).
• Identification and structuring of company-wide data assets.
• Establishing structures for the transformation to the “Data-Driven A1 Company.”

Tasks & Responsibilities:

• Definition of target architecture and guiding principles for information architecture
• Integration with business, process, and application architecture
• Development and evolution of the corporate data model
• Identification of business objects and central data domains

Key Skills & Expertise:

• Enterprise architecture frameworks (TOGAF, TM Forum)
• Information architecture & data governance
• Data modeling & data management
• Communication with business and IT architecture teams

---

2012/07-2014/02 (ongoing), A1 – DWH/BI Domain Architect

Tasks & Responsibilities:

• Overall responsibility for consistency and coherence from an architecture perspective
• Further development of the Enterprise Data Warehouse model and BI solution architecture as well as knowledge transfer within the department
• Development of pragmatic design and modeling guidelines
• Governance, coaching, and quality assurance for eDWH models, solution designs, and guidelines
• Coordination and mediation in company – and IT-wide projects
• Interface to the IT Architecture Board and ensuring alignment of the BI department with the overall IT architecture
• Participation with a focus on information architecture in the project to establish a central enterprise architecture organization

Key Skills & Expertise:

• Data modeling, data governance, ETL & BI architectures
• Information architecture & DWH design
• Communication, coaching, leadership
• Many years of BI/DWH experience since 1998

2012/03-2013/02, A1 – Project “ASAP/BSAP”

Project Scope:

In the post-merger program ASAP at A1 Telekom Austria, the two existing SAP systems were consolidated into a single ERP system. The goal was to return to standard SAP functionalities and harmonize processes. The BSAP project implemented all reporting-related follow-up tasks, particularly migrating the DWH components for reporting and analytics from the old SAP systems to the new system.

Tasks & Responsibilities:

• Technical overall responsibility for BSAP within the BI department
• Interface role to the SAP team (ERP, BW)
• Solution architecture design for switching SAP base data in the DWH and for over 40 dependent solutions
• Business analysis, design, and technical design for sub-areas during implementation as well as implementation of selected sub-areas
• Quality assurance during implementation and the go-live phase

Platforms: Teradata DWH, SAP ERP, SAP BW

Key Skills & Expertise:

• Data warehouse, ETL, data modeling
• SAP integration into DWH architectures
• Business intelligence & reporting
• Quality assurance & project management

---

2011/2012, A1 – Project “oneCLM / oneCampaigning”

Project Scope:

Following the merger of mobilkom Austria and Telekom Austria into A1, a unified data foundation for the CLM department and an integrated campaign management system were developed. The goal was an architecture that remains stable even when replacing operational base systems (e.g., ordering, CRM, billing).

Tasks & Responsibilities:

• Consulting within the business unit for CRM topics
• Contribution to the target system architecture for campaigning
• Business analysis, design, technical design, and data modeling for the solutions’ data foundation
• Implementation of selected sub-areas
• Quality assurance

Target Platforms: Teradata DWH & Aprimo Relation Manager

Key Skills & Expertise:

• Data management, data modeling, ETL
• CRM and campaign management experience
• BI/DWH solutions with Teradata & Aprimo

---

2009/2010, Telekom Austria AG – Project “IPM”

Project Scope:

Development of an integrated commissions management system, replacing the silo solutions of individual sales channels. Commission calculation is performed in the SAP system. The data foundation (order intake, invoices, special business cases) is provided by the DWH.

Tasks & Responsibilities:

• System architecture design (data foundation for IPM, data transfer to and from the SAP system in compliance with ICS policies, downstream distribution of commission data to reporting and other operational systems such as the employee sales lead management system or the dealer extranet)
• Business analysis, design, technical design, and data modeling for the data foundation and the solution’s update processes
• Implementation of selected sub-areas
• Quality assurance
• Steering the implementation team

Platforms: Teradata & SAP

Key Skills & Expertise:

• DWH/BI architecture, ETL, data governance
• Project and team leadership
• Teradata and SAP integration

---

2006/2007, Telekom Austria AG – Project “Sales Steering Application”

Project Scope:

Development of an operational CRM and campaign management system based on mass data from the enterprise DWH and newly integrated data sources.

Tasks & Responsibilities:

• System architecture design with a focus on performance and extensibility
• Design of a cross-functional product and customer view
• Business analysis, design, and technical design for the solution’s data foundation and update processes
• Implementation of sub-areas
• Support in building the CRM software’s metadata layer (TRM)
• Quality assurance
• Steering the implementation team

Target Platform: Teradata, TRM (Teradata CRM)
Sources: Teradata, SQL Server, Oracle, Host, …

Key Skills & Expertise:

• Data modeling, data management, ETL
• BI system architecture & performance optimization
• CRM and campaign management
• Project and team leadership
• Experience with Teradata, SQL Server, Oracle, …

---

2006, RHI AG – Project “Planning Process NEW”

Project Scope:

Replacement of the existing planning system and new implementation of budget planning (sales planning, plant allocation, intercompany sales planning) and mid-term planning based on RHI’s DWH using CoPlanner™ and MS SQL Server 2005.

Tasks & Responsibilities:

• Design of the overall system (interfaces DWH – planning database – CoPlanner™, control of the planning and calculation process)
• Design and technical design for the planning data foundation and calculation modules
• Implementation (data model, interfaces) in CoPlanner™ as well as parts of the calculation modules as T-SQL procedures
• Quality assurance
• Technical project management and steering of the implementation team

Target Platforms: MS SQL Server 2005, CoPlanner™

Key Skills & Expertise:

• Data warehousing, ETL, data modeling
• Planning systems (CoPlanner, SQL Server)
• Project management

---

2004-2006, Mobilkom Austria – Business Intelligence Consultant in the Data Warehouse Department

Scope & Focus Areas:

Consulting, project management and development in the BI environment with a focus on reporting, analytical platforms, and risk management. Provision of Data Marts and OLAP cubes for core business areas (Risk Management, Fraud Management, Accounting, Billing).

Tasks & Responsibilities:

• Design and Lead Development of reporting and analytical platforms for:
  • Credit default management (Risk Management)
  • Collection & Fraud (Fraud Management)
  • Customer scoring (Risk Management, OLAP cube)
  • Standard reporting (Accounting, Billing, Fraud Management)
• Roles: Consulting, Development, Project Management
• Tutor and coach for onboarding and supporting new colleagues in the mobilkom BI team

Key Skills & Expertise:

• Business Intelligence & Data Warehousing
• OLAP & Data Mart design (MS Analysis Services)
• Fraud & Risk Management analytics
• Teradata, Oracle, MS SQL Server, HP-UX, Windows Server
• Project management, consulting, coaching & knowledge transfer

---

2002-2003, PORR AG – Group Data Warehouse Project

Project Scope:

Development of a finance and controlling data warehouse for steering the entire group (DB accounting, outstanding receivables, …). Consolidation of information from three different financial accounting and cost accounting systems used across the group.

Tasks & Responsibilities:

• Design of the DWH architecture
• Source system analysis, design, technical design, and data modeling for the ETL process and the target DWH
• Implementation of ETL, ODS, and data marts

Target Platform: MS SQL Server / MS Analysis Services
Sources: Host, AS/400, MS SQL Server, various formats

Key Skills & Expertise:

• Data warehouse, ETL, data modeling
• Finance and controlling know-how
• MS SQL Server & Analysis Services

---

2001-2003, BOOM Software AG – Development of an ETL Tool

Project Scope:

Initial development of an ETL tool for the target platform MS SQL Server that, driven by metadata, performs all tasks of the DWH manager (scheduling, ETL, monitoring). This tool was used and further developed in many DWH projects at BOOM Software AG.

Tasks & Responsibilities:

• Concept, design, and implementation of the ETL tool
• Support for using the tool in projects

Key Skills & Expertise:

• ETL, data management
• Frontend and backend software development

---

1999-2002, Wolford AG – Central DWH Project

Project Scope:

Design/modeling and implementation of the central DWH and the ETL processes.

Tasks & Responsibilities:

• Design, modeling, and implementation of DWH & ETL processes
• Development of a code generator that implements ETL processes as Oracle PL/SQL packages
• Development of scheduling & monitoring processes and tools to operate the DWH

Target Platform: Oracle 8i
Sources: AS/400, POS systems

Key Skills & Expertise:

• Data modeling, ETL, BI
• Oracle DWH experience

---

1997-2000, RHI AG – Sales DWH

Project Scope:

Design/modeling and implementation of the central sales DWH and the ETL processes.

Tasks & Responsibilities:

• Design, modeling, and implementation of DWH & ETL processes

Target Platform: MS SQL Server
Sources: various

Key Skills & Expertise:

• Data warehousing, ETL, reporting
• MS SQL Server know-how