US Consulate

Who are US Consulate?

The Consulate General of the United States in Ho Chi Minh City belongs to the US Department of the State and provides consular services and deals with diplomatic affairs in Ho Chi Minh City and the rest of southern Vietnam.

Challenges

  • Digitise refugee records and visa application data on microfiche & microfilm (approximately 17,000,000 images)
  • Link digital files into an existing SQL Server database

Solutions and benefits

  • Project delivered on a 24 by 7 working schedule
  • Used bespoke automation tools to optimise the project performance and avoid manual errors
  • Applied a strict process of Quality Assurance to ensure that all tasks were run accurately

Results

  • Significantly reduced data access time from up to 10 minutes down to 3 seconds
  • Project completed on time and with a 99.95% accuracy which helped to improve productivity and efficiency