| Contact | william@williamrobertson.net |
|---|---|
| Skills |
Oracle 10g, PL/SQL,
years Unix Korn shell scripting years, all platforms HTML, CSS, JavaScript, intermediate. Consultant years Team leader 5 years |
| Profile |
Oracle developer with years' experience of Oracle toolset, building robust applications, and performance tuning. As a consultant I led a 5-man development team for 4 years at T-Mobile/One 2 One (below), working closely with end users and project management to confirm requirements, anticipate issues, and resolve problems. In 2007 I was honoured to accept an Oracle Ace award. In free moments I contribute to Quest Pipelines (where I am a Sysop), OTN, OraFAQ, DBForums and DBA Support forums, and my own Oracle-WTF team blog. You can see examples of my work by searching Google for "William Robertson" (oracle OR sql OR pl/sql OR shell) I am enthusiastic about good quality, well structured, efficient, inspired programming:
“Let’s make those computers sing” |
Barclays Capital, Canary Wharf:
Technical lead in Oracle 10.1 to 10.2 upgrade project for large batch system processing daily trading data (Oracle 10g, AutoSys, MQ Series): tested and performance tuned multiple PL/SQL batch processes to handle 10.2 optimizer changes, taking advantage of 10g new features with minimal changes to code. Reviewed statistics gathering strategy, use of parallel query, etc.
Produced technical design for the changes to the system for a new Barclays Capital trading office planned to open in Moscow.
Second-line support and development, addressing performance issues.
Betfair.com Hammersmith:
Betfair is the largest online betting company in the UK and the largest bet exchange in the world. The exchange itself is modelled on the Stock Exchange. Maintaining a high online transaction rate and database availability are crucial to the business.
While at Betfair I worked on changes to the exposure calculation, and re-engineered the database queries behind the online 'My Account' reporting screens to support changes to the product range and to improve performance and maintainability. For each new stored procedure I developed a corresponding unit test procedure, forming part of the project's automated UT suite.
HSBC Investment Banking, Canary Wharf E14 (contract):
Back-end design, development, support and performance tuning for financial datawarehouse (Oracle 8i, 10g, PL/SQL). Developed PL/SQL package to allow generic Java application to extract data in bulk, for loading into Sybase IQ datamart.
Ace*Comm: (formerly Double Helix Solutions), London EC1 (contract).
Back-end Oracle development of a revenue assurance application (Oracle 9.2, PL/SQL, performance tuning, Korn shell): the system reports discrepancies between service configuration and customer billing for clients NTL, Telekom Austria and others, loading large data volumes and producing discrepancy reports.
Converted batch load processes to use 9i External Tables and Materialized views in place of the existing shell scripts and SQL*Loader approach, allowing loads to be controlled from the new web front-end instead of Unix command line.
NTL, London EC1 (contract, with IT consultancy Double Helix Solutions).
Back-end telecomms datawarehouse project (Oracle 9.2, PL/SQL, Korn shell). Performance analysis, tuning and rewrite of batch loads.
Data migration of complex network management data from a great many files and spreadsheets with an assortment of formats into new inventory management system to tight timescales.
Analysis and design for a new Customer data model (CASE Studio) followed by design and build of data loading procedures.
The Woolwich PLC, Bexleyheath, Kent (contract).
Support-development, test and troubleshooting role within support team for datawarehouse system. (Oracle SQL, PL/SQL, Unix Shellscript, Control-M job scheduler.) In addition to monitoring the production batch schedule and troubleshooting data problems I was involved in improving coding and quality standards, code reviews, error reporting and performance tuning.
Began learning Java, JavaScript, HTML and CSS.
Built website www.williamrobertson.net.
Answered technical questions daily on Oracle Metalink,
OTN,
Quest Pipelines,
DBA Support and
Computing.net forums.
T-Mobile, Hatfield (permanent).
Senior Systems Consultant, Information Quality team - cross-department analysis and troubleshooting unit investigating business systems and processes to find information quality issues, trace them to their root causes and propose solutions. This involved discussions with staff to discover issues and plan process or system improvements, and developing validity reports on sampled data, e.g. analysing patterns of address change and credit status history.
Developed system to reconcile data between billing system and data warehouse, using stored procedures to extract data via timed database jobs.
Left due to redundancy (one of 700 staff to leave).
Sopra Group, IT consultancy, Stevenage (permanent).
Senior Technical Consultant, working mainly on client sites.
Consultancy assignments included:
1999 Getty Images, photo image library: support and re-engineering of business systems (Oracle 8i, PL/SQL, Forms 4.5, Solaris). Developed API for legacy sales system to accept batched sales transactions from the company’s new web storefront. Coordinating requirements from end users in eight countries, developed an interactive interface to read incoming data files and log sales. Helped implement PVCS version control.
1996-1999 T-Mobile: Design and Development Lead for 5-man team developing Commissions system (Forms 4.5, Designer/2000). The system loads bulk data and performs calculations based on rules defined by users via a Forms interface. Results are stored for reporting, including commission and subsidy statements for over 2,000 high street dealers. The system is still in use as of 2006.
1995 Ernst & Young: Enhancements to a client database using batch data download from legacy system. (SQL*Forms 3.0, PL/SQL)
1994 Brent Housing: Developed reports for the Oracle Housing application. (SQL*ReportWriter)
1994 M W Kellogg: engineering/construction: designed and developed an order-tracking system. (Oracle 7, Forms 3.0, CASE 5.1, VAX/VMS.)
Sopra Rand, IT consultancy (permanent).
Designer/Senior Programmer on policy rating & administration system for Commercial Union Belgium.
Application development on Oracle/Unix (Sequent S2000) using Oracle toolset (SQL*Forms 3.0, SQL*ReportWriter etc.)
Aug-Oct 1993 Implementation team: travelled to client site in Brussels to plan migration exercise.
Dec 1992 - Aug 1993 Design team, conducting workshops with clients and delivering design specs to development team, using Oracle Designer.
Synergo Technology (now part of Wilco International), financial software supplier, London SE1.
Implementation analyst for TAROT Stockbroking system.
Responsibilities included data analysis, conversion and loading, developing SQL reports, visiting client sites around the UK
and in Dublin to install software on UNIX and VAX platforms, load data, and monitor and solve problems.
Wright Systems, London NW6.
Trainee analyst/programmer.
Application development using Oracle 5.1 toolset
(SQL*Forms 2.3, SQL*ReportWriter 1.1) on DOS PCs.
Various Graphic Design, including freelance and contract positions, e.g:
1987 Haringey Health Authority, London N15.
1985 'Running' Magazine, London WC1.
1982 The Creative Business ad/marketing agency, London WC1;
London College of Communication 1977-1981 (Graphic Design).
Degree: BA Graphic Design.
Wellington College, Berkshire, 1973-1977
O Levels: Mathematics, Statistics, Physics, Chemistry, Biology, English Language, English Literature, French, History, Art, Latin, Ancient History, French Literature AO level.
A levels: English Literature, French Literature, Art.
British
Own flat in Crouch End, London N8.
Full licence, nice car. Happy to commute up to about one hour from N8.
Contract, surprisingly reasonable.
Download as PDF Microsoft Word