• Designed architecture for a large commercial analytical SAS system, making use of a parallel processing architecture
• Designed and built several data warehouses and Management Information Systems
• Presenting many papers at SAS conferences in the USA, Europe & Australia (1989-2003)
• Keynote speaker at SAS Users Group of Chicago International conference (2000)
• Winner of Most Valuable SAS-L member twice
• Honourable mention for my paper at SUGI in 2001 and PHARMASUG 2002
• Invited to speak at SUGI conference many times
• Author of the book “In the Know – SAS Tips & Techniques from around the globe”
• Wrote & presented the “Advanced Macro Programming” training course for SAS Institute.
• Developed and ran a training programme to train people in SAS and Biostatistics 2002/2003.

All positions were done as contracts, except for the ones marked in yellow.

Wood Street Consultants Ltd.

Author (2002-present)

·         Writing & updating 6 courses to be presented in Washington & Minneapolis in September 2003

o        "SAS tips & techniques"

o        "Pharmaceuticals for SAS programmers"

o        "SAS Reporting"

o        "Advanced ODS & Advanced Graphics"

o        "Clinical Trials for SAS programmers"

o        "Advanced Graphics

SAS Institute, Books By Users

Author (2003-present)

·         Writing a revised edition of my book “In the Know: SAS Tips & Techniques from around the Globe”. Is being updated for version 9.1 of SAS

PHARMASUG regional SAS conference - Miami, USA

Trainer (1 day May 2003)

·       Presented 1 day course about SAS Tips & Techniques

PPD Development - Cambridge, England

SAS Consultant & SAS/Pharmaceutical Course Author/Trainer (August-March 2003)

·       Project manage development of a 6 month Graduate Training programme to train recent graduates as Biostatistician Programmers

·       Review existing SAS training material, modifying and supplementing as required

·       Write SAS courses

·       SAS Reporting course – covering ODS, SAS/Graph, Data Step, Proc Report, etc.

·       Accelerated SAS training – covered many areas for experienced programmers including SQL

·       Advanced ODS course

·       Advanced Graphics course

·       SAS version 8 update seminar

·       SAS certification preparation and revision course

·       Provide support to team of experienced SAS programmers

·       Help desk function, answering questions & prototyping solutions

·       Outlined solutions for SAS related process problems – e.g. change control, automated log/list/program management, etc.

·       Write some pharmaceutical industry training

·       Many presentations about Standard Operating Procedures & Working Practices

·       Introduction to the Pharmaceutical Industry

·       An extensive Dummy Study which involved application of clinical trial techniques to study data – combined practical SAS skills with practical clinical trial skills

NESUG regional SAS conference - Buffalo, USA

Trainer (2 days Sep 2002)

·       Presented 1 day course about Advanced Macro Programming techniques

·       Presented 1 day course about SAS Tips & Techniques

MWSUG regional SAS conference - Indianapolis, USA

Trainer (1 day Aug 2002)

·       Presented 1 day course about Advanced Macro Programming techniques

Oxford Pharmaceutical Services - Wallingford, Oxfordshire, England

SAS Consultant (July 2002)

·       Wrote SAS programs to produce a series of tables and listings for a Clinical Trial.

SAS Institute -USA

Trainer (8 days during May 2002)

·       Presented 1 day course about Advanced Macro Programming techniques in San Francisco, Chicago, New York and Rockville (Washington).

Oxford Pharmaceutical Services - Wallingford, Oxfordshire, England

SAS Consultant (April – June 2002)

·       Extended functionality of a Pharmaceutical Data Entry/Management System for use by CROs. Added support for multiple concurrent users.

SAS Institute - Melbourne & Sydney Australia

Trainer (10^th & 12^th April 2002)

·       Presented 1 day on-site course about Advanced Macro Programming techniques.

NRMA - Sydney, New South Wales, Australia

Trainer (9^th April 2002)

·       Presented 1 day on-site course about Advanced Macro Programming techniques.

A.A.M.I. (Insurance) - Melbourne, Victoria, Australia

SAS Data Warehousing Consultant (March 2002)

·       Evaluated SAS technology used in the current data warehouse and make recommendations for improvements and future directions.

