Monday, August 31, 2020

Cleaning up - the aftermath

IBM has been gone for a month or so now. Some of their handiwork has become apparent not just in the reverse KT sessions, but in what was NOT transferred.
In our "successful" transition to SAP, someone from Deloitte dropped several balls and missed doing 2 important reports. One being more critical than the other. They managed to slap something together in eHana which really didn't need to be done. To complicate things, this became a 2 part process where I loaded data and they reported it on a schedule that assumed it was there.(and sometimes it wasn't)

THEN, to make matters worse, they depend on SAP tables that they shouldn't depend on which restrict data and no one knows who maintains those tables. Then, Deloitte's contracts ends and they "hand" it off to the Business Intelligence group which has no clue what this does or how it works.

On the other report, IBM had (without talking to me) created an SSIS package and SSRS reports and scheduled them. They did a little KT at the end, but what was done was mostly useless as they used horrible naming schemes, left things in staging tables but used them as production, and scheduled reports to run under their own userid which expired right after they left. What a mess!

Sunday, March 1, 2020

Running. Resume in hand

The end is near and the contractors see it, so they are running with resume in hand and taking whatever knowledge they had with them.
A year ago, one of them was let go for cost saving and the documentation I was given was extremely outdated. When drilling down on questions I got non-answers or contradictory ones. Support had to go one and it got very difficult.
So the mainframers are nice guys and they are what's left (thought not all). They will remain through the SAP transition to archive stuff, but that's it.
So the bigger question surround the SSIS guys. One of which is pretty useless. No one seems to have a good handle on what's happening with them except that they will be removed from the account.
I've been told that their work will go to someone else, but no news on that. My guess it will go to the same guy who doesn't support the stuff he's supposed to now.