Case Study Banner

CASE STUDY

i2e helps clinical sponsor to eliminate manual handoffs with validated workflow apps

industry-iconCLIENT :Confidential
industry-iconINDUSTRY :Pharmaceutical
industry-iconDURATION :30 days
CLIENT :
Confidential
INDUSTRY :
Pharmaceutical
DURATION :
30 days

Business case

Clinical teams generate more data than ever, and much of it still moves between systems by hand. When one process finished its part, a clinical sponsor's teams relied on Excel trackers to carry the work forward: export a file, reformat it, email it to the next team, and log the update separately.

This bridge between systems, an airgap in the workflow, was slow to sustain and hard to trust. Errors were common. Updates were missed. Critical steps were not consistently traceable. Teams spent more time managing the movement of data than doing the work it was meant to support.

The sponsor needed a way to close these gaps without replacing the systems already in place.

Our Solution

  • Validated Python apps i2e built lightweight applications using Python and POSIT Workbench, delivered through POSIT Connect, to take over the manual handoff steps between systems.
  • Process-matched design Each app was built with business users and mirrored their existing process, so adoption did not require retraining or a redesign of how teams worked.
  • Direct system integration Apps took inputs, applied the sponsor's logic and formatting rules, and wrote outputs directly to the next system or data store, removing the need for exported files and separate trackers.
  • Validation for regulated use i2e validated each app so it could support real oversight in a regulated clinical environment, not stand in as an informal workaround.

Challenges overcome

  • Fragile handoffs: manual export-and-email steps between systems were slow and prone to error.
  • Missed updates: tracker-based logging depended on someone remembering to record each change.
  • Limited traceability: critical steps in the process were not consistently recorded or auditable.
  • Time lost to administration: teams spent more time managing data movement than completing the work it supported. 

Benefits

  • Removed dependence on spreadsheets and manual email handoffs between systems.
  • Gave business users interactive apps that fit directly into their existing workflow.
  • Reduced reliance on engineering support for routine process changes.

Results

Results
SPM Icon
SPM maturity calculator