Excel VBA & SAP Automation

Hi, I'm Stefan – Industrial Process Specialist & Six Sigma Green Belt

I automate the manual SAP reports, copy-paste workflows, and Excel chaos that costs your team hours every week. With 10+ years in chemical and industrial production, I build solutions that actually fit how your plant operates.

Get a Free Consultation

Scroll down

About Me

Who I Am & What I Solve
Stefan Maximilian

I'm a Process Improvement Manager and certified Six Sigma Green Belt with over 10 years of hands-on experience in chemical and industrial production environments — including Novartis, 3M Dyneon, and SI Group.

I specialise in one thing: eliminating the manual, repetitive SAP and Excel work that nobody has time to fix but everyone suffers through. I use VBA scripting, SAP GUI automation, and smart Excel design to turn hours of weekly admin into a one-click process.

My toolbox: SAP (MM, PP, PM, CO), Excel VBA, SAP GUI Scripting, Power BI, SQL, OSIsoft PI

10+ Years
experience
14+ Completed
projects
4 SAP
modules
Download CV

Skills

My technical level

Excel VBA & SAP Automation

More than 8 years

SAP GUI Scripting

Automated report extraction (MM, PP, PM, CO)

Excel VBA

Macros, automation, custom tools

SAP Data Transformation

Extract, clean, structure for reporting

SQL

Data extraction, query optimization

Power BI

KPI dashboards from SAP data

OSIsoft PI

Live process data via PI Datalink in Excel

Industrial Process Knowledge

More than 10 years

OEE & Yield Monitoring

Live tracking, loss analysis

KPI Reporting

Cost centers, production metrics

SPC Control Charts

Statistical process monitoring

Lean & Six Sigma

Green Belt certified, DMAIC

Root Cause Analysis

5-Why, Ishikawa, RCA

Plant Maintenance (PM)

Work orders, downtime tracking

SAP Modules

Hands-on in production environments

MM – Materials Management

Procurement, inventory, consumption

PP – Production Planning

Orders, scheduling, BOM

PM – Plant Maintenance

Work orders, downtime, notifications

CO – Controlling

Cost centers, internal orders

Qualification

My personal journey
Education
Work

Chemical Technician

Bavaria, Germany
2001 – 2005

Six Sigma Green Belt

Certified – Lean & DMAIC
2020

Google Data Analytics

Google Certificate
2023 – 2024

Microsoft Power BI Analyst

Microsoft Certificate
2024 – 2025

Chemical Process Operator

3M Dyneon – Germany
2005 – 2009

Industrial & Pharmaceutical Technologist (GMP)

Novartis – Basel, Switzerland
2013 – 2018

Sr. Production Coordinator & Leader Utilities

SI Group – Switzerland
2018 – 2024

Manager – Process Improvement, Global Utilities

SI Group – Global
2024 – Present

Services

What I build for you

SAP Report
Automation

View more

SAP Report
Automation

  • Fully automated SAP GUI scripting – runs reports with one click

  • Extracts data from MM, PP, PM, and CO modules automatically

  • Saves 5–15 hours of manual work per week per team

  • No SAP consultant or IT department involvement needed

Excel VBA
Workflow Tools

View more

Excel VBA
Workflow Tools

  • Custom VBA macros that replace repetitive copy-paste work

  • Dynamic reporting templates with auto-refresh and formatting

  • Error-proofed inputs and validation logic to reduce human mistakes

  • Built for how your team already works – no retraining required

SAP–Excel
Integration

View more

SAP–Excel
Integration

  • Live data bridge between SAP and your Excel reporting environment

  • Merge SAP exports with external data sources (SQL, PI, CSV)

  • Structured output ready for management reports or Power BI

  • Scheduled, consistent data flow – no manual intervention

KPI Dashboard
Development

View more

KPI Dashboard
Development

  • Excel or Power BI dashboards fed directly from SAP data

  • OEE, yield, cost center, and maintenance KPIs visualized clearly

  • Designed for shift leaders, plant managers, and controlling teams

  • Built on real production data – not generic templates

Portfolio

Real projects, real results
SAP VBA Automation

SAP GUI Scripting – Automated Production Report Extraction

VBA script that automatically pulls daily production data from SAP PP and MM, transforms it, and populates a structured Excel report — replacing 3 hours of manual work per week.

Demo
Excel Shift Planning Tool

Excel VBA – Shift Planning & Headcount Tool

Custom-built Excel tool for chemical plant shift scheduling — with dynamic capacity warnings, headcount validation, and weekly productivity views. Reduced planning time by 60%.

Demo
OEE Monitoring

OSIsoft PI + Excel – Live OEE & Yield Monitoring

Automated OEE and yield tracking using PI Datalink in Excel. Live production asset data integrated into management reports — zero manual data entry, updated every shift.

Demo
SPC Control Charts

Power BI – SPC Control Charts from SAP Data

Real-time statistical process control dashboard built on SAP-sourced quality data — with automated UCL/LCL alerts for production parameters. Used by QA and shift teams daily.

Demo
SAP CO Cost Report

SAP CO + Excel – Automated Cost Center Reporting

Monthly cost center and utility cost reporting fully automated via VBA + SAP GUI scripting. Data from CO module extracted, structured, and pushed into Excel dashboards for controlling.

Demo

Contact Me

Let's talk about your process

Call Me

+41 76 376 1864

Location

Switzerland – Remote available