Recommended expert
Thomas Reick
BI Consultant and Power BI Developer
Experience
Apr 2025 - Present
10 monthsCologne, Germany
BI Consultant and Power BI Developer
Plusnet GmbH
- In-depth forensics on old and new data sources
- Enhancement of existing reports and creation of new data analyses
- Data preparation from source systems and semantic models
- Integration of Azure DevOps
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, Power Automate, Redmine, SharePoint, SQL (T-SQL, Oracle), MS Fabric
Apr 2025 - Apr 2025
1 monthBusiness Analyst, BI Consultant and Power BI Developer
audioprotect AG
- Tracking changes in municipality assignment
- Potential data research, modeling, preparation, and calculation
- Geographic allocation/clean-up of customer base
- Aggregation and regionalization of revenues
- Generation of regional sales territories (routing based on customer and potential shares)
- Cartographic and tabular presentation of results
- Derivation of recommendation measures to increase market penetration
- Tools/Skills: MS Power BI, Power Query, M, DAX, Jet SQL (MS Access), GfK RegioGraph
Mar 2025 - Apr 2025
2 monthsBusiness Analyst, BI Consultant and Power BI Developer
elacin GmbH
- Potential data research, modeling, preparation, and calculation
- Geographic allocation/clean-up of customer base
- Aggregation and regionalization of revenues
- Generation of regional sales territories (routing based on customer and potential shares)
- Cartographic and tabular presentation of results
- Derivation of recommendation measures to increase market penetration
- Tools/Skills: MS Power BI, Power Query, M, DAX, Jet SQL (MS Access), GfK RegioGraph
Jan 2024 - Jun 2024
6 monthsMS 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
- Advancing the central data warehouse architecture (Microsoft Fabric)
- Creating SQL queries and reports
- Design and development of analytical databases
- System documentation
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, MS SQL Server, SSIS, SSRS, Power Automate, Microsoft Fabric
Apr 2022 - Sep 2023
1 year 6 monthsCologne, Germany
BI Consultant and Power BI Developer
Plusnet GmbH
- Providing reports, dashboards, and analyses
- Enhancement of existing reports and creation of new data analyses
- Migration of existing reports to Power BI
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, Power Automate, Confluence, SharePoint, SQL (MariaDB, MySQL, PostgreSQL, Oracle)
Sep 2021 - Dec 2021
4 monthsBonn, Germany
BI Consultant and Power BI Developer
Deutsche Post
- Identification of relevant data sources and stakeholders
- Design of consolidation logic and data models
- Development of dashboards and interactive visualizations
- Implementation of the reporting structure in compliance with data protection
- 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 monthsDüsseldorf, Germany
External BI Consultant
L’Oréal Deutschland
- Monitoring ETL processes, testing and validation procedures
- Development of new cube loads for the D-A-CH region
- Reporting with MS Excel, SSRS and Power BI
- Permission management (Active Directory)
- Tools/Skills: MS-Office 2019/365, SQL-Server, VBA, MDX, M, DAX, T-SQL, PowerBI, SharePoint
Jul 2018 - Sep 2018
3 monthsBonn, Germany
VBA Developer and MS Office Developer
DHL
- Integration of SharePoint data
- Development of plausibility checks and validation procedures
- User training and coaching
- Tools/Skills: MS-Excel, VBA, SharePoint
Jun 2018 - Sep 2018
4 monthsDuisburg, Germany
MS Access and VBA Developer
Deutsche Bahn
- Development of VBA and SQL procedures
- Rollout and adjustments
- Tools/Skills: MS-Excel 2010, MS-Access 2010, PL/2 AS400, VBA
Oct 2017 - Dec 2017
3 monthsEssen, Germany
SQL, VBA and MS Access Developer
ISTA
- Data import and export from source to target systems
- Procedural data processing
- Ad-hoc selections
- Further development of campaign tools
- Support in migrating the parallel Office environment to Qlik Sense
- Development of semi-automatic correction processes and tools for incorrectly captured data
- Tools/Skills: MS-Access 2003/2013, MS-Dynamix, MS-SQL-Server, T-SQL, MS-Excel, VBA
Sep 2016 - Sep 2018
2 years 1 monthMoers, Germany
External BI Consultant
MVZ
- Deriving and validating market potential (DeStatis, GfK, mb-research)
- Data preparation, imports, calculations, and reporting
- Visualization with desktop mapping software RegioGraph
- Reporting, address research and validation (private practice doctors), geocoding
- Competitor environment analysis
- Tools/Skills: MS-Access, RegioGraph, MS-Excel
Feb 2016 - Sep 2018
2 years 8 monthsHamburg, Germany
MS Access and VBA Developer
Philips
- Data imports and exports between source and target systems
- Procedural processing
- Ad-hoc analyses
- Further development of the reporting toolkit (infrastructure, content, KPIs)
- Migration of the Office environment to MS SQL Server
- Introduction of SSRS and Power BI to standardize reporting
- Tools/Skills: MS-SQL-Server, T-SQL, SSIS, ADO DB via MS Access/MS Excel, VBA, pivot reporting with MS-Excel, Power BI
Feb 2016 - Aug 2017
1 year 7 monthsDortmund, Germany
SQL and MS Access Developer
Inlingua
- Maintenance, assistance, and user support
- Integration of new tasks and procedures in third-party form handling
- Rights definition and stored procedure definition
- Automation of exam registrations at the BAMF
- Tools/Skills: MS SQL Server, MS Access 2007 with ADP integration, T-SQL
Summary
Focus on Business Intelligence (BI), data analysis, reporting, database development.
Languages
German
NativeEnglish
AdvancedEducation
Oct 1986 - Jun 1988
Lorem ipsum dolor sit amet
Wholesale and foreign trade merchant, fine paper
Oct 1975 - Jun 1984
Lorem ipsum dolor sit amet
High school diploma (Abitur) · Germany
Lorem ipsum dolor sit amet
Economics (econometrics, statistics)
Certifications & licenses
MS Certified: Power BI Data Analyst Associate
Microsoft, Pearson Vue
Prince2 Scrum Master
People Cert
Data Protection Officer
PersCert TÜV
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience