Xiaoying Nie

860-***-**** adkhfw@r.postjobfree.com LinkedIn

SUMMARY

Efficient and solutions-driven data analytics student keenly focused on delivering high-quality results by utilizing and contributing strong problem-solving, technical, and teamwork skills EDUCATION

University of Connecticut (UConn), Hartford, CT May 2021

- Master’s in Business Analytics (Concentration in Data Science); GPA: 3.77/4.00

- Relevant Courses: Statistics, Data Science Using Python, Data Mining and Business Intelligence, Visual Analytics, Data Management and Business Process Modeling, Web Analytics, Big Data Analytics with Hadoop

- Certificate: Tableau Desktop Specialist, June 2020 University of Connecticut, Storrs, CT Aug 2019

- Master’s in Applied Economics; GPA: 3.92/4.00

- Relevant Courses: Applied Econometrics (Stata), Open Source Program With R, Analysis of Experiments (SAS)

- Scholarships: Russell Palen Scholarship, 2019; Stewart Johnson Scholarship, 2019 Zhongnan University of Economics and Law, Wuhan, China July 2017

- Bachelor’s in Statistics (concentration in Financial Statistics) EXPERIENCE

Awarded Graduate Research Assistantship at UConn Feb 2021 - Present

- Selected to work with Professor David Wanik to convert data mining and business intelligence class materials focusing on text analytics and time series analysis

- Import to Python from SAS to optimize course delivery Sterling Woods Data Challenge, UConn Center for the Advancement of Business Analytics Feb 2021 - Present

- Pre-process client’s (Brew Your Own) datasets such as handling missing values, performing feature selection and transforming data using Python

- Design interactive dashboards on Tableau and Python to analyze customers’ behaviors affecting client’s revenue

- Segment client’s users based on their content consumption using Natural Language Processing (NLP) and rank value of segments based on key metrics such as purchase and site engagement

- Predict what segment the user is in by applying clustering algorithms ACADEMIC PROJECTS

Tweets Classification (Python, basic web scraping, NLP, deep learning) Jan 2020 - Apr 2020

- Scraped 4k tweets of ABC News and Fox News using GetOldTweets3 module, removed general English stop words and deleted URL and HTML to clean text data using Python

- Generated Word Cloud using Scattertext module for each account to visualize text sequence in Python

- Built various models such as DNN, CNN, and RNN achieving 95.5% accuracy by applying advanced recurrent neural network with bidirectional LSTM layers and recurrent dropout Bank Churn Analysis (Python, machine learning) Jan 2020 - Apr 2020

- Performed exploratory data analysis such as using Matplotlib and Seaborn module to visualize data

- Predicted if the customer exists and achieved 90.6% accuracy by tuning and optimizing the hyperparameters using Logistic Regression, Random Forest, neural network and XGBoost with TensorFlow and Scikit-learn in Python Blood Donation Management System (Oracle SQL, MS Visio) Sept 2019 - Dec 2019

- Built a centralized relational database system using SQL and business process modelling techniques such as Swimlane diagram, AS IS, TO BE, etc. for blood donation process

- Created Entity-relationship diagram to keep a track of the donors, blood donation drives, labs, and hospital where the blood was sent after testing which saved time and resources by 40% for critical patients SKILLS

Programming and Databases: Python (Numpy, Pandas, Scikit-learn, Tensorflow, NLTK, GPT-2), SQL, R, SAS, Stata, SPSS, VBA, Hadoop (Spark, Hive, Pig, Sqoop), AWS Cloud (EC2 & S3) Tools: GitHub, Tableau, Power BI, Google Analytics, JMP, MS Excel (pivot table, vlookup, sensitivity analysis, what-if analysis, Macros), MS Project, MS Visio

Analytical Techniques: A/B Testing, Hypothesis Testing, Confidence Intervals, Exploratory Data Analysis (EDA), Predictive Modeling, Machine Learning, Web Scraping (basic), Time Series Analysis, Natural Language Processing LEADERSHIP

Mentor for 5 new international students at UConn as part of Buddy Program Jan 2021 - Present Vice President of Public Relations at UConn’s Toastmasters International Club May 2020 - Jan 2021

Contact this candidate