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
Similar Profiles
Sofia WadsworthSofia Wadsworth
Student Annual Giving Engagement Officer at Azusa Pacific University Office of AdvancementStudent Annual Giving Engagement Officer at Azusa Pacific University Office of Advancement
Moira PerroneMoira Perrone
Phonathon Associate at Marist University Office of AdvancementPhonathon Associate at Marist University Office of Advancement
HAFSA SHAFIQ AHMADHAFSA SHAFIQ AHMAD
MANAGER CORPORATE RELATIONS at UNIVERSITY ADVANCEMENT OFFICE | NUSTMANAGER CORPORATE RELATIONS at UNIVERSITY ADVANCEMENT OFFICE | NUST
Alyssa BowlesAlyssa Bowles
Server at The Shady Restaurant and PubServer at The Shady Restaurant and Pub
Leo OuelletLeo Ouellet
Certified Technician at Great Canadian Oil ChangeCertified Technician at Great Canadian Oil Change