Projektleiter, Microsoft SQL Server
UBS AG, Zürich
Persons in the PROJECT: Stefan Troehler
PROJECT duration: Jan 2007 - Nov 2012
PROJECT value: SFR. 00,000.00
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 the leaf data processing are created and stored in the form of stored functions or procedures (PLSQL) in the database. Standard products such as Drools for the rules of the application and JBPM for the time-controlled execution of the workflows are now also used. The user interface is migrated from Microsoft VB to Java. Data is also migrated from Microsoft SQL Server to Oracle. The various tools for process monitoring and for the fully automated cleaning of the signatures will be left in C #, only the logic will be adapted to the new infrastructure.
Responsible : To plan, coordinate and control the project efficiently. Traditional instruments such as network planning, project cost planning and resource planning help him in this. The newer planning instruments also include the project definition, the analysis of the project environment, the project structure planning and phase-related workshops (project start, milestone, project completion workshop).
- Development of an internal UBS AG application to generate and manage physical signatures for authorized signatories, taking into account internal and legal requirements.
- Multi-layer technology, Oracle database, logic implemented using PLSQL.
- Graphic generation of stored procedures - worldwide patents.
- Integrated security layer implemented using Oracle, PL / SQL and Java.
- Responsibility for project management, project planning.
- Requirement engineering, creating the specifications.
- Compliance with deadlines, resource planning and
- Project monitoring.
- Team management and staff 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, PLSQL and Java.