Oracle-Datenbankspezialist, Drug Safety Specialist

Description

SKILLS

Know How in den Bereichen Mediation,Rating,Billing; ORACLE,PL/SQL,Java,UNIX;Oracle PL/SQL,Oracle Forms,Reports,Server Logik (Packages,Trigger,Procedures),Drug Safety, ARISg, Empirica Trace, ARGUS, SVN, GitHub, Adobe Frame Maker_ Assyst

Main Skills

Other Skills

log files

SVN

Oracle Forms

Oracle PL/SQL

Oracle SQL

Java

Informationstechnologie

data migration

Adobe

MS Office

programming

Oracle 8

Code Reviews

Oracle Designer

APIs

Thin client

client-server

Oracle

Oracle Database

UNIX

SQL

PL/SQL

XML files

GitHub

Oracle 9i

Server-side

Work & Experience

01.09.2018 — Now

Fraunhofer Gesellschaft

Sonstiges

PL/SQL Consultant. Support in the SIGMA project especially in areas Personal and Accounting.

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.

01.01.2018 — 30.09.2018

Boehringer Ingelheim

Pharma und Medizintechnik

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

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. Creation of documentation (Installation Plans, Development Tests, Source Code Reviews

01.06.2017 — 30.09.2017

RegioCom

Energie, Wasser und Umwelt

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

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.

01.01.2017 — 30.06.2017

Deutsche Börse AG

Banken und Finanzdienstleistungen

Oracle Consultant

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.

01.05.2014 — 31.05.2016

CSL Behring

Pharma und Medizintechnik

Drug Safety Reporting.

Preparing, execution and verification of different Drug Safety reports. Migration of DrugSafety reports from Empirica Trace to ARGUS 7.0.5. SQL queries, Performance Tuning, PL/SQL Business logic (DB packages, procedures).

01.04.2011 — 30.04.2014

F. Hoffmann - La Roche AG

Pharma und Medizintechnik

Drug Safety Reporting.

Preparing, execution and verification of different Drug Safety reports. SQL queries, Performance Tuning, PL/SQL Business logic (DB packages, procedures). Preparing and testing of installation scripts for DB objects.

01.06.2010 — 31.03.2011

Atos Origin

Internet und Informationstechnologie

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

DB-design, PL/SQL development and implementation, correction of existing program code, programming, performance tuning. Going live support by end customers.

01.06.2009 — 31.05.2010

Boehringer Ingelheim

Pharma und Medizintechnik

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

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

01.04.2008 — 31.03.2009

Atos Origin

Internet und Informationstechnologie

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.

01.10.2006 — 31.01.2008

Billing Components

Telekommunikation

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

Initially Oracle 7, then Oracle 8/8i, then Oracle 9i and 10g 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.

01.07.2004 — 31.10.2006

Bearing Point

Telekommunikation

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

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).

01.05.2004 — 31.07.2004

Bearing Point

Telekommunikation

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).

01.01.2000 — 29.02.2004

CSC Pkoenzke, Billing Components, Telesens

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.

01.05.1997 — 31.12.1999

Klinik OP Data

Internet und Informationstechnologie

Development of a Hospital Management system for German hospitals.

Server-and client-side programming (PL/SQL, Java), Forms creation, performance tuning.

Attachments

JobReferenceAtosOrigin

JobReferenceBearingPoint

JobReferenceCSLBehring

IKMPL/SQLTest03-Nov-2017

ZertifikatLinuxBashKurs

WolfenhautCVmitProjekthistorie

A.WolfenhautCVmitProjekthistorie