Experian Consolidates Reporting Systems for One, Global View of Financial Data and Improves Planning for Continued Growth
 
 

Experian Consolidates Reporting Systems for One, Global View of Financial Data and Improves Planning for Continued Growth

Experian plc is a leading global information services company, providing data and analytical tools to clients in more than 80 countries. The company helps businesses manage credit risk, prevent fraud, target marketing offers, and automate decision-making. Experian also helps individuals to check their credit reports and credit scores and protect against identity theft. The company maintains its corporate headquarters in Dublin, Ireland, with operational headquarters in Nottingham, United Kingdom; Costa Mesa, Calif; and São Paulo, Brazil.

Experian maintains four diverse businesses—credit, decision analytics, marketing, and Experian interactive—and over the last five to six years, the company has made approximately 200 acquisitions, driving huge growth and complexity throughout the enterprise. Experian faced a global challenge, as each region and individual business unit ran its own, disperse, financial management and reporting systems, making it very difficult, if not impossible, to gather a timely, global view of financial data. Due to the volume of disparate systems—including Oracle Financial Analytics, OutlookSoft (SAP), Cognos, Prophix, and a myriad of Microsoft Access databases and Excel spreadsheets—the company was also experiencing data quality issues.

Experian knew it wanted to replace its multiple systems with one, global, enterprisewide tool. It turned to Oracle, deploying a full suite of Oracle Hyperion enterprise performance management (EPM) applications—including Oracle Hyperion Data Relationship Management, Oracle Hyperion Financial Data Quality Management, Oracle Hyperion Financial Management, Oracle Hyperion Planning, and Oracle Essbase—to address these challenges. At the same time, the company upgraded to Oracle E-Business Suite Release 12 to take advantage of new application functionality and streamline integration with the Oracle Hyperion EPM suite.  

 
Driving Visibility and Timeliness of Financial Information

A word from Experian plc

  • “With our Oracle Hyperion enterprise performance management suite, we have achieved one consolidated global view of our business performance and planning data—across more than 40 countries and numerous business units—enabling our management team to make timelier, effective decisions as our business continues to grow, organically and through acquisition.” – Kulbir Sandhu, Director, Global Reporting Systems, Experian plc

Experian used Oracle Data Integrator to integrate Oracle E-Business Suite with the Oracle Hyperion system. On the first five workdays of the month, the system loads data from Oracle E-Business Suite into the EPM suite every two hours. For the remainder of the month, there is a daily system update.

“Previously, it could take hours or days to gather our financial data across regions and business units and push it through our myriad reporting tools—and even then, there was no guarantee that the information was accurate or timely. The standardized processes enabled by the Oracle Hyperion solution, as well as the continuous refreshes, help us on a day-to-day basis and also greatly help streamline our month-end and year-end financial close processes,” said Kulbir Sandhu, senior director, global reporting systems, Experian plc.

Experian can also pull financial source data from acquired companies that have not yet been integrated into the Oracle E-Business Suite instance by loading the data directly into Oracle Hyperion Financial Data Quality Management—providing the company with a full enterprise view without losing precious time.

“We have 800 users across the Oracle Hyperion applications. The system gives our financial management teams a truly global view of data. They can log in, pull profit and loss and growth reports, and track performance in Asia Pacific and in North America and have confidence that they are using standardized data to make decisions,” Sandhu said. “The platform also gives us a great platform for the future. For example, we’re looking at deploying additional sales reporting capabilities in the EPM system.”

The system also provides Experian with the flexibility to load all data in local currency, automatically completing conversions and budget rates and thus providing a robust set of reports in constant currencies. The ability to aggregate large volumes of data in Oracle Essbase puts information at the finance teams’ fingertips very quickly.

“With Oracle Hyperion, we spend less time building reports and more time on actual analysis. Our various business units within our regions can support their sales and marketing organizations and provide them with the analyses they need to help drive and grow their business,” Sandhu said.

Prior to the Oracle Hyperion implementation, if the company wanted to conduct a global aggregation of its financial performance data, it would need to wait for each region to upload numbers and then reconcile those numbers to their source systems.

“It could take more than a day before we could even access that data,” Sandhu said. “Now, with our continuous refreshes between Oracle E-Business Suite and Hyperion, we can run the end-to-end process in 90 minutes or less.”

Experian has also accelerated its year-end financial close process from seven or eight days to just three.

 
Improving Usability and Flexibility

 
Streamlining Integration and Reducing Total Cost of Ownership

 
 

 
 

Challenges

  • Replace disparate reporting tools with one, global, enterprisewide solution to enable the information services company to gather a timely, global view of financials and reporting across its four, diverse businesses with customers in 65 countries
  • Ensure a scalable and flexible environment to meet the unique needs of a diverse and global information services company that has acquired approximately 200 organizations in the past five to six years
  • Improve financial data quality and create a robust platform for faster integration of acquisitions into the financial systems environment, as the company continues to expand its portfolio of direct marketing and consumer credit services
  • Provide flexibility to enable team members to more easily transfer to different geographies or business units without needing to learn entirely new skillsets
  • Reduce the overall total cost of ownership for reporting systems

Solutions

  • Replaced disparate reporting systems with one, global, financial management and reporting system, enabling 800 users across regional financial management teams to access standardized data for profit and loss, growth, and performance reports
  • Refreshed data between Oracle E-Business Suite and the Oracle Hyperion suite every two hours, enabling Experian to reduce the time needed to pull an aggregated global view of financial performance from more than one day to less than 90 minutes
  • Enabled the company to easily pull financial source data from acquired companies that have not yet been integrated into Oracle E-Business Suite into the EPM system—providing the company with a rapid enterprisewide view
  • Accelerated the year-end financial close process by more than 250%
  • Enabled employees to more easily move between regions or business units without requiring extensive training
  • Reduced application maintenance and upgrade costs by eliminating numerous, regional reporting systems

Why Oracle

“We chose the Oracle Hyperion suite due to the vendor’s reputation as a global leader for reporting and consolidations,” said Kulbir Sandhu, senior director, global reporting systems, Experian. “When Oracle acquired Hyperion, we saw the benefit in staying with one strategic vendor for our financial and reporting systems, due to easier integration between ERP and reporting.”
Implementation Process – In 2009, Experian decided to bring its three instances of Oracle E-Business Suite onto a single instance to implement one, global chart of accounts, while upgrading to Release 12. At the same time, the company chose to deploy the reporting tools—the Oracle Hyperion applications and Oracle Business Intelligence Enterprise Edition—to support its ERP system.

Experian worked with Oracle Platinum Partner Tata Consultancy Services (TCS) on the Oracle E-Business Suite implementation and with Oracle partner Hackett Technology Solutions on the EPM (Oracle Hyperion) deployment. The company went live on all systems in January 2010.

Partner

Experian has a long-standing relationship with TCS, which has maintained and supported the company’s systems for a number of years. TCS provided the technical resources for the Oracle E-Business Suite implementation, completing the technical build and configurations, creating the test scripts, and making sure the integrations between the applications worked appropriately.

On the EPM side, Hackett Technology Solutions provided technical and functional support, helping Experian develop its business processes and understand how the Oracle Hyperion tools could support the business. Hackett also completed the technical implementation and built the integration to the Oracle E-Business Suite environment.