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.
How to Switch From iPhone 5S to BlackBerry Z30 (and Why)
CIOs to Become In-House Brokers -- and That's a Good Thing
The future of computing
10 Hot Hadoop Startups to Watch
The future of computing
Journey to the Future-State framework
Defining the future role and cataloguing the competencies that would take CIOs there was only the first step. In 2009 Council members pushed for more – they wanted to help the IT profession make the journey from Functional Head (where IT is inevitably viewed as a cost centre) to a Business Strategist (where IT is externally focused and viewed as an organisational ‘game changer’). Although a single prescription for advancing the role is impossible because CIOs circumstances are all different, members wanted a general roadmap and guidelines.
Secure by design - How to dramatically simplify data protection, access control and other critical security tasks
This white paper examines how you can dramatically reduce the effort required to protect mission-critical information, while giving users fast, simple, flexible remote access that enhances business productivity.
Top 20 Critical Security Controls - Compliance Guide
Simply being compliant is not enough to mitigate attacks and protect critical information. Organizations can reduce chances of compromise by shifting away from a compliance-driven approach. This guide provides the Top 20 Critical Security Controls (CSCs) developed by the SANS Institute to address the need for a risk-based approach to security.