Start_B

Start_B

Start_B

Welcome at Intellisol.com

With many years of experience in the field of business consulting, I stand by your side as a reliable and competent partner in the new construction and further development of a data warehouse. I have a great expertise in the field of processing large amounts of data with relational databases. I enjoy automating and optimizing processing procedures.

The challenge of data integration in a large data warehouse is often to integrate many heterogeneous sources in a short period of time and to quickly react to changes in the interfaces during project operation. Standardized and automated integration processes are helpful here. Thanks to many years of practice, I can offer you reliable solutions for your needs as well.

Dr. Thomas

Lokajczyk

German, born 1965

Senior Consulting Data Warehouse / BI
Freelance IT consultant since 2017, communicative personality with hands-on mentality
16 years of consulting experience in the area of Data Warehouse / Business Intelligence, including several years of experience and focus on:
- High performance DWHs based on MPP in-memory databases in the multi-terabyte range
- Development of high-performance loading frameworks for neartime loading of several thousand data sources
- Development of metadata generators for fast, automated integration of new data sources
- Optimization of rollout processes for source system changes

6 years system engineer in the areas of billing, DWH and CRM
4 years lecturer at the Technische Hochschule Georg Agricola in Bochum (Department of Electrical Engineering)
2 years postdoc at the German Electron Synchrotron (DESY) in Hamburg
PhD thesis in experimental plasma physics, graduation as Dr. rer. nat.
Physics studies at the Ruhr-University Bochum, graduation as Diplom Physiker
Sports in his spare time (boxing, crossfit, running

show more show less

Skills

Databases

Exasol
Oracle
MySQL
Sqlserver
Sqlite

Operating systems

Linux
Windows
Solaris
AIX

Methodological expertise

Conception
Development
Metadata generation
DWH architecture
Test automation
Presentation
Training
Project Management
Quality Assurance

Software systems

Pentaho Data Integration
Git
Subversion
Confluence

Programming languages

Python
Perl
SQL
Lua
Scala
Bash
PL/SQL
GoLang

Languages

Deutsch
Englisch

Trainings

2021

Certificate

Version Control with Git (Coursera)

Certificate

Multithreading with Python

Certificate

Python for advanced

Certificate

Python: Type Annotations

Certificate

Python: Unit Testing

Certificate

OOP with Python

2020

Certificate

Exasol Certified Expert for AWS deployment

Certificate

Exasol Certified Expert for on Premises Deployment

Certificate

Exasol Certified Expert for Advanced Analytics

Certificate

Exasol Certified Associate

Certificate

Exasol Certified Performance Expert

Certificate

Exasol 6 Certified Professional Administrator

Projects

2022

11.2020 - 01.2022

Migration of an Online Ticket System

Creation of a database model to provide the basis for the migration objects (Oracle)
Development of
- integration processes for different kind of sources (APIs, Database)
- JSON-Objects for transfer via interface APIs (Python)
- a framework for high performance and reliable data exchange via the APIs using threads and multiprocessin
- a meta database layer to monitor the migration and to have a restartable process chain

03.2013 - today

Support and enhancements of a DWH for analysis and marketing

Support for production problems
Consulting for further development
Database and ETL migration from SQL-Server 2008 to 2014
Implementation of change requests based on SQL-Server, SSIS and Perl
Connection of interfaces of several marketing platforms for sales validation

2020

01.2020 - 05.2020

Integration of a new partner company into a central neartime DWH system (EXASOL)

Data integration of a new subsidiary into the central data warehouse.
Simplification of existing processes for better scalability

02.2020 - 02.2020

Exasol database audit

360° Examination of the central DWH
Performance analyses of the long runners
Preparation of an audit report with recommendations for action

07.2020 - 11.2020

Data Warehouse Migration

Analysis and reverse engineering of a legacy DWH subsystem (Oracle – OWB)
Dependency analysis as a basis for simplifying the loading processes
Creation of recommendations for the subsequent migration to Oracle ODI

2019

04.2019 - 12.2019

Building a DWH within a Hadoop environment

Setup of a DWH within a Hadoop environment
- Requirements analysis
- ETL development using a Spark framework and Exasol
- Improvement of the deployment processes
- Modeling with DataVault 2.0