USA
.NET, Azure Data Factory, U-SQL, Azure, Visual Studio
Design & Innovation
The project is for a client who is a popular global design organization located in the USA, with branches all over the globe. They have a team of designers, engineers, teachers, and researchers who look at creating change through design, by building learning platforms and tools to unlock creativity. They create human-centered inventions, services, spaces, and associations that empower groups, cities, and even countries.
The client was keen to store and report contractor information separately amidst data of regular workers and contingent workers. The challenge was to combine users from two applications – Bamboo HR & Okta making sure that the person-wise information exists in any one application only and does not duplicate. Another challenge was to introduce Okta code in a smarter way so that existing BambooHR logic will work efficiently and the collaboration between the two systems remains smooth.
Looking at the challenges faced by the client, SPEC INDIA followed an automated process that created and deployed custom activities for Okta and executed it along with a regular data processing cycle scheduled at a 4-hour interval. Okta users’ data was populated in Person & Person Job table. All these processes were automated through Azure Data Factory.
Our team introduced Okta for contingent workers. Okta is an enterprise-grade, identity management service, built for the cloud, but compatible with many on-premises applications. Full-time regular workers were managed through the BambooHR application, but contingent workers/contractors were managed through Okta profiles. Another use case for Okta was to use it as a Single Sign On authentication process for all other applications.
We wrote custom activities in Azure to pull data from Okta and merge both contractors (Okta users) and regular employees (BambooHR users) into common Person & Person Job tables. Reporting team distinguished contractors or regular employees based on the Person Type field.
Merge Okta users with BambooHR users while populating Person & Person Job Information
Report on Contractors
Our solution enabled the business to achieve the following benefits:
Effective reporting and monitoring of contractor information
Single Sign On authentication for all applications
Improved user experience
Robust, smooth, and effective business process execution
Automated processes and increased returns
Better collaboration with any person on any device
Robust reporting features
“SPEC House”, Parth Complex, Near Swastik Cross Roads, Navarangpura, Ahmedabad 380009, INDIA.
“SPEC Partner”, 350 Grove Street, Bridgewater, NJ 08807, United States.
This website uses cookies to ensure you get the best experience on our website. Learn more