Results
- About 50,700 gifts and 17,000 constituents, with full history back to 2004
- 11,500+ grant requests and about 5,000 bills unified
- 8,113 grant PDFs (about 134,500 pages) made searchable
The problem
NetSuite held only a small slice of grant activity and no donor intent (pledge balances, installment schedules). Finance needed the full picture across the donor, grants and AP systems.
What I built
- Loaders and backfills for Raiser’s Edge NXT, Fluxx and BILL, kept current by a daily sync Lambda, with an automatic token refresher.
- Documented data models. A data dictionary for each source maps every field to NetSuite and lists the query pitfalls.
- Grant document search in its own schema, with a separate read-only login.
- An MCP server that lets AI assistants query NetSuite, the donor and grant systems, and scientific sources (PubMed, ClinicalTrials.gov, Semantic Scholar).
