Wladimir van Kiel

Freelance interim manager, business analyst, system designer, system developer, trainer.

Also AS400 specialist (RPGLE, SQLRPG and SQLRPGLE), DB400, SQL, CL. Query400 and AS400 database implementation

After finishing the locally highly esteemed VOLMAC Top Training RPG programmer’s course of 3 months in 1980 I started working as a programmer. From there on and after finishing a lot of relevant courses I became a systems-analyst, functional designer and finally business-analyst.

I have 30 years of experience designing and developing computerised information systems.

As a business analyst I regularly act as technical project leader in various projects and have also been an interim manager with various software-houses and computer departments.

I also have years of experience giving commercial courses for the AS400 and Jackson Structured Programming, business analysis, system development and database design techniques.

In short: I can be contracted to model the business flows and produce the functional specs (as Data Flow Diagrams for activities and Bachman diagrams for the relevant data model) which will be used for the technical design of the final products, the programs and databases. And if the system has to be build in RPG, I can do that too.

Interim manager

Project leader

Business analyst

System designer

(SQL) RPGLE programmer

Technical system manager

Teacher & trainer programming techniques, database design, business analysis en functional design

Database designer

27 years experience as business analyst/project leader/system designer

30 years of S38/AS40 experience as programmer and system manager

Data modelling according to the Bachman method

25 years independent contractor

Techniques: SDM, ISAC, Yourdon, Bachman and JSP (Jackson Structured Programming) UML and Usecases

Super specialist in developing very complex data models

General professional education: chemical analyst

VOLMAC Programmer's training course

VOLMAC System-analysis course 

VOLMAC Structured programming course (VSP / JSP)

PANDATA Business analyzing techniques  SDM, GOS and TIA (Yourdon DFD, Bachman database designing techniques)

IBM All  S38 courses

IBM AS400 courses  for AS400 trainers

AMBI I1, I2 and I3

ICS SYNON (little experience at the moment) 

Visual Basic course

In addition: private study of industrial economics and accounting, IP job point analysis and the AMRO FOREX course

Trust company administration

Banking: Securities, Basel II, Trade Finance, Treasury, accounting, payments, transaction filtering (compliance)

Dealings in foreign exchange

Cocoa industries

Potato purchasing an futures dealings

Financial accounting

Invoicing and writing off as deprecation

Life and other insurance

Various and lots of logistics

Wholesale in technical goods

Electricity companies

Maintenance and new construction of technical manufacturing plants

Printing ink manufacturing

Health insurance

Mail registration and distribution

Wholesale & retail marketing of kitchens

Insurance

Period

Company

Position

Details

Functional design for the delivery of financial instrument positions with various custodians to a system that values them (Algorisk).

Also functional designer in the New Clients project, adjusting MN-systems that can only service 1 pension fund to be able to service multiple pension funds. And various functional designs for management information reporting from a data warehouse.

November 2006 - February 2008

ABN-AMRO Amsterdam

business analyst

functiona designer

Also a functional design for an interface between MTS and a transaction filtering system (compliance)

June 2006 – November 2006

Achmea Leeuwarden

functional designer

Various insurance projects

From March 2006 irregularly

Bruynzeel Keukens in Bergen op Zoom

functional designer

Designing  the database & functional specs for a marketing system of kitchens (wholesale & retail)

From December 2004 – June 2006

Utrecht City Council

application manager  and business analyst for CORSA 7.1

CORSA is a web based mail registration & distribution application

From April 2005, occasionally

Wynne Systems USA

RPG ILE programmer

programming in RPG ILE of customers' adjustments to the Wynne Systems application Rentalman

April 2005 – August 2005

ABN-AMRO (EDS)

Amsterdam

business analyst

business analyst in project Redenomination of the Romanian LEU. Investigating the impact of this ROL to RON change in July 2005 to the business applications of ABN-AMRO WCS (Wholesale Clients Services).

January 2005 – April 2005

ABN-AMRO (EDS)

Amsterdam

functional designer Basel II

producing functional specifications for the adjustment of the ABN-AMRO foreign division bank software to the BASEL2 requirements. This concerns everything: treasury, securities, accounting, trade financing etc.

October 2004 - December 2004 1 day a week

Centerparcs Rotterdam

business analyst

Centerparcs started to experience database performance problems and I was asked to look into this. As the technical database has been developed continuously over the past 20 years bottom up/build on, I started with the extraction of the logical data model pictured as a Bachman entity diagram. I needed two 4-hour sessions with people from the business, and a white board, to create the perfect model that could support any imaginable Centerparcs transaction. In the next phase I will be comparing the physical database with the theoretical model to look for any possible improvements in the way data is stored and accessed

January 2004 - December 2004 (80%)

Utrecht City Council

business analyst

