← All work

Nonprofit · biomedical research funding

Unified donor, grant and payables data platform

One Postgres database combining donations, grants and payables from three systems, with full-text search over grant documents. It feeds reporting, an AI app and an MCP server.

  1. NXT · Fluxx · BILL
  2. Daily sync
  3. Postgres
  4. Search & MCP
Unified donor, grant and payables data platform
IllustrativeIllustrative: three systems unified for reporting and AI.
Client
Alzheimer's Drug Discovery Foundation ↗
Nonprofit · biomedical research funding
Stack
Postgres (AWS RDS), AWS Lambda, EventBridge, Blackbaud SKY API, Fluxx API, BILL API, Python, MCP

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).