Michael H. - Lead Developer Interim DWH

Go to Website

Dorna, Austria

Experience

Jan 2023 - Present

3 years

Vienna, Austria

Lead Developer Interim DWH

Insurance Company in Vienna

Technical lead for the development of a near-real-time data warehouse at an insurance company.
Ensuring operational stability.
Error analysis and fixes for ongoing operations.
Optimizing and tuning SQL queries and ETL jobs.
Revising scheduling in Automic (UC4).
Coordination with business units and external clients for further development.
Data modeling and programming for sales controlling.
Tuning Postgres SQL queries and functions for balance data retrieval.
Creating hotfixes and releases.
Requesting and coordinating deployments.
Conducting test runs and analyzing results.
Handover activities to internal teams.
Technologies used: Jira, Confluence, SQL Server, Postgres, SSIS, Automic (UC4), Git.

May 2022 - Dec 2022

8 months

Vienna, Austria

VAT Advance Return Accrual for Mergers

Bank in Vienna

Developing a concept for day-accurate allocation of VAT amounts for VAT advance returns in the event of a merger.
Ensuring reporting by the disposing bank up to the day before the merger and by the acquiring bank from the merger date.
Data modeling and programming for the split between the acquiring and disposing bank.
Defining test cases and performing tests.
Technologies used: Jira, Confluence, SQL Server, SSIS.

Mar 2022 - Jul 2022

5 months

Vienna, Austria

Valuation Adjustment Report

Bank in Vienna

Rebuilding a complex report for the monthly valuation adjustments of a bank.
Using general ledgers as the data source for general allowances, Section 57 provisions, direct write-offs, and usage.
Displaying opening balances at the start of the year as well as allocations and reversals up to the reporting date.
Using the report as an annex to the financial statements.
Setting up test environments for 5 clients.
Providing data for client acceptance.
Technologies used: Jira, Confluence, SQL Server, SSIS, WebFocus.

Aug 2021 - Mar 2022

8 months

Vienna, Austria

Transparency for External Auditors

Bank in Vienna

Developing concepts with business units and system owners to increase transparency for external bank auditors.
Designing a method to mark manual postings in sub-ledgers.
Marking the associated debit and credit entries.
Developing a system for assigning document numbers in sub- and general ledgers.
Technologies used: Jira, Confluence, SQL Server, Host.

Jun 2021 - Sep 2021

4 months

Vienna, Austria

VAT Advance Return (U30)

Bank in Vienna

Maintaining a data mart for calculating Austrian VAT return indicators according to form U30.
Bug fixes and performing plausibility checks.
Conducting regression tests.
Creating a special query for VAT data for the stub month of a merged bank.
Implementing test automation with Jenkins.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence, Jenkins, Git.

Jan 2021 - Jun 2021

6 months

Vienna, Austria

UGB Collective Provision (Cancellation Function)

Bank in Vienna

Implementation of the new "cancellation" function for Collective Provision bookings.
Implementation of regression test queries with Jenkins.
Preparation for rolling out the application to new tenants.
Supporting the team with technical detail questions.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence, Jenkins, Git.

Sep 2020 - Feb 2021

6 months

Vienna, Austria

DWH and BI Architecture with MS BI Stack

Electrical trading company in Vienna

Consolidation of an existing DWH and BI solution for CRM and warehouse logistics.
Defining a framework architecture and design guidelines.
Implementing SSIS packages for DWH loading.
Implementing full staging from the sources for customer and product master data as well as inventory management.
Documenting the design guidelines for building DWH tables regarding versioning and history management.
Technologies used: SQL Server, T-SQL, SSIS, SSRS, SSAS, Kingsway.

Aug 2019 - Jun 2020

11 months

Vienna, Austria

DQ Check Tool

Bank in Vienna

Developing a tool for regular data quality checks based on business rules.
Dynamic storage of validation rules.
Integrating the tool into month-end processes and on-demand runs.
Porting and parameterization for use with different tenants.
Implementing prior month comparisons (absolute and relative comparisons).
Documentation in Confluence.
Technologies used: SQL Server, T-SQL, Jira, Confluence.

