Xueying He

Tel: 857-***-**** E-mail: adg9w8@r.postjobfree.com

LinkedIn: www.linkedin.com/in/xueyinghe

SUMMARY

• Statistics Specialty & Data Analysis Internships: Proficient in Python, SQL, T-SQL, R and Office software for statistical modeling and data analysis, familiar with data processing related tasks.

• Logical Mind & Business Insight: Experienced in business operational problem-solving using data analytics tools.

• Fast Learner & Strong Pressure Adaptability: Self-driven learner full of enthusiasm, work well under high pressure. EDUCATION

Boston University GPA:3.6/4.0

Bachelor’s degree in Mathematics 09/2017-01/2020

Coursework: Discrete Math, Applied Statistics, Intro to Computer Science, Data Science in R, Probability, Analysis Variance, Linear Models, Applied Multiple Regression, Mathematical and Financial Derivatives. SKILLS

Programming: Python, R, SQL, T-SQL

Software: Microsoft Excel, Microsoft PowerPoint, Power BI, SSIS Statistical Analysis: Probability, Hypothesis testing, A/B testing, Regression, Machine Learning WORK EXPERIENCE

iTalenta Inc. Remote

Business Intelligence Analyst Intern 02/2020-09/2020

• Established efficient communication with clients to develop technical specification from business requirement that lead to actionable strategies.

• Extracted raw data from SQL Server and flat files and organized it into clean datasets for downstream analysis.

• Developed in-application T-SQL queries including Tables, Indexes, Stored Procedures, Views over large datasets to facilitate data manipulation.

Bayer Healthcare Co., LTD. Beijing, CN

Data Cleansing and Analysis Intern 06/2019-08/2019

• Sorted and organized medical conference information of Bayer within five years covering nearly 1000 meetings and tens of thousands of data including meeting contents, attendees, speakers, and financial expenditure, supported Bayer’s technical innovation and market trend following.

• Built Bayer's internal speaker dataset, and integrated the expert resources of various business segments, improved the coordination efficiency of resources.

• Analyzed medical conference trends using SQL and utilized Power BI to visualize analytical results. Valeon Beijing, CN

Data Analyst Intern 02/2019-06/2019

• Collected, sorted, and screened more than 12,000 pieces of client information via Excel, provided data support for more than 20 consultants, greatly facilitated the business development.

• Organized a dataset including the information files of more than 400 clients for the internal uses, supported the company's target client portraits and customer service improvement.

• Conducted analysis on the common features of past and current clients using R and SQL, increasing the potential clients by 15%.

• Delivered monthly reports, monitored the clients change trends and provided performance improvement suggestions to various departments.

PROJECTS/ EXTRACURRICULAR EXPERIENCE

Data Analysis Research Projects 09/2018-11/2019

• “Prediction of Bike Sharing Rental”: Conducted data analysis and linear statistical modeling to predict the shared bicycle rental situation in U.S. cities in 2012 and analyzed the matching degree with the existing data using R and Python.

• “Research on Reasons for Employee Turnover”: Performed data screening and modeling, studied the main factors affecting employee turnover, and completed reports and presentation. Provided suggestion on reducing company’s employee turnover ratio and improved the company's operating efficiency.

Contact this candidate