www.oraxcel.com

Linker IT Software B.V.

Snikke 6

7833 DM
Nieuw-Amsterdam

The Netherlands

Tel: (+31) 591 556 314
Fax: (+31) 842 245 086

Level

Skill or tool

Expert

Oracle SQL and PL/SQL versions 7 – 10g. TOAD, PLSQL developer. Oracle developer & designer.
SQL Server TSQL, DTS and MS Access
Visual Basic (VB6), ADO, ODBC, VS6, Visual Interdev
Excel VBA, Office development (COM, add-ins)
C / UNIX, shell scripting

Software development, design, engineering, testing

Intermediate

Oracle Forms, Reports, Designer
ASP, PHP, VBScript, javascript
XML, XSLT, CSS

Business process analysis

Knowledge of

Visual Studio .Net

Period

Sector

Company

Position

2006-2008

Energy

Cogas Energie, NL

Business Engineer / Oracle developer

2000-2005

Airport

Manchester & Liverpool Airport, UK

Out of hours systems support (Oracle + applications)

2002-2004

Insurance

Swinton Insurance, UK

Oracle, Access and SQL Server Developer

2001-2002

Energy

Generis Technology, UK

Senior Oracle Developer

2000-2001

Housing

First Software, UK

Oracle Analyst Developer

2000-2000

Pharmacy

Glaxo SmithKline, UK

Analyst Programmer

2000-2000

Retail

Littlewoods, UK

Short project: Oracle Reports Developer

2000-2000

Telecoms

Versatel, NL

Short project: VBA / Excel Developer

1998-2000

Airport

Manchester Airport, UK

Systems programmer; Oracle and VB

Period

Sector

Company

Position

1996-1998

Energy

SCT International, UK

Analyst Programmer

1996-1996

Banking

ABN AMRO through DP Finance, NL

Analyst Programmer

1995-1996

Banking

DP Finance, NL

Analyst Programmer ; IT Trainee

Period

Sector

Description

1995-2008

Business Intelligence

Software development & sales of my own range of software products notably the SQL*XL software.

Period

School

Description

Location

1990 - 1995

University

Masters in Theoretical / Computational Chemistry

Groningen, The Netherlands

1989 - 1990

HLO

Laboratory Education - College of Technology

Groningen, The Netherlands

1986 - 1989

MLO

Laboratory Education - Politechnic

Groningen, The Netherlands

1982 - 1986

MAVO

Secondary School

Slochteren, The Netherlands

Year

Cource

Institute

1998

Certified Oracle Application Developer Program (completed 3 out of 5 modules)

Oracle, UK

1996

Oracle Pro*C

Xicon, UK

1996

Oracle SQL, PL/SQL, Oracle Architecture, Oracle Designer 2000, Oracle Developer 2000 (Forms, Reports)

Oracle, The Netherlands

1996

AOB - General Education in Banking.

NIBE, The Netherlands

1995

Cobol Expert Class

VAC, The Netherlands

1990

VWO Wiskunde B (Mathematics)

LOI, The Netherlands

Year

Publication

2001

Interviewed for the Jan-2001 issue of Oracle Magazine (Peer to Peer column)

2001

Written a review of the Oracle utility Formatter Plus for orafaq.com

2001

Written a review of the Oracle utility EZSQL for orafaq.com

2000

Co-authored the Oracle 8I DBA Bible. IDG books, ISBN 0-7645-4623-6

1995

Written an article in the scientific journal Journal of Electron Spectroscopy and Related Phenomena. Hartree-Fock study on the lower excited states of a Cu+ impurity in NaF using large embedded clusters, Elsevier, vol 77, p 143-148 1995

Period

Software

Description

Skills used

1995 - 2008

SQL*XL

Interface to databases from MS Excel

2007 - 2008

EncOffice

Office encryption software.

2005 - 2006

litLIB

Functions library for Excel

2004 - 2004

litXLS

Build XLS files without Excel

1994 - 1996

Huckel

Molecule Properties Calculator

1996 - 1997

MasSim

Mass Spectrometer Simulator

1998 - 1998

DataEntry

Oracle Data Entry Utility

1998 - 1998

Explain

Oracle Explain Plan Utility

1999 - 1999

CommSnif

COM port sniffer

1999 - 1999

CommTest

COM port analyser

2001 - 2001

WordDiff

Word document difference analysis

2001 - 2001

OrderForm

Configurable Order System

English

Fluent

Dutch

Fluent

German

Knowledge

French

Knowledge

2003-2007

Running: several 10k and half marathon races.

2005-2007

Editor of a local newspaper for Nieuw-Amsterdam and Veenoord. 3500 issues, monthly.

2005-2006

Training a local running clinic (athletics) in Nieuw-Amsterdam. 10 participants.

2005-2005

Assistant trainer at the running club: Loopgroep Klazienaveen: 100 participants.

Jul 2006 - Mar 2008

Business Engineer / Oracle developer

NetMeet – a bespoke customer management system.

Freelance / Contracting

• Involved in a small team of 3 business engineers / developers to assist the business.
• Full life cycle work. Design, execute and document test plans, system changes, new functionality. Reengineering and streamlining existing systems.
• Functional and technical analysis of issues and problems.
• Liaison with functional experts and end users.
• Analyse business processes and the IT systems usage therein.
• Oplossen van diverse functionele vraagstukken in de energiemarkt: berekenen gas jaarverbruiken ; splitsen gasverbruiken mbv profielenmethodiek ; verzamelfacturatie.

