Juri Wolfenhaut - Data Warehouse Consultant

Q: Where is Juri based?

Juri is based in Regensburg, Germany and can operate in on-site , hybrid , and remote work models.

Q: What languages does Juri speak?

Juri speaks the following languages: German (Native), Russian (Advanced), English (Elementary) .

Q: How many years of experience does Juri have?

Juri has at least 29 years of experience. During this time, Juri has worked in at least 2 different roles and for 8 different companies . The average length of individual experience is 2 years and 8 months . Note that Juri may not have shared all experience and actually has more experience.

Q: What companies has Juri worked for in recent years?

In recent years, Juri has worked for Telefónica / O2 and CSL Behring .

Q: Which industries is Juri most experienced in?

Juri is most experienced in industries like Information Technology (IT) , Pharmaceutical , and Telecommunication . Juri also has some experience in Professional Services , Biotechnology , and Healthcare .

Q: Which business areas is Juri most experienced in?

Juri is most experienced in business areas like Information Technology (IT) , Quality Assurance (QA) , and Customer Service . Juri also has some experience in Business Intelligence and Product Development .

Q: Which industries has Juri worked in recently?

Juri has recently worked in industries like Telecommunication and Pharmaceutical .

Q: Which business areas has Juri worked in recently?

Juri has recently worked in business areas like Information Technology (IT) , Customer Service , and Quality Assurance (QA) .

Q: What is Juri's education?

Juri holds a Doctorate in theoretical and mathematical physics .

Recommended expert

Regensburg, Germany

Experience

Feb 2022 - Present

4 years 1 month

Munich, Germany

Telefónica / O2

Development of the NBO/NBA engine intended to support agents during customer interaction
Related ETL processes
Back-end development to support related web front-ends

Oct 2018 - Sep 2021

3 years

CSL Behring

Review of user requirements and design specifications for the new pharmacovigilance reporting system (RxLogix)
Validation and testing of the new pharmacovigilance reporting system
Developing of new reports
Developing of custom solutions (SQL, PL/SQL) and of ad-hoc SQL queries and reports according to end user requests
General support for team members in the Oracle area

Oct 2018 - Jan 2019

4 months

Data Warehouse Consultant

Telefónica / O2

Development and ad-hoc support tasks within a Data Warehouse system

Feb 2017 - Sep 2018

1 year 8 months

Munich, Germany

Telefónica / O2

Impact analysis and development of enhancements and extensions to the DWH batch loads of transactional CRM data for postpaid customers to increase data quality and support new company products (SQL, PL/SQL)
Development of a new DWH load chain for throttle events data provided by the online charging system (SQL, PL/SQL)
Analysis, solution concepts and preparation of transactional and legacy data for ad-hoc loads into the DWH (SQL, PL/SQL)

Oct 2013 - Dec 2016

3 years 3 months

Marburg, Germany

CSL Behring

Developing of a framework for batch data cleansing and 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 and reports according to end user requests
General support for team members in the Oracle area

Aug 2011 - Sep 2013

2 years 2 months

Munich, Germany

Oracle / Java Consultant

LP Solutions

Data modeling to support high data volumes (partitioning, DWH staging tables)
Development of a configurable table partitioning framework (PL/SQL and Python)
Design and implementation of a PL/SQL module to export transaction data to the financial sub-system with gap-free file and line numbers
Implementation of a PL/SQL module to process personal data disclosure requests
Server side programming (PL/SQL) for rating and billing modules with XML-based rules and for exporting 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 and SQL area

Mar 2009 - Jun 2011

2 years 4 months

Biberach, Germany

Boehringer Ingelheim

Evaluation, clarification and fine-tuning of user requirements
Creation of functional specifications, software design specifications and development tests
Conceptual design of the system and 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 both sides
Performance tuning on the Oracle Clinical side
Support for user acceptance tests and application validation

Sep 2008 - Mar 2009

7 months

Ingelheim am Rhein, Germany

Boehringer Ingelheim

Enhancements and corrections to the customized parts of the ARISg application (server-side PL/SQL code)
Development of in-house web applications (back-end Oracle Application Express) to provide additional functionality for ARISg users
Implementing and applying data correction scripts (SQL and PL/SQL)
Third-level support for the ARISg application (database-related)
Code quality control
General support for team members in the Oracle area

Mar 2008 - Sep 2008

7 months

Ingelheim am Rhein, Germany

Boehringer Ingelheim

Validation and corrections to the data migration procedures
Performance tuning for the data migration scripts
Accomplishment of the initial and incremental data migration
Validation and 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

Nov 2007 - Feb 2008

4 months

Graz, Austria

BearingPoint

Evaluation of areas where the product can and needs to be enhanced and corresponding design approaches
Conceptual design and database 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 and SQL scripts) for automated generation of different DDL scripts necessary for switching to VPD
Enhancements and 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 and domain know-how transfer to permanent employees

Apr 2006 - Oct 2007

1 year 7 months

Sydney, Australia

BearingPoint

Creation of development specifications
Application database design, implementation and server side programming (PL/SQL) for rating, billing and invoicing modules (billing module completely specified, designed and implemented single-handedly)
Complex core SQL for the rating module to be called from the Java layer
Major corrections and enhancements in data replication to and from the Accounts Receivables module
Design and code quality control
Database and application performance tuning
Support for team members in the Oracle area and training for support team members
On-site support of QA and performance tests

