Friedbert W. - Data Analyst / Business Analyst

Go to Website

Ihringen, Germany

Experience

Mar 2025 - Present

6 months

Data Analyst / Business Analyst

Profilmetall

Analyzed and built a new reporting system in Power BI (production data)

Designed data model in Power BI
Created interactive dashboards and reports with Power BI and Power BI Embedded
Implemented row-level and object-level security models
Data modeling: designed and implemented an automated, scalable report model in Power BI
Developed complex DAX queries
Built reports and dashboards for clear KPI visualization to support decision-making
Collaborated closely with internal and client service management teams to implement data requirements and communicate results
Reviewed and improved data quality
Trained team members

Oct 2024 - Mar 2025

6 months

Data Analyst / Business Analyst

Axa

Analyzed and built a new reporting system in Snowflake from two legacy systems

Designed data model in Snowflake
Built MVP reporting with Power BI
Implemented row-level and object-level security
Analyzed payment system per ISO 20022
Data modeling: designed and implemented automated, scalable report model in Power BI
Developed complex DAX queries and calculated columns
Built dashboards and reports for clear KPI visualization to support decision-making
Collaborated with internal and client service management teams to implement requirements and communicate results
Reviewed and improved data quality
Tested developed data models
Tools: Power BI, Snowflake, Jira, Confluence, Git/GitHub

Jan 2024 - Sep 2024

9 months

Data Analyst / Business Analyst / Subproject Lead

VDI

Built member reporting (CRM) and analyzed marketing projects

Created interactive dashboards and reports with Power BI and Power BI Embedded
Data modeling: designed and implemented automated, scalable report model in Power BI
Developed complex DAX queries and calculated columns
Built dashboards and reports for clear KPI visualization to support decision-making
Collaborated with internal and client service management teams to implement requirements and communicate results
Performed marketing and CRM data analysis
Implemented row-level (RLS) and object-level (OLS) security
Created channel reporting system
Reviewed and improved data quality
Tested developed data models in Dataverse
Troubleshot legacy Power BI dashboards
Analyzed Google Analytics 4 data
Analyzed A/B tests
Built web dashboards in Looker
Tools: Power BI, Microsoft Dynamics NAV, Business Central, Google Analytics 4, Google Tag Manager, Jira, Confluence

May 2023 - Dec 2023

8 months

Data Engineer / Data Scientist / Business Analyst / Subproject Lead

Fressnapf-Tiernahrungs GmbH

Subproject 1: Analyzed and reorganized company-wide material master data Subproject 2: Prepared and analyzed online marketing data

SAP R/3, SAP S/4HANA
Migrated from SAP SAC
Analyzed and transformed data with R and Python
Built reports with R
Supported enterprise architecture
Designed e-commerce data structure
Created channel reporting system in Power BI
Established and implemented data governance guidelines
Ensured data quality
Designed data model
Tested data models
Implemented row-level (RLS) and object-level (OLS) security
Wrote SQL and PL/SQL queries
Created interactive dashboards and reports with Power BI and Power BI Embedded
Data modeling: designed and implemented automated, scalable report model in Power BI
Developed complex DAX queries and calculated columns
Built dashboards and reports for clear KPI visualization to support decision-making
Collaborated with internal and client service management teams to implement requirements and communicate results
Built statistical models and predictive analytics simulations in Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Tested and documented solutions
Conducted process analysis, requirement engineering, and process mapping
Tools: SAP R/3/HANA, MS SQL, Oracle, Power BI, SSIS, Google Analytics 4, Google Tag Manager, R, Python, Jira, Confluence, Git

Apr 2022 - Feb 2023

11 months

Data Engineer / Data Scientist

IDT Biologika

Built GMP-compliant analysis software to monitor process data in quality and production. Data sources: MS SQL and SAP. Created KPI reports with Power BI.

SAP ERP
MS SQL, MariaDB
Requirement engineering
Analyzed production data and visualized with R and R-Shiny
Built reports with R Shiny
Conducted process flow analysis and mapping
Designed data model in Snowflake
Tested data models
Migrated from SAP SAC; built dashboards with Power BI
Tested and documented solutions
Tools: SAP R/3, R/Shiny, ShinyProxy, MS SSIS, Snowflake, Linux, Docker, Power BI, Git

