JOHN LILLEY

I have over 20 years of database development including 11 years in datawarehousing. As the key resource on many end-to-end datawarehouse projects, I have the in-depth hands-on experience required to make your datawarehouse project a success. Unlike many specialists, my experience covers all aspects of datawarhouse development from dimensional modelling through the ETL process to the front-end presentation layer. Only someone who truly understands the relationships between these different elements of your datawarehouse will be able to deliver an efficient, balanced and easily maintainable system.
Main Skill Set Client Sites
  • Data Warehouse
    • Kimball
    • Star-Schemas
    • SCD 1-3
    • ETL design
    • Partitioned tables
    • Parallel loads
  • ORACLE
    • OBIEE/OBISE
    • RPD, Reports & Dashboards
    • OWB
    • PL/SQL, Toad, SQL-Nav
    • PL/SQL Developer
    • SQL*Plus, SQL-Loader
    • Data-pump, external tables
    • ETL UNIX/Windows scripts
    • DBA (OCP 9i)
    • Designer 2000, Erwin
  • Business Objects
    • Report Developer
    • Universe Designer
  • Micro Strategy
    • Report Developer
    • Project Designer
  • Allied Irish Bank
  • Bahrain Telecom
  • Bank of Scotland
  • Belgacom
  • Birmingham Midshires Building Soc.
  • Botswana Telecom
  • British Aerospace
  • British Airways
  • British Medical Association
  • Citybank
  • Computer Sciences Corporation
  • Couttes Bank
  • Direct Line
  • Fish4
  • Guardian Royal Exchange
  • Hambros Bank
  • IMS Health
  • Lombard Finance
  • Lynx Holdings
  • Protocall One
  • Sun Microsystems
  • Steria (BT project)
  • Teamsolve
  • Telecom Namibia
  • Tia Systems
  • Royal Bank of Scotland
  • UIA
  • Ulster Bank
  • Wyeth Pharmaceuticals

Contact Information

Telephone: 07930 342935