JPMC Code For Good Hackathon

Turning 10 years of grant PDFs into donor-ready impact stories in 36 hours.

Team of 7 · 22h hackathon

Client
The Lilabean Foundation
Pipeline
PDF → MongoDB → donor email
Event
JPMC Code For Good 2025

Problem

The Lilabean Foundation had a decade of annual funding PDFs but no way to show donors what their money actually did. Manual reporting cost staff hours per update.

Approach

Parsed historical funding PDFs into a normalized MongoDB schema, built a React dashboard for impact visuals, and wired Gemini to generate personalized donor update emails with charts drawn from each donor's own contribution history.

In short

Full-stack project built for The Lilabean Foundation to visualize donation impact, parse annual funding data into MongoDB, and generate personalized funding update emails using Gemini-powered summaries and charts.

Stack

React
TypeScript
Python
MongoDB
Gemini API