Andreas (Mba, b. sc.) R.
Information Warehouse Manager
Experience
Jan 2025 - Present
10 months Lorem ipsum dolor sit amet
Mittelständischer Hersteller für Klebesysteme
- Migrated sales reporting to Power BI
- Trained business units in Power Query and DAX
- Created a data warehouse for optimal data processing
Jan 2025 - Present
10 months Lorem ipsum dolor sit amet
Österreichischer Maschinenbauer
- Migrated the KPI landscape (production/sales/procurement) to Power BI
- Trained expert teams (in-house knowledge transfer)
Jul 2024 - Present
1 year 4 months Lorem ipsum dolor sit amet
Maschinenbauer
- Supported the creation of Oracle-based reports
- Implemented ETL processes in PL/SQL
Jun 2023 - Present
2 years 5 months Lorem ipsum dolor sit amet
Mittelständischer Maschinenbauer
- Migrated existing analytics to Power BI infrastructure
- Conducted requirements analysis with business units
Mar 2023 - Present
2 years 8 months Lorem ipsum dolor sit amet
Mittelständischer Hersteller für Temperiersysteme
- Replaced manual Excel HR analyses with Tabular Models
- Made adjustments to local web applications (C#)
- Trained business units on data warehousing
Jul 2022 - Present
3 years 4 months Lorem ipsum dolor sit amet
Medium-sized software manufacturer
- Data migrations from legacy systems
- Interface programming
- Support for data analytics
- Consulting in the Power Platform
Jun 2022 - Dec 2023
1 year 7 months Lorem ipsum dolor sit amet
International crane manufacturer
- Implementation of on-premises Power BI reports using tabular models
- Implementation of dynamic planning tools to optimize make-or-buy decisions
- Implementation of bill of materials analyses to support design optimization decisions
Apr 2022 - Jun 2022
3 months Lorem ipsum dolor sit amet
Cosmetics manufacturer
- Development of Power BI reports for sales, inventory, and financial accounting
- Maintenance of the reports using MSSQL Server views
- Implementation of dataflows
Sep 2021 - Dec 2021
4 months Lorem ipsum dolor sit amet
International pharmaceutical company (Germany)
- Development of Power BI reports for supplier evaluation, lab analytics, and quality assurance
- Maintenance of the reports through an enterprise data backbone (Databricks) and Oracle
- Implementation of dataflows
- Implementation of Power Apps for data collection within Power BI
- Implementation of Power Automate workflows for processing and extracting Teams data
Feb 2021 - Present
4 years 9 months Lorem ipsum dolor sit amet
International pharmaceutical company (Austria)
- Development of Power BI reports for inventory management and change management
- Maintenance of the reports through an enterprise data backbone (Databricks), SharePoint files (exported from SAP), and Excel (manual entries)
- Refactoring existing reports using DaxStudio and Tabular Editor
Feb 2021 - Jun 2021
5 months Lorem ipsum dolor sit amet
Mid-sized E-commerce Retailer
- Implemented ETL processes in Python for Amazon (REST API, Selenium)
- Created reports for sales and inventory management
Feb 2021 - Jun 2021
5 months Lorem ipsum dolor sit amet
Software Vendor
- Implemented an import interface to Mercateo using PLSQL
Nov 2020 - Dec 2020
2 months Lorem ipsum dolor sit amet
Software Vendor
- Developed a system for automatic detection of incoming invoices and order confirmations using Azure Cognitive Services and Azure Data Lake
Sep 2020 - Dec 2022
2 years 4 months Lorem ipsum dolor sit amet
International Construction Group
- Developed Power BI reports using Power BI Dataflows (including linked entities)
- Implemented new requirements in finance and sales reporting
- Refactored existing reports using DaxStudio and Tabular Editor
- Optimized performance of existing reports
- Performed requirements engineering in an international team
- Developed and populated streaming datasets using C#
- Connected Azure Data Lakes as a data source
- Conducted training sessions
- Implemented ETL processes using Data Factory
- Administered and deployed Azure ML models (via Visual Studio Code)
Jan 2020 - Jul 2020
7 months Lorem ipsum dolor sit amet
Own Product
- Created custom connectors and Power BI template apps as a SaaS product in my own store
Jun 2019 - Present
6 years 5 months Lorem ipsum dolor sit amet
Medium-sized variant manufacturer
- Replaced the existing controlling landscape (SSAS cube, Excel as frontend) with Power BI
- Connected and consolidated heterogeneous data sources
- Supported all common project phases: requirements engineering, implementation, testing, training, support
- Used source systems Microsoft Business Central, Microsoft Dynamics NAV ERP/CRM, proprietary production system
Jan 2019 - May 2019
5 months Lorem ipsum dolor sit amet
Medium-sized e-commerce retailer
- Introduced Power BI as an analysis tool
- Connected various cloud systems (Facebook, ERP, currency service provider, Sheet) via REST API
- Conducted training and administration
May 2015 - May 2020
5 years 1 monthOffenburg, Germany
Information Warehouse Manager
Printus GmbH
- Introduced Power BI and provided training
- Developed connections to external cloud-based systems
- Translated SAP-specific requirements into reports
- Implemented SSAS tabular models and SSAS cubes as a source for Power BI
- Implemented and maintained ETL processes (Oracle DWH/SQL Server)
Mar 2010 - May 2015
5 years 3 monthsLahr, Germany
ERP/BI Consultant/Project Manager
Schrempp EDV
- Developed the in-house ERP software SIVAS
- Developed the in-house business intelligence software BI.Analyzer
- Served as sub-project manager for materials management/internal logistics with programming of mobile devices
- Managed full projects in the mechanical engineering industry: creating functional specifications, conducting training, implementing process reliability
- Advised in the business intelligence area: defining KPIs, documentation, evaluation, and knowledge transfer
- Completed over 20 business intelligence projects independently
Mar 2009 - Feb 2010
1 yearSindelfingen, Germany
Junior ERP-Consultant
Computenz
- Developed custom programs/reports
- Upgraded Computenz industry software to the Role Tailored Client
- Transferred knowledge of new technologies to colleagues
Summary
I have dedicated my career to building robust analytics and data solutions by implementing modern BI tools like Power BI, Power Query, and DAX. Over the years, I have led key projects in industries ranging from manufacturing and pharmaceuticals to ecommerce and construction. My experience spans establishing data warehouses, automating ETL processes, and training teams to effectively manage and interpret data.
I focus on delivering practical results by aligning technical solutions with business needs. By consolidating diverse data sources and refining reporting systems, I help organizations optimize decision-making and streamline processes. My hands-on approach and continuous improvement mindset allow me to consistently drive value in every project I undertake.
Languages
German
NativeEducation
Oct 2011 - Jun 2013
Hochschule Offenburg
Master of Business Administration, General Management · Business Administration · Germany · 1,7
Oct 2005 - Jun 2009
Hochschule Offenburg
Bachelor of Science · Applied Computer Science · Germany · 2,1
Certifications & licenses
ISTQB Certified Tester (Foundation Level)
Business Mediator (IHK Certificate)
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.