Social Media Financial Analyst

YING (STEPHANIE) DENG

Redmond, WA • 425-***-**** • ****.****@************.***

EDUCATION

Northeastern University Seattle, WA

• M.S. in Analytics, GPA: 3.74/4.0 Sep 2019 – Apr 2021 University of Washington Tacoma, WA

• B.A. in Interdisciplinary Arts & Sciences Jan 2017 – Jun 2018 Bellevue College Bellevue, WA

• A.A.S. in Economics Sep 2012 – Dec 2016

SELECTED PROJECT

Predictive Analysis of Amazon Reviewers, Northeastern University Apr 2020 – Jun 2020

• A dataset includes 568,454 fine food reviews among Amazon users analyzed to identify the correlations among scores and text messages, proposed a comparison among different predictive analysis methods-based sampling probability distributions

• Naive Bayes Multinomial, Generalized Linear Model and Random Forest applied on the dataset to figure out effective techniques on text classification

• Through NLP to identified and extracted information in sources like e-commerce platforms and social media. The predictive analyzed a lot of information about customers choices and their decision drivers PROFESSIONAL EXPERIENCE

Aventure Works, Inc Remote

Data Analyst Intern Jul 2020 – Aug 2020

• Integrated data from various back-end services and databases, employed techniques of data preparation and data wrangling to clean and position data for review

• Responsible for maintaining, expanding, and scaling the website

• Resolved the primary data sources and wrote analysis reports and data elements to include in data model; built SQL model

• Established data connections and launched the data model that activate API GETS, python page scraping scripts Seattle Real Estate Consulting Group LLC Bellevue, WA Office Manager Jun 2018 – May 2019

• Built a web scraper on Python to effectively research Top 100 properties transactions, and developed a database of company profiles with contact information for clients to connect and create potential partnerships and business engagement

• Predicted housing prices with Xgboost, helping the company gain more revenue. Utilized Logistic Regression to forecast customer purchase behavior with 88.75% accuracy and motivated the company to improve sales strategies and successfully increased revenue by utilizing Association rules

• Performed a full lifecycle quantitative analytics by building time series and linear regression models of the relationship between company financial performance and industry trends, achieving a 15% more accurate prediction of performance

• Utilized advanced Excel formulas to package data and analysis findings into client-faced deliverables on a regular basis with the leverage of data visualization tools such as Tableau & Matlibplot King County Prosecuting Attorney’s Office Seattle, WA Financial Analyst Intern Mar 2018 – Jun 2018

• Utilized Tableau, Salesforce, Excel, R to build and run reports and to gather data across of finance system

• Optimized and streamlined existing data models increasing refresh efficiency for Tableau dashboards

• Employed techniques of data preparation and data wrangling to clean and position data for review

• Evaluate risks related to requirements implementation, testing processes, project communications into over 10 different tangible deliverables such as functional specifications, workflow/process diagrams, data flow/data model diagrams SKILLS & QUALIFICATIONS

• Programming Languages: SQL, Python, R

• Skills: Microsoft Office, Microsoft Access, Minitab, Tableau, Tableau Server, Salesforce, Google Analytics, SAS Enterprise Miner, Web Scraper, Adobe Creative Cloud, Adobe Creative Suite, Machine leaning, Six Sigma

• Framework experience in Pandas, Scipy, Numpy, Matplotlib, Dplyr, ggplot2, ISLR, Mice, Nnet

• Hands on experience in Linear model and experimental design, regression analysis, Probability, Multidimensional scaling clustering, Bayesian statistics, Data visualization, Large-scale dataset management and preprocessing ACADEMIC AWARDS

• University of Washington Dean’s List Scholarship 2018

Contact this candidate