Jun 2018 - Jun 2020

2 years 1 month

Vienna, Austria

UGB Collective Provision (Architecture and Design)

Bank in Vienna

Architecture and design of a system for automated calculation of intra-year specific and general provisions.
Risk assessment of customer accounts based on current LGD, CCF and PD risk parameters.
Determining the Year-to-Date difference values to be booked.
Creating an aggregated booking dataset for the booking system.
Defining a process chain for booking approval by the respective business unit.
Creating tenant-specific configurations according to business requirements and integrating them into the processing logic.
Conceptualization, solution design and implementation of the DWH part.
Testing and test support for the business department.
Setting up new tenants in production.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence.

Feb 2018 - Sep 2018

8 months

Vienna, Austria

EDK - Individual Data Correction

Bank in Vienna

Extending about 30 interfaces with the functionality for prior period bookings.
Integration and testing of the EDK table-valued functions in existing programs.
Performing tuning measures due to significantly degraded performance.
Coaching other teams and sharing know-how from the pilot project.
Technologies used: SQL Server, T-SQL, Jira, Confluence.

Jun 2017 - Feb 2018

9 months

Vienna, Austria

IFRS9 Individual and Collective Impairment

Bank in Vienna

Architecture and design of an IFRS9 interface from the DWH to an external tool.
Retrieval of risk position data.
Populating the interface structure according to the vendor's specifications.
Production support, error analysis, and troubleshooting.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence, HP-ALM.

Apr 2016 - Jun 2020

4 years 3 months

Vienna, Austria

Data Provisioning for SAS RWA Calculation from the DWH

Bank in Vienna

Requirements analysis and design of 32 interfaces to supply the SAS RWA calculation with data from the DWH (customer, account, credit, collateral, contracts, etc.).
Conceptual design and solution development in coordination with the SAS team.
Development of interface programs in T-SQL.
Execution of unit and integration tests.
Supporting operations during the monthly final run.
Performing error analysis and defect fixes.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence, GIT, SAS, HP-ALM, TFS.

Apr 2016 - Dec 2018

2 years 9 months

Vienna, Austria

Support for Maintenance and Operation of Various Data Marts

Bank in Vienna

Maintenance tasks for KSA (Credit Structure Analysis), FWR (early warning report), ADB (default database), GBR (bank-wide risk), and IMA (info management, direct queries by superusers).
Performing error analysis and corrections.
Defect management with HP-ALM and Jira.
Initiating and supporting rollouts.
Conducting acceptance tests.
Technologies used: SQL Server, T-SQL, SSIS, Jira, Confluence, HP-ALM.

Feb 2015 - Mar 2016

1 year 2 months

Vienna, Austria

Data Governance for Regulatory Reporting

Bank in Vienna

Consulting in a feasibility study to replace a 10+ year-old regulatory reporting DWH solution based on DB2 and PL1 and migrate to ORACLE.
Business analysis with a strong technical background.
BDE modeling of output interfaces.
Re-engineering PL1 code due to lack of documentation and technical specifications.
Deriving business rules from the code.
Creating an architecture concept for output interfaces (scheduling, reconciliation, data quality checks).
Conducting SIT and UAT tests for implemented change requests.
Technologies used: ORACLE, SQL Developer, Perl, DB2, PL1, BDE modeling.

Jul 2013 - Jan 2015

1 year 7 months

Frankfurt, Germany

ORACLE DWH and Informatica: LPT, SIT, UAT

Bank in Frankfurt

Consulting with a focus on load and performance testing of an Informatica implementation for a DWH with about 500 GB of data (savings products, credit, finance, business partners).
Staging from SAP BW to ORACLE and output for further processing in the DWH and export in various file formats on UNIX and Host systems.
Coordination of test environment setup.
Test planning and execution with UC4 and Informatica.
Test documentation in ALM and validation of non-functional requirements.
Advising development on throughput optimization and improving job plan run times.
Verifying completeness and correctness of ETL mappings during system integration testing.
Supporting business units in technical matters during UAT.
Technologies used: ORACLE, SAP BW, HP-ALM, UC4, Informatica, Host.

