iSDAT Manpower Tracking System (MTS ERP)
The iSDAT Manpower Tracking System is a production enterprise ERP platform architected to manage distributed workforces, payroll processing, real-time attendance verification, and multi-tier access control for enterprise clients.
High-Impact Metrics
- $500,000+ annual payroll processed automatically.
- 100+ concurrent active enterprise users with 99.5% uptime.
- 50+ RESTful API endpoints with strict JWT role-based access control.
- 35+ tables migrated from SQLite to PostgreSQL with zero downtime.
AI-First Architecture & Agentic Workflow
Rather than traditional manual software development, MTS ERP served as a living proof-of-concept for AI-agent-in-the-loop engineering:
- Autonomous Coding Agent: Utilized Cursor AI Composer with tight architectural prompts to generate 70%+ of the production codebase, spanning API routes, database schemas, validation middleware, and business logic.
- Zero-Downtime Migration: Designed a dual-write migration strategy to transition from SQLite to PostgreSQL using Drizzle ORM, preserving strict relational constraints and transaction atomicity across 35+ tables.
- Automated Workflows: Connected to an n8n orchestration engine for automated WhatsApp notifications, daily attendance punch-in links, and operational alerts.
Tech Stack & Implementation
- Frontend: React.js with modular state management, Tailwind CSS, and brutalist performance-tuned layouts.
- Backend API: PHP 8.x modern RESTful micro-endpoints, JWT authentication, and structured validation.
- Database: PostgreSQL 16 with Drizzle ORM for type-safe schema definitions and migration tracking.
- Infrastructure: Dedicated self-hosted server environment, Cloudflare Tunnels, PM2 process management.