Laboratory data acquisition - Oracle, Microsoft SQL Server, T-SQL
Documenting all Microsoft SQL, Oracle and Microsoft VBA applications for the Philip Morris laboratories. The inventories of the applications were taken and both technical documentation and a user manual were created for each application. Both documents were produced in English.
Lifecycle–Management – Oracle PL-SQL, SQL
Creation of a Microsoft Access application that obtains its data from an Oracle database, calculates the life cycles of the individual products of the company Novartis Pharma and supplements or refines existing data. Subsequently, the data is exported into reports, which are realised in Microsoft Excel. The application is realised using Oracle and PL SQL as well as SQL, Microsoft Access and VBA as well as SQL and Microsoft Excel and VBA. The final product is the finished reports concerning the life cycles of the individual products of the company Novartis Pharma.
Signs from Microsoft SQL Server to Java and ORACLE
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.