MRS - Magic Resource Systems

Data, Database and Research

Data, Database and Research
(Tool used: SAS, MS SQL, Oracle, ACCESS, EXCEL, C# language, ArcGIS)

1. Analyze large, national data sources (e.g., Natality Files, BRFSS, Mortality) to generate county, state and national-level data to be included on NWHID; generate crude and age-adjusted values for key variables; assess comparability of data over time; Work with state public health departments to collect county health status indicators pertaining to infectious and chronic disease and reproductive health in all 50 states as well as US territories and possessions; correspond with local public health officials to convey data needs and requirements.

2. Involve in expanding the Area Resource File System (ARF) for Bureau of Health Professions that integrated health and demographic data available at the county and lower geographic levels. Major databases used are AHA, AMA, CMS, Bureau of Primary Health Care shortage area files, National Center for Health Statistics detailed death and birth data files, Bureau of Labor Statistics employment statistics, Bureau of Economic Analysis income and poverty data.
 
3. Analyzed policy in family medicine and Primary care through data collection, aggregation, large-scale dataset manipulation, and statistical analysis; Analyzed if Medicare clients are more difficult to access to providers than before. Major database used are Medicare claim data, AMA, CMS, GIS
 
4. Developed the Chinese college ranking model, launched the most influential Chinese university ranking system - Netbig Chinese University Ranking annually from 1996 to 2007

5. Pricing strategy for Easton Realty at Dallas-Fort worth metro market: a multiple regression analysis

6. Correlation analysis between yields of 90-day risk-free treasury bill and other relevant macroeconomic variables

7. Design training and other surveys through survey monkey, collect data needed for the projects