SQL
Darren McCann
Data Analyst
Dundalk
Summary
Seasoned Business Intelligence Analyst offering years of Health, Insurance Investments and Retail experience. Expert on business and systems requirements and in-depth data analysis.
Personally dedicated to self-improvement with a passion for learning through experience and formal education.
Overview
19
19
years of professional experience
9
9
years of post-secondary education
2
2
Certifications
Work History
Data & Analytics Specialist (Contract)
Aer Lingus
12.2023 - Current
- Provide analytical and data solutions support to Operations Change and Transformation team.
- Liaise with legacy data system providers to establish possible opportunities for streamlined data ingestion.
- Development and continuous improvement of weekly KPI tracker for COO.
- Support change initiatives through the provision of objective analysis of business activity and change impact.
- Reduction of manual intervention in reporting through automation by utilizing tools such as SQL, VBA, Python, Tableau and Alteryx.
- Developed custom dashboards in Tableau for real-time tracking of key performance metrics across departments.
- Ensured accuracy and consistency in data reporting by implementing rigorous quality control measures.
Lead Data Analyst
Our Lady of Lourdes Hospital, Health Service Executive
3 2022 - 12.2023
- Provided in-depth analysis on Patient Profiles, Presentations, Admissions/Discharges, Clinic Attendances.
- Examination of Outpatient Clinic 'Did Not Attend' and Emergency Dept. 'Did Not Wait' populations to determine individuals at higher risk of breach.
- Use of statistical forecasting techniques to determine seasonal demand and make projections on expected Waiting List activity for resource planning.
- Use of Power BI to create repeatable KPI metrics for Monthly Performance Reporting
- Provide end users with bespoke solutions utilising the Patient Management Database using SQL, VBA and Excel.
Business Intelligence & Data Analyst
BoyleSports
04.2021 - 02.2022
- Developed sustainable intelligence-sharing dashboards using Tableau, providing company-wide access to collected data.
- Use of statistical package 'R' to conduct customer profiling and analyze behaviors such as Churn/Retention rates, Account Re-activation, Cross-Selling (Sportsbook to Gaming) and monitor patterns of play.
- Used historical business data to make informed projections on future performance and calculate potential campaign costings.
- Designed customized data collection models for promotional fulfillment and analysis.
- Provide periodical analysis and data insights to track business KPI's along with ad-hoc goal and problem specific analysis.
Business Systems Analyst - Team Leader
Utmost
08.2009 - 04.2021
- Modelling of Business processes for efficiencies using service orchestration tool Enate. Drafting of Functional Specifications for system based solutions.
- Management of Bloomberg security data ETL interface to core systems.
- Creation of Business Requirement Documents for submission to 3rd Party Developers.
- Oversight of business critical Financial Information Exchange (FIX) messaging between core system, Bloomberg and Stock Brokers.
Senior Fund Accountant
HSBC Security Services (Ireland)
09.2005 - 04.2008
- NAV Calculation for a variety of Funds incorporating a vast array of complex financial instruments.
- Processing Share dealing, Daily Trades, Expenses, Fixed term deposit Interest & FX Settlements
Education
Postgraduate Diploma - Applied Data Science
Dundalk Institute of Technology
Dundalk,Ireland 04.2001 -
Higher Diploma in Science - Data Analytics
Dundalk Institute Of Technology
Dundalk,Louth 09.2018 - 07.2020
Bachelor of Arts - Business Studies
Dublin City University
Dublin 09.2001 - 09.2005
Professional Diploma - Financial Advice (QFA)
UCD/Institute Of Bankers
Dublin 09.2008 - 07.2011
QQI Level 6 - Managing People
Health Management Institute of Ireland
Beaumont Hospital, Dublin 09.2022 - 12.2022
Skills
Data Analysis
Predictive Modeling
Hypothesis Testing
SQL and Databases
Problem Resolution
Business Process Mapping
Accomplishments
- Analysis and remodel of Bloomberg data requests which will produce significant cost savings (€100k+ Per Annum) to the business.
- Creation and configuration of trade data import workflows on Illumas reducing input times of large volumes of trades into system by automated data feed.
- Developed live National Waiting List reporting for OLOL Hospital allowing for instant anytime access to National list which was previously published once weekly.
- Awarded scholarship to DKIT PhD/Masters Track
Software
R
Python
Tableau
Power BI
Excel
Certification
ITIL Certification
Interests
Blogging - Awarded 2018 Irish Sports Blog Award
Competitive Racing Cyclist
Guitar
Referees
Fiona Floyd
Business Manager
Our Lady of Lourdes Hospital, Drogheda, Co. Louth
Fiona.Floyd@HSE.ie
-
Dr. Kevin McDaid
Lecturer Computer Sciences
Dundalk Institute of Technology
Kevin.McDaid@dkit.ie
Timeline
Data & Analytics Specialist (Contract)
Aer Lingus
12.2023 - Current
QQI Level 6 - Managing People
Health Management Institute of Ireland
09.2022 - 12.2022
Business Intelligence & Data Analyst
BoyleSports
04.2021 - 02.2022
Higher Diploma in Science - Data Analytics
Dundalk Institute Of Technology
09.2018 - 07.2020
ITIL Certification
05-2018
ISTQB Certified Tester
05-2017
Business Systems Analyst - Team Leader
Utmost
08.2009 - 04.2021
Professional Diploma - Financial Advice (QFA)
UCD/Institute Of Bankers
09.2008 - 07.2011
Senior Fund Accountant
HSBC Security Services (Ireland)
09.2005 - 04.2008
Bachelor of Arts - Business Studies
Dublin City University
09.2001 - 09.2005
Postgraduate Diploma - Applied Data Science
Dundalk Institute of Technology
04.2001 -
Lead Data Analyst
Our Lady of Lourdes Hospital, Health Service Executive
3 2022 - 12.2023
Similar Profiles
ANA BELEN POSTIGOANA BELEN POSTIGO
Airline Pilot at AER LINGUSAirline Pilot at AER LINGUS
Chris MossChris Moss
Senior Cabin Crew Member at Emerald Airlines UK -Aer Lingus RegionalSenior Cabin Crew Member at Emerald Airlines UK -Aer Lingus Regional
Valerie LavinoValerie Lavino
Airline Reservation Agent at Aer LingusAirline Reservation Agent at Aer Lingus