Mar 2000 – Jan 2005

Operational Systems Support

AMOSS: Airport Management and Operations Support System

Freelance / Contracting

• The provision of out of hours 3^rd line operational systems support for the AMOSS system and related systems at Manchester and Liverpool airport. User base: 250 clients, 2 database servers, 1 application server.
• Finding faults in system interfaces: system messages (MS message queue, flat files, database links), communication protocols (TCP/IP, serial comms, ODBC)
• DBA support for the Oracle databases.

Jun 2003 - May 2004

Oracle, Access & SQL Server developer

Most major MI and retail systems

Freelance / Contracting

• Involved in small teams (2-4 colleages)  to develop new - maintain existing and reengineer old database systems at Swinton Insurance.
• The main responsibilities were the production of program code, test plans and technical documentation. I fulfilled the role of the more senior developer, providing advice and coaching for other programmers. I also provided feedback to functional designers and business analysts.
• I have been involved a number of key systems and projects at Swinton:
  Acquisitions MI: Front-end in MS Access linking to an Oracle database.
  Customer Development System (CDS). Reengineered this old and largely undocumented Oracle7 / UNIX system. Produced UML documentation.
  Customer Contact Database (CCD). Developed several aspects of this newly developed SQL Server system. T-SQL stored procedures, performance tuning. Data migration.
  Accidental Death Benefits system (ADB). Moved system from VB-Access to VB-SQL Server under CITRIX.
  Retentions MI. Extracting Oracle7 data into a SQL Server database.
  LCE: Live Customer Extract. Development of SQL and shell scripts. Performance tuning.
  Safeguard: Retail system to sell and track motorhome policies. VB6 to SQL Server. Designed and developed the VB reporting system and a document product system based on MS Word. Produced UML documentation

Jun 2002 – Mar 2003

Oracle, SQL Server developer

CDS – Customer Development System

Freelance / Contracting

• Design and development of a data extraction utility to extract data from a very large Oracle database into SQL Server using SQL Server stored procedures. Design and development of an Access database front-end.
• Reverse engineering of shell scripts and PL/SQL. Re-engineering, bugfixing, performance tuning of this Oracle on SCO UNIX system. Reinstalled system on a new SCO UNIX server.

Apr 2001 – Feb 2002

Senior Oracle Developer

CTCS, MDB / B-SMART, AMS, CSCS, Support System

Freelance / Contracting

• Development of an interface (CTCS) to mainframes at British Gas in UNIX C and PL/SQL through the Tuxedo middleware.
• Development of PL/SQL packages for a new Oracle8i system (MDB / B-SMART)
• Development of UNIX sed script and Oracle Forms for the AMS system.
• Development of a telemarketing system in VB6 that communicates to mainframes at British Gas.
• Design and development of an online Customer Support System using ASP and Access.
• Development of a new corporate and product website using FrontPage, Java applets, HTML. Design and development of ASP, MSXML and XSLT code to provide an online translation of the website into foreign languages.

Oct 2000 – Jan 2001

Oracle Analyst Developer

Housing

Freelance / Contracting

• Generating and further development of Forms 6i modules generated from Designer 2000.
• Development of Forms 6i PLL modules and PL/SQL server side packages.
• Bugfixing Forms, Pro*C, shell scripts and SQL*Loader scripts.

Oct 2000 - Oct 2000

Oracle Reports Developer

Retail

Freelance / Contracting

• Performance tuning and redevelopment/fixing of Oracle Reports against a very large Oracle 8i database.
• Integration of Oracle Reports into an intranet site hosted from the Oracle Application Server (OAS).

Apr 2000 - Oct 2000

Analyst Programmer

LIMS: Laboratory Inventory Management System

Freelance / Contracting

• Design and development of WinRunner TSL code to enter large amounts of data into the front-end of LIMS.
• Design and development of VBA code in Excel to manage the data and to generate the WinRunner TSL code.

Apr 2000 – Apr 2000

VBA / Excel developer

Customer Information System

Freelance / Contracting

• Development of a spreadsheet application to update a customer information system.
• Integrating SQL*XL into this spreadsheet application to provide the interface to the Oracle database.

Jun 1998 – Mar 2000

Systems Programmer

AMOSS: Airport Management and Operations Support System

Freelance / Contracting

• Design, development and support of the AMOSS system in VB5 and ODBC, Oracle.
• Reverse-engineering, redesign and development of a RPG automated baggage sortation system into a VB5 / Oracle system.
• Design and implementation of various interfaces to the AMOSS system including interfaces for Teletext, IVR (Interactive Voice Recognition), ACCORD (flight schedule planning), etc

Dec 1996 – Jun 1998

Analyst Programmer

BANNER CIS: Customer Information System

Permanent position

• Development and bug fixing of Pro*C, PL/SQL and Oracle Forms 4.5 modules of the BANNER CIS system.

Feb 1996 – Sep 1996

Analyst Programmer

IRIS: Customer Information System

Permanent position

• Development of the IRIS system: a front-end in ObjectView against DB2 databases.
• Development of an interface between the IRIS system and MS Schedule+ using the C language.

Oct 1995 - Jan 1996

Analyst Programmer

Permanent position

• IT training. Two months general IT and Cobol training. Four months training at Oracle Corporation.