IFMIS & Why Nyama-Eaters are fighting the Auditor General

News & Politics
1

http://www.nation.co.ke/image/view/-/1951834/medRes/558564/-/153blraz/-/Jaindi.jpg
By JAINDI KISERO
More by this Author
NOV 8 2016

If there is an enduring lesson we have learnt from the upsurge of new corruption, it is that the graft game is these days played mainly by manipulating the Integrated Financial Management System, better known to Kenyans by the acronym Ifmis.

I will attempt to describe Ifmis in simple terms for the readers of this column who may not understand computer jargon. I will then enter into a discussion on the undercurrents that explain why the Auditor-General, Mr Edward Ouko, is becoming more and more unpopular with the powers that be.

Firstly, what is Ifmis? Simply put, it is a computer application the government uses to keep track of its financial transactions.

To run your Ifmis system, you have to instal an engine called a database. This is why we acquired Oracle, which underpins our Ifmis system. Put in a different way, our system has two parts: Ifmis and Oracle. We do not own the Oracle database and have no control over it.

We, therefore, only use and access the database under annual licences purchased from Oracle Corporation, the world’s leading vendor of software used by large corporations and institutions.

What then is the basic problem with our Ifmis system and why is it so vulnerable to manipulation by crooks? Our problems stem from the fact that we have not implemented a fully-functioning Ifmis system that can enable us to realise the full potential of the Oracle database. This is very much like buying a six-litre engine and using only one cylinder to power the vehicle.

WORK WELL

Indeed, Ifmis systems, or enterprise resource planning (ERPs), work very well for many large companies and institutions. The reason is simple — these entities have implemented fully-functioning systems.

What has Ifmis to do with the increasing unpopularity of the Auditor-General among the eating chiefs? Everything.

Allow me to explain. Having realised that the Ifmis system had long been captured by corrupt networks, the Auditor-General concluded that the best way to interrogate and get a full view of the government’s financial transactions was to acquire software that could go behind the corrupted Ifmis. He wanted a tool to take him straight to the Oracle database, where he can examine and analyse the raw data.

Consequently, Mr Ouko purchased two software programmes, namely Oracle Audit Vault and Oracle Business Intelligence.

I had to borrow several past issues of the magazine, Profit, which is published by Oracle Corporation, to understand and appreciate the power embedded in the software programmes that the Auditor-General has purchased. They go to a phenomenal level and can trawl very deeply into the database. With these tools, Mr Ouko can interrogate the entire financial audit trail of any government transaction.

I read in a past issue of Profit how these software programmes can allow the Auditor-General to carry out a real-time audit on transactions taking place within Ifmis.

The programmes will allow the Auditor-General to dive as deeply as necessary into the database to collect data and information, which he can use to conduct forensic analyses.

FINANCIAL INFORMATION

They will also allow him to see and recover any financial information and data that may have been deleted by crooked government officials.

Whichever way you look at it, the capability the Auditor-General has acquired is unlikely to make him popular with the well-connected tenderpreneurs who, acting in cahoots with top government officials, have turned Ifmis into am enabling tool for corrupt dealings. If you think that I am making a sweeping statement, go back to the National Youth Service scandal and you will see how the Ifmis regime was so easily manipulated to raid the public purse. Those behind the corrupt networks in control of Ifmis must be shaking in their shoes.

The context I describe is how conspiracy theorists are explaining the recent move by the Ethics and Anti-Corruption Commission to open new investigations into how Oracle Vault and Oracle Business Intelligence were acquired.

Indeed, Mr Ouko has been a man under watch. Just the other day he was publicly rebuked by President Uhuru Kenyatta for daring to extend investigations into the Eurobond saga to the Federal Reserve Bank of New York.

Last week, we read that an official of the Ethics and Anti-Corruption Commission had secretly obtained an ex parte court order to snoop into Mr Ouko’s personal bank accounts going back to 2012.

It is an open secret that Mr Ouko has been under pressure from the authorities to remove the disclaimer of opinion on the Eurobond transactions in the current report of the Auditor-General. He is expected to table a special audit report on the Eurobond transaction before the Parliamentary Accounts Committee. In corruption-ridden Kenya, auditors are not popular.

8 Likes
2

Nyasae Linda huyu AG.

2 Likes
3

And how come they have not removed him from the AGs office?

4

@kamnjoro was part of the implementation team of the Oracle DB vault.
#TeamKTalk well represented.

6 Likes
5

It’s a constitutional office.

1 Like
6

Does the db has a traiI of edits on admin level only or on the app users level on oracle modules?

1 Like
7

The way vault works is that it keeps a trail of all changes, including user rights alterations, deletions, etc.

In short, you do shiet, it’s traceable.

2 Likes
8

We are moving as a country, thats why there is so much friction. Even if the eaters have scored, game ni 90

9

Send me any link to Oracle about that. Wondering because most database systems I know of have a way that an admin can alter anything through SQL. Send link in private. No need to discuss this further, shinny eyes alert.

4 Likes
10

True the looters have had their day, but could jaindi be talking out of bitterness, he was a beneficiary of goldenberg.

11

Auditor General ni dimed eyed.Hapendwi na shinny eyes.

12

I have read Jaindi Kisero since I knew how to read. Has he found Elixir for eternal youth?

13

Wacha nifike job takutumia.

1 Like
14

Auditor General is not a pure investigator. He is merely an auditor. The people meant to do the investigations are asleep at the switch, Police, CID, EaCC, DPP, etc. Each year, the AG lists hundreds of cases of fraud in government institutions by public officials. With evidence. And yet nothing gets done. Absolutely nothing. And strangely, his personnel miss huge fraudulent transactions. EgAnglo-Leasing, Eurobond, NYS, Health Ministry… None of these was caught by the AG.
All the crooks know that he flags in parliarment fraud. This usually make noise for a couple of weeks in the news. And then disappears for good.
In a way his office has been rendered quite harmless.
He can invest in all the software he wants, but most of this fraud a std 7 student can catch with a simple calculator and paper and pen. They just take. Government official orders a ksh 10,000 printer and pays ksh 200,000. You can google its price. What software do you need to check this.

1 Like
15

Nothing Shiny Eyes can do about it. Plus all the basic information about Vault is in the public domain:
Audit Vault and Database Firewall | Oracle

16

Did you have to comment? You don’t have to display your ignorance.

17

Yes. Can you counter what I have said with facts? If you are right , I will take back what I have said. And I will salute to your knowledge.

18

Hapo kwa software umekosea unless kama hujui hio software kazi yake ni nini.

19

Sawa. I take that back. Software is important. My point is the fraud these people commit is very simple. They just steal. No trying to hide . Overstating actual prices and non delivery of what they buy account for the majority of the crimes.