A discounting disaster averted at the expense of one's own employment
- Reference: 1651476610
- News link: https://www.theregister.co.uk/2022/05/02/who_me/
- Source link:
"James" is the Regomized reader of record today, and continues the theme of running the risk of doing a job just that little bit too well with an ancedote from the end of the last century involving his first job out of university, at a certain telecommunications giant.
The job involved a process of calculating the discount received by big customers (the ones with multiple branches). "For the life of me I can't remember what the main DB was called," he told us, "but it was the old style green writing on a black screen that took forever to download the necessary data."
[2]
"On the really big clients," he added, "it could [take] 2-3 days with nothing for my team of four to do but twiddle our thumbs."
[3]
[4]
There was, however, a problem. There was no discount. The computers had ground their way through the data but, as far back as the 1980s, the customers had received nothing. "I'm not even sure it stopped working," James confided, "[I] long suspected it was never implemented in the first place..."
The bigger problem was that these customers were beginning to realise that something was amiss, and legal sabres were starting to rattle. The people who had allowed the situation to develop were long since gone and the figures involved?
[5]
"We are talking hundreds of millions here," James said.
What to do? One could heap the blame on the last person to march out of the door or one could try and put things right. James, a freshly minted IT whizz, regarded the mess and set to work, armed with Excel macros and Microsoft Access.
While his duct-tape solution couldn't do much about the download time, it could deal with the rest of the process. A speed increase of between 10x and 20x was recorded and, finally, the correct discounts started flying out of the door to the correct customers.
[6]In IT, no good deed ever goes unpunished
[7]The IBM System/360 Model 40 told you to WHAT now?
[8]IT blamed after HR forgets to install sockets in new office
[9]IT advice fuelled by beer is the best IT advice of all, right?
Disaster averted (although we'll draw a discreet veil over the use of Access for anything more than Christmas card lists and Microsoft's on-stage demonstrations.)
"My immediate management could not stop thanking me," James recalled, "hailing me as some kind of super whizzkid."
[10]
"It was all really quite embarrassing."
So pleased were they that James was offered a promotion from his minimum wage temp job. Instead, he would be placed on a graduate training course and end up at management level a year later, earning vastly more cash.
James's future looked bright. Angry customers had been calmed and discounts were being paid. The hero of the hour, yes?
Not quite.
The largesse of his bosses was spotted by their bosses who, it seems, did not feel quite the same way.
"I was promptly fired, offer withdrawn."
And an important lesson learned, we suspect.
Ever saved your customers millions, only to feel the sole of a hobnailed boot on your behind? Or taken a look at a lashed-together solution and decided that hey – it's somebody else's problem. Or were you the lasher of that solution? Tell all with an email to [11]Who, Me? ®
Get our [12]Tech Resources
[1] https://www.theregister.com/Tag/Who,%20Me?/
[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Ym@r1HiWSYAW0P0H3RnVHgAAAIM&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Ym@r1HiWSYAW0P0H3RnVHgAAAIM&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33Ym@r1HiWSYAW0P0H3RnVHgAAAIM&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Ym@r1HiWSYAW0P0H3RnVHgAAAIM&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[6] https://www.theregister.com/2022/04/25/who_me/
[7] https://www.theregister.com/2022/03/21/who_me/
[8] https://www.theregister.com/2022/03/07/who_me/
[9] https://www.theregister.com/2022/02/28/who_me/
[10] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33Ym@r1HiWSYAW0P0H3RnVHgAAAIM&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[11] mailto:whome@theregister.com
[12] https://whitepapers.theregister.com/
Re: Alarming, fired.
"... as our contract paid a percentage of the overall final cost ..."
No wonder such infrastructure projects always go over budget and way past their schedule.
Re: Alarming, fired.
Yep, cost-plus accounting has a lot to answer for.
I used to work writing user documentation for a software company. But eventually they realised that if the customer looked up the answer to a question in my docs, the company got nothing from that; whereas if they raised a support query, that was billable hours. The job became a lot less satisfying after that.
Re: Alarming, fired.
To be fair I should have known how the job was priced as I was involved in the bid. However even if I'd realised at the time it wouldn't have changed my mind over what to do.
The client may have likely been a one-off customer but the architect who was getting it in the neck from that client was someone we had a solid long standing relationship with and so by helping them we more or less guaranteed ourselves more work in the future. Sure we may lose out a little (still profit) on this contract but profit is profit.
I think the problem was the partners had plans for the slightly fatter cheques they were waiting on, those new company cars would need to wait a few months.
Re: Alarming, fired.
Many years sinceupon, I worked for a purveyor of industrial control systems. We'd won a couple of nice big jobbies which everyone, including the client, acknowledged would have significant scope for changes as the projects unfolded. Change wouldn't be in the architecture, just mainly the size. To give the client's beancounters a dense of prediction, the engineering content was agreed as a fixed % of hardware cost. IIRC 50%.
Simple enough and the project continued with both parties entirely happy.
Then the customer realised there was a shedload of installation hardware from all manner of sources still to ordered. As we had been helpful, seemed to have a good buying support and the fact that the customer was in a bind for handling that part himself, we were asked if we'd be up for a further contract to do his bulk materials purchasing - cable, trays, all manner of bits and pieces.
We were quite happy to do that and agreed. Naturally there had to be a contract and one was duly prepared, which more or less mirrored the existing contracts.
Including how variations were handled.
The moment anything got added to the bought out hardware contract - and there was quite a bit of that was the project evolved - there was an automatic 50% added to cover "engineering".
We were delighted.
Dunno about the client.
Anon cos although it was donkeys years back, someonemight recognise it.
Re: Alarming, fired.
It's a well-known fact (though conveniently ignored when it's not your own money you're spending) that contracts are often (usually) won on the bottom line: many contractors price their tender on the basis of the minimum that meets the bid spec, even if that struggles to meet the cost and irrespective of whether it is actually feasible, and makes profit on the inevitable variations.
Before retiring, I could be asked to take part in bid reviews on major (multi million $) contracts and, despite advising that the work wouldn't meet the actual client requirement, was told to keep quiet and just check that the bid ticked the right boxes on paper. I soon learned that was work to keep clear of as I could later be called back to help clear up the mess. Well paid but not worth the hassle. I wish that had been taught at university as I would have been able to spend more time with my family as the kids grew up. We often learn too late that there's a lot more to life that earning more than we actually need.
Re: Alarming, fired.
Yup. Buy the job then, so long as the contract was set up properly, screw then on variations. Then screw them again on the support contract. Then screw them yet again on any upgrades.
Re: Alarming, fired.
"We often learn too late that there's a lot more to life that earning more than we actually need."
That hit home.
Re: Alarming, fired.
We used to make a product in two versions, 'conventional' and (let's say) 'advanced'. Projects were usually specified in such a way that we could submit two bids; one for exactly as described and a second for an alternative way of completing the same overall task. The consultants would assess the offers and put forward recommendations to the end-user.
Our 'advanced' offer was slightly cheaper in terms of installed equipment but generated massive savings for the end-user as the building structure was much simplified..... but that was in another contractor's scope of supply.
You can guess that the 'advanced' equipment was not ordered as both the main contractor and the consultant were paid on the basis of the overall project cost.
Been there and done that too (I didn't get fired)
Working for a large consultancy company, we had a contract with a large telecoms company to move kit and apps from one DC to another. We seemed to be losing money, so I had a look at the contract. They had a convoluted algorithm which defined the type of servers/apps to be moved and the costs associated - which was produced by a third party and obviously no-one had actually analysed it.
So, I got my handy Exel spreadsheet (no MS Access though) and set up the definitions and then applied it to the servers we had moved or were going to move. It turns out that the telecoms company had applied it wrong and it saved us about £1m - which put us nicely back in profit.
Did I get any thanks or rewards? What do you think? Of course not.
Alan
Oh no, the computer containing all the fixed information that we haven't actually sent out yet just mysteriously caught fire. What a shame.
Sounds like something the BofH and the PFY would cook up.
There is no profit share back to IT experts
All the code we write, the services we maintain, the automation we create, and the efficiencies we make - it all goes to make more money for the higher ups, and IT people continue to be seen as a cost they can't wait to reduce and outsource to India.
Re: There is no profit share back to IT experts
As someone going through this pain right now, a beer.
Division in other side of planet:
(HQ) Mgt: "You have two developers. Cost saving. Sack one"
Local IT manager: "But these guys already can't keep up. We need more resources"
Mgt: "Have x0,000 Dddelloittteee Dollars for support. Sack one" (fictional company, name made up)
... Meanwhile back at the ranch ...
LIM: "Hmmm, Dddelloittteee no longer respond, it's only been a month"
Mgt: "Oh, you used all your Dddelloittteee Dollars"
Last Local Developer: "I will need 80% pay rise due to increased stress AND time in lieu"
Mgt and LIM: "Faaaark"
Excel was said to reveal that the actual savings to the business was as measured in local currency was -100%. (so, 100% higher costs) Productivity reduced to 25% compared to 1 year ago. Customer satisfaction reduced to "statistically insignificant".
Management that makes those decisions deserve all the financial pain they're going to get.
Is this a repeat?
I'm having a bad case of Deja Vu on this one.... Anybody else? Maybe it's just sleep deprivation?
Paris as it's the only icon with a question mark ;-}
I think a lot of us have worked for James's former employer. Too many managers with too little to do roaming the place looking for something they know nothing about nothing about in which they can dabble.
Access is not the problem
The Access DB was. However once you RTFM and discovered you could connect to 'real' databases Access became a really useful tool. Until the other tools in the dept got the yips at anything Access. I modified about 50 or so Access apps around the company once to use the data from MSQL 4.2 via stored procedures so I could modify the DB structure without having to re-write all the apps. After I moved on someone panicked and got rid of the apps and never managed to replace them before the company did something drastic though I know not what as is been totally subsumed by what was a lot smaller company when I was there.
Re: Access is not the problem
You say useful, I say dangerous....
Re: Access is not the problem
It got a bad wrap. It was a really useful front end when you wanted to build something fast to show a client (or your boss). It kept me in coffee and TimTams for a number of years.
The Access back end though... The less said the better.
Alarming, fired.
I once worked as a consulting electrical engineer on a large UK airport upgrade many moons ago, one of the problems we had was the timescales. The client wanted to open early and we just couldn't get the fire alarm system in and tested quick enough.
After speaking to the electricians about the kit we were using I realised we could switch to a more expensive per unit alarm which was far faster to fit. I ran it past the architects and they agreed - it would result in an overall reduction in cost too (as time is money with contractors).
Job completed on time.
I was suspended by my firm for a month and given a first and final warning as our contract paid a percentage of the overall final cost and I'd just accidentally saved the client a fortune.
I left 3 months later to take up a job in IT. Clearly I learned nothing!