Case study · 2025–present · active
AKK Timesheet Manager
A production workforce management platform built for AKK Engineering Pte. Ltd. that handles timesheets, attendance, leave, payroll/payslips, and vehicle journey tracking — available as a web app and Android app.
25
Page files
38
Components
35
Library modules
33
Database tables
22
Migrations
3
Edge Functions
183
Git commits
Web + Android
Platforms
The problem
AKK Engineering had workflows involving employee working hours, shifts, breaks, leave, overtime, payslips, and other operational processes — work that needed a proper digital system, not scattered manual steps.
The idea
A full workforce platform with role-based portals, QR attendance, GPS verification, leave and payroll logic, vehicle tracking, and notifications — shipped for both web and Android.
Why I built it
I wanted to solve a real problem rather than build another project that only existed as a demo. What started as a timesheet project grew into a much larger workforce platform. The project taught me that real software isn't just about making features work — it has to understand the people and processes behind those features.
Features
- Worker, admin, and manager/supervisor portals
- QR clock-in, break management, and clock-out
- GPS geofencing
- Face ID verification
- Leave requests, approvals, and balances
- Payslip generation and payroll calculations
- CPF / SINDA / SDL logic
- Timesheet management and attendance reports
- Site management
- Vehicle journey tracking with live GPS maps
- Push notifications and announcements
- Feedback forms
- PDF and Excel exports
- Guided onboarding tours
- Google Play in-app updates
- Role-based authentication and RLS security
Technology
- React 18
- Vite
- TypeScript
- JavaScript/JSX
- Tailwind CSS
- Radix UI
- TanStack React Query
- React Router
- Supabase
- PostgreSQL
- Supabase Edge Functions
- Supabase Realtime
- Supabase Storage
- Capacitor
- Firebase Cloud Messaging
- face-api.js
- Leaflet
- Framer Motion
- jsPDF
- html2canvas
- xlsx
Architecture
01
React + Vite frontend with TypeScript and Tailwind
02
Supabase for auth, PostgreSQL database, storage, realtime, and Edge Functions
03
Capacitor wrapper for the Android application
04
Role-based access with Row Level Security
05
Firebase Cloud Messaging for push notifications
Screenshots
Challenges
- Designing workflows that match how people actually work on site
- Balancing web and Android behaviour in one product
- Payroll and leave logic that has to be correct, not just pretty
- Security and role separation across worker, manager, and admin portals
What I learned
- Real software is about people, workflows, and reliability — not only UI
- Production apps need careful auth, data rules, and ongoing iteration
- Shipping to Google Play changes how you think about updates and stability
- Small ideas can grow into much larger systems when they solve real problems
Timeline
Development began around December 25, 2025 and has continued actively since.
Future plans
- Keep refining based on real usage
- Improve reporting and operational workflows
- Continue polishing the Android experience
Want to talk about this project?
I'm Arumugam Abinav — a student developer in Singapore who likes turning ideas into real products.