We have two results. In 2003, Ilham Aliyev became the shareholder and Director of a company called Rosamund International Ltd. That company has ceased to be active. Nonetheless in 2003 Ilham Alieyv was serving in parliament. Thus he may have violated constitutional provisions against members of Parliament operating or owning businesses.
Rosamund International Ltd is no longer active though. On appearance it seems President Ilham Aliyev has no other offshore accounts according to the ICIJ dataset. The only issue is that for the moment we have focused on direct paths between Ilham Aliyev and offshore assets. People who are trying to hide money tend to use proxies they can hide behind. That means that we must enlarge our search and look for indirect connections.
Using traditional data analysis techniques, we would embark on a evidence hunt. Looking at who the president is linked to, who they are linked to, etc. Doing this manually is time consuming and hard to do on large scale data. Traditional databases and data analysis tools are not always more helpful : they lack the ability to express queries around the connections in the data. When they do, the process is cumbersome and slow.
That is where graph technologies shine. With a Neo4j database for example, finding all the foreign assets Ilham Aliyev controls directly or indirectly is as simple as adding a “*” to our first query. The search will return all the paths in the data between Ilham Aliyev and offshore accounts.