Profile

Last edited on:

14-04-2005

Name:

E-mail:

Gideon van Melle MSc

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.

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

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.

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.

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.

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

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.

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.

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).

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.

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.

Tasks :

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

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.