Oracle PL/SQL, SQL, Packages and Trigger Logik, Oracle Forms, Oracle Reports, Oracle Designer, Drug Safety Systems ARISg, Empirica Trace, ARGUS
Aktualisiert am 14.02.2019
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.07.2019
Verfügbar zu: 100%
davon vor Ort: 100%
English
fluently
German
fluently
Russian
native

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

4 Monate
2017-06 - 2017-09

Support of an Oracle based System for the management of energy producers

Oracle Entwickler PL/SQL PL/SQL Developer
Oracle Entwickler

Development and implementation of new requirements in the DENEA – a system for the accounting and management of energy producers.

Creation of data migration scripts, performance tuning.

PL/SQL PL/SQL Developer
PL/SQL PL/SQL Developer
RegioCom
Magdeburg
6 Monate
2017-01 - 2017-06

Support of an Oracle based Pricing Simulation System

Oracle Datenbank Entwickler Oracle 12c PL/SQL GitHub ...
Oracle Datenbank Entwickler

Support of an Oracle based Pricing Simulation System.

Design and development of a data loading framework for parallel processing of different data loading processes (loaders) with consideration of timely dependencies between loaders.

Creation of data migration scripts, performance tuning.

GitHub PL/SQL Developer Oracle 12c
Oracle 12c PL/SQL GitHub PL/SQL Developer
Deutsche Börse Group
Eschborn
2 Jahre 5 Monate
2014-05 - 2016-09

Support of an Oracle based safety system for the pharmaceutical industry.

Data retrieval specialist, contract
Data retrieval specialist, contract

Data retrieval specialist.

Creation of standard and Ad hoc Drug Safety Reports according to the GxP-requirements using Oracle SQL, PL/SQL.

Migration of report scripts from Empirica Trace 4.2 to ARGUS Safety 7.0.5.

Testing and validation of report scripts.

Performance tuning.

 Windows 7 SQL ARGUS Drug Safety Systems PC ORACLE RDBMS 11g SQL Navigator Empirica Trace Drug Safety system PL/SQL
CSL Behring
Marburg, Germany
3 Jahre 1 Monat
2011-04 - 2014-04

Development and support of an Oracle based safety system for the pharmaceutical industry.

Drug Safety Specialist, Contract
Drug Safety Specialist, Contract

Oracle 10g and 11g based System.

Creation and execution of Drug Safety SQL queries in the ARISg system and direct on the database.

Development  and  testing of migrations scripts, performance tuning, documentation generation

PC Windows XP Windows 7 ORACLE RDBMS 10g ORACLE RDBMS 11g SQL Developer TOAD ARISg ARISg Explorer Automatic Query Manager TortoiseSVN
Roche
Basel, Switzerland
10 Monate
2010-06 - 2011-03

Development of a Commerce and Customer Care system for the gas dealing area.

Oracle developr, contract
Oracle developr, contract

Oracle 10g and 11g based System.


Front end: Java Application.

DB-design, development  and  implementation, correction of existing program code, programming, performance tuning, going live support by customers.

PC Windows XP ORACLE RDBMS 10g ORACLE RDBMS 11g ORACLE PL/SQL Developer WEM ? World Energy Market
Atos Origin
Frankfurt am Main, Germany ; Groningen, Holland
1 Jahr
2009-06 - 2010-05

Development of an Oracle based system for the pharmaceutical industry.

Data Retrieval Specialist, contract
Data Retrieval Specialist, contract

Oracle 10g and 11g based System.

Front end: Java Application, Oracle Forms, Oracle Reports.

Development  and  implementation, correction of existing modules (packages, forms and reports), programming, performance tuning.

PC Windows XP ORACLE RDBMS 10g  ORACLE RDBMS 11g SQL Navigator TOAD ARISg Oracle Forms Oracle Reports SAP Items MS VSS DOORS HP Service Desk.
Boehringer Ingelheim
Ingelheim am Rhein, Germany
1 Jahr
2008-04 - 2009-03

Development of a Commerce and Customer Care system for the gas dealing area.

