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 GUI Scripting Automation

SAP GUI Scripting – Automated Multi-Site Data Extraction

VBA script that connects to SAP, lets you select sites via dropdown, hits one button — and automatically navigates transactions, extracts production data, and copies it directly into a structured Excel report. Zero manual steps.

Demo
Excel Shift Planning Tool

Excel VBA – Shift Planning & Headcount Tool

Custom-built shift scheduler for a chemical plant — dynamic capacity warnings, headcount validation, and weekly productivity views. Reduces planning time significantly.

Demo

Contact Me

Let's talk about your process

Call Me

+41 76 376 1864

Location

Switzerland – Remote available