There should be no schadenfreude experienced after the news reports of BlackRock accidentally leaking a spreadsheet containing the PII (personally identifiable information) of close to 20,000 independent financial advisors who distribute their iShares products. It can happen to anyone and in fact, it happens all the time.
Creating and maintaining a Model Inventory is simple in concept but much harder in practice. Identifying the existing models to include can be challenging, especially given the fact that the line of business aren’t usually enthusiastic about documenting their model usage. Some model owners would prefer that you just go away, thank you very much. But it’s the “maintain” task that is really difficult. Keeping a model inventory accurate and up to date takes a lot of work. From chasing down various owners and users for updates to reporting on KRIs, it is a thankless job that never ends. Model Inventories are very resource intensive but there is an easier way that is better, faster and cheaper.
Earlier this year, Peter High wrote on Forbes.com about an interview he had with Clay Johnson who currently is the CIO of Walmart. Although the topics of discussion weren’t specific to end-user computing risk management, I found Clay’s lessons learned from his early experience at FedEx to be very applicable to my work focused on Model risk and EUC risk management.
The Prudential Regulatory Authority’s Supervisory Statement SS3/18 concerning model risk management principles is the latest in a long line of financial industry guidance that started with OCC 2011-12, The Federal Reserve’s SR 11-7 and others. Although it is highly focused on the models used for determining capital adequacy (stress testing) in UK banks, and the principles are sound, it is not good news for model risk managers.
Why would a senior executive with strategic responsibilities even remotely think about something so seemingly tactical as spreadsheet risk? Read on: This article discusses a series of recent cases that illustrate how a spreadsheet error can quickly evolve into a material - and public - business crisis.
Two recent articles in The Wall Street Journal reignited the debate between spreadsheet defenders and foes. Excel is perennially derided by software marketers selling replacement solutions, yet its usage continues to proliferate. So we need to ask, why are spreadsheets used so often within critical business processes? More often than not, the smart business decision is to keep those spreadsheets in place.