Jun 2021 - Mar 2022

10 months

Data Engineer / Data Scientist / Business Analyst / Subproject Lead

Fielmann

Subproject 1: Built e-commerce reporting (CRM and marketing) Subproject 2: Analyzed and reorganized company-wide material master data for digitalization and e-commerce project

SAP R/3, SAP S4HANA
Oracle, MariaDB
Built ETL pipelines
Migrated reports from Qlik Sense to Power BI
Created interactive dashboards and reports with Power BI and Power BI Embedded
Analyzed and transformed data with R and Python
Optimized data structure for faster access
Supported enterprise architecture
Designed e-commerce data structure
Built channel reporting in Power BI
Created data model in Snowflake
Reported marketing data in Power BI
Implemented data governance guidelines
Ensured data quality
Tested data models
Wrote SQL and PL/SQL queries
Built dashboards with Power BI
Implemented row-level (RLS) and object-level (OLS) security
Data modeling: designed and implemented automated, scalable report model in Power BI
Developed complex DAX queries and calculated columns
Built dashboards and reports for clear KPI visualization to support decision-making
Collaborated with internal and client service management teams
Tested and documented solutions
Conducted process flow analysis and mapping
Built statistical models and predictive analytics simulations with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Tools: SAP R/3/HANA, Kafka Streams, MS SQL, SSIS, R, Python, JSON filesystem, Oracle, Snowflake, Power BI, Qlik Sense, Jira, Confluence, Google Analytics, Google Tag Manager, Git/GitHub

Nov 2020 - Mar 2021

5 months

Power BI Developer, Data Scientist, Business Analyst

mySolution

Developed dashboards for the assfinet database

Designed data model
Tested data models
Migrated from Qlik to Power BI
Created interactive dashboards and reports with Power BI and Power BI Embedded
Tested and documented solutions
Wrote DAX scripts
Analyzed data
Tools: MS Power BI, Qlik, SQL database (assfinet)

Aug 2020 - Dec 2020

5 months

FORTRAN and Python Developer

RWE Energie

Analyzed and optimized water management simulation software

Upgraded software to latest release
Optimized parallelization and OpenMP code
Optimized virtual machine performance
Built data model in Snowflake
Validated software
Ran simulations
Built statistical models and simulations with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Tools: MS Visual Studio, Intel Parallel Studio XE FORTRAN, MS Azure, Snowflake, Citrix, Jira, Confluence, Git/GitHub

Dec 2019 - Jul 2020

8 months

Rendsburg, Germany

Project Lead and Developer R and Python; Data Engineer, Data Scientist

Machinery Manufacturer

Analyzed production data to reduce rework and errors

Planned, built, and ran ETL pipelines
Created Azure cloud database
Analyzed data
Visualized data with Power BI
Detected anomalies in datasets
Built statistical models and simulations
Built ML models (supervised and unsupervised) with Python to reduce rework
Developed simulations and statistical models with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Deployed ML models in Azure
Validated simulations
Measurement analysis
Tools: R, interactive Shiny app, Azure, Python, Talend (ETL), Power BI, Excel, Jira, Confluence, Git/GitHub

Jan 2019 - Present

6 years 8 months

Google Analytics Data Analyst

Various Tourism Boards

Ongoing analysis with Google Analytics.

Jan 2019 - Jun 2019

6 months

Marburg, Germany

Project Lead and Developer R and Excel

Pharma Industry

Monte Carlo risk simulations in project management

Introduced Monte Carlo method for project management
Trained staff in Monte Carlo method
Evaluated software vendors
Simulated project plans for time and cost
Built statistical models and simulations
Tools: statistical simulations, Monte Carlo, R, Excel, Vose Software, @RISK, Oracle Crystal Ball, Power BI

Nov 2018 - Jan 2019

3 months

Project Lead and Developer R, Python, SQL / Data Analyst / Machine Learning

