Leon Zhou

Address: ** ********** *****, ***********, ******* M1T 1M5

226-***-**** acy9c2@r.postjobfree.com

Job Objective

Seeking a position as SAS Developer in highly reputed and professional organization

Highlights of Qualifications

4+ years of experience in statistical analysis by using SAS and SQL

Strong skills in data cleaning, manipulation, validation and peer review by SAS data step and SQL

2+ years of experience in working in customer retention and loyalty by segmentation

2+ years of experience in customer default, fraud and stress test by segmentation and statistic modeling

Experienced in creating sales trends reports using SAS Proc report, Proc tabulate and producing sales analysis graphs using SAS Proc gplot, Proc gchart, Annotation and Tableau

2+ years of experience in data mining by SAS/STAT and SAS/EM (e.g. linear regression, logistic regression, decision tree and neural networking)

Ability to use SAS Macro to achieve automation and improve efficiency

Proficient in analytical tools, such as Excel VBA, dashboard, Python, R and R-studio

Advanced skills in Microsoft Office Suite, Adobe Reader, Acrobat X

Ability to work efficiently under pressure and tight deadlines within a team or individually

Ability to think logically and have excellent written, verbal, and interpersonal communication skills

Work Experience

General Reinsurance AG China

Data Analyst Beijing, China Jan – August 2015

Extracted Cancer statistic of China, Hong Kong and Taiwan data collection from company’s database by using SAS data step and SQL query

Processed data cleaning and validation of certain key variables, such as locations and diet custom

Did customers segmentation in geography and demography and made charts by using SAS Proc gplot

Used SAS Proc corr to find the correlation between independent variables and target variable

Applied SAS Proc logistic to build a logistic regression model which fits the data

Studied the premium and claims’ relation to the facts of breast cancer

Manipulated Underwriting Consistency Study data and applied the model to score data

Proceed data management of every two weeks by applying SAS Macro and achieved automation

Allianz China General Insurance Co. Ltd.

Data Analyst Shanghai, China April - August 2014

Collected, documented and analyzed data on current customers to study the sale trends of products

Applied data step to manipulate, transpose and SQL to merge, concatenate and cleanse the data

Did segmentation to study the churn rate and sales, and analysis for customer relation management

Produced Proc report to make sales reports on monthly basis

Participated in creating SAS/EM process flow to do customers’ data mining

Compared models, selected the best one to fit our data and did prediction

Education

University of Waterloo Waterloo, ON

Bachelor of Mathematics, Major in Honours Statistics

Project

Conducted an experiment of cell phone battery consumption and collected data

Applied t-test to justify the significance of all variables

Used SAS Proc reg and its three selection methods to produce the best four models

Predicted the value and stated the conclusion

Achievements

Entrance Scholarship, University of Waterloo, Fall 2012

Placed in the top 10% or better in the 2012 Euclid Contest

Dean’s Honor List, Great Lake Collage of Toronto, June 2012

Contact this candidate