Name:	Mark John Richard Ellen
Tel/Fax:
www:	www.museit.co.uk
Date of Birth:	02-SEP-1957
Nationality:	British
Marital status:	Married
Health:	Good
Driving Licence:	Full/clean since 1979. Groups A,E (car owner)
Languages:	Conversational French

CSE
Mathematics Grade 1, June/July 1974

GCE 'O' LEVEL
June/July 1974

Mathematics 3, Physics 4, Chemistry 5, English Language 6,
Geography 3, Woodwork 4 French 6, Biology 3

GCE 'A' LEVEL
June/July 1976
Biology D, Physics E

June 1978
English Literature E

I remain interested in the development of ORACLE, especially in Versions 7 and 8, as ORACLE is the market leader. I am currently adding DB2 CLI programming to my skills. Improving knowledge of Java.

DEC: VMS, Ultrix

UNIX: Prime, Hewlett Packard HP/UX, Sun, Data General Aviion, Bull,
Pyramid, NCR, Unisys, IBM AIX, SCO, Sequent Dynix/PTX, ICL
DRS6000,Linux

DATA GENERAL: AOS

IBM/PC: MS Dos, Windows 3.1, DRDos, Concurrent Dos, Netware, Coherent, NT, OS/2

C, C++, JAVA, SQL, PL/SQL, Pascal, Modula-2, Dbase, Clipper, Oracle Pro-C/ OCI, Delphi3

DOS APPLICATIONS EXPERIENCE

Lotus 123, Word Perfect, Multimate, Lucid 3D, Supercalc, Zstem,
Paradox, Rbase, Desqview, Brief, MultiEdit, Word Pro 97

ORACLE EXPERIENCE
VERSIONS 5,6 and 7 PLATFORMS VMS, ULTRIX, UNIX, AOS & DOS,OS/2,NT
OCI 7.2, 7.3, PRO-C, SQLFORMS 2.3 & 3, CONVERT, RPT, CRT, SQLDBA, ORATERM, SQLPLUS
IMPORT & EXPORT, SQLLOADER, SQLNET V1, V2

Sep 1969-Jun 1976 : Woolverstone Hall School
Jun 1976-Feb 1977 : Reinsurance Clerk at I.R.B.
Feb 1977-Sep 1977 : Travelling EUROPE, MIDDLE EAST, AFRICA, SEYCHELLES
Sep 1977-Aug 1979 : Manager Our Price Records
Aug 1979-Jun 1980 : Polytechnic of Central London
Jun 1980-Jun 1983 : Travelling SWITZERLAND, FRANCE, USA, HONG KONG
Oct 1983-Dec 1983 : Salesperson Boots Chemist
Dec 1983-Dec 1985 : Computer Operator/Programmer (dBASE II) Ancon Insurance (UK) Co Ltd
Dec 1985-Feb 1988 : Analyst/Programmer (Clipper/dBASE III) Crownpark Business Software
Feb 1988-Jul 1992 : Senior Technical Specialist (ORACLE v5, v6, v7, VMS ,Unix, Dos) Cedardata plc
Sep 1992 : 1 week Consulting in CFACS and DBA skills at Cranfield Institute of Technology.
Dec 1992 : 2 weeks C-Programming for D.H. Craighead & Partners, consulting Actuary.
Dec 92 - Jan 93 : 1 Months Analysis,Design and Programming a small project to enhance the CFACS Accounts package for INMARSAT
Jan 93 - Aug 95 : Consultancy for Cranfield University
Oct 94 - Mar 95 : Consultancy for Cranfield Management Development LTD
Jan 95 - Mar 95 : PRO-C Programming Smith New Court Derivatives, Farringdon
Interfaces to COLT and TCAM on VAX/VMS platform.
Apr 95 - May 95 : PRO-C and C++ Programming on Vax/VMS, NT Smith New Court
May 95 - Aug 95 :PRO-C Programming on PC/OS/2/ Netware, New World Payphones
Aug 95 - Jun 99 :PRO-C, OCI, Unix,NT,OS/2 Cranfield University, HM Treasury, Cedargroup

CEDARGROUP ( Freelancing )
Responsible for Middleware Server development during Intranet project. Middleware written in C using TCP/IP networking functions on NT/DEC & HP Unix/ OS2. Database functions programmed using Oracle OCI. Coded the front end Java classes responsible for socket communications with Middleware.

CRANFIELD SCHOOL OF MANAGEMENT ( Freelancing )
Interfaces to Shamrock system, Unix Shell scripts, Install own Scheduler Product

HM TREASURY ( Freelancing )
Interfaces to CFACS Accounting system, Unix Shell scripts, Install own Scheduler Product

CRANFIELD UNIVERSITY ( Freelancing )

Over the Period April 1993 - November 1994 designed and implemented 4 Projects:

CRAMENU An enhancement to the CFACS Menu System
Writen in Sqlforms 3, Pro-C, Unix awk and Korn Shell.
Allows a more flexible menu structure.

