Profile

 

Last edited on:

 

14-04-2005

 

Name:

E-mail:

 

Gideon van Melle MSc

email adres

 

click to download the profile in Word format  

 

Resumé in Word format  

Postal Address: 

Date of Birth:

 

Dulongstraat 9, 1097 RT Amsterdam 

23-09-1944

Telephone: 

Experience since:

020-7714021 

26-07-1998

 

 General education

 IT education

 Methods & techniques

 *

Open University: Environmental  Economy

Int. Inst. for Aerial Survey & Geology

University of Wageningen: Tropical Sylviculture and Ecology

Royal Inst. For the Navy

HBS-B

 

Powerhouse 4GL v.8

Compu'train, MSAcces97 VBA

Hyperion/Temtec Essbase Fund.&Syst.Adm. Hyp/Temt.Essbase Optim.& Essbase 5 Rel. Prev. Syst. mngr Progress Database. Temtec, Executive viewer training PION: COBOL Mainframe Developer 

Data warehousing

OLAP

Structural programming

Data Mining

Data Modelling

Structural Design

 

C

C

C

A

A

A

 

 

 Program languages

 *

 DB/DC-systems

*

 Hardware

*

 Operating systems

 *

 Tools

*

HTML

SQL

VBA

Visual Basic

Word-basic

COBOL II

D

D

D

D

D

B

Essbase

MS Access

Progress

Oracle 8.1 

D

D

C

 

PC

IBM Mainframe

IBM RS/6000

Vax, Alpha

 

D

A

A

A

 

DOS

Windows

BS2000

VSE series

Unix

 

D

D

A

A

 

MS Help 4.02

HTML Editor

MS Access

MS Office

Visual Basic 6.0

Adobe Acrobat

Visual SourceSafe

E

D

D

D

D

C

B

 

 

 

 

General:

Job experience in English-, French-, Spanish- and Portuguese speaking countries.

Job experience in SE Africa, W-Africa, C-America, New-Zealand, Belarus.

Experience in project management, project evaluation. (International development projects).

 

Started by means of a PION course “Cobol Mainframe Developer” in 1997 a second career as IT-professional.  After a short while as COBOL-II programmer with the AEGON FN LCE team, attached to the HRM Staff  of AEGON as system and application manager. Main tasks were the maintenance of the used databases (Access, Progress, and Essbase) and making reports for the Management concerning personnel and sick-leave.  This assignment was till April 2002. After that some ad-hoc assignments with AEGON and SFS for the building of MS-Access applications.

 

 

Period

 :May 2002 - February 2003

Company

:A&O Services

Branch

:Insurance

Application

:Insurance systems

Function/role

:Application programmer

Programming Languages

:Visual Basic/SQL; COBOL, RDB-SQL,JCL

DB/DC-systems

:Access 95/97, RDB

Hardware

:PC, Vax

Operating Systems

:Windows, Unix

 

General Tasks:

Maintenance and management diverse RDB systems. Development of office automation (Outlook, Access)

 

My specific tasks:

- to make a functional design together with the client, following business rules and functional demands

- to make a technical design

- to organize the database

- to programme the supporting code for Word and Access

- to test,

- to implement

- to maintain

 

 

 

Period

:March 2002 - April 2002

Company

:SFS

Branch

:Insurance

Application

:Insurance system

Function/role

:Application programmer

Programming Languages

:VBA

DB/DC-systems

:MS Access

Hardware

:PC

Operating Systems

:Windows

Tools

:Visual SourceSafe

 

Tasks:

The assignment concerned the upgrading (programming and testing) of an existing application. My specific task was the upgrading of a part of the user interface to the changed business rules and database structure.

 

 

 

Period

:February 2002 - February 2002

Company

:SFS

Branch

:Insurance

Application

:Client information system

Function/role

:Application programmer

Programming Languages

:VBA

DB/DC-systems

:MS Access

Hardware

:PC

Operating Systems

:Windows

Tools

:Visual SourceSafe

 

