Overview
The New Breed Church struggled with manual attendance tracking, disjointed member databases, and lack of communication tools. I identified these broken processes and architected a system to handle church logistics.
Key Features
Member Database
Centralized system with all members, eleimanting the need to track on spreadsheets and makes information easily accessible. This also allow members to receive automated mails such as birthday wishes.
QR Attendance
Generated a system to track workers attendance. Geolocation checks were implemented to prevent fraudulent check-ins from outside the premises.
Role Based Access Control
Allows user to create and manage custom roles based on system features. This also allow admin to assign roles to users.
Automated Email System
Allows user to send automated emails to members based on certain triggers. There was also a broadcast feature to send emails to all members such as information about service and other church activities.
Engineering Highlights
- Backend: Built with FastAPI (Python) for high performance and automatic documentation. Used SQLAlchemy ORM.
- Database: PostgreSQL hosted on Renser. optimized queries for attendance reports.
- Frontend: React + TypeScript. Focus on mobile-first design as most check-ins happen on phones.
Product Impact
The system eliminated paper-based attendance, providing real-time dashboards for leadership. It streamlined communication via automated email broadcasts.