Oracle Consultant, Java, J2EE, Unix

9/2005 – 11/2005

Contracting as a Datawarehouse Specialist for Telecom’s PROBE Data Warehouse.
Implementing the ETL Processing for Decision Point data into PROBE.
The Decision Point system provides credit assessment data of customers wishing to purchase TCNZ PSTN and mobile services. The data provides analysed potential customer risk, revenue and profitibilty.
Implementing the ETL Processing for Xtra Arbor data into PROBE. Xtra Arbor shows a view of Xtra dial up internet usage data.

Software and Tools: Oracle 9.x , Oracle Warehouse Builder, PL/SQL , SQL, UNIX, Shellscripting, PVCS, ClearCase

8/2004 – 8/2005

Contracting as an Oracle Developer/Consultant in the Airpoints Dollars Relaunch project which won GOLD in the ‘New Product or Service Introduction’ at the 2005 CAANZ EFFIE Awards and won ‘Best Redemption Pacific and Asia’ at the 2005 Freddie Awards in 2005.
Designing and implementing the Airlines non-air invoicing application.
Supporting Airline Application Services.

Software and Tools: Oracle 7.x/9.x , PL/SQL , SQL, miscellaneous Oracle tools, UNIX, Shellscripting, UML, PRO*C.

5/2002 – 7/2004

Working on several projects for Keystone-Solutions, Genesis Power, and Fonterra.
Developing a Web based reporting application based on Oracle Financials data using Oracle11i, PL/SQL, DHTML, JavaScript, Java.
Developing modules for the direct Integration of Oracle Financials and Keystone Professional applications in using PL/SQL, Oracle Application Server (OAS) and Oracle InterConnect.
Developing a Web based project management office application in HTML, PL/SQL and JavaScript.
Developing modules and writing functional and technical specifications for the Integration of AIMS to SAP/R3 as part of the Fonterra Empower project.

Software and Tools: Oracle 8.x/9.x/10g , Oracle11i, Oracle InterConnect, OAS, PL/SQL , JavaScript, Java, HTML, miscellaneous Oracle tools, UNIX, VMS

6/2001 – 11/2001

Contracting as an Oracle Consultant during 6 months on a Risk Controlling project of the Global Risk Technology Department at Deutsche Bank AG, Frankfurt, Germany.
Within in a team of 7 people I was responsible for the staging of Credit Risk and Regulatory data from the Europe Region (EMEA). The staging area is built upon an Oracle RDBMS version 8.1.7 on AIX 4.3.3 plus PERL scripts for pre-load processing.
Design and implementation of additional functionality in both PL/SQL and PERL, esp. the high volume optimisation of PL/SQL packages.
Provided consultancy and training for the team members, installed and tested some PERL modules,and did the implementation of an XML parser in PERL

Software and Tools: Oracle 8.1.7.2.0 ,PL/SQL ,SQL*Loader, Perl 5.00503
, AIX 4.3.3,K-Shell, CVS, XML-Spy, miscellaneous UNIX tools

11/2000 – 5/2001

Contracting as an Oracle Consultant.
Developing of a B2B Internet Application.

Software and Tools: Oracle 8.1.6 ,Oracle Internet Application Server,PL/SQL, XML, XML-Spy, HTML, JavaScript

4/2000 – 10/2000

Contracting as an Oracle Consultant in a datawarehouse project of reporting the risk potential in the share trade over a time series.
Administration of the development database,
Developing PL/SQL Packages and Perl programs in order to enable the incremental load of computed portfolios in RiskWatch into an Oracle Database.
Support in Performance Tuning of several instances, optimizing of SQL and PL/SQL code.
Installation and evaluation of an Oracle WebDB instance.

Software and Tools : Oracle 7.3.4.0, 8.1.6 ,PL/SQL ,SQL*Loader, WebDB, Perl, Sun-Solaris,K-Shell, Tivoli Maestro,CVS, miscellaneous UNIX tools

11/1999 – 2/2002

Maintaining and supporting Oracle 8.x Databases on Windows NT and Sun Solaris.
Implementation of a datawarehouse solution including database design, sizing and installation.

4/1999 – 10/1999

Contracting as an Oracle/Unix consultant - Business Analyst and Developer.
ORACLE7- application development tools , Developer/2000 client server architecture in Win95/NT environment and UNIX in Oracle CPG environment.
responsible for dataconversion from legacy systems into ERP Manugistics

- PL/SQL / SQL and Kornshell programming
- Developing Oracle Forms and Reports

8/1998 – 3/1999

Contracting as an Oracle/Unix consultant - Business Analyst and Developer.
ORACLE7- application development tools Designer/2000 , Developer/2000 client server architecture in Win95/NT environment and UNIX
in Oracle parallel processing environment.-
- PL/SQL programming
- system and application design/programming
- team development
- developing large Datawarehouse application
- optimizing and tuning application and database

2/1998 – 7/1998

Working as an Oracle/Unix consultant - Business Analyst and Developer.
ORACLE7- application development tools Designer/2000 , Developer/2000 (Forms and Reports) ; client server architecture in Win95/NT environment and UNIX
within the Health Division and Air NZ Team.-
- system analysis
- system and application design/programming
- team development
- maintenance of Datawarehouse application
- SQL Tuning and optimizing

4/1991 – 10/1997

Involved in analysis, design and development of technical Information Systems.
ORACLE6, ORACLE7- application development tools Case*5, Forms30, Designer/2000, Developer/2000 under UNIX and in client-server architecture in Win95/NT environment. DBA work.
Developing of custom made applications and standard applications based on ORACLE RDBMS, including following process states:
- system analysis
- system design, designing data model
- application design
- application programming
- programming of interfaces to external systems/applications
- testing /optimizing /tuning of application
- consultancy - preparation and presentation of new software modules and/or new
functionalities for customers and corporate IT members.

6/1989 – 3/1991

Kämpf Elektronic
Hamburg/Germany
Working as a contractor as professional in developing custom made applications for acquisition and control systems.

GPA / Softwarehouse for Scientific processing and automation
Hamburg/Germany
Working as a contractor as professional in programming of scientific applications written in Fortran and C under DOS.

3/1986 – 12/1998

Unix consultant for CAD/CAM applications. Programming in Fortran and C.