Hi, I am Stefan

Data Automation Expert

Data Analyst with strong skills in SAP, Excel (VBA), SQL, and R. Experienced in automating processes, KPI tracking, and staff scheduling.

Contact Me
Scroll down

About Me

My introduction
about-me

Certified Data Analyst with expertise in SAP, Excel (VBA), SQL, R. Experienced in automating SAP data extraction and integration, for efficient analysis. Skilled in workflow automation, KPI & OEE tracking, and staff scheduling. PI OSIsoft Consultant

06+ Years
experience
09+ Completed
project
04+ Companies
worked
Download CV

Skills

My technical level

Data Analytics & Process Optimization

More than 6 years

SAP

85%

SQL

75%

Excel (Advanced VBA)

90%

R

65%

Industrial & Automation Tools

More than 5 years

Process Automation

80%

Data-Driven Decision Making

70%

Efficiency Optimization

75%

KPI & OEE

85%

Programming & Web Development

More than 2 years

Python

30%

JavaScript

25%

HTML & CSS

45%

Qualification

My personal journey
Education
Work

Chemical Technician

Bavaria - Germany
2001 - 2005

SAP Production &
SupplyChain

3M Dyneon
2007-2008

Certificate of Heating
Plant Specialist

Switzerland - UTECH
2021 - 2022

Data Analyst

Google Certificate - Coursera
2024 - 2025

Chemical Process Operator

3M Dyneon - Germany
2005 - 2009

Industrial and 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 offer

Web
Development

View more

Web
Development

  • Custom website development using modern technologies

  • Responsive design implementation for all devices

  • Integration of interactive features and animations

  • Performance optimization and SEO implementation

KPI & OEE
Designer

View more

KPI & OEE
Designer

  • Develop advanced KPI & OEE Dashboards

  • MVAR, Consumption and Yield Tracking

  • OSIsoft PI & MS Excel Consulting

  • Digital SPC Control Charts

Workflow
Management

View more

Workflow
Management

  • Automated data extraction for goods movement (SAP / VBA)

  • Automate SAP procurement process via dynamic VBA prompts (BAMF)

  • Developing tools to streamline inventories, ensuring effortless and fully KPMG/PwC-verified processes.

  • CAPEX and project status list

Workforce
Allocator

View more

Workforce
Allocator

  • Track employee assignments to jobs and workstations

  • Calculate shift allowances for weekends, night shifts, and Sundays

  • Manage vacation, flex time, and overtime balances

  • KPI Dashboards for all departments, teams, and employees

Portfolio

Most recent work

Dynamic SAP Queries via VBA

Developed dynamic SAP queries in Excel using VBA, enabling flexible inputs via cell references. This system automates SAP-Excel data exchange, streamlining transactions and minimizing manual input for improved efficiency.

Demo

Dynamic SPC Chart Integration

Created a dynamic SPC control chart in Excel with SQL integration, automatically pulling and filtering relevant data. A VBA macro enables seamless switching between product families, offering comprehensive analysis for commando-room and shift leader offices.

Demo

Dynamic Shift & Resource Tool

Developed a dynamic Excel-based shift and resource planning tool with real-time data integration and automated scheduling. It optimizes resource allocation, minimizes conflicts, and enhances workforce efficiency with automated updates and visual tracking.

Demo

Contact Me

Get in touch

Call Me

+41 76 376 1864

Location

Basel - Switzerland