Home
Get started
Why iGiGXWork from Dubai
Login
Meet Genie
Home / Candidates Listing / Anonym
avatar

Consultant for Oracle based systems - since 1995

Experience:
31 y
Experience:
31 y
Location:
93053 Regensburg
Last update:
21.04.2021
Register to Contact Freelancer
Availability
Available
Rate
Onsite hourly: N/A
Remote hourly: N/A
Languages
Russian: Native
German: Near native
English: Near native
Area Preference
No constraints
Description
SKILLS
Short introduction:
I am a consultant for Oracle based systems with Oracle-experience since 1995. My core areas are:
  • Design, Development and Support of Oracle based systems
  • PL/SQL und SQL
  • Application tuning / SQL-tuning / Database tuning

Experience in projects at:
  • AAPT (www.aapt.com.au)
  • BearingPoint (www.bearingpoint.com)
  • BMW (www.bmw.de)
  • Boehringer Ingelheim (www.boehringer-ingelheim.de)
  • CSC Ploenzke (www.csc.com/de)
  • CSL Behring (www.cslbehring.com)
  • Linde (www.linde.com)
  • Payback (www.payback.net)
  • Softlab (www.softlab.de)
  • VeriSign (www.verisign.com)

and locations in:
  • Australia (Sydney)
  • Austria (Graz)
  • Bahrain (Manama)
  • Germany (Biberach - Ingelheim - Marburg - München)
  • Indien (Bangalore)
  • USA (Savannah)

Experience in branches / areas:
  • Automotive industry – Construction Data Management systems and Quality Control systems
  • Customer Loyalty systems
  • Pharmaceutical / Health Care – Hospital Management systems and Drug Safety systems / Adverse Event & Drug Reaction Reporting systems
  • Plants construction industry – Ordering and Purchase systems
  • Telecommunication – Billing and Customer Care systems

Databases: Oracle 7, Oracle 8 / 8i, Oracle 9i, Oracle 10g, Oracle 11g

Products / Tools:
  • Oracle Clinical, ARISg, Empirica Trace, ARGUS Safety
  • Oracle Application Express 3.0
  • Oracle Developer Suite 9i / 10g
  • Oracle Designer/2000, R 1.3.x , R 6.0
  • Oracle Developer/2000, R 1.3.x,