Tasks:

An independent assignment. Changing,  in consultation with the system owner, the functionality of an existing MS Access application, adding new functionality (interaction MS Access and Excel) and changed business rules.

My specific task was:

-making the Technical design according to the functional design

- the programming

- testing

- maintenance

-writing of functional documentation

 

 

 

Period

:November 2001 - December 2001

Company

:AEGON HRM

Branch

:Insurance

Application

:HRM information system

Function/role

:Application programmer, Functional designer

Programming Languages

:VBA, Visual Basic 6.0

DB/DC-systems

:Access 95/97

Hardware

:PC

Operating Systems

:Windows 95, Windows NT

 

Tasks:

An independent assignment for the design and building of an  application in Visual Basic for the mail merging of salary change letters for all company branches of AEGON.

 

My specific task were:

- making of the Functional and Technical design together with the client.

- programming and building of the front-end application in VB 6.0

- programming of a backend application for the validation of data

- design databases (Access 95)

- Writing of functional and technical documentation.

- Making of the mail merge file in Word.

- testing

- implementation

- maintenance

 

 

 

Period

:October 2001 - November 2001

Company

:SFS

Branch

:Insurance

Application

:Premium-Insurance-System

Function/role

:Application programmer

Programming Languages

:VBA, SQL

DB/DC-systems

:Access 95/97

Hardware

:PC

Operating Systems

:Windows

Tools

:MS Access

 

Tasks:

A independent assignment, where, in consultancy with the client a number of (action)queries were made and executed for The delivering of client data to functional manager of the “Premiespaarloon” system (SAMS). Some queries were built-in in a MS Access application with VBA for later (repeated) execution.

 

 

 

Period

:August 2001 - February 2002

Company

:AEGON HRM

Branch

:Insurance

Application

:Management-Information system

Function/role

:System manager

Methods

:Data warehousing

Programming Languages

:VBA, SQL

DB/DC-systems

:Essbase, Access 95/97

Hardware 

:PC

Operating Systems

:Windows

 

Independent assignment. Maintenance and development of The Management Information System at AEGON HRM Netherlands. Designing and data input of The Essbase (Hyperion) modules with monthly copies of the Personnel Registration and Information System (PeopleSoft). Design and building of modules (cubes) for OLAP of salary, personnel and sick leave data.  Design and building of  interfaces in MS Access for The data input from ARBO2000 & PeopleSoft  to the Essbase database.

 

The OLAP cubes can be consulted via IP/TCP with a viewer of Temtec by every company branch of AEGON. Maintenance of The software, building of The views, and simple training on the spot, support and security was part of my responsibility.

 

 

 

 

 

Period

:July 2001 - July 2001

Company

:PinkRoccade Finance Sequoia Services

Branch

:IT

Application

:Personnel Registration System

Function/role

:Application programmer

Programming Languages

:VBA

DB/DC-systems

:Access 95/97

Hardware

:PC

Operating Systems

:Windows

 

Tasks:

An independent VIP assignment. Increasing functionality of the working hour registration system, build in Access and Excel according the functional design. The technical design was made by me. 

Specific Tasks:

- to propose solutions

- making technical design

- programming in VBA

- testing of the application

 

 

 

Period

:June 1999 - January 2000

Company

:AEGON

Branch

:Insurance

Application

:Salary and HRM system

Function/role

:Application programmer

Programming Languages

:SQL, VBA

DB/DC-systems

:MS Access

Tools

:MS Office

 

Tasks:

 Design and building of an application in MS Access for The automation of The salary upgrade procedures for all Company branches of AEGON. Reporting of relevant data, input of new data and uploading of the final data in the Personnel Registration and Information System (PeopleSoft).

 

Independent design and building of an application in MS Access for the Maintenance of the Management Potential System. Design of forms for the online input of data, automation of data-input from the Personnel Registration and Information System (PeopleSoft). The design and building of executive and statistical reports for the management.

 

 

 

Period

:January 1999 – June 1999

Company

