How Master Data Management Unified Financial Reporting at Nationwide Insurance
As Nationwide grew, its data became siloed and scattered, making it increasingly difficult for the company to get an accurate picture of its finances. Here's how it brought all that data into focus.
Fri, December 21, 2007
CIO — In a span of three short years, between 2000 and 2002, Nationwide Insurance got a new CEO, CIO and CFO. Jerry Jurgensen, elected by Nationwide's board in 2000 to replace the retiring CEO, was hired for his financial acumen and his ability to transform a business's culture.
Michael Keller was named the company's first enterprisewide CIO the following year. He had 25 years of IT experience managing big infrastructure and systems integration projects. In 2002, Robert Rosholt replaced the retiring CFO and joined the others in Nationwide's Columbus headquarters, bringing along deep experience in all things financial.
The three were old buddies who had worked together at financial giant Bank One. Now they held the reins at Nationwide and their goal was to take its dozens of business units, selling a diverse set of insurance and financial products, to a higher level. In 2001, Nationwide was profitable to the tune of $138 million and board members had billion-dollar aspirations for that line item.
But to get there, Jurgensen needed financial snapshots of how Nationwide was doing at any given moment. And getting them wasn't so easy.
In fact, it was almost impossible.
The Fog of Finance
"When you're dealing with 14 general ledger platforms and over 50 applications," Rosholt says, "it was enormous work to get the financials out."
The problem lay knotted in a tangle of systems and applications, and some 240 sources of financial data flowing in and around Nationwide's business units. The units had always run independently, and that's how financial reporting was handled. "There was a variety of [financial reporting] languages," Rosholt says, which affected Nationwide's ability to forecast, budget and report. "It was difficult," says Rosholt, to ask, "How are we doing?" Keller's situation was no better.
"One of the first questions I was asked when I joined was, How much money do we spend, total, on IT?" Keller recalls. "The answer was, we didn't know. It took weeks to put that answer together."
Headquarters: Columbus, Ohio
Revenue: $160 billion in assets; $21 billion in annual revenues
CEO: Jerry Jurgensen
CFO: Robert A. Rosholt
CIO: Michael Keller
IT Employees: 5,500
Focus Project Fast Facts: 280 team members worked 1.2 million man hours (including overtime) over 24 months
Jurgensen wanted to be able to run Nationwide as if it were one unified enterprise. He wanted, in Rosholt's words, "to do things that are common, and respect the things that are different. And that was a big change." Indeed, the transformation the company embarked upon in early 2004 was dauntinga master data management makeover that would alter how every Nationwide business reported its financials, how accounting personnel did their jobs, how data was governed and by whom, and how the company's information systems would pull all that together. The goal was simple: one platform; one version of the financial truth. Simple goal. But a difficult challenge.