Archive | Business Intelligence RSS feed for this section

Revenue System of Record

A leading software  and software services provider was moving from traditional software revenue recognition based on licensing to new ways of recognizing revenue based on usage, cloud services and so forth.  Furthermore, the company has online ads revenue from its search engine.  Therefore the client requested to assess and map all revenue systems currently in use in the division and propose a plan to reduce and rationalize the number of revenue systems.

Business Results

  • Proposed a common data model for revenue recognition – Corporate assumes responsibility versus divisions
  • Proposed to streamline number of revenue recognition applications (Consolidate and manage by trigger)

Reporting Architecture Design

The client, a regional utility company,  was undergoing a financial transformation program that included the redesign of the reporting architecture.  My team led the analysis and conceptual design of the reporting architecture which included the definition of a financial data mart to collect in one place all financial information for reporting, and the definition of multiple Hyperion Essbase cubes to manage the reporting of different areas of the business.

Budgeting and Forecasting Solution

Led pursuit and delivered analysis and design of a budgeting and forecasting solution for a large financial services company.  The solution included the redesign of all major business dimensions and the adoption of Oracle DRM to manage them.

Business Results

  • Standardization of all master data across the company
  • Financial data mart as one source for all budgeting and forecasting need
  • Distribute planning process

Reporting Architecture

Managed the analysis and design of a reporting solution for a global high-tech company. The legacy reporting system was based on PeopleSoft G/L with limited reporting capability. The new solution, which included Oracle Financial Management, OBIEE and Data Relationship Manager was able to cover all company reporting needs from transactional reporting up to high level management reporting in one architecture.

Business Results

  • Create reporting architecture to consolidate all company’s reporting needs in one place
  • Standardized company-wide master data
  • Streamlined financial reporting

Pentaho Demo Environment

Setup a Pentaho Business Analytics demo environment to present an open source solution to manage business intelligence and business analytics to prospect clients.