Oracle developer, contract
Oracle developer, contract

Oracle 10g and 11g based System.


Front end: Java Application.

DB-design, development  and  implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Windows XP ORACLE RDBMS 10g  ORACLE RDBMS 11g ORACLE PL/SQL Developer PC
Atos Origin
Frankfurt am Main, Germany; Groningen, Holland
1 Jahr 4 Monate
2006-10 - 2008-01

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

Oracle database developer, contract
Oracle database developer, contract

Oracle 10g and 11g based System.
Front end: Java Application.
DB-design, development and implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Hardware: PC

Software:

Windows XP, ORACLE RDBMS 10g/11g, ORACLE PL/SQL Developer

Oracle/SQL Oracle Developer Oracle Designer Oracle Forms Oracle Reports SQL Navigator Oracle 10g Oracle 11g
Billing Components
Munich, Germany
2 Jahre 4 Monate
2004-07 - 2006-10

Development of an Oracle based Billing and Customer Care system for US telecommunication companies (GSM operators)

Oracle database developer, contract
Oracle database developer, contract

New Oracle 9i based Billing System (client-server) for US GSM operators (over 40 installations), which has to replace their COBOL based legacy systems. Includes features like flexible bill cycle and bill run management, 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, real time billing.
Front end: Java GUI.
Server-side development with Oracle Designer/2000, server side programming (PL/SQL).

Hardware: PC, IBM Servers

Software: Windows 2000, UNIX, ORACLE RDBMS V9i, ORACLE Developer Suite 9i, TOAD.

Oracle 9i Oracle Developer Suite Oracle SQL PL/SQL TOAD
BearingPoint
Graz, Austria
3 Monate
2004-05 - 2004-07

Development of an Oracle based Billing and Customer Care system for Astral MGCP Callagent (Romania) telecommunication company (GSM operators)

Oracle database developer, contract
Oracle database developer, contract

Oracle 9i based Billing System (client-server) for GSM operators.

Front end: Java GUI.
Server-side development and programming (PL/SQL)

Oracle 9i Oracle/SQL PL/SQL TOAD
BearingPoint
Graz, Austria
4 Jahre 2 Monate
2000-01 - 2004-02

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

Oracle database developer, contract
Oracle database developer, contract

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

Billing Components, Telesens KSCL, CSC Ploenzke (the Billing Components was first within CSC Ploenzke, afterwards within Telesens KSCL and from May 2002 independently).

Munich, Germany

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).
Full interface layer for data structures and business logic to enable independent “on-customer-site” development.
Data export from application to XML files, MS Office.

Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000, PL/SQL Developer.
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.

 

Application and DB-design, development  and  implementation, programming (server-and client-side), performance tuning, support for end customers.

Hardware: PC, HP / SUN Servers

Software: Windows NT/2000, UNIX, ORACLE RDBMS 8i/9i, ORACLE Developer, ORACLE Designer

Oracle 7 Oracle 8i Oracle 9i SQL PL/SQL Oracle Designer Oracle Forms Oracle Reports SQL plus SQL Navigator
Billing Components
Munich, Germany
2 Jahre 8 Monate
1997-05 - 1999-12

Development of a Hospital Management system for German hospitals

Oracle developer, permanent
Oracle developer, permanent

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-and client-side programming (PL/SQL, Java), Forms creation, performance tuning.

Hardware: PC

Software: Windows 3.1/95, SCO UNIX, ORACLE RDBMS V7, ORACLE Developer/2000 R 1.3.2, ORACLE Designer/2000 R 1.3.2

Oracle7 Oracle Designer Oracle Developer Oracle Forms Oracle Reports SQL SQL Plus PL/SQL Java
Klinik OP Data GmbH
Regensburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 10 Monate
1971-09 - 1976-06

Mathematics and Mechanics

Dipl. Ing., State University Tomsk, Russian Federation
Dipl. Ing.
State University Tomsk, Russian Federation

Kompetenzen

Kompetenzen

Schwerpunkte

