Mary Makhnyk

I am a BI and strategy analyst with 7+ years in analytics across SaaS, sales operations, and finance. I build forecasting and performance models, dashboards, and KPIs using SQL, Python, Looker, Power BI, and Mode, and translate complex data into executive-ready insights. I lead cross-functional initiatives, troubleshoot data pipelines, and support enterprise decision-making with clear, actionable recommendations.

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

Bachelors of Commerce in Finance and Accounting – University of Toronto

Online Courses – Coursera