Michael Hahn - Interim Lead Developer DWH

Q: Where is Michael based?

Michael is based in Dorna, Austria .

Q: What languages does Michael speak?

Michael speaks the following languages: German (Native) .

Q: How many years of experience does Michael have?

Michael has at least 40 years of experience. During this time, Michael has worked in at least 30 different roles and for 6 different companies . The average length of individual experience is 1 year and 3 months . Note that Michael may not have shared all experience and actually has more experience.

Q: What is Michael's latest experience?

Michael's most recent position is Interim Lead Developer DWH at Insurance .

Q: What companies has Michael worked for in recent years?

In recent years, Michael has worked for Insurance and Bank .

Q: Which industries is Michael most experienced in?

Michael is most experienced in industries like Banking and Finance , Manufacturing , and Insurance . Michael also has some experience in Telecommunication and Retail .

Q: Which business areas is Michael most experienced in?

Michael is most experienced in business areas like Information Technology , Business Intelligence , and Finance . Michael also has some experience in Quality Assurance , Project Management , and Operations .

Q: Which industries has Michael worked in recently?

Michael has recently worked in industries like Insurance and Banking and Finance .

Q: Which business areas has Michael worked in recently?

Michael has recently worked in business areas like Information Technology , Business Intelligence , and Accounting .

Recommended expert

Dorna, Austria

Check rate

Experience

Jan 2023 - Present

3 years 8 months

Interim Lead Developer DWH

Insurance

Technical leadership of the development for a near real-time data warehouse of an insurance company
Ensure stable operation
Analyze and fix errors for ongoing operations
Optimize and tune SQL queries and ETL jobs
Revise scheduling in Automic (UC4)
Coordinate with business units and external clients for further developments
Data modeling and programming for sales management
Tune PostgreSQL queries and functions for balance data queries
Create hotfixes and releases
Plan and coordinate deployments
Execute test runs and analyze the results
Handover activities to internal teams

May 2022 - Dec 2022

8 months

VAT Prepayment Allocation for Mergers

Bank

Design concept for day-accurate allocation of VAT amounts for the VAT advance return in case of a merger
Report by the transferring bank until the day before the merger
Acquiring bank takes over from the merger date
Data modeling and programming to split between the acquiring and transferring bank
Test case definition and test execution

Mar 2022 - Jul 2022

5 months

Impairment Reconciliation Report

Bank

Rebuilt a complex report for the monthly impairment adjustments of a bank
Use general ledgers as data source for general allowances, §57 provisions, as well as direct write-offs and consumption
Presentation of opening balances at the beginning of the year, additions and reversals up to the reporting date
Use of the report as an attachment to the financial statements
Test setups for 5 clients
Data delivery for customer acceptance

Aug 2021 - Mar 2022

8 months

Transparency for External Auditors

Bank

Concept to mark manual postings in sub-ledgers
Mark related debit and credit postings
System for assigning document numbers in sub-ledgers and the general ledger

Jun 2021 - Sep 2021

4 months

UVA - VAT Advance Return

Bank

Management of a data mart to calculate the Austrian VAT advance return codes according to form U30
Bug fixes and plausibility checks
Regression testing
Special query of VAT data for the stub month of a merged bank
Test automation with Jenkins

Jan 2021 - Jun 2021

6 months

UGB Collective Provision

Bank

New "cancellation" function for Collective Provision bookings
Implemented regression test queries with Jenkins
Prepared rollout of the application to new tenants
Supported the team with technical detail questions

Sep 2020 - Feb 2021

6 months

DWH and BI architecture with MS BI stack

Electronics trading company

Consolidated an existing DWH and BI solution for CRM and warehouse logistics
Defined a framework architecture and design guidelines
Implemented SSIS packages to load the data warehouse
Implemented complete staging from source systems for customer and product master data and ERP
Documented design guidelines for building DWH tables regarding version control and historization

Aug 2019 - Jun 2020

11 months

DQ-Check Tool

Bank

Developed a tool for regularly checking data quality according to business rules
Dynamically managed the validation rules
Called during month-end processing or executed on demand
Portable and configurable for different tenants
Provided previous month comparisons, absolute or relative
Documented in Confluence

Jun 2018 - Jun 2020

2 years 1 month

UGB Collective Provision

Bank

