Business solutions for you portfolio


Company: UBS AG (Bankverein), Basel

Technology: MS Access, VBA, Microsoft Excel, SQL.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: May 1998 – Jun 1998

Cost: no details

Picasso is the corporate structure of the Bankverein. 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 make manipulations to the tree structure quickly and easily. The application was implemented using Microsoft Access, VBA as well as SQL.

  • Picasso is the entire corporate structure of UBS AG.
  • This corporate structure was created and maintained manually in a central controlling office in Basel.
  • After the merger of the two major banks UBS AG and Swiss Bank Corporation, manual maintenance was no longer feasible.
  • Corporate divisions had to be integrated into each other, existing divisions were replaced or abolished and new divisions were added.
  • Due to the fact that the old Picasso application was realised using Microsoft Excel and VBA, it was decided together with the client to realise the new company structure using Microsoft Access and VBA and to integrate new     customer requirements regarding the merger during the realisation.
  • Testing and documentation (user and technical).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52


[email protected]

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.