Welcome to VisiActive
Frank Daly SQL Developer / Analyst
visiactive.com frankdaly.com email@example.com +353-87-2227226
Hi, I'm Frank Daly and VisiActive is my IT Consultancy contracting company.
I am a SQL Developer / Analyst with 20 years technical and business experience including: Business Intelligence 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, 2008 R2, 2012), SSIS, SSRS, SSAS, C#, VB.net, and ASP.Net, for BI and MI projects mostly in the financial services industry. Recent Highlights include:
GodleyWood - Design and development of a BI financial and marketing reporting system and data warehouse using SQL Server 2012, SSIS, SSRS and c#.
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
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
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 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: (1) Development of ETL packages to move telephony data from Avaya systems and integrate with collections reporting. (2) Extraction of Conduct Risk information and the development of a reporting dashboard. (3) Migration of mortgage forbearance data into a SQL Server data layer and reporting layer with summary charts and drill down to detailed reports. (4) 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.
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)
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.
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
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.
The key skills which I have brought to all these projects include:
- Understanding the business and technical requirements and creating Business Requirements Documents and Functional Specifications
- Design and Development of database and application solutions for MI and BI projects.
This is a chronological list of projects which I've worked on:
Aug 2013 to Date
GodleyWood - SQL Developer / Analyst (Contract)
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
Jan 2013 to July 2013
PTSB Bank - SQL Developer / Analyst (Contract)
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
Sep 2011 to Dec 2012
Certus (financial services provider) - SQL Developer / Analyst (Contract)
Database Design, ETL package design / development using SSIS and SSRS development
￼￼￼￼March 2011 to Aug 2011
Irish Medicines Board (System Dynamics contract) - SQL / .Net Analyst / Developer (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.
Aug 2010 to March 2011
IBRC Bank - SQL / .Net Analyst / Developer (contract)
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.
June 2010 to Aug 2010
IVI (System Dynamics contract) - SQL / .Net Analyst / Developer (contract)
Analysis, design and development of business information and reporting application using c#, ASP.Net, SQL Server 2008 and SSRS
Feb 2010 to May 2010
Technology Research Independent Living (TRIL) - SQL / .Net Analyst / Developer (contract)
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)
Dec 2009 to Jan 2010
National Standards Authority - SQL / .Net Analyst / Developer (contract)
Analysis, Design and Development of a web-based Logistics application, using SQL Server 2005, ASP.Net, c# and SSRS
May 2009 to Nov 2009
VisiActive - IT Consultant (Contract)
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.
Feb 2009 to April 2009
VisiActive - Project Manager (Contract)
Directing / Producing documentary on professional photographers
Jan 2009 to Feb 2009
VisiActive - Business Analyst (Contract)
Forensic Analysis and Reporting on a set of websites for a legal case
June 2008 to Dec 2008
RTE: TV Broadcaster - SQL Developer / Analyst (contract)
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.
May 2007 to May 2008
Canada Life - Business Analyst / Developer (Contract)
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.
Jan 2007 to April 2007
VisiActive - Project Manager (Contract)
Directing / Producing documentary on social media business and usage.
May 2006 to Dec 2006
Bank of Scotland, Ireland - SQL / .Net Analyst / Developer (contract)
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.
Sep 1995 to Apr 2006
Intel Ireland - Analyst / Developer (multiple contracts)
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#)
Jan 1999 to Apr 2004
Bank of America / Fleet Bank - Analyst / Developer (contract)
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)
Jan 1994 to April 1995
Digital Equipment Corporation - Analyst / Developer (contract)
Analysis and development of a financial collection and reconciliation system.
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)
Full Skills List
My main interests are: Photography, Art and Video ( click this link to bring you to my portfolio site FrankDaly.com ). I'm also interested in travel, reading, writing, cycling and walking.
Technology and Imagination, Right Here, Right Now