Migration of the first prototype, which was created in 2001-2003, from Microsoft Access and VBA to Microsoft SQL Server, Visual Basic and C #. The central core of the application remains the database compiler, which is able to recursively form transect SQL functions and procedures on the basis of flowcharts and to execute them on the Microsoft SQL server in a time-controlled manner. The prototype is expanded to include various smaller applications that are able to clean up the signature submitted by the employee in various processes and save it as an image. As a result, these signatures are published both on the Internet and in the cross-bank extranet.

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, database Microsoft SQL Server, logic implemented using T-SQL.
• Graphic generation of stored procedures - worldwide patents.
• Integrated security layer implemented using Microsoft SQL Server, T-SQL and VB.
• Based on the Microsoft Access prototype, a compiler is being developed that is able to recursively generate Transact SQL code based on graphical business processes and make the business logic thus formed available to the authorized user.
• The concept has been patented worldwide by UBS AG.
• At a later point in time, the application will be migrated from Microsoft VB to Java and from Microsoft SQL Server to Oracle.
• In the administrative area, responsibility for project management and project planning.
• The creation of specifications according to customer specifications.
• Compliance with deadlines and budget.
• Resource planning, project monitoring.
• The team management and staff management (25 employees from 2003 - 2012, project volume> 30,000,000 SFr.).
• In the technical area, I was responsible for data modeling.
• The database development (SQL Server) and the implementation of the logic in Transact SQL.
• Image editing tools in .NET area (C #, EPF, WCF).
• I also have the interface between the compiler and the database
• realized.
• Maintenance of the SQL Server (configuration of a database server,
• Memory areas, processes and threads, control of resources,
• Transaction management, security features, configuration of instances and databases, user accounts and logins, roles and authorizations, tuning of an instance, parallel queries, replication, clustering,
• Partitioning, database mirroring, database snapshots, etc.).