- The firm’s operational risk team sought to improve control of their spreadsheets as seamlessly as possible.
- The aim was to provide a solution that allowed the organization to make more informed decisions by understanding their spreadsheets and the data within.
- Our ESM platform delivered the improved controls, transparency and reporting oversight sought by Janus Henderson.
- Operational performance & insights were enhanced, with risks mitigated and discussed along with best practice at a monthly operational risk user group.
Janus Henderson identified that a large number of internal processes and functions were tied to and heavily reliant on spreadsheets. The firms’ operational risk team coordinated an exercise to self-identify the use of spreadsheets by department – with the results confirming the pervasive use of spreadsheets and, more importantly, the operational dependencies many processes had to spreadsheets.
From benign checklists and logs to critical business processes and calculations, the review exercise found that spreadsheets had become an integral tool to the business units. However – and most significantly – the operational risk team found that in most cases, the control environment needed to be strengthened.
In light of the review, the business objectives were clear:
- Improve the overall control of spreadsheet usage at Janus Henderson as quickly and seamlessly as possible and increase transparency into the firm’s spreadsheet population.
- Have the ability to apply a uniform set of criteria to look at and evaluate spreadsheets.
- Provide better optics for the business to learn more about where spreadsheets are integrated within the business.
- Implement a solution that would allow the firm make more informed business decisions, including processes that could benefit from wider technology solutions.
Janus Henderson implemented ClusterSeven’s Enterprise Spreadsheet Manager (ESM), as the software solution met the firm’s business objectives in three core ways:
- Improved controls.
- Visibility – the ability to see the spreadsheet universe.
- Reporting & oversight.
In the view of the Janus Henderson team, ClusterSeven distinguished itself from alternative technology or process solutions in a number of ways:
- The tool, and more specifically the ribbon, was highly intuitive to use and non-invasive.
- The Discovery and Spider processes provided additional insight into file structures and relationships, which was unique.
- It provided a one-piece solution as opposed to a modular approach and as such was seen as a product that does what it was billed to do. Additional components or upgrades are not required to meet the needs of the business.
Improved Operational Performance & Insights One Month Post Implementation.
After implementing our solution, it took Janus Henderson only a month to start noticing improved operational performance and insights. Improving the controls over spreadsheets not only had a positive impact on Janus’ risk profile but also its business areas are now more aware of their spreadsheet use on a much larger scale. Other effects include:
- The number of spreadsheets under current active management has been growing as a result of regular interactions with the operational business teams, and the firm plans to introduce the solution to additional segments of the company.
- Spreadsheet owners have the ability to clean up old spreadsheets and understand how the network of spreadsheets can affect other areas of the business.
- A quarterly user group hosted by the Operational Risk team now brings together business stakeholders to talk about data best practice.
- Running risk checks gives the business specific areas of risk to work on and in return gives the organization greater confidence in spreadsheet integrity.
Through the use of the ClusterSeven comparison tool, Janus has been able to leverage the solution functionality to quickly provide updates regarding period over period changes for quarterly reporting. What once was a laborious side by side comparison process is now easier.
In working with us, Janus Henderson sees itself as a leader in implementing such a solution. Through ancillary feedback, the firm believes it is one of only a few companies that have taken a deeper look at the reliance of EUC tools in its organization and found a solution to control and monitor the risk they pose. Janus plans to continue to grow the awareness of spreadsheet risk and expand the use of the ClusterSeven tool to improve its control posture.