Application tuning / SQL-tuning
Design and Development of Oracle based systems (client-side and server-side)
Drug Safety

Produkte / Standards / Erfahrungen / Methoden

ARGUS - Drug Safety System
ARGUS Drug Safety Systems
ARISg
ARISg - Drug Safety System
ARISg Explorer
Automatic Query Manager
COGNOS 8
DOORS
Empirica Trace Drug Safety system
GitHub
GitHub
HP Service Desk.
MS VSS
Navigator WAVES 4
Oracle Designer
2000, R 1.3.x , R 6.0 (server- and client-relevant components)
ORACLE Developer
2000, 1.x-10g (Forms and Reports)
ORACLE Developer Suite 10g
ORACLE Developer Suite 9i
Oracle Forms
ORACLE Headstart
 R 1.0, R 2.1
ORACLE PL/SQL Developer
Oracle Reports
ORACLE SQL*Plus
PL/SQL Developer
SAP Items
SQL-Navigator
TOAD
TortoiseSVN
WEM ? World Energy Market

Betriebssysteme

CP/M
HP-UX
Linux
RSX-11
RT-11
SunOS
Unix
Windows
Windows 7
Windows XP
 Windows 7

Programmiersprachen

Assembler
C
Java
Oracle SQL
Schwerpunkt
Oracle/SQL
Pascal
PL/SQL
Schwerpunkt
Shell Bash
XML

Datenbanken

Oracle
ORACLE 7-9i, 10g, 11g
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 12c
Oracle 7
Oracle 8i
Oracle 9i
Oracle Developer Suite
ORACLE RDBMS 10g
ORACLE RDBMS 11g
Oracle7
SQL
SQL Developer
SQL Navigator
SQL plus
 ORACLE RDBMS 11g
 ORACLE RDBMS 11g

Datenkommunikation

PC-Anywhere
Router
TCP/IP
Windows Netzwerk

Hardware

Messgeräte
Mikrocontroller
PC
PDP
Plotter

Branchen

Branchen

  • Drug Safety
  • Pharma Industry
  • Telecommunication (GSM) ? Billing and Customer Care systems
  • Healthcare
  • Gas dealing area
  • Energy producers management

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

4 Monate
2017-06 - 2017-09

Support of an Oracle based System for the management of energy producers

Oracle Entwickler PL/SQL PL/SQL Developer
Oracle Entwickler

Development and implementation of new requirements in the DENEA – a system for the accounting and management of energy producers.

Creation of data migration scripts, performance tuning.

PL/SQL PL/SQL Developer
PL/SQL PL/SQL Developer
RegioCom
Magdeburg
6 Monate
2017-01 - 2017-06

Support of an Oracle based Pricing Simulation System

Oracle Datenbank Entwickler Oracle 12c PL/SQL GitHub ...
Oracle Datenbank Entwickler

Support of an Oracle based Pricing Simulation System.

Design and development of a data loading framework for parallel processing of different data loading processes (loaders) with consideration of timely dependencies between loaders.

Creation of data migration scripts, performance tuning.

GitHub PL/SQL Developer Oracle 12c
Oracle 12c PL/SQL GitHub PL/SQL Developer
Deutsche Börse Group
Eschborn
2 Jahre 5 Monate
2014-05 - 2016-09

Support of an Oracle based safety system for the pharmaceutical industry.

Data retrieval specialist, contract
Data retrieval specialist, contract

Data retrieval specialist.

Creation of standard and Ad hoc Drug Safety Reports according to the GxP-requirements using Oracle SQL, PL/SQL.

Migration of report scripts from Empirica Trace 4.2 to ARGUS Safety 7.0.5.

Testing and validation of report scripts.

Performance tuning.

 Windows 7 SQL ARGUS Drug Safety Systems PC ORACLE RDBMS 11g SQL Navigator Empirica Trace Drug Safety system PL/SQL
CSL Behring
Marburg, Germany
3 Jahre 1 Monat
2011-04 - 2014-04

Development and support of an Oracle based safety system for the pharmaceutical industry.

