Skip to content
Zach O'Donnell

Open to remote and MA/CT opportunities

Zachary O'Donnell

Senior Commercial Analytics & Business Intelligence

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

Portrait of Zachary O'Donnell

Selected impact

  • $50M+

    E-commerce business supported

  • $5M+

    Annual Amazon advertising spend analyzed

  • ~25%

    Growth in net sales in one year

  • 60–80%

    Reduction in manual optimization work

Case studies

Commercial problems, measured results

Each engagement is told from the business question through the decision and the outcome.

Pricing & Profitability Transformation

Used cross-channel pricing, cost, volume, and margin analysis to redesign pricing and profitability decisions across a $50M+ e-commerce business.

Business problem
Pricing and margin decisions were spread across channels, cost assumptions, and one-off analyses, so growth and profitability were hard to manage together.
Role
Led the analytical work and the decision support behind pricing, margin, and volume tradeoffs.
Scale
$50M+ e-commerce business; cross-channel price, cost, and volume analysis.
Result
Approximately 25% growth in net sales in one year, with approximately 15% lower unit volume, alongside better margins and a more efficient operation.
Read the Pricing & Profitability Transformation case study

Amazon Advertising Optimization & Automation

Analyzed and supported strategy for more than $5 million in annual Amazon advertising spend, then built the optimization system that made those decisions repeatable.

Business problem
A large Amazon advertising account was too fragmented to manage consistently, and default platform metrics were a weak guide to profit.
Role
Owned the analysis and the optimization workflow. Supported strategy for the account; I did not personally control the entire advertising budget.
Scale
More than $5M in annual Amazon advertising spend analyzed for a $50M+ e-commerce business. Campaign count moved from more than 5,000 to fewer than 1,000.
Result
ACOS improved from above 16% to 14.5% with higher net sales. Manual optimization work dropped by approximately 60–80%.
Read the Amazon Advertising Optimization & Automation case study

COGS & SKU Profitability Engine

Took an Excel MVP for product cost and turned it into a production application covering standard products and a very large custom catalog.

Business problem
Product cost lived in spreadsheets that could not represent a catalog of custom sizes, materials, and shapes.
Role
Partnered with business, operations, and technical stakeholders to design, iterate, and put the cost logic into production use.
Scale
About 3,000 standard SKUs and more than 800,000 custom SKU combinations.
Result
Teams could see cost and margin at a product level that a maintained spreadsheet could not cover.
Read the COGS & SKU Profitability Engine case study

Executive Scorecard & Forecasting

Built the weekly business review: shared KPIs, variance and trend context, and a forecast the leadership team could use to choose follow-up actions.

Business problem
Weekly reviews were spent assembling channel exports instead of deciding what to do.
Role
Defined the KPI set, the review narrative, and the forecasting view that leadership used to steer the business.
Scale
Weekly executive review across e-commerce channels for a $50M+ business, including sales, margin, and advertising context.
Result
A trusted weekly forum for performance, forecast, and the short list of actions that followed.
Read the Executive Scorecard & Forecasting case study

League Island

Independent league-management SaaS product

A product I own end to end: organizers run registration, competition, and communication in one place instead of a pile of spreadsheets and chat threads.

Business problem
League organizers were splitting registration, schedules, brackets, payments, and player communication across spreadsheets, chat, and one-off tools.
Role
Product owner and builder. I set the roadmap and turned organizer and player needs into product decisions.
Scale
Multi-tenant product used to operate leagues, with separate organizer and player workflows.
Result
A live product that covers the league lifecycle, not a demo of a single bracket screen.
Read the League Island case study

How I create value

Analysis that teams can act on

Commercial decision support

Pricing, profitability, advertising, forecasting, and performance analysis connected directly to business decisions.

Data products and automation

Reliable pipelines, analytical tools, dashboards, and automated workflows that reduce repetitive work.

Executive communication

Clear KPIs, business reviews, recommendations, and explanations tailored to technical and nontechnical audiences.

Cross-functional delivery

Experience working with leadership, finance, operations, product managers, legal partners, architects, and engineers.

Experience

Where the work happened

Independent Product and Analytics Projects

Independent Product Builder

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

October 2022–January 2026

  • Owned analytics and strategy for more than $5M in annual Amazon advertising spend supporting a $50M+ e-commerce business; helped reduce ACOS from more than 16% to 14.5% while increasing net sales.
  • Led pricing and profitability initiatives that helped produce approximately 25% growth in net sales in one year despite approximately 15% lower unit volume.
  • Built an automated Python bidding system and helped consolidate more than 5,000 campaigns to fewer than 1,000, reducing manual optimization work by approximately 60–80%.
  • Built ETL and API pipelines integrating Amazon, Shopify, ChannelAdvisor, and other channel data, and redesigned PostgreSQL reporting workflows that reduced some reports from approximately 30 minutes to under one minute.
  • Helped take a COGS initiative from an Excel MVP to a production application supporting approximately 3,000 standard SKUs and more than 800,000 custom SKU combinations.

Connecticut APA

Business Analyst

2020–2022

  • Independently led an automated 1099 solution through requirements, build, testing, rollout, training, and monitoring.
  • Designed and launched a team payment-management platform that replaced paper-based tracking with centralized digital records.
  • Standardized operating processes, trained employees, and improved administrative reliability and visibility.

CheckWriters

Business Analyst

2019–2020

  • Led cross-functional feature delivery with leadership, legal, the software architect, developers, and operations stakeholders.
  • Translated business needs into user stories, wireframes, process maps, acceptance criteria, and Jira work.
  • Supported Agile delivery and helped convert evolving COVID-era legal requirements into usable employee check-in and payroll workflows.

MassMutual

Operational Support Specialist

Business systems, reporting, and automation

2017–2019

  • Led an employee-scheduling automation initiative from process discovery and requirements through implementation, training, and monitoring.
  • Built Alteryx performance reporting and internal workflow tools using Alteryx, JavaScript, HTML, and CSS.
  • Produced operational analysis supporting more than 6,000 monthly requests at greater than 99% accuracy.

Background

Education and recognition

University of Massachusetts Amherst

Bachelor of Science, Resource Economics

Amherst, MA · May 2017

Recognition

  • MassMutual Leadership Award
  • MassMutual Be Bold Award

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

Looking for an analytics partner who can connect data, systems, and business decisions?

I’m open to remote opportunities and roles in Massachusetts or Connecticut.