Welcome to VisiActive

Frank Daly,   Business Intelligence Consultant
visiactive.com   fxdaly@gmail.com   +353-87-2227226
Dublin and London

CLICK HERE TO DOWNLOAD PDF VERSION OF CV

Last updated: 25-07-2016


Business Intelligence / SQL Developer

Hi, I'm Frank Daly and VisiActive is my IT Consultancy contracting company. 

I am a Business Intelligence consultant with more than 20 years technical and business experience including: SQL development,  Database Architecture, SQL Server design and development (relational and star schema), Kimball Methodology, ETL package development, Business Analysis, Reporting and DBA using SQL Server (2005, 2008R2, 2012, 2014), SSIS, SSRS, SSAS, C#, VB.net, and ASP.Net, for BI and MI projects mostly in the financial services industry. Recent highlights include:

Capita Asset Services – Data warehouse design and development (SQL Server 2014) Team leading a business intelligence project (8 people), creating SSIS, SSRS and SQL procedures to deliver financial analysis and reporting for a set of clients. Project included business analysis, data warehouse design, data quality assessment, ETL packages, development of complex stored procedures, performance tuning, report development, and deployment.

Bank of America Merrill Lynch - Developments to international financial regulatory databases and implementation of Jenkins continuous integration development environment using SQL Server 2008, SSIS, SVN, Autosys, and Powershell.

GodleyWood - Design and development of a BI financial and marketing reporting system and data warehouse using SQL Server 2012, SSIS, and SSRS.

PTSB Bank - BI and ETL analysis, design and development for treasury data and liquidity asset liability management data warehouse project

Certus (financial services) – BI / MI Database Development, SSIS, SSRS projects
IVI Management Consultancy - ASP.net / SSRS dashboard and reporting project
IBRC Bank  - Financial BI and MI ETL and Reporting applications
Bank of Scotland (Ireland):  - Credit Risk Management ASP.Net application
RTE:  - SQL Server Data Migration / Microsoft Dynamics CRM


Project Skills Overview


My Top Skills Analysis


My Recent Projects

The critical competence which I have brought to all these projects is: 

  • Understanding and defining the business and technical requirements 
  • Design and development of database and application solutions for BI and MI projects.

Capita Asset Services (Contract)

Capita Asset Services manage loan books and provide other financial services to clients.
This project involved the following tasks:

  • Creating a set of relational databases and a data warehouse database using SQL Server 2014
  • Design and development  of ETL packages  to load the data from the source systems: T24 Financial management system, a property asset management system and PEGA customer relationship management system
  • Perform data quality analysis on source data
  • Create staging data and load daily and monthly tables
  • Load data warehouse fact and dimension tables
  • Develop SSRS reporting stored procedures and  RDLs
  • Create Datamarts for reporting
  • Tune database for performance

Bank of America Merrill Lynch (CONTRACT) 

The contract at Bank of America Merrill Lynch focused on developments and enhancements to databases and applications which are part of an international regulatory reporting system. This included:

  • Development of SSIS  package interfaces to Oracle, Teradata, SQL Server and other external systems
  • Defining business requirements and developing database tables, views, stored procedures and powershell code to implement the required functionality
  • Implementation of a continuous integration environment using Jenkins, Subversion,  Jira, Powershell, c# and Autosys to provide facilities for the development team (which is spread over multiple locations) to automatically build, test, and deploy database, ETL packages and Web components
  • SQL performance tuning
  • Migration of data from older systems

GodleyWood (Contract) 

At GodleyWood the project involved the analysis, design and development of scalable BI financial and marketing reporting databases (relational and star-schema data warehouse) and a suite of SSRS reports and SSIS ETL procedures. The project included the following components:

  • Financial and Marketing Dashboards, Business Metrics, User and transactional analysis reports
  • Charting, summary and drill down reports
  • Importing financial data from Apple iTunes, Paypal and Flurry Analytics 
  • Importing production, and transactional data from the company application databases
  • Processing and summarising data to produce data marts, summary and detailed data
  • Multi-currency financial reconciliation.  
  • Development of video and audio SSRS reports

PTSB (Contract) 

At PTSB I carried out analysis, design, and database / ETL package development to extract and transform data from legacy banking systems (Opics, Hogan, Unibanks) and automate the movement into a financial data warehouse used for regulatory reporting and liquidity risk management.

