Data Migration Specialist

• Apr 2018 - Present

SQL / BI Developer (Contract)

• Jun 2016 - Dec 2017

BI Developer (Contract)

• Aug 2013 - Jun 2016

Business Domain: Banking Role/Responsibilities : Develop and deliver an ETL solution & data warehouse using SQL Server & SSIS to support an interim tactical MI project. Develop and deliver an ETL solution to support the monthly creation/verification of the MR1 regulatory return to the central bank of Ireland. Business Domain: Banking Role/Responsibilities : Develop and deliver an ETL solution & data warehouse using SQL Server & SSIS to support an interim tactical MI project. Develop and deliver an ETL solution to support the monthly creation/verification of the MR1 regulatory return to the central bank of Ireland.

Database / BI Developer (Contract)

• Jan 2010 - Aug 2013

Business Domain: Banking Role/Responsibilities : Develop and deliver an ETL solution to support the monthly creation/verification of a series of regulatory returns to the central bank of Ireland & FSA. (RS1 / CRS2) Develop and deliver a generic import mechanism that could be rolled out to any MS SQL Server database application to facilitate the scheduled and/or triggered import of data from a variety of source containers along with an outcome notification process. Business Domain: Banking Role/Responsibilities : Develop and deliver an ETL solution to support the monthly creation/verification of a series of regulatory returns to the central bank of Ireland & FSA. (RS1 / CRS2) Develop and deliver a generic import mechanism that could be rolled out to any MS SQL Server database application to facilitate the scheduled and/or triggered import of data from a variety of source containers along with an outcome notification process.

ETL Developer (Contract)

• Jun 2009 - Dec 2009

Business Domain: Energy Role/Responsibilities : Develop and deliver an ETL solution using SSIS to support the migration of data from legacy systems to Sage ERP. Business Domain: Energy Role/Responsibilities : Develop and deliver an ETL solution using SSIS to support the migration of data from legacy systems to Sage ERP.

Database / ETL Developer (Contract)

• Aug 2007 - Dec 2008

Business Domain: Banking Role/Responsibilities : Develop and deliver an application to support the management of exposures and collateral. (SQL 2005/VB6/Crystal Reports) Develop and deliver an ETL solution using SSIS to support the 'Basel II' banking accord. (SQL 2005/SSIS) Develop and deliver data consolidation solution using SSIS to create warehouse of external data feeds for daily reporting. (SQL 2005/SSIS) Business Domain: Banking Role/Responsibilities : Develop and deliver an application to support the management of exposures and collateral. (SQL 2005/VB6/Crystal Reports) Develop and deliver an ETL solution using SSIS to support the 'Basel II' banking accord. (SQL 2005/SSIS) Develop and deliver data consolidation solution using SSIS to create warehouse of external data feeds for daily reporting. (SQL 2005/SSIS)

Database / Reports Developer (Contract)

• Feb 2007 - Jul 2007

Business Domain: Social Care Case Management Systems (UK & ROI) Role/Responsibilities : Develop and deliver a new suite of reports for regional UK social services departments using SQL Server 2000, DTS and Reporting Services. Business Domain: Social Care Case Management Systems (UK & ROI) Role/Responsibilities : Develop and deliver a new suite of reports for regional UK social services departments using SQL Server 2000, DTS and Reporting Services.

SQL Analyst / Developer (Contract)

• Jul 2006 - Jan 2007

Business Domain: Insurance Role/Responsibilities : Using Sybase T-SQL to design, develop, maintain and support numerous backend applications. Business Domain: Insurance Role/Responsibilities : Using Sybase T-SQL to design, develop, maintain and support numerous backend applications.

ETL Developer (Contract)

• Jan 2006 - Jun 2006

Business Domain: Regional Business Solutions Role/Responsibilities : The primary SQL developer within a development team of eight. Extensive development of backend ETL functionality using the new ‘SSIS’ technology within the newly released MS SQL Server 2005. Business Domain: Regional Business Solutions Role/Responsibilities : The primary SQL developer within a development team of eight. Extensive development of backend ETL functionality using the new ‘SSIS’ technology within the newly released MS SQL Server 2005.