Other skills
Oracle 7 PL/SQL Oracle 11g MS Excel SQL queries database server-side Oracle Application Express Visual Source Safe embedded SQL application System Oracle Designer back-end Oracle database performance tuning Database tuning requirements definition legacy systems sub-system Oracle applications Programming languages SQL scripts data cleansing 9i Databases XML files user acceptance WebEx Data retrieval GxP GSM SVN XML Oracle Forms Oracle SQL stored procedures data migration Java database design Oracle Developer Data Management system SQL-Navigator C++ APIs Data Management systems ETL programming XML schema Java persistence Oracle 10g test data server side Oracle 8 tier 3 configuration management GSM Network error logging client-server Thin client data structures DB2 Clinical data business logic SQL software design web applications Database administration Hibernate Oracle 9i Oracle FORTRAN Python TOAD Source Control
Work & Experience
01.10.2013 — 31.12.2016
CSL Behring
Project at: CSL Behring (www.cslbehring.com) Location: Marburg, Germany Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5. Data retrieval and data migration support within a Drug Safety & Pharmacovigilance Reporting system (Empirica Trace 4.2) by an international pharmaceutical company in a GxP-validated environment. Tasks: * developing of a framework for batch data cleansing/correction as part of data migration (SQL, PL/SQL) * developing of a framework for the ETL validation in the custom DWH * developing of ad-hoc SQL queries / reports according to the end user requests * general support for team members in the Oracle area
01.10.2013 — 31.10.2014
PAYBACK GmbH
Project at: PAYBACK GmbH, Part of the American Express Group (www.payback.net) Location: Munich, Germany Development of an Oracle & Java based Customer Loyalty system. New Oracle 11g based back-end & Java/JPA2/Hibernate based frontend Customer Loyalty system to be used as a global platform. Tasks - development and support within the Oracle-related part of the system: * data modeling to support high data volumes (partitioning, DWH staging tables) * development of a configurable table partitioning framework (PL/SQL and Python) * design/implementing of a PL/SQL module to export transactions data to the financial sub-system (supports gap-free export file numbers and gap-free line numbers within these files) * implementing of a PL/SQL module to process the personal data disclosure requests * server side programming (PL/SQL) - e.g. Rating and Billing modules with the XML-based rules, module to export the billing data to the financial system * data migration within the loyalty module * support for Java developers at design and implementation of the Java persistence layer regarding SQL-statements * support for team members in the Oracle / SQL area
01.03.2009 — 30.06.2011
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein / Biberach an der Riss, Germany Automatic transfer of the adverse events related data, gathered during clinical trials for new drugs within an Oracle Clinical database (Oracle 9i), to the Drug Safety System - Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2, Oracle 10g) - a new project by a major pharmaceutical company in a GxP-validated environment, which deliveres a generic XML-based publishing service for Oracle Clinical data, prepared for future use of an Enterprise Service Bus. Tasks: * evaluation, clarification and fine-tuning of user requirements * creation of functional specifications, software design specifications and development tests * conceptual design of the system * creation of the underlying XML schema * database design and implementation, installation scripts on the Oracle Clinical side and on the ARISg side * code implementation (server-side PL/SQL), including error logging, auditing and tracing sub-systems on the Oracle Clinical side and on the ARISg side * performance tuning on the Oracle Clinical side * support for user acceptance tests and application validation
01.09.2008 — 31.03.2009
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein, Germany Database-related third-level support, enhancements and development around Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2) by a major pharmaceutical company in a GxP-validated environment. Tasks: * enhancements / corrections to the customized parts of the ARISg application (server-side PL/SQL code) * development of in-house web applications (back-end Oracle 10g) to provide additional functionality for ARISg users (Oracle Application Express) * implementing / applying data correction scripts (SQL and PL/SQL) * third-level support for ARISg application (database-related) * code quality control * general support for team members in the Oracle area
01.03.2008 — 30.09.2008
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein, Germany Data migration GxP project by a major pharmaceutical company - merge of regional production databases spread worldwide into a single database, with concurrent migration / customization of the related third-party application (ARISg - Adverse Drug Event & Reaction Reporting system) to a new major release (5.1.2) and migration to Oracle 10g from Oracle 9i. Tasks: * validation / corrections to the data migration procedures * performance tuning for the data migration scripts * accomplishment of the initial and incremental data migration * validation / corrections to the customized parts of the ARISg application (server-side PL/SQL code) * creation of new server-side PL/SQL procedures in the customized part of the application * code quality control * general support for team members in the Oracle area
01.11.2007 — 29.02.2008
BearingPoint
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria Product enhancements for the Oracle 10g & Java based Billing and Customer Care system, developed in the previous project: * Separation of the core product part from the customizations * Adding the Virtual Service Provider / Virtual Service Operator (VSP/VSO) functionality to the system Tasks - responsibility for the Oracle-related part of the project: * evaluation of areas where the product can / needs to be enhanced and of corresponding design approaches * conceptual design / DB-design of how to use Oracle's Virtual Private Database feature to support required VSP/VSO functionality while keeping system performance * creation of a framework (dedicated PL/SQL packages & SQL scripts) for automated generation of different DDL-scripts (performing table changes, creating views, VPD-policies, grants, synonyms, etc.) necessary for switching to VPD * enhancements / adjustments to the server-side PL/SQL code to support required VSP/VSO functionality * creation of sets of SQL-scripts for populating the database with consistent test data * support for team members in the Oracle area * domain / system know-how transfer to permanent employees
01.04.2006 — 31.10.2007
BearingPoint
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria and Sydney, Australia Development of an Oracle & Java based Billing and Customer Care system for an Australian telecommunication company (Landline and Cellurar / GSM operator). New Oracle 10g based back-end & Java/Hibernate based front-end Billing and Customer Care system for an Australian Landline, Cellurar and GSM operator, which needs to replace their legacy system (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management, bill previews, usage caps, discounting, re-rating and real time billing. Initial CDR validation is implemented in PL/SQL, Rating module is embedded SQL / Java & PL/SQL based, Billing / Invoicing modules are implemented in PL/SQL, and Invoice presentation in Java/XML. Front end: Java/Hibernate GUI. Tasks - responsibility for the Oracle-related part of the system design, development and support: * creation of development specifications * application DB-design, implementation and server side programming (PL/SQL) - Rating, Billing and Invoicing modules (here Billing module has been completely specified, designed and implemented from scratch single-handedly) * complex core SQL for Rating module to be called from Java layer * major corrections / enhancements in data replication to/from Accounts Receivables module * design/code quality control * database/application performance tuning * support for team members in the Oracle area * training for support team members * on-site support of QA / performance tests
01.01.2005 — 31.12.2021
freelancermap GmbH
× Newsletteranmeldung erfolgreich Sie haben sich erfolgreich für den freelancermap Newsletter angemeldet.
01.05.2004 — 31.03.2006
BearingPoint
Java GUI.
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria and Savannah GA, USA and Bangalore, India Development of an Oracle based Billing and Customer Care system for US telecommunication companies (Cellurar/GSM operators) - Releases 1 and 2. New Oracle 9i based Billing System (client-server) for US Cellurar and GSM operators (over 40 installations), which have to replace their COBOL based legacy systems (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management with threading, 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, near real time billing. Front end: Java GUI. Tasks - Oracle development team leader for the Billing / Rating server side module: * requirements definition on-site with the customer * creation of development specifications * application DB-design and implementation * server side programming (PL/SQL, Java stored procedures) * support for developer team in the Oracle area * design/code quality control * on-site database/application performance tuning * on-site processing of customers change requests * on-site support for customer QA tests / end user acceptance tests * on-site training and WebEx knowledge sharing sessions for the customer and for application support team members * creation of application manuals / documentation for end users
01.05.2002 — 30.04.2004
Billing Components GmbH
Designer
Project at: Billing Components GmbH (initially within Telesens KSCL AG) (www.billing-components.com) Location: Munich, Germany and Manama, Bahrain Development of an Oracle 9i based Billing and Customer Care system for telecommunication companies (GSM operators). 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). Flexible and powerful security system (dynamically enabled Oracle roles, "fine-grained row-level access control" and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent "on-customer-site" development. Data export from application to XML files. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). 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. Tasks - Oracle development team leader: * application System- and DB-design and implementation * creation of development specifications * technical development management * support for other developers in the Oracle area * design/code quality control * programming (server-side and client-side) * performance tuning * support for end customers * configuration management in emergency cases * DBA-tasks in emergency cases
01.04.1999 — 30.04.2002
CSC Ploenzke
Designer
Project at: CSC Ploenzke (www.csc.com/de) Location: Munich, Germany Development of an Oracle 7/8/8i based Billing and Customer Care system for telecommunication companies (GSM operators). Initially Oracle 7, then Oracle 8/8i 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). Flexible and powerful security system (dynamically enabled Oracle roles, "fine-grained row-level access control" and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent "on-customer-site" development. Data export from application to XML files. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). 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. Tasks - Oracle development team leader: * application System- and DB-design and implementation * creation of development specifications * technical development management * support for other developers in the Oracle area * design/code quality control * programming (server-side and client-side) * performance tuning * support for end customers * configuration management in emergency cases * DBA-tasks in emergency cases
01.02.1999 — 31.03.1999
BMW (via Softlab GmbH)
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Development of a Construction Data Management system for a major automobile construction company. Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C. Tasks: * DB-design * programming (server-side: packaged PL/SQL procedures) * performance tuning
01.09.1998 — 31.01.1999
Linde (via Softlab GmbH)
Designer
Project at: Linde (via Softlab GmbH) (www.linde.com) Location: Munich, Germany Development of an Ordering, Purchase and Delivery system for a major plant construction company. Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets. Tasks: * DB-design and implementation * PL/SQL programming (server-and client-side) * performance tuning * customer support
01.08.1998 — 31.08.1998
BMW (via Softlab GmbH)
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Development of a Construction Data Management system for a major automobile construction company. Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C. Tasks: * DB-design * programming (server-side: packaged PL/SQL procedures) * performance tuning
01.01.1998 — 31.07.1998
Linde (via Softlab GmbH)
Designer
Project at: Linde (via Softlab GmbH) (www.linde.com) Location: Munich, Germany Development of an Ordering, Purchase and Delivery system for a major plant construction company. Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets. Tasks: * DB-design and implementation * PL/SQL programming (server-and client-side) * performance tuning * customer support
01.10.1997 — 31.12.1997
BMW (via Softlab GmbH)
Designer
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Change request for a Quality Control system, used by a major automobile construction company. Oracle 7 based client-server application to manage various data, obtained during different quality control procedures. Front end: Oracle Forms and Reports. Business logic implemented partially on the server side (via DB-triggers and packaged PL/SQL procedures), and partially on the client side. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000 and Developer/2000. Most of Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000, and some Forms have been created completely with Developer/2000. Tasks: * Server-side and client-side PL/SQL programming * Forms generation and manual changing/creation
01.10.1995 — 30.09.1997
Klinik OP-Data GmbH
Project at: Klinik OP-Data GmbH Location: Regensburg, Germany Development of a Hospital Management system for German hospitals. 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-side and client-side PL/SQL programming * Forms creation * Database administration and tuning
PROFILBILD
Drug Safety Specialist
Oracle SQL PL/SQL ArisG argus Drug Safety Specialist PROFILBILD DATEIANLAGEN Juri Wolfenhaut CV (PDF) Der Download dieser Datei ist nur mit einem kostenpflichtigen Account möglich. Jetzt Upgrade durchführen Juri Wolfenhaut CV (Word) Der Download dieser Datei ist nur mit einem kostenpflichtigen Account möglich. Jetzt Upgrade durchführen
ZEITLICHE UND RÄUMLICHE; Plz; Informationen für Agenturen
Informationen für Freelancer
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT No constraints KONTAKTANFRAGE VERSENDEN Sie können diesen User nicht kontaktieren, da dieser auf Ihrer Blacklist steht. Nachricht: Betreff * Anschreiben * Absenderdaten: Name * Firma E-Mail * Telefon * Plz * Stadt * Land * Land wählen Deutschland Österreich Schweiz Großbritannien USA Russische Föderation Spanien Italien Liechtenstein Ukraine Ungarn Neuseeland Frankreich Slowakei Antigua and Barbuda Algeria Albanien Ägypten Argentinien Armenien Australien Bahamas Bahrain Bangladesch Barbados Belarus Belgien Belize Benin Bermuda Bolivien Botswana Brasilien Bulgarien Chile China Costa Rica Dänemark Dominikanische Republik Estland Finnland Georgien Grenada Griechenland Guadeloupe Guatemala Guinea Guyana Haiti Hongkong Indien Indonesien Irak Irland Island Israel Jamaika Japan Jordanien Kamerun Kanada Kazakhstan Katar Kenya Kirgisistan Kolumbien Kroatien Kuba Kuwait Lettland Liberia Litauen Luxemburg Mazedonien Malaysia Malta Marokko Mexico Monaco Montserrat Mosambik Namibia Nepal Niederlande Norwegen Oman Pakistan Paraguay Peru Philippinen Polen Portugal Puerto Rico Rumänien Sambia Saudi Arabien Schweden Senegal Zimbabwe Singapur Slowenien Sri Lanka Südafrika Tadschikistan Thailand Tschechische Republik Tunesien Türkei Uruguay Usbekistan Venezuela Vereinigte Arabische Emirate Yemen Zypern Libanon Serbien Bosnien-Herzegowina Vietnam Nigeria Moldawien Marschallinseln Palau Samoa Cookinseln Angola Grönland Trinidad und Tobago Equador Fidschi Inseln Papua-Neuguinea Tansania Äthiopien Kongo Swaziland Niger Ghana Südkorea Nordkorea Mongolei Kambodscha Myanmar Azerbaijan Syrien Afghanistan Iran San Marino Montenegro Mauritius Uganda Palästina Panama El Salvador Honduras Libyen Malediven Nicaragua Madagascar Sudan Website Anfrage verschicken × Profil herunterladen Welche persönliche Daten sollen in dem Dokument sichtbar sein: Name Telefon E-Mail Stunden-/Tagessatz Profil herunterladen AUFTRAGNEHMER * Informationen für Freelancer * Informationen für Agenturen * Projekte finden * Musterverträge * Berufshaftpflicht * Preise und Leistungen
AUFTRAGGEBER; HILFE UND SUPPORT
Informationen für Recruiter
* Business Mitgliedschaft * Enterprise Mitgliedschaft * Datenschutzmodul * Top-Projekt * Automatischer Projektimport * Preise und Leistungen HILFE UND SUPPORT * FAQ * Kontakt * RSS * Sitemap * Preise und Leistungen
ÜBER UNS
Unsere Partner
ÜBER UNS * Kundenecho * Werben Sie bei uns * Presse * Unsere Partner * Werden Sie Partner * Karriere
SOZIALE NETZWERKE
SOZIALE NETZWERKE * facebook * Twitter * LinkedIn RECHTLICHES * Datenschutz * AGB * Impressum
RATGEBER UND BLOG; FREELANCER KOMPASS
Die freelancermap-Marktstudie für Freelancer
RATGEBER UND BLOG Der freelancermap-Blog bietet Ihnen spannende Ratgeberartikel rund um das Thema Freelancing und Selbstständigkeit FREELANCER KOMPASS Die freelancermap-Marktstudie für Freelancer, Selbständige und Freiberufler CASE STUDIES Lesen Sie spannende Erfolggeschichten von begeisterten Kunden!
Attachments
JuriWolfenhautCV(PDF)
JuriWolfenhautCV(Word)

Description

SKILLS
Short introduction:
I am a consultant for Oracle based systems with Oracle-experience since 1995. My core areas are:
  • Design, Development and Support of Oracle based systems
  • PL/SQL und SQL
  • Application tuning / SQL-tuning / Database tuning

Experience in projects at:
  • AAPT (www.aapt.com.au)
  • BearingPoint (www.bearingpoint.com)
  • BMW (www.bmw.de)
  • Boehringer Ingelheim (www.boehringer-ingelheim.de)
  • CSC Ploenzke (www.csc.com/de)
  • CSL Behring (www.cslbehring.com)
  • Linde (www.linde.com)
  • Payback (www.payback.net)
  • Softlab (www.softlab.de)
  • VeriSign (www.verisign.com)

and locations in:
  • Australia (Sydney)
  • Austria (Graz)
  • Bahrain (Manama)
  • Germany (Biberach - Ingelheim - Marburg - München)
  • Indien (Bangalore)
  • USA (Savannah)

Experience in branches / areas:
  • Automotive industry – Construction Data Management systems and Quality Control systems
  • Customer Loyalty systems
  • Pharmaceutical / Health Care – Hospital Management systems and Drug Safety systems / Adverse Event & Drug Reaction Reporting systems
  • Plants construction industry – Ordering and Purchase systems
  • Telecommunication – Billing and Customer Care systems

