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.
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.