freiberufler Oracle DB Entwickler, Drug Safety Spezialist auf freelance.de

Oracle DB Entwickler, Drug Safety Spezialist

offline
  • auf Anfrage
  • 93197 Zeitlarn
  • DACH-Region
  • ru  |  de  |  en
  • 02.07.2020

Kurzvorstellung

Ich bin ein Oracle DB Entwickler mit Schwerpunkten PL/SQL, SQL, Oracle Forms, Oracle Reports, Performance Tuning.
Ich bin auch ein Drug Safety Spezialist, Habe Erfahrung mit Drug Safety Systemen ARISg, WAVES, ARGUS.

Auszug Referenzen (8)

"Es war eine sehr angenehme und produktive Zusammenarbeit! Herr W. hat wesentlich zum Projekterfolg beigetragen."
Oracle - Entwickler
Kundenname anonymisiert
Tätigkeitszeitraum

6/2017 – 9/2017

Tätigkeitsbeschreibung

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

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.

Eingesetzte Qualifikationen

PL/SQL

"A. arbeitet ausgesprochen sorgfältig, zuverlässig und selbständig. Excellentes ORACLE-Wissen und PL/SQL Programmier-Erfahrung."
Oracle Datenbank Entwickler
Roland Jeschke
Tätigkeitszeitraum

1/2017 – 6/2017

Tätigkeitsbeschreibung

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.

Eingesetzte Qualifikationen

Oracle (allg.), PL/SQL, Git

"Mr. [...] [...] support us in the area of Global Clinical Safety & Pharmaco-vigilance / Data Retrieval as Data Retrieval Specialist from May 2014 to October 2016.

CSL Behring is a global leader in the plasma protein biotherapeutics industry. We research, develop, manufacture and market biotherapies that are used to treat serious and rare conditions. Users of our therapies rely on them for their quality of life and, in many cases, for life itself. Our products are produced at facilities in Bern, Switzerland; Marburg, Germany; Kankakee, Illinois and Broadmeadows, Australia, in accordance with international safety and quality standards.

Mr. [...] [...]’s main activities were:
• Creation of standard and Ad hoc Drug Safety Reports according to the GxP-requirements using Oracle SQL, PL/SQL.
• Development of new standard scripts for 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.

Mr. [...] [...] beyond others developed highly complex PL/SQL based reports for the implementation of custom quantitative signal detection reports. His profound knowledge of Oracle based technologies and his business knowledge in pharmacovigilance were essential to the successful implementation of these approaches. His knowledge and his interpersonal skills were also critical for the interactions with a wide range of customers in our department. He also collaborated effectively and in a very collegial manner with all members of the Data Retrieval group.


We would like to thank Mr. [...] [...] for his excellent contributions and engagement, which was crucial to the success of this project. We would be very happy to welcome him back as a team member for a future project.



Dr. Jürgen Kübler
Head Quantitative Safety Sciences"
Data Retrieval Specialist
Jürgen Kübler, CSL Behring
Tätigkeitszeitraum

5/2014 – 9/2016

Tätigkeitsbeschreibung

Support of an Oracle based safety system for the pharmaceutical industry.
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.

Eingesetzte Qualifikationen

Oracle Database, SQL, PL/SQL

"[...] [...] worked in the Data Management Group within Global Drug Safety of Roche.

He is very reliable and responsible. He has a profound knowledge of the Database tools as well as about Drug Safety in general.

Gerhard Heyer"
Data Management Spezalist
Kundenname anonymisiert
Tätigkeitszeitraum

4/2011 – 4/2014

Tätigkeitsbeschreibung

Development and support of an Oracle based safety system for the pharmaceutical industry.
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.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

"Herr [...] hat sich als äußerst kompetenter und fleißiger Spezialist in kürzester Zeit eingearbeitet und immer allerhöchste Arbeitsqualität geliefert. Ich würde ihn jederzeit wieder bei uns beschäftigen."
Oracle Entwickler
Kundenname anonymisiert
Tätigkeitszeitraum

6/2010 – 3/2011

Tätigkeitsbeschreibung

