Core Expertise
• Inventory Reconciliation & Analysis
• Excel VBA / Macros Automation
• Power Query & Data Transformation
• Amazon Seller Central & PPC
• SKU / UPC Database Management
• 3PL & Warehouse Operations
• Order Processing & Fulfillment
• Product Setup & Catalog Management
• Operational Reporting & Data Analysis
• Inventory reconciliation using QuickBooks reports and accounting data
• Process Improvement & Workflow Optimization
Operations professional with 9+ years of experience in inventory management, order processing, product setup, logistics coordination, operational analytics, and workflow automation. Specialized in streamlining complex operational processes for eCommerce and marketplace businesses through Excel VBA/Macros, Power Query, and data-driven process optimization.
Experienced in managing high-volume SKU catalogs, inventory reconciliation across multiple systems, Amazon marketplace operations, warehouse coordination, and cross-functional operational support. Proven ability to reduce manual workload, improve data accuracy, and develop scalable automation solutions.
Inventory Management & Operational Analytics
• Manage inventory reconciliation across 3PL systems, warehouse management systems, Amazon inventory, and QuickBooks.
• Analyze inventory discrepancies, shipment variances, and warehouse movement records to ensure stock accuracy.
• Generate operational and accounting reports for inventory adjustments, shipped units, and stock summaries.
• Monitor inbound/outbound inventory flows and troubleshoot operational irregularities.
• Lead monthly and annual inventory reconciliation initiatives with warehouse partners.
• Build and maintain SKU/UPC databases across domestic and international marketplaces.
• Coordinate with accounting, logistics, customer service, and inventory planning teams to maintain operational accuracy.
• Utilize Power Query to automate and track inventory movement analysis and reporting processes.
Excel VBA / Macros Automation
• Developed a complete Excel VBA/Macros automation model for Product Setup operations that transforms and maps product information between multiple platform formats, significantly reducing manual processing time.
• Created automated SKU-to-UPC association tools using Excel VBA to improve catalog accuracy and operational efficiency.
• Built Power Query inventory tracking systems to monitor inventory movements, reconciliation, and warehouse reporting.
• Automated repetitive operational workflows, reducing manual data entry and improving processing speed and accuracy.
Order Processing & Fulfillment Operations
• Oversee timely order processing and shipment verification across multiple marketplaces and warehouse partners.
• Investigate fulfillment errors, shipment discrepancies, delivery issues, and pricing disputes.
• Manage claims related to returns, re-deliveries, logistics issues, and invoice discrepancies.
• Maintain operational trackers and generate weekly/monthly performance reports.
• Conduct root cause analysis and implement process improvements to minimize operational errors.
Amazon PPC & Marketplace Operations
• Manage and optimize Amazon PPC campaigns through keyword research, bid optimization, search term analysis, and negative keyword strategies.
• Analyze advertising performance metrics including CTR, conversion rates, ACOS, impressions, and sales performance.
• Generate PPC performance reports and provide optimization recommendations to improve profitability.
Product Setup & Catalog Management
• Manage full SKU assortments across multiple retail and marketplace platforms.
• Validate product submissions, pricing updates, and listing accuracy.
• Optimize product listings and maintain catalog data integrity across platforms.
• Resolve listing issues and implement long-term preventive solutions.
• Support image and video content updates for marketplace listings.