Challenges

1. Merging data from diverse HR platforms
2. Navigating multiple disparate HR systems, which had created data redundancies and inconsistencies, making it hard to extract a single source of truth
3. Development of data flow mappings
4. Data quality management implementation
5. Data masking for personally identifiable data based on access level
6. ETL design and implementation data integration into the global DWH solution
7. Making sure that the cloud-based HR solution was compatible with other business tools and systems used in different departments, which was crucial for holistic business operations

Goal

Build SaaS for offices all over the world to manage the administrative processes required to track and support employees

Results

1. HR teams, managers, and employees have secure access to necessary data from anywhere and real-time analytics
2. Migration for 39 countries implemented successfully, taking into account all regulations
3. Developed, reinvented, and modernized the HR system for all HR-related tasks and procedures
4. Advanced encryption and security protocols ensured sensitive HR data is protected
5. Collaboration and self-service capabilities make employees more engaged in teamwork. Satisfaction has increased by 50%
6. Various HR tools and applications were easily integrated, breaking data silos

Background

The customer is the company’s business unit engaged in training management. Previously, reports on the implementation of training programs were prepared manually: they collected data from various training systems and summarized them.

Business Challenge

The company has several training apps that collect a variety of data about students, instructors, and training programs. This data needs to be collected in one system and automate the reporting process.

Solution

Since it was required to build a solution framework in a short time, we decided to use an open source solution. The IBA Group team developed a test version of the data warehouse with integrated Tableau BI system. Dashboards and reports are now created in this software.

The challenge of the project was that the various applications of the training platforms had to be taught to communicate with each other. For example, there is an application where employees take courses and another application where they provide feedback on these courses. The task was to write a utility that would automatically forward users after completing the courses to the feedback page which already contained the details of the course.

Result

Previously, report preparation using MS Excel took about a week. Now this process is fully automated with a ready-made dashboard in Tableau.

The customer is also able to track and analyze the content: demand for courses, percentage of fully-completed courses, and number of certificates received by students.