Oracle DB Entwickler, Drug Safety Spezialist
- Verfügbarkeit einsehen
- 8 Referenzen
- auf Anfrage
- 93197 Zeitlarn
- DACH-Region
- ru | de | en
- 02.07.2020
Kurzvorstellung
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."
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.
PL/SQL
"A. arbeitet ausgesprochen sorgfältig, zuverlässig und selbständig. Excellentes ORACLE-Wissen und PL/SQL Programmier-Erfahrung."
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.
Oracle-Anwendungen, 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"
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.
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"
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.
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."
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.
Oracle Database, PL/SQL
"Sehr schnelle Einarbeitung!
sehr flexibel einsetzbar
sehr zuverlässig
top Arbeitsqualität
immer wieder gerne"
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.
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."
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
Oracle Database, PL/SQL
"Stimmt."
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
Oracle-Anwendungen, SQL, SQL*Plus, PL/SQL
Qualifikationen
Projekt‐ & Berufserfahrung
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.
Oracle Database, PL/SQL
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.
Softwaredokumentation, Pharmakologie, Oracle Database
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.
PL/SQL
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.
Oracle-Anwendungen, PL/SQL, Git
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.
Oracle Database, SQL, PL/SQL
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.
Oracle Database, PL/SQL
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.
Oracle Database, PL/SQL
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.
Oracle Database, PL/SQL
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.
Oracle Database, PL/SQL
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
Oracle Database, PL/SQL
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).
Oracle-Anwendungen, PL/SQL
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).
Oracle-Anwendungen, PL/SQL
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
Oracle-Anwendungen, SQL, SQL*Plus, PL/SQL
Ausbildung
Tomsk
Weitere Kenntnisse
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
- Deutsch (Fließend)
- Englisch (Gut)
- Russisch (Muttersprache)
- Europäische Union
- Schweiz
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden