Our client is the asset management arm of an international banking group with some £35bn under management from some very prestigious clients. We have developed a number of systems for the client covering all areas of investment management. Core to many of the bank's processes and software was the security classification system which we designed and implemented.
With the diverse array of financial instruments available to investors, the classification, allocation and reporting of securities held in funds is not an easy task. This application classifies all holdings in the 2000 or more funds that the bank manages, every night, into the elements that uniquely identify each instrument. Complex summations are then performed to show each fund in a breakdown that the fund manager requires.
The front end allows each fund manager to specify the hierarchical breakdown of each fund by dragging, dropping and expanding the detail lines that are required. The system also allows some flexibility in the reporting, for instance for bond markets the instruments may be better allocated to countries by their currency of issue rather than country of origin so that exposure to currency fluctuations can be more easily spotted.