Certus (Contract) 

Certus provides financial services to Lloyds Banking Group in managing the loan book of the former Bank of Scotland (Ireland). I worked on four SQL projects for the Certus MI Department:  

  • Development of ETL packages to move telephony data from Avaya systems and integrate with collections reporting.
  • Extraction of Conduct Risk information and the development of a reporting dashboard.
  • Migration of mortgage forbearance data into a SQL Server data layer and reporting layer with summary charts and drill down to detailed reports.  
  • Development of ETL packages to extract data from a FICO Debt Manager system into a SQL Server Customer accounts and forbearance database for SSRS ad hoc queries, reporting and detailed evidencing extracts. 

IBRC Bank (Contract) 

At IBRC Bank I carried out analysis and migration of legacy data from treasury systems, corporate financial systems and a business intelligence data warehouse, cleansing the data, loading it into a staging database using SSIS ETL packages and reporting and extracting flat files and excel files for transmission to the National Asset Management Agency. 

Bank of Scotland Ireland (Contract) 

The project at Bank of Scotland (Ireland) was the development of a Basel II Credit Risk Management system using ASP.Net, C#, SQL Server and SSRS.

RTE (Contract) 

The project at RTE (TV Broadcaster) involved migration of data from more than 50 data sources, including Excel, XML, SQL Server, MS Access, CSV's, and proprietary   databases, into a staging database, where the data was matched, de-duplicated, cleansed, reported on, reviewed, and finally extracted into sets of related CSV files for loading into a Microsoft Dynamics CRM system. 

Innovation Value Institute (Contract) 

At Innovation Value Institute I carried out analysis, design and development of a dashboard with complex charting and drill down reports for a management consultancy project.

 

 

Key Skills

SQL Server

SSRS

SSIS

SSAS

Database Design

ETL

Reports Development

Kimball Methodology

Data Warehouse

C#

ASP.Net

PostgreSQL

Business Intelligence

Business Analysis

 

5 Year Timeline


Companies I've Worked for

I've worked on contracts for the following companies:

Project Details

This is a chronological list of projects which I've worked on.


SQL Developer / Team Leader (Contract)

Sep 2015 - Jun 2016
Capita Asset Services

Development of a data warehouse, ETL packages, stored procedures and reports for loan book analysis and reporting for Capitas client using SQL Server 2014, TFS, SSIS, SSRS, Powershell.


SQL Developer / Analyst (Contract)

Jul 2014 - May 2015
Bank of America Merrill Lynch

Developments to international financial regulatory databases and implementation of Jenkins continuous integration development environment using SQL Server 2008, SSIS, SVN, Autosys, and PowerShell.


SQL Developer / Analyst (Contract)

Aug 2013 - May 2014 
GodleyWood

Analysis, design and development of a BI financial and marketing reporting system using SQL Server 2012, SSIS, SSRS, PostgreSQL and c# for GodleyWood (WholeWorldBand,com) global music production company


SQL Developer / Analyst (Contract)

Jan 2013 - July 2013
PTSB Bank 

Database Design, ETL development (SSIS, stored procedures and c# modules) for extraction, transformation and loading a data warehouse for regulatory reporting and liquidity risk management


SQL Developer / Analyst (Contract)

Sep 2011 - Dec 2012
Certus (financial services provider)

Database Design, ETL package design / development using SSIS and SSRS development


SQL / .Net Analyst / Developer (contract)

Mar 2011 - Aug 2011
Irish Medicines Board (System Dynamics contract)

Design and development of enhancements to an Inspection and Licensing workflow system for Irish Medicines Board using ASP.Net, c# and SQL Server 2008, including web services interfaces to InfoPath, SharePoint Services, document management system and product databases.


SQL / .Net Analyst / Developer (contract)

Aug 2010 - Mar 2011
IBRC Bank

Analysis and development of ASP.Net Financial Reporting applications and the creation of SSIS ETL packages and extract stored procedures to provide information on Anglo Irish Bank's commercial loans and hedge funds to the National Asset Management Agency (NAMA). Also involved development of SSRS reports.


SQL / .Net Analyst / Developer (contract)

Jun 2010 - Aug 2010 IVI (System Dynamics contract)

Analysis, design and development of business information and reporting application using c#, ASP.Net, SQL Server 2008 and SSRS


SQL / .Net Analyst / Developer (contract)

Feb 2010 - May 2010
Technology Research Independent Living (TRIL)

Analysis, design and development of data capture and analysis applications for a clinical research project, including extensive use of SQL Server 2008, SSIS packages and Visual Studio 2008)


