Challenge

  • Multiple consolidation systems
  • Dynamic ownership calculations
  • Thousands of accounts/LE’s/Products
  • Legal Entity reporting gap
  • Lack of integrated LE and management reporting
  • Duplicative reporting efforts at region and division levels
  • Process inconsistencies
  • Excessive time spent preparing reports, limited time spent analyzing results

Solution

  • Hyperion solutions addressed consolidation and reporting needs
  • Automated reporting converts the time and effort spent compiling and presenting data to the more productive activities of analysis and interpretation
  • Consistent, automated reporting achieves SOX compliance
  • Concurrent implementation of an Oracle-based global data warehouse for data management
  • Abstracted a dimensional repository for all metadata management
  • Enriched data moved to global data warehouse repository for all reporting, including transactions

The solution has been running in production since 2003

Benefits

  • Reporting Day 2 to the street, including automated cash flow
  • A consolidated, globally-linked forecasting and actuals solution enabled actions to be taken while there is still time to impact current period results
  • Increased the transparency of BU results and commentary by shifting the role of Corporate FP&A from a creator of analysis to that of a reviewer of results.
  • Reduce overall cycle time and effort of corporate FP&A in producing standard reports.
  • 25% efficiency opportunity gained in budgeting, forecasting, and reporting processes
  • Future cost avoidance and allocation of financial resources to higher value activities
    • Customer profitability analysis/strategic renewal
    • Capital investment analysis, resource allocation and post-project review
    • Controllership activities (including ASAT)

picture2

Return to Client List