Small and mid-sized biotechs run much of their discovery through contract partners. Chemistry may happen at one CRO, biochemical profiling at a second, ADME and pharmacokinetics at a third and in vivo pharmacology at a fourth. Each partner returns results in its own format and often with its own compound identifiers. Before the project team can decide what to make next, someone has to collect the files, match the compounds, check the numbers and assemble a view of the series.
That someone is often a medicinal chemist or a project leader doing data work on a Friday afternoon. In an outsourced program this handoff sets the pace of the design, make, test, analyze loop more than any single experiment does, and it suits AI well because the work is structured and easy to check.
Productivity pressure makes cycle time worth chasing
Scannell and colleagues described the long decline in R&D efficiency in Nature Reviews Drug Discovery in 2012. The number of new drugs approved per billion dollars of inflation-adjusted R&D spending had halved roughly every nine years since 1950, a trend they called Eroom's law, Moore's law spelled backwards. The causes are many and mostly scientific, but cycle time is one of the few levers a program team controls directly. Every day a result sits in an inbox is a day the next round of synthesis waits.
What the reconciliation work involves
The first task is identity. A partner may report results against its own sample number, the sponsor's compound ID with a batch suffix, or a structure drawn with a different salt form. Matching each result to the right parent compound and batch in the sponsor's registry is tedious and error-prone by hand, and a single mismatch can attach potency to the wrong molecule. Structure-based matching combined with a check against the shipment manifest resolves most cases automatically and sends the rest to a person.
Standardization comes next. Units, assay names, curve-fit outputs and qualifiers such as greater-than values need to land in the same schema whoever produced them, with the protocol conditions attached. After that comes checking, so that values outside the tested range, controls that drifted from their historical values and replicates that disagree are flagged before they reach the project dashboard.
- 01CollectGather partner deliveries automatically.
- Shared inbox watcher
- Partner portals and SFTP
- Shipment manifests
- 02ReconcileMatch every result to the right compound and batch.
- Structure-based matching
- Registry lookup
- Exception queue
- 03StandardizePut all partners on one schema.
- Unit and qualifier rules
- Assay vocabulary
- Protocol conditions
- 04CheckFlag suspect values before anyone relies on them.
- Control drift checks
- Replicate agreement
- Range checks
- 05AnalyzePrepare the project meeting material.
- Results warehouse
- Weekly SAR draft
- Links to source data
- Unmatched compounds never load silently
- Every number traces to a partner file
- Scientists approve each weekly summary
| Capability | Azure | AWS | Google Cloud |
|---|---|---|---|
| Results warehouse | Azure Database for PostgreSQL | Amazon RDS for PostgreSQL | Cloud SQL for PostgreSQL |
| File intake | Azure Blob Storage | Amazon S3 | Cloud Storage |
| Orchestration | Azure Functions | AWS Lambda | Cloud Run functions |
| Language model | Azure OpenAI | Amazon Bedrock | Vertex AI |
From clean data to a weekly analysis
Once results are reconciled, an agent can prepare the material a project meeting needs. That might be a table of new compounds against the target product profile, a note on which analogs lost cell potency relative to enzyme potency, or a list of compounds whose selectivity changed after a small structural edit. The agent drafts and the scientists edit, and every statement links back to the underlying measurements so nobody has to take a summary on faith.
The same layer improves the working relationship with partners. When a CRO knows its results load automatically against a clear schema, it can deliver in that format from the start, and arguments about which sample was which become rare. A structured results file is also a reasonable thing to write into the next partner contract.
Where the limits are
Reconciliation depends on good registry data at the sponsor, and many young companies keep their compound records in spreadsheets, so cleaning that up belongs inside the project scope. Partners also change formats without notice, which means the extraction step needs monitoring and a quick way for a person to correct a mapping. Interpretation remains a scientific task. The agent can point out that potency dropped across a series, but deciding why, and what to make next, is the chemists' call.
A practical first step
Pick the partner whose results cause the most manual work, usually the highest-volume assay provider, and automate that single feed from inbox to registry with checks and a weekly summary. If it saves the team a day a week, extend it to the next partner. QueryNow builds these pipelines inside the sponsor's own environment, connected to its registry and electronic lab notebook. Tell us the workflow you want gone, we build it in your environment in two weeks, and you pay $10,000 only after it meets the acceptance criteria you signed off on. Start at /build or see our work in pharma and life sciences.
Ready to ship AI in your organization?
We build one workflow into a working tool in two weeks. You pay $10,000 only after every acceptance criterion you signed off on is met.
One workflow · Two-week build · $10,000, paid on delivery
QueryNow
QueryNow deploys production AI for enterprises on Azure, AWS, or Google Cloud. Founded in 2014, we help pharma, healthcare, manufacturing, and financial services organizations deploy governed AI systems. We build it, you pay when it works.
Learn more about us →


