Datamile Computers Ltd

Consultant Profile

	Ian White
	Database Designer/Senior Analyst Programmer (Oracle/Sybase) Computer Science Degree (University Of Exeter) Nationality : British Date of Birth : 05/09/66

Other Skills

Methodologies - Method1, Design1, Yourdon, MASCOT

Languages LISP, PROLOG, SIMULA 77, PC Assemblers, Oracle Financials, Smalltalk, OCCAM, Forth Tools:- , Visual Basic, Access, Excel, Word, SQL*Loader,SQL*Import, PVCS, CMS, RCS, SCCS, ENFIN Others PC Hardware, PC Configuration, OOA, OOD, Stock Market operation.

Services Provided on behalf of Datamile Computers

•  (June 99 - Present contract extended)

Tasked to bring Datamile Computers experience into Deutsche's Banks Commisson Management Information System, and to enhance it to a more global level, whilst automating processing and controls. The system is based on a 40gb oracle 7 database using oracle web server as front end, operating non-stop as a global information system. Products used on the project by us were :-

• Oracle web server and pl/sql with javascript
• C shell scripts and perl
• Oracle tools sql*import and sql*loader

•  Bankers Trust – Contract Development Manager ( April 98 – June 99 contract extended)

Acting as  development manager for the Bank’s European Cash equities Management Information Systems, Ian was responsible for project planning, design, and client interaction. The two major projects were as follows :-

• Oracle Data server, which collected, validated and collated transactional data from various source systems, in order to provide an auditable dataset for downstream DSS and OLAP systems. The technologies employed in this system are :- Oracle 7.3, Forms 4.5, sql*loader, pl/sql and UNIX shell scripts

• Sybase 11/Powerbuilder 6 OLAP system used by sales staff, analysts and management to sample multi-dimensional views of current and historic transactional data. Sybase stored procedures are used to extract the data, before presentation to the user via a Powerbuilder front-end.

With a small team, Ian spent 80% of his time as the senior developer. This role included design, implementation, testing and tunning of the databases and interfaces, with the occasional Powerbuilder tasks during high resource loads.

Under his management, both of these systems went  through Y2K and EMU upgrades, and successfully passed bank-wide compliance testing without fault.

•    Natwest Markets (July 1995 - April 98  contract extended)

  Maintaining and enhancing a major 2.5GB Oracle 7 database used to provided trading breakdowns by stock. sector, client, and financial data to back office and traders. Ian was responsible for the full life cycle of the project, including

  • Attending user design meetings
  • Project design, management and planning.
  • Implementation and testing of new developemtn
  • Daytime user support and overnight processing support.
  • Database design, performance tunning

Member of development team on Sybase 10/11 warehouse system providing Operational Accounting and SFA reporting for the bank.

•    Oracle UK (Feb 95 - July 95 contract extended)

  Project - Major re-design and upgrade of the European Passenger Services ticket sales accounting system. The system imported european rail ticket sales and receipt flat file data into Oracle financial's General ledger and Revenue Accounting packages, where monetary transfers between the various rail companies and ticket agencies would be computed. Tasks performed by Ian were as follows :-

  • Database, Process, and User Interface design.
  • Process and Interface implementation ( PRO*C , PL/SQL , Forms 2.3)
  • Unit and link testing.

•          ACT Banking Systems Contract A/P (Sept 94 - Feb 95   contract extended)

  Project - Middle-office consolidation system for bonds, loans, FX and other derivatives including interest rate swaps, caps, floors, futures and options. Jam used as a Windows front-end for the input of static data and instrument definitions. A C based Object Broker (Nwi) used to interface User, Business and Data classes which provided the access to ORACLE or SYBASE databases on IBM or HP UNIX hardware. Specialized user class used to batch feed daily trade data into the Object Broker. Major tasks performed were as follows :-

  • Program Specification, user interface design
  • Coding of classes in machine independent C (Unix and MS-Windows) and user interface implementation (Jam)
  • Programing of Oracle and Sybase database interface code
  • Unit and system testing using formal test packs (Oracle and Sybase).

•         AT&T Istel Contract A/P (Sept 93 - Aug 94  contract extended)

  Tasked to convert global network port booking systems held under MS-Excel, to a multi-user, real-time Oracle database. Solely responsible for full life cycle of the project, tasks involved user meetings, database design and implementation, data conversion and checking using PRO*C and SQL Loader, interface design and prototyping, implementation in JAM under windows using SQL*NET, testing and hand over. Development multiple algorithms for automatic port allocation, and implement full history tracking of ports and customer bookings.

  Other tasks :- Oracle DBA (User, table and tablespace management), Technical support on Oracle, JAM and SQL. JAM6 and Visual Basic

•                             Thames Water Utilities Senior A/P (May 90 - Sept 93)

  Technical consultant on a client server systems implemented in C, Smalltalk, Enfin and JAM running on a RDB database

• Ferranti International Software Engineer (Aug 88 - May 90)

  Involved with projects that supplied data from optical drives into transputer networks for processing and then displaying the results on graphical workstations. Developed using FORTH, Turbo PASCAL and OCCAM. Developed FORTH kernel for use in all FORTH projects

Web Author: Ian White mailto:ian.white@dataamile-computers.com
Copyright ©20001Datamile Computers Ltd - ALL RIGHTS RESERVED

This document is not to be transferred, distributed or change without the permission of Datamile Computers Ltd. By downloading, coping or printing this document you accept Datamile Computers Ltd. standard terms and conditions.