Analyst Intern Research

RAYMOND YEE

San Jose, CA LinkedIn 408-***-**** ***.****@*****.***

EDUCATION

California State Polytechnic University-Pomona Pomona, CA M.S. in Business Analytics August 2021 – August 2022 University of California, Riverside Riverside, CA

B.S. in Business Administration, Concentration in Marketing September 2015 – June 2019 WORK EXPERIENCE

Market Scan Information Systems Inc. Camarillo, CA Data Analyst April 2022 – Present

● Cleans and prepares data using Excel’s Power Query and VBA for uploading into SQL databases

● Actively updates and audits automotive lease datasets on a daily basis while ensuring the utmost accuracy

● Automates dataflow using Python and VBA scripts to improve time efficiency in data extraction processes Cal Ergonomics LLC Cupertino, CA

Marketing Coordinator February 2021 - January 2022

● Actively oversaw company's social media and email marketing activities to grow online presence

● Created dynamic digital content that embodies the company’s core values and mission

● Developed social media campaigns that increased following by 110% and engagement by 50% Nollysoft LLC East Brunswick, NJ

Marketing Research Analyst Intern November 2020 – March 2021

● Created dashboards with Tableau to visualize industry trends and descriptives within the FinTech industry

● Interpreted and synthesized learnings from research sources to draw actionable conclusions for management to implement towards marketing strategies

● Designed detailed questionnaires/surveys to collect and analyze data to determine inefficiencies and areas of improvement for new mobile application launch

LCG Brands Consulting LLC Marblehead, MA

Digital Marketing and Research Intern September 2020 – January 2021

● Evaluated client preferences, combined with market trends and historical data to devise strategic plans and enhance marketing campaigns

● Conducted and documented market research on latest trends and identified implications on marketing strategies

● Collaborated with fellow peers to create digital content such as articles, blog posts and case studies to promote brand awareness

CAPSTONE PROJECTS

Investigation of Professional Football Teams’ Most Unexplored Areas

● Analyzed historic data using multiple linear regression model with Python to identify trends within the NFL draft picks that affect performance

● Classified players between fast and slow using random forest regression. Performed hotspot analysis with Python to identify areas of big plays that should be observed during a match. Identification of Fake Job Postings

● Collected data through Python BeautifulSoup web scraper. Applied natural language processing techniques

(normalization, tokenization, lemmatization) to clean dataset.

● Built Random Forest, k-NN, Naive Bayes and SGD models to be applied to clean datasets and classify real and illegitimate job postings.

SKILLS & EXPERTISE

AWS Tools Data Analytics Data Wrangling and Visualization Data Modeling Digital Marketing Excel Natural Language Processing/Text Mining Power BI/Power Query Python PySpark R SQL Tableau

Contact this candidate