:AEGON

Branch

:Insurance

Application

:Internet

Function/role

:Manager

Programming Languages

:HTML, JavaScript

Tools

:Text editor, HTML Editor

 

Tasks:

Keeping Up-to-date of the intranet site and the Internet Vacancy site of AEGON/PN. My specific tasks were the manual editing of text and illustrations op the web pages, the coding of java scripts, and the upload of new web pages and maintenance of the URL's.

 

 

 

Period

:November 1998 – June 2001

Company

:AEGON

Branch

:Insurance

Application

:Sick-leave registration system

Function/role

:System manager, Functional Application manager

Programming Languages

:VBA

DB/DC-systems

:Progress

Hardware

:PC

Operating Systems

:Windows

 

Tasks:

An independent assignment for the Maintenance and management of The application ARBO2000 system of the internal Medical Staff of AEGON, and Functional manager of AEVRIS (AEGON sick leave registration and information system). ARBO2000 is a sick leave registration system for “ARBO” services.

 

Sick- and recover reporting is done through an intranet application: AEVRIS. The interfaces between AEVRIS, ARBO2000 and PeopleSoft HRMS-system of AEGON were built by me in MS Access and also maintained.  

 

Daily reports from AEVRIS were loaded into in ARBO2000. Weekly personnel data were loaded into ARBO2000.

Monthly the Essbase database was refreshed with personnel and company data.

Data from ARBO2000 were loaded into Essbase for reporting and statistical manipulations according to the NIA rules (Netherlands Institute of Medical doctors).

 

 

 

Period

:November 1998 – June 2001

Company

:AEGON

Branch

:Insurance

Application

:Management Information system

Function/role

:System manager, Application programmer

Methods

:Data Mining, Data Modelling, OLAP

Programming Languages

:VBA, Progress, Visual Bas/SQL

DB/DC-systems

:Access 95/97, Essbase, Progress

 

Tasks:

Independent assignment. Maintenance and development of The Management Information System at AEGON HRM Netherlands. Designing and data input of The Essbase (Hyperion) modules with monthly copies of the Personnel Registration and Information System (PeopleSoft). Design and building of modules (cubes) for OLAP of salary, personnel and sick leave data.  Design and building of interfaces in MS Access for The data input from ARBO2000 & PeopleSoft to the Essbase database.

 

The OLAP cubes can be consulted via IP/TCP with a viewer of Temtec by every company branch of AEGON. Maintenance of The software, building of The views and simple training on the spot, support and security was part of my responsibility.

 

 

 

Period

:August 1998 - November 1998

Company

:AEGON-LCE

Branch

:Insurance

Application

:holiday home system

Function/role

:Programmer

Methods 

:Structural Programming

Programming Languages

:COBOL II

DB/DC-systems

:IDMS

Hardware

:IBM Mainframe

Operating Systems

:VSE series

Tools

:TSO/ISPF

 

Tasks:

Added to the LCE team of AEGON FN.

My tasks were the coding and testing of changes and Y2K adjustments in existing COBOL programs.  Recompilation of existing programs written in COBOL 74 to COBOL 85.

 

 

 

Period

:March 1990 - August 1994

Company

:WinBBS Rotterdam

Branch

:IT

Application

:Electronic newsletter system

Function/role

:Developer/Designer

Methods

:Structural Design

Operating System

:Windows

Tools

:MS Office, MS Help 4.02

 

Tasks :

Creating of Electronic magazines in Windows Online Help format for a Bulletin Board System (WinBBS). Monthly editions with software reviews.

 

 

 

Period

:August 1987 - June 1995

Company

:Ministry of foreign Affairs

Branch

:Government

Application

:Various

Function/role

:Project leader

DB/DC-systems 

:dBase

Operating Systems

:DOS

 

Tasks :

Maintenance of PC’s and Software for a Rural Development Project in Cape Verde ( Ministry of Foreign Affairs, DGIS). Relevant software: WP 5.0, Lotus 123, DOS. Dbase III.