Marketing Project

Jianhua Huang

ashland, OR, *****

*******.***@*****.***

Phone:

732-***-****

Objective

Enthusiastic, knowledgeable person with strong quantitative

skills seeks marketing analyst/SAS programmer position .

Exams Passed the first 4 actuarial exams(P, FM, M, C). SAS Base

Programming Certificate for SAS9.

Experience A Plus Express, Oregon, Marketing Analyst

2008.7 - now

. Imported large volume invoice data of various

formats(.txt, xls, rtf,access,db2) to database on a

daily basis and performed data integrity and validation

check. Developed SAS macros to detect missing

/duplicate records and generate report for

qualitative/quantitative analysis;

. Functioned as project lead for the marketing campaigns

for two consecutive years (2009 and 2010). Built

predictive models for Christmas/Spring festival direct

marketing(email and catalogs). The models successfully

indentified the list of clients qualified for company's

coupon program with high LIFT around 150% ~350% over

the overall respond rate.

. Hands on experience with customer segmentation and

profiling using different methods like RFM cell,

LTV(customer life time value), etc.

. Assisted in developing a scenario forecasting tool to

show which segment of constituent base should be

solicited for the best ROI. The tool used SQL, Excel

and historical campaign data.

. Wrote SAS and SQL to produce report detailing campaign

revenue and response comparison, channel revenue and

response comparison, etc.

Honors

Award for Outstanding Achievement by a Graduate Student,

UALR, 2005.

Fellowship from GIT, Univ. of Arkansas at Little Rock,

2005

Technology

SAS, Stata, ominiture, C, FORTRAN, EXCEL,ACCESS, VBA,

Visual Basic.NET, SQL,

Certificate Certified Teaching Assistant by the State of Iowa (taught

different junior classes and led the labs)

Project Management Foundation by Mercer MMC Code of

Business Conduct & Ethics

Education

The University of Iowa, Iowa City, IA,

May 2008

Master of Science in Statistics Science

Beijing Industrial University, Beijing

July, 2003

Bachelor: Electrical Engineering

Contact this candidate