Aerospace Supplier

Built SPC system in MEMS production

Networked production equipment
Built ETL pipeline to SAP R/3 and SAP BW
Created SAP tables
Developed statistical models
Detected anomalies in datasets
Introduced and trained in SPC methods
Built statistical models and simulations with Python
Built ML models (supervised and unsupervised) with Python
Deployed ML models in Azure
Visualized data with Power BI
Tools: SAP, R/RStudio, SQL, Azure, ETL processes, Python, R ML, Power BI

May 2018 - Dec 2018

8 months

Project Lead and Developer R, Python, SQL / Data Analyst

Aerospace Supplier

Performed correlation analyses in fiber sensor production

Networked production equipment
Built ETL pipeline to SAP
Created SAP tables
Prepared data for correlation analysis
Detected anomalies in datasets
Linked data across production steps
Built predictive analytics models with Python
Built statistical models and simulations with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Developed ML models (supervised and unsupervised)
Visualized data with Tableau

Goal: Linked test data from production processes to analyze factors impacting final product quality. Analysis of large datasets identified key quality drivers.

Tools: R, RStudio, predictive analytics, Python, ML, Shiny or Tableau, Azure

Jan 2018 - Dec 2018

1 year

Project Lead and Developer R and Python; Implemented Google Analytics and GMT on various websites

Travel Operator

Text mining of Facebook and Twitter reactions

Analyzed user response to marketing activities
Performed NLP analysis with Python and R
Analyzed user behavior and customer reactions
Used Google Analytics
Applied GIS analyses
Built customer retention models with Python
Created Google Analytics reports
Visualized data in Power BI or Tableau per tourism board
Ongoing Google Analytics reporting since 2019 for various boards
Tools: R/RStudio, Shiny, predictive analytics, CRM, Power BI, Tableau, ML, Python

Jan 2018 - May 2018

5 months

Data Engineer / Data Scientist

Pharma Manufacturer

Validation of medical test methods

Validated physical, chemical, and biological test methods
Created test plans and reports
Analyzed test data with R and R-Shiny
Built statistical models with Python
Visualized data with Power BI
Tools: Minitab, R, Shiny app, Power BI

Sep 2017 - Apr 2018

8 months

Project Lead and Developer R, Python, SQL / Data Analyst

Aerospace Supplier

Predictive maintenance in production

Built ETL pipeline to SAP
Created SAP tables
Prepared data for predictive maintenance
Built predictive maintenance models with Python
Developed statistical models and simulations with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Deployed ML models in Azure
Visualized data with Power BI
Tools: R, Python, RapidMiner, Azure

Jul 2017 - Jan 2020

2 years 7 months

Software Quality Lead

Aerospace Supplier

Quality engineer for DO-254 (hardware) and DO-178 (software) certifications at DAL A level

Created compliant planning documents
Managed development processes (requirements engineering)
Planned and executed validation (including FPGA and VHDL)
Planned and executed verification (including FPGA and VHDL)
Planned and executed system tests (flight, performance, hardware/software, EMC)
Participated in EASA audits
Tools: document review, Jira, Confluence, SVN, Git

Jun 2017 - Jun 2017

1 month

LEAN SIX SIGMA Black Belt

Continental

Value stream analysis in production

Conducted value stream analysis within a task force to address throughput and delivery issues
Tools: value stream mapping

May 2017 - Oct 2017

6 months

Developer R, Python, SQL / Data Analyst

Automotive Manufacturer

Developed analytical environment for big data; technical architect for predictive analytics

Installed and managed Hortonworks via Ambari
Set up 3-node cluster with Lambda architecture: Kafka ingestion, Storm speed layer, Spark batch layer
Stored data in HBase, Cassandra, MongoDB, HDFS
Analyzed data with Python and R
Built predictive analytics in Python
Developed statistical models and simulations with Python (NumPy, SciPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, TensorFlow)
Built and maintained ETL process with Talend
Tested Splunk
Worked with SQL and NoSQL databases
Performed GIS analyses
Tools: Hadoop ecosystem, AWS, ML, R, interactive Shiny app

