Progressive needed a human resources analysis solution to help answer the following questions:
The desire was to create an application that could help address the questions above and would facilitate 24 x 7 user access.
This project was a large effort that focused the implementation of Oracle BI Applications-HR Analytics against PeopleSoft ERP, some custom analytics, and the consolidation of existing data warehouses. The solution consisted of four primary areas to meet the business needs of Progressive.
Beyond the technical complexities involved in converting from one business intelligence tool to another, the biggest challenge was ensuring user adoption of the new tools among a group of users that are not considered to be technically savvy.
Using KPI’s proven proprietary methodology for Business Objects to Oracle BI migration, Progressive was able to move the existing HR reports into a new, more robust environment. This process also included the migration of Microsoft SQL Server to an Oracle database platform. KPI’s migration process from Business Objects to Oracle Business Intelligence has four distinct phases:
The Audit Phase is one of the most important in any report conversion process. The Audit Phase determined the initial scope of the project. The final deliverable of the Audit Phase was a comprehensive list of all reports identified for conversion.
After the list of reports identified for conversion was prepared in the Audit Phase, business intelligence experts determined the best way to migrate each existing report within the functional capabilities of each application. A high-level design for report conversion was constructed.
The Development Phase was the phase during which Progressive was able to greatly minimize costs and maximize the benefits of the conversion process. Reports were converted using a proven proprietary strategy. All reports were unit tested. Staging and production environments were prepared.
The User Acceptance Phase focused on Progressive’s end user. Users were trained to understand the features of Oracle BI and how these features map to features within Business Objects. All critical issues were resolved and the solution was deployed into the production environment.
Oracle’s BI Applications were extended to include additional support for Survey Analytics and Training Analytics at Progressive. The custom-developed Survey Analytics area of the solution provides Progressive HR management measurements and metrics around employment satisfaction. The customdeveloped Training Analytics area of the solution provides insight into their employee development program
Beyond converting existing HR reports from the previous BI tool, Progressive sought to augment their analytical capabilities through the construction of an HRMS Scorecard that provided key metrics in the following areas:
Oracle’s HR Analytics was deployed with a new data warehouse and extended to meet the additional needs of the HRMS Scorecard.
Progressive successfully uses Oracle HR Analytics to analyze turnover (both voluntary and involuntary; controllable and uncontrollable) from 25+ different angles in graphically intuitive ways.
This gave Progressive new insights into their turnover data and helped them proactively identify at-risk groups of employees who are likely to leave the company and allowed them to tweak their retention strategies.
The effort was initiated with a KPI Partners Vision Workshop that brought together all the key stakeholders within Progressive’s Technology Department, Progressive’s business sponsors, functional & subject matter experts, and the business intelligence project team. After a 5-month project, old Business Objects reporting was converted into the new OBIEE environment, Oracle BI Applications-HR Analytics was deployed featuring a new Human Resource Management (HRMS) Scorecard and extended functionality for Survey & Training Analytics, and additional data warehousing elements were launched.
Progressive required a single consolidated view of their human resources organization. A successful implementation would facilitate the ability to refresh business intelligence data daily and accommodate 24 x 7 user access.
High-level performance and data accuracy were critical success criteria. End user acceptance and adoption was a major success criterion for the effort.
By selecting the tightly integrated solution from Oracle, Progressive is now able to better monitor corporate performance. Progressive can more efficiently deliver critical business information throughout the value chain and obtain an overall lower total cost of ownership.
User adoption within Progressive’s Human Resource area has been very high. The system currently supports over 500 users who are experiencing response times ranging from 0-30 seconds.
Multiple systems were consolidated. Disparate Business Objects and SQL Server environments were consolidated into a single Oracle Business Intelligence environment. Oracle Business Intelligence is now the enterprise-reporting standard for human resources at Progressive.
There has also been a significant reduction in the use of other outside tools, such as Excel, for routine reporting which has led to a higher rate of employee productivity.
Progressive went through an extensive evaluation process to determine if there would be enough tangible value in moving from Business Objects to Oracle Business Intelligence. After deliberation, Progressive moved to make the change based on the following value-driven criteria:
As the most experienced systems implementation partner focused on Oracle BI & EPM, KPI partners was chosen because of their expertise with business intelligence tool migrations, specifically with Business Objects. KPI Partners has successfully executed the world’s largest and most complex migrations of Business Objects to Oracle Business Intelligence.
With over 20 migrations under their belt, KPI developed a proprietary methodology for BOBJ to Oracle BI migration. This methodology has successful driven projects at such organizations as Bank of Hawaii, St. Jude Medical, and Cox Communications. The Cox Communications project was the largest known migration to Oracle BI with over 1500 reports and 25 universes of Business Objects.
KPI Partners also offered global delivery capabilities that leverage a blended-shore model with a combination of high-value on-site experts and lower cost offshore resources.