As a final part of the business analyst and data architect offering for the Bloomberg AIM migration, pureCygnet developed an online tool for reporting on the Bloomberg AIM user permissions (both functions and accounts / groups).
This takes the Extended Admin Feed, imports it into a SQL database with different sections going to different tables. The front end (ASP.NET) gives the user the options to browse users in the AIM system, assign users to arbitary regions and departments and generate reports for function permissions and account permissions. The reports can be filtered by the arbitary groups specified, or by the User Groups specified in the Bloomberg AIM admin interface.
These reports have been used for their quarterly SAS70 audits as a structured means to show the Portfolio Managers who has access to what accounts, and to then be signed off.
If you would like to know more about pureCygnet's offering, or would like a similar system developed, please contact us.