Pepper Group rolling out data warehouse-in-a-box
- 12 February, 2013 08:00
James Henshaw, CIO, Pepper Australia
Financial services organisation Pepper Group is deploying what is claimed to be Australia’s first fully-integrated data warehouse-in-a-box, an appliance that doesn’t require IT support.
Pepper Group has grown substantially over the past 12 months, acquiring seven portfolios globally including a $5 billion residential mortgage portfolio originated by GE Capital Australia and New Zealand.
During the global financial crisis, it also picked up contracts from competitors such as Allco Finance Group, which was liquidated in mid-2009.
As a result of this growth – which will see Pepper’s global staff numbers increase from 375 to 1000 by the end of 2013 – the company had created around six data warehouses. Workers relied heavily on a few IT staff to produce the reports that staff across its various divisions required.
“Every time our treasury, finance or marketing department wanted something done, IT [staff] had to do all the work,” said James Henshaw, CIO at Pepper Australia and member of the CIO Executive Council.
“For us, unlocking the IT resources and enabling the business to be self-sufficient in terms of their reporting was key,” he said.
“We built reports for them and they could go in a run them but if they needed any modifications for those reports or needed a new report – we were doing lots of acquisitions and handling large data files – IT always had to be involved.”
Pepper’s Australian office has engaged system integrator InfoReady to roll out the “self-service appliance” which combines data warehousing, business intelligence and data integration functions. It is based on the IBM Smart Analytics System 5710 Data Warehouse with a Cognos Business Intelligence front end.
The new data warehouse will contain information about 250,000 clients and up to 60,000 loans, said Henshaw.
Key data warehouse environments will be rolled out by mid-February and business intelligence tools will be available for use by staff in the company’s treasury and principle investment groups by the end of March, said Henshaw.
The business intelligence tools will enable these teams to analyse millions of rows of transaction and product data, which is used to determine prices paid for assets, he said.
As Pepper acquires more portfolios around the world, data will be incorporated into its data warehouse environment in Australia and business intelligence tools will be rolled out to various business units overseas, said Henshaw.
“We have about three or four acquisitions on the go over in Europe at the moment,” he said.
In mid-2012, Pepper purchased a €600 million residential mortgage portfolio managed by GE Capital in Ireland.
“We are heavily customising a system for the Irish market because it’s very heavily regulated over there,” said Henshaw.
“Once we have that rolled out, we will be bringing their data warehouse into ours. That will be a bit of a project itself, but at least early on, they will be able to use the BI tools.”
According to Henshaw, the automation provided by the appliance and integrated business intelligence tools free up three of his 20 IT staff to focus on business process improvements.
He added that while there will be “massive” cost savings it’s “more [about] the business being able to use the data, be more self-sufficient, get it [data] more timely and make strategic decisions earlier.”
Join the CIO Australia group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.
Trust issue looms large for tech companies capitalizing on personal data
5 women who've made it in IT
Five trends affecting legal CIOs
CIO Roundtable: The changing face of security
Bitcoin malware count soars as cryptocurrency value climbs
The Power of Transformational Knowledge
Apple saves $5 million a year on case and email deflection, while its agents find information 47 per cent faster than before they invested in something called Transformational Knowledge. In today’s consumer-empowered marketplace, you cannot afford negative customer experiences. However many companies lack the tools and processes required to empower their employees to deliver great customer experiences. In this whitepaper, we look at how to breakdown silos and deliver great customer experiences.
Assessing IP Telephony Total Cost of Ownership
Understanding total cost of ownership (TCO) of IP telephony (IPT) and unified communications (UC) implementations is critical to sound decision making. Based on data gathered from 211 Enterprises, this whitepaper reveals TCO for each vendor across a range of implementation sizes.
How to Successfully Select an ERP System
An Enterprise Resource Planning (ERP) system is a series of software applications that collect and compiles data from different departments to enhance collaboration and co-ordination within the business. If you’re looking to implement your first ERP system, or to upgrade from an existing system, this whitepaper offers eight simple steps for selection that will lead to long-term strategic success.