Architected and designed a system for automated calculation of intra-year specific and flat-rate value adjustments
Evaluated customer account risk based on current LGD, CCF, and PD risk parameters
Calculated the year-to-date difference values to be booked
Generated an aggregated set of bookings for the posting system
Defined a process chain for booking approval by the respective department
Created and integrated tenant-specific configurations according to business requirements
Conceptualized and designed the solution and implemented the DWH part
Executed tests and supported the business unit
Set up new tenants in production

Feb 2018 - Sep 2018

8 months

EDK - Individual Data Correction

Bank

Extended about 30 interfaces to add prior period posting functionality
Integrated and tested the EDK table-valued functions into the existing programs
Performed tuning measures to improve significantly degraded performance
Coached other teams and shared know-how from the pilot project

Jun 2017 - Feb 2018

9 months

IFRS9 Individual and Collective Impairment

Bank

Architecture and design of the IFRS9 interface from the data warehouse to an external tool
Extraction of risk position data
Populating the interface structure according to vendor specifications
Supporting production
Error analysis and troubleshooting

Apr 2016 - Jun 2020

4 years 3 months

Data Provisioning for SAS RWA Calculation from the Data Warehouse

Bank

Requirements analysis and design of 32 interfaces to supply the SAS RWA calculation with data from the data warehouse
Concept and solution design in coordination with the SAS team
Development of interface programs in T-SQL
Performing unit and integration tests
Supporting operations during the monthly final run
Error analysis and bug fixes

Apr 2016 - Dec 2018

2 years 9 months

Support for maintenance and operation of various data marts

Bank

Maintenance tasks for KSA, FWR, ADB, GBR, IMA
Error analysis and resolution
Defect management with HP ALM and Jira
Rollout initiation and support
Test execution for approvals

Feb 2015 - Mar 2016

1 year 2 months

Data Governance for Regulatory Reporting

Bank

Consulting in the feasibility study for replacing a DB2/PL1 reporting data warehouse solution with ORACLE
Business analysis and logical data model for the output interfaces
Re-engineering of the PL1 code due to lack of documentation and technical specifications
Deriving business rules from the code
Architecture concept for the output interfaces: scheduling, reconciliation, data quality checks
SIT and UAT testing of change requests

Jul 2013 - Jan 2015

1 year 7 months

ORACLE Data Warehouse and Informatica: LPT, SIT, UAT

Bank

Load and performance testing of an Informatica implementation for a data warehouse with about 500GB of data
Staging from SAP BW to ORACLE and output in various formats on UNIX/host
Coordination in setting up the test environment
Test planning and execution with UC4 and ALM
Reviewing non-functional requirements
Advising on throughput optimization and runtime improvements
Reviewing ETL mappings in the system integration test
Supporting the business units in UAT

Aug 2012 - Jun 2013

11 months

EDWH – Data Warehouse with Teradata and ODI

Bank

Consulting on the “Enterprise DWH” project with Teradata and ODI
Developing test scenarios for system and system integration tests
Creating a test plan with about 2500 test cases
Executing tests and logging bug tickets with ALM
Analyzing defects and proposing fixes
Introducing Ataccama DQA in the testing and development team
Advising and guiding business units in UAT

Jan 2012 - Sep 2012

9 months

GDWH – Data Warehouse with Oracle and Datastage

Bank

Testing, defect analysis and resolution for an ORACLE DWH with Datastage ETL
Deploying Datastage packages and ORACLE DDL scripts into the test system according to the release plan
Running test cycles and analyzing results
Implementing defect corrections
Documenting tests and defects in HP-ALM

Sep 2011 - Jan 2012

5 months

GCPP – DWH/BI with Teradata/ODI/Cognos

Bank

Test and QA consulting for a DWH/BI solution to report the Contribution Margin
Coordinating 17 clients in the implementation of the input interface
Defining an approach model to improve the data quality of delivered input files
Developing tools for automated data quality checks

Sep 2010 - Aug 2011

1 year

Setup of Finance and Controlling Platform

Bank

Consulting on the introduction of new reporting solutions for Finance and Controlling
Evaluating and implementing COGNOS 7 and 8
Migrating from Cubeware to COGNOS 8
Gathering requirements from Controlling and Finance
Creating COGNOS packages and reports
Implementing a financial planning solution and accounting software
Designing interfaces to the core banking system

Jul 2008 - Aug 2011

3 years 2 months

Private Banking Reporting

Bank