Project extracting, concentrating and storing of data from various JD Edward (JDS) and FMS Administrations. Recently Utrecht has moved to 1 completely new administrative system (hardware and software) for all their departments. In the past, 12 departments used 4 different systems and no historical data was converted to the new system. In order to comply with the legal requirement that data from the last 7 years has to be kept available, all the old software and hardware were kept in use alongside the new system. This meant that the council had to keep on paying all the licence fees. In 2003 it was decided to extract the required data, store it on an intranet server and to discontinue the old systems. My work in the project is to analyse for each department what they want to keep in history and to extract and form the data. I performed the extractions using SQL.

May 2003 - October 2003

VGZ Health Insurance in Eindhoven

business analyst

VGZ were going to move their administration from their own main frame to a completely new ORACLE application. VGZ did not want a conversion from old to new but decided to process their business concurrently on both systems during a transition period. Old customers would still be processed in the old system while new customers would be registered and processed in the new one. Eventually the old system would die. I was asked to analyse the case and to make a functional design for an application that routes the incoming bills to the right system. This is very complicated as bills come from different directions like Internet, on paper and on diskette/tape. Bills can be handed in by the client himself or the supplier of the service (doctor, hospital, pharmacy etc) for the customer. Suppliers usually hand in bathes of bills while a batch can have clients from the old or the new system at random.
Another complication was that VGZ where handling the intake of bills for another insurance company and these bills where mixed in the batches with VGZ bills match this with the legal requirements

January 2003 - May 2003

Koopman International Trade Company Amsterdam

technical system designer and system developer

Designing and developing software on IBM AS400 in RPGLE and RPGSQLLE

August 2002

Code511 Paris

business analyst

Security report for a service provider of an office rental administration as a part of an ISO Certification. CODE511 does the reporting for the ISO-certification and hired me for the. Software/hardware part of the report. The customer provides complete administrative support for investors (banks, insurance Companies) owning property. The provider takes care of the administration, collects the rent and does everything that needs to be done, the investor receives the rent and has no other involvement with the property.
As the provider runs the administrations of several investors on 1 machine with the same software it is important for the investors to know that there can never be a mix up of data in the machine. As the investors can access their data through telephone lines it is important to make sure they cannot touch data of other investors. I analyzed all these aspects and also the working procedures of the provider and the physical security at the computer centre.

2001, 1 day a week

O+R Inktchemie (Sun Chemical) in Zaandam, printing ink factory

system designer, IBM AS400

Converting most of the software to the EURO, using Jackson/VSP, SQL, RPG400, CL, query400

February 2000 - February 2003

ABN-AMRO bank, foreign division, International Helpdesk

2nd-line helpdesk member (combined AS400 specialist/business analyst position)

Round the clock aiding the international branches with occurring problems. These are functional and bank software-technical problems (start of day, end of day, ISAP + satellites and peripheral software like SAFE, BRMS, TURNOVER e.g.) and technical AS400 problems. This required a good working functional knowledge of what a bank does, the products (accounting, treasury, securities, Trade finance, money transfers, settlements etc) and the procedures of a bank.

May 1997 - February 2000

ABN-AMRO bank, foreign division Information Management

business analyst

Making functional specs and testing of treasury software, SWIFT, EURO and Year 2000. I
was working for the foreign division of the bank, adjusting and testing the functional specification of treasury products (currency, interest and over-the-counter derivatives) and money transfers (SWIFT) for the various foreign branches of the bank. This job requires a very good knowledge of named products

1995, miscellaneous

Circle Freight Oude Meer, transport and logistics

system developer IBM AS400

Various RPG programming in RPG, CL, and query400

December 1995 - April 1997

ABN-AMRO bank, foreign division Information Management

system manager IBM AS400

System-management of 2 AS400 machines of this functional department

1995, May to October

ABN-AMRO bank, foreign division Technical Support

system manager, technical consultant IBM AS400

Making AS400-hardware configuration proposals, HELPDESK, tuning and Performance monitoring of about 30 AS400 systems, making system programs for the AS400 using API's and UIM, evaluation of third party tuning software

May 1995, 2 weeks

De Kruithoon in Den Bosch, an ammunition factory

system developer IBM AS400

SQLRPGLE programming

April 1995, 2 weeks

FORBO Krommenie, producer of wall to wall carpeting

system developer IBM AS400

Creating RDB-programs in SQLRPGLE on an AS400 to transfer tables from a mainframe SQL-database to an AS400

April 1993 - April 1995

Compu'Train in Utrecht (training centre)

trainer, consultant

I ran all their AS400 courses as the main freelance trainer. I also developed all these courses.

1994, 6 months

KLM Schiphol

system manager IBM AS400

Setting up AS400 system management for the cargo terminal

1994, 2 months

Electro Staal in Huizen (importer of Bosch tools and equipment)

trainer IBM AS400

AS400 training courses for the entire EDP department

1994, 5 days

IBM Nederland

trainer IBM S38

Training a number of S38 system managers for IBM

1993, 4 months

Verheijen Koffiemachines in Heerhugowaard

business analyst IBM AS400 system developer

