David Finnegan

Experience

• 

  HSBC

  Jan 1996 - Jan 2001

  Database Developer
• 

  N-Tier Securities Development Studio

  Sept 2002 - Apr 2008

  Head of Technology

  Initially as Senior Database Developer, for small statup software company specialising in the design and delivery customized Corporate Actions & Securities Settlement solutions. Support and re-engineering of existing systems. Development using SQL Server 2000/2007, SSIS/DTS and PowerbuilderDesigned new corporate actions processing databaseRan a project to research and develop the production of financial data feeds using SQL Server and SSIS, in conjunction with the Google Search Appliance, and Google Applications. This was done successfully done with a preview launched at Swift Sibos 2007. Successful development of new data feed technology using a combination of new technologies (MS SQL Server 2005, SSIS, SSRS, C#, Google Search Appliance, XML, RSS). Successful SQL Server database and system upgrades. SQL Server 7.0 to 2000, and SQL Server 2000 to 2005.Company became a Google Enterprise Partner and I certified as Google Enterprise ProfessionalManagement of small offshore development team in Romania, who were employed to provide Oracle version of software, and basically provide additional support Show less

• 

  Anglo Irish Bank

  Nov 2008 - Jun 2009

  Contract Senior Database Specialist

  Worked as contract Senior Database Developer on Basel II Data warehouse project for the Business Solutions division of Anglo. Developed SSIS packages to load and scrub data from a variety of data sources and the transformation of this data from flat denormalised, to a more normalised structure with business keys. Ultimately transformed to a Kimball style star schema structures closely aligned to the fact/dimension structure required by SAS. Developed and implemented staging database in preparation for loading into SAS BI application. Project reached a successful conclusion at the end of May 2009. Show less

• 

  Bank of Scotland Ireland

  Jul 2009 - Dec 2010

  Senior SQL Database Specialist

  Working as contract SQL Server production providing DBA support and analysis role, providing expertise on system tuning and performance, and assistance with on going system development and enhancements. Developed various SSRS Reports and SSIS packages, and provided lead on development performance and best practices.

• 

  IBM Global Business Services

  Jan 2011 - Oct 2016

  SQL Server Database Specialist & Tech Team Lead

  Working as a Tech Team Lead with SQL Server and SME Specialities within the IBM Global Business Services team working on the Bank of Scotland account. I had responsibility for the technical delivery of primarily SQL Server database projects from initial requirements and impact analysis to test and delivery, in a formal and structured environment. I provided expert SQL Server knowledge with particular strengths in database design and architecture, data design and analysis, SSIS ETL development and SQL Server Reporting Services (SSRS).I also provided expert SME knowledge on systems such as Fico DebtManager, document management system SoftCo, Swift, and the core banking systemsRecent successful projects of note:1. Development of SSIS packages to archive and apply data retention to the DebtManager application and related systems2. Design and Development of an ETL and archiving framework to be used for complete archiving of a bank. This involved considerable work with SSIS and the development of standard SSIS packages to be re-used by a team of developers.3. Development of a Consolidated Customer Master Data Store - to use for data archiving and data retentionThe delivery of these most recent projects was described and "Phenomenal" and 'Epic" by the client in the UK, and acknowledged as such by the head of IBM Ireland. Other projects of note.1. Major Data Migration and Extraction Projects using SQL Server, SSIS and SSRS to support the Band of Scotland divestment program2. Implementation of Central Bank Code of Conduct for Mortgage Arrears (CCMA)3. Development of Liquidity Reporting System - SQL Server Reporting Systems4. Various system , application datawarehouse upgrade projects.5. Data design and analysis support Show less

• 

  AIB

  Mar 2017 - now

  Snr Financial Data Engineer & Analyst

  Currently, Snr Finance Data consultant working on the banks multi billion euro banking deleveraging projects. Also recently completed large Finance EDW project to onboard & integrate a large numbers of accounts purchased by the bank into their financial systems.- Previous worked on witholding taxation FATCA/CRS projects- Lead consultant on developing DQ systems to support the implementation of Basel directive BCBS239 principles for effective risk data aggregation & risk reporting- Lead consultant on organisation wide project to remediate critical data in core systems and EDW- Technical SQL Lead contractor in the Business Analytics team in AIB on IFRS9 (International Financial Reporting Standards) banking project. My role was to provide expert SQL consultancy and to lead the QA of the MI stream of the project. Show less