Jan 2017 - Jun 2017

6 months

Statistician and Developer R / Data Analyst / SIX SIGMA Black Belt

Medical Device Manufacturer

Data analysis in medical development; conducted DOE (details confidential)

Analyzed development and production data
Conducted and analyzed DOE
Built statistical models with Python and R
Visualized data with Power BI
Tools: R, Python, Minitab, Power BI

Jan 2017 - Jun 2017

6 months

Statistician / Data Analyst

Travel Operator

Tourism data analysis and CRM system build (details confidential)

Project goal: Derived customer satisfaction insights from Facebook and Twitter reactions. Developed customer retention model
Tools: R, Python, RapidMiner, Power BI, big data tech, CRM, Google Analytics predictive analytics

Aug 2016 - Dec 2016

5 months

Statistician

Heavy Industry Company

Built quality management for production data; coached employees

Linked test data from production processes to analyze factors impacting product quality. Analysis of large datasets revealed key quality drivers
Tools: SAP R/3, CSV, Excel, Tableau, Power BI, statistical analysis, predictive maintenance

Aug 2016 - Dec 2016

5 months

Statistician / Data Analyst

Thyssenkrupp Rasselstein GmbH

Process optimization of a ~600 m rolling mill with DOE

Analyzed production data
Conducted and analyzed DOE
Built statistical models
Tools: Minitab, R, Power BI

Jun 2015 - Dec 2015

7 months

Project Lead and Developer R, Python, SQL / Data Analyst

Aerospace Supplier

Implemented SPC via SAP as part of Industry 4.0

Continued SPC networked workplaces project; added SAP R/3 integration
Tools: SAP data and CSV queries, Excel, R, Python, RapidMiner, Minitab, predictive analytics models

Jan 2015 - Jun 2015

6 months

Project Lead and Developer R, Python, SQL / Data Analyst

Airline

Built MES system on SAP R/3; introduced production tracking and coached production leads

Implemented SPC system for early detection of process changes (e.g., wear)
Visualized results mainly with Tableau
Tools: Tableau, Qlik, predictive analytics for delivery performance

Jan 2015 - Jun 2015

6 months

Project Lead and Developer R, Python, SQL / Data Analyst

Aerospace Supplier

Introduced SPC networked workplaces (Industry 4.0) and trained staff

Built SPC system to monitor process stability via statistical process control
Visualized outcomes mainly with Tableau
Tools: Excel, R, Python, RapidMiner, Minitab, Tableau

Jan 2014 - Present

11 years 8 months

Freelance Senior Consultant

Jan 2010 - Dec 2023

14 years

Quality Process Engineer Black Belt Lean Six Sigma ISO 9001/9100

Northrop Grumman LITEF GmbH

Jan 2007 - Dec 2010

4 years

Lean Six Sigma Black Belt

Northrop Grumman LITEF GmbH

Jan 2000 - Dec 2007

8 years

Group Lead Production Engineering

Northrop Grumman LITEF GmbH

Jan 1999 - Dec 2000

2 years

Development Engineer

Northrop Grumman LITEF GmbH

Jan 1988 - Dec 1999

12 years

Wuppertal, Germany

Senior Engineer

