· Created data pipelines in SQL Server and refreshable dashboards using Power BI to replace manual reports by automating the data clean and combination (ETL), reduced the working time by 60%. · Created moving weighted average algorithm in SQL Server to solve issues including imbalanced data, lack of data, and improved the historical product purchase price accuracy 20%. · Developed two dashboards and performed Quality Assurance to present data Visualization for product managers to monitor each product lines’ sales amounts at different marketing channels (Amazon Vendor Centro, Website, Store etc.) · Defined metrics through Amazon Keepa to measure competitive products performance to help product managers predict new product selection and pricing analysis · Predicted the container's empty date by using regression estimated annual cost saving $10K. Created dashboard to present the coverage of different products and provides the new warehouse location advise, monitored items shortage or overbooking