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