Company Background

Rogers Corporation, headquartered in Rogers, Connecticut, develops and manufactures high-performance specialty material-based products, which serve a diverse range of markets including portable communication devices, communication infrastructure, consumer products, computer and office equipment, ground transportation, and aerospace and defense. Rogers operates manufacturing facilities in Connecticut, Arizona, and Illinois in the United States; Gent, Belgium; and Suzhou, China. Sales offices are located in various countries around the globe, including Japan, Taiwan, Korea, China, and Singapore.

Project Goals & Objectives
  • Develop an automated consolidation application and replace a homegrown data warehouse with a purpose-built data warehouse that would allow for scalability and analysis of sales and other data using Hyperion Essbase
  • Deliver all these solutions via the web utilizing Hyperion Financial Reporting and Hyperion Web Analysis
  • Create a scalable application that will allow for future growth
  • Help build a standardized set of reports

Business Issues

Rogers’ reporting and consolidation process was based on a set of Microsoft Excel spreadsheets and general ledger reports, which lacked appropriate controls and procedures. In addition, the financial close took numerous days of effort.  The homegrown data warehouse was not linked to the financial reporting and discrepancies in the data would typically exist.

Software Implemented

  • Hyperion Financial Management
  • Hyperion Hub
  • Hyperion Financial Reporting
  • Hyperion Web Analysis
  • Hyperion Application Link Advanced
  • Hyperion Essbase
  • Hyperion Essbase Integration Services

Ranzal Role

In partnership with Hyperion Consulting Services, the Ranzal team successfully designed and implemented Hyperion Financial Management and Hyperion Essbase, and developed a dashboard utilizing Hyperion Web Analysis to deliver the solution to the Company. Ranzal, along with other outside consultants, also developed the foundation of a purpose-built data warehouse that would allow drill- down analysis and that is scalable to meet the future analysis needs of the Company.

Business Benefits

  • A Sarbanes-Oxley compliant consolidation process providing a controlled environment to perform the GAAP financial consolidation processing
  • Elimination of manual processes, including running monthly reports and creating and reconciling many independent spreadsheets
  • Ease of administration by the Corporate Finance Reporting department
  • Improved financial reporting and analysis of consolidated results and the underlying detail
  • Controlled processing of last minute adjustments of GAAP consolidated results – the solution can receive a journal-based entry and reconsolidate the legal and management consolidation structures within a 30-minute window
  • Reduced turnaround time for restatements and organizational changes
  • Reduced time in the external audit process
  • More robust reporting