P.S. - Software Development

Case Examples

Projects with clear operational impact

The project cards include technical detail sections, stack references, and linked deep dives for more concrete engineering context.

Selected Projects

Full project overview

Signalwerk: Integration Operations on a Long-Grown Stack

Evolution of a production integration environment using PHP/MySQL, Lobster Data, Python/SQL, and containerized operational workflows.

Starting point Long-grown processes with strong dependence on manual routines, inconsistent data contracts, and reactive incident handling.

Technical approach Stack-coherent evolution instead of full replacement: retain the PHP/MySQL core, structure integration logic in Lobster Data, standardize data pre-processing with Python/SQL, and stabilize execution through containerized workflows.

Operational effect Interfaces became more stable, failures became faster to classify, and recurring operational tasks became more predictable.

Why it matters Signalwerk demonstrates how a legacy-adjacent stack can be modernized professionally without destabilizing critical live processes.

Technical Details

PHPMySQLLobster DataPythonSQLDocker

Operationally stable evolution based on explicit validation logic, separated error classes, and containerized execution boundaries.

Integration stability significantly stronger trend from explicit validation, clear error classes, and standardized handovers

Operational effort fewer reactive interventions day-to-day relief through repeatable routines instead of ad-hoc manual work

ERP Integration via Lobster Data

B2B integration flows between ERP, partner interfaces, and downstream data processes.

Starting point Heterogeneous source formats, conflicting required-field logic, and inconsistent semantics across systems.

Technical approach Explicit mapping contracts, validation-before-processing, clear error classes, and reproducible routing paths.

Operational effect Failures became easier to classify early, rework became easier to prioritize, and functional clarifications got faster.

Why it matters The integration flow stayed controllable under change instead of escalating on each format deviation.

Technical Details

Lobster DataREST APIJSON MappingValidationMonitoring

Whitelist-driven routing with fail-closed defaults and strict separation between test and production callback paths.

Manual rework noticeably reduced operational observation, not a published client KPI

Failure triage time shorter cycles trend after clearer error classes and structured logs

Data Processing for Downstream Systems

Python- and SQL-based normalization for reliable handover to downstream systems.

Starting point Downstream flows were affected by mixed formats, unclear field conventions, and inconsistent data quality.

Technical approach Deterministic transformation chains with checks for required fields, data types, duplicates, and business plausibility.

Operational effect Correction loops moved from live operations into a controlled pre-processing stage.

Why it matters Dependent systems received more reliable inputs and were less disrupted by outliers.

Technical Details

PythonSQLData ValidationBatch Processing

Layered pre-validation model with explicit record states before downstream processing is triggered.

Data quality more stable input baseline observed impact in downstream operations without disclosing internal KPI figures

Operational effort fewer ad-hoc corrections trend-level assessment from day-to-day operation

Automation of Repetitive Operational Tasks

Standardized script operations for repetitive tasks with clear rollback paths.

Starting point Manual routines were person-dependent, time-critical, and error-prone in peak situations.

Technical approach Containerized execution, versioned configuration, and fixed execution windows with traceable logging.

Operational effect Recurring tasks ran more consistently and remained stable across staffing changes.

Why it matters Less operational time went into routine handling, more into targeted improvements.

Technical Details

PythonDockerGitLinuxMonitoring

Repeatable job execution with explicit rollback paths and standardized diagnostics for faster incident handling.

Execution stability higher and repeatable based on standardized runs instead of manual variance

Planning reliability clearer execution windows operational estimate from recurring workload

Monitoring and Interface Incident Analysis

Monitoring model with technical signals, process indicators, and structured escalation paths.

Starting point Incidents often became visible only after business impact, with reactive and lengthy diagnosis loops.

Technical approach Unified log correlation, prioritized alerts, and separation of transport, validation, and process failures.

Operational effect Incident triage became reproducible and handovers between operations and business teams improved.

Why it matters Incident handling remained structured even under sustained load.

Technical Details

Log CorrelationAlertingError ClassesProcess Monitoring

Early-warning indicators and prioritized escalation paths combine technical telemetry with process impact.

Response readiness earlier drift detection through process-level signals in addition to technical errors

Escalation noise lower fewer ambiguous escalations after alert prioritization

Additional Project Experience

Operationally Stable Mapping Flows with Lobster Data

2025 - ongoing

Rule-based data flows with clear error classes and traceable correction paths.

Data Migration During System Transition

2024 - 2025

Legacy data cleanup and reliable mapping into the target system.

Standardized Import and Export Pipelines

Ongoing operational task

Unified file standards with pre-processing validation gates.

Self-hosted Server Infrastructure

2025 - ongoing

Containerized services, reverse proxy, and automated backups.

Central Device Management System

Personal project since 2024

Custom-built MDM solution for heterogeneous device environments.

Modernization of a Long-Grown Web Application

2024 - ongoing

Structured evolution of a PHP/MySQL system that had grown over many years.

Interactive Real-Time Map View

2025

Leaflet-based live map display with automatic refresh.

Client names and internal metrics are intentionally omitted due to confidentiality constraints. On request, I can share anonymized flow examples and architecture sketches to discuss the technical approach.

Planning a similar initiative? A short project outline by email is enough for an initial technical assessment. Get in touch