Order a prototype for the application or for the database compiler project, which is to be started in 2003. The prototype is developed using Microsoft Access and VBA as well as Microsoft VB 6.0. The aim is to be able to keep the migration as simple as possible when the application is implemented at a later date. A migration from Microsoft Access to Microsoft SQL Server is the easiest way to keep the migration costs as low as possible.

Responsible : To plan, coordinate and control the project efficiently. Traditional instruments such as network planning, project cost planning and resource planning help him to do 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.
• Employee data is consolidated from several different sources (national and international) and refined with the help of data such as the company structure.
• The employee is requested to submit his signature (form, in four languages) by e-mail and the submitted signatures are read in using batch processing.
• The aim is to develop the complete software for managing the signatures of authorized signatories in the shortest possible time (RAD Microsoft Access 97, VBA, VB 6.0) and in parallel to this, the prototypes for version 2 (SQL Server, VB) develop.
• Requirement Engineering.
• Create a data model using Dezign.
• Implementation of customer requirements using Microsoft Access 97.
• Microsoft Visual Basic for Application and Microsoft Visual Basic 6.0.
• Provision of reports (Microsoft Access 97) and consolidated evaluations (Microsoft Excel).
• Testing and documentation (user and technical).
• 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 implemented the interface between compiler and database.
• 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.).