Key Skills

Sybase (v 12.0) since 1994

Microsoft Visual Basic since 1993 including VB.NET

Unix since 1995 including Solaris v2.8

Training since 1994

HTML/ASP since 1996

Forest & Trees for Windows 1992 1998

Other skills

Visual Basic for Applications (VBA); UML; SPRiNG; Visio (Enterprise Architect); unix scripts (bsh,ksh,csh); lex; yacc; Presentations; MS Access; Modelling; Relational Design; Object Design

Employment History

CIBC World Markets Senior Analyst/Programmer 2001 to present

International Investment Bank.

Maintenance and enhancement of data warehouse for regulatory reporting.

Back end is Sybase on Solaris. Feed processes use unix scripts and stored procedures.

Maintenace and query/search front ends bulid with Visual Basic (inc.VB.NET).

Warehouse holds customer data for compliance purposes

Web front end for customer data (ASP).

System provides security, auditing and scheduling.

Major upgrades recently implemented

Warm standby arrangement recently implemented

Fidelity Investments Senior Analyst/Programmer (contract) 1995 to 2001

• Delvered and supported several systems.
• Produced full documentation
• Followed formal development methodology

• Deal Management System Reports
• Delivered a large suite of pre-defined reports.

Front end: Forest & Trees

Back end: Forest & Trees; Sybase

• Reports processed batch.
• Reports user-requested, scheduled and event-generated (e.g. process failure)
• Reports delivered to file, printer or email.
• 1997: system re-written in VB5 to improve performance, reliability and deployment.
• System integrated with other in-house systems.

o User reaction continues to be enthusiastic.

• Contact Tracking System
• System tracks all contacts between customers and the company.
• Records system events: customer search; account enquiry; dealing; etc.
• Users can view a complete history of all previous interactions a customer.
• Powerful way to monitor and report on phone activity.
• Later productised into a complete diary / customer / contact tracking system.
• Generic Reporting Tool
• Generic reporting tool; reports defined based on Sybase stored procedures.
• Overcomes many problems with commercial packages eg. Crystal Reports.
• Automatically prompts user for correct parameter values etc.
• Report formatting instructions are stored as a string in the database.
• System has since been productised and is available commercially.
• Time recording system
• 3-Tier architecture
• Front end: ActiveX components presented via the intranet
• Middle Tier: MTS-hosted COM+ components
• Back end: Sybase on Solaris
• Used UML during analysis and design.

Various Contracts Analyst/Programmer 1994 to 1995

• Delivered a variety of systems for Executive Information, Flexible Enquiries and Report Generation for several major clients.
• Used Forest & Trees and Visual BASIC
• Users could select, drill-down and perform slice & dice and graphing.
• Often integrated with email.
• Queried back-end sales databases (Oracle, Sybase, Informix).
• Primarily in the pharmaceuticals sector (Zeneca Pharma, Bristol-Myers Squibb, Rhone-Poulenc Rorer).

Freelance Trainer 1994 to 1995

• Gave training in Forest & Trees and SQL
• Some onsite, some at specialist training venues
• I always received very positive feedback.

BP Oil Programmer 1992 to 1994

• Developed EIS solution for BPs European lubricants businesses
• Used Forest & Trees, Visual Basic and Oracle
• used prototyping, and required close involvement with
• users of different nationalities

BP Oil Office Systems Support 1989 to 1992

• support and development of shared calendar and email systems.
• pioneered global remote access using X.25.

Ben Hardwick Fund, Addenbrookes Hospital - 1989

• PC training & support
• Built databases to support statistical anaysis for clinical research into liver transplants.

Personal

Contact

Address 174 Southwood Road phone 01892 530424

Tunbridge Wells email aj@logos.co.uk

TN4 8UX web http://www.logos.co.uk

Responsibilities and Achievements

I have held several leadership posts at church, particularly working with young people.

I am currently working with teenagers from church and the local neighbourhood.

• I have travelled widely in Europe. I have also visited America, Asia and Australia.
• I hold a Private Pilot's licence and a Flight Radio-Telephony Operator's licence.

Education

Degree Computer Science (Second Class) from The University of Exeter

A-levels Maths (A), Physics (A), German (D)

Personal

Full Name Alexander James Finch

Date of birth 12^th November 1966

Marital Status Married

Nationality British

I have a full, clean, driving licence.

I speak some French.

My German is rather better.

I am a committed Christian.

Interests

Magic

I enjoy spending time with friends, who are spread across the world.

I have a DV camera, and when Im a famous film director, youll be able to say you gave me a job.

I own a PS2. Enough said.