GDI helped a manufacturing company develop Hyperion intelligence-based reporting and analysis applications to improve user productivity and reduce cost of ownership.
The Challenge
Client Background
The client, an auto supply manufacturer, has a presence on six continents. Known for its pioneering products and high added-value services, the company strives to and succeeds at achieving a fair return on the quality and innovation that characterize its offerings.
Project Objective:
This project addressed replacement of SAS Reporting systems with Hyperion reporting. The client was using SAS for its reporting along with host of other tools and software. They sought an integrated modular suite of financial management applications with the comprehensive business intelligence (BI) capabilities for reporting and analysis offered by Hyperion. The project objective was to increase user productivity and lower the cost of ownership.
The Solution
Technology Employed:
Hyperion, an ETL tool called Essential, Java, Oracle DB2 and RDB
Project Details:
GDI was selected by the client for its extensive experience in managing delivery of multiple data warehousing solutions across functional areas. The engagement entailed three BI projects using the Hyperion Performance Management System: Revenue Accounting, Help Desk Management and Quality Management.
The Revenue Accounting system allowed cost accountants to monitor anomalies in shipping and receiving. The Help Desk system enabled users to identify outstanding issues. And the Manufacturing system facilitated the tracking of quality in the production environment.Key Responsibilities:
- The GDI team performed an extensive study and analysis of requirements for all projects.
- A GDI consultant served as mentor to the client’s development team, directing project activities and providing guidance in implementing improvements that harnessed Hyperion capabilities.
- GDI realized that defining the milestones of each project deliverable would be paramount in achieving client satisfaction in the long run.
- The GDI team maintained a successful track record of timely deliverables that has spurred the client to extend the project for development and implementation of new functionality.
- Our team developed a series of custom Hyperion Dashboard Builder templates for use by in-house developers.
- GDI consultants developed a Hyperion Intelligence Based Management Issue Tracking application to monitor problem aging, problem priority and resolution documentation.
- GDI consultants developed a Hyperion Intelligence Based RA application to allow revenue accountants to track invoice vs. purchase order discrepancies in real time.
- GDI consultants developed a Hyperion Intelligence Based IT Help Desk Application to provide users real-time access to statistical data in the Hyperion-Foundation.
The Results
- GDI earned the distinction of being chosen for further project extensions.
- The Quality Management and Help Desk Management systems exceeded the client expectations.
- The eESM and Revenue Accounting reports are in the production phase with testing and demos in progress. These reports will ensure that all users look at high-quality data, speeding response time and freeing up resources for other projects.
- The delivered solutions will significantly accelerate management information reporting, bringing important control issues to light