Web Analytics
Portfolio / Database migration for an international law firm

Database migration for an international law firm

Our client, an international law firm, had an existing C.CURE 800 access control system that required migration into their new C.CURE 9000 system, which had been provisioned as part of a new building project. The scope of work for this project included the extraction and cleansing of personnel credentials.

Strategy/process taken during the project

QCIC undertook a cleansing analysis exercise, to establish a set of cleansing criteria for the extracted personnel database. The following data cleansing criteria were identified: disabled personnel records, disabled cards, invalid card numbers, expired cards, personnel records with empty clearances and duplicate records.

These cleansing criteria were applied to the data and a set of relevant data fields for migration.

The cleansed data from C.CURE 800  was then imported into the C.CURE 9000 system using the following filtration criteria:

  • First Name
  • Last Name
  • Personnel type
  • Client contact name
  • Department or company
  • Person ID
  • Professional ID
  • PIN number
  • Card number
  • Expiration date
  • CHUID 
  • Facility code

Outcome

The personnel database was reduced by 18 544 records, leaving 3 852 records of active personnel.

After the data cleansing, the client was able to migrate a clean and up-to-date personnel database from the legacy access control system to C.CURE 9000.

The migration went smoothly and was completed on time, allowing a seamless transition into the new building.