Project Manager Data

*** **** ***** **, *** *CC Tel: +1-917-***-****

OU LIU

New York, NY, 10025 Email:******@********.***

EDUCATION COLUMBIA UNIVERSITY Sept. 2012-Dec. 2013

Master of Arts in Statistics New York, NY

Courses: Data Mining, Data Science, Advanced Data Analysis, Time Series, Linear Regression, etc.

SUN YAT-SEN(ZHONGSHAN) UNIVERSITY Sept. 2008-June 2012

Bachelor of Science in Statistics ; Minor in Economics Canton, China

Second Prize of Student Awards for each year of 2009-2011

RELEVANT Columbia Business School Oct. 2013 - Present

EXPERIENCE SAS Project Manager, Innovation Synergies Project New York, NY

Lead a team of 5 to design and construct SAS database for patent citations of over 500 companies in 3

industries over 10 years and further analyze citations pattern to identify companies innovation trends

Barclays June 2013-Aug. 2013

Fraud Risk Summer Analyst, Credit Risk Office Long Island City, NY

Developed and maintained database and data warehouse with UK fraud portfolios and automated regular

reports to save workload by 90% with VBA, SAS macro and Teradata SQL

Assessed and monitored fraud rules performance by industry behaviors and applied segmentation and ROC

curve to decrease false positive rate by 20% and significantly save investigation cost

Designed new fraud rules by identifying abnormal fraud trends and anomalies in transactional pattern

using Business Intelligence to mitigate high fraud losses and optimize customer experience

KPMG Feb. 2012-Mar. 2012

Audit Intern, Department of Auditing Shenzhen, China

Reviewed clients internal control system and performed substantive test and inventory count

Assisted with financial statements and documents preparation by verifying data accuracy and consistency

Worked closely with senior management and facilitated information flow between audit team and clients

China Mobile Ltd. Sept. 2011-Dec. 2011

Data Analyst, Office of Enterprise Clients Canton, China

Performed queries with large datasets in Access and SQL Server, standardized weekly report procedures

and optimized data processing algorithm to improve work efficiency significantly

Analyzed population movement using cellphone roaming patterns to support precision marketing

Identified regional low-value users with clustering analysis to maximize Return On Investment

Nov. 2013 – Dec. 2013

PROJECT Predicting Likelihood of Customer Accepting Personal Loan Offers

EXPERIENCE Course Project New York, NY

Built logistic regression model with exploratory data analysis, transformations and stepwise selection

Combined decision tree to incorporate complex interactions and enhanced AUC by 2.1%

Assessed accuracy by ROC curve on test dataset and corrected over-fitting problems by cross validation

Forecasting Questions Being Closed On Stackoverflow May 2013 - June 2013

Course Project New York, NY

Scraped data from Stackoverflow’s web API and converted text body to build corpus of 500 word features

Applied SVM and logistics regression on 3 reputation groups with built corpus and other variables

Improved model via Naïve Bayes and increased correction rate by 20% for lower reputation group

SKILLS Extensive experience in statistical modeling, database management and data mining

Advanced skills in SQL, R,SPSS,SAS (SAS Advance Certificate); Familiar with Matlab, Python

Proficient in MS Office suite: Excel(spreadsheet, macro), PowerPoint and Word

Fluent in English, Chinese( Mandarin and Cantonese)

Contact this candidate