Automating the Key Man

It's insane to me how much vital work is conducted via a Microsoft Excel spreadsheet—just one person sitting in the back office compiling the data that will either ensure success, or doom the firm to failure.
The other day I was out having a drink with a contact who works for the US arm of a major international investment bank. His boss put him in charge of developing an Excel spreadsheet that details some of the firm's operations. (Since it's not pertinent to this discussion, I'll leave out what exactly it's used for.) He's not a developer, but he's young and had been educated in front of a computer, rather than with a pencil and loose-leaf paper, so he was the natural fit.
He said that he intentionally made the program complex because he had no intention of spending the rest of his days at the firm. So, essentially, this was something of an insurance plan. "I hope to one day leave and they have to hire me back as a consultant," he boasted.
Ah, the perils of key man risk. Give him enough rope and he'll hang ya.
Earlier this week I met with Bonaire Software Solutions CEO Christopher John. His firm works in the niche space of revenue management and fee billing software. This is one of those jobs that as of a few years ago was likely done manually.
John says that as a result of the financial world meltdown that hit its zenith in late 2008, asset managers are now much more concerned with automating previously manual processes. When I ask him whether this trend will continue once the good times return, he says he believes it will because it's a measure of success, for these firms, to see how much they can automate.
Fair enough. Besides, if you've already begun the process of automation it's highly unlikely that you're going to go back to manual. But the point is this: If you're not making the move now, what exactly are you waiting for—Steve over in accounting to quit and leave you in the lurch?
More on Trading Tech
Doing a deal? Prioritize info security early
Engaging information security teams early in licensing deals can deliver better results and catch potential issues. Neglecting them can cause delays and disruption, writes Devexperts’ Heetesh Rawal in this op-ed.
Google gifts Linux, capital raised for Canton, one less CTP bid, and more
The Waters Cooler: Banks team up for open-source AI controls, S&P injects GenAI into Capital IQ, and Goldman Sachs employees get their own AI assistant in this week’s news roundup.
Waters Wavelength Ep. 323: MarketAxess’s Chowdhury and Burke (plus some Cusip updates)
This week, Riad Chowdhury, head of Asia-Pacific, and Dan Burke, global head of emerging markets at MarketAxess, join to discuss block trading in fixed income. Plus Reb discusses her recent article about Cusip and updates on the class action lawsuit moving through the courts.
As datacenter cooling issues rise, FPGAs could help
IMD Wrap: As temperatures are spiking, so too is demand for capacity related to AI applications. Max says FPGAs could help to ease the burden being forced on datacenters.
WatersTechnology latest edition
Check out our latest edition, plus more than 13 years of our best content.
Deutsche Bank casts a cautious eye towards agentic AI
“An AI worker is something that is really buildable,” says innovation and AI head
LLMs are making alternative datasets ‘fuzzy’
Waters Wrap: While large language models and generative/agentic AI offer an endless amount of opportunity, they are also exposing unforeseen risks and challenges.
Trading venues seen as easiest targets for Esma supervision
Platforms do not pose systemic risks for member states and are already subject to consistent rules.