Stefan D.
BI Consultant in Controlling
Experience
Apr 2025 - Present
6 monthsRemote
BI Consultant in Controlling
Reutter GmbH
- Extraction, transformation and cleaning of data from Microsoft Dynamics AX
- Creating sales reports in Power BI and consolidating them into a data warehouse.
- Training employees in Business Intelligence Technologies: Power BI, SQL, SQL Server Integration Services (SSIS)
Jul 2024 - Present
1 year 3 monthsFrankfurt, Germany
BI & Data App Developer
A&W Holding GmbH (Energievertrieb)
- Automating the controlling process.
- Extraction, transformation and cleaning of data from various data sources and consolidating into a data warehouse.
- Creating comprehensive dashboards and reports in Power BI.
- Leading a team of two data analysts.
- Technologies: Power BI, Python, SQL, Excel, Git
Apr 2024 - Present
1 year 6 monthsVienna, Austria
Business Data Engineer
Gebauer & Griller Kabelwerke GmbH (Automotive)
- Building an ETL process in Azure Data Factory to load data from SAP ERP, SAP BW and SAC.
- Cleaning, linking and analyzing data in Azure Databricks.
- Delivering reports in Power BI.
- Coordinating with stakeholders: business analysts, SAP consultants and DevOps engineers.
- Technologies: Azure Data Factory, Databricks, Power BI, Apache Spark
Apr 2024 - Nov 2024
8 monthsMunderfing, Austria
Controlling Tool Developer
Glasfaser Spezial-Bau GmbH (Bauindustrie)
- Developing a Python pipeline to load data from two construction planning systems into a data warehouse.
- Creating a Power BI report with detailed maps of the fiber network to monitor construction progress and costs.
- Technologies: Power BI, Python, MySQL, Git
Nov 2023 - Mar 2024
5 monthsZürich, Switzerland
BI Consultant
Von Greyerz AG (Asset Management)
- Creating comprehensive Power BI reports on managed assets, inventory movements, financial metrics and customer KPIs.
- Ensuring highest care for data security due to highly confidential customer data.
- Technologies: Power BI, SQL
Aug 2023 - Sep 2023
2 monthsBerlin, Germany
Financial Modelling Consultant
Zolar GmbH (Solaranlagen)
- Preparing the financial planning for a special purpose vehicle (SPV) for investor outreach.
- Technologies: Excel, VBA
Mar 2023 - Apr 2023
2 monthsBonn, Germany
BI Consultant
DHL Consulting GmbH (Management & Logistics Consulting)
- Acting as a sparring partner in creating an HR dashboard and supporting complex DAX formulas.
- Technologies: Power BI
Dec 2022 - Feb 2023
3 monthsHamburg, Germany
BI Consultant
DZ-4 GmbH (Solaranlagen)
- Developing a controlling tool in Power BI for plan vs actual comparison of the solar portfolio.
- Technologies: Power BI
May 2022 - Apr 2023
1 yearEschborn, Germany
Manager (freelance)
Ernst & Young
- Project manager at EY Germany in Strategy & Transactions focused on financial modelling and business intelligence.
- Responsible for the financial modelling workstream in 2 M&A projects and 2 controlling projects.
- Technologies: Power BI, Excel
Jun 2021 - Apr 2022
11 monthsVienna, Austria
Financial Modelling Consultant
Bausparkasse Wüstenrot AG (Bank)
- Creating budget planning for the capital market as part of launching a retail bank.
- Technologies: Excel, VBA
May 2021 - Dec 2021
8 monthsAmsterdam, Netherlands
Energy Data Analyst
Power2X Services B.V. (Energie)
- Modeling the European electricity market (supply and demand modeling) to develop electricity price scenarios.
- Technologies: Python, PLEXOS
Mar 2021 - Apr 2021
2 monthsVienna, Austria
Financial Modelling Consultant
Ring International Holding AG (Private Equity)
- Preparing planning calculations for various RIH companies.
- Technologies: Excel
Jan 2021 - Present
4 years 9 monthsVienna, Austria
Founder & Consultant
Walecon e.U.
- Founded the consulting firm Walecon focusing on business intelligence, data analytics and financial modelling
Sep 2018 - Dec 2020
2 years 4 monthsVienna, Austria
Manager
Ernst & Young
- Part of the EY Strategy & Transactions team and responsible for business analytics and financial modelling.
- Projects in business intelligence and data warehousing, integrated financial planning, statistical modeling.
Mar 2015 - Jun 2018
3 years 4 monthsZug, Switzerland
Portfolio Optimization Expert
MET International AG
- Part of the Power & Gas Trading team. Responsible for controlling and optimizing electricity and gas supply contracts. Performing market analyses using statistical methods.
Feb 2012 - Mar 2015
3 years 2 monthsVienna, Austria
Commodities and Financial Analyst
Sibex GmbH
- Data warehousing, data analytics and financial planning in commodity trading.
Feb 2009 - Feb 2012
3 years 1 monthVienna, Austria
Consultant
Deloitte
- Part of the Financial Advisory team focusing on quantitative finance, financial modelling and business analytics.
Summary
Support along the entire data-based decision-making process from raw data preparation through statistical analysis to transparent communication to decision makers:
- Implementing end-to-end solutions to automate the controlling process, including data integration, transformation and dashboarding.
- Preparing and merging business data from different data sources.
- Developing interactive BI dashboards and visualizing complex business data to support data-driven decisions.
- Conducting analyses using statistical methods (machine learning).
Languages
German
NativeEnglish
AdvancedEducation
Sep 2014 - Jul 2015
University of Geneva
Diploma of Advanced Studies · Commodity Trading · Geneva, Switzerland
Mar 2009 - Dec 2010
University of Vienna
Master, Statistical Programming · Data Science · Vienna, Austria · Graduated with distinction
Jul 2007 - Mar 2009
University of Vienna
Bachelor · Statistics and Data Analytics · Vienna, Austria · Graduated with distinction
...and 1 more
Certifications & licenses
Microsoft Certified: Azure Data Fundamentals
Microsoft
Microsoft Certified: Azure Enterprise Data Analyst
Microsoft
Microsoft Certified: Power BI Data Analyst
Microsoft
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.