Power BI Data Analytics
Hi, I am Stefan – PowerBI Data Analyst & Six Sigma Green Belt
Data & Power BI Analyst with strong skills in SQL, SAP, and Excel (VBA). Experienced in process automation, KPI dashboard development, and leading operational improvements as a Six Sigma Green Belt.
Contact Me
About Me
My Story & Skills
I am a certified Data Analyst and Process Improvement Manager with over 6 years of experience optimizing processes and visualizing data for better decisions. My work includes automating SAP data workflows, developing dynamic KPI dashboards, implementing SPC control charts, and optimizing staff scheduling and resource planning.
Tools: Power BI, SQL, Excel (VBA), SAP, OSIsoft PI, Minitab
experience
project
worked
Skills
My technical levelData Analytics & Process Optimization
More than 8 yearsPower BI
Dashboards, DAX, KPI VisualizationSQL
Data extraction, query optimizationSAP ECP
Data integration, KPI extractionExcel (VBA)
Automated workflowsSPC Charts
Process monitoring, Six SigmaGreen Belt
Certified in LeanOperational Excellence
More than 6 yearsProcess Automation
Workflows, triggersYield & Output
Loss tracking, output ratesKPI Monitoring
Metrics, goalsOEE Optimization
Availability, performanceRoot Cause Analysis
5-Why, Ishikawa, RCALean & Six Sigma
Waste reduction, DMAICTeam & Project Leadership
More than 5 yearsCross-Functional Work
EMEA & US teamsProject Management
Planning, executionTeam Leadership
Coaching, ownershipCommunication
Clarity, reportsQualification
My personal journeyChemical Technician
Bavaria - GermanyCertificate of Heating
Plant Specialist
Switzerland - UTECH
Google Data Analytics
Google CertificateMicrosoft Power BI
Analyst
Microsoft Certificate
Chemical Process Operator
3M Dyneon - Germany
Industrial and Pharmaceutical
Technologist (GMP)
Novartis - Basel, Switzerland
Sr. Production Coordinator &
Leader Utilities
SI Group - Switzerland
Manager - Process Improvement,
Global Utilities
SI Group - Global
Services
What I offer
Power BI
Consulting
OEE & Yield
Optimization
SAP Data
Automation
Shift Planning
Tool
Portfolio
Most recent work
Power BI – SPC Control Charts
Real-time statistical process control dashboard with automated alerts and Upper/Lower control limits for key quality parameters.
Demo
Excel – Shift Planning Tool
Custom-built Excel tool for shift scheduling and headcount planning with dynamic bottleneck warnings and weekly productivity views.
Demo
OSIsoft PI – Yield & OEE Monitoring
Automated Yield and OEE tracking using PI Datalink in Excel. Live data from production assets integrated into management reports.
Demo
Power BI – Utility Cost Dashboard (Steam, Electricity, Water)
Interactive dashboard for visualizing utility consumption and costs across multiple sites, with forecasting and KPI benchmarking.
Demo
SAP Automation – VBA-Driven Data Extraction
Automated extraction and structuring of SAP data (e.g. cost centers, consumption, downtime) for seamless Excel-based reporting.
Demo