Data Analysis

Bo Lin

Tel: 443-***-**** Email: ******.*********@*****.***

Address: **** ******* *** #***, ********, MD 21044

Education

Louisiana State University, Baton Rouge, LA

Master of Science, Applied Economics, 4.0

Fujian Agriculture and Forestry University, Fuzhou, China

Bachelor of Science, Agriculture, 3.9

Summary

Six plus years’ experience as a professional SAS programmer on data management, data analysis, statistical

modeling, simulation and reporting in Healthcare data.

Thorough knowledge of drug development, Medical Devices, Clinical Trials and involved in all Phases of

Clinical trials which includes design, development and implementation of Statistical/Data models for major

pharmaceutical companies and CROs.

Strong analytic, statistical, and quantitative mathematics skills using SAS/SAS Base, SAS/Macro,

SAS/Access, SQL, SAS/STAT, SAS/Graph, SAS/Connect, SAS/Report, SAS/ODS, SAS Enterprise Guide

in windows, Mainframes and UNIX environment to conduct large-scale data analysis; Proficient in MS

Office (Microsoft Word, Excel, PowerPoint and Access)

Excellent written & verbal communication skills in English

Certifications

SAS Certified Base (Certificate Serial Number: BP033600v9) Programmer for SAS 9.3

SAS Certified Advanced (Certificate Serial Number: AP009427v9) Programmer for SAS 9.3

Work & Research Experiences

SAS Programmer/Research Analyst, Impaq International, Columbia, MD 01/2014-Present

Responsible for various CMS and CCIIO projects, including Medicare Part C & Part D Payment Error Analysis,

Payment Validation, Development of Medicare Part C and Part D Monitoring Methods, Medicare Part C and Part D

Payment Error Analysis, CCIIO Formulary Outlier Review Analysis, CCIIO Clinical Appropriateness Analysis,

CCIIO Exchange Policy and Oversight Group Analysis etc. including:

Worked with statisticians to analyze clinical data and generated tables, listings, graphs, summaries and

reports according to internal SOPs and departmental guidelines, for the same generated output files in HTML,

PDF, and RTF format using SAS ODS.

Has experience in mapping data into Clinical Data Interchange Standards Consortium(CDISC) for electronic

submissions and a thorough knowledge of different phases of clinical trials and clinical trials data like

1

Demographic data, Adverse Events data, Laboratory data and Vital signs. Highly experienced in extracting

data from relational databases, good at collecting and generating requirements from users.

Manipulated and managed data in SAS, extracting, recoding, and merging datasets, handling missing data

and creating analysis variables, performing statistical analyses, creating customized reports of data analysis

results as well as performing quality check audits of SAS programs.

Provided advanced level of SAS programming activities for the monitoring, reporting, and analysis of CMS

Bundle Payment Validation (BPV) simulation, translated all SAS codes running in production for BPV

simulation and developed data flow diagram, developed and maintained SAS Batch jobs as a part of data

integrity check for monthly monitoring of SAS programs and logs used in BPV simulation to generate

automated reports from Excel exhibit files.

Performed a Part C and Part D monitoring gap analysis to identify and report gaps in the current CMS

monitoring strategy, (b) developing a sustainable monitoring method and measures of Part C and Part D

sponsors’ administrative function, (c) developing a sustainable monitoring method and measures to ensure

that marketing materials and beneficiary communications are available to beneficiaries in all required

languages, (d) developing a sustainable monitoring method and measures to help ensure beneficiary

provider access in the Part C program, and (e) developing a sustainable monitoring method and measures of

benefits and out of pocket coverage under the Medicare Part C program.

Determined the state-level low outlier thresholds for the number of chemically distinct drugs without a

prior authorization or step therapy requirement (i.e., unrestricted drugs), based on CCIIO identified USP

category and class of drugs to be assessed in the FOR test using SAS merge/SQL Join, Proc freq, Proc

Univariate, and SAS/Macro etc., created customized reports of data analysis results using Dynamic Data

Exchange (DDE), as well as conducting Adhoc analysis.

09/2013 – 12/2013

Volunteer, the United Nations

Department of Economic and Social Affairs, New York, NY

Volunteered with the e-Participation Cluster of Development Management Branch (DMB) of the Division

for Public Administration and Development Management (DPADM) of United Nations Department of

Economic and Social Affairs with research and analysis in the Field of Citizen Engagement.

Created, updated, and documented the contact list of famous speakers through Excel spreadsheets.

Researched and documented Decentralization Law, National Budget Act, and Open Budget Initiative for

various countries. Communicated and collaborated with team members and supervisors to make accuracy

with the results of research; edited and deleted the errors.

2

Economic Research Assistant, Louisiana State University - Baton Rouge, LA 01/2011 - 08/2013

Briefed, abstracted and issued recently publication; summarized market research findings related to biofuel

and energy service, including inputting survey data from excel/pivot table into SAS, and graphing utilizing

SAS.

Built general/partial equilibrium and demand & supply model; collected, encoded, cleaned, and compiled

data for multifarious projects utilizing SAS/Macro, SAS/Graph, and SAS/Report.

Studied consumers' perception and preference towards grass-fed versus grain-fed beef product, including:

created ten compound profiles of beef steak product utilizing experimental factorial design; conducted survey

questionnaire online for consumers to rate those profiles and collect data; built conjoint model, demand and

supply model, ordered probit and logit model utilizing mean deviation coding; employed statistical software

to analyze the data utilizing Stata, and made accurate interpretations of the results. Reported the results to the

supervisor and other committee members weekly/monthly.

Actively involved in other assignments including: provided supports, drafted, edited for government grant

and protocol preparation, managed research projects, conducted experimental design; analyzed the food

market data including correlation analysis, multivariate analysis, factor analysis, and cluster analysis.

Statistical Analyst, Chinese Academy of Agriculture Sciences-Beijing, China 09/2007 - 07/2010

Extensively investigated and analyzed statistical and programming problems utilizing SAS/SAS Macro,

SAS/SQL.

Wrote statistical analysis and results for various projects; ensured the integrity and accuracy of database

utilized in analysis through development of essential data cleaning and checks, and data back-ups by

SAS/SAS Macro.

Extensively involving in correlation analysis, multivariate analysis, cluster analysis, negative binominal

analysis, general linear analysis, decision trees, mixed analysis, and market model including supply and

demand model, partial/general equilibrium. Collaborated with team members; wrote statistical and market

reports; documented for internal and external clients.

Drafted and wrote proposals for grant and protocol usage. Provided customer/business owners ad-hoc and

business data for internal and external customers using SQL Server and SAS Enterprise Guide. Summarized

descriptive statistics and identified possible outliers through summary tables and graphs using SAS

procedures such as Report, Freq, Means, and SGpanel.

3

Contact this candidate