Yuqi Luo Email & Phone Number

Shanghai, China

Pta

• Completed client questionnaire data cleaning and analysis through SPSS, evaluated the advertisement outcome, and made 20+ PPT slides • Summarized 30,000+ search data, and used Excel to compare different products’ searching frequencies• Analyzed different advertising products of the Top3 Chinese advertising platform and turned out 10+ summary report

Columbus, Ohio, United States

• Analyzed China E-Commerce data of the most recent 5 years, made 50+ page document and 30+ PPT slides• Solved import tax issue for client, researched on import tariff regulations, offered suggestions on exporting goods and successfully saved more than 10,000+ dollars for client• Assisted client to hold the biggest North America online agriculture expo, imputed over 100 attendee info data and solved 50 + technical issue

Columbus, Ohio, United States

• Created an export strategic plan for client company. Selected proper measurable indicators and assign them weights to build global market decision matrix in Excel to determine top international markets and found Japan to be the best option for client.• Further researched on top target export countries including potential market sizes, important documentations, duties and taxes, competitor sales, and estimated landed costs to provided entry strategies.• Researched on available commercial and government resources, possible international trade shows, potential business partners, to help client address export funding issue and the export plan has been executed by client company, greatly prompted their export process.

Paris Area, France

• Made competitor marketing research for company in 10 target countries. Used benchmark including senior, production line, Powerful Product, Special Service and etc. to make over 50+ SWOT analysis for each competitor in different target countries.• Completed social media and website research. Summarized the most popular post content and surprised website design. Made suggestions to update company’s website and social media account.• Provided a totally new plan to design company APP. Aimed for providing consultant’s profile, company’s latest news, consult project progress, and recruiting, which will provide a quick way to know project progress, company information, and improved recruiting efficiency. The APP plan was greatly appraised by marketing and HR manager and ready to design and use.

Hunan, China

-Made mid-year financial summary and did most of the first draft of PowerPoints and Excel sheets.-Analyzed cost and profit data and made 20+ Excel spreadsheets-Made financial statements and helped to manage bill payments and tax payments

Columbus, Ohio Area

The MMC Scholars Program is a selective, living-learning program at Ohio State that encourages a hands-on application of digital media and technology. Students share a passion for learning new technologies and exploring how to incorporate them in emerging careers.