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
Sergio MazzucaSergio Mazzuca
Cabin Crew at Aer LingusCabin Crew at Aer Lingus
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