Alen Grey

ad4l7k@r.postjobfree.com

Professional Summary:

Over 7 years of experience in the Healthcare sector as Data Analyst, specializing in data analysis, validation, reporting, and visualization.

Domain expertise in the Healthcare, Insurance, and Life Sciences sectors.

Familiarity with medical coding systems and codes, demonstrating knowledge in the Healthcare and RWD domain

Proven track record in analyzing Real World Data (RWD) to generate Real World Evidence (RWE) aligned with study or research specifications.

Skillful in crafting simple to complex SAS programs and SQL queries, adept at fulfilling HEOR-related ad hoc requests.

Extensive hands-on experience with large RWD datasets such as MarketScan, Optum, IQVIA, Cerner, aligning with the SAP of HEOR Studies.

Proficient in fine-tuning and optimizing queries using various techniques, including macros and arrays, to enhance efficiency by minimizing processing time and memory usage.

Expertise includes merging SAS datasets, utilizing SAS procedures, data extraction and cleaning, macros, formats, functions, and comprehensive data manipulation and transformation.

Specialized in conducting statistical tests such as survival analysis, t-test, ANOVA, regressions, etc.

Excel proficiency, encompassing advanced functions, pivot tables, VBA, macros, and the construction of intricate models.

Exceptional analytical and problem-solving skills, showcasing a proven ability to provide logical solutions for complex problems.

Professional Experience:

BioXcel Therapeutics August 2021 – December 2023

HEOR Analyst

•Crafted datasets for analysis using SAS and PROC SQL programming, integrating diverse medical codes like ICD-10, NDC, CPT, HCPCS, etc., to establish cohort groups for Real-World Evidence (RWE) Studies.

•Collaborated with research, market access, and commercial teams to determine evidence needs throughout the product portfolio.

•Extracted, transformed, and modeled datasets from varied sources using SAS, Python, and PROC SQL codes, alongside analysis using visualization tools such as Tableau.

•Conducted Overall Survival analysis in line with the study design, employing methodologies like Kaplan-Meier curve model, Cox Proportional Hazard model, and Log-rank test.

•Utilized SAS procedures including PROC LIFETEST, PROC PHREG, PROC GLM, PROC REG, PROC CORR, PROC TTEST, PROC ANOVA for analysis.

•Revised and streamlined SAS programs and SQL queries, improving code simplicity and dynamism by incorporating macros and arrays.

•Produced reports and graphs depicting demographic and baseline characteristics, drug treatment patterns, healthcare resource utilization, lines of therapy, etc., derived from healthcare data.

•Presented Health Economics and Outcomes Research (HEOR) analysis findings and insights to cross-functional teams and leadership using presentations and dashboards.

•Scrutinized and debugged codes using options such as MPRINT, MLOGIC, and SYMBOLGEN.

•Conducted quality control checks on SAS programs and output produced by others.

Accenture Jan 2019 – June 2021

RWD Analyst

•Utilized the SAS PROC SQL pass-through facility to extract data from database servers, employing various SQL Joins and Unions to create SAS datasets.

•Developed complex programs using Base SAS and PROC SQL procedures for the extraction, cleansing, transformation, and structuring of diverse data types, including Electronic Health Records (EHR) records, member claims data, medication records, surveys, etc.

•Collaborated extensively with Market Access research teams, understanding objectives, addressing data quality issues, and discussing fixes and expected outcomes.

•Conducted statistical analyses as per requirements, demonstrating the ability to swiftly adjust programs as needed.

•Applied BASE SAS and PROC SQL Codes for observational and registry studies, working with diverse data sources.

•Customized cohorts and derived analysis parameters based on Real-World Evidence (RWE) study designs to meet objectives.

•Performed exploratory data analysis using descriptive statistics, leveraging SAS procedures such as PROC FREQ, PROC MEANS, PROC CONTENTS, PROC UNIVARIATE, and PROC SUMMARY to understand complexity and distributions.

•Executed statistical tests and analyses in accordance with the study design and Statistical Analysis Plan.

•Produced high-quality reports adhering to mock shells, utilizing PROC REPORT, PROC TABULATE, and ODS to generate output, graphs, and charts in formats like HTML, RTF, and PDF.

•Developed SAS programs for routine procedures and contributed to the program library by creating reusable macros and programming templates.

•Responded promptly to requests from other teams, creating ad-hoc reports and analyses in a timely manner.

Parexel Feb 2017 – Dec 2018

Healthcare Analyst

•Developed and implemented SAS programs, leveraging PROC SQL and Python procedures, to efficiently query, manage, and clean extensive datasets for HEDIS reporting measures. Analyzed resulting files, focusing on key metrics such as colorectal cancer screening, post-hospitalization follow-up, and the use of high-risk medications.

•Conducted ongoing tracking and reporting of Medication Possession Ratio (PDC) measures for cholesterol, oral diabetes, and hypertension, ensuring adherence to CMS goals for medication compliance.

•Applied advanced programming techniques with Base SAS, PROC SQL, and Python to extract, clean, transform, and structure diverse datasets, including Electronic Health Records (EHR), member claims data, medication records, and surveys.

•Collaborated with internal and external partners to execute activities related to the annual audit of HEDIS data and other metrics for regulatory compliance.

•Effectively communicated insights to stakeholders and senior-level audiences, providing valuable information on medication adherence compliance, identifying high-cost areas, and suggesting potential focus areas for quality improvement and cost reduction.

•Delivered regular reports of metrics and fulfilled ad-hoc requests for data and reports, ensuring prompt and accurate assistance to meet stakeholder needs.

Technical Skills & Certifications:

Programing Skills SAS, PROC SQL, SQL, Python, R, Stata

Skills and Tools Tableau, MS Excel (Advanced), Visual Studio, Eclipse, and NetBeans

Statistics and Modelling Statistical tests, Survival Analysis, Regression

Education:

Master of Science in Computer Science

New York Institute of Technology, USA

Bachelor of Technology in Computer Science

Ganpat University, India

Contact this candidate