Data Analyst

Phuong (Jen) Phan

916-***-**** ***********@*****.*** linkedin.com/in/pphan92 jenarchiee.github.io Education

Seattle University Seattle, WA

Master of Science in Business Analytics; GPA: 3.7 Sep. 2019 – June 2021 Skills

Languages/ Tools: Python (Numpy, Pandas, scikit-learn, matplotlib, statsmodels), R (tidyverse, ggplot2), SQL, Tableau, Power BI

Relative Courses: Python for Business Analytics, Machine Learning, Data Mining (Supervised and Unsupervised Learning), Statistical Modeling (Linear/Logistic Regression), Data Wrangling, Visualization, and Communication, Database Management, Big Data Analytics (Hadoop, MongoDB, NoSQL, PySpark) Experience

BI & Data Analytics Intern Jan. 2021 – Present

Costco Wholesale Seattle, WA

• Build Power BI dashboards to automate sales performance report and customer profiles in order to generate product-wise, geographic and seasonal insights for supporting business decision making toward product launches and marketing campaigns

• Extract customer shopping history data using SQL, conduct Exploratory Data Analysis (EDA), implement machine learning models using Python in order to predict customer purchase behavior, and translate model results into actionable insights

• Effectively communicate and present key performance drivers to the business and leadership through Power BI and Adobe Analytics reports

Data Scientist Apprenticeship Sep. 2020 – Dec. 2020 Seattle University Seattle, WA

• Developed logistic regression model as a benchmark for decision tree, SVN, KNN, and neural network by utilizing Python to predict defendants’ hearing appearance pattern and time to disposition with the accuracy rate of 68%

• Processed local Washington state county data, implemented and visualized EDA, and conducted feature engineering from six datasets by utilizing Python to improve the performance of models by 38%

• Presented results, wrote reports to interpret and evaluate different models, as well as proposed recommendations to the local criminal justice system by minimizing defendant failure-to-appear rate and time to disposition Student Records Assistant Apr. 2019 – July 2019

City University of Seattle Seattle, WA

• Worked with confidential information; ensured that records were complete, and all information was tracked and recorded

• Created and archived physical files and electronic records using spreadsheets and database software that helped optimize course schedules

Projects

Modeling Passengers’ Airport and Airline Choice Behavior jenarchiee.github.io/airport

• Utilized Python to develop logistic regression and decision tree model with the goal of identifying passengers’ choice behavior from the survey data of 488 respondents, yielding the accuracy rate of 84% for airport model and 72% for airline model

• Conducted data mining procedure including data processing, EDA, feature engineering, modeling, evaluating, and proposing recommendations to the airline companies based on passengers’ behavior pattern SQL Data Warehouse Design and Visualization jenarchiee.github.io/ER

• Developed a conceptual model and MYSQL diagram that include 10 entities with attributes and relationships, populated the database, and generated SQL queries to identify business insights for a small coffee shop

• Deployed database to AWS cloud, utilized Tableau to visualize and present the key findings that helped answer the business problems including supplies, merchandising, and marketing campaigns Book Recommendation System jenarchiee.github.io/book

• Built machine learning model to optimize book recommendations using data set from AWS

• Utilized Python to find similarity scores of books and recommend the most relevant choices to the user

Contact this candidate