Ingo Marent RIBAsys

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

  • BPMN 2.0
  • TIM Flow
  • SmartForms
  • TIBCO
  • Boomi
  • GoAnywhere MFT
  • Project management

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

  • iGrafx
  • TIM Flow
  • BPMN 2.0
  • SmartClient
  • JavaScript
  • SQL

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

  • Python
  • SQLite
  • REST
  • Microsoft Entra ID
  • SSO
  • SCIM
  • iGrafx
  • TIM Flow

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

  • Power BI
  • Power Query/M
  • Microsoft Fabric
  • Boomi
  • MFT
  • JSON
  • SQL

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

  • BPMN 2.0
  • TIM Flow
  • SQL
  • Process Mining
  • LLM-assisted methods

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

  • iGrafx
  • Azure API Management
  • Oracle REST Data Services
  • D2
  • Git
  • Azure DevOps
  • SAP Signavio (evaluation)
  • SAP Build Process Automation (evaluation)

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.

  • BPMN 2.0
  • ProcessMaker
  • JavaScript
  • PHP
  • SQL
  • AWS
  • Google Cloud
  • Jira

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.

  • Quasar Framework
  • Cordova
  • Docker
  • Git
  • Bitbucket

2015

Consultant & developer

Invoice approval process

Development of an invoice approval process and technical sales support.

  • Workflow development
  • 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.

  • ProcessMaker
  • BPMN 2.0
  • PHP
  • MySQL
  • jQuery
  • Linux

2014 – 2015

Developer & tester

Damage management software in the aviation environment

Development and testing of damage management software, plus documentation and technical support.

  • Software development
  • Testing
  • Documentation

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.

  • Project lead
  • Team leadership
  • Web development
  • User training

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.

  • PHP
  • ownCloud
  • Dolibarr
  • Git

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.