Allan Kamau

Built a school fee management platform with a React/TypeScript frontend and a JWT-secured FastAPI API. Implemented core entities for students, guardians, invoices, and payment plans, and validated functionality using sample data (students, invoices, and payments). Enforced least-privilege database access using PostgreSQL Row-Level Security on Supabase, with separate database roles for migrations and live API requests. Deployed the frontend on Vercel and automated fee reminders via Africa’s Talking using email and SMS.

Designed a normalized four-table PostgreSQL schema for household energy analytics, including 3 triggers and 4 stored procedures. Built a Node.js/Express REST API on top of the database and created a Postman collection to test endpoints. Led deployment on OCI by configuring a VCN, placing PostgreSQL in a private subnet, and running the API on an Oracle Linux instance. Resolved issues such as out-of-memory kills, SSL certificate chain errors, and data-quality problems, and produced a technical report and deployment runbook.

Built a full-stack hiring platform using FastAPI, Streamlit, and Supabase PostgreSQL with user roles for recruiters and candidates. Implemented automated resume ranking using TF-IDF and cosine similarity (scikit-learn) to reduce manual screening, and added an in-app AI assistant feature (“Hira”). Secured the platform with JWT authentication, role-based access control, rate limiting, and input sanitization. Improved production reliability by fixing email delivery failures on Render—migrating to the Resend API and using FastAPI background tasks to avoid frontend timeouts. Delivered and operated the system with registered users and active dashboards.