Drug Safety Specialist, Contract
Drug Safety Specialist, Contract

Oracle 10g and 11g based System.

Creation and execution of Drug Safety SQL queries in the ARISg system and direct on the database.

Development  and  testing of migrations scripts, performance tuning, documentation generation

PC Windows XP Windows 7 ORACLE RDBMS 10g ORACLE RDBMS 11g SQL Developer TOAD ARISg ARISg Explorer Automatic Query Manager TortoiseSVN
Roche
Basel, Switzerland
10 Monate
2010-06 - 2011-03

Development of a Commerce and Customer Care system for the gas dealing area.

Oracle developr, contract
Oracle developr, contract

Oracle 10g and 11g based System.


Front end: Java Application.

DB-design, development  and  implementation, correction of existing program code, programming, performance tuning, going live support by customers.

PC Windows XP ORACLE RDBMS 10g ORACLE RDBMS 11g ORACLE PL/SQL Developer WEM ? World Energy Market
Atos Origin
Frankfurt am Main, Germany ; Groningen, Holland
1 Jahr
2009-06 - 2010-05

Development of an Oracle based system for the pharmaceutical industry.

Data Retrieval Specialist, contract
Data Retrieval Specialist, contract

Oracle 10g and 11g based System.

Front end: Java Application, Oracle Forms, Oracle Reports.

Development  and  implementation, correction of existing modules (packages, forms and reports), programming, performance tuning.

PC Windows XP ORACLE RDBMS 10g  ORACLE RDBMS 11g SQL Navigator TOAD ARISg Oracle Forms Oracle Reports SAP Items MS VSS DOORS HP Service Desk.
Boehringer Ingelheim
Ingelheim am Rhein, Germany
1 Jahr
2008-04 - 2009-03

Development of a Commerce and Customer Care system for the gas dealing area.

Oracle developer, contract
Oracle developer, contract

Oracle 10g and 11g based System.


Front end: Java Application.

DB-design, development  and  implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Windows XP ORACLE RDBMS 10g  ORACLE RDBMS 11g ORACLE PL/SQL Developer PC
Atos Origin
Frankfurt am Main, Germany; Groningen, Holland
1 Jahr 4 Monate
2006-10 - 2008-01

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

Oracle database developer, contract
Oracle database developer, contract

Oracle 10g and 11g based System.
Front end: Java Application.
DB-design, development and implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Hardware: PC

Software:

Windows XP, ORACLE RDBMS 10g/11g, ORACLE PL/SQL Developer

Oracle/SQL Oracle Developer Oracle Designer Oracle Forms Oracle Reports SQL Navigator Oracle 10g Oracle 11g
Billing Components
Munich, Germany
2 Jahre 4 Monate
2004-07 - 2006-10

Development of an Oracle based Billing and Customer Care system for US telecommunication companies (GSM operators)

Oracle database developer, contract
Oracle database developer, contract

New Oracle 9i based Billing System (client-server) for US GSM operators (over 40 installations), which has to replace their COBOL based legacy systems. Includes features like flexible bill cycle and bill run management, 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, real time billing.
Front end: Java GUI.
Server-side development with Oracle Designer/2000, server side programming (PL/SQL).

Hardware: PC, IBM Servers

Software: Windows 2000, UNIX, ORACLE RDBMS V9i, ORACLE Developer Suite 9i, TOAD.

Oracle 9i Oracle Developer Suite Oracle SQL PL/SQL TOAD
BearingPoint
Graz, Austria
3 Monate
2004-05 - 2004-07

Development of an Oracle based Billing and Customer Care system for Astral MGCP Callagent (Romania) telecommunication company (GSM operators)

Oracle database developer, contract
Oracle database developer, contract

Oracle 9i based Billing System (client-server) for GSM operators.

Front end: Java GUI.
Server-side development and programming (PL/SQL)

Oracle 9i Oracle/SQL PL/SQL TOAD
BearingPoint
Graz, Austria
4 Jahre 2 Monate
2000-01 - 2004-02

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

