1. Following the ETL process for data cleaning and making some automated reports by using MS SQL in order to find insights for improving abnormal behavior of sales. 2. Pre-interview with the sales department for sales demand and then define the system specifications to provide IT reference for development. 3. Clarify the data source and logic from the database and draw up the data dictionary.

1. New product development: ●Market research for IPC products and related applications ● New product planning(Based on the market requirement and design feasibility) ● Specification and pricing strategy formulation. 2. Product life cycle and production management: ● 8 software customization projects per year, including BIOS default value update, Intel Security update for the vulnerability, etc. ●3 product certification renewal projects per year, including the EMC certification case for installing the M12 LAN module on the system, and the KC certification case. ● 6 hardware customization projects per year, including customized front bracket logo, customized panel mechanism, and 5W speaker system customization project. ● Regular maintenance of production and sales planning table every month, and business analysis of stocking according to rolling up forecast. ● ECN needs to be released 1-2 times a month for product improvement, including BOM materials replacement, motherboard revision, etc. 3. Product planning and research: ●Conduct the research based on existing product hardware/software/legislation requirements.

1. E-commerce platform management: ●Manage the product line of consumer electronics and appliances every day. ●Create a new banner and EDM every 2 weeks for attracting customers to order the merchandise from the website. 2. E-commerce business analysis: ●Through GA analysis to calculate CPC、CTR and draw up the market strategic project. ●Advanced the conversion rate of electronic products from 3.2% to 5% merely for a month by arranging explosive campaigns to bring more page views. 3. Website planning: Make the website design program and negotiate the feasibility with the software engineer to update the website for improving user experiences. 4. Business development(B2B): Success in developing a new dealer to cooperate with us. In partnership with Artist, a Japanese-style lunchbox supplier, to create even much more business opportunities.

1. E-commerce platform management: ●Management of consumer electronics products by arranging some promoted online events and providing perfect customer service consultation for maintenance. 2. Operating data analysis and market research: ●To understand what consumers demand on 3C products, so as to highly increase the conversion rate to get more revenue. ●Researched focus on the projector lamps while completing the B2C projects to achieve sales performance and presented monthly revenue performance reports. 3. Programs and activities planning: ● Came out with much more creative ideas to stimulate the sales values and website browse rates.