Health Sql Server

Eric (Yajun) Guan

* ***** **** ***** ****, NY ***24 516-***-**** *********@*****.***

EDUCATION

UNIVERSITY OF MICHIGAN Ann Arbor, MI

Master of Health Services Administration, August 2006

UNIVERSITY OF WISCONSIN Madison, WI

Master of Science, Molecular & Environmental Toxicology, August 2003

NANKAI UNIVERSITY Tianjin, CHINA

Master of Science, Microbiology, June 2000

Bachelor of Science, Microbiology, June 1995

EXPERIENCE

HEALTH MANAGEMENT CORPORATION (WELLPOINT, INC) New York, NY

Advanced Analytics Analyst, Sr (May, 2008 ~ Present)

Developed and maintained sophisticated SAS codes in support of the operations of Disease

Management programs

Executed identification and stratification algorithm to direct members to targeted complex products

Performed analysis of quality, use, cost and other variables for opportunity assessments

Assisted business owners on program development, evaluation, and effectiveness measurement

Developed the technical definition, and performed analysis of metrics to assess outcomes for

various programs/initiatives, including ROI and performance guarantee etc.

Built and executed statistical models to select high risk members for the targeted solution

Investigated member behavior drivers and preferences, to meet client specific health gaps and needs

Developed evidence-based guidelines reporting process for national accounts

EMPIRE BLUE CROSS BLUE SHIELD (WELLPOINT, INC) Brooklyn, NY

Data Analyst. Sr (October, 2006 ~ May, 2008)

Provided financial and utilization reports to support marketing and sale strategy

Delivered and automated routine reports for national accounts, improved efficiency and accuracy

Participated in developing Enterprise Client Reporting standard and prodution

Provided standard and ad hoc enrollment, cost, and utilization reports to national accounts

BLUE CROSS BLUE SHIELD OF MICHIGAN Detroit, MI

Internship (April, 2006 ~ July, 2006)

Analyzed the impact of benefit change on quality, utilization and costs of behavior health services

Studied prevalence and incidence of mental disorders in the State of Michigan

Investigated Emergency Room use and costs, as well as generic Rx dispensing rates for GM

DALIAN PHARMACEUTICAL INC. Dalian, CHINA

Assistant Technical Director (September, 1995 ~ June, 1997)

Led research on ‘Fermentation Optimization of Antibiotics production’

TECHNICAL SKILLS

SAS Certified Advanced Programmer for SAS9

SQL Server, Teradata, Business Objects, MS Access, MS Excel

Statistical Modeling

ADDITIONAL

Published four articles in international scientific journals

Contact this candidate