Novopay Technical Review for Dummies
I’ve worked on “enterprise grade” software for a large chunk of my career. Do not get me wrong: I could not build a payroll system capable of running the NZ School payroll without error, but I do know a grade-A clusterflop* when I see one.
LATEST: Datacom working on spec
This post attempts to cut through some of the veiled (albeit admirably blunt as far as political documents go) language in the Novopay Technical Review (heretofore known as the NTR)
Bear in mind: the NTR is focussed specifically on the current situation and how to get out of it, not how we got here. However based on the findings, it’s pretty easy to see some of the how.
So, let’s run through the “key findings” and break those out:
1. In some areas system functionality does not adequately support the business processes.
The system, as built, does not do what it was meant to do. This could be because the requirements were poorly documented from the outset (probably), but also because the system is an “off the shelf” system that has been “customised” to meet the requirements.
At some point, a decision would have been made that the “off the shelf” software was an 80% (or 70% or 90%) fit for requirements, and the rest could be built as customisations. Hold that thought and read on.
2. Usability issues and lack of data input validations contribute to processing errors.
To me, this is the most egregious finding. As I understand it, the entire purpose (or at least a key selling point) of Novopay was to reduce costs by moving from Datacom’s human-intensive workflow to a system whereby schools do all the data entry, and the “system” just needs to calculate pay.
For a system like this to work, a massive amount of time and focus has to go into usability of the front-end system. Later on in the review there are comments about tab keys not working properly, and links between pages of the same input form not working. This is fundamental stuff, and points to Talent2 and ALESCO not giving a flying fish* about end-users.
This, while fairly typical of an “enterprise” system build on Oracle Forms, is completely unacceptable if it’s so utterly important that data is entered correctly and quickly. It is an absolute core failure of a system intended to be user-driven.
As an aside: this is what “enterprise” software users work with every day. Usability and User Experience are pretty much dirty words, with SAP and Oracle making their money from systems that are actively hostile to end users.
3. School management visibility and control is limited by reports that are sometimes poorly presented or inconsistent.
See above.
4. Data quality has been affected by system issues, raising the risk of future errors.
Sh*t’s gone bad, which makes future sh*t worse. There’s a comment later in the report that data integrity is often managed by code, rather than by database constraints. Not inherently evil when done for the right reasons, but this sort of code approach more often than not points to coders that don’t understand the underlying system.
Think about a situation where your pay has been calculated incorrectly, then fixed up by a manual adjustment, what happens when the pay calculation is fixed? Does your tax liability for the year include the adjustment?
10 points if you answered “I have no f'ing idea”. Perhaps we just cross our fingers? With no test suite there’s no way to know.
5. Quality controls on data entry have not adequately prevented errors.
Too much reliance on the computers, not enough overview by experts.
6. A high degree of customisation in high-impact areas has made on-going development more difficult.
This is another one that really sets my alarm bells ringing. Talent 2 sold Novopay to the government as an ALESCO system with some customisation (see point 1). This is the dirty not-so-secret of any “out of box” enterprise software installation: the base system is next to useless without massive amount of customisation.
More often than not, when you add up the cost of an “out of box” solution PLUS the required “customisation”, a greenfield development fine-tuned to your own requirements becomes a much more comparable solution.
In the case of Novopay, the core system itself has been “customised”, which makes a complete mockery of the “out of box” solution. Expect upgrades to come with significant pain. Also expect ALESCO to wash their hands of any errors because the system is no longer “as-sold”.
7. Aspects of the application architecture make customisation difficult.
See above.
8. Service support processes have struggled to manage the volume of issues.
Sh*t's gone so bad that Talent2 don’t have the people or expertise to get it under control. Expect the costs to continue to escalate while the government throws money at a solution.
Conclusion
Like I said on Twitter: Novopay appears to be the wrong solution sold by people with a poor understanding of the problem, implemented with the typically lax approach of enterprise software development.
In other words, pretty much business as usual for Enterprise IT.
If you think this thing has run its course, you’re kidding yourself. I’ve seen Oracle systems quoted as costing $6m run up $30m of cost before being completely scrapped – as in yes, uninstalled and reverted to the system they were meant to be replacing, completely wiped away. Or there’s the $1 billion spent for “no significant capability” on an US Airforce SAP system.
Auckland software developer Ben Gracewood is practice lead at Marker Metro, founder and director of the Codemania conference, and a former principal architect at Datacom. During his time at Datacom he was not involved with the company's payroll division. He blogs at Ben Geek.
* Language has been modified in multiple instances - CK






















