Data Analyst

• Jul 2020 - Present

Data Analyst

• Jun 2019 - Dec 2019

Graduate Student Consultant, Business AnalyticsDuring this program, I've participated in two different projects. One is finance related and the other is natural language process related. Details are below:Forecasting University Research Funding Project (September 2019 – December 2019)• Preprocessed 9.7K university funding proposals and 7.3K received awards records over 10 years from two data sources for other team members to conduct analysis in Python.• Visualized data leveraging Tableau to present proposals and award insights for stakeholders to understand funding performances and patterns in the past 10 years.• Developed three key metrics to evaluate university’s funding capacity for stakeholders to plan resources strategically.Google BERT Capability for Medical Text Classification (June 2019 – August 2019)• Led a team of four students to evaluate Google BERT’s performance in medical text classification tasks against other five machine learning algorithms in Python for a major pharmaceutical company.• Extracted 3000 tweets from Twitter API using provided tweet IDs for the team to perform the analysis.• Cleaned and transformed tweets that ready for five machine learning models and text analysis.• Reported results and key findings in comparison of Google BERT and other five machine learning models to client for their internal evaluation on Google BERT’s capability.

Associate

• Jul 2017 - Jun 2018

• Studied target audience of client’s four product lines in China to localize global marketing communications strategies that contributed to client remaining in first place among competitors locally, for traditional and social media impact.• Derived insights from focus group interviews and social media data to create new digital marketing strategy that increased conversion by 73%.

Account Executive

• Sep 2016 - Mar 2017

• Segmented 20K social media followers into three groups by analyzing their demographics and interests in Caterpillar.• Customized content strategy based on follower analysis to grow follower base and follower interactions.

Account Coordinator

• Dec 2015 - Aug 2016

Since promoted in December 2015, Junwei started taking more responsibilities, serving accounts across aviation, automobile and energy industries as well as playing a key role in multiple new business pitches including F&B, fashion, infrastructure, electronic and chemical industries in both traditional PR and social media.• Analyzed media coverages deriving media interests and trending topics for creating contents that conveyed the benefits of Honeywell’s aviation products.

PR Intern

• Sep 2015 - Dec 2015

In the period of three month internship, Junwei worked on accounts in aviation and automobile industries. As a member of the team, Junwei's main duties include:• Transformed data from multiple sources into five kinds of reports, updating clients and other teams around the world about China team’s works in progress and Honeywell’s public relations performance in China.