Data Health

Huaide Ye, Ph.D.

*** ****** **** ***, *******, Ohio 43230

Home Phone: 614-***-****

e-mail: *********@*******.***

CAREER SUMMARY

Having obtained a Ph.D. degree in Sociology in 1999 focusing on demography and population studies; one and half year experience in financial company; seventeen years working in the state government, analyzing statewide large relational database in Education and Health Departments, conducting several complex research projects by linking different data sources and using statistical software SAS, SPSS, and GIS software ArcView.

EXPERIENCE

7/15 – 1/17 Community Choice Financial Inc. Dublin, Ohio

Senior SAS Programmer

Conducting metadata analyses for eight servers for CCFI in the Office of Risk Management

Rewriting SAS programs of daily metadata analyses for eight servers in CCFI using SAS macro and SQL syntax.

Writing SAS program to link CCFI databases to externally purchased data sources such as Experian, Targus, and Factortrust information to conduct Payday Loan Risk Assessment (PRA) modeling.

Writing SAS program to check the discrepancies between ADW, a data warehouse project contracted to Argus, and CCFI retail databases.

Writing SAS program to automate various monthly and daily reports such as initial delinquency report, revenue report, loan volume report, lead providers report, score card tracker report, etc.

Writing SAS program to conduct an analysis of Pay Off rate by Months of Book for retail installment loans from January 2014 through November 2016.

1/06 – 4/15 Ohio Department of Education, Columbus, Ohio

Social Science Research Specialist

Conducting various research projects related to LRC (Local Report Card) in the Office of Accountability

Independently writing a SAS program to conduct a simulation of Value-Added project contracted to SAS Inc.

Using SAS PROC SQL syntax to conduct a simulation of longitudinal graduate rate calculation by merging student attendance, graduation, and withdrawn tables from ODE (Ohio Department of Education)’s Data Warehouse.

Writing a SAS program to update similar school districts project annually by analyzing social economical and geographical variables from various data sources such as the American Community Survey from the US Census Bureau, district income data from Ohio Department of Taxation, student poverty and enrollment information from ODE’s EMIS (Education Management Information System) database, etc., and efficiently writing several Excel macros to generate the similar school grouping report.

Writing a SAS program and creating a similar schools project with a flexibility to customize the selection criteria in Excel report by specifying the school type such as public school or community school, school district typology such as rural, suburban, urban, etc., school designation, the percent of poverty, percent of minority, percent of disability, and total number of enrollment.

Using SAS PROC SQL syntax for checking whether there is any discrepancy between ODE’s data warehouse and trend tables, on which the variables in annual report card are based.

Writing a SAS program for HLM (Hierarchical Linear Models) by using Ohio ACT and OGT (Ohio Graduation Test) data.

Writing SAS PROC SQL syntax to update the complex calculations of priority schools, focus schools, and reward schools for renewing Federal ESEA (Elementary and Secondary Education Act) Flexibility Waiver.

7/03 – 1/06 Ohio Department of Health, Columbus, Ohio

Epidemiology Investigator 3

Initiating, designing and conducting epidemiologic projects and health services research in the Division of Family and Community Health Services (DFCHS)

Writing SAS programs to link public data sets such as VS (vital statistics), WIC (Women, Infants and Children Supplemental Nutrition Program), and U.S. census data by using propensity score matching method from the variables of first, middle, last names, date of birth, home address, etc. and conducting several in-depth researches such as “Using Neighborhood Types to Identify Populations at Risk for Poor Birth Outcomes” and “The Impact of WIC on Birth Outcomes in Low And Medium Income Neighborhoods”.

12/99 – 7/03 Ohio Department of Health, Columbus, Ohio

Researcher 3

Initiating, designing and conducting research activities pertaining to the DFCHS

Writing SAS programs to link Ohio vital statistics data such as birth certificate, death certificate, and fetal death certificate data by using propensity score matching method from the variables of first, middle, last names, date of birth, home address, etc. and further linking Ohio Childhood Lead Poisoning Prevention (STELLAR) surveillance database and U.S. census data by using GIS software ArcView to conduct “Ohio Pediatric Lead Poisoning Assessment Model --- Screening Recommendation Evaluation”.

8/98 – 12/99 Ohio Department of Health, Columbus, Ohio

Researcher 2

Coordinating Bureau of Nutritional Services research activities

Transforming the old data system based on mainframe

software, Condor, to the new data system based on PC software, Microsoft Office Suite, to address the Y2K issue and designing an automated new format for Monthly Report of WIC in the state of Ohio by using Microsoft Access/Excel/Word.

EDUCATION

The Ohio State University, Columbus, Ohio

Department of Sociology

Ph.D. in Sociology, 1999

Concentration in Demography

The University of Texas at El Paso, El Paso, Texas

Department of Sociology and Anthropology

Master’s Degree in Sociology, 1992

Concentration in Population Studies and Economic Development

East China Normal University, Shanghai, China

BA English, 1988

GRANTS

“Ohio Pediatric Lead Poisoning Assessment Model --- Screening

Recommendation Evaluation”, awarded $91,437 from the Centers for

Disease Control and Prevention, June 2000 - May 2001.

PUBLICATIONS

“Does the Family Structure Matter in the Process of Migration

Decision Making? A Longitudinal Analysis of Migration

Among American Youth: 1984 - 1994.” Doctoral Dissertation, March

1999, Ann Arbor, University of Michigan.

PRESENTATIONS

“The Impact of WIC on Birth Outcomes in Low And Medium Income Neighborhoods”, The Tenth Annual Maternal and Child Health Epidemiology Conference, December 2004, Atlanta, Georgia

“Using Neighborhood Types to Identify Populations at Risk for Poor Birth Outcomes”, The Ninth Annual Maternal and Child Health Epidemiology Conference, December 2003, Tempe, Arizona

HONORS AND AWARDS

Ohio Childhood Lead Poisoning Prevention Program Appreciation

Award for Performance of Excellence, September 2000, Columbus,

Ohio.

Selected as the Employee of the Month of July 2000 in Ohio

Department of Health, Columbus, Ohio.

Selected as the Ohio Statewide Employee of the Month for August

2000, Columbus, Ohio

Contact this candidate