Resume

Sign in

Data Medical

Location:
Kings County, New York, United States
Posted:
December 05, 2017

Contact this candidate

XINWA CHANG

*** ****** ***.

Brooklyn, NY *****

646-***-**** (cell)

ac3lrg@r.postjobfree.com

SUMMARY:

More than 10 years experience in SAS programming to analyze large data.

Extensive experience in developing data analyzing, statistics analyst and data modeling.

Statistical analysis including univariate, bivariate, multivariate methods and extensive use of logistic.

Excellent knowledge of SAS software: Base, Stat, Macro, SQL, Graphic, ODS.

Extensive programming skills with SAS for data manipulation, data convert and transform, reporting summarization, listing and graphing.

Knowledge of operation systems such as Windows NT…

Working knowledge of popular software e.g. Oracle SQ/PLSQL, MS SQL, Crystal Report, HTML and MS Office….

Experience with medical codes ICD9, ICD10, CTP, DRG….and the medical terminology.

I enjoy team work and do whatever is necessary to get the jobs done accurately and on time to meet deadlines.

Exported the data from SQL, SAS and other software to Microsoft Excel and formatted the Excel sheet(s) for the manager, the director, and for any kinds of users.

NYS License Real Estate Salesperson.

EXPERIENCE:

02/2017 – 06/2017 Affinity Health Plan

Consultant

Created and modified the project and the reports for Marketing group to run the scheduling on the system.

Modified the project for sales and retention group to monitor the membership, duplicate records, disenrollment and reenrollement.

Programming using SAS, SQL, Facets…

01/13 – 11/15 Fitch Ratings Inc.

Program Analyst

Performed data mining analyst on rating and product business.

General and modify the Coverage Page Project that be viewed by senior managers in several groups.

Created SAS programming / html for compliance project and sale group to track the data.

Review and troubleshooting statistical projects for structured finance group.

Generated, updated the finance reports using SQL.

10/05 – 09/11 Metroplus Health Plan

Data Analyst

Covered millions dollars from my work for the company, the first amount was $252,850 from the claim process.

Worked for the medical finance director to monitor the claim and the payment process.

Generated lot of claim reports for inpatient, outpatient… readmission, the hospital in network or out of network, the medical doctors to correct claim and payment problems and waste.

Generated, updated the finance reports using SQL for the finance department.

Performed statistical analysis for UM and quality measurement analysis for QM.

Generated business report for finance, Quality, UM, Claim and Provider departments.

Supported medical doctors to monitor clinical and financial information.

Prepared, created and updated report using MS SQL and Crystal Report.

06/04 – 09/05 Columbia University Medical College (Grand fund)

Data Analyst

Designed and developed SAS and database program which including interface, database and report for international cancer research project

Performed statistical analysis using SAS including Proc UNIVERSITY, FREQ, MEANS, GLM, AOVA, TTEST, REG, PLOT, CHART, FORMAT, etc.

Abstracted and maintained data from the database and modified them.

Generated, updated reports using SQL, Crystal Report and Proc Report.

Maintained the database of MS Access, MS SQL etc.

11/00 – 05/04 Mount Sinai & NYU Medical Center, New York, NY

Lead Programmer Analyst

Performed data modeling for SAS programming.

Abstracted and maintained data from MS SQL or Oracle database service, Access, Excel and raw data by using PROC SQL, PROC IMPORT and Data step. Modified data by using MERGE, SET, SET/BY MERGE/BY and UPDATE and Data step.

Programmed, computed and modified reports, graphics, statistical and mathematical analyses. In-depth SAS programming to create derived data sets, generating summary tables, listings and graphics including the following procedures: UNIVARIATE, FREQ, MEANS, GLM, ANOVA, TTEST, MIXED, REG, PLOT, CHART, FORMAT, etc.

Generated a lot of reports including Web reports (Crystal Report, SAS/ODS HTML).

Created and updated programs using Access for the department.

10/95 - 10/00 New York Hospital - Cornell Medical Center, New York, NY

Data Analyst

Designed and developed SAS programs for the department of epidemiology to generate the output for CDC.

Created, reviewed and validated statistical programming for data of analysis, summarization and listing tables. Involved statistical analysis with GLM, FREQ, MEANS, REG, UNIVARIATE, TTEST, ANOVA, PLOT, CHART etc.

Abstracted and maintained data from Oracle or MS SQL service, Access, Excel and raw data by using PROC SQL, PROC IMPORT and Data Step. Modified data by using MERGE, SET, SET/BY MERGE/BY and UPDATE and Data step.

Daily functions included programming queries and interactive data between SAS and raw data.

Provided statistical expertise to the other team members.

Performed data modeling for SAS programming.

Created and updated programs using VB and Access for the departments.

Converted data from one platform to another to be used for further analyst.

Generated a lot of reports and graphics for special meeting (Crystal Report, SAS/Report).

EDUCATION:

SAS Certification

Oracle SQL/PL SQL Certification.

Brooklyn College of City University of New York

MS in Computer and Information Science

Shanghai Jiao Tong University

MS in Applied Mathematics

Shanghai Institute of Mechanical Engineering

BS in Applied Mathematics



Contact this candidate