CPG Management System
A single platform that runs an entire federation of professional guilds — membership, welfare, events, and communication — while keeping each guild independent and members' information private.
Built for a professional guild federation under the Archdiocese of Accra
Multiple professional associations under one church structure were being run on paper, spreadsheets, and word of mouth. Member records were scattered, welfare support — illness, bereavement, emergencies — was hard to administer fairly, reporting was painful, and there was no reliable way for leaders to oversee it all or for members to stay connected.
The real challenge wasn't features — it was boundaries. Many guilds needed to operate independently inside one system, leadership needed oversight without overreach, and members' personal information had to stay protected even while people engaged across the whole community. So I designed it as a multi-tenant system from the start, with role-based access and privacy built into the foundation rather than bolted on afterward.
Leaders get a real-time view across every guild; executives manage their own members, events, and welfare cases through clear approval workflows; members get a private space to stay informed, connect, and access resources. Administration that used to live in filing cabinets now runs as one dependable platform.
Custom MVC-inspired PHP / MySQL architecture. Multi-tenant design with granular role-based access control across Super Admin, Guild Executive, and Member roles. Welfare module with submission, verification, approval, and tracking workflows plus expenditure reporting. A reusable engagement engine — threaded comments and reactions — shared across modules. Centralised notification engine covering guild, system, event, and activity-feed notifications. Privacy-aware guild and cross-guild feeds. Security throughout: session validation, CSRF protection, input sanitisation, and soft-deletion to preserve audit history.