Chad is an experienced E-Commerce Data Analyst specializing in Amazon and eBay reporting, using Google Sheets, Excel, Seller Central, Seller Legend, and Mailchimp to deliver daily, weekly, and ad-hoc performance dashboards. Skilled in data cleaning, campaign attribution, and marketplace trend analysis, with projects including Prime Day YoY comparisons and an eBay sales dashboard adopted as a daily reporting tool.

Summary of Experience
Recent Experience:

• Company: Karo Healthcare / Nutravita

• Role: E-Commerce Data Analyst (Independent Contractor)

• Duration: June 2021 – December 2024

• Responsibilities:

  • Produced daily, weekly, and monthly reports on sales, product status, ASIN health, inventory, and financial performance.

  • Analyzed top gainers and losers daily—checking competitor pricing, stock levels, and changes in Amazon Best Seller banners.

  • Conducted deep-dive ad-hoc reports, e.g. Prime Day YoY comparisons, eBay dashboard creation.

  • Cleaned data for campaign attribution (matching names from Mailchimp to Seller Central records using delimiters and filters).

  • Updated dashboards via Google Sheets, visualizing trends across 7 Amazon marketplaces in the EU.

  • Created summary reports with narrative insights submitted to management via his direct supervisor.

• Reason for Leaving:

• Company downsized due to preparation for sale; PH-based contractors were let go to reduce manpower costs.

• Notable Achievement:

  • Created and maintained an eBay sales dashboard that started as an ad-hoc request and became a daily report.

  • Regularly received positive feedback from his manager for his clear insights, particularly for the Prime Day analysis.

Previous Experience (Condensed):

• Nacoma Services Inc. – HR Manager (Nov 2019 – Dec 2020)

• Oriente Express / Cashalo – Manager, HR Ops (Oct 2018 – Apr 2019)

• ServiceSource – Sr. Manager, HR Shared Services (2016 – 2018)

• Full HR experience detailed in CV

Interview Questions & Responses
1. What was the context around why he was hired? What were the problems of the business? Why was hiring a data analytics guy so important?

• He joined as an additional headcount because the company was aggressively growing.

• When he started, sales were around £1K–£2K/day and later grew to £4K–£5K/day.

• The company needed someone to handle reporting to keep up with product launches, promotions, and campaign tracking.
  2. Why did he leave? Or was he let go?

• He was laid off in 2024 due to company downsizing—Karo Healthcare was preparing for a potential sale and cut costs by ending contracts with Philippine-based contractors.
  3. What was he in charge of? Was it regular dashboards or ad-hoc reports?

• Both.

• Daily: ASIN status, top sellers/gainers/losers, gross and net sales.

• Weekly & Monthly reports.

• Ad-hoc: campaign sales comparison, eBay dashboard, Prime Day analysis, customer promo tracking.

• He extracted data from Seller Legend, Seller Central, eBay Seller Hub, and sometimes Mailchimp.
  4. End-to-end example of how a report/project was requested and delivered:
  a) Meeting/context-setting:

• No direct meetings with UK stakeholders. Requests were relayed through his manager.

• One exception: direct coordination with a marketing contact to match names from Mailchimp and Amazon.
  b) Process steps:

• Extracted raw data (from Seller Central, Seller Legend).

• Cleaned data where necessary (e.g. delimited names, removed prefixes).

• Analyzed active SKUs, blockers, stock-outs.

• For gainers/losers: compared sales by ASIN, checked PDPs, competitor pricing, sale tags, bestseller rankings.

• Wrote narrative insights explaining the change.
  c) Delivery and presentation:

• Submitted reports to his manager.

• Manager reviewed and presented to higher management.

• Chad was not client-facing and did not present reports directly to stakeholders.

Key Skills and Tools

• Tools: Google Sheets, Excel, Seller Central, Seller Legend, eBay Seller Hub, Mailchimp

• Data Skills: Advanced formulas, dashboards, data cleaning (e.g., delimiter and filter), basic SQL logic (via Sheets)

• Reporting: Daily/weekly/monthly reporting, dashboard creation, ad-hoc report generation

• Visualization: Google Sheets dashboards only (trained on Power BI, not used in production)

Key Metrics and Analysis

• Metrics Used: Units sold, gross/net revenue, top SKUs, active/inactive status, out-of-stock rate, YoY comparisons, campaign attribution

• Monitoring Tools: Seller Central, Seller Legend, eBay Seller Hub, Mailchimp

Motivational Fit

• Looking For: Data analytics or reporting role, ideally mid-shift (UK hours), but open to US shift with partial overlap

• Current Rate: £1,000/month (~USD 1,250)

• Asking Rate: Open to similar or slightly higher

• Availability: Immediate

Red Flags

• Not client-facing; limited exposure to stakeholder presentation or strategy input

• Experience limited to Google Sheets; Power BI training not applied professionally

• Reports are filtered through supervisors—he has little direct feedback loop from data users

Assessment of Suitability for the Role
Chad is a strong backend data analyst well-suited for structured reporting roles. His Amazon experience is solid—especially across Seller Central, campaign analysis, inventory monitoring, and insights generation. While he’s not strategic or client-facing, he’s reliable with operations reporting and well-versed in e-commerce data sources. Best placed in environments where business stakeholders define report needs and expect timely, accurate, and clean delivery.