Aug 2012 - Jun 2013

11 months

Vienna, Austria

EDWH – DWH with Teradata and ODI

Bank in Vienna

Consulting during the "Enterprise DWH" project with Teradata and ODI.
Developing test scenarios for system and system integration testing.
Creating a test plan with about 2500 test cases.
Executing tests and creating bug tickets with ALM.
Analyzing errors and developing suggestions for fixes for development.
Introducing Ataccama DQA (data profiling) in the test and development team.
Advising and guiding business units during UAT.
Technologies used: UC4, ODI, Teradata, HP ALM, Ataccama.

Jan 2012 - Sep 2012

9 months

Vienna, Austria

GDWH – DWH with Oracle and Datastage

Bank in Vienna

Consulting on testing, error analysis, and fixes for an ORACLE DWH with Datastage ETL.
Deploying Datastage packages and ORACLE DDL scripts to the test system according to the release plan.
Conducting test runs and analyzing results.
Implementing bug fixes.
Documenting tests and defects in HP ALM.
Technologies used: ORACLE, Datastage, HP ALM.

Sep 2011 - Jan 2012

5 months

Vienna, Austria

GCPP – DWH/BI with Teradata/ODI/Cognos

Bank in Vienna

Consulting on testing and QA for a DWH/BI solution with Teradata/Cognos to display the contribution margin in the "Global Customer and Product Profitability" (GCPP) project for about 400,000 customers.
Coordinating 17 clients during the implementation of the input interface.
Defining a process model for continuously improving the data quality of delivered input files.
Developing tools for automated data quality checks.
Technologies used: UC4, ORACLE, ODI, Datastage, Teradata, COGNOS 8, Perl, HP ALM, Ataccama.

Sep 2010 - Aug 2011

1 year

Munich, Germany

Building Finance and Controlling Platform

Bank in Munich

Consulting on implementing new reporting solutions for finance and controlling.
Evaluating suitable BI solutions.
Implementing COGNOS 8.
Migrating from Cubeware to COGNOS 8.
Migrating from COGNOS 7 to COGNOS 8.
Gathering requirements from controlling and finance.
Creating COGNOS packages and reports.
Evaluating and implementing a financial planning solution.
Implementing a new accounting software.
Designing interfaces to the core banking system.
Technologies used: ORACLE, COGNOS 8, COGNOS 7.

Jul 2008 - Aug 2011

3 years 2 months

Munich, Germany

Reporting Private Banking

Bank in Munich

Business analysis and UAT for the report layer in private banking.
Designing customer reports.
Designing performance and results calculations for client portfolios.
Designing internal reports for controlling.
Creating ad hoc reports for banking operations and the finance department.
Conducting error analyses as well as creating and tracking tickets.
Conducting acceptance tests for new releases from the outsourcing partner.
Gathering and structuring new user requirements.
Communicating with service providers and software vendors.
Technologies used: ORACLE, ORACLE Reports, COGNOS, ITREXS.

Apr 2008 - Jul 2008

4 months

Zürich, Switzerland

BI Group Controlling with Essbase

Bank in Zurich

Assisted with strategic and tactical planning in group controlling.
Gathered and structured user requirements.
Designed the role and permission model.
Designed the Essbase application structure.
Designed the ETL processes.
Designed and implemented the EIS cube.
Integrated the cube into the standard reporting process.
Designed the development, test, and production environments.
Provided technical support and coaching to users.
Technologies used: Hyperion Essbase, Excel, Oracle, SQL Server.

Apr 2007 - Mar 2008

1 year

Bern, Switzerland

BI Competency Centers for Customer Intelligence

Telecommunications in Bern

