Weitere Länder: Europaweit, Voraussetzung ist Deutsch, Englisch oder Russisch als Projektsprache
Development of the NBO/NBA engine (SQL, PL/SQL).
Software: ORACLE RDBMS 12c, TOAD, SQL-Developer.
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:
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
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:
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:
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:
Tasks:
Tasks:
Responsibility for the Oracle-related part of the project:
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:
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:
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:
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:
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:
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:
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:
1976
Universität Tomsk (Russland)
Graduation with honors
Ph.D. in theoretical and mathematical physics
Ph.D. in theoretical and mathematical physics
Oracle Experte: Consultant/Berater, System Architekt/Designer, technischer Entwicklungsleiter oder Entwickler von Oracle basierten Applikationen
Major skills:
Methodes:
Tools
Products:
Version control:
Source control:
Experience:
Since 1995 - tooday:
Since 1976 - tooday:
Projects by / for:
Projects in:
Job type:
Weitere Länder: Europaweit, Voraussetzung ist Deutsch, Englisch oder Russisch als Projektsprache
Development of the NBO/NBA engine (SQL, PL/SQL).
Software: ORACLE RDBMS 12c, TOAD, SQL-Developer.
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:
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
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:
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:
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:
Tasks:
Tasks:
Responsibility for the Oracle-related part of the project:
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:
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:
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:
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:
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:
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:
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:
1976
Universität Tomsk (Russland)
Graduation with honors
Ph.D. in theoretical and mathematical physics
Ph.D. in theoretical and mathematical physics
Oracle Experte: Consultant/Berater, System Architekt/Designer, technischer Entwicklungsleiter oder Entwickler von Oracle basierten Applikationen
Major skills:
Methodes:
Tools
Products:
Version control:
Source control:
Experience:
Since 1995 - tooday:
Since 1976 - tooday:
Projects by / for:
Projects in:
Job type: