Oracle PeopleSoft Integration for a Multi-Tenant HUCM Platform

Project Solution

INNERLUXES designed a multi-tenant, cloud-based HUCM application to help human resource departments manage employees.

The Client

The Client is a HUCM software company that helps businesses save cost and time by reducing manual tasks and automating processes. Its tools help HR departments across organizations increase the efficiency of their management procedures while remaining compliant. The Client engaged INNERLUXES to design an application its customers could use to fulfil a wide variety of employee-information functions:

• Track employee histories, skills, abilities, salaries, and accomplishments.
• Gather, store, and access employee information.
• Keep records of employee attendance, payroll, tax deductions, and benefits.

Design and Structure

INNERLUXES first established expectations and necessary functionalities, then implemented multi-tenancy so the application could be used by various organizations internationally, established UI and role-based functionality, and developed specific APIs to facilitate interaction between modules — designing the application to allocate a new database for each new tenant.

The application included two main modules: an admin module (managed by the Client) for loading new customers, setting up configurations, and IT features; and individual customer modules broken into company, recruitment, HR/Admin, payroll, and tax categories, each with its own functions. Integrating submodules with third parties such as Oracle PeopleSoft further extended functionality.

Application Development

Within the admin module, INNERLUXES established a process for new-customer setup, performing a series of integrations so the initial configuration ran smoothly for each user. As part of a 10-step procedure, it performed integrations with access and clock devices and an API to enable database updates and tax-entity integration. Finally, INNERLUXES integrated Oracle PeopleSoft into the customer module to enable payroll integration and eliminate manual payment processing.

INNERLUXES then identified the roles and functions in each submodule of the customer module. To test the solution, it created a prototype UI, established overall workflow logic, and validated the prototype. After establishing the flow architecture between the recruiting, HR/Admin, payroll, and tax modules — and how they interact with users, the admin module, and backend software — INNERLUXES developed the final solution.

The application was staged and produced in the AWS cloud environment, modeling database allocation with AWS RDS and using AWS Route 53 and DNS services to ensure seamless user access for each module. The final solution was customizable, scalable, and cloud-compatible to support flexibility and adaptation.

The Impact

• Provides the Client's customers with timely, accurate, and dependable information to support informed decision-making, policy framing, and analysis for HUCM.
• Enhances HR management across recruitment, performance, wages, attendance, holidays, and payroll.
• Delivers a customizable, flexible, cloud-based solution that boosts HUCM efficiency.
• Improves accessibility, compliance, efficiency, employee experience, integration, and data security in human resource management.

Technologies and Tools

ReactJS, NodeJS, PostgreSQL, AWS Elastic Beanstalk, RDS, Lambda, CloudFront, Route 53, Elastic Load Balancer, Oracle PeopleSoft.