Software Development

Professional Development für BioPharma, LIMS & Healthcare IT

25+ Jahre Entwicklungserfahrung in komplexen, regulierten Umgebungen – von LIMS über Shop Floor bis Healthcare IT.

Mein Ansatz: Requirements Engineering + Software Development in einer Person – ich verstehe, was gebaut werden soll, UND wie man es technisch umsetzt.

Core Stack: C#/.NET Core, ASP.NET, Oracle, MSSQL, Azure Cloud, REST APIs, Microservices.

Prinzipien: Clean Code, Testbarkeit, Wartbarkeit, Dokumentation – besonders wichtig in regulierten Umgebungen (GxP, CSV).

Warum Software Development + Requirements Engineering eine starke Kombination ist

Als Requirements Engineer verstehe ich:

Was gebaut werden soll (Business Requirements, Use Cases)
Warum es gebaut wird (Business Value, Stakeholder Needs)
Für wen es gebaut wird (User Personas, Workflows)
Welche Constraints gelten (Governance, GxP, Performance)

Als Developer kann ich:

Technische Machbarkeit früh bewerten
Alternative Lösungen vorschlagen (oft einfacher als initial gedacht)
Direkt von Requirement zu Implementation gehen – kein "Stille Post"-Effekt
Traceability sicherstellen (Code ↔ Requirements ↔ Tests)

Das Ergebnis:

Software, die wirklich tut, was sie soll – weil Anforderungen nicht nur verstanden, sondern auch technisch korrekt umgesetzt werden. Besonders in regulierten Umgebungen (LIMS, BioPharma, Healthcare IT) ist diese End-to-End-Verantwortung entscheidend.

Core Technologies & Expertise

C# / .NET / .NET Core Primary

Erfahrung: 2006–heute (~20 Jahre)

Versionen: .NET 1.0 → .NET Framework 4.7.2 → .NET Core 2.1–8.0

Backend Development:

ASP.NET Core: REST APIs, Web Services, Middleware
Microservices: Azure Functions, Background Services
Windows Services: .NET Core Worker Services
Integration Services: File Processing, Data Transformation, ETL
Real-time Processing: SignalR, WebSockets

Frontend/UI:

Blazor: Server & WebAssembly
Razor Pages: Server-side rendering
WPF/WinForms: Desktop applications (legacy)

Tools & Frameworks:

Entity Framework Core, Dapper (ORM)
AutoMapper, FluentValidation
Serilog, NLog (Logging)
Polly (Resilience & fault-handling)

Databases Expert

Oracle Database

Erfahrung: 1997–heute (~28 Jahre)

PL/SQL: Stored Procedures, Functions, Packages, Triggers
Advanced SQL: Analytical Functions, CTEs, XMLTABLE, JSON_TABLE
Performance: Execution Plans, Indexing, Partitioning
Integration: Database Links, External Tables, Java Bindings

Microsoft SQL Server

Erfahrung: 1999–heute (~26 Jahre)

T-SQL: Stored Procedures, Functions, Triggers, Views
Database Design: Normalization, Indexing, Constraints
Performance Tuning: Query Optimization, Profiling
Versionen: SQL Server 7.0 → 2019

ORM & Data Access:

Entity Framework Core
Dapper (Micro-ORM)
ADO.NET (low-level, performance-critical scenarios)

Cloud & DevOps Azure

Azure Services:

Azure IoT Hub: Device-to-Cloud messaging (QIAGEN-Projekt)
Azure Event Hub: High-throughput event streaming
Azure Functions: Serverless Microservices
Azure Blob Storage: File storage, Data Lake
Azure SQL Database: Managed MSSQL

DevOps & CI/CD:

Git: Version Control, Branching Strategies, Code Review
GitHub: Repositories, Actions (CI/CD), Pull Requests
Azure DevOps: Pipelines, Artifacts, Work Items
Docker: Containerization, Docker Compose

Deployment & Automation:

