CJS.
Available for select freelance projects

Hi, I'm Cedrix John

AI Automation Engineer · E-commerce Operations

I automate e-commerce operations: pricing, inventory, margins, returns, and procurement. Production automation systems for marketplace teams, built on n8n, BigSeller, BigQuery, Supabase, Shopee, Lazada, and TikTok Shop.

View WorkersBook a 15-min callDownload Resume
Experience

AI Automation Engineer

May 2026 to Present

Boughtnex · Remote

  • Built an approval-gated procurement system (106 nodes) that calculates supplier-level reorder quantities from stock, sales velocity, reorder points, lead times, MOQs, and order multiples, routes spend-capped proposals through Slack approval, then creates verified BigSeller purchase orders and dispatches branded PDFs to suppliers over WhatsApp.
  • Developed a daily negative-margin monitoring system across Shopee, Lazada, and TikTok Shop that audits settled orders, deduplicates open cases, and creates tasks, alerts, and audit logs in Supabase, surfacing loss-making SKUs manual settlement review had been missing.
  • Built production n8n automations for marketplace operations, including Shopee and Lazada competitor-price intelligence with BigQuery caching, API enrichment, and normalized outputs.
  • Automated BigSeller inventory exports across warehouse workflows by triggering and polling jobs, downloading and transforming XLSX files, and synchronizing clean snapshots to BigQuery and Google Sheets.
  • Designed reusable API and webhook orchestration patterns for scheduled commerce operations, reducing manual handoffs and improving reporting consistency across teams.

Operational Support Specialist

Dec 2024 to May 2026

New York Family Dentistry · Brooklyn, NY

  • Built and maintained 20+ Python automated data pipelines processing 400K+ CSV/Excel rows daily into validated Google Sheets reports, reducing manual processing by ~30% and improving cross-team reporting accuracy.
  • Built and deployed 15+ interactive call-handling scripts (HTML, CSS, JavaScript) on Google Sites to guide live patient/caller conversations.
  • Automated operational trackers using Google Apps Script, enabling row transfers between tabs and cross-sheet report consolidation with built-in data cleaning and transformation, saving ~15+ hours of manual work weekly.
Education

Associate in Computer Technology

June 2022 - June 2024

Pampanga State University

Tech Stack

Tools I build with

Languages, platforms, and AI tools I use daily.

  • Languages & Web

    • Python
    • SQL
    • JavaScript
    • TypeScript
    • HTML
    • CSS
    • Next.js
    • React
    • Tailwind CSS
    • Vercel

  • Automation & APIs

    • n8n
    • Make.com
    • Google Apps Script
    • REST APIs
    • Webhooks
    • Vapi
    • Resend
    • Firecrawl

  • Commerce Operations

    • BigSeller API
    • Shopee
    • Lazada
    • TikTok Shop

  • AI / LLMs

    • ChatGPT
    • Claude Code
    • Claude API
    • Ideogram 3.0

  • Data & Storage

    • Google BigQuery
    • Supabase
    • Airtable
    • Google Sheets
    • Pandas
    • NumPy
    • Seaborn
    • Matplotlib
    • Power BI
    • Excel

  • Tools

    • VS Code
    • Google Colab
    • Git
    • GitHub

AI workforce

Meet the workers

Four production workers running e-commerce operations: procurement, margin protection, price intelligence, and inventory.

More AI Workers (8)
  • Charlotte digital worker portraitDigital worker

    Name

    Charlotte

    Procurement Automation

    Work

    Procurement & Purchase Order Worker

    Validates fresh inventory data, calculates supplier-level reorder quantities from stock, velocity, ROP, lead times, MOQs, and order multiples, then routes spend-capped proposals through Slack approval before creating verified BigSeller purchase orders and sending branded PDFs to suppliers through WhatsApp.

    Example use cases

    Inventory replenishmentApproval-gated POsSupplier dispatch
    n8nBigSeller APIGoogle SheetsSlack+4
    Replaces manual reorder math · spend-capped approvals · 106 nodes
    Private workflow
  • Sophia digital worker portraitDigital worker

    Name

    Sophia

    Negative Margin Monitor

    Work

    Margin Protection Worker

    Reviews settled Shopee, Lazada, and TikTok orders each morning, identifies negative-margin transactions, avoids duplicate cases, and creates actionable tasks, alerts, and audit logs for the operations team.

    Example use cases

    Settlement auditsLoss-making SKU detectionFinance alerts
    n8nBigQuerySupabaseGoogle Sheets+3
    Loss-making orders caught every morning · 28 nodes
    Private workflow
  • Piper digital worker portraitDigital worker

    Name

    Piper

    Marketplace Price Intelligence

    Work

    Marketplace Price Intelligence Worker

    Searches Shopee and Lazada for comparable products, checks cached results first, enriches marketplace listings, normalizes the findings, and stores fresh price intelligence in BigQuery for fast reuse.

    Example use cases

    Competitor price trackingAssortment researchPricing reviews
    n8nShopeeLazadaBigQuery+1
    Competitor pricing without manual lookups · 2 workflows · 30 nodes
    Private workflow
  • Harper digital worker portraitDigital worker

    Name

    Harper

    BigSeller Inventory Sync

    Work

    Inventory Data Sync Worker

    Runs scheduled BigSeller inventory exports, polls until each file is ready, downloads and transforms the XLSX data, then synchronizes clean warehouse snapshots to BigQuery and Google Sheets.

    Example use cases

    Warehouse snapshotsStock reportingInventory reconciliation
    n8nBigSeller APIBigQueryGoogle Sheets+1
    Warehouse stock reconciled on a schedule · 25 nodes
    Private workflow

Client work

Websites

Full site builds, handed over with the client owning every account the business runs on.

See all websites
A&R Carpet Cleaning · Business Website preview

A&R Carpet Cleaning · Business Website

Carpet Cleaning Co. · Calgary

Business website for a Calgary hot-water-extraction carpet cleaner: transparent pricing, a before-and-after gallery of real jobs, a free-quote booking form, and an FAQ covering drying time and pet safety. The same client the WhatsApp and lead-intake automations were built for, listed separately here because this is the public-facing site, not the automation behind it.

Next.jsVercel
Published pricing · before/after job gallery · online quote form
Visit the live site
YYC Prep · Marketplace Fulfilment Website preview

YYC Prep · Marketplace Fulfilment Website

Amazon/Walmart/eBay prep and fulfilment · Calgary

Full site rebuild for a Calgary marketplace prep and fulfilment warehouse: a published rate card instead of a lead-gated quote form, real Google reviews, a working contact form wired to the client's own inbox, and a complete domain, DNS, and email handoff so the client owns every account the business runs on.

HTMLCSSJavaScriptVercel FunctionsResendCloudflare
Published rate card · verified reviews · client-owned hosting and email
Read case studyVisit the live site

What clients say

Reviews

Real feedback from the businesses these sites were built for.

  • “Really happy with how the website turned out. Ced was easy to work with, listened to what we wanted, and made the whole process straightforward. The site looks clean, professional, and represents our business well.”
    YYC Prep
  • “Ced did a great job on our website. He was responsive, understood the direction we wanted, and brought everything together nicely. We're very pleased with the finished site and would gladly recommend his work.”
    A&R Carpet Cleaning

Contact Me

Let's build something

Open to AI automation, workflow, and ops engineering work. Send a message here and it lands in my inbox. I reply within 24 hours.

Email directly

cedrixjohns [at] gmail.com

Response time

Usually within 24 hours