Kylie/Hongyu Ma

Phone: 617-***-**** Email:adm750@r.postjobfree.com LinkedIn: Hongyu Ma Milpitas,CA Summary Qualification

* ***** ** ********** ** data analytics by manipulating complex SQL queries, Python scripting, and BI visualization. Worked with technical managers and project managers to successfully interpret business, generate business insights, and solve problems in the financial and international development industry. Programming Languages: Python(Numpy, Pandas,Matplotlib), SQL, R Application:Tableau, Excel(Pivot table) Google Analytics Machine Learning: Logistic regression, Decision tree, Neural network, Linear REgression, Random Forest ETL (Extraction, Transformation & Load)

OS: MacOS, Linux

Work Experience

Business Analyst July 2020– December 2020

Lovely Time Weddings & Events Milpitas, CA, US

● Processed, cleaned & analyzed customer, employee, revenue data to understand the impact of various factors (region, age, income etc.) on revenue

● Increased advertising return on investment over 1.5 times by identifying the platform with highest conversion using Google Analytics

● Designed / built data pipelines and dashboard to track key cost/revenue related metrics

● Collaborated with marketing manager and other stakeholders to address business questions

● Utilized SQL to build pipeline and database, and built dashboard to track metrics Data Analyst February 2018– July 2019

Nextgen Realty Company Boston, MA, US

● Built a dashboard(Python-Panda) to visualize transaction data in order to show no of new deals per season, and the trend of the deals.

● Forecasted number of new deals using time series to help marketing and HR department set up their KPI goals

● Performed cost analysis to better understand the potential risk of the property investment in rebuilding the construction.

Academic Project

Housing Price Project Main factors in NewYork Airbnb influenced house price(Python)

● Processed, cleaned & transformed hundreds of thousands raw housing data from Airbnb using python

● Performed exploratory data analysis to understand the popular room types, locations etc

● Built regression model to predict the housing prices based on features: no of bedroom, sf, locations, room etc

Capstone Project Discover the relation between mental health and Reddit posts

● Understand the commonalities of the people with anxiety based on the conversation text from Reddit posts of mental health, e.g. the frequent words, location linked with anxiety.

● Used natural language processing in python including NER, tokenization etc. to generate summaries of posts by extracting only chief entities like places, feelings etc.

● Insights from the analysis are used by stakeholders for roadmap planning and product prioritization. EDUCATION

Northeastern University San Jose, CA, US

Master of Science, Analytics (GPA3.5) September 2019 –April 2021 Northeastern University Boston, MA, US

Master of Science, Project Management (GPA3.3) September 2016 –April 2018