SQL / .Net Analyst / Developer (contract)

Dec 2009 - Jan 2010
National Standards Authority

Analysis, Design and Development of a web-based Logistics application, using SQL Server 2005, ASP.Net, c# and SSRS


IT Consultant (Contract)

May2009 -  Nov2009
VisiActive

IT Consultancy assignments providing development, training and support on Web Design, Database Design, Systems Analysis, Digital Media production and Business Social Media, for a number of companies including IntoPrint, Telcotec, Hi-Sales.


Project Manager (Contract)

Feb 2009 - Apr 2009
VisiActive

Directing / Producing documentary on professional photographers


Business Analyst (Contract)

Jan 2009 - Feb 2009
VisiActive

Forensic Analysis and Reporting on a set of websites for a legal case


SQL Developer / Analyst (contract)

Jun2008 - Dec2008
RTE: TV Broadcaster

Analysis and development of data migration for the implementation of a Customer Relationship Management system. This project also included extensive use of SQL Server and SSRS for the migration phase.


Business Analyst / Developer (Contract)

May2007 - May2008
Canada Life

Business analyst / developer leading a team of analysts and developers on the requirements definition and specification of two insurance broker portals. This project also involved the definition of an Information Architecture for the portals.


Project Manager (contract)

Jan 2007 - Apr 2007
VisiActive

Directing / Producing documentary on social media business and usage.


SQL / .Net Analyst / Developer (contract)

May2006 - Dec2006
Bank of Scotland,  
Ireland

Technical Lead on “Single Customer View” Retail Loans enhancement project and Basel II Credit Risk Management project. The Credit Risk project included documenting the full process of corporate lending.


Analyst / Developer (multiple contracts)

Sep 1995 - Apr 2006
Intel Ireland

Design and development of Innovation management system, Media Content Management peer-to-peer networking applications and cost management, analysis and reporting applications. (ASP.net and c#)



Analyst / Developer (contract)

Jan 1999 - Apr 2004
Bank of America / Fleet Bank

Systems Analysis and development of a web-based Small Business Credit system, Siebel Finance print integration and Marketing Campaign Management systems (overlap with Intel contracts)


Analyst / Developer (contract)

Jan 1994 - Apr 1995
Digital Equipment Corporation

Analysis and development of a financial collection and reconciliation system.


My Experience By Industry

Screen Shot 2014-05-26 at 15.09.30.png

Patents

Co-Inventor on Patent No: US 7440994 B2 
Method and Apparatus for Peer-To-Peer Services
This patent is for a design method using peer-to-peer services, to allow large media files to be moved around a global network in the most efficient manner. It was obtained while working for Intel Corporation and is assigned to them.

 

 

 


  
Education / Training 

Business and Technical Training Courses:  Project Management (Prince II Certified) , Business / Systems Analysis , Consulting Skills, Sales Training, Assertive Skills, Presentation Skills,  Database Design, Software Design, Business Intelligence development.
Trinity College Dublin:  Computer Science (Advanced Computer Programming)

 

Screen Shot 2014-05-26 at 15.07.30.png

Full Skills List 

Project Management, Business Analysis, Prince II, Software Management, Kimball Methodology, Technical Architect,.Net Development, Enterprise Architect, Software Consulting, Social Media Marketing tools,  UML, OOAD,  SSADM, Software Design, Web Application Development, Database Design, SQL Server, SSIS, SSRS, SSAS, ETL, JIRA, Oracle, MS-Access, C#.Net, VB.Net, ASP.Net, Active Server Pages, Java, JavaScript, PHP, MySQL, PostgreSQL, Microsoft CRM,  Content Management Systems, Photoshop, Lightroom, Final Cut Pro X, Sound Forge, Logic Pro, Flash, Video Production, Microsoft Windows, Mac OS/X, Ubuntu.


Interests

My main interests are: Writing, Photography, Art and Video ( Click this link to go to my Book and Portfolio site ). I'm also interested in travel, reading, cycling and walking.

Transient

Technology and Imagination, Right Here, Right Now

CLICK HERE TO DOWNLOAD PDF VERSION OF CV