Led the BI delivery team of 3-5 members.
Designed a BI Competence Center (BICC) for marketing using SAS.
Introduced requirements management processes using DOORS.
Captured and analyzed relevant business processes.
Gathered and structured user requirements.
Analyzed the existing solution with about 80 standard reports, 800 ad-hoc reports, and around 900 metrics.
Technologies used: DOORS, Change, Synergy, ARIS, ER/Studio, ERwin, Quality Center, UC4, SAS DI Studio, SAS BI Studio, SAS Enterprise Guide, Cognos, Oracle, Teradata.

Sep 2005 - Mar 2007

1 year 7 months

Zürich, Switzerland

Rating Data Mart

Bank in Zurich

Business analysis and solution architecture for an Oracle data warehouse.
Gathered requirements for the Basel II Rating Office.
Created a dimensional data model.
Implemented an interface for the Basel II Rating Office.
Implemented ETL processes with Informatica PowerCenter.
Implemented complex SQL views and PL/SQL procedures.
Introduced Hyperion Essbase for reporting.
Designed Control-M job networks.
Managed changes with ClearQuest.
Handled tickets with Peregrine.
Documented tests with Quality Center.
Technologies used: Oracle, Informatica, PL/SQL, ClearCase, ClearQuest, Requisite Pro, Quality Center, ERwin, TOAD, Control-M, Perl, Peregrine, CVS, Access, Hyperion Reporting.

Jan 2005 - Dec 2005

1 year

Zürich, Switzerland

Credit & Risk Data Mart

Bank in Zurich

Solution design for an Oracle data warehouse.
Gathered requirements for the Credit & Risk department.
Designed the solution architecture.
Designed the staging processes for the data mart.
Assisted with release planning.
Implemented ETL processes with Informatica.
Implemented complex SQL views and PL/SQL procedures.
Created reports with Hyperion Essbase.
Designed Control-M job networks.
Developed a solution for automated test data provisioning for unit tests.
Managed changes with ClearQuest.
Handled tickets with Peregrine.
Technologies used: Oracle, Informatica, PL/SQL, ClearCase, ClearQuest, ERwin, TOAD, Control-M, Perl, Peregrine, CVS, Access, Hyperion Reporting.

Jul 2004 - Dec 2004

6 months

Frankfurt am Main, Germany

Production Support for an Oracle DWH

Bank in Frankfurt and London

Acted as the interface between the business department and external development in London for an Oracle data warehouse in private banking.
Analyzed error situations and provided 3rd level support.
Captured change requests.
Created and tracked error tickets.
Assisted with release planning.
Maintained PowerCenter mappings for the Oracle data warehouse.
Maintained load process chains using Control-M.
Programmed urgent workarounds.
Developed various analysis tools.
Technologies used: Oracle, Informatica, PL/SQL, Java, Visual Basic, VB.NET, DB2, COBOL, MQ Series, ClearCase, ClearQuest, TOAD, Control-M, Perl, WebSphere, OLYMPIC.

Dec 2003 - Jun 2004

7 months

Frankfurt am Main, Germany

Localization of OLYMPIC and Data Warehouse

Bank in Frankfurt and London

Technical consulting for the localization of OLYMPIC and the connected data warehouse.
Analysis of order management and order routing processes.
Documentation of release management procedures.
Documentation of daily workflows and exception handling for application support.
Optimization of PowerCenter loads and Oracle data warehouse.
Technologies used: ORACLE, PL/SQL, Java, Visual Basic, ODBC, MS Access, DB2, COBOL, MQ Series, Erwin, Informatica, ClearCase, ClearQuest, TOAD, Control-M, Perl, WebSphere, OLYMPIC.

Jan 2001 - Dec 2001

1 year

Munich, Germany

Order Routing System

Bank in Munich

Development work for an order routing system connected to Sectras.
Design to improve availability.
Design of the test and production environments.
Design of release management.
Development of an error log and availability statistics.
Development of an MQ Series interface to the host in C++.
Creation of emergency documentation for on-call service on the intranet.
Support and monitoring of production.
Technologies used: UNIFY TeamDeveloper, SQL-TALK, ORACLE, PL/SQL, C++, MQSeries, Visual Basic, MS Excel, Erwin, SQL Navigator, shell scripts, Dreamweaver, VSS.

