Case Study Banner

CASE STUDY

i2e helps pharma sponsor to replace Excel tracking with real-time API integrations

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

Business case

A pharma sponsor already had the systems it needed. A ticket system tracked work, a separate system handled data requests, and other tools managed who was doing what. What it lacked was a way to keep them aligned without extra effort.

Closing that gap meant a layer of work that added no value: exporting data into Excel trackers, building status reports, following up manually just to see where something stood.

CluePoints followed the same pattern. Getting signal and action data out of the system depended on someone remembering to run a Python script and share the result. When that step was missed, so was the visibility.

Our Solution

  • CluePoints integration i2e automated the pull of signal and action data directly into the sponsor's data lake, giving teams real-time access without a manual script or a shared file.
  • Ticket system integration i2e connected the ticketing system directly to the data lake, so users could request data from within a ticket and receive an automatic update once it was ready.
  • Direct flow by design Both integrations replaced email handoffs and duplicate files with a direct connection between existing systems, without introducing a new platform.

Challenges overcome

  • Disconnected systems: ticketing, data requests, and resourcing lived in separate tools with no link between them.
  • Manual, dependent processes: CluePoints reporting relied on someone remembering to run a script and share it by hand.
  • Non-value-added work: Excel reports, status updates, and manual follow-ups consumed time without moving the work forward.
  • Delayed visibility: teams often did not know where something stood until someone chased an update. 

Benefits

  • Retired the Excel trackers used to bridge systems.
  • Gave teams real-time visibility into signal, action, and ticket status.
  • Removed manual scripts and file sharing from the CluePoints workflow.
  • Freed teams to focus on the work itself rather than chasing status updates. 

Results

Results
SPM Icon
SPM maturity calculator