Data Project

CURRICULUM VITAE

Amy Xia

Fayetteville, AR **701

Email: ********@*****.***

EDUCATION:

M.S. 2002~2004 Statistics University of Arkansas

WORK EXPERIENCE:

**/**/** - ******* ***** Space Analyst (Store Layout)

Wal-Mart Home Office, Bentonville, AR 72716

Major accomplishments and responsibilities:

1. Develop Proto & Non-Proto store merchandise space recommendation

plans creatively using statistical predictive models attained from

statistical analyses of Wal-Mart's sales data, customer data and

competitor's information, and continue to improve current predictive

models based on store layout best practices and new corporate

strategies.

2. Assists in special and ad-hoc projects through database statistical

analysis to provide summary reports, trend analysis, and models to

decision makers and merchants.

3. Uses data analytical tools such as SQL, SAS, JMP, Access, and Excel

to program, extract, transform, standardize and analyze data sets

retrieved from local department collected data, Tera-data and DB2

databases, generate and develop ad hoc reports for business uses.

4. Manage multiple projects individually and participate on team

projects concurrently.

5. Work cross functionally with CAD specialists and project managers

to optimize and execute space allocation plans during the blue print

designing process for new store and space re-allocations for remodel

or expansion or relocation stores for nine states which include state

of Texas and eight states from mountain area.

6. Promotes and supports company policies, procedures, mission,

values, and standards of ethics and integrity, respect for the

individual, service to the customer and striving for excellence.

2007 - 2012 System Analyst II.

National Office for Research on Measurement

and Evaluation

Systems (NORMES), University of Arkansas,

Fayetteville, AR. Manipulate

and combine large database using SAS and SQL.

Major accomplishments and responsibilities:

1) Conducted 5 years advanced SAS programming and statistical

analysis of K-12 educational database for Arkansas Department

of Education to support developing and maintaining a web-

based reporting system named as "AIP-IRI". This system

provides school performance snapshots of all public schools

in the Arkansas. Database management activities involved

Arkansas K-12 testing data, which included creating SAS

datasets from original ASCII data from testing companies,

statistical analyses of the data, and preparing analysis

reports to meet the requirements of the No Child Left Behind

(NCLB) Federal legislation. Participated in the data

management and analysis, assessment, reporting of Reading

First project. Developed SAS program to load AR benchmark

assessment data sets and cross validate with the summary data

file from test company for AYP project, double checking the

AYP calculation results based on the student level data

released.

2) Performed two years database management and analysis for

Michigan Department of Education, in support of developing

and maintaining a web-based reporting system to facilitate

the implementation of the NCLB legislation.

3) Published research papers on academic journals and presented

research findings at national conferences. During the 5 years

working as statistical analyst at NORMES, 1 journal article

has been published; another 4 research papers were presented

at national academic conferences.

2003 - 2004 Graduate Assistant, served as statistical consultant

at Center for Statistical

Consulting, Division of Statistics in

Department of Mathematics, University of

Arkansas, Fayetteville, AR.

Duties performed: providing statistical consultation for

faculty and graduate students working on their research

projects, consultation of experimental

design and statistical methodology, data

analysis using SAS, JMP, etc.

statistical software and interpretation of

statistical analyses results to clients.

1999 - 2003 Ph.D Graduate Assistant, Department of Soil and

Environmental Sciences, University of Arkansas,

Fayetteville, AR.

Ph.D dissertation research project: "Dynamics

of Phosphorus Transformation

in Arkansas Silt Loam Soil Used for Rice

Production".

Major accomplishments include: Aerobic and Anaerobic

incubation of flooded and unflooded air-dried soils, with

soil Eh and pH measurements through the whole incubation

period. Modified Chang and Jackson P fractionation

procedure was used to measure the transformations of

Soluble P, Ca-P, Fe-P, Al-P, Reductant Soluble Fe-P, and

Occluded Al-P. Soil-test phosphorus was determined using

Bray-1, Bray-2, Olsen, Mehlich-3, Resin Capsule, and

Lancaster six methods respectively. The concentration of

the P in all extracts was determined by the ascorbic

method.

PUBLICATIONS

Yanling Xia, Kening Wang and Sean W. Mulvenon. 2009. Effect of Gender on

the English Language Proficiency Assessment Test Score. Presented at the

2009 American Educational Research Association Annual Meeting in April,

2009, San Diego, CA.

Kening Wang, Sean W. Mulvenon, Charles Stegman and Yanlin Xia. 2010. Web-

Based Interactive System for Analyzing Achievement Gaps in Public Schools

System. Journal of Educational Technology Systems. Vol. 38(3), 341 - 348,

2010.

Kening Wang, Sean W. Mulvenon and Yanling Xia. 2010. GIS Analysis of the

Achievement Gap for Socio-economically Disadvantaged Students in Arkansas

from 2003 to 2008. Presented at the 2010 American Educational Research

Association Annual Meeting in April, 2010, Denver, Colorado.

Kening Wang, Sean W. Mulvenon, Charles Stegman and Yanling Xia. 2008.

Improving Educational Data Quality for Growth Model Analysis. Presented at

the 2008 American Mathematical and Statistical Association Joint Meetings

in August, 2008, Denver, Colorado.

Kening Wang, Sean W. Mulvenon, Charles Stegman and Yanling Xia. 2008.

Modified Equation for Computing Performance Growth Index (PGI) When

Expected Gain (EG) Is Negative. Presented at the 2008 American Educational

Research Association Annual Meeting in March, 2008, New York.

Yanling Xia, Wilson, C.E., Jr., R.J. Norman, N.A. Slaton. 2002. Phosphorus

fertilizer management for rice produced on alkaline soils. pp. 310-316. In

R.J. Norman and T.H. Johnston (ed.). B.R. Wells Rice Research studies 1998.

Ark. Agr. Exp. Sta. Res. Ser. 468. Fayetteville, AR.

PROFESSIONAL SKILLS AND TRAINING:

Statistics:

. Statistical programming(SAS) and analysis

. Data compilation and management

. Statistical Modeling

. Experimental design, variance analyses and regression

. Professional display and interpretation of statistical

analysis results

Computer:

Programming: SAS, SQL

Database: Teradata, DB2,

Statistical Software: SAS, JMP, R, SPSS, ITSM2000 (Time Series

Analysis).

Spatial Analysis and Modeling: Geostatistical Analyst package, GeoR

package, and GS+ package.

GIS (Geographic Information System):

ArcGIS Certificate; ArcGIS-ArcInfo (ArcMap, ArcCatalog, and

ArcTools)

Statistics, GIS, and Computer Related Courses (Total of 57 graduate level

credit hours completed): Statistical Theory, Statistical Inference,

Spatial Statistics, Vector GIS, Stochastic Process, Time Series,

Categorical Response, Multivariate Analysis, Experimental Design,

Principles of Statistics, Regression Analysis, Practicum in Biometry, Case

Studies in Biometry, Applied Regression Analysis, Consulting Practicum,

Statistical Consulting Process, SAS Programming, Applied Math Methods,

FIN. DIMSNL Vector Spaces, Advanced Calculus I (Set Theory), Numerical

Analysis (Matrix Theory), Advanced Mathematics, Applied Mathematical

Methods, Industrial Statistics.

Contact this candidate