Database Overhaul: Walked into a database that was
barely functional — riddled with duplicate entries, misnamed fields, and broken variables
accumulated over years of patchy data entry. Audited the entire structure, built targeted
automation scripts to catch and resolve inconsistencies at scale, and finished what
automation couldn't with careful manual review. Took it from unusable to reliable.
Supplier Quote Intake Pipeline: The company was
receiving dozens of supplier quotes from China daily — arriving as PDFs, Excel files, and
CSVs in wildly inconsistent formats. Built an intelligent extraction pipeline that reads
each incoming email, identifies the correct product codes regardless of formatting
variation, parses the quote data accurately, and stores it cleanly in the database.
Significant engineering effort went into handling the unpredictability of real-world
supplier documents.
Automated Order Sync (SellerLegends → Database):
Built a production-grade Python automation hosted on GitHub Actions that wakes up every
morning, logs into SellerLegends, downloads the latest Amazon order data, and syncs it into
the company's internal database — keeping everything current without anyone lifting a
finger. Extended the same architecture to handle a second daily report serving a separate
operational purpose.
Live Tariff Monitoring System: US–China tariffs
change frequently and unpredictably — and for an Amazon seller sourcing from China, a missed
tariff update directly hits margins. Built an automated monitoring system that watches for
tariff changes across the company's product catalog, verifies updates, and writes them to
the database in real time. One less thing the team needs to manually track.
Ad Creative & New Product Launches: Produced a
range of AI-generated ad creatives for new product lines — experimenting with different
visual styles, angles, and audience personas to build out launch-ready creative libraries
without the cost of a full creative team.
TikTok UGC Automation (In Progress): Architected
the early-stage infrastructure for a multi-account TikTok content engine — designed to
generate and post UGC-style product videos at volume across multiple accounts to drive
organic reach and top-of-funnel awareness.