Mary Makhnyk

Senior BI Analyst at THEMIS SOLUTIONS INC. (2025-11 – Present)

Investigated errors and causes of variances for payment processing transactions, using SQL and Python to identify root causes and inform corrective action
Created and maintained Looker dashboards for Finance and Accounting to monitor performance and support executive and month-end reporting
Reviewed and submitted pull requests on GitHub for staging and intermediate data models, improving data reliability for downstream analytics
Troubleshot broken data linkages in executive dashboards with a 24-hour turnaround time to ensure decision-makers had timely, accurate insights

Freelance AI Workflow Consultant at Freelance (2025-06 – 2025-11)

Created customized AI workflows on N8N with JavaScript, prompt engineering, and API integrations to automate processes and remove redundant tasks
Translated small business requirements into AI-powered workflows that saved owners time and produced consistent, measurable outputs

Technical Business Analyst at INDIGO PARK CANADA (2024-09 – 2025-06)

Evaluated marketing programs and built data-driven business cases and recommendations for Sales Operations to improve performance and ROI
Visualized and assessed large data sets using Python (Matplotlib) in KNIME to identify trends and support executive decision-making
Investigated ETL issues and removed roadblocks to reduce dashboard errors and improve reliability of reporting
Led dynamic pricing strategy initiatives, including strategic price protections and promotional campaigns; contributed to a March Break campaign that achieved a 20% year-over-year revenue increase with no parking lot closures
Supported new product launches end-to-end using Agile methodology, from business case and data analysis to marketing recommendations and website UX tactics

Senior Business Insights Analyst – Sales Operations at SHOPIFY (2021-01 – 2024-08)

Performed regression analysis and statistical testing on sales and marketing campaigns to assess performance and set direction for Eloqua, ZoomInfo, and Partnerships teams
Produced executive and management reports highlighting trends, ROI, and resource gaps to inform strategy and planning
Served as first point of contact for a portfolio of sales accounts, identifying global account distribution patterns and recommending equitable redistribution to maximize sales coverage
Led ad hoc analyses on large datasets for executives, marketing, finance, and sales using Salesforce, Databricks, Mode, Hive, BigQuery, Google Sheets, and Data Studio
Investigated data pipelines across multiple systems to resolve data quality issues and ensure reliable reporting for senior stakeholders

Promo Reporting Analyst at CANADIAN TIRE (2019-03 – 2021-01)

Provided daily reports to approximately 200 executive and management users across multiple teams to support operational and promotional decisions
Built user-friendly, visually clear reports using Data Studio, Tableau, Power BI, SQL, and Excel/Access to analyze promotional performance and product lines

Financial Analyst at CANADIAN TIRE (2017-06 – 2019-02)

Built custom SQL queries to identify top variance drivers of provision reserves, reducing variance report time from 6 hours to 5 minutes
Used SQL to replicate warranty calculations at the product level, improving precision of financial analysis
Analyzed monthly financial statement variances and identified risks from missing cost center charges, proactively notifying departments to resolve issues before month-end close

About