Oracle Design/Development/Tuning (Oracle RDBMS, PL/SQL, SQL, Designer/2000, Developer/2000, Headstart)
Aktualisiert am 03.09.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.10.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Oracle
PL/SQL
SQL
ARGUS Safety
ARISg
Deutsch
Fließend in Wort und Schrift, Projekte in Deutschland und Österreich
Englisch
Fließend in Wort und Schrift, Projekte in USA, Australien, Bahrain
Russisch
Muttersprache

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz

Weitere Länder: Europaweit, Voraussetzung ist Deutsch, Englisch oder Russisch als Projektsprache

möglich

Projekte

Projekte

2 Jahre 8 Monate
2022-02 - heute

NBO/NBA engine

PL/SQL SQL

Development of the NBO/NBA engine (SQL, PL/SQL).

Software: ORACLE RDBMS 12c, TOAD, SQL-Developer.

Oracle 12c
PL/SQL SQL
Telefónica/O2
München, Germany
3 Jahre
2018-10 - 2021-09

Drug Safety & Pharmacovigilance

Support of the Drug Safety & Pharmacovigilance reporting system migration from Oracle BI Publisher to the PV Reports (RxLogix) and ARGUS Safety 8.

Data retrieval and reporting migration support within a Drug Safety & Pharmacovigilance system (ARGUS Safety) by an international pharmaceutical company in a GxP-validated environment 


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
  • general support for team members in the Oracle area

    ORACLE RDBMS 11g/12c SQL-Navigator SQL-Developer ARGUS Safety RxLogix PVR
    CSL Behring
    Marburg, Germany
    2 Jahre
    2017-02 - 2019-01

    Development and support of a Data Warehouse system

    Development and ad-hoc support tasks within a Data Warehouse system used by a major German telecommunication company for reporting in various areas like Contolling, Customer Intelligence, Business Marketing Intelligence, and others.
    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

    • developing of a new DWH load chain for throttle events data provided by the online charging system

    • analysis, solution concepts and preparation of transactional and legacy data for ad-hoc loads into the DWH

    CRM SQL PL/SQL DWH TOAD ORACLE RDBMS 11g
    Telefónica/O2
    München, Germany
    3 Jahre 3 Monate
    2013-10 - 2016-12

    Drug Safety & Pharmacovigilance

    Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5.

    Data retrieval and data migration support within a Drug Safety & Pharmacovigilance Reporting system (Empirica Trace 4.2) by an international pharmaceutical company in a GxP-validated environment


    Tasks:

    • developing of a framework for batch data cleansing/correction as part of data migration 
    • 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

      PC ORACLE RDBMS 10g/11g SQL-Navigator SQLDeveloper ARGUS Safety
      CSL Behring
      Magdeburg, Germany
      3 Jahre 3 Monate
      2011-08 - 2014-10

      Development of an Oracle & Java based Customer Loyalty system

      New Oracle 11g based back-end & Java/JPA2/Hibernate based frontend Customer Loyalty system to be used as a global platform


      Tasks:

      Development and support within the Oracle-related part of the system: 

      • data modeling to support high data volumes (partitioning, DWH staging tables)
      • development of a configurable table partitioning framework (PL/SQL and Python)
      • design/implementing of a PL/SQL module to export transactions data to the financial sub-system (supports gap-free export file numbers and gap-free line numbers within these files)
      • implementing of a PL/SQL module to process the personal data disclosure requests
      • server side programming ? e.g. Rating and Billing modules with the XML-based rules, module to export the billing data to the financial system
      • data migration within the loyalty module
      • support for Java developers at design and implementation of the Java persistence layer regarding SQL-statements
      • support for team members in the Oracle / SQL area
      ORACLE RDBMS 11g JPA2/Hibernate Weblogic Maven Jenkins Confluence Oracle SQL-Developer / Data Modeler PL/SQL Developer PC
      Loyalty Partner Solutions
      Munich, Germany
      2 Jahre 4 Monate
      2009-03 - 2011-06

      Oracle Clinical database

      Automatic transfer of the adverse events related data, gathered during clinical trials for new drugs within an Oracle Clinical database (Oracle 9i), to the Drug Safety System ? Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2, Oracle 10g) ? a new project by a major pharmaceutical company in a GxP-validated environment, which deliveres a generic XML-based publishing service for Oracle Clinical data, prepared for future use of an Enterprise Service Bus


      Tasks:

      • evaluation, clarification and fine-tuning of user requirements
      • creation of functional specifications, software design specifications and development tests
      • conceptual design of the system
      • creation of the underlying XML schema
      • database design and implementation, installation scripts on the Oracle Clinical side and on the ARISg side
      • code implementation (server-side PL/SQL), including error logging, auditing and tracing sub-systems on the Oracle Clinical side and on the ARISg side
      • performance tuning on the Oracle Clinical side
      • support for user acceptance tests and application validation
      ORACLE RDBMS 9i and 10g
      Boehringer Ingelheim
      Diverse locations
      7 Monate
      2008-09 - 2009-03

      Adverse Drug Event & Reaction Reporting

      Database-related third-level support, enhancements and development around Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2) by a major pharmaceutical company in a GxP-validated environment


      Tasks:

      • enhancements / corrections to the customized parts of the ARISg application (server-side PL/SQL code) ? development of in-house web applications (back-end Oracle10g) to provide additional functionality for ARISg users (Oracle Application Express) 
      • implementing / applying data correction scripts (SQL and PL/SQL) 
      • third-level support for ARISg application (database-related)
      • code quality control
      • general support for team members in the Oracle area

      ORACLE RDBMS 10g
      Boehringer Ingelheim
      Ingelheim am Rhein, Germany
      4 Monate
      2007-11 - 2008-02

      Product enhancements for the Oracle 10g & Java

      Product enhancements for the Oracle 10g & Java based Billing and Customer Care system, developed in the previous project:

      • Separation of the core product part from the customizations 
      • Adding the Virtual Service Provider / Virtual Service Operator (VSP/VSO) functionality to the system 


      Tasks:

      Responsibility for the Oracle-related part of the project:

      • evaluation of areas where the product can / needs to be enhanced and of corresponding design approaches
      • conceptual design / DB-design of how to use Oracle?s Virtual Private Database feature to support required VSP/VSO functionality while keeping system performance
      • creation of a framework (dedicated PL/SQL packages & SQL scripts) for automated generation of different DDL-scripts (performing table changes, creating views, VPD-policies, grants, synonyms, etc.) necessary for switching to VPD
      • enhancements / adjustments to the server-side PL/SQL code to support required VSP/VSO functionality
      • creation of sets of SQL-scripts for populating the database with consistent test data
      • support for team members in the Oracle area
      • domain / system know-how transfer to permanent employees

      ORACLE RDBMS 10g Hibernate
      AAPT
      Graz, Austria
      1 Jahr 7 Monate
      2006-04 - 2007-10

      Oracle & Java based Billing

      Development of an Oracle & Java based Billing and Customer Care system for an Australian telecommunication company (Landline and Cellurar / GSM operator).

      New Oracle 10g based back-end & Java/Hibernate based front-end Billing and Customer Care system for an Australian Landline, Cellurar and GSM operator, which needs to replace their legacy system (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management, bill previews, usage caps, discounting, re-rating and real time billing. Initial CDR validation is implemented in PL/SQL, Rating module is embedded SQL / Java & PL/SQL based, Billing / Invoicing modules are implemented in PL/SQL, and Invoice presentation in Java/XML. Front end: Java/Hibernate GUI


      Tasks:

      Responsibility for the Oracle-related part of the system design, development and support:

      • creation of development specifications 
      • application DB-design, implementation and server side programming (PL/SQL) ? Rating, Billing and Invoicing modules (here Billing module has been completely specified, designed and implemented from scratch single-handedly)
      • 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
      • support for team members in the Oracle area
      • training for support team members
      • on-site support of QA / performance tests 

      ORACLE RDBMS 10g Hibernate
      AAPT
      Graz, Austria / Sydney, Australia
      1 Jahr 11 Monate
      2004-05 - 2006-03

      Billing and Customer Care

      Development of an Oracle based Billing and Customer Care system for US telecommunication companies (Cellurar/GSM operators) (Releases 1 and 2).

      New Oracle 9i based Billing System (client-server) for US Cellurar and GSM operators (over 40 installations), which have to replace their COBOL based legacy systems (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management with threading, bill previews, different kinds of free minutes (use or lose, rollover, shared), price tiering (incremental and total), different kinds of discounting (on usages, monthly fees, number of services), minimum consumption, re-rating, near real time billing. Front end: Java GUI


      Tasks:

      Oracle development team leader for the Billing / Rating server side module:

      • requirements definition on-site with the customer
      • creation of development specifications
      • application DB-design and implementation
      • server side programming (PL/SQL, Java stored procedures) 
      • support for developer team in the Oracle area
      • design/code quality control
      • on-site database/application performance tuning
      • on-site processing of customers change requests
      • on-site support for customer QA tests / end user acceptance tests
      • on-site training and WebEx knowledge sharing sessions for the customer and for application support team members
      • creation of application manuals / documentation for end users

      ORACLE RDBMS 9i ORACLE Developer Suite 9i
      BearingPoint
      Graz, Austria / Savannah GA, USA / Bangalore, India
      5 Jahre 1 Monat
      1999-04 - 2004-04

      Billing and Customer Care system

      Development of a Billing and Customer Care system for telecommunication companies (GSM operators).

      Initially Oracle 7, then Oracle 8/8i, then Oracle 9i based Billing System (client-server) for the tier 3 GSM operators, includes Customer Care, Inventory Administration, GSM Network Provisioning, Rating, Billing and Accounts Receivable modules, plus Customization modules requested by customers. Front end: Oracle Forms and Reports. ?Thin client? ? complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling business rules packaged PL/SQL procedures). Flexible and powerful security system (dynamically enabled Oracle roles, ?fine-grained row-level access control? and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent ?on-customer-site? development. Data export from application to XML files. Using of the Oracle 8/8i features. Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). Presentation logic implemented as PL/SQL code directly in Forms or (if reusable) in attached client side PL/SQL libraries. Common look & feel due to using of object libraries, templates and preference sets


      Tasks:

      Oracle development team leader:

      • application System- and DB-design and implementation
      • creation of development specifications
      • technical development management
      • support for other developers in the Oracle area
      • design/code quality control ? programming (server-side and client-side)
      • performance tuning
      • support for end customers
      • configuration management in emergency cases
      • DBA-tasks in emergency cases

      ORACLE RDBMS 7 / 8i / 9i ORACLE Developer/2000 R 1.3.2 and R 6i ORACLE Designer/2000 R 1.3.2 and R 6.0 Oracle Headstart R 1.0 and R 2.1
      Various customer
      8 Monate
      1998-08 - 1999-03

      Development of a Construction Data Management

      Development of a Construction Data Management system for a major automobile construction company.

      Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C


      Tasks:

      • DB-design
      • programming (server-side: packaged PL/SQL procedures)
      • performance tuning 

      ORACLE RDBMS 7 Oracle Pro*C C++
      softlab & BMW
      Munich, Germany
      1 Jahr 1 Monat
      1998-01 - 1999-01

      Development of an Ordering, Purchase and Delivery system

      Development of an Ordering, Purchase and Delivery system for a major plant construction company

      Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed ?manually? with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets


      Tasks:

      • DB-design and implementation
      • programming (server-and client-side)
      • performance tuning
      • customer support

      ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
      Linde
      Munich, Germany
      3 Monate
      1997-10 - 1997-12

      Quality Control system

      Change request for a Quality Control system, used by a major automobile construction company

      Oracle 7 based client-server application to manage various data, obtained during different quality control procedures. Front end: Oracle Forms and Reports. Business logic implemented partially on the server side (via DB-triggers and packaged PL/SQL procedures), and partially on the client side. Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Most of Forms and Reports have been generated with the Designer/2000 and then changed ?manually? with the Developer/2000, and some Forms have been created completely with Developer/2000


      Tasks:

      • Server-side and client-side programming
      • Forms generation and manual changing/creation

      ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
      Softlab / BMW
      Munich, Germany
      2 Jahre
      1995-10 - 1997-09

      Development of a Hospital Management system

      Development of a Hospital Management system for German hospitals

      Oracle 7 based highly secured client-server application to manage various processes in a hospital, mainly for the surgery area. Front end: Oracle Forms and Reports. Business logic implemented on the client side (directly in Forms or in PL/SQL libraries). Server-side development (on the later stage) with Oracle Designer/2000, client-side development with Developer/2000. Forms and Reports have been created with the Developer/2000


      Tasks:

      • Server-side and client-side programming
      • Forms creation
      • Database administration and tuning 


      ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
      Klinik OP-Data GmbH
      Regensburg, Germany

      Aus- und Weiterbildung

      Aus- und Weiterbildung

      1976

      Universität Tomsk (Russland)

      Graduation with honors

      Ph.D. in theoretical and mathematical physics

      Position

      Position

      Ph.D. in theoretical and mathematical physics

      Oracle Experte: Consultant/Berater, System Architekt/Designer, technischer Entwicklungsleiter oder Entwickler von Oracle basierten Applikationen

      Kompetenzen

      Kompetenzen

      Top-Skills

      Oracle PL/SQL SQL ARGUS Safety ARISg

      Produkte / Standards / Erfahrungen / Methoden

      Major skills:

      • Design, Development and Support of Oracle based systems (client-side and server-side)
      • Application tuning
      • SQL-tuning
      • Database tuning 


      Methodes:

      • ER-Modellierung
      • Physikalishes Datenbank-Design
      • PL/SQL-Entwicklung
      • SQL-Entwicklung/Tuning
      • Datenmigrationen
      • Applikation/Datenbank Performance Tuning


      Tools

      • Oracle Clinical
      • ARISg
      • Empirica Trace
      • ARGUS Safety
      • RxLogix PVR 
      • Oracle Application Express 3.0 
      • Oracle Developer Suite 9i / 10g 
      • Oracle Designer/2000
      • R 1.3.x
      • R 6.0
      • Oracle Developer/2000
      • R 1.3.x, R 6.0/6i (Forms and Reports) 
      • Oracle Headstart R 1.0, R 2.1 
      • Oracle SQL*Plus
      • Oracle SQL-Developer / Data Modeler 
      • SQL-Navigator
      • TOAD
      • PL/SQL Developer


      Products:

      • ARISg
      • MedDRA
      • Oracle Clinical / Remote Data Capture


      Version control:

      • CVS
      • SVN
      • Microsoft Visual SourceSafe


      Source control:

      • CVS
      • SVN
      • Visual Source Safe 


      Experience:

      Since 1995 - tooday:

      • ORACLE


      Since 1976 - tooday:

      • Software development


      Projects by / for:

      • BMW
      • Linde
      • Softlab
      • CSC Ploenzke
      • VeriSign
      • BearingPoint
      • AAPT
      • Boehringer Ingelheim
      • Loyalty Partner / Payback
      • CSL Behring
      • Telefonica / O2


      Projects in:

      • Germany
      • Bahrain
      • Austria
      • USA
      • India
      • Australia


      Job type:

      • Contract

      Betriebssysteme

      CP/M
      HPUX
      MS-DOS
      MVS, OS/390
      Novell
      OS/2
      RSX-11
      SUN OS, Solaris
      Unix
      SCO Unix, Linux
      Windows

      Programmiersprachen

      Algol
      Fortran
      Java
      Anbindung an Oracle, keine reine Java-Projekte
      PL/1
      PL/SQL
      Expert Level
      Oracle SQL
      1.x, 2.x, 8.x, 9.x, 10.x, 11.x, 12.x

      Datenbanken

      Oracle
      Expert Level, Versionen 7, 8/8i, 9i, 10g, 11g, 12c
      SQL
      Expert Level

      Datenkommunikation

      RPC
      TCP/IP

      Hardware

      HP
      IBM Großrechner
      PC
      PDP
      SUN
      VAX

      Branchen

      Branchen

      • Telecommunication ? Billing and Customer Care systems
      • Customer & Business Marketing Intelligence
      • Plants construction industry ? Ordering and Purchase systems
      • Automotive industry ? Construction Data Management systems and Quality Control systems
      • Pharmaceutical / Health Care ? Hospital Management systems and Drug Safety systems
      • Adverse Event & Drug Reaction Reporting systems
      • Customer Loyalty systems

      Einsatzorte

      Einsatzorte

      Deutschland, Österreich, Schweiz

      Weitere Länder: Europaweit, Voraussetzung ist Deutsch, Englisch oder Russisch als Projektsprache

      möglich

      Projekte

      Projekte

      2 Jahre 8 Monate
      2022-02 - heute

      NBO/NBA engine

      PL/SQL SQL

      Development of the NBO/NBA engine (SQL, PL/SQL).

      Software: ORACLE RDBMS 12c, TOAD, SQL-Developer.

      Oracle 12c
      PL/SQL SQL
      Telefónica/O2
      München, Germany
      3 Jahre
      2018-10 - 2021-09

      Drug Safety & Pharmacovigilance

      Support of the Drug Safety & Pharmacovigilance reporting system migration from Oracle BI Publisher to the PV Reports (RxLogix) and ARGUS Safety 8.

      Data retrieval and reporting migration support within a Drug Safety & Pharmacovigilance system (ARGUS Safety) by an international pharmaceutical company in a GxP-validated environment 


      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
      • general support for team members in the Oracle area

        ORACLE RDBMS 11g/12c SQL-Navigator SQL-Developer ARGUS Safety RxLogix PVR
        CSL Behring
        Marburg, Germany
        2 Jahre
        2017-02 - 2019-01

        Development and support of a Data Warehouse system

        Development and ad-hoc support tasks within a Data Warehouse system used by a major German telecommunication company for reporting in various areas like Contolling, Customer Intelligence, Business Marketing Intelligence, and others.
        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

        • developing of a new DWH load chain for throttle events data provided by the online charging system

        • analysis, solution concepts and preparation of transactional and legacy data for ad-hoc loads into the DWH

        CRM SQL PL/SQL DWH TOAD ORACLE RDBMS 11g
        Telefónica/O2
        München, Germany
        3 Jahre 3 Monate
        2013-10 - 2016-12

        Drug Safety & Pharmacovigilance

        Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5.

        Data retrieval and data migration support within a Drug Safety & Pharmacovigilance Reporting system (Empirica Trace 4.2) by an international pharmaceutical company in a GxP-validated environment


        Tasks:

        • developing of a framework for batch data cleansing/correction as part of data migration 
        • 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

          PC ORACLE RDBMS 10g/11g SQL-Navigator SQLDeveloper ARGUS Safety
          CSL Behring
          Magdeburg, Germany
          3 Jahre 3 Monate
          2011-08 - 2014-10

          Development of an Oracle & Java based Customer Loyalty system

          New Oracle 11g based back-end & Java/JPA2/Hibernate based frontend Customer Loyalty system to be used as a global platform


          Tasks:

          Development and support within the Oracle-related part of the system: 

          • data modeling to support high data volumes (partitioning, DWH staging tables)
          • development of a configurable table partitioning framework (PL/SQL and Python)
          • design/implementing of a PL/SQL module to export transactions data to the financial sub-system (supports gap-free export file numbers and gap-free line numbers within these files)
          • implementing of a PL/SQL module to process the personal data disclosure requests
          • server side programming ? e.g. Rating and Billing modules with the XML-based rules, module to export the billing data to the financial system
          • data migration within the loyalty module
          • support for Java developers at design and implementation of the Java persistence layer regarding SQL-statements
          • support for team members in the Oracle / SQL area
          ORACLE RDBMS 11g JPA2/Hibernate Weblogic Maven Jenkins Confluence Oracle SQL-Developer / Data Modeler PL/SQL Developer PC
          Loyalty Partner Solutions
          Munich, Germany
          2 Jahre 4 Monate
          2009-03 - 2011-06

          Oracle Clinical database

          Automatic transfer of the adverse events related data, gathered during clinical trials for new drugs within an Oracle Clinical database (Oracle 9i), to the Drug Safety System ? Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2, Oracle 10g) ? a new project by a major pharmaceutical company in a GxP-validated environment, which deliveres a generic XML-based publishing service for Oracle Clinical data, prepared for future use of an Enterprise Service Bus


          Tasks:

          • evaluation, clarification and fine-tuning of user requirements
          • creation of functional specifications, software design specifications and development tests
          • conceptual design of the system
          • creation of the underlying XML schema
          • database design and implementation, installation scripts on the Oracle Clinical side and on the ARISg side
          • code implementation (server-side PL/SQL), including error logging, auditing and tracing sub-systems on the Oracle Clinical side and on the ARISg side
          • performance tuning on the Oracle Clinical side
          • support for user acceptance tests and application validation
          ORACLE RDBMS 9i and 10g
          Boehringer Ingelheim
          Diverse locations
          7 Monate
          2008-09 - 2009-03

          Adverse Drug Event & Reaction Reporting

          Database-related third-level support, enhancements and development around Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2) by a major pharmaceutical company in a GxP-validated environment


          Tasks:

          • enhancements / corrections to the customized parts of the ARISg application (server-side PL/SQL code) ? development of in-house web applications (back-end Oracle10g) to provide additional functionality for ARISg users (Oracle Application Express) 
          • implementing / applying data correction scripts (SQL and PL/SQL) 
          • third-level support for ARISg application (database-related)
          • code quality control
          • general support for team members in the Oracle area

          ORACLE RDBMS 10g
          Boehringer Ingelheim
          Ingelheim am Rhein, Germany
          4 Monate
          2007-11 - 2008-02

          Product enhancements for the Oracle 10g & Java

          Product enhancements for the Oracle 10g & Java based Billing and Customer Care system, developed in the previous project:

          • Separation of the core product part from the customizations 
          • Adding the Virtual Service Provider / Virtual Service Operator (VSP/VSO) functionality to the system 


          Tasks:

          Responsibility for the Oracle-related part of the project:

          • evaluation of areas where the product can / needs to be enhanced and of corresponding design approaches
          • conceptual design / DB-design of how to use Oracle?s Virtual Private Database feature to support required VSP/VSO functionality while keeping system performance
          • creation of a framework (dedicated PL/SQL packages & SQL scripts) for automated generation of different DDL-scripts (performing table changes, creating views, VPD-policies, grants, synonyms, etc.) necessary for switching to VPD
          • enhancements / adjustments to the server-side PL/SQL code to support required VSP/VSO functionality
          • creation of sets of SQL-scripts for populating the database with consistent test data
          • support for team members in the Oracle area
          • domain / system know-how transfer to permanent employees

          ORACLE RDBMS 10g Hibernate
          AAPT
          Graz, Austria
          1 Jahr 7 Monate
          2006-04 - 2007-10

          Oracle & Java based Billing

          Development of an Oracle & Java based Billing and Customer Care system for an Australian telecommunication company (Landline and Cellurar / GSM operator).

          New Oracle 10g based back-end & Java/Hibernate based front-end Billing and Customer Care system for an Australian Landline, Cellurar and GSM operator, which needs to replace their legacy system (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management, bill previews, usage caps, discounting, re-rating and real time billing. Initial CDR validation is implemented in PL/SQL, Rating module is embedded SQL / Java & PL/SQL based, Billing / Invoicing modules are implemented in PL/SQL, and Invoice presentation in Java/XML. Front end: Java/Hibernate GUI


          Tasks:

          Responsibility for the Oracle-related part of the system design, development and support:

          • creation of development specifications 
          • application DB-design, implementation and server side programming (PL/SQL) ? Rating, Billing and Invoicing modules (here Billing module has been completely specified, designed and implemented from scratch single-handedly)
          • 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
          • support for team members in the Oracle area
          • training for support team members
          • on-site support of QA / performance tests 

          ORACLE RDBMS 10g Hibernate
          AAPT
          Graz, Austria / Sydney, Australia
          1 Jahr 11 Monate
          2004-05 - 2006-03

          Billing and Customer Care

          Development of an Oracle based Billing and Customer Care system for US telecommunication companies (Cellurar/GSM operators) (Releases 1 and 2).

          New Oracle 9i based Billing System (client-server) for US Cellurar and GSM operators (over 40 installations), which have to replace their COBOL based legacy systems (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management with threading, bill previews, different kinds of free minutes (use or lose, rollover, shared), price tiering (incremental and total), different kinds of discounting (on usages, monthly fees, number of services), minimum consumption, re-rating, near real time billing. Front end: Java GUI


          Tasks:

          Oracle development team leader for the Billing / Rating server side module:

          • requirements definition on-site with the customer
          • creation of development specifications
          • application DB-design and implementation
          • server side programming (PL/SQL, Java stored procedures) 
          • support for developer team in the Oracle area
          • design/code quality control
          • on-site database/application performance tuning
          • on-site processing of customers change requests
          • on-site support for customer QA tests / end user acceptance tests
          • on-site training and WebEx knowledge sharing sessions for the customer and for application support team members
          • creation of application manuals / documentation for end users

          ORACLE RDBMS 9i ORACLE Developer Suite 9i
          BearingPoint
          Graz, Austria / Savannah GA, USA / Bangalore, India
          5 Jahre 1 Monat
          1999-04 - 2004-04

          Billing and Customer Care system

          Development of a Billing and Customer Care system for telecommunication companies (GSM operators).

          Initially Oracle 7, then Oracle 8/8i, then Oracle 9i based Billing System (client-server) for the tier 3 GSM operators, includes Customer Care, Inventory Administration, GSM Network Provisioning, Rating, Billing and Accounts Receivable modules, plus Customization modules requested by customers. Front end: Oracle Forms and Reports. ?Thin client? ? complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling business rules packaged PL/SQL procedures). Flexible and powerful security system (dynamically enabled Oracle roles, ?fine-grained row-level access control? and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent ?on-customer-site? development. Data export from application to XML files. Using of the Oracle 8/8i features. Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). Presentation logic implemented as PL/SQL code directly in Forms or (if reusable) in attached client side PL/SQL libraries. Common look & feel due to using of object libraries, templates and preference sets


          Tasks:

          Oracle development team leader:

          • application System- and DB-design and implementation
          • creation of development specifications
          • technical development management
          • support for other developers in the Oracle area
          • design/code quality control ? programming (server-side and client-side)
          • performance tuning
          • support for end customers
          • configuration management in emergency cases
          • DBA-tasks in emergency cases

          ORACLE RDBMS 7 / 8i / 9i ORACLE Developer/2000 R 1.3.2 and R 6i ORACLE Designer/2000 R 1.3.2 and R 6.0 Oracle Headstart R 1.0 and R 2.1
          Various customer
          8 Monate
          1998-08 - 1999-03

          Development of a Construction Data Management

          Development of a Construction Data Management system for a major automobile construction company.

          Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C


          Tasks:

          • DB-design
          • programming (server-side: packaged PL/SQL procedures)
          • performance tuning 

          ORACLE RDBMS 7 Oracle Pro*C C++
          softlab & BMW
          Munich, Germany
          1 Jahr 1 Monat
          1998-01 - 1999-01

          Development of an Ordering, Purchase and Delivery system

          Development of an Ordering, Purchase and Delivery system for a major plant construction company

          Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed ?manually? with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets


          Tasks:

          • DB-design and implementation
          • programming (server-and client-side)
          • performance tuning
          • customer support

          ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
          Linde
          Munich, Germany
          3 Monate
          1997-10 - 1997-12

          Quality Control system

          Change request for a Quality Control system, used by a major automobile construction company

          Oracle 7 based client-server application to manage various data, obtained during different quality control procedures. Front end: Oracle Forms and Reports. Business logic implemented partially on the server side (via DB-triggers and packaged PL/SQL procedures), and partially on the client side. Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Most of Forms and Reports have been generated with the Designer/2000 and then changed ?manually? with the Developer/2000, and some Forms have been created completely with Developer/2000


          Tasks:

          • Server-side and client-side programming
          • Forms generation and manual changing/creation

          ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
          Softlab / BMW
          Munich, Germany
          2 Jahre
          1995-10 - 1997-09

          Development of a Hospital Management system

          Development of a Hospital Management system for German hospitals

          Oracle 7 based highly secured client-server application to manage various processes in a hospital, mainly for the surgery area. Front end: Oracle Forms and Reports. Business logic implemented on the client side (directly in Forms or in PL/SQL libraries). Server-side development (on the later stage) with Oracle Designer/2000, client-side development with Developer/2000. Forms and Reports have been created with the Developer/2000


          Tasks:

          • Server-side and client-side programming
          • Forms creation
          • Database administration and tuning 


          ORACLE RDBMS 7 ORACLE Developer/2000 R 1.3.2 ORACLE Designer/2000 R 1.3.2
          Klinik OP-Data GmbH
          Regensburg, Germany

          Aus- und Weiterbildung

          Aus- und Weiterbildung

          1976

          Universität Tomsk (Russland)

          Graduation with honors

          Ph.D. in theoretical and mathematical physics

          Position

          Position

          Ph.D. in theoretical and mathematical physics

          Oracle Experte: Consultant/Berater, System Architekt/Designer, technischer Entwicklungsleiter oder Entwickler von Oracle basierten Applikationen

          Kompetenzen

          Kompetenzen

          Top-Skills

          Oracle PL/SQL SQL ARGUS Safety ARISg

          Produkte / Standards / Erfahrungen / Methoden

          Major skills:

          • Design, Development and Support of Oracle based systems (client-side and server-side)
          • Application tuning
          • SQL-tuning
          • Database tuning 


          Methodes:

          • ER-Modellierung
          • Physikalishes Datenbank-Design
          • PL/SQL-Entwicklung
          • SQL-Entwicklung/Tuning
          • Datenmigrationen
          • Applikation/Datenbank Performance Tuning


          Tools

          • Oracle Clinical
          • ARISg
          • Empirica Trace
          • ARGUS Safety
          • RxLogix PVR 
          • Oracle Application Express 3.0 
          • Oracle Developer Suite 9i / 10g 
          • Oracle Designer/2000
          • R 1.3.x
          • R 6.0
          • Oracle Developer/2000
          • R 1.3.x, R 6.0/6i (Forms and Reports) 
          • Oracle Headstart R 1.0, R 2.1 
          • Oracle SQL*Plus
          • Oracle SQL-Developer / Data Modeler 
          • SQL-Navigator
          • TOAD
          • PL/SQL Developer


          Products:

          • ARISg
          • MedDRA
          • Oracle Clinical / Remote Data Capture


          Version control:

          • CVS
          • SVN
          • Microsoft Visual SourceSafe


          Source control:

          • CVS
          • SVN
          • Visual Source Safe 


          Experience:

          Since 1995 - tooday:

          • ORACLE


          Since 1976 - tooday:

          • Software development


          Projects by / for:

          • BMW
          • Linde
          • Softlab
          • CSC Ploenzke
          • VeriSign
          • BearingPoint
          • AAPT
          • Boehringer Ingelheim
          • Loyalty Partner / Payback
          • CSL Behring
          • Telefonica / O2


          Projects in:

          • Germany
          • Bahrain
          • Austria
          • USA
          • India
          • Australia


          Job type:

          • Contract

          Betriebssysteme

          CP/M
          HPUX
          MS-DOS
          MVS, OS/390
          Novell
          OS/2
          RSX-11
          SUN OS, Solaris
          Unix
          SCO Unix, Linux
          Windows

          Programmiersprachen

          Algol
          Fortran
          Java
          Anbindung an Oracle, keine reine Java-Projekte
          PL/1
          PL/SQL
          Expert Level
          Oracle SQL
          1.x, 2.x, 8.x, 9.x, 10.x, 11.x, 12.x

          Datenbanken

          Oracle
          Expert Level, Versionen 7, 8/8i, 9i, 10g, 11g, 12c
          SQL
          Expert Level

          Datenkommunikation

          RPC
          TCP/IP

          Hardware

          HP
          IBM Großrechner
          PC
          PDP
          SUN
          VAX

          Branchen

          Branchen

          • Telecommunication ? Billing and Customer Care systems
          • Customer & Business Marketing Intelligence
          • Plants construction industry ? Ordering and Purchase systems
          • Automotive industry ? Construction Data Management systems and Quality Control systems
          • Pharmaceutical / Health Care ? Hospital Management systems and Drug Safety systems
          • Adverse Event & Drug Reaction Reporting systems
          • Customer Loyalty systems

          Vertrauen Sie auf Randstad

          Im Bereich Freelancing
          Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

          Fragen?

          Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

          Das Freelancer-Portal

          Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.