One tree One life
USA
.NET, C#, SSIS, SQL, Visual Studio, Data Tools
Design & Innovation
The client was keen to get rid of the legacy on-premises Enterprise Manager application and migrate to a third party, cloud SaaS based HR application for better usability, interactive UI, better collaboration and less support and maintenance.
The client was in need for automation of the entire process which was possible only by migration. Replacing a legacy application with a third party SaaS based application by making sure that all existing business logic will work was a big challenge.
Having frequent updates in the API endpoints was difficult. Deploying all the legacy systems onto the new SaaS based application in a single shot was a tough task specially to ensure a low downtime.
Looking at the challenges faced by the client, SPEC INDIA followed an automated process that will download incremental (modified) data from the new SaaS application through web API, process the downloaded data through SQL stored procedure, populate processed data into the traditional database, replicate data to other reporting database that are being used for reporting purpose. The entire process was automated and scheduled for every 1 hour interval using SSIS tool & SQL agent job.
Our solution was based on replacing the old on-premises EM application with the new third-party SaaS-based HR application named BambooHR. It is a complete HR management software that contributes to growing your people, improving the employee experience, and taking your business forward.
Our project involvement included the following steps:
Analysis & Field Mapping
Migrate existing legacy (EM application) data to the new BambooHR system through API endpoints
Write API that will download data from new system (incremental changes)
Build strong business layer that will sync downloaded data back to EM database
Replicate new application data to reporting databases and use them for reporting
We suggested to build Web API to download the new system data, SQL Server for processing/storing downloaded data & SSIS for automation.
Staff/Talent module keeping talent details
Personal information i.e., name, address, contact information, marital status etc.
Employment status i.e., full time, part time etc.
Employee job information i.e., studio, department, job title, reporting manager etc.
Employee compensation i.e., pay amount, pay method, pay frequency etc.
Employee journey information i.e., journey, journey title, role, discipline etc.
Location percentage
SPEC INDIA offers seamless migration to cloud-based SaaS applications which not only offers better collaboration but also integration. Get in touch with our consultants to get started with the migration.
Our detailed and accurate research, analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.
We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.
Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.
Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.
We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.
Enhanced HR process and usability
Less support and maintenance costs and efforts
Automated processes and increased returns
Robust and effective business processes
Interactive user interface
Better collaboration
Robust reporting features
You have landed at the right destination. We at SPEC INDIA hold experience with similar projects. Let us discuss the specifications of your requirements further.
This website uses cookies to ensure you get the best experience on our website. Learn more