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
  • 14 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

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

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
March 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
January - May 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
February 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
2019
April - December 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