Rainbow Omega Portal replaced a broken internal application that was no longer maintained, but still carried crucial worker time tracking, payroll reporting, and quarterly and yearly nonprofit reporting requirements. The old system was not mobile friendly, had a poorly built backend and database schema, and still forced staff to modify and reorganize much of the reporting data in Excel. We successfully migrated their legacy data into the new system with no data loss, giving the staff continuity without carrying forward the old app architecture. The new portal is a responsive React application backed by PostgreSQL, API-driven workflows, and authenticated email delivery through AWS SES. Staff can now track worker data, customize report sorting and filtering, send reporting data directly to other authenticated portal users, and catch discrepancies in worker time entries before they reach payroll.
Product Highlights
- Full replacement for a broken legacy internal app
- Successful legacy data migration with no data loss
- Responsive React portal backed by PostgreSQL and APIs
- Worker time tracking, payroll review, and quarterly/yearly nonprofit reporting
- Custom report sorting, filtering, and authenticated email delivery through AWS SES
Key Features
- Mobile-friendly interface for staff who need reliable access beyond a desktop workstation
- PostgreSQL schema designed around worker data, time entries, reporting, and operational clarity
- API-driven data workflows that replace spreadsheet cleanup and manual report reshaping
- Legacy data migration that preserved historical records through the transition
- Payroll discrepancy tracking before time entries move into the biweekly payroll process
- Customizable report filters and sorting options for staff and nonprofit reporting requirements
- Authenticated report delivery to other portal users through AWS SES