Upgrade Projekt einstellen
AW

Alexander Wolfenhaut

Zeitlarn
verfügbar

Letztes Update: 06.09.2022

Oracle-Datenbankspezialist, Drug Safety Specialist

Abschluss: Universität Tomsk Russische Föderation Matematik und Mechanik
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (gut) | englisch (verhandlungssicher) | russisch (Muttersprache)

Schlagwörter

Dateianlagen

alexander-wolfenhaut_job_reference_atos.pdf
jobreference_bearingpoint_2.pdf
jobreference_csl_behring.pdf
ikm-pl-sql-test-result-92912199.pdf
zertifikat_linux_bash_kurs.pdf
CV_AWolfenhaut.doc

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

Projekthistorie

09/2018 - bis jetzt
PL/SQL Consultant. Support in the SIGMA project especially in areas Personal and Accounting.
Fraunhofer Gesellschaft (Sonstiges, >10.000 Mitarbeiter)

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/2018 - 09/2018
Development and support of an Oracle based system for the pharmaceutical industry.
Boehringer Ingelheim (Pharma und Medizintechnik, >10.000 Mitarbeiter)
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
06/2017 - 09/2017
Support of an Oracle based System for the management of energy producers
RegioCom (Energie, Wasser und Umwelt, 1000-5000 Mitarbeiter)
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/2017 - 06/2017
Oracle Consultant
Deutsche Börse AG (Banken und Finanzdienstleistungen, 5000-10.000 Mitarbeiter)
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.
05/2014 - 05/2016
Drug Safety Reporting.
CSL Behring (Pharma und Medizintechnik, 5000-10.000 Mitarbeiter)
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).
04/2011 - 04/2014
Drug Safety Reporting.
F. Hoffmann - La Roche AG (Pharma und Medizintechnik, >10.000 Mitarbeiter)
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.
06/2010 - 03/2011
Development of a Commerce and Customer Care system for the gas dealing area.
Atos Origin (Internet und Informationstechnologie, 5000-10.000 Mitarbeiter)

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

06/2009 - 05/2010
Development and support of an Oracle based system for the pharmaceutical industry.
Boehringer Ingelheim (Pharma und Medizintechnik, >10.000 Mitarbeiter)

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

04/2008 - 03/2009
Development of a Commerce and Customer Care system for the gas dealing area.
Atos Origin (Internet und Informationstechnologie, 5000-10.000 Mitarbeiter)

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

10/2006 - 01/2008
Development and Support of a Billing and Customer Care system for telecommunication companies (GSM operators)
Billing Components (Telekommunikation, 50-250 Mitarbeiter)

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.

07/2004 - 10/2006
Development of an Oracle based Billing and Customer Care system for US telecommunication companies (GSM operators).
Bearing Point (Telekommunikation, 5000-10.000 Mitarbeiter)

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

05/2004 - 07/2004
Development of an Oracle based Billing and Customer Care system for Astral MGCP Callagent (Romania) telecommunication company (GSM operators).
Bearing Point (Telekommunikation, 5000-10.000 Mitarbeiter)

Server-side development and programming (PL/SQL).

01/2000 - 02/2004
Development and Support of a Billing and Customer Care system for telecommunication companies (GSM operators)
CSC Pkoenzke, Billing Components, Telesens (5000-10.000 Mitarbeiter)

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

05/1997 - 12/1999
Development of a Hospital Management system for German hospitals.
Klinik OP Data (Internet und Informationstechnologie, 10-50 Mitarbeiter)

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

Reisebereitschaft

Verfügbar in den Ländern Deutschland, Österreich und Schweiz
deutschlandweit
Profilbild von Alexander Wolfenhaut Oracle-Datenbankspezialist, Drug Safety Specialist aus Zeitlarn Oracle-Datenbankspezialist, Drug Safety Specialist
Registrieren