May 2004 - Mar 2006

1 year 11 months

Bengaluru, India

On-site

BearingPoint

Requirements definition on-site with the customer
Creation of development specifications
Application database design and implementation
Server side programming (PL/SQL, Java stored procedures)
Support for the developer team in the Oracle area
Design and code quality control
On-site database and application performance tuning
On-site processing of customer change requests
On-site support for customer QA tests and end user acceptance tests
On-site training and WebEx knowledge sharing sessions for the customer and application support team members
Creation of application manuals and documentation for end users

Apr 1999 - Apr 2004

5 years 1 month

Munich, Germany

CSC Ploenzke

Application system and database design and implementation
Creation of development specifications
Technical development management
Support for other developers in the Oracle area
Design and code quality control
Server-side and client-side programming
Performance tuning
Support for end customers
Configuration management and DBA tasks in emergency cases

Feb 1999 - Mar 1999

2 months

Munich, Germany

Softlab

Database design
Programming (server side packaged PL/SQL procedures)
Performance tuning

Aug 1998 - Dec 1998

5 months

Munich, Germany

Softlab

Database design and implementation
Programming (server and client side) with packaged PL/SQL procedures and Oracle Designer/2000
Performance tuning
Customer support

Oct 1997 - Dec 1997

3 months

Munich, Germany

Softlab

Server-side and client-side programming
Forms generation and manual changing and creation

Oct 1995 - Sep 1997

2 years

Regensburg, Germany

Klinik OP-Data GmbH

Server-side and client-side programming
Forms creation
Database administration and tuning

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (10 years), Pharmaceutical (9.5 years), Telecommunication (6 years), Professional Services (4 years), Biotechnology (3 years), and Healthcare (2 years).

Information Technology

Pharmaceutical

Telecommunication

Professional Services

Biotechnology

Healthcare

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (29 years), Quality Assurance (12.5 years), Customer Service (9.5 years), Business Intelligence (5 years), and Product Development (2 years).

Information Technology

Quality Assurance

Customer Service

Business Intelligence

Product Development

Skills

Design, Development And Support Of Oracle Based Systems (Client-side And Server-side)
Application Tuning / Sql-tuning / Database Tuning
Oracle 7, 8 / 8i, 9i, 10g, 11g, 12c, 19c
Oracle Clinical
Arisg
Empirica Trace
Argus Safety
Rxlogix Pvr
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, R 6.0/6i (Forms And Reports)
Oracle Headstart R 1.0, R 2.1
Oracle Sql*plus
Oracle Sql-developer / Data Modeler
Sql-navigator
Toad
Pl/sql Developer
Oracle Sql & Pl/sql V 1.x, 2.x, 8.x, 9.x, 10.x, 11.x, 12.x, 19.x
Fortran
Algol
Cvs
Svn
Visual Source Safe
Telecommunication – Billing And Customer Care Systems, Customer & Business Marketing Intelligence
Plants Construction Industry – Ordering And Purchase Systems
Automotive Industry – Construction Data Management Systems And Quality Control Systems
Pharmaceutical / Health Care – Hospital Management Systems And Drug Safety Systems / Adverse Event & Drug Reaction Reporting Systems
Customer Loyalty Systems
Bmw
Linde
Softlab
Csc Ploenzke
Verisign
Bearingpoint
Aapt
Boehringer Ingelheim
Loyalty Partner / Payback
Csl Behring
Telefónica / O2

Languages

German

Native

Russian

Advanced

English

Elementary

Education

Ph.D. · theoretical and mathematical physics

Profile

Created

March 2024

Last Update

June 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Juri based?

Juri is based in Regensburg, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Juri speak?

Juri speaks the following languages: German (Native), Russian (Advanced), English (Elementary).

How many years of experience does Juri have?

Juri has at least 29 years of experience. During this time, Juri has worked in at least 2 different roles and for 8 different companies. The average length of individual experience is 2 years and 8 months. Note that Juri may not have shared all experience and actually has more experience.

What roles would Juri be best suited for?

Based on recent experience, Juri would be well-suited for roles such as: Data Warehouse Consultant, Oracle / Java Consultant.

What companies has Juri worked for in recent years?

In recent years, Juri has worked for Telefónica / O2 and CSL Behring.

Which industries is Juri most experienced in?

Juri is most experienced in industries like Information Technology (IT), Pharmaceutical, and Telecommunication. Juri also has some experience in Professional Services, Biotechnology, and Healthcare.

Which business areas is Juri most experienced in?

Juri is most experienced in business areas like Information Technology (IT), Quality Assurance (QA), and Customer Service. Juri also has some experience in Business Intelligence and Product Development.

Which industries has Juri worked in recently?

Juri has recently worked in industries like Telecommunication and Pharmaceutical.

Which business areas has Juri worked in recently?

Juri has recently worked in business areas like Information Technology (IT), Customer Service, and Quality Assurance (QA).

What is Juri's education?

Juri holds a Doctorate in theoretical and mathematical physics.

What is the availability of Juri?

Juri is immediately available full-time for suitable projects.

What is the rate of Juri?

Juri's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.