Juri Wolfenhaut
Oracle consultant
Erfahrungen
Telefónica/O2
Development tasks related to the NBO/NBA engine used by a major German telecommunication company (SQL, PL/SQL).
- 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
CSL Behring
Support of the Drug Safety & Pharmacovigilance reporting system migration from Oracle BI Publisher to the PV Reports (RxLogix) and ARGUS Safety 8.
- Review of User Requirements and Design Specifications for the new pharmacovigilance reporting system (RxLogix)
- Validation / testing of the new pharmacovigilance reporting system
- Developing of new reports
- Developing of custom solutions (SQL, PL/SQL) and of ad-hoc SQL queries / reports according to the end user requests
- General support for team members in the Oracle area
Telefónica/O2
Development and support of a Data Warehouse system used by a major German telecommunication company for reporting in various areas like Controlling, Customer Intelligence, Business Marketing Intelligence, and others.
- Impact analysis and developing of enhancements/extensions to the DWH batch loads of transactional data from the CRM system for postpaid customers to increase data quality and to support new company products (SQL, PL/SQL)
- Developing 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)
CSL Behring
Support of the Drug Safety & Pharmacovigilance system migration from the Empirica Trace 4.2 to ARGUS Safety 7.0.5.
- 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
Loyalty Partner/Payback
Development of an Oracle & Java based Customer Loyalty system to be used as a global platform.
- 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
Boehringer Ingelheim
Automatic transfer of adverse events 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).
- 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
Boehringer Ingelheim
Database-related third-level support, enhancements, and development around Adverse Drug Event & Reaction Reporting system (ARISg 5.1.2).
- 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
Boehringer Ingelheim
Data migration GxP project by a major pharmaceutical company - merge of regional production databases into a single database, with concurrent migration/customization of the related third-party application (ARISg) to a new major release (5.1.2) and migration to Oracle 10g.
Support for the migration team:
- 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
BearingPoint
Product enhancements for the Oracle 10g & Java based Billing and Customer Care system.
- 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
- Creation of a framework (dedicated PL/SQL packages & SQL scripts) for automated generation of different DDL-scripts
- 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
BearingPoint
Development of an Oracle & Java based Billing and Customer Care system for an Australian telecommunication company.
- Creation of development specifications
- Application DB-design, implementation, and server side programming (PL/SQL) – Rating, Billing and Invoicing modules
- 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
BearingPoint
Development of an Oracle based Billing and Customer Care system for US telecommunication companies.
- 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
- Creation of application manuals/documentation for end users
Telesens
Development of a Billing and Customer Care system for telecommunication companies (GSM operators).
- 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
Softlab
Development of a Construction Data Management system for a major automobile construction company.
- DB-design
- Programming (server-side: packaged PL/SQL procedures)
- Performance tuning
Softlab
Development of an Ordering, Purchase and Delivery system for a major plant construction company.
- DB-design and implementation
- Programming (server-and client-side)
- Performance tuning
- Customer support
Softlab
Change request for a Quality Control system, used by a major automobile construction company.
- Server-side and client-side programming
- Forms generation and manual changing/creation
Klinik OP-Data GmbH
Development of a Hospital Management system for German hospitals.
- Server-side and client-side programming
- Forms creation
- Database administration and tuning
Zusammenfassung
Sprachen
Ausbildung
Ph.D. · theoretical and mathematical physics
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.