Universität Wuppertal

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Reduced TFT test repeats in μFORS
Context: μFORS test repeats (rework/defects) drive failure stats and production deviations. Hard to distinguish device vs. tester faults.
Goals:
Cut μFORS test repeats by 50%
Reduce deviation time by 30%
Increase TFT test capacity by 20%

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Scoped LCR-100 performance
Context: Identify factors affecting LCR-100 performance to improve Rockwell Collins customer satisfaction and reduce data prep effort.
Goals:
Visualize and assess LCR-100 process factors and coverage by ongoing projects
Analyze performance data from 3 lots of 10 systems for Six Sigma discussions
Evaluate Cal/ATP, FOGIMU-CAS, bias test dependencies
Test data presentation formats
Automate LCR-100 data provision
Standardize data for company-wide analysis tool

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Reduced B290 throughput time
Context: High production lead time for B-290 sensor; baseline to be set in Improve phase. Production is bottleneck.
Goal: Reduce lead time by 20%

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Cut testing and QS inspection costs
Context: €700k/year cost; analyze and find savings
Goal: Reduce costs by ~~14% (~~€100k/year)

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Minimized TO-TxRx module risk
Context: To stay competitive, cut uFORS-6U production costs by 30% via redesign. Risks of new tech/components must be minimized to avoid yield loss.
Goals:
Minimize risk; functional prototypes on first try
Estimate expected yield

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Saved effort on TFT result reporting (GB)
Context: TFT test results are fully printed but only spot-checked. LCR-100 raw data (~120 pages) electronic but still printed and scanned.
Goals:
Cut paper use by 225,000 sheets
Save 625 hours annual scanning time

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Reduced approval effort (GB)
Context: ~1400 docs/year through SAP change service; process too slow
Goal: Cut approval time from ~60 to 15 minutes

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Optimized EASA Form 1 process (GB)
Context: EASA Form 1 cert for civilian aircraft made in Access, risky due to unmaintained DBs
Goal: Streamline process and boost data security

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Automated μFORS calibration evaluation (GB)
Context: Replace manual calibration pass/fail with objective automated method suitable for other uFORS variants
Goals:
Eliminate manual evaluation
Use clear PASS criteria

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Cut change-service admin effort (GB)
Context: Reduce admin work and turnaround time for change orders in SAP; add transparency
Goal: Save 1260 hours/year (~108,000)

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Reduced PC boot times (GB)
Context: Boot times grow with PC age, hindering daily work
Goal: Cut average boot time by at least 1 minute sustainably

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

High availability for test stations (GB)
Context: Frequent test station failures due to network, server, PC; need future-proof high availability
Goal: Cut failures from 32 to 5 per year

Lean Six Sigma Project

Northrop Grumman LITEF GmbH

Reduced AHRS O&R LOOPs (GB)
Context: ~15% repairs need >2 loops before delivery; loops due to equipment errors or poor fault analysis; find loop causes and early detection methods
Goal: Reduce extra loops via better device fault analysis; based on PLK 12.02

Summary

Winning, processing, and analyzing large datasets is part of my daily work. The datasets to be analyzed were sourced from various systems, integrated into databases through ETL processes, and further processed with predictive analytics. My software focus is on Python and R. For visualization I mainly use Tableau, Qlik, and Power BI.
Summary of my experience across various BI projects:
Created interactive dashboards and reports with Power BI, Power Platform, and Power BI Embedded
Developed KPIs and trend analyses
Customized visualizations to client corporate design
Queried multiple data sources and databases in various formats
Wrote database queries with SQL and PL/SQL
Integrated GIS data into reports
Familiar with SAP R/3 and SAP S/4HANA
Excellent skills in SAP SAC
Strong experience with Azure and AWS cloud platforms
Extensive experience with the Snowflake cloud data platform
Connected Power BI with Microsoft Dynamics and SAP applications
Built data models in Snowflake
Deep knowledge of Power Query, DAX, DAX Studio, DirectQuery
Strong SQL querying skills (MS SQL, MariaDB, Snowflake SQL)
Proficient in Python and R/Shiny
Solid statistics and machine learning knowledge
Developed ETL workflows with Python, Talend, PowerShell, and R
Gathered business requirements (requirement engineering)
Expert in Microsoft SharePoint and Microsoft 365 (e.g., Excel)
MS BI technologies (MS SQL Server, SSIS, SSRS, Power BI, Visual Studio with Data Tools, Dataverse)
Strong skills in data quality and data cleansing
Experience conducting proofs of concept
Version control with Git/GitHub
Solid experience with Power BI security and access models (row-level and object-level security)
Trained staff in Power BI

Languages

German

Native

English

Intermediate

Education

Lorem ipsum dolor sit amet

Dr.-Ing. · Communications Engineering

Certifications & licenses

Lean Six Sigma ISO 9001/9100

LITEF GmbH

Lean Six Sigma Black Belt

LITEF GmbH

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Anja Ż.