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

Languages - php , perl , c shell , html, javascript
Tools - SQL*Loader,SQL*Import, sed , shell , Visual Basic, Access,
Others - Stock Market operation. Star schemas, ETL, mysql
Methodologies - Method1, Design1, Yourdon, MASCOT

Services Provided on behalf of Datamile Computers

• warehouse designer / ETL specialist (June 99 - Jan 03)

Ian was brought into the client's team as an experienced MIS developer to convert a fledging equity sales MIS system into a global sales system capable of supporting and reporting on the banks 10 millions trades annual trades over a three year period. During this time the system has been enhanced from a 0.5 trade single source cash system with a 72 hour batch, a system with over 50 disparate feeds in multiple formats supplying over 10 million trades with a 12 hour weekly batch run.

Ian implemented a range of pre-processors and processors employing sed/ shell script/ perl/ awk/ sqlldr/ import/ db links to load the supplied data into a 270 Gb oracle 8.1.7 database. The data would then enter a standardisation and validation stage implemented in pl/sql before data analysts mapped local client/instrument and salesperson identifiers to global standard hierarchies and validated suspect data. Once a week, the data would be published to a reporting database where an OAS web site would give reporting and drillable data mining access to the management, salesperson and controllers. Ian would also be involved in the design and implementation of OAS web pages using PL/SQL packages.

Once this was stable, Ian created a daily batch process which would processed up to 14 days of daily trade data and incorporate it into the reporting database in a timing manner. This process required complex validation, as manual invention by the data analysts was no longer available before data publishing.

Ian's third major task was the design and implementation of a 36Gb star schema based on the dataset currently held within the reporting database. From the underlying trade and dimension tables a series of summary views were built, and this enabled 90% of end-user queries to be satisfied within a fraction of the time of the reporting database while hiding the complexity of the star schema from the end-user via oracle query rewrite. This resulted in the rollout of business object reporting using a simple universe model, and considerable cost savings in reporting analyst time, and hardware to support the reporting requirements.

Ian was further tasked to build a soft commission and client invoice tracking system. Developed in OAS, PL/SQL and perl the system would track client soft trades, while accepting invoice and payment data against their current balance resulting in monthly the generation of monthly PDF statements for mailing to the clients.

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

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

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.