Refugees – Relocation

Established in 1951, IOM is the leading inter-governmental organisation in the field of migration and works closely with governmental, intergovernmental and non-governmental partners. Since 2015 IOM has been relocating refugees to European countries.

What was the problem:

Multiple users were accessing a single Excel file that contained refugee relocation information. Very often the file was crashing. It was very difficult to create a workflow that was just based on a single Excel sheet. Excel did not offer any protection in case of a user deleting a whole row by mistake also it was difficult to extract statistics.

The solution:

A new database system was specifically created for our client to assist them with the refugees relocation needs. Users used both Excel and the database at the same time. We created an automated import process that enabled them to import information from the Excel file into the database on their own. Normalisation of the database was performed by an algorithm automatically.

A New People form was created showing information in a condensed way. It was possible to link a person to his/her family. Data was transformed to information in the new database. It was now possible to create statistics.

We also created a browse form that enabled users to quickly search for people under certain criteria or even export the data to another application for further analysis.

Spectrum Monitor

RansomSaver

Remove RDP Trails

We use cookies and other tracking technologies to improve your browsing experience on our site, show personalized content and targeted ads, analyze site traffic, and understand where our audience is coming from. To find out more, please read our Cookie Policy. In addition, please read our Privacy Policy, which has also been updated and became effective May 23rd, 2018..AcceptRead More