Thomas Reick

MS Power BI / MS SQL Developer

Essen, Germany

Experience

Jan 2024 - Jun 2024
6 months
Worms, Germany

MS Power BI / MS SQL Developer

Ewr Ag

  • Designing use cases with business units

  • Developing performance-optimized dashboards

  • Usability analysis of existing dashboards and optimization

  • Structuring reporting requirements

  • Further development of the central data warehouse architecture (Microsoft Fabric)

  • Creating SQL queries and reports

  • Designing and developing analysis databases

  • System documentation

  • Tools/Skills:**

  • MS Power BI

  • DAX

  • MS Office 365

  • PowerQuery

  • M

  • MS SQL Server

  • SSIS

  • SSRS

  • Power Automate

  • Microsoft Fabric

Apr 2022 - Sep 2023
1 year 6 months
Cologne, Germany

BI Consultant and Power BI Developer

Plusnet GmbH

  • Providing reports, dashboards and analyses

  • Enhancing existing reports and creating new data analyses

  • Migrating existing reports to Power BI

  • Preparing data according to data protection requirements for HR/Legal

  • Tools/Skills:**

  • MS Power BI

  • DAX

  • MS Office 365

  • PowerQuery

  • M

  • Power Automate

  • Confluence

  • SharePoint

  • SQL (MariaDB, MySQL, PostgreSQL, Oracle)

Sep 2021 - Dec 2021
4 months
Bonn, Germany

BI Consultant and Power BI Developer

Deutsche Post

  • Identifying relevant data sources and stakeholders

  • Designing consolidation logic and data models

  • Developing dashboards and interactive visualizations

  • Implementing reporting structures in compliance with data protection regulations

  • Tools/Skills:**

  • MS Office 2013

  • SQL Server 2019

  • MDX

  • M

  • DAX

  • T-SQL

  • Power BI

  • SharePoint

  • SSIS

  • SSAS

  • SSRS

Nov 2018 - Apr 2021
2 years 6 months
Düsseldorf, Germany

External BI Consultant

L'Oréal Deutschland

  • Building flows for integration of external market data into the BI system from requirements to deployment

  • Incident management and monitoring activities

  • Data analysis and mapping

  • Managing relationships with IT partners in India and Paris as well as with external agencies

  • Managing relationships with business stakeholders during the assignment

  • Leading improvement initiatives on the solution with partners

  • Actively participating in the technical migration from SAP BW to Microsoft BI

  • Rolling out and decommissioning tools

  • English communication and documentation management

  • Leading multiple topics with internal and external stakeholders

  • Tools/Skills:**

  • MS Office 2019/365

  • SQL Server

  • VBA

  • MDX

  • M

  • DAX

  • T-SQL

  • Power BI

  • SharePoint

Jul 2018 - Sep 2018
3 months
Bonn, Germany

BI Consultant

DHL

  • Developing an Excel-based processing tool for master data maintenance

  • Connecting SharePoint data

  • Developing plausibility checks and validation procedures

  • Conducting user training and coaching

  • Tools/Skills:**

  • MS Excel

  • VBA

  • SharePoint

Jun 2018 - Sep 2018
4 months
Duisburg, Germany

BI Consultant

Deutsche Bahn

  • Improving Excel reporting and Access database

  • Developing VBA and SQL procedures

  • Rolling out and adapting solutions

  • Tools/Skills:**

  • MS Excel 2010

  • MS Access 2010

  • PL/2 AS400

  • VBA

Dec 2015 - Dec 2015
1 month
Lorem ipsum dolor sit amet

  • Customer classification and site analysis
Apr 2015 - May 2015
2 months
Lorem ipsum dolor sit amet

  • DWH design, ETL processes and reporting
Jan 2015 - Dec 2017
3 years
Lorem ipsum dolor sit amet

  • Process definition for online surveys and automated evaluations
Jan 2015 - Apr 2015
4 months
Lorem ipsum dolor sit amet

  • Change management and sales consulting
Dec 2014 - Jan 2015
2 months
Lorem ipsum dolor sit amet

  • Planning a customer and order database
Jun 2014 - Dec 2015
7 months
Lorem ipsum dolor sit amet

  • Automated documentation processes
Jan 2013 - Dec 2015
2 years
Lorem ipsum dolor sit amet

  • Various BI, CRM, and reporting projects
Jan 2011 - Dec 2014
2 years
Lorem ipsum dolor sit amet

  • IT-side consulting and data integration
Jan 2010 - Dec 2013
2 years
Lorem ipsum dolor sit amet

  • Sales and marketing analyses
Jan 2009 - Dec 2011
2 years
Lorem ipsum dolor sit amet

  • BI and CRM solutions for clinic management

Summary

  • Focus on Business Intelligence (BI), data analysis, reporting, database development.

Languages

German
Native
English
Advanced

Education

Oct 1983 - Jun 1984
Lorem ipsum dolor sit amet

High School Diploma · Essen, Germany

Lorem ipsum dolor sit amet

Economics, Microeconomics, Econometrics, Statistics · Germany

Certifications & licenses

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

Prince2 Scrum Master

Data Protection Officer

TÜV

Microsoft Fabric from Rookie to Rock Star