Projects & case studies
Projects
Six case studies from enterprise automation in life sciences – with situation, my contribution, approach, outcome and actual status. Plus earlier projects since 2013.
The six case studies come from my work since late 2021 for an internationally operating life sciences company. The client remains unnamed, internal designations are generalised, and no confidential configurations or system details appear here.
I deliberately do not publish figures here. I am happy to explain in conversation what can be said within the bounds of confidentiality. Projects from the years before are listed under Earlier projects.
How to read the status
Each project is labelled as it actually stands – a technical investigation is not a completed roll-out.
In production
Ongoing development
Prototype / trial
Evaluation / proof of concept
Architecture concept
Role: project management
Automating the configuration of clinical study data flows
Project management of an automation project in data exchange with external contract research organisations – including the migration to new platforms.
Situation
In the clinical study environment, the company exchanges data with various external contract research organisations (CROs). Each of these data flows has to be configured – a task that involves several departments.
My contribution
Project management: steering the project, coordinating the departments involved and the project documentation – from the first solution through to the migration to the successor platforms.
Approach
- Configuration procedure modelled as a process in BPMN 2.0 and automated as a workflow
- SmartForms for the details required to configure a data flow
- Implementation initially in conjunction with TIBCO as the integration platform
- Later migration to Boomi and GoAnywhere MFT
- Coordination of the departments involved throughout the project
- End-to-end project documentation
Outcome
The configuration of study data flows runs in an automated way via a modelled workflow with forms. The solution was migrated from the original integration platform to the successor platforms.
Status
- Automation of the configuration: implemented, initially with TIBCO
- Migration to Boomi and GoAnywhere MFT: completed
Technologies
In production
Ongoing development
Workflow platform for regulated business processes
Development, extension and technical support of an enterprise-wide process automation platform.
Situation
The company controls cross-departmental workflows – including in supply chain, master data management and clinical operations – via a central BPM and workflow platform. The business units need forms, task views and notifications that go beyond the standard scope.
My contribution
Technical owner of custom-built solutions around the platform: development and support of workflows, SmartForms and automation logic, troubleshooting during platform updates, and coordination with business units, IT and the software vendor.
Approach
- SmartClient SmartForms for production workflows, including dynamic forms and tabular data views
- Role-based cockpits, task views, dashboards and widgets with dynamic SQL logic
- A purpose-built editor for task notifications with BPMN preview and variable substitution
- BPMN extensions and multi-instance modelling
- SQL analyses for permission audits and process hierarchies
Outcome
The SmartForms run in production workflows. Cockpits, the notification editor and BPMN extensions add capabilities to the platform that the standard does not cover.
Status
- Workflows and SmartForms: in production
- Editor, cockpits and extensions: custom-built, under ongoing development
Technologies
Ongoing development
Synchronising users, roles and licences traceably
A rule-based synchronisation engine and a purpose-built licence management application.
Situation
Users, groups and roles have to match between the role and responsibility management, the workflow engine and the process platform. In a regulated environment it must also be possible to evidence which change was made when and according to which rule.
My contribution
Design and development of the synchronisation engine in Python, including a purpose-built API client for the process platform; development and ongoing enhancement of the licence management application.
Approach
- Rule-based reconciliation between responsibility management, workflow engine and process platform
- Three-stage flow plan → execute → verify: changes are planned first, then executed and subsequently verified
- An audit log in SQLite that records every step
- Interplay with Microsoft Entra ID, SSO, SCIM and central provisioning and permission services
Outcome
Reconciliations follow fixed rules, and every planned, executed and verified change is traceable in the audit log. Licences are managed via a dedicated application.
Status
- Licence management: custom-built, under ongoing development
- Synchronisation engine: custom-built
Technologies
Ongoing development
Architecture concept
Making clinical study data flows visible
Dashboards, change detection and a monitoring architecture in the interface environment.
Situation
In the clinical study environment, data is exchanged with partners via integration and file transfer platforms. Business and IT need transparency: where is a file, what has changed in partner configurations, and which business decisions were taken in that regard?
My contribution
Modelling of the data flow, development of the dashboards and the preparation logic, and design of the architecture for end-to-end file tracking.
Approach
- Data flow dashboards in Power BI with extensive Power Query/M logic
- Detection of changes to partner configurations by comparing JSON configurations
- Tracking of business decisions
- Data preparation and monitoring in bronze, silver and gold layers
- Architecture for file journey monitoring across integration platform and data platform
Outcome
Dashboards and preparation logic make data flows and configuration changes visible. An architecture is in place for end-to-end file tracking.
Status
- Dashboards and data preparation: build-up and enhancement
- File journey monitoring: architecture concept
Technologies
Ongoing development
Prototype / trial
Process mining on workflow execution data
A purpose-built analysis tool that shows how processes actually run – directly in the process model.
Situation
The workflow engine generates execution data on pharma sourcing and activation processes. The model shows the intended flow; how the processes are actually executed is contained in the runtime data.
My contribution
Design and development of the process mining tool, a BPMN viewer and automated layout methods.
Approach
- Variant, hierarchy and optimisation views across a multi-level sub-process hierarchy
- BPMN viewer with execution overlays
- Derivation of gateway behaviour from runtime data
- Automated BPMN layout methods with metrics for assessing model quality
- Trials of LLM-assisted optimisation
Outcome
Execution data can be read directly on the process model: variants and actual branching behaviour become visible and provide starting points for optimisation.
Status
- Process mining tool and BPMN viewer: custom-built
- Layout methods: development and trials
- LLM-assisted optimisation: trial
Technologies
In production
Evaluation / proof of concept
Architecture concept
Architecture, operations and platform modernisation
Controlled changes in operations, documented architecture and a sound assessment of possible target platforms.
Situation
A BPM landscape that has grown over time raises three questions at once: how do changes reach production in a controlled way? How is the architecture documented? And which platform will meet the requirements in future?
My contribution
Release support, troubleshooting and testing in live operations; architecture documentation; deployment concept; technical evaluation of alternative platforms; a strategy paper on connecting strategic BPM platforms with executable workflow systems.
Approach
- Releases, troubleshooting, testing and controlled changes across DEV, ACC and PROD
- Architecture documentation as diagrams-as-code around the process platform, database interfaces and API management
- Deployment concept with Git, Azure DevOps and automated delivery
- Technical evaluation of SAP Signavio and SAP Build Process Automation: migration capability, SSO, provisioning, permissions and model history
- Reference model of an integrated BPM system with audit readiness and GxP validatability as areas of consideration
Outcome
A documented architecture, a deployment concept and a technical assessment of possible target platforms as a basis for decision-making.
Status
- Release support and production support: live operations
- SAP Signavio and SAP Build Process Automation: evaluation / proof of concept
- Deployment automation and reference model: concept
Technologies
Earlier projects
Assignments before 2021
BPM, software and web projects, including in automotive, telecommunications and aviation. I refer to clients by industry here; details gladly in conversation.
2016 – 2020
Senior BPM Architect
BPM development and platform migration for an international automotive supplier
A multi-year BPM development project including a ProcessMaker migration – international in scope, with national subsidiaries in Europe, the USA and Asia.
2019 – 2020
Product owner
Cross-platform app for iOS, Android and Windows
Product owner for the relaunch of an application as a cross-platform app based on the Quasar Framework.
2015
Consultant & developer
Invoice approval process
Development of an invoice approval process and technical sales support.
2014
Developer
Around 30 workflows for the e-commerce support of a telecommunications company
Development of around 30 processes on ProcessMaker to support e-commerce support operations.
2014 – 2015
Developer & tester
Damage management software in the aviation environment
Development and testing of damage management software, plus documentation and technical support.
2013 – 2015
Project lead
Relaunch of several company websites
Project lead for the redesign of three websites, including for a supplier of measuring tools and a career consultancy: leading a team of developers, graphic designers and copywriters, user training and continuous enhancement.
2013 – 2015
Developer & consultant
Open-source business applications and e-commerce
Development of a cloud solution based on ownCloud and a CRM/ERP solution based on Dolibarr; shop configuration for an online retailer and translation of an online shop into six languages.
Let’s talk about your project.
A few keywords on the assignment, environment and time frame are enough. I will get back to you with an honest assessment of whether and how I can help.