Development tasks related to the NBO/NBA engine used by a major German telecommunication company (SQL, PL/SQL)

Data retrieval and reporting migration support within a Drug Safety & Pharmacovigilance system (Argus Safety) by an international pharmaceutical company in a GxP-validated environment.

• 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 Software: Oracle RDBMS 11g/12c, SQL-Navigator, SQL-Developer, Argus Safety, RxLogix PVR

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.

• 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 Software: Oracle RDBMS 10g/11g, SQL-Navigator, SQL-Developer, Argus Safety

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.

• 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 Software: Oracle RDBMS 9i and 10g

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. 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 Software: Oracle RDBMS 9i and 10g

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.

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 End customer: AAPT. Software: Oracle RDBMS 10g, Hibernate

Development of a Billing and Customer Care system for telecommunication companies (GSM operators). Initially Oracle 7, then Oracle 8/8i, then 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.

Using of the Oracle 8/8i features.

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.

As 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 End customers: HT, T-HT, Batelco, Simobil, Globul, Cosmote, Eronet, Cybit Positioning Solutions. Software: Oracle RDBMS 7 / 8i / 9i, Oracle Developer/2000 R 1.3.2 and R 6i, Oracle Designer/2000 R 1.3.2 and R 6.0, Oracle Headstart R 1.0 and R 2.1

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, client-side 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.

• DB-design and implementation
• Programming (server-and client-side)
• Performance tuning
• Customer support End customer: Linde. Software: Oracle RDBMS 7, Oracle Developer/2000 R 1.3.2, Oracle Designer/2000 R 1.3.2

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, client-side 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.

• DB-design and implementation
• Programming (server-and client-side)
• Performance tuning
• Customer support End customer: Linde. Software: Oracle RDBMS 7, Oracle Developer/2000 R 1.3.2, Oracle Designer/2000 R 1.3.2

Permanent position. 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.

• Server-side and client-side programming
• Forms creation
• Database administration and tuning Software: Oracle RDBMS 7, Oracle Developer/2000 R 1.3.2, Oracle Designer/2000 R 1.3.2