CV for Barry WILLIAMS – Data Analyst

1. SUMMARY OF EXPERIENCE

  • Many years experience in Data Modelling, Data Migration and Data Warehouses,

Data Analysis, Database Design and Implementation, and as a DBA.

  • At London Borough of Haringey - Data Analyst on a corporate Data Migration Project :-

-Created Framework for a Data Migration to Corporate Data Warehouse and Data Marts.

-Designed over 50 ERWin Data Models including ‘Single View of the Customer’.

-Software included Oracle, SQL Server, SAP, Siebel, Business Objects and ERWin.

  • At Credit Suisse Bank - Data Analyst on Basel II Team :-

-Designed a Database to analyse timings for loading 200 Data Migration Files.

-Software included Oracle, Sybase, SQL Server and ERWin for Data Models.

  • At Cisco - Data Analyst on a Data Migration Project :-

-Created ETL SQL Templates to load Oracle Datawarehouse from 15 Countries.

-Producing Migration Specifications and obtaining User Buy-in.

-Software included Oracle SQL, PL/SQL ,Sun Solaris UNIX,TOAD and ERWin.

  • Data Analyst / DW Designer for two years at Centrica, (the AA, British Gas). :-

-Designed a ‘Single View of the Customer’ for AA and British Gas.

-Produced specifications for mapping from 40 source Systems to Data Warehouse.

-Created ERWin Data Models to map 40 Data Sources to the Data Warehouse.

-Created an Enterprise Data Repository and published it over the Intranet.

-Software included Oracle, SQL Server, SAS, Business Objects and ERWin

  • Maintains Web Site where he has created a Library of over 200 Data Models :-

The breadth of his experience is summarised in a table at the end of this CV.

Letters of Appreciation from all of Barry's previous Clients are available on request.

Qualifications :B.Sc. Honours Mathematics, (Leeds University)

Diploma in Computer Science, (Leeds University)

RDBMS :Oracle, SQL Server, Access, CA-Ingres, Sybase.

Data Modelling:ERWin, Oracle Designer, Sybase DataArchitect, Rational Rose (UML)

CLIENTS SINCE 1990 :

Start Date DurationClient NameRole

Oct 04 7 monthsLondon Borough of Haringey Data Analyst

Apr 04 6 monthsCredit Suisse Bank. Data Analyst

Sept 03 6 monthsCisco Systems Ltd. Data Analyst

Jan 03 8 monthsUnited Nations Data Architect

Jan 01 2 yearsCentrica, (AA, British Gas, etc.)Data Analyst

Dec 99 1 yearRubus Ltd.Data Analyst

July 99 6 monthsBank of MalaysiaData Migration Analyst

July 98 1 yearNational Power, SwindonData Modeller/Analyst

Oct 97 9 monthsBank of MalaysiaData Migration Analyst

Feb 97 8 monthsBarclays BankData Migration Analyst

Mar 96 8 monthsSalomon Smith Barney BankDBA

Nov 95 6 monthsRaboBank, Holland Data Modeller

May 95 6 monthsHambros BankDBA

May 94 1 yearBarclays BankDatabase Designer & DBA.

May 93 1 yearVodafoneDatabase Designer.

Nov 92 6 monthsBarclays BankDatabase Designer.

Jul 92 4 monthsUniversity of London and WCMCPh.D. Student and Database Consultant.

Jan 91 18 monthsMitsubishi BankDatabase Designer & DBA.

Mar 90 9 monthsParibas Bank, Paris. DBA

2. DETAILS OF ASSIGNMENTS

Oct 04 – May 05London Borough of Haringey Data Analyst

  • Created complete Framework for Data Migration to Corporate Data Warehouse and Data Marts.

April 04 – Sept 04Credit Suisse Bank Data Analyst

  • Analysed loading of over 200 Files into a Datawarehouse to ensure Data Integrity for Basel II.

Oct 03 – Mar 04Cisco Systems Ltd. Data Analyst

  • Migrated data from 15 Countries into an Oracle Datawarehouse.

Jan 03 –Sept 03United Nations Data Architect

  • Designed ICT Toolkit to support Best Practice and Global Reporting across the UN.
  • Created Data Models and Databases for Registration, Communities, Q & A and Feedback.

Jan 01 –Dec 02Centrica Ltd., (the AA, British Gas, etc.)Data Analyst

  • Data Analyst / Architect and DW Designer in the corporate Data Management Group.

Dec 99 -Dec 00Rubus Ltd. Data Analyst

  • Data Architecture, Data Migration, Database Design and Review for major Clients:-

Granada Media, Andersen Consulting and Cazenove (Stockbrokers).

  • Designed Datawarehouse for Visits to the Granada TV Coronation Street Web Site (1999) to analyse the effectiveness of Cadbury’s advertising campaigns.

July 99 -Dec 99Bank of MalaysiaData Migration Analyst

  • Designed a Data Migration Architecture to load operational data and present Key Performance Indicators,(‘KPIs’) data values to the General Manager with Drill-down.

July 98 -Jun 99National PowerData Modeller/Analyst

  • National Power had mission-critical Systems to be tested for Y2K-Compliance.
  • Created 15 Data Models to understand Source Oracle Databases.
  • Created UNIX Shell Scripts, used SQL*Plus and Oracle Designer/2000.

