01
Business Analyst II
Rug Pad USA
Oct. 2022 – Jan. 2026
Suffield, CT
- Managed $5M+ annual Amazon Ads spend supporting $50M+ in revenue, increasing efficiency and driving incremental net sales growth through custom performance metrics, profitability-based bidding, and automated optimization systems.
- Led pricing and profitability initiatives that increased net sales while reducing unit volume, improving margins and driving more efficient operations.
- Developed automated bidding and campaign management tools in Python, reducing manual optimization time by 60–80%.
- Designed and implemented a COGS calculation engine supporting ~3,000 standard SKUs and 800,000+ dynamically generated custom SKUs, enabling SKU-level profitability tracking.
- Built a centralized data infrastructure (PostgreSQL, Supabase, dbt), reducing reporting time from hours to minutes.
- Developed interactive dashboards and internal tools (Next.js, TypeScript, Python) to monitor revenue, profitability, and advertising performance.
- Engineered ETL pipelines and API integrations (Amazon Ads, ChannelAdvisor, Shopify), automating data ingestion and eliminating manual reporting workflows.
- Improved database performance through schema design and indexing, reducing query times by 30–70%.