Comments and questions38
Yup, pretty much what my techie husband said, too. The whole thing has been poorly done from start to finish, like many (most?) large IT projects.
Agree on first part and disagree on the 2nd part (many/most generalization) . There's urgent need need for huge cultural shift in IT enterprises here in NZ, the lax behaviour adds up to the flaws in systems (and business processes). Lack of discipline in fool proof methology is major cause for such problem, there have been amazing IT projects implemented successfully when good governance is put in place.
Exception point! Most IT projects don't get into the news, don't spend and waste public money, don't end careers for the participants, and don't become a laughing stock. This is a news worthy story. The other side of the coin is that there are hundreds of successful projects run by public and private organisations where real value is delivered and it's just not news worthy.
There was also merit in Steven Joyce's comment earlier today that the teacher payroll system should have been simplified before the software project started (he said it currently allows around 10,000 pay permutations). Of course, better if he said it three years ago.
Even better if the Ministry had said this before they started the project.
I totally agree Chris. I would go further though. A professional BA (business analyst) employeed by a software company should have also have made those recommendations. A professional BA is as concerned with the process as much as the software. Their role includes looking at the existing processes and needs and looking at streamlining the processes as well as the software, because the ultimate goal of any software IS streamlining the business processes.
A good BA knows that complicated processes leads to complicated software and impacts on efficiency and often creates unnecessary problems.
You could compare a BA to a race car designer. The focus is always on the end objective - how can we crank an extra few km/hr out of the car while maintaining stability and control.
For novopay it should have been how can we get the staff paid efficiently with the minimum amount of admin overhead and confusion and no errors. This cannot be achieved by simply writing software to mimic complicated processes. It requires simplifying the processes and that is the corner stone of good software implementation - simplify and streamline the processes.
you think 1 BA could have made a recommendation on that whole system??
You cannot compare 1 BA to a race car designer - you think McClaren have 1 race car designer???
Lets not forget Ben himself has mentioned it is one enormous complex system he himself as an experienced architect would not build, so you've just raised the bar on NZ BA's it would seem.
I did qualify it by saying "Professional" BA. You may have contributing BA's but one person has to drive it and keep the overview and focus, no different to the lead architect on a buildling.
If that BA is "professional" he will also have the project leader reporting to him in the same way that builders and engineers used to report to "professional" architects in days before collapsing buildings and leaky homes.
Or in the same way that Bill Gates was the chief architect for Microsoft and Steve Jobs the Chief Architect for Apple during their respective visionary phases.
Too many middle rate BA's are guaranteed to complicate things. One person has to hold the vision and hold everyone else accountable. Otherwise with differing BA's and differing programmers the development process becomes a lot like herding cats - It takes for forever, there are always runaway bugs slipping out of the net, nerves get frayed, egos get scratched, and it is accompanied by lots of hissing and complaining.
Where do you get the idea that a BA has Project Leaders reporting to him / her?
In my (20 years plus) experience as a "professional" BA I have always reported to a Project Manager.
Also, I'm not sure what you mean by "Professional" BA - are there "amateur" BAs who work for free?
Reporting to someone does not mean that person has to be your boss. A BA is not the boss, however a good project manager will be guided by him. No point employing someone for a specific skill if you don't take their advice.
A project manager might be the boss but a project manager is still accountable to deliver the end objective. In this respect a good project manager will report to a BA to ensure that the project is in keeping with the BA's original intent. A good project manager may never understand the integrity of the system like the BA. If he did, the BA would be redundant, and the project manager could do both jobs.
Just like a good business manager, a good project manager knows when to take advice as well as give it. He never plays God and always hires people that know more than him in the relevant field.
A good comparable example would be a hotel manager hiring Gordon Ramsay to cater for a major event. I can assure you that Gordon would hold the hotel manager accountable for everything that Gordon needs, despite the hotel manager being the 'boss'. Because Gordon would want to fulfill his obligation to deliver what he is being paid to deliver.
The ability of a manager to take firm yet respectful control and take on board good advice from those that he employees is what gets projects completed, under time, and without bugs. Omnipotent project managers accountable to no-one is one of the reasons why Novopay is where it is right now.
Nice theory - but unfortunately it doesn't work like this in practice.
Your posts suggest that you have never worked on a large ICT project for a large company here in NZ.
I agree completely. At the risk of someone screaming "throwing out the baby with the bath water" one of the key opportunities with replacing a complex system is to step back and ask why it got so complex, and how we can actually simplify the business (ie pay permutations), and then build the system that supports that. The idea that "a system" (particularly of this size) will then somehow enable or support a transformation of the payment process is mind numbingly dumb.
I bet NZP are happy Novapay has grabbed everyones attention rather than the fiasco of the whole of government radio network....and the recent announcement that all frontline police are being issued with smartphones. Of course that's not because the radio network cost has blown out and they cant rollout to rural areas, and having looked at it no other government department wants to jump on board.....
I am dumb founded how many errors of such magnitude are in a released FINANCIAL system... obviously QA and testing arent in the SDLC of some project managers...
I joked to a co-worker of mine yesterday that they must have given this to a software intern that majored in machine learning and DSP and his payroll IIR filters had gone into oscillation after poorly calculated coefs :-)
Apparently the testing consultancy advised NOT to go ahead because of the bugs they had found , and there were ALOT of them
The thing I find (almost) most alarming about the report is the revelation that core ALESCO code has been modified and rewritten. This makes it effectively impossible to roll out critical updates such as security fixes, not to mention more mundane system updates.
So many aspects of this seem to have been so badly implemented that I find it hard to believe they'll ever be fixed. My suspicion is that the focus will be on making it work and that these issues will be largely ignored leaving us with a working by fundamentally flawed system with high maintenance costs and potential for unpatched security issues.
Agree. The only excuses for modifying core code are:
a) that it is temporary as ALESCO will deploy their own fix/enhancement;
b) that no code updates from ALESCO will ever be required to be implemented; or
c) that exceptional care has been taken to isolate the modifications into their own separate and independent module.
What is the betting that any of these apply?
Just goes to show that time spent in defineing the business and system requirements to a good level of detail is essential for the success of these implmentations. Unfortunately they are often run by IT managers who dont undestand the business and business sponsors who dont understand IT speak and/or their own business processes. This was doomed ot failure form the start and will continue to bleed money. Time to start again by fully analysing business needs and simplifying / standardising the business processes before you look for an IT system. IT systems dont fix business process issues they usually make them worse.
Bingo!
IT managers who don't understand the business and business. Managers who don't understand IT. A recipe for disaster as you both talk past each other on important issues and then think the other knows what he/she is doing! Idiots.
I have seen it almost every major IT project I have observed. The most successful (the Maori Land Court system) was one where 50% of the staff were involved in the design and testing. It was delivered on time, under budget and worked.
How many of these things are undertaken when, in fact, good BA work would simplify the exisitng system. As it stands, it appears they are going to fall back on the old system anyway.
It's not like this is the first piece of software the government has bought - or even the first systemic failure of a government IT project. Given the parallels with other well-known government IT failures, there's simply no excuse for this. If it ever works it seems that it will be a unique solution with no support or development. The ministry needs to plan to replace Novopay, first by sorting out the system that it was designed to support.
This whole scenario reminds me of the IBM INCIS debacle that went well over budget by the time it was finally shelved..
It seems the government never learns...
http://en.wikipedia.org/wiki/INCIS
Why doesn't systems used by IRD face such problems? Why not simply use same vendor/service provider across all other government systems :)
I wish the IRD systems were in dissarray - would be bliss to have the IRD being inaccurate and behind the times - sadly their seems to be super accurate
We all hate tax but a professional BA would recommend that the NZ IRD move to a low flat tax rate as a starter. Which did happen several years ago where an audit by an Australian company calculated a a flat tax rate of 17% upgraded to 15% during an audit of the audit.
Too easy
The Govt gets conned by the service providers that have their own objectives
MONEY
Both the social welfare benefits and tax systems were built from scratch rather than relying on customisation and its supposed efficiencies. Both departments at the time had staff who understood the coal face detail of running a service.
I suspect the Ed Dept has mostly staff who specialise in the fantasy world of educational philosophy and policy.
I thought the benefits system was still based around/built on top of SWIFTT, which was rolled out circa 1990.
Love your work Ben. One also has to question the tender process which is inherently flawed, the Ministries contract negotiation skills, project governance etc etc. Their hands are not clean in this either.
Brilliant! Can Ben do more writing for NBR? Like his cut to the chase style...
This 'article' is a joke. How is a ex-datacom staffer who obviously still has a bias capable of providing independent critique? Datacom is hardly a shining white knight and have stuffed up more than their fair share of projects over the years.
Ben is up front about the fact he used to work for Datacom (as noted at the foot of the article). During the time he did, he was not involved in payroll systems.
He's had roles at different companies since and NBR welcomes his perspective.
Our door is open to comment from Novopay, and other voices.
You want to interpret the NTR differently? Go right ahead and we'll judge the contest.
From the comments I've heard of the kinds of problems initially encountered by the users is that Novopay appears to have gone live with a really old database. Almost like they went live with test data. If you look at some of the kinds of early issues that users encountered - like people who had not been on payroll for two years suddenly popping up back on the register, people on wrong pay scales, part timers not appearing... the first few periods appear to have been trying to get the database to reflect the current reality - a major job in itself.
As several posters have already commented, any review / investigation of the project should go right back to basics and ask why the current payroll rules are so complex.
There must be thousands of teaching payroll systems successfully operating around the world, so why does a standard payroll application require extensive customisation for NZ teachers?
The rules for teacher pay are not unduly complex. The way Novopay handles the pay has made it ridiculously complex to the point in some instances of complete incomprehensibility. The staff who are meant to check it in the schools struggle with the added complexity every payday. The corrections sent in are largely ignored and faults just pile up.
Thank you finally some sense. Print and television have skirted around underlying architecture issues because they themselves don't understand. Now we have it in a nutshell. Exactly what everyone who has worked on an it project thought from the beginning.
I query the reviews comments about it being acceptable to go live with errors. In a number of countries taw law makes it imperative that a payroll is correct, ignoring any other issues. As such', it is rare that payrolls are implemented with so many fundamental errors.
The classification of errors appears to be unusual. Non-payment of staff would be normally be classified as a major issue. Payment of staff who have not worked may be an moderate issue but not when they should have been off the payroll 20 months ago, as is alleged.
The report specifically mentions the Start and End of Year issues. It ignores totally the Start and End of the TAX year which is due shortly. This should be a specific focus of attention!
Having managed the day-to-day running of a much larger payroll for a number of years I am disappointed at the apparent casual attitude of the reviewer's suppliers and ministry on the acceptance of so many errors affecting low-paid workers. One would be bad enough, but so many after almost six months is not acceptable.
The review conclusions are good and one must emphasise the need to encourage and retain the existing staff for their knowledge of the system until all the issues are resolved.
"As I understand it, the entire purpose (or at least a key selling point) of Novopay was to reduce costs by moving from Datacom’s human-intensive workflow to a system whereby schools do all the data entry and the 'system' just needs to calculate pay." There's the real rub. Because the data entry is being driven by the clients (i.e., schools), it is now massively human intensive, with principals and administrators in thousands of schools doing Novopay's work for them: untrained and unpaid.