SQL / DTS Developer (Contract)

• Aug 2005 - Jan 2006

Business Domain: Varied (Bespoke solutions) Role/Responsibilities : Solely responsible for the development and implementation of complex ETL migration layer from an excessively de-normalized legacy database to a SQL Server OLTP database. In addition to the initial migration I had the responsibility of developing and implementing a series of synchronization packages to maintain daily synchronization of the two systems during the parallel deployment of the project’s pilot phase. Business Domain: Varied (Bespoke solutions) Role/Responsibilities : Solely responsible for the development and implementation of complex ETL migration layer from an excessively de-normalized legacy database to a SQL Server OLTP database. In addition to the initial migration I had the responsibility of developing and implementing a series of synchronization packages to maintain daily synchronization of the two systems during the parallel deployment of the project’s pilot phase.

Project Developer (Permanent)

• Aug 2000 - Aug 2005

Business Domain: Pharmaceutical (ETMS, Data Warehousing) CSL specialise in providing sales and marketing information systems, including data warehousing, data analysis, and data distribution to the pharmaceutical industry. Role/Responsibilities : Design, develop, maintain and support both tailored ETMS and Sales Force Automation solutions for a number of major external clients in the pharmaceutical industry. Business Domain: Pharmaceutical (ETMS, Data Warehousing) CSL specialise in providing sales and marketing information systems, including data warehousing, data analysis, and data distribution to the pharmaceutical industry. Role/Responsibilities : Design, develop, maintain and support both tailored ETMS and Sales Force Automation solutions for a number of major external clients in the pharmaceutical industry.

Analyst/Programmer (Permanent)

• Aug 1999 - Aug 2000

Business Domain: Business Directories (MIS, Call Centre, Workflow) Role/Responsibilities : Design, develop, enhance, maintain and support many new and existing business systems, including Order Processing, General Ledger, and Ad Manufacture. Business Domain: Business Directories (MIS, Call Centre, Workflow) Role/Responsibilities : Design, develop, enhance, maintain and support many new and existing business systems, including Order Processing, General Ledger, and Ad Manufacture.

Analyst/Programmer (Permanent)

• Jun 1998 - Aug 1999

Business Domain: Insurance (MIS, Product Servicing, Workflow) Role/Responsibilities : Develop, enhance, maintain and support a number of business sub-systems. Within a team I shared responsibility for 4 distinct areas of functionality, Premium Collection, Indexation, Arrears and Plan Servicing. In each of these areas the responsibility encompassed both client applications and server side objects. Business Domain: Insurance (MIS, Product Servicing, Workflow) Role/Responsibilities : Develop, enhance, maintain and support a number of business sub-systems. Within a team I shared responsibility for 4 distinct areas of functionality, Premium Collection, Indexation, Arrears and Plan Servicing. In each of these areas the responsibility encompassed both client applications and server side objects.

Analyst/Programmer (Permanent)

• Apr 1997 - Jun 1998

Business Domain: Consultancy (Varied) Role/Responsibilities : Develop, enhance, maintain and support systems for many external clients (Aer Lingus, RTE, Eagle Star) using both Microsoft technologies and supplied in-house tools. Business Domain: Consultancy (Varied) Role/Responsibilities : Develop, enhance, maintain and support systems for many external clients (Aer Lingus, RTE, Eagle Star) using both Microsoft technologies and supplied in-house tools.

Software Engineer (Permanent)

• Oct 1990 - Apr 1997

Business Domain: Hydrographic Survey (Data Capture / Analysis) Role/Responsibilities : Design, develop, and implement a range of hydrographic survey solutions for major clients in the global oil and gas industry. Business Domain: Hydrographic Survey (Data Capture / Analysis) Role/Responsibilities : Design, develop, and implement a range of hydrographic survey solutions for major clients in the global oil and gas industry.