Participated in project coordination; Collected and organized school characteristics information in spreadsheet for future data analysis using Excel, Airtable, WordPress, etc.Performed survey data management, cleaning, analysis and visualization for 400+ participating schools using Qualtrics and R. Delivered survey report to the team and participated schools; Presenting longitudinal study and students’ mental health results during the annual symposium.Analyzed predictors of survey response rate based on historical data such as school sponsorship funding sources and survey lunch month to improve survey quality and school report accuracy.

Utilized Excel built-in functions including decision tree and pivot table to manage and analysis data of 5,000+ clients’ information.Created a model based on the results of data analysis to develop a new assessment strategy of financial loans and lines.

Wrote 3 legal reports about VIE structure, joint venture contract, and sales contracts for clients.Completed a legal research report discussing potential approaches of a foreign vehicle industry opening business in China, including suggestions of factory constructing structures, financial and share structures, etc.Provided real-life business consulting based on the acquired knowledge related to commercial law.