Case study · Life sciences

From spreadsheets to an auditable pharmacovigilance signal platform

A drug safety team tracked potential signals across spreadsheets, email and slide decks. Each evaluation meant a bespoke data request and weeks of analysis. The goal was one platform that detects candidate signals, keeps the reasoning auditable and lets the team test them quickly against real-world data.

Case studyLife sciences · Drug safetySumanta Mukhopadhyay9 min read
#healthcare#omop#data#governance
CASE STUDY · CASE STUDY · LIFE SCIENCES28 Oct 2026 · 12:50 GST
At a glance
SectorLife sciences · Drug safety
My rolePrincipal data architect
EngagementArchitecture, build and validation
ScopeCase intake, disproportionality screening, signal tracking, RWD evaluation
What changed
  • One tracked record per signal, from detection to decision, with an audit trail
  • Candidate signals screened consistently on a regular schedule
  • Real-world data evaluations run from reusable study packages
  • Clear separation between signal detection, evaluation and decision
Safety database extractsMedDRA-coded eventsDisproportionality analysisOMOP CDMOHDSI HADESSignal trackerWorkflow engineAudit trail

Anonymised composite. Client names, identifying details and confidential figures are withheld; public facts are cited in the references.

The situation

A pharmaceutical company's drug safety team handled case processing well; their safety database and regulatory reporting were mature. Signal management was not. Potential signals arrived from periodic report reviews, literature, partners and occasional regulator queries, and were tracked in a spreadsheet. Evaluating one meant a custom data request, an analyst working for weeks, and conclusions summarised in slides that did not record which data or method they came from.

The head of safety wanted three things: consistent screening, faster evaluation and a record any inspector could follow from first observation to final decision.

What had to be true

  • Every signal has one record, from source to decision, with who did what and why.
  • Screening is consistent: the same methods on the same schedule, not ad hoc queries.
  • Detection is not confused with evidence. Report counts start investigations; they don't conclude them.
  • Evaluation is fast and reproducible, using standardised real-world data and versioned study code.
  • Validated where it matters, with the computerised system controls a regulated safety function expects.

The EU's good pharmacovigilance practice guidance on signal management frames the lifecycle the platform needed to support, and EMA presentations on it emphasise that marketing authorisation holders should keep an audit trail of their signal management activities1.

Architecture

Sources
Safety databaseindividual case reportsPublic reportse.g. FAERSLiteraturescreened articlesReal-world dataclaims and EHR
Standardise
Coded eventsMedDRA termsProduct mappingingredients, brandsOMOP CDMRWD partners
Detect
Disproportionality screenscheduled runsChange detectionnew or rising pairsLiterature triageflagged articles
Manage
Signal trackerone record per signalWorkflowvalidate, prioritise, assessAudit trailevery action and version
Evaluate
Study packagesHADES, versionedDiagnosticsnegative controlsAssessment reportlinked to data and code
Detection, management and evaluation are separate layers, so a statistical flag never becomes a conclusion by accident.

The data flow, end to end

  1. IngestCase extracts, public reports and literature flags loaded on schedule
  2. ScreenDisproportionality and change detection for product and event pairs
  3. ValidateSafety physician reviews cases behind each flag and opens or closes a signal
  4. PrioritiseSeriousness, novelty and public health impact recorded with reasons
  5. EvaluateStudy package run on OMOP data with diagnostics
  6. DecideAssessment and action recorded, linked to the evidence used
Each step leaves a record, so the path from first flag to final decision can be replayed.

The hard part: not over-reading spontaneous reports

Spontaneous reports are the backbone of signal detection and also easy to misuse. The FDA states plainly that a report does not mean the product caused the event, that report counts cannot establish how often an event occurs, and that reports can be duplicated, incomplete or stimulated by publicity2. The platform's design reflected that:

  • Disproportionality scores were labelled as screening statistics, never as risk estimates, everywhere they appeared.
  • Every flag required case-level review by a safety physician before becoming a validated signal.
  • Evaluation used designed studies on population data, not more report counting.

For evaluation, self-controlled designs suited many acute safety questions because they compare time periods within the same people, removing confounding by stable characteristics3. Negative control outcomes and empirical calibration showed whether residual bias could explain a result4. The designs are compared in real-world evidence study designs.

A signal platform's most important feature is the line it draws between "worth investigating" and "evidence of harm". Blur that line and you get both false alarms and false reassurance.

How it ran

Safety physicians
  1. Define screening scope
  2. Validate and assess signals
  3. Record decisions
Epidemiology
  1. Design study templates
  2. Run evaluations on OMOP
  3. Interpret diagnostics
Data platform
  1. Ingest and standardise
  2. Scheduled screening
  3. Validation and audit
Clinical judgement stays with safety physicians; the platform makes their work faster and traceable.
Phase 1Tracker
  • One record per signal
  • Workflow and audit
  • Migrate open signals
Phase 2Screening
  • Scheduled disproportionality
  • Change detection
  • Review queues
Phase 3Evaluation
  • OMOP data partners
  • Study templates
  • Negative controls
Phase 4Validate
  • System validation
  • SOP updates
  • Inspection readiness
The tracker came first because it fixed the audit problem immediately, before any new analytics existed.

Key decisions and trade-offs

DecisionAlternativeWhy
Tracker before analyticsStart with detection algorithmsAudit trail and consistency were the biggest gaps
Physician validation of every flagAuto-open signals above a thresholdScreening statistics are not evidence of harm
OMOP for evaluation dataBespoke extracts per questionReusable study packages across data partners
Negative controls by defaultReport estimates aloneShows when bias could explain a result
Separate detection and evaluation layersOne combined risk scoreKeeps the reasoning legible to inspectors

What I'd do again, and differently

Again: fix the record-keeping first, then add analytics. Differently: agree data access with real-world data partners at the start. Contracts and governance for external data take longer than building the screening pipeline, and evaluations wait on them. The data side is described in federated health analytics and OMOP data quality checks.

If your safety, evidence or medical teams need a platform like this, the healthcare data architecture page describes how I approach it, or analyse your challenge and bring the result to a call.

References
  1. 1
  2. 2
  3. 3
  4. 4
FAQ

Common questions

What is a safety signal?

Information suggesting a new potentially causal association, or a new aspect of a known association, between a medicine and an event, that warrants further investigation. Signal management covers detecting, validating, analysing, prioritising and assessing those signals.

Can spontaneous reports show how often an adverse event happens?

No. The FDA notes that counts of reports in FAERS do not establish how often an event occurs and that a report does not mean the product caused the event. Spontaneous reports are for detection; incidence and causality need other data and designs.

How does real-world data help evaluate a signal?

Standardised data such as OMOP lets teams run designed studies, for example self-controlled designs for acute events, with diagnostics and negative controls, to see whether a signal holds up in a population.

Keep reading

Related

Open to advisory, fractional CTO & select builds

Let's talk about what you're building.

The fastest route is a free 30-minute call. Prefer to write? Send a message and I'll reply personally within two business days.

Start a conversation

How would you like to reach me?

Book a 30-min callFastest. Pick any open slot on my calendar.→ Write in GmailOpens a pre-filled draft in your browser.→ Use my email appOutlook, Apple Mail or your default client.→

I reply personally within two business days. Time zones from the Americas and Europe to the Middle East and Asia-Pacific.