Development of a Commerce and Customer Care system for the gas dealing area.
DB-design, development and implementation, correction of existing program code, programming, performance tuning,
going live support by customers.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

"Sehr schnelle Einarbeitung!
sehr flexibel einsetzbar
sehr zuverlässig
top Arbeitsqualität
immer wieder gerne"
Oracle Developer
Kundenname anonymisiert
Tätigkeitszeitraum

4/2008 – 3/2009

Tätigkeitsbeschreibung

Development of a Commerce and Customer Care system for the gas dealing area.
DB-design, development and implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

"Ja, stimmt alles. [...] war sehr gur als Oracle Developer mit serverside Logik und Forms/Reports generierung mit Designer und Forms, Reports builder."
Oracle Developer
Boris Iankilevitch, Billing Componenets
Tätigkeitszeitraum

10/2006 – 1/2008

Tätigkeitsbeschreibung

Development and Support of a Billing and Customer Care system for telecommunication companies (GSM operators).
Application and DB-design, development and implementation, programming (server-and client-side), performance tuning, support for end customers.
Front-end design and development via Oracle Forms and Oracle Reports

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

"Stimmt."
Oracle Developer
Boris Iankilevitch, Billing Components
Tätigkeitszeitraum

1/2000 – 2/2004

Tätigkeitsbeschreibung

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

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

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 Forms, Oracle Reports

Eingesetzte Qualifikationen

Oracle (allg.), SQL, SQL*Plus, PL/SQL

Qualifikationen

  • Oracle Database
  • PL/SQL

Projekt‐ & Berufserfahrung

PL/SQL Consultant. Support in the SIGMA project especially in areas Personal and
Fraunhofer-Gesellschaft zur Förderung der angewand, München
10/2018 – offen (5 Jahre, 6 Monate)
Hochschulen und Forschungseinrichtungen
Tätigkeitszeitraum

10/2018 – offen

Tätigkeitsbeschreibung

Development and implementation, correction of existing code, PL/SQL programming, performance tuning, bug fixing.
Creation of new forms and popups using Oracle Forms.
Correction of data transfer processes between SIGMA and Fraunhofer registration system (Verzeichnisdienst) with writing of errors and transfer results into the log files.
Creation od diverses data exports in SIGMA.
Processing of tickets.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Oracle Developer, Drug Safety Specialist
Boehringer Ingelheim, Ingelheim am Rhein
1/2018 – 6/2018 (6 Monate)
Gesundheitswesen
Tätigkeitszeitraum

1/2018 – 6/2018

Tätigkeitsbeschreibung

Development and implementation, correction of existing code, PL/SQL programming, performance tuning, bug fixing.
Installation of ARISg 7.2 and 7.4 services.
Support by Migration to the ARISg version 7.4.
Management of transactions using BizManager.
Processing of tickets.

Eingesetzte Qualifikationen

Good documentation practice (GDP, GDocP), Pharmakologie, Oracle Database

Oracle - Entwickler
RegioCom, Magdeburg
6/2017 – 9/2017 (4 Monate)
High-Tech- und Elektroindustrie
Tätigkeitszeitraum

6/2017 – 9/2017

Tätigkeitsbeschreibung

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

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.

Eingesetzte Qualifikationen

PL/SQL

Oracle Datenbank Entwickler
Deutsche Börse Group, Eschborn
1/2017 – 6/2017 (6 Monate)
Finanzdienstleistiung
Tätigkeitszeitraum

1/2017 – 6/2017

Tätigkeitsbeschreibung

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.

Eingesetzte Qualifikationen

Oracle (allg.), PL/SQL, Git

Data Retrieval Specialist
CSL Behring GmbH, Marburg
5/2014 – 9/2016 (2 Jahre, 5 Monate)
Gesundheitswesen
Tätigkeitszeitraum

5/2014 – 9/2016

Tätigkeitsbeschreibung

Support of an Oracle based safety system for the pharmaceutical industry.
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.

Eingesetzte Qualifikationen

Oracle Database, SQL, PL/SQL

Data Management Spezalist
Hoffmann & La Roche, Basel
4/2011 – 4/2014 (3 Jahre, 1 Monat)
Gesundheitswesen
Tätigkeitszeitraum

