Thomas R.

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

  • Design use cases with business units

  • Developed performance-optimized dashboards

  • Usability analysis of existing dashboards and optimization

  • Structured reporting requirements

  • Evolved the central data warehouse architecture (Microsoft Fabric)

  • Created SQL queries and reports

  • Designed and developed analytical databases

  • System documentation

  • Tools/Skills:**

  • MS-PowerBI

  • DAX

  • MS-Office 365

  • PowerQuery

  • M

  • MS-SQL-Server

  • SSIS

  • SSRS

  • PowerAutomate

  • Microsoft Fabric

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

BI Consultant and Power BI Developer

Plusnet GmbH

  • Delivered reports, dashboards, and analyses

  • Enhanced existing reports and created new data analyses

  • Migrated existing reports to Power BI

  • Prepared data according to data protection regulations for HR/legal

  • Tools/Skills:**

  • MS-PowerBI

  • DAX

  • MS-Office 365

  • PowerQuery

  • M

  • PowerAutomate

  • Confluence

  • SharePoint

  • SQL (MariaDB, MySQL, PostgreSQL, Oracle)

Sep 2021 - Dec 2021
4 months
Bonn, Germany

BI Consultant and Power BI Developer

Deutsche Post

  • Identified relevant data sources and stakeholders

  • Designed consolidation logic and data model

  • Developed dashboards and interactive visualizations

  • Implemented reporting structure compliant with data protection regulations

  • Tools/Skills:**

  • MS-Office 2013

  • SQL-Server 2019

  • MDX

  • M

  • DAX

  • T-SQL

  • PowerBI

  • 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 BI System from requirements to deployment

  • Incident Management and Monitoring activities

  • Data analysis and mapping

  • Managed relationship with IT partners in India and Paris as well as with external agencies

  • Managed relationship with Business stakeholders during his assignment

  • Lead Improvement points on the solution with partners

  • Active participant in the technical migration from SAP BW to Microsoft BI

  • Rollout and decommissioning of tools

  • English communication and documentation management

  • Leading several topics with internal and external stakeholders

  • Tools/Skills:**

  • MS-Office 2019/365

  • SQL-Server

  • VBA

  • MDX

  • M

  • DAX

  • T-SQL

  • PowerBI

  • SharePoint

Jul 2018 - Sep 2018
3 months
Bonn, Germany

BI Consultant

DHL

  • Developed an Excel-based tool for master data maintenance

  • Connected SharePoint data

  • Developed validation checks and audit procedures

  • User training and coaching

  • Tools/Skills:**

  • MS-Excel

  • VBA

  • SharePoint

Jun 2018 - Sep 2018
4 months
Duisburg, Germany

BI Consultant

Deutsche Bahn

  • Improved Excel reporting and Access database

  • Developed VBA and SQL procedures

  • Rollout and adjustments

  • 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 location analysis
Apr 2015 - May 2015
2 months
Lorem ipsum dolor sit amet
  • Data warehouse design, ETL processes, and reporting
Jan 2015 - Dec 2017
3 years
Lorem ipsum dolor sit amet
  • Process definition for online surveys and automated analyses
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 of a customer and order database
Jun 2014 - Dec 2014
7 months
Lorem ipsum dolor sit amet
  • Automated documentation processes
Jan 2013 - Dec 2014
2 years
Lorem ipsum dolor sit amet
  • Various BI, CRM, and reporting projects
Jan 2012 - Dec 2013
2 years
Lorem ipsum dolor sit amet
  • IT consulting and data integration
Jan 2011 - Dec 2012
2 years
Lorem ipsum dolor sit amet
  • Sales and marketing analyses
Jan 2010 - 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, and 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

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions