You are currently browsing the tag archive for the ‘data’ tag.

The proliferation of chief “something” officer (CxO) titles over the past decades recognizes that there’s value in having a single individual focused on a specific critical problem. A CxO position can be strategic or it can be the ultimate middle management role, with far more responsibilities than authority. Many of those handed such a title find that it’s the latter. This may be because the organization that created the title is unwilling to invest the necessary powers and portfolio of responsibilities to make it strategic – a case of institutional inertia. Or it may be that the individual given the CxO title doesn’t have the skills or temperament to be a “chief” in a strategic sense.

In business, becoming a chief anything means leaving behind most of the hands-on specific skills that made one successful enough to receive the promotion. This is often the hardest requirement, especially for those coming from an administrative or a highly technical part of a business. Take the chief financial officer position. The person who gets that job often was a controller – an individual who must be able to manage the minutiae of a finance organization. Most of the detailed skills required of a great controller are counterproductive for a CFO, who must focus on the big picture, work well with all parts of the business and be the face of the company to bankers and investors. People who can’t leave the details behind are by definition not strategic CFO material. Similarly, the job of the chief information officer ultimately is not about coding, technical knowledge or project management. It’s about understanding and communicating how the most important issues facing the business can be addressed with technology, ensuring that the IT organization understands the needs of the business and delivering value for the money spent on IT.

The same distinction applies to newer C-level titles. For example, since the financial crisis a few years ago, there has been a growing recognition that banks must manage risk more comprehensively. In response, a number of banks have created the position of chief risk officer or, if they already had one, have invested a broader range of responsibilities in that office. Managing risk strategically has gained importance in financial markets as rising capital requirements and increased regulation force banks to structure their asset portfolios and manage their assets more carefully to maximize their return on equity (ROE). In most banks, optimizing risk – getting the highest return at any given level of risk – and managing risk more dynamically over a credit cycle requires a strategic CRO to lead the effort. Even so, in many organizations the office of the CRO doesn’t have the weight it needs to make such a difference. Here are the most important requirements for chief risk officers who want to transform a middle management job into something more strategic.

Approach risk management as if it were a four-dimensional chessboard. Having the proverbial “seat at the table” (a hackneyed business phrase that’s shorthand for being taken seriously by the senior leadership group) means being able to bring something of value to the table. While an appreciation of the overall business and its strategy is necessary as one rises through the ranks, a purely functional position usually doesn’t require an especially deep understanding of the other parts of the business. For a chief risk officer to play more than a titular role, however, he or she must have a solid understanding of all the major operating pieces of the business on both sides of the balance sheet and a knowledge of the industry’s competitive dynamics – three dimensions of the chessboard. This is particularly important because risk is just a constraint, not the sole consideration in decision-making. That is, the role of the CRO is not simply to enforce constraints that minimize risk – it’s about optimizing risk within the context of the corporate strategy. Stiffer capital requirements are a defining characteristic of today’s banking industry, especially in the United States. Optimizing risk is a necessary condition for optimizing return on equity and the long-term success of the bank. Moreover, the role requires thinking ahead several steps and understanding the dynamics of the business – that’s the fourth dimension. A solid grasp of credit and financial market cycles is essential in leading a risk organization. The ability to use past experience to forecast the consequences of even disparate sets of actions makes the risk organization strategic.

Learn another language. Understanding of other parts of the business goes a long way toward being able to work more effectively, and a CRO should be to translate risk jargon into words and concepts that are relevant to specific parts of the business. It works both ways, too. Understanding the objectives, objections and concerns of other executives means being able to grasp the nuances of their questions and comments. It also helps in explaining the thinking behind the trade-offs necessary to optimize a balance sheet to achieve an optimal ROE for the level and structure of the risk. It’s also essential to be able to communicate the essence of risk management to laymen, for example, by distilling the complexities of a black-box risk strategy into an elevator pitch. All risk models are translatable into easy-to-comprehend concepts. A CRO must be able to do this and even develop an institutional shorthand within the organization that everyone understands – the functional equivalent of describing a feature film as “a car-chase buddy movie.”

Assert leadership when it’s needed. Some leaders are born, but everyone else needs to unlearn habits that detract from their effectiveness as a leader. People in risk or compliance roles may have a harder time than others because the basic skills necessary to excel in this area tend to be found in less introspective souls. Those who work in a compliance function can fall into the trap of using “the rules” as a cudgel for wielding power rather than persuading and gaining assent. Joining the senior leadership team, though, transforms the CRO from a simple enforcer to one who works with others to find solutions.

Beyond these three personal and interpersonal requirements, appropriate use of information technology – data and software – is essential to strategic risk management in banks (and other financial services companies). Successfully exploiting the advantages that can be had with advanced IT is fundamental requirement of making the role of a CRO strategic. SuccessfulCROs must weigh the make-or-break information technology issues of mastering data quality and using the right software tools.

Data is the lifeblood of risk management. The credibility of the risk organization is based on accuracy and availability of data. Bad data drives bad decisions and undermines the authority of the risk organization. As data sets proliferate, grow larger and increasingly incorporate external data feeds (not just market data but news and other unstructured data), the challenge increases. The proverbial garbage-in-garbage-out (GIGO) becomes Big GIGO, as I have written. vr_infomgt_06_data_fragmentation_is_an_issueData quality must be built into all of the systems. Speed in handling data is essential. The pace of transactions in the financial markets and the banking industry continues to increase, and their risk systems must keep up. Our benchmark research shows that financial services has to deal with more sources of data than other industry sectors.

Yet beyond these maxims is the reality that all large financial institutions fall short in their ability to handle data. “You can have your answers fast or you can have them accurate,” is often said in jest, but it reflects the business reality that analyses often are not black-and-white – utterly reliable or completely false. They may have to be based on information that to varying degrees is incomplete, ambiguous, dated or some combination of these three. Adapting to this reality, new tools utilizing advanced analytical techniques can qualify the reliability of a bit of analysis. It’s better to get some assessment and see that it’s 33 percent reliable than to get no answer or – worse – get an answer without qualification. In most cases, it’s better to get an approximate answer now than to wait for an ironclad answer in a day or two. The decision-makers have an idea of the risk they’re taking if they act on the result, or they can take a different approach to look for a way to get an answer that is more reliable.

Software is essential to risk management and optimization. Technology can buy accuracy, speed, visibility and safety. Many banks ought to do more dynamic risk management. Analytical applications using in-memory processing can substantially reduce the time it takes to run even complex models that utilize very large data sets. This not only improves the productivity of risk analysts but it makes scenario analysis and contingency planning more accessible to those outside the risk organization. If you can run a complex, detailed model and immediately get an interactive report (one that enables you to drill back and drill around), you can have a business conversation about its implications and what to do next. If you have to wait hours or days as you might using a spreadsheet, you can’t.

Desktop spreadsheets have their uses, but in risk management the road to hell begins in cell A1. Spreadsheets are the right tool for prototyping and exploratory analysis. They are a poor choice for ongoing risk management modeling and analytics. They are error-prone, lack necessary controls and have limited dimensionality. The dangers of using spreadsheets in managing risk exposure were laid bare by the internal investigation conducted by JP Morgan, which I commented on at the time. There are many alternatives to desktop spreadsheets that are affordable and require limited training. For example, many financial applications for planning and analysis have Excel as their user interface. There are more formal tools, such as a multidimensional spreadsheet, that are relatively easy for risk modelers to use and offer superior performance and control compared to desktop spreadsheets.

Automate and centralize. Information technology delivers speed, efficiency and accuracy when manual tasks are automated. The payoff from automating routine reporting and analytics may seem trivial, but this is usually because people – especially managers – underestimate the amount of time spent as well as the routine errors that creep into manual tasks (especially if they are performed in a desktop spreadsheet). The need for automation and centralization especially applies to regulatory and legal activities, such as affirmations, attestations, signoffs and any other form of documentation. Especially in highly regulated industries such as financial services, there is no strategic value in meeting legal requirements, but there is some in doing so as efficiently as possible and limiting the potential for oversights and errors. Keeping all such documentation in a central repository and eliminating the use of email systems as a transport mechanism and repository for compliance documentation saves time of highly compensated individuals when inevitable audits and investigations occur and limits the possibility that documents cannot be found when needed.

Senior executive sponsorship is also a critical need if the chief risk officer is to be a strategic player. If the CRO has done all of the above, that’s not going to be a problem because the CRO’s objectives and the CEO’s objectives will be largely aligned. True, that’s not always a given. Some organizations will not embrace the notion that managing risk can be strategic. CROs who find themselves in an organization where their aspirations to serve a strategic role are not met should find another one that appreciates the value they can bring to the table.

Regards,

Robert Kugel – SVP Research

Reconciling accounts at the end of a period is one of those mundane finance department tasks that are ripe for automation. Reconciliation is the process of comparing account data (at the balance or item level) that exists either in two accounting systems or in an accounting system and somewhere else (such as in a spreadsheet or on paper). The purpose of the reconciling process is to identify things that don’t match (as they must in double-entry bookkeeping systems) and then assess the nature and causes of the variances. This is followed by making adjustments or corrections to ensure that the information in a company’s books is accurate. Most of the time, reconciliation is a matter of good housekeeping. The process identifies errors and omissions in the accounting process, including invalid journal postings and duplicate accounting entries, so they can be corrected. Reconciliation also is an important line of defense against fraud, since inconsistencies may be a sign of such activity.

But let’s be frank: The reconciliation process is tedious. As for all tedious processes in modern corporations, it makes sense to let machines do this work. Reconciliation is a part of the accounting close process, and one of the main benefits of automation here is that it can accelerate the process. This is important because our benchmark research on closing finds that it’s actually taking longer for companies to close their books than it used to. The research also shows a correlation between the degree of automation in the close process and the time it takes to complete it.

vr_fcc_financial_close_and_automation_updatedBack in the days of quill pens and blotters it might have been manageable to meticulously comb through accounting entries. Today, however, volumes of data are too great to make this realistically feasible, and technology provides accountants with faster and more effective means of spotting patterns and familiarizing them with the peculiarities of the company’s books. For CFOs and controllers who are trying to determine how to begin the process of transforming their department to make it a more strategic player in their company, here is a way to free finance staff to do more productive tasks.

There are three important virtues associated with automating reconciliation. The first is consistency: Business rules, policies and procedures are applied consistently in ways that are in line with accounting policies that external and internal auditors accept. Machines are more reliably consistent than humans in such tasks. The second virtue is elegance: Automated systems simplify the process while making it faster and more accurate. They enable auditors to focus their time and attention on the most important issues that arise from the process. The ability of automated systems to highlight exceptions eliminates the need for random sampling, which both consumes time and poses the risk that something important will go unnoticed. The third virtue is efficiency: Automated systems enable a company to substantially reduce the amount of time needed to complete the reconciliation of accounts because the system performs the purely mechanical tasks and skips the accounts in which there has been no activity or in which the amounts to be reconciled are too small to be material. These systems also reduce the time internal and external auditors need to check reconciliations because all of the work is centralized in a single system and because the system and its configuration functions as a higher level of control in the reconciliation process that’s easy to test and monitor.

Despite these obvious virtues, most companies don’t use such capable automation. The majority manage reconciliations in spreadsheets shared through email. Electronic spreadsheets were a major advance decades ago. Today, however, they are not the best choice because the information they contain is fragmented, difficult to consolidate, hard to share and prone to error. Running this process with spreadsheets and email is more difficult and time-consuming to manage and control than using a dedicated reconciliation application. A well-designed dedicated application assigns ownership of every task to individuals and provides real-time visibility into which parts are on schedule, which are behind and which may be in danger of falling behind schedule. These systems employ templates that are centrally controlled to ensure consistency and quality. The templates can be updated as needed. A spreadsheet may start as a template, but it’s difficult to control them, even with protections built in.

Documentation is another weak spot in spreadsheets shared through email. Although there are objective aspects to the reconciliation process, those performing it ultimately must use their judgment. These judgments must be supported by narratives and calculations that clearly and completely explain the decisions each person made and by citing supporting documents wherever necessary. A related aspect is approvals, since good governance and control of accounting systems requires that someone inspect and approve the work of others when their actions (or lack of action) can have a material impact on the quality and accuracy of financial statements. So another important element that a dedicated reconciliation system can provide are approval workflows to ensure that the work has been completed before the books can be closed.

Automating reconciliation can be a first step in creating a virtuous cycle. Many executives in finance organizations would like to improve the performance of their department but face the challenge of finding the time to devote to such efforts. The staff time that can be saved through automation can be reinvested in finding the root causes of other issues that bog down the department and fixing them. Automating reconciliation can accelerate the financial close, improve productivity, reduce errors and the related possibility (albeit limited) of financial misstatements, enhance control and diminish the risk of financial fraud. These are reasons enough why all midsize and larger corporations should investigate the benefits of dedicated reconciliation software.

Regards,

Robert Kugel – SVP Research

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 61 other followers

Twitter Updates

Blog Stats

  • 62,607 hits
Follow

Get every new post delivered to your Inbox.

Join 61 other followers

%d bloggers like this: