Offboarding in Alio (LINQ ERP)
Engagement Details
Primary Operations:
USA
Associated Since:
2023
Service Type:
Professional Services
Service Model:
SOW/Project
Status: In Progress
Methodology: Agile
Scope/Challenges/Key objectives
Business Case:
- One of the most prominent K-12 school districts in Missouri uses Alio for benefits and payroll.
- Manual entry and processes were used to terminate and correctly reconcile benefits, final pay, etc. This process was cumbersome, error prone, and lengthy.
- A manual method was used to trigger account deactivation as well.
Challenges:
There are no existing APIs or Web Services enabled or standardized for the applications involved.
The ERP system had limited integration points.
The budget was tight.
Reusability and best practices was a must.
The solution must be a base for integrating other systems.
Solution, Technical Environment, Benefits
Solution / Project Engagement:
- OTSI Designed and built a comprehensive solution to integrate multiple systems using the same framework. Once a termination date is set:
- Email employee with terms
- End dates benefits
- Reconciles final contract payout
- End dates leaves
- End dates direct deposit
- Sets termination status
- Set de-activation in active Directory, removing access
Technical Environment:
- Azure Data Factory
- Oracle
- SQL
- Azure Storage Account/Blobs
- Data Flows
- SSIS
- Active Directory
Much Faster than Manual Entry
Error reduction
Modular and highly maintainable due to minimal coding.
Greater user satisfaction due to the reduction in effort and errors.
