• Create and report weekly and monthly sales/profitability/inventory analysis with an executive summary for each platform by applying Excel, PowerPoint, and Tableau. • Identify opportunities to improve online presence and grow sales through promotions (Wayfair, Shopify, Walmart) and marketing strategies (Amazon Advertising).• Work corporately with a software company to set up automation and integration with platforms and 3PL logistics.• Onboard and maintain products to ensure all online assets are displayed optimally and accurately.

• Forecasted demand and monitored nationwide inventory of ventilation fan products to report purchases and goods transfer. Connected Excel with database by SQL to access real-time data.• Implemented adjustments and configurations in the ERP system.• Created labels and packages using CorelDRAW and mail merge function of MS Word.

• Recorded system defects and followed up dealing process in MS Project. Performed system tests and generated deliverable documents for new requirements.• Led interns to insert Macros in Excel templates for annual report function. Processed data using SQL in DB2.

• Collected and visualized data to track purchasing schedules via Excel and PowerPoint.• Created and updated purchasing contracts in the GLOBUS system and SAP CBFC system.