linked-in

  • Barclays Direct +

    Position:

    • ETL Development & Support

    Dates: 

    • March 2013 to August 2014

    Role Synopsis:

    • Hired on a contract basis to develop ETL components to migrate core customer and savings data from Barclays Direct systems to Barclays UK.
    • Continued in a support capacity keeping Barclays Direct Data Warehouse and ODS systems functioning through a lengthy and volatile migration period.

    Enhancements / Projects Delivered:

    • Developed a core data validation function through Powercenter to expose validation exceptions (through Cognos) to a business unit for correction in source systems. The system allowed for opening of new exceptions and closure of fixed exceptions.
    • Designed and developed a function to produce data for the business for ongoing mailing selections in the critical migration paths, to comply with legal requirements at defined points in the pilot and main migration cycles.
    • Provided high quality 24/7 support through my extensive knowledge of Barclays Direct information systems. Produced several time savings through performance improvements such as bulk loading and session pipeline partitioning.
  • Sony Computer Entertainment +

    Position:

    • ETL Developer

    Dates:

    • July 2012 to March 2013

    Role Synopsis:

    • Hired on a contract basis to support existing online gaming ODS & Data Warehouse within the group finance department.

    Enhancements / Projects Delivered:

    • Worked closely with ETL counterparts in the San Diego and Tokyo offices.
    • Developed & supported ODS feeds from global game servers via Ruby scripts.
    • Worked with members of Accenture to implement a new financial planning tool for the group.
    • Developed and evolved various functions including reference data, player activity and a profit & loss Data Warehouse.
  • Legal & General Investment Management +

    Position:

    • ETL Analyst

    Dates:

    • November 2011 to July 2012

    Role Synopsis:

    • Hired on a contract basis to develop core data quality components for a Solvency II project using Informatica IDQ.

    Enhancements / Projects Delivered:

    • Designed and developed an IDQ framework for data validation for a Solvency II project (see first career highlight).
    • Developed an Informatica DVO suite of scripts to successfully test a migration from version 8.6.1 to version 9.1. These scripts were used to concurrently test outputs from both versions across dual versions of multiple systems to ensure a robust upgrade.
  • Carphone Warehouse +

    Position:

    • ETL Developer / Data Warehouse SME

    Dates:

    • November 2004 to November 2009

    Role Synopsis:

    • Joined as ETL Developer to work on ETL projects across Europe and provide 3rd Line 24/7 Data Warehouse support.
    • In July 2007, promoted to Retail Data Warehouse Team Leader to manage a team of 6 Developers with a remit to enhance and maintain the UK DWH and provide all 3rd line technical support.
    • In May 2008, Development and Support was off-shored. Subsequently oversaw the transition to the offshore partner and a role change to Application Manager to manage DWH services through the off-shore partner.

    Duties & Responsibilities:

    • Worked with Informatica Powercenter 7.6 and 8.1, UNIX, Oracle 10g Retail DWH, and Netezza Telecoms DWH using Kimball methodology and SCD Type 1 design type.
    • Delivered several projects in Informatica with UNIX shell scripts and Oracle PLSQL scripting.
    • Line managed 3 permanent ETL Developers and 3 partner resources including resource planning, recruitment, and training and performance management.
    • Created standard design approach, incorporating new requirements traceability matrix.
    • Delivered performance tuning and emergency changes where required.
    • Transitioned ETL development and support to offshore team. Led knowledge transfer, established KPIs and oversaw reporting / reviews. Reduced offshore costs by 35%

    Enhancements / Projects Delivered

    • Selected as Developer for rollout of a Telecoms Data Warehouse on a new Netezza instance, including creating POC for Netezza's Informatica connector and migrating Telecoms Data Warehouse ETL from Oracle to Netezza.
    • Delivered Informatica ETL components for a new Stock Data Warehouse for the UK. Enabled reporting for fraud and leakage analysis across all stores and warehouses and subsequently led offshore team to roll out a pan-European Stock Data Warehouse.
    • Delivered Informatica ETL components for enhanced Commissions reporting capability across Europe and led integration into Oracle Retail Data Warehouse.
    • Migrated entire Informatica code base from version 7 to version 8.1 which involved lengthy phased implementation and extensive regression testing.
    • Delivered ETL components for new pan-European Data Warehouse, consolidated from 10 data warehouses. This involved business requirements gathering and utilising Oracle's partition exchange feature for fast loading of high volume data.
    • Designed and developed star schema for Informatica metadata to enhance reporting on workflow structures and load times.
  • Earlier history +

    • Aug 2003 to Nov 2004: Cisco Systems, London: ETL Consultant (perm)
    • Apr 2003 to Jul 2003: Identex Marketing, Bristol: Informatica SME (contract)
    • Jun 2002 to Sep 2002: Pacific Micro Marketing, Melbourne: Informatica SME (contract)
    • Dec 2000 to May 2002: RCMS Ltd, London: ETL Consultant (perm)
    • Sep 1998 to Dec 2000: Logica, London: Graduate Consultant (perm)
  • 1

Testimonials

  • I had numerous interactions with Jon during our time at Logica. He was always a pleasure to work with and proved himself particularly proficient in the use of a software tool, Informatica, that was thrust upon him.He has gone into to become a recognised expert in his field and to this day he is still the person that I go to when I am researching Informatica in the BI space as he has great thought leadership in this area.

    Jamie Thomson

  • I worked with Jon for almost two years and I found him to be a very conscientious and dependable member of the team. With Jon I could rest assured that the task will get done on time with the quality desired without any stress. With his expert ETL skills and can-do attitude he has been able to tackle may complex data movement scenarios. He got on very well with the team and has made significant contributions to standardizing code

    Dionisa Joseph Mattam, Barclays Direct

  • I have worked with Jon in both development and service management roles for a number of years. In a nutshell, I have nothing but praise for Jon. He has many positive attributes which are, but not limited to: - Great technical skills- Ability to attain new skills rapidly and efficiently- Very meticulous, methodical, and logical in executing his work- Has a very pleasant character and the ability to operate at many levels- Very articulate and efficient communicator- Can do attitude  

    Reza Maziat (Carphone Warehouse)

  • Jon joined ING Direct at a time when the Information Management department was expanding and the number of information marts and ETL jobs run against the Data Warehouse were growing quite quickly. Thanks to his very strong ETL and Oracle skills the team were able to keep on top of these changes and keep delivering the reports the business needed on a daily basis.

    Jeremy Parker, ING Direct

  • Jon worked on several of my projects at Carphone in particular a difficult one integrating with 3rd party software. He was a key member of the team and was well respected by his peers. He developed a good project relationship with all of his key stakeholders and was equally comfortable talking to his technical colleagues as well as to non-technical/business colleagues.I would welcome the opportunity to work with him again

    Mark Lane, Carphone Warehouse

  • 1
  • 2
  • 3
  • 4
  • 5