Marketing Python

YIWEI (BAI) BAI

New York, NY 917-***-**** ******@*******.*** linkedin.com/in/yiwei-bai-b5b001181

TECHNICAL SKILLS

Programming & Software: Python (Numpy, Pandas, Matplotlib, Scikit-learn, NLTK), Excel (Function, VLOOKUP, What-if Analysis, Sensitive Analysis, Scenario Analysis), SPSS Statistics & Modeler(HCA, K-means), SQL, Tableau

Analysis method: Machine Learning, Clustering, Scraping, Natural Language Process, Data Cleaning, Visualization (Tableau, Python Matplotlib + Seaborn), Descriptive Analysis, Predictive Analysis

EDUCATION

FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY

MS, Marketing Intelligence, Expected August/202*-****-****

Relevant Coursework: Data Driven Marketing Decisions, Customer Behavior, Market research

Activity: Fordham Graduate Marketing Society, Gabelli-Cardinal Hayes Marketing Competition finalist (Data analysis)

Pre-Master, International Business Bridge, GPA 4.00 2019-2020

Relevant Coursework: Financial Statement Analysis, Excel Application & Modeling, Marketing Analytics, Public Speaking

CENTRAL UNIVERSITY OF FINANCE AND ECONOMICS Beijing, China

Bachelor of Management, Business Administration, GPA 3.29 2014-2018

Relevant Coursework: Probability and Statistics, Database Principle and Application, Econometric

Honors and Awards: Merit-Based Scholarship(2016), First Runner-up CUFE Basketball Competition as team leader, Entrepreneurship Training

EXPERIENCE

Viale Tokyo, Japan Viale is one of Japanese online B2C fashion Companies. Jan 2019-Mar 2019 Market Researcher, Supply

Achieved 10% increase in sales by predicting future trend through collecting, cleaning, and analyzing product price data from different purchasing platform in Python, while ensuring quality of products

Conducted qualitative and quantitative marketing research, including (SWOT analysis, environmental analysis, and customer analysis), and identified future customer base and predicted future customer behaviors

Provide managerial recommendation for clients, including the current fashion trend and insight of future

Created product lists and liaised with Japanese clients to list up products for future market

HITACHI(China) LTD Beijing, China

Manager Assistant, Department of Social Infrastructure Summer 2017

Accelerated negotiation progresses by leveraging multiple languages advantage to support in translation of business documents

Coordinated with colleagues in business negotiations and gained insight in marketing and promotion of to-business equipment sales

Drafted templates of pricing and wrote product investigation report by leveraging skilled Japanese writing ability

PROJECTS

Nordstrom Rack Promotion Plan - Customer Segmentation Fall 2020

Aggregated transactional records and obtained 100,000 customer data by SPSS

Analyzed customer data, using Hybrid of Hierarchical and K-means Clustering Analysis and identified meaningful segments of customers, based on exploratory research for different brand in Nordstrom Rack(SWOT, positioning, 4Ps)

Visualized Geo-demographic data of target customers by Tableau and provided valuable managerial recommendation

The Gabelli-Cardinal Hayes HS. Marketing Competition -- Finalist Fall 2020

Analyzed text documents and extract valuable insight from data, using Python and Natural Language process

Came up with creative tagline for clients by conducting marketing research including survey and interview.

ADDITIONAL

Languages: English(Fluent), Mandarin(Native), Japanese(Native), Korean(Elementary)

Certifications and Licenses: CFA Level I passed, Python for Everybody Specialization(Coursera), Applied Data Science with Python Specialization(Coursera), Customer Analytics in Python(Udemy), Mathematics in Machine Learning

Interests: Basketball, Cooking, Stock market

Contact this candidate