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.
Why IT projects really fail
Queensland government to provide 200 services online by 2015
Call Centers Suffer From Big Data Overload
CIO 100: Carsales wins top gong for innovation
How to secure passwords and other critical numbers
Benefits of Web Self-Service
According to Forrester, 72 per cent of customers prefer using a company’s website to answer their questions. But only 52.4 per cent actually find the information they need online. Customers want to solve their issues quickly and easily, and providing the right solutions means greater customer retention and revenue streams - but this is sometimes not the case. Download to find out more.
Managing Web Security in an Increasingly Challenging Threat Landscape
Cybercriminals have increasingly turned their attention to the web, which has become by far the predominant area of attack. Those who would do harm to our computer systems for profit or malice always manage to focus their efforts on our most vulnerable weak spots. Today, that is the web, for a wide number of reasons. Download to find out why and what you can do to protect yourself.
Data Centre Physical Infrastructure: Optimising Business Value
To stay competitive in today’s rapidly changing business world, companies must update the way they view the value of their investment in data centre physical infrastructure (DCPI). This whitepaper discusses how companies can succeed in a changing global market. Read now.