Databases: Oracle 7, Oracle 8 / 8i, Oracle 9i, Oracle 10g, Oracle 11g

Products / Tools:
  • Oracle Clinical, ARISg, Empirica Trace, ARGUS Safety
  • Oracle Application Express 3.0
  • Oracle Developer Suite 9i / 10g
  • Oracle Designer/2000, R 1.3.x , R 6.0
  • Oracle Developer/2000, R 1.3.x,

Main Skills

Other Skills

Oracle 7 PL/SQL Oracle 11g MS Excel SQL queries database server-side Oracle Application Express Visual Source Safe embedded SQL application System Oracle Designer back-end Oracle database performance tuning Database tuning requirements definition legacy systems sub-system Oracle applications Programming languages SQL scripts data cleansing 9i Databases XML files user acceptance WebEx Data retrieval GxP GSM SVN XML Oracle Forms Oracle SQL stored procedures data migration Java database design Oracle Developer Data Management system SQL-Navigator C++ APIs Data Management systems ETL programming XML schema Java persistence Oracle 10g test data server side Oracle 8 tier 3 configuration management GSM Network error logging client-server Thin client data structures DB2 Clinical data business logic SQL software design web applications Database administration Hibernate Oracle 9i Oracle FORTRAN Python TOAD Source Control

