Alexandre Wood
Ottawa,ON
Summary
Talented professional passionate about data analysis and programming, seeking to leverage a strong business analysis and performance management background to grow as a data scientist. Experienced in evaluating program and policy performance, designing and producing business intelligence products, and managing programs. Proven ability to analyze complex data sets and synthesize information into actionable insights for stakeholders. Adept at working with cross-functional teams to provide business solutions and improve decision-making. Capable of analyzing complex business problems by leveraging deep experience in management roles and around senior audiences.
Overview
11
11
years of professional experience
Work History
Senior Data Analyst
Canadian Firearms Program
01.2025 - Current
- Collaborated with stakeholders to identify business needs and data sources.
- Updated and developed scripts and queries in Oracle SQL and COGNOS Analytics to extract and analyze data from multiple sources.
- Analyzed large amounts of data to identify trends and find patterns, signals, and hidden stories within data.
- Developed customized reports and dashboards using Power BI, summarizing and presenting data in a visually appealing format.
- Built fully automated visualization solutions using VBA and Power Automate.
Senior Data Analyst, HR Analytics & Business Intelligence
RCMP
10.2023 - 01.2025
- Produced reporting and business intelligence products to assist decision-making across the organization using Cognos Analytics, Tableau, and Power BI
- Redesigned an Equity, Diversity, and Inclusion dashboard originally delivered by PriceWaterhouseCooper to power it with live data
- Participated in a horizontal initiative to centralize EE data storage and access led by Treasury Board Secretariat
Acting Deputy Director, HR Analytics & Business Intelligence
RCMP
01.2024 - 08.2024
- Managed a team of 7 employees responsible for the delivery of HR Analytics and Business Intelligence services to RCMP divisions and business lines
- Stabilized the unit's ad-hoc request service by leading the implementation of efficiency measures such as the use of canned reports, a report library, a prioritization matrix, and standardized processes
- Led the development of an organizational dashboard to provide Senior Management with insights on key HR indicators
- Oversaw the development of a statistical attrition forecast to provide input into other resourcing models from different parts of the organization
- Led key initiatives to implement data governance across HR, modernize the unit's pipeline and development environment, and restructure and resource the unit.
Senior Data Analyst, Anti-Racism Unit
RCMP
01.2022 - 10.2023
- Assisted with the development of a framework for the collection, analysis and disclosure of operational race-based data in PROS
- Coordinated work with PriceWaterhouseCooper to develop the Race-Based Data Collection (RBDC) Initiative critical path and identify dependencies between operational record management systems
- Managed administrative and HR processes required to set up and build the RBDC team
Manager, Equity, Diversity and Inclusion Unit
RCMP
03.2018 - 12.2021
- Managed a team of 7 employees responsible for delivering EDI programming in the RCMP
- Developed and launched the RCMP's first comprehensive Equity, Diversity, and Inclusion Strategy and led its implementation across Divisions
- Ensured the RCMP's compliance with Canadian diversity legislation by coordinating reporting, planning, and analysis activities across the organization
- Promoted diversity and inclusion in the RCMP by leading awareness and engagement activities like National Diveristy Week, Black History Month and Pride Month
- Authored the RCMP's Budget 2021 funding request which secured funding for anti-racism programming
Manager, Programs and Services, Technical Operations
RCMP
04.2017 - 03.2018
- Managed a team of 5 employees delivering services in strategic planning and performance management, facility management, and occupational health & safety to Technical Operations
- Led a thorough review of Technical Operation's internal support services and delivered a set of final recommendations to its Senior Management for implementation
- Led the implementation of business intelligence practices across Technical Operations
Executive Assistant to the CO of National Division
RCMP
01.2014 - 03.2017
- Managed a team of 9 employees providing executive, strategic planning, performance management, property security, honours & recognition, civil litigation, peer-to-peer support, and emergency planning services to the Division
- Advised the Division's Commanding Officer on sensitive operational and administrative issues
- Led the development and implementation of the Division's first Mental Health strategy and oversaw the roll-out of the Road 2 Mental Readiness training to all Division employees
Education
Bachelors - International Commerce
University of Ottawa
Ottawa05-2011
Skills
- Data processing and Machine Learning using Python libraries such as Pandas, NumPy, MatPlotLib, and SciKit-Learn
- Query development in SQL (Oracle, MySQL) and NoSQL (Mongo DB)
- Web Development in HTML/CSS/JS and in Wordpress
- Advanced Data manipulation in Excel
- Data Visualization in Power BI and Tableau
- Data modelling and report building in IBM Cognos Analytics
- End-to-end data processing using MS Fabric and Azure Databricks
- OCR using Python libraries like OpenCV-Python, Pillow, Pytesseract
- Prompt engineering with ChatGPT, Co-Pilot, Bard, Midjourney, and Dall-E
- Workflow automation using MS Power Automate and VBA
- Augmented research and writing using AI-augmented software such as Perplexity, Harpa AI, and Jasper AI
- Application of statistical modelling techniques and principals
Languages
French - EEE
Advanced (C1)
English - EEE
Advanced (C1)
Custom Section
Top-Secret clearance valid until 2029
Timeline
Senior Data Analyst
Canadian Firearms Program
01.2025 - Current
Acting Deputy Director, HR Analytics & Business Intelligence
RCMP
01.2024 - 08.2024
Senior Data Analyst, HR Analytics & Business Intelligence
RCMP
10.2023 - 01.2025
Senior Data Analyst, Anti-Racism Unit
RCMP
01.2022 - 10.2023
Manager, Equity, Diversity and Inclusion Unit
RCMP
03.2018 - 12.2021
Manager, Programs and Services, Technical Operations
RCMP
04.2017 - 03.2018
Executive Assistant to the CO of National Division
RCMP
01.2014 - 03.2017
Bachelors - International Commerce
University of Ottawa
Similar Profiles
Mel CyrMel Cyr
Interpreter Trainer & Supervisor - at Interpreter Internship Program, Canadian Hearing Services - ContractInterpreter Trainer & Supervisor - at Interpreter Internship Program, Canadian Hearing Services - Contract
Vina CurryVina Curry
Fingerprint Technician at SAFE Arizona Firearms EducationFingerprint Technician at SAFE Arizona Firearms Education
Sonya L. DyerSonya L. Dyer
Chief of Staff at Bureau of Alcohol, Tobacco, Firearms and ExplosiveChief of Staff at Bureau of Alcohol, Tobacco, Firearms and Explosive