Business solutions for you portfolio


Company: UBS AG, Zurich

Technology: MS Access, VBA, SQL

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 1998 – Feb 2000

Cost: no details

Project: After the merger of Swiss Bank Corporation and UBS AG, the aim was to combine the private banking clients of both companies and to reallocate them to the client advisors. For this purpose, a Microsoft Access application was created, which on the one hand carried out the planning for the reallocation of the customers, but on the other hand also monitored the status of the implementation. The application was realised using Microsoft Access, VBA and SQL.

  • After the merger of UBS AG with Swiss Bank Corporation, all clients of the Private Banking Group (of both big banks) are transferred to the newly formed big bank UBS AG, which was created by the merger.
  • The client advisors of both companies are merged and assigned to the regions.
  • The clients of the regions are assigned to the newly assigned client advisors, this under the condition that the client agrees to change with one client advisor.
  • For this purpose, an application (Microsoft Access 2.0, Microsoft Visual Basic for Application) was developed for this purpose. and generates evaluations (Microsoft Access 2.0) or status reports (Microsoft         Excel, VBA).
  • Requirement Engineering.
  • Create data model using Dezign.
  • Implementation of customer requirements using Microsoft Access 2.0, Microsoft Visual Basic for Application.
  • Microsoft Excel.
  • 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.