Aug 2000 - Nov 2003

3 years 4 months

Munich, Germany

Income Statement and Annual Tax Certificate

Bank in Munich

Development of a multi-client system for generating and producing income statements and annual tax certificates.
Technical project management.
Redesign of the ORACLE database, optimization, and tuning.
Development of PL/SQL packages.
Development of parallel processes using ORACLE job queues.
Conversion of batch load processes to SQL*Loader direct loads.
Administration of the development database.
Connection to the host using Java and JDBC to DB2.
Connection to DB2/400 using the ORACLE Transparent Gateway.
Maintenance and redevelopment of the user interface.
Development of analysis tools using Visual Basic, MS Access, and ODBC.
Design of the integration with a new back-office system.
Execution of data migrations from a new client's system.
User and production support.
Setup and operation of the development environment.
Technologies used: UNIFY TeamDeveloper, ORACLE, PL/SQL, Java, Eclipse, Visual Basic, MS Access, DB2, COBOL, Erwin, PowerDesigner, SQL Navigator, TOAD, VSS, Perl.

Nov 1999 - Feb 2000

4 months

Vienna, Austria

Information Providing Documentation for a Stock Exchange

Stock Exchange in Vienna

Inventory and analysis of the processes and applications for information providing.
Creation of technical documentation.
Creation of the operator manual.
Technologies used: OpenVMS, DCL, C, RSM, PCGrasp, MS Office.

Aug 1994 - Jul 2000

6 years

Vienna, Austria

Development in Decentralized Banking Systems

Bank in Vienna

Development of client/server applications for e-banking.
Technical lead of the subproject 'Monitoring and Investigation'.
Development of an application for monitoring and investigating e-banking transactions with structured display of EDIFACT files.
Design and implementation of build management with VAX-MMS for the entire project.
Definition of coding guidelines and checklists for formal code inspections and performing these inspections.
Design of a Lotus Notes database for structured documentation and discussion forum.
Analysis of the Reuters SSL4 data feed.
Maintenance and redevelopment of SSL4 interfaces.
Application support for the 'Wallstreet' treasury system.
Design and development of DCL command procedures.
Development and maintenance of a multi-client call center application with IVR (Interactive Voice Response) in a client/server architecture.
Development of a 3270 user interface on OpenVMS for selecting and viewing lists and documents archived on CD with the ability to save recurring queries.
Review of the externally created requirements specification and parameterization of the standard software IPOS for international payments.
Technologies used: OpenVMS, C, ORACLE-RDB, DECFORMS, LU6.2, APPC, SNA, INA/ACNS, Reuters Triarch, IPOS, Lotus Notes.

Jan 1986 - Feb 1994

8 years 2 months

Vienna, Austria

Application development for an industrial company

Industrial company in Vienna

Development of a production control system with sequence optimization.
Implementation of the interface to the AS400 PPS and graphical display of production plans in a MOTIF GUI.
Creation of a coordination tool for development and production activities between two partnering companies in the telecom industry.
Installation, administration, and training for SQL/DS.
Introduction of the IEW/ADW CASE tool in the company, conducting pilot projects and training specialist departments.
Creation of a company-wide data model.
Design and implementation of the "Engineering Bill of Materials" system.
Design and implementation of an error tracking system in a client/server architecture.
Development of heuristic optimization methods for PCB drilling and needle adapter positioning.
Development of an application for load optimization of telecom networks.
Implementation of a host-based user interface for entering optimization parameters with CMSDMS and later porting to PC with Turbo Pascal, including graphical network display.
Programming of a project planning tool with integrated capacity and cost calculation.
Technologies used: MOTIF, C++, IEW/ADW, VM/CMS, VAX/VMS, REXX, SQL/DS, ABF, INGRES, PostScript, Pascal, FORTRAN, PL/I, CMSDMS.