Business solutions for you portfolio


Company: UBS AG, Zurich

Technology: Oracle, PL/SQL, Java, VB

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2007 – Nov 2012

Cost: no details

Migration of the prototype database compiler created in 2003-2006 from Microsoft SQL Server to Oracle, Jboss, Drools and JBPM. The database compiler is still the core of the application. With the help of the compiler, the workflows for sheet data processing are created and stored in the database in the form of stored functions or procedures (PL-SQL). However, standard products such as Drools are now also used for the application's set of rules and JBPM for the timed execution of the workflows. The user interface is migrated from Microsoft VB to Java. A data migration from Microsoft SQL Server to Oracle is also taking place. The various tools for process monitoring and fully automated signature clean-up are left in C#, only the logic is adapted to the new infrastructure.

  • Development of a UBS AG internal application for the generation and administration of physical signatures of employees authorised to sign, taking into account internal and legal requirements.
  • Multi-layer technology, Oracle database, logic implemented using PL-SQL (graphical generation of stored procedures - worldwide patents), integrated security layer implemented using Oracle, PL/SQL and Java.
  • Responsibility project management, project planning.
  • Requirement engineering.
  • Creation of specifications, adherence to deadlines, resource planning and project monitoring, team leadership and employee management (25 employees from 2003 - 2012, project volume > 10'000'000.00 SFr.).
  • Version 2.0 (SQL Server, Transact SQL, VB) was migrated to Oracle, PL-SQL and Java.
  • Data modelling, database development (Oracle, migrated from SQL Server) and the implementation of logic in PL-SQL (migrated from Transact SQL). Migration from MS SQL Server to Oracle 10g.
  • Automated testing (HP QTP).
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

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.