Yuxi Yan

Houston, TX, ***** • 409-***-**** • admhv4@r.postjobfree.com

Data Analyst

Highly qualified individual with strong statistical analytic abilities and aptitude to work with a variety of data environment. Analytic, goal-oriented professional with demonstrated experience in executing data-driven solutions to increase efficiency, accuracy, and utility of data processing. Hands-on experience in creating data regression models using predictive modeling and analyzing data mining algorithms to deliver insights and implement action-oriented solutions to complex business problems. Energetic presenter and confident communicator with the ability to circulate information clearly, efficient, and beneficial for end users. Skilled at providing realistic projections and establishing various scenarios to determine viable process strategies to utilize. Technical Proficiencies includes R studio, SQL, Python, Word, Excel, PowerPoint, Power BI, Tableau, SAP. Highlights of Expertise:

• Data Management

• Data Mining

• Problem-Solving

• Leadership

• Project Management

• Time Management

• Report Generation

• Data and Statistical Analysis

• Logistic Regression

• Interpersonal and

Communication Skills

Education

University of Houston, Houston, TX

Master of Data Science, 12/2019, GPA 3.5

Bachelor of Science in Biology, Mathematics Minor, 2018 Experience

Sutong Tire Resources, Hockley, TX, 3/2021 to now

Business Analyst

• Collect sales and inventory data from SAP, clean and format data in Excel, using filter, vlookup and pivot table function.

• Create report per month in Power BI, analyzing and summarizing sales, margins, product order count and inventory trend.

• Deal with orders in SAP, interact with clients from Walmart, Home Depot, Lowe’s. Harris County Public Health, Houston, 8/2019 to 12/2019 Internship at Data Analyst

• Collected data by using SQL Server and validating the correction of data as well debug.

• Created the report and dashboard in Power BI, wrote the R script and interact with Power BI to add animation on plot independently, used ggplot2, gganimate,plotly packages.

• Created the template of animation plot and established the guidelines for users. Academic Projects

A Study of Diabetes Through Health Information, May 2019

• Participated in team of 4 members, in charge of creating ANN model and made PowerPoint.

• Selected dataset from Kaggle, built Decision Tree and ANN model to predict diabetes situation of Pima India women, compared two models by training accuracy and testing accuracy, refined model to improve accuracy by 15%. Tuberculosis Treatment Success Visual Analysis, May 2019

• Successfully completed team of 2 members project with Video and presentation used Tableau.

• Collected data from World Bank and WHO, used Tableau to visualize the relationships of TB treatment and economic of each country from 2000 to 2016, provided ideas about project and explored potential relationships by visualizing bar graph, line graph, boxplot and map.

Per Capita Income in Populous US Counties, November 2018

• Spearheaded team of 4 members which resulted in saving 60% of the time and increase efficiency by 99%.

• Played an integral role in creating multiple linear regression, identifying valuable data sources and automating collection processes, building predictive models and presenting results in a clear manner, as well as collaborating with professors and product development teams.

Yuxi Yan

Page 2

Statistical Computing Project, December 2018

• Participated in completing the academic project; served as the main speaker in presenting information using data visualization techniques in collaboration with other team members.

• Provided leadership in executing projects involving analytics including analyzing data to develop predictive models, using R studio to build linear regression with different models, such as with time series, with interaction; writing interpretation.

• Effectively collaborated with team members and professor, which resulted in saving 30% of the time and increase efficiency by 95%.

Contact this candidate