Data Analyst

Nuo Chen

***********@*****.*** linkedin.com/in/nuo-chen-930333217/ 626-***-****

EDUCATION

University of Southern California Los Angeles, CA

Master of Science in Analytics, GPA 3.89/4.0 Aug 2022–May 2024 Guangdong University of Foreign Studies Guangzhou, China Bachelor of Economics in Financial Engineering, GPA 3.80/4.0 Sept 2018–Jun 2022 SKILLS

Programming: Python (Pandas, Numpy, Scikit-learn, Matplotlib, Seaborn), SQL, R (ggplot2,dplyr), VBA Analytics: BI tools (Tableau, Power BI, Looker), Google Cloud Platform, Azure, BigQuery, PySpark, Snowflake Techniques: ETL, Exploratory Data Analysis (EDA), Statistical Analysis, Machine Learning, Web Scraping, NLP PROFESSIONAL EXPERIENCE

USC Dornsife College of Letters, Arts and Sciences Los Angeles, CA Research Assistant Jan 2024–Present

Extract post-experiment questionnaire data, perform feature engineering and 8+ statistical analysis

Employ Librosa in Python to derive speaker’s tone from 45mins audio for each experiment pair, build predictive regression models to correlate with behavioral ratings for assessing closeness between strangers

Detect the dominant emotion for speakers via Py-Feat package, covering anger, disgust, fear, happiness, sadness, surprise, and neutrality. Visualize influential patterns through 15+ tables and graphs FLYR Santa Monica, CA

Data Analyst Intern May 2023–Aug 2023

Developed and implemented an alerting system in Looker to monitor flight data pipelines and ETL processes, identifying and addressing data discrepancies to ensure 98%+ valid model runs for clients in the airline industry, reduced team workload by 20%

Consolidated 20+ data sources in BigQuery, fine-tuned 10+ filters to automate queries work on different scenarios, analyzed profit margins per flight attribution to uncover feature importance

Created a model explain dashboard to examined time-series data for individual flights, delivered valuable insights on high-impact attributions affecting revenue and trends, offered insights to data science team Guangzhou Yuexiu Industrial Investment Fund Management Co., LTD Guangzhou, China Business Analyst Intern Sept 2021–Feb 2022

Analyzed and Interpreted business data from dairy industry with Tableau, leveraged valuation models to assess the company’s financial performance, produced a 50+ pages analysis report for optimizing investment strategies

Assessed market size and competitive landscape of LED industry by gathering data from diverse online sources, delivered insightful presentation directly to the Executive Director, driving informed decision-making Ernst & Young Guangzhou, China

Data Analyst Intern Jul 2021–Aug 2021

Led a team of 4 in accomplishing capital verification of 30+ mutual funds, streamlined data reconciliation process for revenue analytic by deploying SQL queries and VBA instead of dumping Excel file

Queried, organized, and manipulated 20k+ records for mutual funds using SQL, expanded proprietary database by deriving terms and summarizing fund strategies from source documents, improving data retrieval efficiency SELECTED PROJECTS

Intelligent Search Engine for CNN News Nov 2023

Applied KNN to categorize various topics within CNN news dataset, labeled 1% of the dataset’s entities to establish ground truth. Built search engine models with NLTK, SpaCy and TextBlob for entity recognition

Conducted data cleaning for 300k+ text records by applying stop words removal, lemmatization, and format standardization, resulting in a 10% increase in final search engine precision rate

Employed TF-IDF for text vectorization and performed cosine similarity calculation to extract top 10 relevant news for each testing query. Achieved a search time reduction from 22mins to 7mins, surpassing the baseline by 68% Credit Card Customer Churn Analysis Dec 2022

Performed 10k+ data cleaning, created 30+ charts and 5+ dashboards for exploratory data analysis

Developed Logistic Regression and Decision Tree model based on R, evaluated the performance with key metrics, and tuned models by hyperparameter tuning, enhancing test accuracy by 8%

Derived actionable insights for bank to identify which kind of customers would leave credit card services, addressing the challenge of revenue loss from customer churn

LEADERSHIP AND INVOLVEMENT

Member of Women in Engineering (WIE), USC Viterbi Engineering School

Captain of Badminton Team at School of Finance, Guangdong University of Foreign Studies. Organized 10+ social events and weekly training with a team of 50+ members

Contact this candidate