Software Engineer@ActiveSystems Software Inc.
July 2024 – Present · Davao City
- Core member of the Research & Development team driving adoption of modern architecture and standardized engineering practices across multiple products: ActiveWork — a multi-tenant HR / Payroll / Attendance SaaS (.NET 9 Web API + Next.js 16) — and ActivePOS XA — a BIR-accredited Point-of-Sale platform serving 20+ tenant businesses (Delphi, DDD, Aurelius / FireDAC ORM).
- Architected a multi-tenant backend with PostgreSQL Row-Level Security and tenant-resolution middleware, enforcing strict per-tenant data isolation across every service and background job.
- Built JWT authentication and a role-based access control (RBAC) system with searchable field-level encryption for sensitive employee documents.
- Delivered an end-to-end leave-management subsystem — configurable leave-type catalog, accrual engine, balance ledger, half-day filing, PH statutory rules, multi-level approval routing, and year-end forecasting — across the .NET API and Next.js UI.
- Implemented a payroll overtime approval workflow (audit logging, tenant-wide queues, optimistic UI with rollback) and disbursement features: bank-file generation, payslip history, and BIR-2316 PDF generation via PDFsharp.
- Added real-time notifications with SignalR, scheduled and recurring background jobs with Hangfire, Redis-backed caching, and versioned schema delivery with Flyway migrations.
- Owned the CI/CD pipeline end-to-end (GitHub Actions + Docker + GitHub Container Registry) as platform release owner, automating builds and deployments to an on-premise Ubuntu staging host and an AWS EC2 production server — improving release reliability and repeatability.
- Built the Next.js 16 / React 19 client (TanStack Query, Zustand, Zod, React Hook Form, Tailwind CSS, Radix / shadcn), delivering responsive, accessible UI covered by Vitest, Playwright, and MSW tests.
- Served as the first engineer on client requirements — scoping system updates, feature requests, and production issues, then translating them into backend changes and coordinating rollout.
- Resolved a critical ORM concurrency / FireDAC connection-pooling defect (dangling object manager), improving data-processing throughput by ~60% and stabilizing the system under load.
- Implemented a Socket.IO API adapter using the observer pattern to stream real-time updates between POS terminals and backend services.
- Designed BIR-compliant reporting modules (end-of-shift, end-of-day, sales, and tax summaries) with optimized SQL — indexing, joins, and window functions — plus PDF export, satisfying the fiscal-reporting requirements for BIR accreditation.
- Refactored core domains (sales orders, discounts, payment transactions, report management) toward Clean Architecture / DDD, raising modularity and test coverage with DUnitX unit and integration tests.
- Built supporting developer tooling, including ActiveEnvEditor, a Delphi FMX desktop app for managing environment configuration.
.NET 9Next.js 16PostgreSQL RLSSignalRHangfireDockerAWSClean Architecture / DDD