Oracle database developer, contract
Oracle database developer, contract

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

Billing Components, Telesens KSCL, CSC Ploenzke (the Billing Components was first within CSC Ploenzke, afterwards within Telesens KSCL and from May 2002 independently).

Munich, Germany

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).
Full interface layer for data structures and business logic to enable independent “on-customer-site” development.
Data export from application to XML files, MS Office.

Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000, PL/SQL Developer.
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.

 

Application and DB-design, development  and  implementation, programming (server-and client-side), performance tuning, support for end customers.

Hardware: PC, HP / SUN Servers

Software: Windows NT/2000, UNIX, ORACLE RDBMS 8i/9i, ORACLE Developer, ORACLE Designer

Oracle 7 Oracle 8i Oracle 9i SQL PL/SQL Oracle Designer Oracle Forms Oracle Reports SQL plus SQL Navigator
Billing Components
Munich, Germany
2 Jahre 8 Monate
1997-05 - 1999-12

Development of a Hospital Management system for German hospitals

Oracle developer, permanent
Oracle developer, permanent

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-and client-side programming (PL/SQL, Java), Forms creation, performance tuning.

Hardware: PC

Software: Windows 3.1/95, SCO UNIX, ORACLE RDBMS V7, ORACLE Developer/2000 R 1.3.2, ORACLE Designer/2000 R 1.3.2

Oracle7 Oracle Designer Oracle Developer Oracle Forms Oracle Reports SQL SQL Plus PL/SQL Java
Klinik OP Data GmbH
Regensburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 10 Monate
1971-09 - 1976-06

Mathematics and Mechanics

Dipl. Ing., State University Tomsk, Russian Federation
Dipl. Ing.
State University Tomsk, Russian Federation

Kompetenzen

Kompetenzen

Schwerpunkte

Application tuning / SQL-tuning
Design and Development of Oracle based systems (client-side and server-side)
Drug Safety

Produkte / Standards / Erfahrungen / Methoden

ARGUS - Drug Safety System
ARGUS Drug Safety Systems
ARISg
ARISg - Drug Safety System
ARISg Explorer
Automatic Query Manager
COGNOS 8
DOORS
Empirica Trace Drug Safety system
GitHub
GitHub
HP Service Desk.
MS VSS
Navigator WAVES 4
Oracle Designer
2000, R 1.3.x , R 6.0 (server- and client-relevant components)
ORACLE Developer
2000, 1.x-10g (Forms and Reports)
ORACLE Developer Suite 10g
ORACLE Developer Suite 9i
Oracle Forms
ORACLE Headstart
 R 1.0, R 2.1
ORACLE PL/SQL Developer
Oracle Reports
ORACLE SQL*Plus
PL/SQL Developer
SAP Items
SQL-Navigator
TOAD
TortoiseSVN
WEM ? World Energy Market

Betriebssysteme

CP/M
HP-UX
Linux
RSX-11
RT-11
SunOS
Unix
Windows
Windows 7
Windows XP
 Windows 7

Programmiersprachen

Assembler
C
Java
Oracle SQL
Schwerpunkt
Oracle/SQL
Pascal
PL/SQL
Schwerpunkt
Shell Bash
XML

Datenbanken

Oracle
ORACLE 7-9i, 10g, 11g
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 12c
Oracle 7
Oracle 8i
Oracle 9i
Oracle Developer Suite
ORACLE RDBMS 10g
ORACLE RDBMS 11g
Oracle7
SQL
SQL Developer
SQL Navigator
SQL plus
 ORACLE RDBMS 11g
 ORACLE RDBMS 11g

Datenkommunikation

PC-Anywhere
Router
TCP/IP
Windows Netzwerk

Hardware

Messgeräte
Mikrocontroller
PC
PDP
Plotter

Branchen

Branchen

  • Drug Safety
  • Pharma Industry
  • Telecommunication (GSM) ? Billing and Customer Care systems
  • Healthcare
  • Gas dealing area
  • Energy producers management

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

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

Das GULP Freelancer-Portal

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