development of software for purchasing, sales and extracting information from MAPICS (IBM MRP package using VSP/Jackson, RPG400, CL, query400, SQL

Spring 1993, total of 3 weeks

Pink Elephant, a software agency

trainer

Giving an course SDM + structured business analysis techniques and system Designing techniques

1993, 1 month

Hoogheemraadschap Noorderkwartier, a water managing authority in Alkmaar

system developer IBM AS400

Adapting existing book keeping software, plus continuing activities, using RPG400/RPGLE, CL, query400 and SQL400

1991 - 1992

O+R Inktchemie (Sun Chemical) in Zaandam, printing ink factory

business analyst, system designer, developer IBM AS400

analyzing, designing and programming of practically the entire company, purchasing, sales, ink formula, raw materials, warehousing and production planning using Jackson/VSP, SQL, RPG400, CL, query400. Designing and making software that links up with the FMS financial package, continuing until 2002

Various periods during 1992- 1994

Blaupunkt in Amsterdam

System developer IBM AS400

Support in setting up, tuning and securing theAS400 and SQL instruction. Setting up BSC-communication with external systems(MAI), plus other continuing activities during that period using Jackson/VSP, SQL, RPG400, CL, query400

1990

CITCO Trust Company in Amsterdam

Business analyst, system designer

Design and engineering of their trust administration, mainly database design for all the Trust processes using Yourdon/DFD, Bachman. I was head of the database group and extracted the theoretical Bachman entity model of their trust business that was extremely complex. All possible derivatives in the whole world had to be taken into account. This took about 6 months of intensive sessions with people from the business and a white board. From this Bachman diagram I went on to design the actual database.

irregular, 1989 to 1990

IPCO (Bouwfonds Informatica) in Amersfoort

trainer, consultant

designing and giving various AS400 training courses

1989

Econocom in Amsterdam

consultant

Setting up a training institute for the IBM AS400, developed the entire range of courses and trained the trainers. Also commercially active

1988, 6 weeks

IBM Nederland

trainer

I produced the official IBM AS400 CL (Control Language) course for AS400 training agents

1988-1989

CIMPRO in Amersfoort, a software agency

interim technical manager, consultant

Set up own training institute to provide official IBM AS400 training courses. I followed all these IBM courses as a trainer. In addition, developed a set of courses for CIMPRO for analyst/programmers and database administrators on the AS400, and trained and coached CIMPRO employees in business analysis and system design techniques and supervised and directed them in the field. Also technical manager of CIMPRO. Duties included field management and commercial activities

1988, 2 months

Bergler Automatisering in Amstelveen, a software agency

trainer

in-house training courses for structured functional designers, teaching Yourdon data flow diagram techniques and Bachman database design

1987, during 2 weeks

CORITEL (later Arthur Andersen Consulting) in Nieuwegein

trainer

in-house training introduction IBM S38

1987, 2 months

MIC in Rotterdam, a software agency

consultant

helping with a life insurance project

1986-1988

Cacao de Zaan in Koog aan de Zaan, a cocoa butter manufacturer

Business analyst/system developer

Designed and built a system for the company's foreign exchange and treasury activities, invoicing and the production of export documents using SDM, Yourdon/DFD, Bachman, Jackson/VSP, RPG3,CL,query400. Also trained and coached CdZ employees

1986, 6 months

Bank der Bondsspaarbanken in Amsterdam

interim head of the computer department

managing a team of 8 operators and aiding with the implementation of MIDAS bank software

1986, 8 months

Expert 38 in Utrecht, software agency

technical director and co-founder

Designed and gave courses for the agency, also responsible for general technical management of 45 people

1985-1986

Desisco (a software agency) in Amsterdam

training manager and field manager and consultant

Technical and moral support for employees. Also maintaining contacts with clients plus commercially active. In addition, organising training activities, designing and giving courses. I also acted as a consultant to Desisco clients Legal & General Insurance in Hilversum and PEB Leeuwarden (electricity

1985, 8 months

British Petroleum (BP), Amsterdam

business analyst, system designer

Business analysis, designing a system to manage the maintenance of the oil refinery installations in Rotterdam using SDM, ISAC, Yourdon/DFD, Bachman. This involved the administration of the maintenance frequencies, the subcontractors and maintenance projects of the refinery

1984, 8 months

Nestle Amsterdam, food producer

business analyst

Project leader/business analyst in a major revision of the potato purchasing system for the Maggi factory in Venray. Nestle needs an enormous amount of potatoes yearly. The amount is so big that if they bought the potatoes on the regular market, the prices would rocket. To avoid this Nestle contracts potato farmers to grow and supply potatoes at a set price and a set quality. The system registered this whole complex traffic of contracts, deliveries, quality and storage.I was also responsible for adjustment to the financial administration system. Using SDM, Yourdon/DFD, Bachman

1980- end of 1983

Gestetner in Diemen supplier of printing and copying equipment (now Nashua

IBM S38

programmer, systems analyst/system designer and later business analyst using RPG3, Cl, query400, VSP/Jackson, analysing, designing and building of applications for purchasing, warehousing, the financial administration, sales and technical services