Business analysis and UAT for the reporting layer in Private Banking
Designing customer and internal controlling reports
Performance and P&L calculation of client portfolios
Creating ad hoc reports for banking operations and Finance
Defect analysis and ticket tracking
Acceptance tests for new releases
Communicating with service providers and software vendors

Apr 2008 - Jul 2008

4 months

BI Group Controlling with Essbase

Bank

Strategic and tactical planning in group controlling
Identifying and structuring user requirements
Designing the roles and permissions model
Designing the ESSBASE application structure and ETL processes
Implementing the EIS cube and integrating it into the reporting process
Providing technical support and coaching to users

Apr 2007 - Mar 2008

1 year

BI Competency Center for Customer Intelligence

Telecommunication

Leading the BI delivery team with 3-5 members
Designing a BICC for marketing using SAS
Introducing requirements management processes with DOORS
Capturing and analyzing relevant business processes
Analyzing the existing BI solution with about 80 standard reports and 800 ad hoc reports

Sep 2005 - Mar 2007

1 year 7 months

Rating Data Mart

Bank

Business analysis and solution architecture for an Oracle DWH
Gathering requirements for the Basel II rating office
Creating a dimensional data model
Implementing an interface for the Basel II rating office
ETL processes with Informatica PowerCenter
Complex SQL views and PL/SQL procedures
Introducing Hyperion Essbase for reporting
Designing Control-M job networks
Change management with ClearQuest and ticketing with Peregrine
Test documentation with Quality Center

Jan 2005 - Dec 2005

1 year

Credit & Risk Data Mart

Bank

Solution design for an Oracle DWH
Gathering requirements for the credit and risk department
Architecture design and planning of staging processes
ETL processes with Informatica
Complex SQL views and PL/SQL procedures
Creating reports with Hyperion Essbase
Designing Control-M job networks
Automated test data provisioning for unit tests
Change management with ClearQuest and ticketing with Peregrine

Jul 2004 - Dec 2004

6 months

Production Support of an Oracle DWH

Bank

Acting as liaison between the business department and external development team in London
Analyzing error situations and providing 3rd-level support
Logging changes and error tickets
Participating in release planning
Maintaining PowerCenter mappings and Control-M workflows
Developing workarounds and analysis tools

Dec 2003 - Jun 2004

7 months

Localization of OLYMPIC and DWH

Bank

Technical consulting for localization of OLYMPIC and connected DWH
Analysis of order management and order routing processes
Documentation of release management procedures
Documentation of daily operations and exception handling
Optimization of PowerCenter loads and the Oracle DWH

Jan 2001 - Dec 2001

1 year

Order Routing System

Bank

Development work for an Order Routing System connected to Sectra
Concept for improving availability and release management
Development of an error log and availability statistics
MQ Series interface to the host in C++
Creation of emergency documentation and production monitoring

Aug 2000 - Nov 2003

3 years 4 months

Yield statements and annual tax certificates

Bank

Development of a multi-tenant system for yield statements and annual tax certificates
Technical project management and redesign of the ORACLE database
Development of PL/SQL packages and parallel processes with ORACLE job queues
Migration to SQL*Loader direct loads
Database administration and host connectivity with JAVA/JDBC to DB2
Development of analysis tools using Visual Basic and MS Access
Data migration and user support

Nov 1999 - Feb 2000

4 months

Documentation of information providing for a stock exchange

Stock Exchange

Inventory and analysis of processes and applications related to information providing
Development of technical documentation and the operator manual

Aug 1994 - Jul 2000

6 years

Development in a bank's decentralized systems

Bank

Development of client/server applications for e-banking
Technical lead of the monitoring and investigation subproject
Build management with VAX-MMS and code inspections
Application support for the treasury system "Wallstreet"
Lotus Notes database for documentation and forum
Development of an IVR call center application
3270 user interface under OpenVMS
Review and parameterization of IPOS for international payment transactions

Jan 1986 - Feb 1994

8 years 2 months

Application development for an industrial company

Industrial company

Production control center with sequence optimization and MOTIF GUI
Coordination tool for development and production activities
Implementation of SQL/DS and CASE tool IEW/ADW
Company-wide data model and bill of materials system
Error tracking system in client/server architecture
Heuristic optimization methods for printed circuit board manufacturing
Project planning tool with capacity and cost calculation

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Banking and Finance, Manufacturing, Insurance, Telecommunication, and Retail.

Banking and Finance

