Projects & Articles
Project
Completed
Negative Inventory Dashboard
Automated negative inventory tracking to eliminate manual processes and accelerate month-end resolution timelines. Reduced reporting time by 96.7%, saving 8 hours monthly while enabling analysts to focus on high-value resolution activities.
View Project →Large Entries Inventory Analysis Model
Developing a Power BI report that identifies unusually large SAP entries using statistical analysis and dynamic thresholds, enabling more accurate detection of high-risk transactions and improving inventory data integrity.
View progress →Which Quarterback in the NFL has been the best ROI since 2021?
Analyzing NFL quarterback performance versus contract value from 2021-2024 using Python and pandas. Combining salary cap data with performance metrics to calculate ROI and reveal which QBs deliver the most value relative to their cost.
View progress →The Future of Financial Data Transformation in Oil & Gas
Why the industry's next competitive advantage lies in automated financial analytics and real-time decision-making. Exploring how Power Query and modern analytics tools are transforming traditional finance operations.
Coming soon →Power Query for Inventory Reconciliation: A Practical Guide
Step-by-step guide to automating inventory reconciliation processes using Power Query, including fuzzy matching techniques and variance analysis workflows for downstream operations.
Coming soon →Data Modeling in Power BI for Inventory Reconciliation: Simplified
Demystifying data modeling concepts for inventory reconciliation. Learn how to structure relationships between fact and dimension tables to create efficient, accurate reconciliation reports in Power BI.
Coming soon →Recent Experience
October 2023 - Present
Inventory Control Analyst, Hydrocarbon Inventory Control (HIC)
Suncor Energy | Calgary, AB
Driving automation initiatives that have reduced reporting time by 75% through Power BI dashboards for negative inventory monitoring and anomaly detection. Optimized inventory reconciliation processing by 50% using Power Query and automated SAP data extraction with Power Automate. Applied AI-assisted analysis to enhance variance analysis accuracy. Delivered training on Power BI and Power Query to build team digital capabilities while collaborating with Supply, Trading & Optimization and Operations teams to improve inventory reporting processes.
May 2022 - October 2023
Financial Analyst, Financial Planning & Analysis (FP&A)
Taiga Building Products Ltd. | Burnaby, BC
Transformed FP&A reporting by reducing monthly sales cycle time by 70% through Power Query and VBA automation. Built interactive Power BI dashboards for sales and inventory analysis used by regional branches. Reported KPIs to senior leadership, prepared trend analysis for annual budgeting, supported cloud system implementation, and developed market models for executive presentations and capital planning.
Get in Touch
GitHub
github.com/brandonmcmanusLocation
Calgary, AB, Canada