Getting the financials right
- 27 December, 2013 09:00
Matt Toohey, CIO, iiNet
Demand for timely financial reports has lead ASX-listed Perth Internet service provider (ISP), iiNet, to ditch manual processes in favour of automated reports.
The ISP selected NEC to implement an IBM Cognos TM1 and business intelligence (BI) offering in May. “It was taking too much time to generate departmental, monthly, half yearly and annual reports,” said iiNet CIO, Matt Toohey.
“Analysing historical data was a time consuming process with information pulled from several different data sources, and the preparation and consolidation of monthly financial results was largely manual.”
The budgeting process also required multiple inputs and spreadsheet consolidation, meaning changes were slow and potentially error-prone. In addition, rolling forecasts were difficult to produce, with little scope for scenario planning or version control.
“Data integrity, budgeting, forecasting and reporting were our four main business issues, and it was clear future acquisitions and organic company growth would only make the limitations of our systems worse,” Toohey explained.
Since the implementation, the ISP’s finance team has been able to obtain and analyse old data much more quickly. Staff can also share results using a Web-based tool, while monthly financial reporting to the board is now automated.
According to Toohey, Cognos was selected because of its ease of use and ability to work with all of iiNet’s data sources.
“The BI team is introducing company-wide self-service reporting using Cognos as well as a number of advanced predictive data models to fight churn and optimise marketing campaigns,” he said.
“The main benefits sought from the business improvement team were to lower marketing costs through targeted, direct marketing capability.”
Self-service reporting is aimed at lowering operational overhead costs by “putting the power back” into the users' hands, without the need for information services intervention. Toohey added this also provides efficiency within the iiNet group to obtain information faster and in customised formats to match the situation.
“The entire staff of 2000 workers will benefit from the reporting and dashboard capability of Cognos including finance, marketing, business improvement, information services and human resources,” he said.
According to Toohey, the company took a calculated risk in choosing NEC to do the implementation, as the vendor had no customers in the IBM enterprise space in Western Australia at the time.
Two key factors drove the decision. Firstly, there was a clear sense of “genuine buy-in” from senior management at NEC to achieve the implementation on cost and time, he said.
“Secondly, the per day cost of resources NEC committed to as a once-off for this project was significantly cheaper than competitors. This reinforced our views of the company’s commitment to this project and working with iiNet,” Toohey said.
Working directly with the iiNet finance team, NEC conducted an assessment of the scenario and proposed a phased design and implementation. Budgeting and forecasting was completed in the second phase.
The detailed distributed planning application was activated with budget data collection, workflow control with integrated security assignments and monthly rolling forecasting processes.
iiNet has automated processes for subscriber revenue, operational expenses, capital expenditure, depreciation/amortisation, working capital/debt modelling and tax calculations.
The third phase was integration of the BI solution, running on top of other financial data delivered by the earlier projects, which automatically generates most of the financial month-end reports that were previously complied manually. Toohey said the shift from manual spreadsheets to automated reports means staff can now trust the integrity of company data.
iiNet financial controller, Ben Jenkins, said there was “a lot to learn” with the new platform, so getting the right training from NEC was important to ensure employees were making the most of Cognos reporting.
“NEC kept members of the project team onsite after the platform went live and was available to answer questions and help us with any problems. This saved us time and helped us get up to speed with the system quickly.”
Jenkins’ advice for other CIOs when dealing with two vendors on a project is to establish a strong relationship with all parties. “This lowers program risk and maximises engagement output between vendor, supplier and company. You should also apply ownership when the vendor is a recommended partner of the supplier,” he said.
“Make sure the supplier understands that you are using the vendor on its recommendation. This creates a reputational responsibility for the supplier to ensure delivery from the vendor is in everyone’s best interests.”
iiNet also uses IBM technology to support its database environment including storage, network, servers and operating systems. The vendor’s SPSS modeller is used for BI predictive modelling.
Continues over page
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)
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
PCI DSS v3.0 - Compliance Guide
Due to a lack of consumer confidence and a subsequent drop in sales, all entities that handle credit cardholder information are being challenged to adopt more effective data protection measures. This paper provides information on available tools to help validate compliance with the latest version of the Payment Card Industry Data Security Standard (PCI DSS).
Research firm Radicati names Google Apps for Business the leader in cloud business email
Radicati Market Quadrants illustrate how individual vendors fit within a specific technology market, classifying them as niche specialists, up-and-coming pioneers, today’s top players or yesterday’s leaders. In August 2013, Radicati used this model t o assess and compare 14 cloud business email providers, including Google.
Migrating from BlackBerry? See Our Trusted Method.
Are your business leaders demanding a migration plan from BlackBerry? Let the mobile experts at Good help you migrate without migraines. Our Professional Services team has deep experience supporting Fortune 500 organizations through the transition; read this sample planning chart and see our trusted method.