Summary

Seasoned SAS-certified healthcare data analytics professional with 9 years of experience of delivering key insights to health services researchers, health plans, and physicians to improve clinical quality and financial outcomes. Progressive expertise in querying large administrative claims databases, statistical analysis, and mentoring data analysts to build their SAS and SQL expertise.

Primary expertise in the areas of:
• SAS Programming in a Windows-based environment (Data steps, PROC SQL, macros, macro variables, SAS/STAT, SAS/GRAPH, PROC SGPLOT, PROC REPORT, PROC UNIVARIATE)
• Business Intelligence Reporting via SAS Enterprise BI Server and Information Delivery Portal ( Dynamic Data Exchange, stored processes, SAS Management Console)
• Querying MS SQL Server relational databases and data warehouses (unique counts of patients/members; unique counts of health care services delivered; extracting patients with specific diseases and procedures via ICD-9, CPT, HCPCS, and NDC codes)
• Mining administrative claims databases of up to 100 million rows (medical/encounter/pharmacy/enrollment files)
• Conducting health outcomes analyses using statistical analysis (descriptive statistics, frequency distributions, Chi-square test for independence, linear regression, logistic regression)
• Mentoring data analysts to develop their SAS programming skills and SQL database querying skills

Secondary expertise in the areas of:
• CMS-HCC Risk Adjustment Model
• CMS 5-STAR Bonus Program
• Medicaid managed care
• Disease management
• Calculating HEDIS compliance rates
• Using SPSS to conduct statistical analysis
• Biostatistics and epidemiology
• Predictive Modeling
• Healthcare Information Technology

Notable accomplishments
• Three published abstracts in the supplemental issue of Gastroenterology in the areas of inflammatory bowel disease, colorectal cancer, and chronic hepatitis C that provided national visibility for the American Gastroenterological Association

Work History

Work History
2013 - 2014

Healthcare Strategic Analyst

Altegra Health

Responsible for using SAS and MS SQL Server to provide statistical analysis, data mining, and operational reporting to support strategic and operational decision-making to maximize reimbursement for Medicare Advantage health plans and prove the value of disease management services in improving outcomes in both Medicare and Medicaid managed care populations. Accomplishments include:

  • Building web-based Excel-exportable reports in SAS Information Delivery Portal to summarize and assess ROI of chart audit and coding projects on clients’ potential CMS reimbursement
  • Statistical analysis of member engagement with health plans on HEDIS compliance rates, inpatient/ER utilization rates, and receipt of an annual flu shot
  • Mentoring data analysts to improve their SAS programming and SQL database querying skills
2012 - 2013

Business Analyst, Healthcare Data Analytics

Inovalon

Responsible for using MS SQL Server to provide analytic and operational support for a product line focused on providing interventions for members of Medicare Advantage health plans. Accomplishments include:

  • Data set targeting a group of members to receive a member report card
  • Automation of monthly reports that summarized the amount and timing of interventions delivered to members of Medicare Advantage health plans
  • Mentoring data analysts to improve their SQL database querying skills
  • Training data analysts how to connect to MS SQL Server databases from SAS via ODBC configurations
  • Ad-hoc analyses delivered to internal and external clients in a time-sensitive environment
2010 - 2012

Business Analyst, Registries

Inovalon

Responsible for developing business requirements for the AGA Digestive Health Outcomes Registry in an Agile software development environment and using MS SQL Server and SPSS to provide statistical and ad-hoc analyses using registry data. Accomplishments include:

  • Successful management of product backlog in Team Foundation Server
  • Data flow diagrams, data dictionaries, use cases, user interface prototypes, and pseudo code
  • Performance measure development for inflammatory bowel disease and colorectal cancer screening
  • Analyses of claims/encounter/pharmacy/enrollment data using ICD-9, CPT, HCPCS, and NDC codes for studies on inflammatory bowel disease and colorectal cancer screening
  • Physician Quality Reporting System submissions for registry patients with Chronic Hepatitis C
2009 - 2010

Quantitative Health Analyst

Inovalon