SAS Software Limited - Marlow, Buckinghamshire, England

SAS Consultant (December 2001–March 2002)

·       Write the official SAS course titled “Advanced SAS Macro Programming”

Oxford Pharmaceutical Services - Wallingford, Oxfordshire, England

SAS Consultant (September–November 2001)

·       Extended functionality of a Pharmaceutical Data Entry/Management System for use by CROs

Allied Irish Bank - Dublin, Ireland

SAS Consultant (September 2001)

·       Conducted many interviews and wrote proposal for an Enterprise Data Warehouse

Oxford Pharmaceutical Services - Wallingford, Oxfordshire, England

SAS Consultant (June-July 2001)

·       Created Data Entry System for use by CROs in Pharmaceutical Trials

·       Documented system and trained users

Motorola - Swindon, England

SAS Consultant (July 2000-May 2001)

·       R&D for new parallel processing architecture for an existing commercial SAS application

·       Ported a large application from Solaris to Windows

·       Upgraded a large application from SAS 6.12 to SAS 8.1

·       Investigate, prototype, evaluate and recommend various new technologies from SAS

Fortis Bank (formerly Generale Bank) - Brussels, Belgium

SAS Consultant (1997-July 2000)

·       Design & develop change control system

·       Develop programming standards & guidelines

·       Design & develop a complex GUI for a Risk Management System

·       Tune existing SAS systems and advise programmers

AXA (formerly National Mutual Health Insurance) - Melbourne , Australia

SAS Consultant (September 1995-1998)

·       Design & develop a health insurance data warehouse

·       Design & develop a Management Information System

·       Provided development services and support for over a year from England to staff in Australia

Sabena Airlines - Brussels, Belgium

SAS Consultant (May-June 1997)

·       Designed & implemented a large multi-dimensional data warehouse

·       Built an MIS

Janssen Pharmacuticals - Turnhout, Belgium

SAS Consultant (December 1996-February 1997)

·       Upgraded part of pharmaceutical information system from SAS 6.08 to 6.11, making use of new functionality

·       Defined and documented SAS data validation guidelines

·       Developed general purpose utility to export SAS data to other PC applications

British Gas - Staines, England

SAS Consultant (June-July 1996)

·       Built GUI to run a series of SAS macros producing reports

Janssen Pharmacuticals - Turnhout, Belgium

SAS Consultant (March-June 1996)

·       Designed and coded several modules for a pharmaceutical information system which produced a range of reports using complex parameters

·       Wrote programming guidelines and validation procedures for SAS coding team

Telstra (formerly Telecom Australia) - Melbourne, Australia

SAS Consultant (April 1994-September 1995)

·       Carried out hundreds of adhoc requests involving writing SAS code to report from a range of SAS databases

·       Wrote and presented SAS efficient programming & SQL courses

·       Produced daily SAS coding tips which were distributed to people inside and outside Telstra

·       Wrote a range of utilities for exploiting existing data sources

Janssen Pharmacuticals - Turnhout, Belgium

SAS Consultant (November 1994)

·       Produced a number of modules for a pharmaceutical information system which enabled interactive production of graphs, tables & listings

Morgan Bank Euroclear - Brussels, Belgium

SAS Consultant (January-December 1993)

·       Wrote a system for software promotion between development environments

·       Wrote an EIS for senior management

·       Tuned LAN SAS applications resulting in huge performance gains

Telstra (Telecom Australia) - Melbourne, Australia

SAS Consultant (February-November 1992)

·       Modified an MXG based billing system

·       Wrote a regional reporting system

·       Created the Telecom Online Enquiry System which was an advanced query tool for financial information

ANZ Bank - Melbourne, Australia

Information Technology Consultant (January 1990-December 1991)

·       Designed and produced a functional billing system which calculated costs of business functions

·       Produced complex one page financial analysis reports

·       Designed and produced a network availability system

·       Wrote dataset I/O analysis program which was published in MXG

Coles Myer[1] - Melbourne, Australia

SAS Analyst Programmer (April 1985-December 1989)

·       Many performance & tuning related projects

·       Worked on many capacity plans