Case Study · Higher Education
USEK Alumni CRM
A custom verification CRM that turned scattered alumni spreadsheets into one fast platform the university's advancement office runs from any device.
- Client
- USEK
- Role
- Design & build
- Year
- 2026
- Type
- Internal tool
// The context
The Holy Spirit University of Kaslik (USEK) is one of Lebanon's oldest private universities. Its advancement office is responsible for staying connected to thousands of graduates spread across the world — the foundation of every alumni event, fundraising drive, and engagement campaign a university runs.
// The problem
The contact data existed — but it lived everywhere. Old registration exports, event sign-in sheets, separate spreadsheets owned by different people. No single source of truth, no way to tell which records were current, and no shared view: whoever held the latest file held the data. Verifying and cleaning thousands of records across a team, on different devices, was effectively impossible.
// What I built
A custom CRM built around one job: verify and maintain the alumni contact list, fast, from anywhere. Every record lives in a single Cloudflare-backed database with instant cross-device sync — open it on a laptop, phone, or tablet and everyone sees the same live data.
- One searchable list of every alumni record, filterable by faculty, graduation term, and status
- One-tap verification with a live progress counter across the whole dataset
- Instant cross-device sync — the team works from laptop, phone, or tablet on the same data
- Alumni-card request tracking built into each record
- Filtered or full CSV export, so the data stays portable and the office keeps ownership
A note on the data
Every screenshot on this page uses synthetic demo data — fictional names, emails, and numbers generated only for this case study. Real alumni records are never shown. Handling institutional data carefully, even in my own portfolio, is part of the job.
// The outcome
The advancement office moved from a tangle of spreadsheets to a single system they control. Records can be verified and cleaned by the whole team in parallel, from any device, with a clear live view of how much of the dataset is confirmed. The cleaned data exports straight back out — ready for the events, outreach, and campaigns the alumni programme depends on.
Run alumni relations, operations, or IT at a university?
This is a solved problem. I build custom CRMs and operational systems for institutions in Lebanon and the Gulf — and maintain them on a monthly care plan.