PowerShell Scripting (Automation, Deployment)
Azure CLI, ARM Templates
Continuous Integration / Continuous Deployment

Web Technologies & JavaScript Node.js

Node.js (2014–heute):

Backend: Express.js, REST APIs, Authentication (Passport.js)
Reporting: HTML Report Generator (Custom Framework)
Integration: Oracle DB (node-oracledb), File Processing
Document Generation: Microsoft Word DOCX Generator

Frontend Libraries:

jQuery / jQuery UI: DOM Manipulation, AJAX
Bootstrap: Responsive UI
DataTables: Interactive tables
D3.js, Plotly: Data Visualization
FancyTree: Hierarchical data

Oracle APEX (2016–2020):

Low-Code Web Application Development
Custom JavaScript Integrations (D3.js, AnyChart, Oracle JET)
PL/SQL Backend, REST Services

Development Principles & Best Practices

Clean Code

SOLID Principles
DRY (Don't Repeat Yourself)
KISS (Keep It Simple, Stupid)
Readable, self-documenting code
Meaningful naming conventions

Testing & Quality

Unit Testing (NUnit, xUnit)
Integration Testing
Test-Driven Development (TDD)
Code Coverage (>80%)
Mocking (Moq, Typemock)

Documentation

Technical Specifications
API Documentation (Swagger/OpenAPI)
Code Comments (XML Documentation)
README, Architecture Docs
User Manuals, SOPs

Agile Development

Scrum Framework (seit 2008)
Iterative Development
Sprint Planning & Reviews
Continuous Feedback
Retrospectives

Version Control

Git Workflows (Feature Branches)
Pull Requests & Code Review
Branching Strategies (GitFlow)
Merge Conflict Resolution
Release Management

Security & Compliance

Input Validation & Sanitization
Authentication & Authorization
Encryption (Data at Rest & in Transit)
OWASP Top 10
GxP-konforme Development

Specialized Domains & Industry Expertise

LIMS Development

Labware LIMS (2012–heute):

LIMS Basic: Custom development, frameworks
Instrument Integration: AMBR, TECAN, Siemens BGA
Migration: v6 → v7
Reporting: HTML Reports, Crystal Reports, Labels
Modules: Visual Workflows, Project Manager, Plate Manager

Custom LIMS (PAuLa 2002–2015):

Komplett-Entwicklung (Delphi, MSSQL)
ERP-Integration (Navision)
Synthesizer, HPLC, QC-Workflows

BioPharma & Shop Floor

QIAGEN (2020–2023):

IPC Data Acquisition: Azure IoT Hub, Event Hub
Real-time Processing: Shop Floor → Cloud
Integration: Mettler-Toledo LabX, B&P Label Printing
PowerShell: API Walker, Data Transformation

Process Science:

Fermentation, Upstream/Downstream
Data Visualization (D3.js, Plotly)
Capacity Planning (Oracle APEX)

Healthcare IT

MCC.NET (2006–2011):

HIS/KIS Development: C#, WinForms, SQL Server
PACS Integration: Visus
Archiving: d.velop D.3
Dictation Systems: Philips SpeechMagic, 4voice, Dictanet
Requirements Module: Lab, Radiology
FAP/RIS: Functional Workplace

Besonderheit:

Entwicklung in Scrum seit 2008 – einer der ersten Healthcare IT Projekte mit agiler Methodik.

Technology Stack

Languages:

C# SQL PL/SQL T-SQL JavaScript PowerShell HTML/CSS

Frameworks:

.NET Core ASP.NET Core Entity Framework Node.js Express.js Blazor

Databases:

Oracle SQL Server Azure SQL

Cloud & Tools:

Azure Docker Git GitHub Visual Studio

Testing:

NUnit xUnit Moq Typemock

Design Patterns:

Repository Unit of Work Factory Strategy Dependency Injection

LIMS Platforms:

Labware LIMS Oracle APEX Custom LIMS

Legacy (falls relevant):

Delphi C++ Java