Post Job Free

Resume

Sign in

SAS, Marketing, Finance

Location:
United States
Posted:
December 14, 2009

Contact this candidate

Resume:

Zuocheng (Mark) Wang

** ******** ****, ***.**, Newark, DE 19713

bxyevn@r.postjobfree.com 302-***-**** (Cell)

Summary of Related Experience

Hands-on experience in analyzing customer database data (data mining, statistical analysis, statistical test and regression) and report generation. Expertise using SAS Base, SQL, SAS Macro, SAS/STAT to analyze large data sets.

Employment

Recovery Strategy analyst

June 2008 – Present Recovery Strategy Department, JPMorgan Chase Credit Card Services, Wilmington, DE 19801

* Analysis, programming and creation of reports on existing strategies using SAS and SQL. Design, implementation, tracking performance trend on new strategies in a test vs. control environment.

* Conduct data mining and statistical analysis (t-test, Chi-Square test, ANOVA, and logistic regression) to improve existing strategies; customizing treatments via appropriate risk/ payment performance based segmentation analysis.

* Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.

* Prepare daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.

* Develop SAS and VBA macros for automating the analysis, process, and report generation.

* Partnering with recovery operations to create value added analyses that directly drive business goals.

Business analyst

October 2007 – June 2008 Database Analytics Group, Marketing Department, NutriSystem, Inc., Horsham, PA 19044.

* Performed data mining using SAS and SQL to provide in-depth understanding about customer behavior and effectiveness of marketing strategies.

* Conducted statistical analysis, test (t-test, Chi-Square test, and ANOVA) and logistic regression to identify the key touch points/factors that influence and predict customer behavior.

* Standardized on-going reports and created ad hoc reports.

* Conducted list pull selection from database for marketing campaigns.

Statistical analyst - Intern

June 2006 – May 2007 Nonclinical Statistics Group, Biostatistics Department, Centocor, Inc., Malvern, PA 19355

* Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL, Proc Import, SAS Data Step, cleaned, validated and manipulated data by SAS and SQL.

* Conducted statistical analyses using linear and nonlinear regressions (Proc Reg and Proc NLIN), logistic regression (Proc Logistic), and general linear models (Proc GLM).

* Created reports including tables, listings, and Graphs by using Proc TABULATE, Proc SUMMARY, Proc FREQ, Proc REPORT, and Proc GPLOT.

Education

M.S. in Statistics, University of Delaware, Newark, DE, graduation/May 2007

M.S. in Materials Engineering, Harbin Institute of Technology, Harbin, China

B.S. in Physics, Nanchang University, Nanchang, China

Certified SAS Base Programmer and SAS Advanced Programmer.

Computer Skills

* SAS Products: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ODS.

* Programming Languages: VBA, S-plus, R.

* Databases: Oracle, MS SQL

* Packages: Microsoft Outlook, Word, Excel, Access, PowerPoint.

* Operating systems: UNIX and PC WINDOWS.



Contact this candidate