Picasso is the corporate structure of the bank association. Since there were considerable adjustments to this company structure during the time of the merger of UBS AG and the Bankverein, the existing Microsoft Excel solution had to be replaced by a dynamic Access application. The aim was to be able to manipulate the tree structure quickly and easily. The application was implemented using Microsoft Access, VBA and SQL.

• Picasso is the entire corporate structure of UBS AG.
• This corporate structure was created and maintained manually in a central controlling department in Basel.
• After the merger of the two major banks UBS AG and Schweizer Bankverein, manual maintenance was no longer feasible.
• Company areas had to be integrated into one another, existing areas were replaced or abolished and new areas were added.
• Due to the fact that the old Picasso application was implemented using Microsoft Excel and VBA, it was decided together with the client to implement the new company structure using Microsoft Access and VBA and, during the implementation, new customer requirements with regard to the Integrate Fusion.
• Testing and documentation (user and technical).