4/2011 – 4/2014

Tätigkeitsbeschreibung

Development and support of an Oracle based safety system for the pharmaceutical industry.
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.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Oracle Entwickler
Atos Origin, Frankfurt a. M.
6/2010 – 3/2011 (10 Monate)
Großhandel
Tätigkeitszeitraum

6/2010 – 3/2011

Tätigkeitsbeschreibung

Development of a Commerce and Customer Care system for the gas dealing area.
DB-design, development and implementation, correction of existing program code, programming, performance tuning,
going live support by customers.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Drug Safety Spezialist
Boehringer Ingelheim, Ingelheim an Rhein
6/2009 – 5/2010 (1 Jahr)
Gesundheitswesen
Tätigkeitszeitraum

6/2009 – 5/2010

Tätigkeitsbeschreibung

Development of an Oracle based system for the pharmaceutical industry.
Development and implementation, correction of existing modules (packages, forms and reports), programming, performance tuning.
Creation of Drug Safety reports in ARISg and using Oracle Reports.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Oracle Developer
Atos Origin, Frankfurt a. M.
4/2008 – 3/2009 (1 Jahr)
Großhandel
Tätigkeitszeitraum

4/2008 – 3/2009

Tätigkeitsbeschreibung

Development of a Commerce and Customer Care system for the gas dealing area.
DB-design, development and implementation, correction of existing program code, programming, performance tuning, going live support by customers.

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Oracle Developer
Billing Components, München
10/2006 – 1/2008 (1 Jahr, 4 Monate)
Telekommunikation
Tätigkeitszeitraum

10/2006 – 1/2008

Tätigkeitsbeschreibung

Development and Support of a Billing and Customer Care system for telecommunication companies (GSM operators).
Application and DB-design, development and implementation, programming (server-and client-side), performance tuning, support for end customers.
Front-end design and development via Oracle Forms and Oracle Reports

Eingesetzte Qualifikationen

Oracle Database, PL/SQL

Oracle Developer
Bearing Point, Graz
7/2004 – 10/2006 (2 Jahre, 4 Monate)
Telekommunikation
Tätigkeitszeitraum

7/2004 – 10/2006

Tätigkeitsbeschreibung

Development of an Oracle based Billing and Customer Care system for US telecommunication companies (GSM operators).
Server-side development with Oracle Designer/2000, server side programming (PL/SQL).

Eingesetzte Qualifikationen

Oracle (allg.), PL/SQL

Oracle Developer
BearingPoint, Graz
5/2004 – 7/2004 (3 Monate)
Telekommunikation
Tätigkeitszeitraum

5/2004 – 7/2004

Tätigkeitsbeschreibung

Development of an Oracle based Billing and Customer Care system for Astral MGCP Callagent (Romania) telecommunication company (GSM operators).
Server-side development and programming (PL/SQL).

Eingesetzte Qualifikationen

Oracle (allg.), PL/SQL

Oracle Developer
Billing Components, München
1/2000 – 2/2004 (4 Jahre, 2 Monate)
Telekommunikation
Tätigkeitszeitraum

1/2000 – 2/2004

Tätigkeitsbeschreibung

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

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

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 Forms, Oracle Reports

Eingesetzte Qualifikationen

Oracle (allg.), SQL, SQL*Plus, PL/SQL

Ausbildung

1971
Staatliche Universität
1976
Tomsk

Weitere Kenntnisse

ORACLE 7-9i, 10g, 11g, ORACLE Developer/2000, 1.x-10g (Forms and Reports)
ORACLE Headstart R 1.0, R 2.1, ORACLE SQL*Plus, SQL-Navigator,TOAD, PL/SQL Developer, SQL Developer, Drug Safety Systems: ARISg, VAWES, ARGUS

Persönliche Daten

Sprache
  • Deutsch (Fließend)
  • Englisch (Gut)
  • Russisch (Muttersprache)
Reisebereitschaft
DACH-Region
Arbeitserlaubnis
  • Europäische Union
  • Schweiz
Profilaufrufe
2401
Alter
69
Berufserfahrung
44 Jahre und 2 Monate (seit 01/1980)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden