Things I've Built
Three real projects, built for real use cases, with real constraints. No toy apps.
Biometric Attendance System
CIU had a real problem with exam impersonation. I led all backend development on a fingerprint-based authentication system that now runs during actual university exams. The system matches fingerprints in real time, logs timestamps, and stores biometric data encrypted on a Raspberry Pi. Django and DRF handled the API layer, MySQL handled the schema, and a React frontend handled the room admin UI.
- Led backend architecture and API design (Django, DRF)
- Designed and implemented the MySQL schema
- Built biometric data processing and matching logic
- Implemented encrypted storage and automated attendance recording
- Coordinated with a 6-person team across two departments
Smart Farm Management System
A full-stack platform for managing farm operations: fields, IoT sensors, planting schedules, irrigation cycles, and task assignments. I owned the backend and the frontend-backend integration. FastAPI deployed on Render, React/TypeScript on Vercel, PostgreSQL as the database. The schema has 10 normalised tables with stored functions, triggers, and role-based access control for Admin and Farm Manager roles.
- Designed 10-table PostgreSQL schema with normalization
- Built and deployed RESTful API with FastAPI on Render
- Implemented stored functions, triggers, and role-based access
- Integrated with React/TypeScript frontend deployed on Vercel
- Wrote DML statements and SQL queries alongside the team
Daily Energy Activities Tracker
A full-stack activity tracking app where users log daily positive and negative energy activities, filter by category, and edit their history. I built the entire server-side layer in PHP: session-based authentication, bcrypt password hashing, prepared statements to prevent SQL injection, and an admin user management panel. The UI features a dark glassmorphism design with a light/dark mode toggle wired entirely through CSS variables.
- Built full server-side logic in PHP (auth, CRUD, admin)
- Designed 3-table MySQL schema with foreign key constraints
- Implemented SQL injection prevention via prepared statements (MySQLi)
- Built the dark/light mode toggle using CSS custom properties
- Delivered a fully responsive glassmorphism UI