Patrick Galloway
Kingston,ON
Summary
Dynamic Senior Analyst Lead with a proven track record at Queen's University, excelling in business intelligence and stakeholder communication. Spearheaded the development of over 40 interactive dashboards, enhancing fundraising performance analysis. Expert in SQL and data modeling, fostering a data-driven culture through effective training and collaboration across teams.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Senior Analyst Lead
Queen's University, Office of Advancement
11.2007 - Current
- Implemented business intelligence (BI) solutions to increase operational efficiency.
- Streamlined reporting capabilities with the creation of interactive dashboards and visualizations using Tableau and Tableau server.
- Built and maintained 100+ dynamic data sources to enable a decentralized, self-service BI environment.
- Designed and delivered 40+ interactive dashboards to analyze and monitor fundraising performance, including donations, prospect pipelines, proposals, stewardship activities, and constituent engagement.
- Designed customized data collection models for specific visualization tasks.
- Promoted a data-driven culture by training end-users on utilizing BI tools effectively for analysis and reporting purposes.
- Created data models to support decision-making processes.
- Consolidated multiple data sources into a centralized repository, improving data accessibility, consistency, and reliability across the organization.
- Effectively communicated complex data insights to stakeholders at all organizational levels, from executives to frontline staff, ensuring clarity and alignment.
- Utilized data visualization techniques to present and explain complex data sets.
- Managed project timelines effectively, ensuring timely delivery of high-quality BI solutions that met or exceeded stakeholder expectations.
- Facilitated cross-functional collaboration, gathering business requirements for customized BI solutions from various departments.
- Improved team efficiency by developing clear, user-friendly documentation for BI systems, workflows, and processes.
- Optimized data processing efficiency by designing and deploying ETL processes for data extraction, transformation, and loading.
- Assisted in database schema design, resulting in a scalable structure that supported future growth requirements efficiently.
- Developed, implemented and optimized stored procedures and functions using P-SQL and T-SQL.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs.
Senior Data Analyst
AmerisourceBergen Canada
01.2005 - 11.2007
- Led data team through three system conversions, defining data mapping requirements and migration strategies to integrate corporate data into a centralized data warehouse.
- Designed and implemented relational databases and ETL processes to consolidate disparate sources, improving data consistency and warehouse performance.
- Developed and maintained data dictionaries, stored procedures, functions, and views to optimize reporting and analytics capabilities.
- Administered BI servers and supported enterprise reporting for a $1.5B corporation, ensuring scalability and reliability of analytics solutions.
- Implemented data archiving and recovery strategies to safeguard warehouse integrity and support long-term reporting needs.
Education
Bachelor of Commerce - Information Systems
Carleton University
Ottawa06-2003
Skills
- Stakeholder communication
- Team collaboration and leadership
- Business intelligence
- SQL and databases
- Data analysis
- Data modeling
- Complex Problem-solving
- Performance monitoring
- Attention to detail
- Continuous improvement
- Project management
- Information gathering
Certification
Tableau Desktop Specialist
Timeline
Senior Analyst Lead
Queen's University, Office of Advancement
11.2007 - Current
Senior Data Analyst
AmerisourceBergen Canada
01.2005 - 11.2007
Bachelor of Commerce - Information Systems
Carleton University