Senior Consultant

• Jan 2023 - Present

Senior Consultant

• Aug 2015 - Jan 2023

I am really enthusiastic about anything relating to Cloud Technologies and specifically Snowflake. I have the Snow Pro Core certification (89% pass score) and I am currently shaping the Snowflake content of a BDP Cloud Practise. I am currently steering the Snowflake training of BDPs internal Consultants and have volunteered to help my current client, a large household name bank, train Snowflake concepts and techniques their permanent and consultant colleagues. I have commercial Snowflake experience with a Household name insurer leading a Snowflake design and development team of five. The objective was to construct a Proof of Concept, and then a solution that enabled automatic hourly shredding XML data into their Warehouse from a staging area. I also co-authored and lead a weekly live broadcast to the client’s entire IT and technical teams to showcase progress of the shredding project. This described issues we found and their resolution, etc. and also how Snowflake could be used across the company highlighting many of the unique features such as elastic compute. For my current client I am currently co-developing a non-Snowflake engine that generates Transaction analysis. I will be instrumental in the conversion of this engine to Snowflake later this year when complete.

Senior Consultant

• Aug 2015 - Aug 2017

Senior Financial Services BI Consultant currently engaged on project with a major on-line retailer. The objective is to design and construct a repeatable data ingestion and quality assurance process for a Data Lake project. Previously worked on 3 assignments over a 13 month period for the a High Street bank using the Teradata tool set in conjunction with SAS EG. Senior Financial Services BI Consultant currently engaged on project with a major on-line retailer. The objective is to design and construct a repeatable data ingestion and quality assurance process for a Data Lake project. Previously worked on 3 assignments over a 13 month period for the a High Street bank using the Teradata tool set in conjunction with SAS EG.

BI Consultant

• Oct 2012 - Aug 2015

Working on client-sites of major Financial Services Organisations to implement various BI solutions using a range of tools including Teradata, Oracle, Cognos (Reports Studio version 10.1), Excel and Excel VBA. Working on client-sites of major Financial Services Organisations to implement various BI solutions using a range of tools including Teradata, Oracle, Cognos (Reports Studio version 10.1), Excel and Excel VBA.

Business Intelligence Analyst

• May 2003 - Oct 2012

All technical and business aspects for all stages of the life-cycle for BI and MI solutions developed using Cognos and Teradata All technical and business aspects for all stages of the life-cycle for BI and MI solutions developed using Cognos and Teradata

Consultant - Technical Specailist

• May 2001 - May 2003

Role divided between Oracle Datawarehousing Development and reporting and maintenance of a Legacy IBM Cobol/DB2 system (WIPS) Oracle Reporting and Data Warehouse:- Centred on Oracle Enterprise Data Warehouse feed by 11i Financials system, Concurrent Manger, SQL, PL/SQL (Toad, DBPartner), SQL Loader, Telnet/FTP, Unix scripts. Discoverer 4 Desktop and viewer, PVCS. Role divided between Oracle Datawarehousing Development and reporting and maintenance of a Legacy IBM Cobol/DB2 system (WIPS) Oracle Reporting and Data Warehouse:- Centred on Oracle Enterprise Data Warehouse feed by 11i Financials system, Concurrent Manger, SQL, PL/SQL (Toad, DBPartner), SQL Loader, Telnet/FTP, Unix scripts. Discoverer 4 Desktop and viewer, PVCS.

Applications Project Manager

• Jun 1999 - Apr 2001

Applications Project Manager – Retail Supply Systems Responsible for the managing the relationship between the company and a third-party supplier with management responsibility for the development, support and maintenance of tills, back office hub, central and Warehousing systems for various Duty Free and Specialist Duty Paid airport shops. All applications were developed using Micro Focus Cobol on SCO UNIX Operating System. Applications Project Manager – Retail Supply Systems Responsible for the managing the relationship between the company and a third-party supplier with management responsibility for the development, support and maintenance of tills, back office hub, central and Warehousing systems for various Duty Free and Specialist Duty Paid airport shops. All applications were developed using Micro Focus Cobol on SCO UNIX Operating System.

Senior Analyst Programmer

• Nov 1996 - Oct 1998

Senior Analyst Programmer Back Office Banking and Payment and Reporting Systems. IBM Escala Mainframe, GCOS6 Operating System, COBOL Senior Analyst Programmer Back Office Banking and Payment and Reporting Systems. IBM Escala Mainframe, GCOS6 Operating System, COBOL

Senior Analyst/Programmer (PO2)

• Jun 1986 - Nov 1996

Business Analyst - SSADM V4 Analysis and Design, SSADM SE Engineer CASE tool. Developer - Honeywell Bull DPS695, GCOS6 Cobol, SSADM Version 3, Excel Macro Language Business Analyst - SSADM V4 Analysis and Design, SSADM SE Engineer CASE tool. Developer - Honeywell Bull DPS695, GCOS6 Cobol, SSADM Version 3, Excel Macro Language