Go to Website
  • en
  • de

Klaus E.

Exasolution DBA

Paderborn, Germany

Experience

Jun 2024 - Dec 2024
7 months

Exasolution DBA

Rechenzentrum Innsbruck

  • Exasolution server DBA consulting
  • Migration to version 8
  • Analysis of SQL query performance and tuning
  • Troubleshooting batch scripts
  • Technology: GitLab, EXACloud, EXAOperation, DBeaver, Control-M
Sep 2022 - Dec 2023
1 year 4 months

ERP Migration

Elis GmbH

  • Consolidation of ERP landscapes of different branches into a standard system
  • Analysis of legacy system data structure with the business department
  • Building the migration framework to the standard system
  • Loading the migration framework
  • Handing over migration files to production in Paris
  • Support in error analysis and fixing
  • Interface extension to SalesDS
  • Technology: MSSQL on-premises, MSSQL cloud, Oracle, Confluence, Jira, Git
Apr 2021 - Dec 2021
9 months

Data Engineering – DWH / ETL

Haba

  • Reengineering of old structures and data population of the old DWH on MSSQL
  • Reengineering SSIS jobs to connect SAP4/HANA to existing structures
  • Connecting MS Dynamics AX to existing structures
  • Connecting the product system
  • Support in building a new DWH: Enterprise Analytics (company KPIs), Embedded Analytics (process KPIs), Performance Analytics (product KPIs)
  • Technology: MS SQL on-premises + cloud, SSIS, SSMS, SQL Agent Jobs, Freeplane, Snowflake, Confluence, Jira
Feb 2021 - Mar 2021
2 months

Data Quality Architect

Douglas

  • Creating a generic data quality concept and implementation
  • Conducting an as-is analysis of connecting country data sources
  • Creating a generic concept (Snowflake data model)
  • First implementation in Talend jobs
  • Creating the technical documentation
  • Technology: SSMS, Jira, Snowflake, DB2
Feb 2020 - Apr 2020
3 months

Interim Talend Expert

EMP

  • Preparing XML data via queue and providing it for MS Dynamics
  • Support in creating DV concepts
  • Development of ESB routes
  • Creating mappings with Talend Data Mapper
  • Creating the documentation
  • Conducting integration tests, troubleshooting and bug fixing
  • Technology: Talend ESB, MSSQL, RabbitMQ, SQL Tools, QBunny, Postman, Jira
Feb 2018 - Dec 2019
1 year 11 months

Application Management (Talend Development)

FI-SPlus

  • Technical implementation and adjustment of the interface in collaboration with project management
  • Support in creating data processing concepts
  • Implementation including developer tests
  • Creation of documentation
  • Conducting integration tests, troubleshooting, and bug fixing
  • Expanding the operations manual
  • Delivering the application to operations
  • Technology: Talend, Oracle, MSSQL, DB2, SQL Tools, Soap_UI
Apr 2017 - Dec 2017
9 months

Frontend Master Data (Investment)

DekaInvest Bank

  • Extracting, normalizing, and preparing data from various systems for the NX manager
  • Installing and extending master data interfaces
  • Implementing using shell scripts, stored procedures, awk, sed
  • 3rd level support for the interfaces
  • Clarifying missing definitions and supporting specifications for new interfaces
  • Supporting necessary updates in the legacy system
  • Project management and planning, effort estimation, and implementation at database and system level
  • Technology: Sybase ASE, Oracle, shell scripting, SQL tools
Oct 2015 - Jan 2017
1 year 4 months

Counterparty Risk (Investment Risk Calculation)

Commerzbank

  • Performance analysis on Sybase ASE
  • Implementing requirements using shell scripts and stored procedures
  • 3rd level support and migration of the legacy system
  • Clarifying missing definitions
  • Supporting specifications for the new system and enhancements in the legacy system
  • Supporting project management, planning, and data protection clarification with business units
  • Effort estimation and implementation at database and system level
  • Technology: Sybase ASE & IQ, UC4, shell scripting, SQL tools
Mar 2015 - Sep 2015
7 months

Logistics Sector

DHL

  • Loading a data warehouse
  • Developing a framework for XML mapping (file to table) in Talend DI
  • Using the Talend XML module
  • Analyzing system base structure and file structure
  • Clarifying missing definitions (XML attribute to table column)
  • Creating XML mappings for new reports in collaboration with the client
  • Leading a small ETL transfer and test team
  • Supporting project management and planning
  • Technology: Teradata, Talend ETL
Mar 2014 - Feb 2015
1 year

Exasol Expert

IMS Health

  • Analyzing processes and redesigning existing applications in the data warehouse
  • Conducting market analysis and introducing a new ETL tool (SSIS) in line with the existing IT structure
  • Point of contact for DWH modeling and performance issues of the old DWH
  • ETL process guidelines for introducing a metadata-driven new DWH
  • Supporting PowerPoint presentations and knowledge transfer to India
  • Technology: SSIS, Exasol, DBSchema, Erwin, ESP, Harvest
Apr 2013 - Dec 2013
9 months

Server Platform Optimization

