Donor Data Extractor
Data Tool
Donor Data Extractor
A back-office tool that consolidates donation records from a Malaysian payment gateway across multiple charity accounts into a single, deduplicated donor masterlist — giving non-profits a clean view of their supporters for follow-up and reporting.
Domain
Fintech / Non-Profit
Project Type
Data Pipeline
Stack
Node.js · Payment Gateway API · Excel
Year
2023
What we built
- Pulls paid transactions across multiple charity merchant accounts
- Aggregates per donor — total given, gift count, average and full campaign history
- First and last donation dates per donor
- Malaysian phone-number normalisation
- Deduplicated, sorted Excel masterlist output
Related Work
Other Projects
