Jan Schuermeier

Data Engineer
We live in a data driven world.

Today's companies produce more data than ever before and it is essential to publish it in a timely and integrated manner to the stakeholders. Linkable and reliable information plays a key role in operational decision-making and strategic planning.

As a consultant with a focus on business intelligence, in particular Data Integration, Data Warehousing and Big Data, my goal is to help you develop and use this information - for the best possible business success.

Learn more >

Über mich

Qualification

Based on my studies of business informatics, I have the ability to combine IT and business knowledge. Together with years of experience in consulting, acquired in several IT consultancies, I offer you a comprehensive know-how basis for your project requirements.

Degree: MSc Information Systems
Languages: German, English, French

Industry Sectors

All of my services are independent of the sector. My previous projects were focused on the financial industry, the trade as well as the telecommunication sector.

Certificates

SAP Certified Application Associate –
SAP Data Services 4.2

Leistungen

  • 01. Consulting

    • Design of BI architecture and infrastructure
    • Support for technology selection
    • Reviews of existing implementations
    • Application of best practices
    • Performance optimization
    • Development of standards for administration and operations
    • Conduction of workshops and user trainings

  • 02. Conception

    • Requirement and source data analysis
    • Subject-oriented and technical design
    • Modeling of data integration processes
    • Multidimensional Data Modeling
    • Creation of guidelines for development and operations
    • Introduction of deployment strategies
    • Report design

  • 03. Implementation

    • Implementation of ETL and data integratio processes
    • Ensuring a high level of flexibility through
      dynamic and reusable components
    • Use of proven standards and best practices
    • Performance-optimized design
    • Test, deployment and initial operation

Technologies

Databases

Relational and NoSQL Database Systems

  • Oracle
  • Microsoft SQL Server
  • Exasol
  • Firebase & Firestore

Data Integration

Tools for integrating data from different source systems

  • Informatica PowerCenter
  • SAP (Business Objects) Data Services - BODS
  • Microsoft SQL Server Integration Services (SSIS)
  • SQL, PL/SQL, T-SQL, Python

Business Intelligence

Platforms for Data Analytics and Reporting

  • SAP (Business Objects) BI Platform
  • IBM Cognos Business Intelligence
  • Microsoft Business Intelligence

References

Industry sector:
Financial services
Team size:
10
Kunde:
Index provider
Tasks:
Conception, development, operations
Location:
Conception, development, operations
Technologies:
Informatica PowerCenter, Oracle, PL/SQL, Control-M
Duration:
6 months

Project description:

Creation of data integration processes for the calculation and parametrization of indices based on shares and bonds.

Task description:

Modeling and implementation of data integration processes for master and transaction data based on standardized and proven design patterns with Informatica PowerCenter and PL/SQL. Further tasks include job monitoring and operation support.
Industry sector:
Telecommunications
Team size:
6
Kunde:
Telecommunications provider
Tasks:
Conception, development
Location:
Telecommunications provider
Technologies:
Informatica PowerCenter, Oracle, PL/SQL, SAP Crystal Reports, SAP BO WebI
Duration:
4 months

Project description:

Data integration and reporting for the export of itemised bills. Development of a generic integration process for importing data from SAP CRM into a core DWH, including parameterization and logging.

Task description:

Conception and implementation of processes for data integration as well as creation of reports for displaying metadata of export processes.
Industry sector:
Electronics
Team size:
15
Kunde:
Manufacturer of optics and photography products
Tasks:
Conception, development
Location:
Hamburg
Technologies:
SAP Data Services, SAP ERP, SAP BW, MS SQL Server, Exasol, IBM Cognos
Duration:
1.75 years

Project description:

Konzeption und Implementierung der Datenintegrationsprozesse eines Data Warehouses zur Unterstützung abteilungsübergreifender Informationsflüsse und Ablösung der Datenbasis für ein bestehendes Reporting im Rahmen der Neueinführung von SAP ERP.

Task description:

  • Design and implementation of ETL processes for the integration of master and    transaction data
  • Review and performance optimization of developments prior to release
  • Project management for integration of individual source systems
  • Data migration of legacy data to SAP ERP
  • Consulting and training for operations staff with regard to performance optimization, monitoring and deployment
Industry sector:
Logistics
Team size:
15
Kunde:
Global logistics service provider
Tasks:
Conception, development
Location:
Karlsruhe
Technologies:
SAP Data Services, MS SQL Server, SAP BusinessObjects Information Design Tool, SAP BusinessObjects Web Intelligence
Duration:
4 months

Project description:

Introduction of an operational logistics and transport KPI system including creation of the data foundation for controlling.

Task description:

  • Design and implementation of ETL processes for the integration of master and transaction data
  • Review and performance optimization of developments prior to release
  • Project management for integration of individual source systems
  • Data migration of legacy data to SAP ERP