Dr. Juri Wolfenhaut

Development tasks related to the NBO/NBA engine used by a major German telecommunication company. Tasks: • Development of the NBO/NBA engine (SQL, PL/SQL). Software: ORACLE RDBMS 12c, TOAD, SQL-Developer

Design, Development and Support of Oracle based systems Database tuning SQL-tuning Application tuning

Support of the Drug Safety & Pharmacovigilance reporting system migration from Oracle BI Publisher to the PV Reports (RxLogix) and ARGUS Safety 8. Tasks: • review of User Requirements and Design Specifications for the new pharmacovigilance reporting system (RxLogix) • validation / testing of the new pharmacovigilance reporting system • developing of new reports • developing of custom solutions (SQL, PL/SQL) and of ad-hoc SQL queries / reports according to the end user requests

Development and support of a DWH system. Tasks: • impact analysis and developing of enhancements / extensions to the DWH batch loads of transactional data from the CRM system for postpaid customers to increase data quality and to support new company products (SQL, PL/SQL) • developing of a new DWH load chain for throttle events data provided by the online charging system (SQL, PL/SQL) • analysis, solution concepts and preparation of transactional and legacy data for ad-hoc loads into the DWH

Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5 in a GxP-validated environment: - Developing of a framework for batch data cleansing/correction as part of data migration (SQL, PL/SQL) - Developing of a framework for the ETL validation in the custom DWH - Developing of ad-hoc SQL queries / reports according to the end user requests; - General support for team members in the Oracle area

Development of a Customer Loyalty system: - Data modeling to support high data volumes (partitioning, DWH staging tables) - Configurable table partitioning framework (PL/SQL and Python) - PL/SQL module to export transactions data to the financial sub-system - PL/SQL module to process personal data disclosure requests - Rating and Billing modules with the XML-based rules - Data migration within the loyalty module - Support in design/implementation of the Java layer regarding SQL-statements

Automatic transfer of the adverse events data from an Oracle Clinical database to the ARISg Drug Safety via XML-based publishing service: - Evaluation and fine-tuning of user requirements - Creation of functional & software design specifications and development tests - Conceptual design of the system - Creation of the underlying XML schema - Database design and implementation, installation scripts - PL/SQL code, incl. error logging, auditing and tracing - Performance tuning for Oracle Clinical

Database-related third-level support, enhancements and development around ARISg 5.1.2 Drug Safety system: - Enhancements / corrections to the customized parts of the ARISg application (server-side PL/SQL code) - Development of in-house web applications (APEX) to provide additional functionality for ARISg users - Implementing / applying data correction scripts (SQL and PL/SQL) - Third-level support for ARISg application - Code quality control - General support for team members in the Oracle area

Data migration - merge of regional databases spread worldwide into a single database, with concurrent migration / customization of the ARISg Drug Safety system to release 5.1.2: - Corrections to the data migration procedures - Performance tuning for the data migration scripts - Initial and incremental data migration - Corrections to the customized PL/SQL code of the ARISg application - Creation of new server-side PL/SQL procedures in the customized part of the application - Code quality control

Enhancements to the Billing and Customer Care system: - Separation of the core product from customizations - Adding Virtual Service Provider/Operator (VSP/VSO) functionality - Conceptual & DB design of the Virtual Private Database while keeping system performance - PL/SQL packages & SQL scripts for automated generation of DDL-scripts (table changes, views, VPD-policies, grants, synonyms) for switching to VPD - PL/SQL code to support the VSP/VSO functionality - SQL-scripts for creating test data

Development of a Billing and Customer Care system for an Australian telecommunication company - Oracle-related part: - Creation of development specifications - Application DB-design, implementation and PL/SQL programming (Rating, Billing and Invoicing modules) - Complex core SQL for Rating module to be called from Java layer - Major corrections / enhancements in data replication to/from Accounts Receivables module - Design/code quality control - Database/application performance tuning

Development of a Billing and Customer Care system for US telecommunication companies: - Requirements definition - Creation of development specifications - DB-design and implementation - Server side programming (PL/SQL, Java stored procedures) - Design/code quality control - Database/application performance tuning - Processing of change requests - Support for QA / user acceptance tests - Training and WebEx knowledge transfer sessions - Creation of manuals / documentation for end users

Development of a Oracle 9i based Billing and Customer Care system for telecommunication companies: - Creation of development specifications - Application system- and DB-design and implementation - Technical development management - Design/code quality control - Support for other developers in the Oracle area - PL/SQL programming (server- and client-side) - Performance tuning - Support for end customers - Configuration management in emergency cases - DBA-tasks in emergency cases

Development of a Oracle 7/8/8i based Billing and Customer Care system for telecommunication companies: - Creation of development specifications - Application system- and DB-design and implementation - Technical development management - Design/code quality control - Support for other developers in the Oracle area - PL/SQL programming (server- and client-side) - Performance tuning - Support for end customers - Configuration management in emergency cases - DBA-tasks in emergency cases

Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components: - DB-design - Server-side PL/SQL programming - Performance tuning

Development of an Ordering, Purchase and Delivery system for plant construction: - DB-design and implementation - PL/SQL programming (server-and client-side) - Performance tuning - Customer support

Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components: - DB-design - Server-side PL/SQL programming - Performance tuning

Development of an Ordering, Purchase and Delivery system for plant construction: - DB-design and implementation - PL/SQL programming (server-and client-side) - Performance tuning - Customer support

Change request for an Oracle 7 based Quality Control system: - Server-side and client-side PL/SQL programming - Oracle Forms generation and manual changing/creation

Development of an Oracle 7 based Hospital Management system for German hospitals: - Server-side and client-side PL/SQL programming - Oracle Forms creation - Database administration and tuning

Quantengravitation

Quantenelektrodynamik