• Developed digital marketing strategy with industrial research and competitor analysis for new bag lunch campaign across Social, Search and email marketing. • Utilized MOZ to analyze gap and opportunity for brand website, identifying the keywords with low ranking and find out potential opportunity for keyword targeting. (i.e. recommending high searching volume keywords from google search; identifying the potential keywords from backlinks) • Optimized existing content to improve domain expertise and SEO customer volume. • Acquired 150 waitlist subscribers and converted 50 handbags pre-sales during pre-launch stage.

• Utilized online and offline market survey of students’ demand on mobile cards in five universities in Langfang city• Constructed bundling policy about mobile phone and card wireless network with setting special price for 10% off.• Visualized the distribution of students’ demands with Tableau, discovered freshman as a segmentation to promote the bundling products.• Cooperated with universities for promotion activity, successfully sold 100+ bundle products for the first month, and the overall sale increased 8%.

• Utilized V-lookup and pivot tables to analyze the financial data including asset-liability ratio, financial flow ratio etc.• Conducted data visualization with Tableau to monitor the trends over years and analyzed fluctuations from economic and political perspective.• Cooperated with technical department, enhanced the automation level and data quality of data acquisition and statistical process for 15%