We remember spending hours (if not days) each month in mind-numbing tedium as junior analysts, producing regular reporting for our business lines. The recurring exercise had us piecing together data from various sources, manually updating Excel files and praying fervently that none of the associated formulas got corrupted along the way. Excel would generate new graphs, which we transferred over to PowerPoint, and, more often than not, further manipulation would be required to fit them into the approved templates to avoid formatting glitches. Copy-Paste was both our dearest friend and greatest foe.
That was many years ago – exactly how many, I hesitate to say. Regardless, we can agree that reporting was and always will be a fundamental part of the financial services industry. Scroll forward to present day and we find that analysts are still struggling with the same old song and dance. The key difference, however, is that regulators have started taking notice and demanding change.
Case in point: A Top 30 bank was struggling with outdated methods of producing more than 100 recurring risk reports in a compliant fashion. Analysts were spending valuable time navigating manually updated spreadsheets, calculations and presentations to compile reporting instead of driving business insights to better manage risk.
Spinnaker introduced the strategic use of automation to streamline reporting for the bank’s first- and second-line risk organizations. Through partnerships with key stakeholders, we assessed reports based on criticality, complexity, data availability and suitability for automation to prioritize the automation backlog. In that process, we identified opportunities to eliminate overlapping metrics and reporting, and align intent across business lines.
We worked with SMEs to map data to its strategic source, fixing errors that had occurred over time as information was moved from legacy systems. We tapped into our deep financial analytics skills to recommend and implement meaningful Tableau visualizations. Finally, we tested and validated new reports before retiring earlier processes and provided guidance for future evolutions in the reporting suite.
Spinnaker delivered a rigorous, repeatable reporting process that leaders trusted to ensure the bank meets regulatory requirements. We cut the number of reports and metrics by as much as 70%, drove consistency across product lines and reduced the ongoing cost to produce the information. Armed with a system that automatically delivers the latest reporting, analysts can now focus their valuable time on value-added insight generation.
While leadership sleeps well at night knowing their reporting suite is reliable and the regulators are satisfied, front-line analysts are doing happy dances, too. Having walked in their shoes, we can’t blame them!
“Feel free to add in my personal thanks for this. There are all kinds of efforts toward automation these days. This is the only one I can think of that is actually truly helpful. You guys are saving me a ton of tedium!”
- Front-Line Report Owner
Click for a copy of our Business Analytics and Data Management case study to find out how Spinnaker helped our client streamline, automate and improve its risk reporting within a tight regulatory deadline.
Content plays a central role in your ongoing development as a leader, as we discussed in a recent Spinnaker blog “The 3 Cs of Personal Leadership Development.” In honor of National Book Lover’s Day, today Spinnaker’s leadership team shares a peek at a trio of books that caught our attention, and whose leadership lessons we think are worthy of yours.
Executive Leadership Coaching 3 minute read
The Big Picture Regulations might be written in black and white, but how they are interpreted is up to bank leadership. In the case of a Top 30 bank, its interpretation of the Military Lending Act meant that it could not allow active military members in collections to pay by remotely created checks (RCCs). However, ongoing operations monitoring revealed that a third-party supplier, intended to help take online payments, was at times generating checks that were out of compliance.
Data & Analytics, Change Management, Compliance 1 minute read
The Big Picture Whether we’re talking about a policy or the processes your bank has put in place to support its intent, the connection between the two often erodes over time.
Data & Analytics, Risk Management & Regulatory Compliance, Change Management 1 minute read
Like how we think? Subscribe to have our articles delivered direct to your inbox each month.
Headquarters: 8000 Franklin Farms Drive, Suite 100, Richmond, VA 23229
©2022 Spinnaker Consulting Group. All rights reserved.