Work & Experience

01.10.2013 — 31.12.2016
CSL Behring
Project at: CSL Behring (www.cslbehring.com) Location: Marburg, Germany Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5. Data retrieval and data migration support within a Drug Safety & Pharmacovigilance Reporting system (Empirica Trace 4.2) by an international pharmaceutical company in a GxP-validated environment. Tasks: * developing of a framework for batch data cleansing/correction as part of data migration (SQL, PL/SQL) * developing of a framework for the ETL validation in the custom DWH * developing of ad-hoc SQL queries / reports according to the end user requests * general support for team members in the Oracle area
01.10.2013 — 31.10.2014
PAYBACK GmbH
Project at: PAYBACK GmbH, Part of the American Express Group (www.payback.net) Location: Munich, Germany Development of an Oracle & Java based Customer Loyalty system. New Oracle 11g based back-end & Java/JPA2/Hibernate based frontend Customer Loyalty system to be used as a global platform. Tasks - development and support within the Oracle-related part of the system: * data modeling to support high data volumes (partitioning, DWH staging tables) * development of a configurable table partitioning framework (PL/SQL and Python) * design/implementing of a PL/SQL module to export transactions data to the financial sub-system (supports gap-free export file numbers and gap-free line numbers within these files) * implementing of a PL/SQL module to process the personal data disclosure requests * server side programming (PL/SQL) - e.g. Rating and Billing modules with the XML-based rules, module to export the billing data to the financial system * data migration within the loyalty module * support for Java developers at design and implementation of the Java persistence layer regarding SQL-statements * support for team members in the Oracle / SQL area
01.03.2009 — 30.06.2011
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein / Biberach an der Riss, Germany Automatic transfer of the adverse events related data, gathered during clinical trials for new drugs within an Oracle Clinical database (Oracle 9i), to the Drug Safety System - Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2, Oracle 10g) - a new project by a major pharmaceutical company in a GxP-validated environment, which deliveres a generic XML-based publishing service for Oracle Clinical data, prepared for future use of an Enterprise Service Bus. Tasks: * evaluation, clarification and fine-tuning of user requirements * creation of functional specifications, software design specifications and development tests * conceptual design of the system * creation of the underlying XML schema * database design and implementation, installation scripts on the Oracle Clinical side and on the ARISg side * code implementation (server-side PL/SQL), including error logging, auditing and tracing sub-systems on the Oracle Clinical side and on the ARISg side * performance tuning on the Oracle Clinical side * support for user acceptance tests and application validation
01.09.2008 — 31.03.2009
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein, Germany Database-related third-level support, enhancements and development around Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2) by a major pharmaceutical company in a GxP-validated environment. Tasks: * enhancements / corrections to the customized parts of the ARISg application (server-side PL/SQL code) * development of in-house web applications (back-end Oracle 10g) to provide additional functionality for ARISg users (Oracle Application Express) * implementing / applying data correction scripts (SQL and PL/SQL) * third-level support for ARISg application (database-related) * code quality control * general support for team members in the Oracle area
01.03.2008 — 30.09.2008
Boehringer Ingelheim
Project at: Boehringer Ingelheim (www.boehringer-ingelheim.de) Location: Ingelheim am Rhein, Germany Data migration GxP project by a major pharmaceutical company - merge of regional production databases spread worldwide into a single database, with concurrent migration / customization of the related third-party application (ARISg - Adverse Drug Event & Reaction Reporting system) to a new major release (5.1.2) and migration to Oracle 10g from Oracle 9i. Tasks: * validation / corrections to the data migration procedures * performance tuning for the data migration scripts * accomplishment of the initial and incremental data migration * validation / corrections to the customized parts of the ARISg application (server-side PL/SQL code) * creation of new server-side PL/SQL procedures in the customized part of the application * code quality control * general support for team members in the Oracle area
01.11.2007 — 29.02.2008
BearingPoint
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria Product enhancements for the Oracle 10g & Java based Billing and Customer Care system, developed in the previous project: * Separation of the core product part from the customizations * Adding the Virtual Service Provider / Virtual Service Operator (VSP/VSO) functionality to the system Tasks - responsibility for the Oracle-related part of the project: * evaluation of areas where the product can / needs to be enhanced and of corresponding design approaches * conceptual design / DB-design of how to use Oracle's Virtual Private Database feature to support required VSP/VSO functionality while keeping system performance * creation of a framework (dedicated PL/SQL packages & SQL scripts) for automated generation of different DDL-scripts (performing table changes, creating views, VPD-policies, grants, synonyms, etc.) necessary for switching to VPD * enhancements / adjustments to the server-side PL/SQL code to support required VSP/VSO functionality * creation of sets of SQL-scripts for populating the database with consistent test data * support for team members in the Oracle area * domain / system know-how transfer to permanent employees
01.04.2006 — 31.10.2007
BearingPoint
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria and Sydney, Australia Development of an Oracle & Java based Billing and Customer Care system for an Australian telecommunication company (Landline and Cellurar / GSM operator). New Oracle 10g based back-end & Java/Hibernate based front-end Billing and Customer Care system for an Australian Landline, Cellurar and GSM operator, which needs to replace their legacy system (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management, bill previews, usage caps, discounting, re-rating and real time billing. Initial CDR validation is implemented in PL/SQL, Rating module is embedded SQL / Java & PL/SQL based, Billing / Invoicing modules are implemented in PL/SQL, and Invoice presentation in Java/XML. Front end: Java/Hibernate GUI. Tasks - responsibility for the Oracle-related part of the system design, development and support: * creation of development specifications * application DB-design, implementation and server side programming (PL/SQL) - Rating, Billing and Invoicing modules (here Billing module has been completely specified, designed and implemented from scratch single-handedly) * complex core SQL for Rating module to be called from Java layer * major corrections / enhancements in data replication to/from Accounts Receivables module * design/code quality control * database/application performance tuning * support for team members in the Oracle area * training for support team members * on-site support of QA / performance tests
01.01.2005 — 31.12.2021
freelancermap GmbH
× Newsletteranmeldung erfolgreich Sie haben sich erfolgreich für den freelancermap Newsletter angemeldet.
01.05.2004 — 31.03.2006
BearingPoint
Java GUI.
Project at: BearingPoint (www.bearingpoint.com) Location: Graz, Austria and Savannah GA, USA and Bangalore, India Development of an Oracle based Billing and Customer Care system for US telecommunication companies (Cellurar/GSM operators) - Releases 1 and 2. New Oracle 9i based Billing System (client-server) for US Cellurar and GSM operators (over 40 installations), which have to replace their COBOL based legacy systems (full cycle from CDR processing to bill presentation). Includes features like flexible bill cycle and bill run management with threading, 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, near real time billing. Front end: Java GUI. Tasks - Oracle development team leader for the Billing / Rating server side module: * requirements definition on-site with the customer * creation of development specifications * application DB-design and implementation * server side programming (PL/SQL, Java stored procedures) * support for developer team in the Oracle area * design/code quality control * on-site database/application performance tuning * on-site processing of customers change requests * on-site support for customer QA tests / end user acceptance tests * on-site training and WebEx knowledge sharing sessions for the customer and for application support team members * creation of application manuals / documentation for end users
01.05.2002 — 30.04.2004
Billing Components GmbH
Designer
Project at: Billing Components GmbH (initially within Telesens KSCL AG) (www.billing-components.com) Location: Munich, Germany and Manama, Bahrain Development of an Oracle 9i based Billing and Customer Care system for telecommunication companies (GSM operators). 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). Flexible and powerful security system (dynamically enabled Oracle roles, "fine-grained row-level access control" and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent "on-customer-site" development. Data export from application to XML files. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). 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. Tasks - Oracle development team leader: * application System- and DB-design and implementation * creation of development specifications * technical development management * support for other developers in the Oracle area * design/code quality control * programming (server-side and client-side) * performance tuning * support for end customers * configuration management in emergency cases * DBA-tasks in emergency cases
01.04.1999 — 30.04.2002
CSC Ploenzke
Designer
Project at: CSC Ploenzke (www.csc.com/de) Location: Munich, Germany Development of an Oracle 7/8/8i based Billing and Customer Care system for telecommunication companies (GSM operators). Initially Oracle 7, then Oracle 8/8i 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). Flexible and powerful security system (dynamically enabled Oracle roles, "fine-grained row-level access control" and security policies via the DBMS_RLS package, DBA-tasks like create/drop users and roles, grant/revoke privileges are performed directly via the application, managing of DB-objects both from the application schema and from other schemas). Full interface layer for data structures and business logic to enable independent "on-customer-site" development. Data export from application to XML files. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000, Developer/2000 and Headstart. All Forms and most of Reports are 100% generated (zero-gap). 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. Tasks - Oracle development team leader: * application System- and DB-design and implementation * creation of development specifications * technical development management * support for other developers in the Oracle area * design/code quality control * programming (server-side and client-side) * performance tuning * support for end customers * configuration management in emergency cases * DBA-tasks in emergency cases
01.02.1999 — 31.03.1999
BMW (via Softlab GmbH)
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Development of a Construction Data Management system for a major automobile construction company. Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C. Tasks: * DB-design * programming (server-side: packaged PL/SQL procedures) * performance tuning
01.09.1998 — 31.01.1999
Linde (via Softlab GmbH)
Designer
Project at: Linde (via Softlab GmbH) (www.linde.com) Location: Munich, Germany Development of an Ordering, Purchase and Delivery system for a major plant construction company. Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets. Tasks: * DB-design and implementation * PL/SQL programming (server-and client-side) * performance tuning * customer support
01.08.1998 — 31.08.1998
BMW (via Softlab GmbH)
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Development of a Construction Data Management system for a major automobile construction company. Oracle 7 based client-server application to manage constructional data of automobiles and their modules/components. Front end: C++ based screens. Access to the (distributed) Oracle database via Oracle Pro*C. Tasks: * DB-design * programming (server-side: packaged PL/SQL procedures) * performance tuning
01.01.1998 — 31.07.1998
Linde (via Softlab GmbH)
Designer
Project at: Linde (via Softlab GmbH) (www.linde.com) Location: Munich, Germany Development of an Ordering, Purchase and Delivery system for a major plant construction company. Oracle 7 based client-server application to manage goods ordering, purchase and delivery, integrated into the heterogeneous software system of the company, therefore many interfaces to other non-Oracle applications (e.g. DB2, legacy systems, MS Excel). Front end: Oracle Forms and Reports. Complex business logic implemented completely on the server side (via standardized table-APIs and DB-triggers, calling packaged PL/SQL procedures). Server-side development is done with Oracle Designer/2000, clientside development with Oracle Designer/2000 and Developer/2000. Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000 (mainly the complex presentation logic has been added: standardized Form-level triggers called PL/SQL procedures form attached libraries). Common look & feel due to using of templates and preference sets. Tasks: * DB-design and implementation * PL/SQL programming (server-and client-side) * performance tuning * customer support
01.10.1997 — 31.12.1997
BMW (via Softlab GmbH)
Designer
Project at: BMW (via Softlab GmbH) (www.bmw.de) Location: Munich, Germany Change request for a Quality Control system, used by a major automobile construction company. Oracle 7 based client-server application to manage various data, obtained during different quality control procedures. Front end: Oracle Forms and Reports. Business logic implemented partially on the server side (via DB-triggers and packaged PL/SQL procedures), and partially on the client side. Server-side development is done with Oracle Designer/2000, client-side development with Oracle Designer/2000 and Developer/2000. Most of Forms and Reports have been generated with the Designer/2000 and then changed "manually" with the Developer/2000, and some Forms have been created completely with Developer/2000. Tasks: * Server-side and client-side PL/SQL programming * Forms generation and manual changing/creation
01.10.1995 — 30.09.1997
Klinik OP-Data GmbH
Project at: Klinik OP-Data GmbH Location: Regensburg, Germany Development of a Hospital Management system for German hospitals. 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-side and client-side PL/SQL programming * Forms creation * Database administration and tuning
PROFILBILD
Drug Safety Specialist
Oracle SQL PL/SQL ArisG argus Drug Safety Specialist PROFILBILD DATEIANLAGEN Juri Wolfenhaut CV (PDF) Der Download dieser Datei ist nur mit einem kostenpflichtigen Account möglich. Jetzt Upgrade durchführen Juri Wolfenhaut CV (Word) Der Download dieser Datei ist nur mit einem kostenpflichtigen Account möglich. Jetzt Upgrade durchführen
ZEITLICHE UND RÄUMLICHE; Plz; Informationen für Agenturen
Informationen für Freelancer
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT No constraints KONTAKTANFRAGE VERSENDEN Sie können diesen User nicht kontaktieren, da dieser auf Ihrer Blacklist steht. Nachricht: Betreff * Anschreiben * Absenderdaten: Name * Firma E-Mail * Telefon * Plz * Stadt * Land * Land wählen Deutschland Österreich Schweiz Großbritannien USA Russische Föderation Spanien Italien Liechtenstein Ukraine Ungarn Neuseeland Frankreich Slowakei Antigua and Barbuda Algeria Albanien Ägypten Argentinien Armenien Australien Bahamas Bahrain Bangladesch Barbados Belarus Belgien Belize Benin Bermuda Bolivien Botswana Brasilien Bulgarien Chile China Costa Rica Dänemark Dominikanische Republik Estland Finnland Georgien Grenada Griechenland Guadeloupe Guatemala Guinea Guyana Haiti Hongkong Indien Indonesien Irak Irland Island Israel Jamaika Japan Jordanien Kamerun Kanada Kazakhstan Katar Kenya Kirgisistan Kolumbien Kroatien Kuba Kuwait Lettland Liberia Litauen Luxemburg Mazedonien Malaysia Malta Marokko Mexico Monaco Montserrat Mosambik Namibia Nepal Niederlande Norwegen Oman Pakistan Paraguay Peru Philippinen Polen Portugal Puerto Rico Rumänien Sambia Saudi Arabien Schweden Senegal Zimbabwe Singapur Slowenien Sri Lanka Südafrika Tadschikistan Thailand Tschechische Republik Tunesien Türkei Uruguay Usbekistan Venezuela Vereinigte Arabische Emirate Yemen Zypern Libanon Serbien Bosnien-Herzegowina Vietnam Nigeria Moldawien Marschallinseln Palau Samoa Cookinseln Angola Grönland Trinidad und Tobago Equador Fidschi Inseln Papua-Neuguinea Tansania Äthiopien Kongo Swaziland Niger Ghana Südkorea Nordkorea Mongolei Kambodscha Myanmar Azerbaijan Syrien Afghanistan Iran San Marino Montenegro Mauritius Uganda Palästina Panama El Salvador Honduras Libyen Malediven Nicaragua Madagascar Sudan Website Anfrage verschicken × Profil herunterladen Welche persönliche Daten sollen in dem Dokument sichtbar sein: Name Telefon E-Mail Stunden-/Tagessatz Profil herunterladen AUFTRAGNEHMER * Informationen für Freelancer * Informationen für Agenturen * Projekte finden * Musterverträge * Berufshaftpflicht * Preise und Leistungen
AUFTRAGGEBER; HILFE UND SUPPORT
Informationen für Recruiter
* Business Mitgliedschaft * Enterprise Mitgliedschaft * Datenschutzmodul * Top-Projekt * Automatischer Projektimport * Preise und Leistungen HILFE UND SUPPORT * FAQ * Kontakt * RSS * Sitemap * Preise und Leistungen
ÜBER UNS
Unsere Partner
ÜBER UNS * Kundenecho * Werben Sie bei uns * Presse * Unsere Partner * Werden Sie Partner * Karriere
SOZIALE NETZWERKE
SOZIALE NETZWERKE * facebook * Twitter * LinkedIn RECHTLICHES * Datenschutz * AGB * Impressum
RATGEBER UND BLOG; FREELANCER KOMPASS
Die freelancermap-Marktstudie für Freelancer
RATGEBER UND BLOG Der freelancermap-Blog bietet Ihnen spannende Ratgeberartikel rund um das Thema Freelancing und Selbstständigkeit FREELANCER KOMPASS Die freelancermap-Marktstudie für Freelancer, Selbständige und Freiberufler CASE STUDIES Lesen Sie spannende Erfolggeschichten von begeisterten Kunden!

Attachments

JuriWolfenhautCV(PDF)
JuriWolfenhautCV(Word)