CRALATER Job scheduling interface between Oracle and Unix
Writen in Sqlforms 3, Pro-C, Unix awk and Korn Shell.
Allows users to configure and schedule jobs from within Oracle.
Provides reporting on Jobs Scheduled, Jobs Completed and their
completion status also uses Unix Mail.

CRAJLINK Datafile interface between external systems and General Ledger Interface.
Writen in Sqlforms 3, Pro-C, Unix awk and Korn Shell.
Provides users with the facility to upload General Ledger Journals to the
CFACS General Ledger. Files can be text files or Lotus 123 spreadsheet files.

CRAFORMA Datafile interface between CUPID course booking system and CFACS
Invoicing Interface
Writen in Sqlforms 3, Pro-C, Unix awk and Korn Shell.
Enables FTP transfers of Course booking information to be transferred to
CFACS Invoice Interface.

CRANFIELD MANAGEMENT DEVELOPMENT LTD ( Freelancing )

Consulting re:
Performance Tuning
Configuration Management

I designed and implemented an enhancement to the CFACS accounts package which enabled a system manager to administer the configuration and generation of complex views on the CFACS Accounting package tables. I undertook the design of the database schema and forms. I also spent time prototyping and performance testing of key SQL statements using Oracle's explain plan tool. I delivered optimum performing software in good time along with User and Technical documentation including an entity model for the schema. The project involved using SQLFORMS and PRO-C. The software is crucial to the successful implementation of their accounting system. The software that I produced is now sold along with other components of the CFACS Accounting system.

I was commissioned to write a C program used to calculate cash flow for reinsurance companies. The analysis of the project involved the translation of certain statistical formulae into C code. The program also has a graphics module which displays and prints a graph using low level graphics routines.

I have been hired to do some DBA training and Database administration tasks for Cranfield Institute of Technology on a number of occasions.

ORACLE V6, V5, SQLFORMS 2.3, 3.0 & PRO-C & C
Devised template forms and user exits which became the company standards.
Developed an in house quotation system.
Devised many reusable core modules for the CFACS Accounts system.
Tested and evaluated several Forms 2.3 to 3 conversion tools.
Involved in Analysis and programming many of the CFACS modules.
General Ledger Sales, Purchase Ledger, Sales Order Purchasing

AWK, LEX & YACC, C/BOURNE & KORN SHELLS
Devised custom conversion routines to make bulk changes to programs.
My conversion routines have saved many man hours .
They were particularly useful during porting where small but
widespread changes were effected quickly and reliably.

SQLDBA
Responsible for DBA activities for many of our clients as well
as CEDARDATA.

DECNET/VAX & TCP/IP, PCSA/PATHWORKS & COMMUNICATIONS TOOLS
Telnet, UUCP, kermit, zmodem, PCAnywhere, modem configuration,
compression and decompression tools. I configured and
supported various networks both within CEDARDATA and for
clients.

CONFIGURATION MANAGEMENT
Devised coding standards and naming conventions.
Developed portable installation procedures built around the MAKE utility.
Responsible for the first Unix and MSDOS ports and a port to
Data General AOS.

My many successful ports of the CFACS package arose from my
ability to become familiar with unknown systems and to solve
problems quickly.

Devised in house SQL reports to aid configuration management.
Devised an entity model for our Support system.
Adept at understanding and debugging unfamiliar code.

COURSES ATTENDED
Management of Decnet VAX
VMS System Management
SqlForms 2.3

CLIPPER/dBASE III
Analysis and Programming bespoke applications including:

A pension administration system for The Press Association.
A shipping registry for Seacontainers LTD.
A Back Office system for an Inter Dealer Broker in the City.
A demonstration application for Ashton Tate.

PARADOX

Programming and Consultancy for United Distillers
NOVELL NETWORK

Installation, Configuration and Support for various clients in
the City, both hardware and software.

I designed and configured the details of the Crownpark Training
Centre network.

DBASE II
Designed a suite of 40 programs and a menu system to provide
Data Entry and Reports. The reports were designed in liaison
with the Company Accountant and the Technical & Claims
managers. Input data was from a daily printout from PSAC and
the reports were used to verify the reliability of a mainframe
system, which was often found to be incorrect. My system
became a vital part of the company's operation and I was
re-employed on a consultancy basis when the company was taken
over.

Travel,Computing, languages, popular and classical music, carpentry, technical
drawing, midi computer music, guitar playing, wind surfing, sailing a 23ft Dauntless,
tennis and skiing. Amateur Dramatics

RESPONSIBILITIES HELD AT SCHOOL

Deputy Head Of House
Captain of House Tennis Team
Full back for 2nd XV Rugby Team
Helmsman for 2nd VI Sailing Team
Member of the Photography Club
Actor/Singer in various school plays/productions

REFERENCES

MR L BIRD family friend for 20 years.
95 Eyre Court,
LONDON NW8 9TX
TEL: 0207 4833082

MR Ian Sibbald Financial Controller Cranfield University.
Cranfield University
Cranfield,
Bedford
MK43 0AL
TEL:01234 750111

MR A HALES In charge of Product Development at Cedardata plc.
WOODFIDLEY COTTAGE
NEW ROAD
SWANMORE
HAMPSHIRE SO32 2PE
TEL: 0489 895117