Junior Business/Data/Marketing Analyst

Jingchao Wang

Contact: 347-***-****, ***********@*****.*** 40 Newport PKWY, Jersey City, 07310

PROFILE

Detail and data oriented, skilled in data mining, cleaning and analysis (R, SQL, SAS base, SPSS/Modeler, etc.), simulation and optimal model programming (Excel), and data visualization (Tableau, Gephi).

Have hands on experience of conducting marketing strategy/report, and a strong financial background.

EDUCATION

09.2013---05.2016

Hofstra University, Frank G. Zarb School of Business

MBA (Dual Major) in Marketing and Business Analytics GPA:3.54/4.0

Business Analytics Project highlight: WeChat Electronic Commerce Social Networking Analysis

Collected, cleaned and formulated our sellers’ data into (ID, amount, type, total consumption, referred by). And separate into different groups due to different consumption levels.

Designed and distributed questionnaire on Qualtrics for collecting customer feedbacks.

Conducted centrality measurement, visual plots with R and Gephi to find out key nodes and difference of relationship structure for different groups.

Used SPSS to generate report of Qualtrics questionnaire and made our sales recommendation.

Marketing Project highlight: JFK Terminal 4 (JFKIAT) – Food & Beverage Revenue Growth Plan

Summarized data based on JFKIAT annual Reports, JFK airport Gate Utilization and etc.

Conducted marketing analysis including SWOT, Competitive, Industry, Customer and Environmental/Economic analysis. Generated Sales Forecast and Promotions Initiatives

09.2008---07.2012

Shanghai University

Bachelor of Arts in Finance, 2008 First-Class Scholarship (top 3%)

EXPERIENCE

06.2014---08.2014

Bank of Communications (NY)

Risk Management Intern

Learnt build objects, query on Business Objects platform

Monitored enterprise performance of our loan clients and subsidiary companies

Generated risk reports with enterprise credit evaluation and industry analysis

07.2012---06.2013

SAIC Motor Corporation Limited

Southeast Asia Marketing Assistant

Involved in MG and ROEWE promotion activities of Southeast Asia Market

Built dashboard to help generating 2013-2015 Southeast Asia Marketing strategy report

Collected statistical data, analyzed customer preferences and find key influential factors

Designed surveys and summarized data for customer service department as reference

01.2012---06.2012

Fubon Bank

Enterprise Account Associate Manager

Involved in enterprise deposit and loan business

Generated credit reports based on enterprise annual reports evaluation and industry analysis

Maintained customer relationship and helped with improving customer satisfaction

08.2013---05.2016

Hofstra CSSA

Officer of Secretary Department

09.2008---06.2010

SHU. Student Union

President of Propaganda Department

SKILLS/LANGUAGES

Excel (Model Programming, simulation, decision tree, pivot table), Outlook, Word, PowerPoint

Programming and BI tools: BO platform, R, SQL, SAS base, Minitab, SPSS/ Modeler, Rapid Miner

Data Visualization: Tableau, Gephi

Certificate: Bloomberg Essential Language: English, Mandarin

Contact this candidate