Software Development

Professional Development for BioPharma, LIMS & Healthcare IT

25+ years of development experience in complex, regulated environments – from LIMS to Shop Floor to Healthcare IT.

My approach: Requirements Engineering + Software Development in one person – I understand what needs to be built AND how to implement it technically.

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

Principles: Clean Code, Testability, Maintainability, Documentation – especially important in regulated environments (GxP, CSV).

Why Software Development + Requirements Engineering is a Strong Combination

As a Requirements Engineer, I understand:

What needs to be built (Business Requirements, Use Cases)
Why it's being built (Business Value, Stakeholder Needs)
For whom it's being built (User Personas, Workflows)
Which constraints apply (Governance, GxP, Performance)

As a Developer, I can:

Assess technical feasibility early
Propose alternative solutions (often simpler than initially thought)
Go directly from requirement to implementation – no "telephone game" effect
Ensure traceability (Code ↔ Requirements ↔ Tests)

The Result:

Software that truly does what it should – because requirements are not only understood but also technically implemented correctly. Especially in regulated environments (LIMS, BioPharma, Healthcare IT), this end-to-end responsibility is crucial.

Core Technologies & Expertise

C# / .NET / .NET Core Primary

Experience: 2006–present (~20 years)

Versions: .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

Experience: 1997–present (~28 years)

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

Experience: 1999–present (~26 years)

T-SQL: Stored Procedures, Functions, Triggers, Views
Database Design: Normalization, Indexing, Constraints
Performance Tuning: Query Optimization, Profiling
Versions: 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 project)
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–present):

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 (since 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-compliant Development

Specialized Domains & Industry Expertise

LIMS Development

Labware LIMS (2012–present):

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):

Complete development (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

Notable:

Development in Scrum since 2008 – one of the first Healthcare IT projects with agile methodology.

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 (if relevant):

Delphi C++ Java