Roster management automation
Development of a roster management system and centralization of labor relations management with staffing agencies
Client
Under a non-disclosure agreement (NDA)
Business challenges
- Duplication and loss of data
- Lack of a unified roster management system
- Manual data input resulting in frequent errors (Excel)
- Manual payroll management by supervisors and accountants
Our solutions
- Temporary and full-time employees management
- Inventory management
- Admin panel and access management
- Advanced analytics and reporting module
- Paid time off (PTO) management
Project description
The goal was to develop a sophisticated roster management system designed to eliminate data duplication, reduce manual entry errors, and centralize labor relations management with staffing agencies and full-time employees.
We conducted an exhaustive analysis of the client's existing workflows to pinpoint inefficiencies and critical pain points. Utilizing TypeScript and Nest.js for the backend, we designed a scalable and maintainable architecture. PostgreSQL was selected for its robust data handling capabilities, complemented by Docker and Redis to streamline deployment and enhance caching performance.
We chose React.js paired with MobX for state management, resulting in a dynamic and responsive user interface. The administrator panel provided robust access control and user management, ensuring that confidential information was kept secure and only authorized personnel had access to it.
We integrated with a global provider of digital signage and self-service solutions, utilizing their self-service kiosks for access management. This integration enabled seamless data synchronization and communication between the roster management system and the access management system, ensuring data accuracy and consistency across all platforms.
The system of analytics and reporting was improved, allowing accountants to receive data on the working hours of each employee for the reporting period as well as verify invoices from staffing agencies. The administrator was able to view logs of all operations through the admin panel.
Technology stack
- Typescript
- Nest.js
- React.js
- MobX
- Docker
- Redis
- PostgreSQL
Key activities
Results
The new roster management solution and enhanced reporting module allowed the client to:
- Improve management of temporary and full-time employees, including PTO tracking and payroll
- Centralize the management of labor relations with recruitment agencies
- Automate payroll and billing management
- Solve the problem of data loss by automating data management
