4 ms·
Someone tell that to the CEO of the company I worked at last. There were a bunch of undocumented Qlikview reports I was landed with when the CEO decided to fire
by chris_wot 11y ago
Someone tell that to the CEO of the company I worked at last. There were a bunch of undocumented Qlikview reports I was landed with when the CEO decided to fire the IT team who looked after them. We are talking about 35 reports, each in a ridiculous state where you would need to literally modify some date variables and comment out some fields in a load statement, and ensure that the old data was loaded out of a QVD file, new data appended to the end and then the data reloaded into that same QVD file after clearing the file. In short, it worked but an utter disaster and virtually impossible to maintain.
Luckily the CEO kept the lady who sort of knew the procedure for several months, but due to fire fighting dozens of different issues I never really got the chance to fully find a better solution. Luckily, I worked out enough to understand the general principle when this lady left.
Fast forward to my old manager burning out after 4 weeks and me firefighting for several months while the lady the CEO kept around maintained the reports. A new manager, let's call him DW for short, comes in claiming expertise in Qlikview. He works on his reports whilst I work on other important issues.
After 4 weeks a client services colleague asks when her Qliiview dashboards will be fixed. This is news to me, the old maintainer has apparently explained the process in detail to my new manager, and although I've offered DW my help to go through the process he waves me off telling me other work is more important.
DW is in lengthy meetings that day, so I take a deep breath and open said horribly put together but working Qlikview report. Sure enough, data is wrong and virtually no graphs even display. I look at the load script, which sadly relies as part of the procedure an Excel spreadsheet lookup in the mapped drive, which we have standardised to S:. I notice it is now pointing to a mythical Z:. Then I look for the load scripts that work out pending work... gone. Sales data load script statements - gone. You name it, it has been changed. There is no documentation anywhere - not even to explain what Z: points to.
I take a deep breath and wait for my new manager to return. I'm not looking forward to asking about this - he's already stated in front of my other colleagues that "Actiobs speak louder than words" when I explain what I'm working on, and when he asks for a technical explanation about a system issue I know about he tends to cut me off half way through the explanation.
Turns out, he has been "tweaking" and "automating" the reports on live production. In the process he hasn't documented anything and the Z: maps to a Windows share on his laptop. In the process he has literally broken every single Qlikview dashboard through his changes, and he has neglected to even make backups.
I have been working the last two weekends and evenings from home (often till 11pm and later) to fix another more specialised report for a multimillion dollar contract - mainly because day to day operational issues don't allow me any time to fix this complex report - and I'm pretty much at burnout stage. I tell said manager I can't do any more weekends with no break. DW has other ideas and on my third weekend in a row I arrive at 10:30am at the office, rebuild the first report (luckily the basic data schema for each report is similar) which I intend to use as a basis for the 15 other broken reports I've been told are critical to get working, tangle the black box that is the wield semi-pivoted row based data schema of the custom corporate app we use to gather the data, rebook up the dozens of graphs, tabular forms and other odd graphs driven by strange Qkiview expressions and leave at 4:30ammthe Subday morning. Exhausted, I fall asleep at 5:39am, then wake up at 10:45, serve into work, attempt to get the rest of the reports done, but instead get chewed out by my manager and a "project manager", who schedules in a meeting with himself and the CEO the heat day. Rather dumbstruck, I ask to get back to fixing the rest of the reports, they agree then when I leave the room I hear them jovially joking around.
I go back to my desk in shock. I think about the situation for ten minutes, then close down all the Qlikview dashboards I'm working on, load up Word and draft a polite resignation letter which I email to the CEO, then print and out on the CEO's desk.
The next day, to the horror of my two colleagues (not my new manager) the CEO pays me out 4 weeks and I leave, never to return.
Fast forward 6 weeks - Mr Qliiview expert has made things worse, refused all offers of help, and eventually resign apparently largely blaming myself all the way.
Now 6 months later the CEO has only 3 clients left and is haemorrhaging money.
I smile and get on with my life.