Responsible for using MS SQL Server to provide analytical support to the Statistical and Actuarial Services department. Accomplishments include:

  • QA scripts for verifying accuracy of business intelligence reports
  • Serving as a subject matter expert for the data model used to support disease management outcomes reporting
  • Reporting on diabetes quality and outcome metrics through analysis of claims/encounter/pharmacy data and use of ICD-9, CPT, HCPCS, and NDC codes
2008 - 2009

Clinical Informaticist

DocSite

Responsible for providing analytical support for Physician Quality Reporting System submissions.   Accomplishments include:

  • Algorithm development for calculating performance and reporting rates
2007 - 2008

Health Data Analyst

Johns Hopkins Healthcare

Responsible for using SAS to conduct analysis and reporting for the Clinical Outcomes and Research team. Accomplishments include:

  • Analysis of physician performance within Johns Hopkins’ physician practices through analysis of claims/encounter/pharmacy data and use of ICD-9, CPT, HCPCS, and NDC codes
  • Graphics for costs savings evaluation of PPO product
  • Data dictionaries for data sets used in analysis projects
2005 - 2006

Presidential Graduate Research Fellow

St. Louis University Center for Outcomes Research

Responsible for using SAS to provide analyses to the department’s health services research projects.  Experience also included the opportunity to take courses in statistics and epidemiology.  Accomplishments include:

  • Literature review of claims-based analyses to assess outcomes in diabetes patients
  • Using SAS to conduct exploratory analyses of claims/encounter/pharmacy data on diabetes patients using ICD-9, CPT, HCPCS, and NDC codes
  • Abstraction of medical record data for a pediatric palliative care satisfaction study
2003 - 2004

Administrative Fellow

Cardinal Health System

Responsible for providing analytical support to the quality management department.  Accomplishments include:

  • Three-month projection of emergency department utilization
  • Leading a Failure Modes and Effects Analysis to improve accuracy of intake registration data
  • Leading a performance improvement team to reduce the use of restraints in patients with psychiatric disorders
  • Research on Malcolm Baldrige National Quality Award for senior management
  • Training users on a budget planning software application
2002 - 2003

Intern

SSM Integrated Health Technologies

Responsible for providing support to the HIPAA Project Management Office.  Accomplishments include:

  • Training course on HIPAA business associate laws
  • HIPAA compliance gap analysis
  • Business proposal for technology to standardize EDI transmissions
2001 - 2002

Research Associate

Health Capital Consultants

Responsible for supporting healthcare market research projects.  Accomplishments include:

  • Successful retrieval of accurate and relevant information on trends in physician specialties via print and web sources

Skills

Skills

Mentoring

Committed to helping data analysts develop their SAS programming and SQL querying skills Always willing to answer questions on simple, efficient commands to optimize the effort to produce analytics

Data Analysis

9+ years experience in analyzing large administrative claims databases (medical/pharmacy/enrollment) Table sizes up to 100 million rows

Reporting

  Business Intelligence Reporting via SAS Enterprise BI Server and Information Delivery Portal ( Dynamic Data Exchange, stored processes, SAS Management Console)  

Healthcare

Areas of expertise Medicare Advantage Risk Adjustment CMS 5-STAR Bonus Program Calculating HEDIS compliance rates and interpreting HEDIS technical specifications Malcolm Baldrige National Quality Award HIPAA Administrative Simplification Patient Registries Disease Management Inflammatory Bowel Disease, Colorectal Cancer Screening, Chronic Hepatitis C Biostatistics and epidemiology Predictive modeling  

Statistics

Descriptive statistics, frequency distributions, Chi-square test for independence, linear regression, logistic regression

SQL

  Six years of querying MS SQL Server relational databases and data warehouses Types of queries written: unique counts of patients/members; unique counts of health care services delivered; extracting patients with specific diseases and procedures via ICD-9, CPT, HCPCS, and NDC codes  

SAS Programming

  Data steps, PROC SQL, macros, macro variables, SAS/STAT, SAS/GRAPH, PROC SGPLOT, PROC REPORT, PROC UNIVARIATE Certified as a Base Programmer for version 9.1  

Education

Education
2005 - 2006

Post-baccalaureate coursework in biostatistics and epidemiology

St. Louis University School of Public Health
  • Introduction to General Linear Modeling
  • Applied Regression Models
  • Epidemiology Methods I
  • Epidemiology Methods II
  • Applied Epidemiology Methods

Portfolio