Manufacturing

Insurance

Telecommunication

Retail

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Finance, Quality Assurance, Project Management, and Operations.

Information Technology

Business Intelligence

Finance

Quality Assurance

Project Management

Operations

Skills

Data Warehouse/Business Intelligence
Define Requirements With Subject Matter Experts, Design Dwh/Bi Architecture, Conceptual And Logical Data Models
Develop Solution Designs, Physical Data Models, Relational And Dimensional Modeling, Implement Etl Processes, Bi, Reporting
Testing Services: Test Planning, Coordination And Execution In The Dwh Environment, Error Analysis And Proposed Solutions
Methods/Architecture: Bi/Dwh, Relational And Dimensional Db Modeling, Test Management And Test Development, Application Development, Requirements Management, Change Management, Configuration Management, Reviews And Code Inspection
Programming Languages: Pl/Sql, T-Sql, Java, Perl, C/C++, Vb.Net, Pascal, Cobol, Fortran, Centura, Delphi, Pl/1, Rexx, Dcl
Bi/Dwh/Etl: Informatica, Ssis, Ssrs, Ssas, Hyperion, Business Objects, Cognos, Sas, Oracle Odi, Datastage, Ataccama Dqa/Dqc
Modeling: Erwin, Er-Studio, Powerdesigner, Rational Rose, Adw
Databases: Oracle, Toad, Sql Developer, Teradata, Sql Server, Mysql, Db2, Db2/400, Ms Access, Sybase, Informix, Ingres
Scheduler: Control/M, Automic (Uc4)
Life Cycle, Agile, Scrum: Jira, Confluence, Hp Alm
Code Management: Git, Tfs, Cvs, Svn
Requirements Management: Telelogic Doors, Rational Requisite Pro
Ide: Eclipse, Visual Studio (.Net), Unify Teamdeveloper (Sal)
Build Management: Ant, Make, Sniff+
Systems: Sectras – Securities Back Office By Finatec, Olympic – Banking Back Office By Eri, Paba/Q – Booking System By Actis, Itrexs – Bank Back Office By HöLl, Wm Data Service For Securities Reporting, Fix Protocol For Financial Information Exchange
Operating Systems: Unix, Windows, Openvms, Vm/Cms, Z/Os (Basic Knowledge), Os/400 (Basic Knowledge)

Languages

German

Native

Education

Oct 1979 - Jun 1984

TGM

High School Diploma / Abitur · Mechanical Engineering / Industrial Engineering · Vienna, Austria

Statistics

Experience

Total positions 31

Experience in Banking and Finance 26.5 y

Avg length 1 y 7 m

Longest experience 8 y 1 m

Expertise

Recent roles Interim Lead Developer DWH, VAT Prepayment Allocation for Mergers, Impairment Reconciliation Report

Main industries Banking and Finance, Manufacturing, Insurance

Main business areas Information Technology, Business Intelligence, Finance

Qualifications

Profile

Created

December 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Michael is based in Dorna, Austria.

Michael speaks the following languages: German (Native).

Michael has at least 40 years of experience. During this time, Michael has worked in at least 30 different roles and for 6 different companies. The average length of individual experience is 1 year and 3 months. Note that Michael may not have shared all experience and actually has more experience.

Based on recent experience, Michael would be well-suited for roles such as: Interim Lead Developer DWH, VAT Prepayment Allocation for Mergers, Impairment Reconciliation Report.

Michael's most recent position is Interim Lead Developer DWH at Insurance.

In recent years, Michael has worked for Insurance and Bank.

Michael is most experienced in industries like Banking and Finance, Manufacturing, and Insurance. Michael also has some experience in Telecommunication and Retail.

Michael is most experienced in business areas like Information Technology, Business Intelligence, and Finance. Michael also has some experience in Quality Assurance, Project Management, and Operations.

Michael has recently worked in industries like Insurance and Banking and Finance.

Michael has recently worked in business areas like Information Technology, Business Intelligence, and Accounting.

Michael attended TGM for Mechanical Engineering / Industrial Engineering.

Michael is immediately available for suitable projects.

Michael's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

To hire Michael, click the Meet button on the profile to request a meeting and discuss your project needs.

Daily Rate Distribution

0 2 4 6 8

<€720 €800-880 €880-960 €960-1040 €1120+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000

750

500

250

Daily rate avg. 920 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000

750

500

250

Median rate 960 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.