A company has grown inorganically by taking over its competitors It wants to do financial reporting at group level and wants to report its financial metrics for various branch levels eg. National branches, regional branches, Sub regional branches, county level, city level. Its various constituent companies however have different levels of branch hierarchy and call various branch levels by different names. For example : one company may have 5 different levels of branches starting from Zonal, region, state, City, district level branches, while another just has county, city and local branches Our utility needs to create a harmonized reference hierarchy and map the various different branch levels of the various companies to one of the levels of master hierarchy. This will allow for group level reporting of financial numbers for various branch levels.
Technologies: java (bigdata with hadoop)