Zachary O'Donnell

Senior Commercial Analytics & Business Intelligence Analyst

hello@zachodonnell.me · South Hadley, Massachusetts

Summary

I turn pricing, marketing, product, and operational data into decisions that grow revenue, improve profitability, and reduce manual work.

Experience

Independent Product and Analytics Projects

Independent Product Builder | Remote

January 2026–Present

Build and operate League Island, owning the product roadmap, subscription workflows, third-party integrations, customer-support processes, technical documentation, and product analytics for a league-management SaaS product.

Rug Pad USA

Business Analyst II | Suffield, CT

October 2022–January 2026

Owned analytics and strategy for $5M+ in annual Amazon advertising spend supporting a $50M+ e-commerce business; reduced ACOS from 16%+ to 14.5% while increasing net sales.
Led pricing and profitability initiatives that increased net sales approximately 25% in one year despite approximately 15% lower unit volume; developed pricing hypotheses, secured approval, executed changes, and measured results across channels.
Led a six-month advertising transformation using Amazon Marketing Stream data, controlled tests, and an automated Python bidding system with SKU-level profitability guardrails, reducing manual optimization work by approximately 60-80%.
Planned a phased migration from 5,000+ advertising campaigns to fewer than 1,000, improving product coverage and reporting consistency while enabling reallocation of a full-time campaign-management resource.
Built centralized analytics infrastructure and hourly ETL/API pipelines integrating Amazon, Shopify, ChannelAdvisor, and other channels and processing millions of data points daily.
Redesigned PostgreSQL structures, relationships, and indexing and developed reusable data models that reduced complex report generation from approximately 30 minutes to under one minute.
Owned the evolution of a COGS initiative from an Excel MVP to a production web application, coordinating finance, operations, ownership, and developers to deliver true SKU-level profitability across approximately 3,000 standard and 800,000+ custom SKUs.
Built automated forecasts, KPI dashboards, and a weekly scorecard and led the weekly business review with company ownership and finance and operations leaders to surface risks, explain performance drivers, and prioritize actions.
Led a distribution-center site analysis by translating operational requirements and the shipping footprint into five data-backed recommendations; leadership selected a location that improved shipping costs and delivery times.

Connecticut APA

Business Analyst | Chicopee, MA

2020–2022

Independently led an automated 1099 solution from problem identification through requirements, build, testing, rollout, training, and performance monitoring, reducing manual tax-document preparation.
Designed and launched a team payment-management platform that replaced paper-based tracking with centralized digital records, improving visibility into outstanding balances and streamlining staff follow-up.
Developed and standardized operating processes, trained employees, and supported payroll, hiring administration, and day-to-day operations in a small-business environment.

CheckWriters

Business Analyst | Northampton, MA

2019–2020

Led cross-functional software feature delivery with leadership, legal, the software architect, and developers; translated business needs into user stories, wireframes, process maps, acceptance criteria, and Jira work.
Converted evolving state and legal requirements into sprint-ready plans for a COVID-era employee check-in feature and helped redesign complex payroll inputs into a guided experience.
Supported Agile delivery through requirements discovery, backlog development, sprint planning, prototyping, testing coordination, and documentation.

MassMutual

Operational Support Specialist | Springfield, MA

Business systems, reporting, and automation

2017–2019

Led an employee-scheduling automation initiative from process discovery and requirements through testing, implementation, training, and monitoring, replacing a recurring weekly process involving 2-3 employees.
Built Alteryx performance reporting that combined employee production and error-rate data, enabling management to identify trends and improve productivity and accuracy.
Developed internal web and workflow-automation tools using JavaScript, HTML, CSS, and Alteryx, including automated ticket generation for an employee-recognition program.
Created operational analyses used by leadership to improve turnaround times and standardize productivity measurement while processing 6,000+ monthly requests at greater than 99% accuracy.

Education

University of Massachusetts Amherst — Bachelor of Science, Resource Economics (May 2017)

Skills

Commercial and marketing analytics: Pricing and profitability, E-commerce performance, Paid media optimization, Conversion analysis, Forecasting, Experimentation

Data and business intelligence: SQL, Python, PostgreSQL, dbt, ETL and API pipelines, Data modeling, Query optimization, Dashboard development

Platforms and visualization: Amazon Advertising, Amazon Marketing Stream, Shopify, ChannelAdvisor, pandas, NumPy, Plotly, Dash, Streamlit, Excel, Power BI — working knowledge, Tableau — working knowledge

Leadership and delivery: KPI design, Executive reporting, Stakeholder management, Requirements gathering, Agile, Jira, Process improvement

Download Resume