Commerzbank

  • Analysis of database servers and cluster zone (Sybase ASE / IQ)
  • Project lead on the database side (Sun Sparc to x86 cluster)
  • Point of contact for the business side for new versions
  • Analysis and provisioning of the cluster zone (Sun Cluster)
  • Setting up new databases and upgrading/migrating to the new zone
  • Adjusting server parameters for the new version
  • Support for performance issues
  • Creating migration scripts
  • Technologies: Shellscript, ASE 15.7, ASIQ 15.4, ASIQ 16, Perl
Aug 2012 - Jan 2013
6 months

Data Archiving according to GDPdU

Projektfabrik GmbH

  • Reengineering data models from various databases
  • Talend data migration from DB2, Oracle, MSSQL to MySQL
  • Talend flat file processing and creation of generic extraction jobs
  • Ensuring data integrity and quality
  • Executing the process and defining the ETL job structure
  • Technologies: Talend ETL, DB2, Oracle, MSSQL, SmartX, SmartV
May 2012 - Jul 2012
3 months
Berlin, Germany

Migration Support

Groupon Berlin

  • Migration from PostgreSQL to Vertica server
  • Data provisioning from the staging area to Vertica
  • Advising on Vertica data schema
  • Technologies: PostgreSQL, Vertica, Talend ETL
Jan 2009 - Dec 2012
4 years

Data Warehouse Project Lead

Sonymusic GSA

  • Migrating the data warehouse from Sybase IQ to Exasol
  • Market analysis for new software (Exasol, Infobright)
  • Consulting and procurement of hardware and software
  • Setting up and executing initial tests and POCs
  • Migration project planning and building the new data warehouse with Exasol
  • Planning and building the staging area
  • Migrating and normalizing existing data using ETL
  • Setting up data provisioning and backup structures
  • Point of contact for required extensions, infrastructure changes, and recovery
  • Performance tuning of Sybase ASE servers
  • Planning server upgrades and leveraging new features
  • Technologies: Exasol, Shellscript, Perl, OpenProject, Talend ETL, C, Sybase ASE, Sybase IQ, Oracle
Jan 2002 - Dec 2008
7 years

Data Warehouse

BMG / SONYBMG

  • Building a new data warehouse with Sybase IQ
  • Consulting and procurement of hardware and software
  • Market analysis and execution of POCs
  • Migrating existing data from ASE into the data warehouse
  • Extending the data warehouse with host data and connecting additional countries
  • Setting up MySQL and PostgreSQL servers for the online presence
  • Establishing data provisioning to external providers
  • Performance tuning of ASE, IQ, and ASA servers
  • Planning server upgrades and leveraging new features
  • Technologies: Sybase IQ, Sybase ASE, Sybase ASA, MySQL, PostgreSQL, Shellscript, Perl, OpenProject, ODI
Jan 1999 - Dec 2002
4 years

Database Administration

BMS / Arvato Systems

  • Administration of Sybase servers
  • Upgrade from ASE 11.5 to 11.9 with planning and creation of upgrade scripts (Perl)
  • Troubleshooting during live operation
  • Point of contact for enhancements
  • Maintenance of batch scripts (shell, Unix)
  • Technologies: Perl, shell scripts, PowerDesigner, awk, sed, Sybase ASE

Summary

Project manager DWH

  • New DWH with new technology
  • Insert large data volumes in a short time
  • Query large data volumes in ad-hoc queries with low response times
  • Low maintenance effort

Interfaces and database developer ETL

  • Support the business department in implementing the functional concept with data-side requirements and their validation.
  • I implemented interfaces to the DWH and data lake with Talend, SSIS.
  • I developed interfaces in the database environment using linked servers, remote server connections, replication, CDC connections.
  • Reengineering and migration of legacy systems.
  • Consulting, support, and implementation of various legacy systems on MSSQL, Oracle, and DB2 into an ongoing current ERP system on MSSQL.

Languages

German
Native
English
Advanced

Education

Universität Paderborn

Diploma in Physics · Physics · Paderborn, Germany

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Vitali H.

Power BI Expert

View Profile
Konstantin G.

Requirements engineer, Python Developer

View Profile
Alexander Z.

Senior Data Architect & Data Engineer

View Profile
Henok A.

Founder and Managing Director

View Profile
Jakub S.

Oracle Consultant

View Profile
Evrim I.

T-SQL Database Expert

View Profile
Stefan F.

Support Oracle Administration and Tuning

View Profile
José C.

IT Architect, Process Manager

View Profile
Timo K.

Senior Fullstack Developer

View Profile
Christian D.

Lead Business Functional Analyst

View Profile
János K.

Data Engineer Lead

View Profile
Josef K.

Architect / Senior Consultant

View Profile
Peter B.

Data Warehouse Consultant (Development and Analysis)

View Profile
Stefan C.

BI Developer

View Profile
Tarek S.

Cloud Analytics Developer

View Profile
fratch Part of Bitkom logo
linkedIncrunchbaseyoutube
  • English
  • Deutsch

2025 © FRATCH.IO GmbH. All rights reserved.