INDEX | ORGANISATION | TIME LINE | PEOPLE | STORY | RESEARCH METHOD | COMMENTARY | FINDINGS | HELP | BOTTOM

Data audit: Doing the audit

' ... I was used to provide support, hit the database behind the scenes, extract the information, identify areas that were of concern, common errors, common misunderstandings. ... hit the database, straight SQL, extract the information, sometimes investigate to have a see the history..what had happened in the life of a policy, go back and see if this has always been wrong, was this..if we found an error, was this a common error, were there any other cases like it, provide advice on whether or not it was likely to be a system problem or was it just a case of they didn't know what they were doing, which was 99% of the cases.

So it was just basically to provide technical support and just some..often just to provide a layman's view on things ... have a see if I could understand why the underwriters had done it like that. ... I did go down two or three times, but it was all done mainly over the phone and because we've got the line connected I printed the reports off just right next to Keith's desk on the printer. ...

We didn't do the US. We came very rapidly, after a few reports were run, we came very rapidly to the conclusion that the US was abysmal. ...

And then at the end all the information that they collated, I designed a little system where they could record it, just simply put the numbers in against each field and then pull off some graphs indicating error trends. ... I actually used Powerbuilder, on flat text files. And they got one of the secretaries in London to key the information in. They produced little audit reports as they went through listing all the fields in error then they got one of the secretaries to transcribe that into the little system I'd developed, and I went in and did the trend analysis.'

X065 page 001.01a (tape 05.1.01a) Jim Notes/Tape 14/10/94

Social influence: Team: Composition
Technical influence: Process: Quality procedures


Recording
Story
Social influence
Technical influence

INDEX | ORGANISATION | TIME LINE | PEOPLE | STORY | RESEARCH METHOD | COMMENTARY | FINDINGS | HELP | TOP

© Clare Tagg 2000