Oct 97 -Jun 98Bank of MalaysiaData Migration Analyst

  • The Bank was committed to migration to an integrated Data Architecture.
  • Carried out Data Analysis for mapping of all sources of Data involved.
  • Designing a Database for the loading and Staging Area.

Feb 97 -Oct 97 Barclays Bank Life Assurance Co. Ltd. Data Migration Analyst

  • Barclays Bank was changing to Customer-facing Systems over an Intranet.
  • Data Modelling for all sources of Data involved.
  • Designing a Data Architecture and Mapping the migration of Data.

Mar 96 -Dec 96Salomon Smith Barney Bank, LondonDBA

  • Senior DBA and created Intranet-based Best Practice for other DBAs in USA.

2. DETAILS OF ASSIGNMENTS (continued)

Nov 95 -Mar 96RaboBank, Holland. Data Modeller

  • Designed a Generic Data Model for a Global Risk Management System.

May 95 -Nov 95Hambros Bank, UK. Data Analyst & DBA.

  • Provided Technical Consultancy on performance of a production Database.

May 94 -Apr 95Barclays Bank Group Headquarters.Data Analyst & DBA.

  • Designed a Data Warehouse for a new Consolidated Global Financial Reporting System.

May 93 -Apr 94Vodafone, Newbury. Data Analyst & DB Designer.

  • Designed a new MIS/Data Mart System, loading Data from an IDMS Mainframe.

Nov 92 -May 93Barclays Bank Commercial Services Data Analyst & DB Designer.

  • Worked on Data Migration, ensuring Data Quality in association with the Users.

Jul 92 -Oct 92University of London andPh.D. Student

World Conservation Monitoring CentreData Analyst.

  • Pursued his interest in taking a Ph.D. in Intelligent User Interfaces

.

Jan 91 -Jun 92Mitsubishi Bank, London.Data Analyst, DBA.

  • Defined a Database Strategy to migrate to a Sybase Consolidated Corporate Database.

Mar 90-Dec 90Paribas Bank, Paris. Data Analyst, DBA

  • DBA in a Merchant Bank supporting Users and Developers in France and the UK.

May 89-Mar 90Automobile Association.A/P & Database Designer

  • Database design and development establishing standards in a ‘Greenfield Site’.

May 88 -Apr 89Reuters, London.A/P & Database Designer.

  • Database design and development for a new MIS Database to take data from a legacy system.

Dec 87 -May 88Sherwood Computel, Gloucester.A/P & Database Designer.

  • Database design and development for Personal Financial Systems.

Apr 87 -Nov 87Travelling around the world.Getting Married in Malaysia.

Sep 86 -Mar 87J.P.Morgan Bank, London.A/P & Database Designer

  • Database design and development for a Dealer’s Position Management System.

Previous History :-

  • 1982 - 1986 - Freelance Computer Consultant in Canada, New York and England.
  • 1977 - 1981 - Research EngineerBell-Northern Research, Ottawa, Canada.

Page 1 of 4

CV for Barry WILLIAMS – Data Analyst

3. AREAS OF EXPERTISE

Start
Date / Client / Duration
of Contract / Data Warehouse / Data
Analysis / Data
Modelling / Data
Migration / Data
Cleansing
Oct 04 / London Borough of Haringey / 7 months / Yes / Yes / Yes / Yes / Yes
Apr 04 / Credit Suisse Bank / 6 months / Yes / Yes / Yes / Yes
Oct 03 / Cisco Systems / 6 months / Yes / Yes / Yes / Yes / Yes
Jan 03 / United Nations / 8 months / Yes / Yes / Yes
Jan 01 / Centrica - AA, British Gas,etc. / 2 years / Yes / Yes / Yes / Yes / Yes
Dec 99 / Rubus Ltd. / 1 year / Yes / Yes / Yes / Yes / Yes
July 99 / Bank of Malaysia / 6 Months / Yes / Yes / Yes / Yes / Yes
July 98 / National Power / 1 Year / Yes / Yes / Yes / Yes
Oct 97 / Bank of Malaysia / 9 Months / Yes / Yes / Yes / Yes / Yes
Feb 97 / Barclays Bank - Life Assurance Co. / 8 Months / Yes / Yes / Yes / Yes / Yes
Mar 96 / Salomon Brothers Bank / 9 Months / Yes / Yes / Yes
Nov 95 / RaboBank, Holland / 6 Months / Yes / Yes / Yes / Yes
May 95 / Hambros Bank / 6 Months / Yes / Yes / Yes
May 94 / Barclays Bank - Group HQ / 1 Year / Yes / Yes / Yes / Yes / Yes
May 93 / Vodafone / 1 Year / Yes / Yes / Yes / Yes / Yes
Nov 92 / Barclays Bank - Commercial Svcs / 6 Months / Yes / Yes / Yes
Jan 91 / Mitsubishi Bank / 18 Months / Yes / Yes
Mar 90 / Paribas Bank, Paris / 9 Months / Yes / Yes
Mar 89 / Automobile Association / 1 Year / Yes / Yes / Yes
Mar 88 / Reuters / 1 Year / Yes / Yes
Nov 87 / Sherwood Insurance Services / 6 months
Mar 86 / J.P.Morgan Bank / 6 months / Yes

Page 1 of 4