Case: PwC

A consultant from Specialisterne has, with their flair for pattern recognition in unstructured data, helped the accounting company PwC with manually cleaning and streamlining data from their customer’s financial systems faster and with fewer mistakes.

The Company’s Challenge

Manual cleaning and structuring of data from customers’ financial systems is a big recurring task in for the revision company PwC. It is a time consuming and very repetitive task, that is usually done by student helpers. Even though data extracts from financial systems arrive unstructured, they do follow a certain logic – a pattern. In light of autistic people’s documented talent for pattern recognition, PwC entered into a collaboration with Specialisterne; a pilot project to see if a consultant from Specialisterne could do the standard task of manually cleaning and structuring customer data faster and with fewer mistakes than usual.

The Solution

PwC had prepared different workstations, depending on how much calm the consultant form Specialisterne wanted around them; but it quickly turned out that the consultant worked best with other people around them, and ended up working in the big room office with the rest of their team members.

Here the consultant was cleaning and structuring data from PwC customers’ financial systems in Excel spreadsheets that went up to a million lines, and afterwards other PwC employees would take over the job with the now structured financial data.

The consultant’s specific work assignments were, among others:

  • Cleaning and structuring of data from financial systems exported in Excel spreadsheets.
  • Validation and testing of new, structured Excel spreadsheets to find mistakes and shortcomings.
  • Attunement of financial data.
  • Clarification of attunement differentials in financial data.
  • Written and verbal communication with internal “customers” about differentials and shortcomings in the forwarded material.

 

The Client says

”Our expectation that an autistic consultant, with their ability to recognize patterns, would do the job with cleaning and structuring data faster and with fewer mistakes has been met. The consultant was fast, and there were an unusually small number of mistakes in the work that the consultant did.”

“But we also learned that the length of the task is important for the time related profit. The longer the single tasks took, the bigger the positive effect got from using a consultant from Specialisterne.”

“The pilot project has shown us that there is a great potential in using autistic consultants for this type of task, and we are absolutely certain that we can get Specialisterne and our business to work together.”

 

Christian Alexander, Manager, Assurance, Services, Methods, & Tools, PwC.

Case: PwC

En konsulent fra Specialisterne har med sin flair for mønstergenkendelse i ustruktureret data hjulpet Revisionsvirksomheden PwC med manuelt at rense og strømline data fra kunders finanssystemer hurtigere og med færre fejl.

Udfordringen

Manuel rensning og strukturering af data fra kunders finanssystemer er en stor, tilbagevendende opgave i revisionsvirksomheden PwC. Det er en tidskrævende, meget repetitiv opgave, som normalt udføres af studiemedhjælpere. Selv om dataudtræk fra finanssystemer kommer ustruktureret, følger de en vis logik – et mønster. I lyset af autisters dokumenterede talent for mønstergenkendelse indgik PwC derfor samarbejde med Specialisterne om et pilotprojekt for at se, om en konsulent fra Specialisterne kunne udføre standardopgaven med manuelt at rense og strukturere kundedata hurtigere og med færre fejl end normalt.

Løsningen

PwC havde forberedt forskellige arbejdsstationer, alt efter hvor meget ro Specialisternes konsulent ønskede omkring sig. Men det viste sig hurtigt, at konsulenten trivedes bedst med andre, og snart sad konsulenten og arbejdede i storrumskontoret sammen med teamets øvrige medlemmer.

Her stod konsulenten for at rense og strukturere data fra PwC-kunders finanssystemer i Excel-ark på op til en million linjer, hvorefter andre PwC-medarbejdere overtog arbejdet med de nu strukturerede finansielle data.

Konsulentens konkrete arbejdsopgaver var blandt andet:

  • Rensning og strukturering af data fra finanssystemer eksporteret i Excel-ark.
  • Validering og test af nye, strukturerede Excel-ark for fejl og mangler.
  • Afstemning af finansielle data.
  • Opklaring af afstemnings-differencer i finansielle data.
  • Skriftlig og mundtlig kommunikation med interne “kunder” omkring differencer og mangler ved fremsendt materiale.

 

Kunden siger

”Vores forventning om, at en autistisk konsulent med sin evne til at genkende mønstre kunne udføre arbejdet med at rense og strukturere data hurtigere og med færre fejl, har holdt stik. Konsulenten var hurtig, og der var usædvanligt få fejl i det arbejde, konsulenten udførte.”

”Men vi har også lært, at opgavens varighed har betydning for den tidsmæssige gevinst. Jo længere tid den enkelte opgave varer, jo større bliver den positive effekt af at bruge en konsulent fra Specialisterne.”

”Pilotprojektet har vist os, at der er et stort potentiale i at bruge autistiske konsulenter til denne type opgaver, og vi er helt sikre på, at vi kan få Specialisterne til at fungere i vores forretning.”

 

Christian Alexander, Manager, Assurance, Services, Methods, & Tools, PwC.