Post Job Free
Sign in

Data Analysis, Modeling, Sas, Spss, Stata, R,Excel, Access, SQL

Location:
United States
Posted:
September 05, 2014

Contact this candidate

Resume:

LU ZHANG

202-***-**** **********@******.***.***

EDUCATION

THE GEORGE WASHINGTON UNIVERSITY Washington, DC

Master of Science, Statistics May 2014

Coursework: SAS Programming for Data Management, Econometrics, Regression Analysis, Data Analysis, Applie d Forecasting

and Time-Series Analysis, Legal Statistics, Mathematical Statistics, Multivariate Analysis, Clinical Trials.

SOUTH CHINA UNIVERSITY OF TECHNOLOGY (SCUT) Guangzhou, China

Bachelor of Accounting June 2012

Key national university sponsored by Ministry of Education via “985 Project” and “211 Project.”

Academic Honors: University Third Scholarship, 2011; University Merit Student, 2010, 2011; Third Prize in National English

Contest, 2010; University First Scholarship (Awarded to three of 337 students), 2010; University Nobel Statistics Prize, 2010;

Excellent Member of Student Government Association, 2009.

PROFESSIONAL SKILLS

SAS Certifications:

SAS Certified Base Programmer for SAS 9 May 2013

SAS Certified Advanced Programmer for SAS 9 August 2013

SAS Certified Statistical Business Analyst Using SAS 9 June 2014

Technical Skills: SAS, SQL, STATA, SPSS, R, SAS Enterprise Guide, Microsoft Office (Ex cel, Word, Access, PowerPoint)

Language Competencies: Mandarin (Native Proficiency), English (Full Professional proficiency)

EXPERIENCE

Public Company Accounting Oversight Board (PCAOB) Washington, DC

Research Intern May-December, 2013

Assisted two Senior Economic Analysts with literature review, data management, SAS program coding, statistical

methodology design, data analysis and report preparation for economic research.

Used Excel and SAS to create organization’s audit dataset of over 10,000 public companies from Audit Analytics, to give

Associate Director easy access to data on market share of accounting firms.

Used Excel to create and update Emerging Growth Company (EGC) dataset from SEC filings in Edg er database, to give

coworkers easy access to oversee emerging growth companies.

Used S&P Capital IQ to analyze risks associated with issuers, and communicated these risks to other groups within PCAOB to

reduce potential risk of audit failure.

Recognition: Because of my excellent performance, internship was extended to maximum hours.

Mary Kay Company Canton, Guangdong Province, China

Marketing Research Intern June-October, 2011

Designed and distributed customer surveys to 200 participants at 9 different universities.

Used Excel and SPSS to collect and analyze survey data, and define product preferences among different customer groups.

Found that students in technical universities cared more about skin care products and less about makeup than students at other

schools.

Developed report that recommended distributing different advertisement fliers to different groups.

Results: Significantly increased sales.

Zhejiang NHU Company, Ltd. Hangzhou, Zhejiang Province, China

Accounting Intern June-August, 2010

Checked source documents to ensure accuracy and completeness of all data.

Used Kingdee accounting software to document financial transactions.

Maintained financial security by ensuring compliance with internal controls.

Used Excel to prepare special financial reports by collecting, analyzing, and summarizing account information and trends.

Results: All data entries were error-free, and management was able to make more informed decisions.

SELECTED RESEARCH PROJECTS

Analysis of Relationship between Wind Power Generation and Other Energy Prices February-May 2014

Used SAS to conduct correlation analysis and generate multiple linear regression model, to find indicators, such as crude oil

prices, natural gas prices, and nominal GDP, that influence wind power generation in the United States.

Used SAS to generate deterministic time series model to find exponential trend and influence of seasonality on wind power

generation.

Data Analysis of United States CO2 Emissions in G lobal Context October-December 2013

Professor doubted accuracy of recent findings, and assigned us to double -check for accuracy

Replicated original statistical model in book “Climate Change Justice” using dataset from World Bank, and found 3 obvious

errors.

Used SAS to create better model using robust regression, which could better explain amount of CO2 emissions per capita and

relative position of United States in global context in 2002.

Results: Found positive relationship betwee n CO2 emissions per capita and GDP per capita, as well as gasoline, and United

States looked bad in terms of CO2 emissions in global context.

Data Analysis of Risk Factors for Systolic Blood Pressure April-May 2013

Used SAS to conduct multivariate regression analysis, to identify possible risk factors for systolic blood pressure (SBP).

Conducted one-way ANOVA to examine influence of Body Mass Index (BMI) on SBP.

Conducted two-way ANOVA to examine influence of BMI and race on SBP.

Results: Found that people with higher BMI tended to have higher systolic blood pressure, and that people of African

ancestry tended to have higher systolic blood pressure than people of European ancestry.

Analysis of Relationship between Asset Structure and Financial Performance March-June 2012

Collected and analyzed 5 years of financial statements for 63 manufacturing companies, to study financial indicators.

Used SPSS to conduct correlation analysis and regression analysis.

Results: Determined negative linear relationship between debt ratio and return on equity.

Analysis of Financial Reports for Angang Steel Company, Ltd. February-June 2011

Analyzed the valuation of tangible and intangible assets and analyzed 5 years of company’s key financial indicators, to

measure performance and trends.

Conducted horizontal industry comparisons, to identify rankings and provide recommendations regarding asset structures and

profit models.

Results: Determined that the value of patents and brand recognition was overstated.

Recycling of Public Textbooks Research and Statistical Analysis September-December 2010

Designed and distributed questionnaire to 300 participants, to collect a nd analyze survey data.

Interviewed students, teachers, and bookstore personnel to determine recycling behaviors and expectations.

Provided reports and recommendations to university textbook department and promoted textbook recycling.

Recognition: Won University “Nobel Prize” in Statistics.

LEADERSHIP ACTIVITIES

SAS Tutor May 2014-present

Volunteer Elementary School Tutor March-May 2012

Host, Chinese Institute of Certified Public Accountants Lecture March 2012

Organizer, Mary Kay Director’s Lecture October 2011

Host and Organizer, School of Business Administration Debate Competitions September 2011

High School Tutor June-September 2010

Organizer, Student Government Enrollment Drive August 2010

Lecture Organizer, Lecture by former Google and Microsoft Executive Kai -Fu Lee October 2009

Lecture Organizer, Lecture by Chinese Academic Expert Li August 2009

Volunteer, Xiaoguwei International Finance Forum March 2008



Contact this candidate