Mengdi

(Lucus)

Liu

*** *.

**nd

St.

Apt.

**08

*

Chicago,

IL

60616

*

312- 709- 4980

*

acq222@r.postjobfree.com Summary

of

Qualifications

• Recent

Master

graduate

of

Marketing

Analytics

and

Communication

with

ability

to

work

with

team

members cross- functionally.

• Extensive

working

knowledge

of

SPSS,

Google

Analytics,

and

expert

user

level

of

Excel

working

with

complex formulas

and

formatting.

• Proven

ability

to

collect,

analyze,

optimize,

and

deliver

data

while

making

recommendations

for

further

success. Technical

Summary

• SPSS

• Google

Analytics

• Esri

ArcGIS

• Palisade’s

@Risk

• Excel

• SQL

• NodeXL

• Adobe

Photoshop

• Tableau

• SAS

Enterprise

Guide

• DecisionPro

Education

Summary

Illinois

Institute

of

Technology

Chicago,

IL

05/15

• Stuart

School

of

Business,

Master

of

Science

in

Marketing

Analytics

and

Communications Shandong

University

of

Finance

and

Economics

Shandong,

China

07/13

• Bachelor

of

Management

in

Human

Resource

Management Professional

Experience

Kydia

Inc.

/

BeyondMenu.com

Rosemont,

IL

12/14

-

05/15 Sales

&

Marketing

Analyst

• Conducted

market

research,

evaluated

market

penetration,

and

identified

new

market

opportunities

• Worked

out

measurable

test

marketing

plans

of

action

to

ensure

success

• Devised

strategic

methodology

to

collect

new

data

• Analyzed

sales

data

in

support

of

business

insights

and

decision- making

with

SPSS

Modeler

• Designed

product

sales

material,

user

manuals,

collateral,

and

other

commutation

content

• Cooperated

with

product

development

department

to

improve

product

functions BikeSpike

Chicago,

IL

06/14

-

08/14 Marketing

Consultant

• Recommend

the

marketing

strategies

for

product

initial

launch

period

• Collected

and

analyzed

profit

data

through

direct,

retailer,

and

distribution

channels

• Designed

price- calculating

tools

for

salesperson

to

negotiate

with

retailers Zibo

Pingyuan

Advertisement

Co.,

Ltd.

Zibo,

China

07/12

-

09/12 Marketing

Intern

• Responsible

for

the

sales

promotion

of

LED

writable

board

to

retail

stores’

owners

in

the

Zhangdian

District

• Collected

and

analyzed

sales

and

cost

data

to

support

the

marketing

strategy

• Cooperated

with

marketing

staff

to

complete

order

execution

and

follow- up

services Project

Experience

Divvy

Bike

Deployment

Analysis

Chicago,

IL

03/15

-

05/15

• Analyzed

and

visualized

Divvy

Bike

trips

data

to

improve

the

bike

deployment

performance

• Developed

strategy

of

improving

rebalance

efficiency

from

trip

perspective

and

presented

to

Divvy

executive Chicago

Sun- Times

Early

&

Often

Social

Media

Analysis

Chicago,

IL

09/14

-

12/15

• Conducted

analysis

on

E&O

Facebook

page

data

to

improve

customers’

engagement

• Recommend

social

media

marketing

plan

to

achieve

over

1.5

times

ROI

Contact this candidate