Over six years of experience in the HEOR/RWE space with proven expertise in RWE studies using SAS based on claims, EMR, and registry data. Rich background in categorical data analysis, survival analysis, randomized trial designs analysis, macro definitions, debugging programs, and documentation in both SAS and R programming environments. Expert in Advanced Excel/VBA including mastery of pivot tables, charts, functions, scenarios, macro creation, and more. Highly skilled at integrating programming skills, conducting analysis, adapting to new applications and platforms, and converting data from complex clinical systems.

Industry and Project Experience

This image has an empty alt attribute; its file name is Divider-1.jpg
Pharma Consulting Firm, Senior Associate, HEOR (Dec 2020 – Present)

DOMAIN IN R

⦿ Performed HEOR/RWE studies using MarketScan data.
⦿ Wrote, implemented, and tested various functions such as medication adherence and persistence. Developed functions to generate automatic reports resulting in reduced development time.
⦿ Performed treatment pattern and resource utilization analysis on MarketScan data.
⦿ Generated graphs and reports for analysis using various visualization and statistical packages.
⦿ Utilized knowledge of analytics and R programming language to create scripts capable of data access, manipulation, visualization, and reporting.

DOMAIN IN SAS

⦿ Performed quality checks of the analysis to validate it using various SAS modules and procedures.
⦿ Extensive programming experience in SAS tools including BASE/SAS, SAS/SQL, SAS/MACROS, and SAS/ODS.
⦿ Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, FORMAT, IMPORT, EXPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COPY, PRINT, and SQL.
⦿ Prepared reusable components and SAS Macros for automation of the application.
⦿ Developed SAS programs to analyze data for information stated in Analysis Plan.

Life Sciences Consulting Company, Senior Analyst (Feb 2015 – Oct 2020)
DOMAIN IN SAS

⦿ Strong experience in various SAS modules like SAS/BASE, SAS/ADVANCED, SAS/SQL, SAS/MACROS, SAS/GRAPHS.
⦿ Performed statistical analyses including survival analysis and statistical modeling of real-world data and clinical trials data.
⦿ Created customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
⦿ Wrote, implemented, and tested programs for populating reports and automated client reports using SAS Macro programs integrated with a variety of other programming languages.
⦿ Led the development of SAS code for modeling data and directed the implementation of SAS procedures such as PROC LIFE TEST (Survival Analysis), PROC MEANS, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC SQL, etc.
⦿ Meticulously analyzed and validated data sets and SAS outputs with other programmers’ outputs and mockups in Statistical Analysis Plan (SAP) using PROC COMPARE, PROC CONTENTS, and PROC FREQ.
⦿ Effectively managed and tracked all studies/analyses to ensure timelines were met and all stakeholders were aware of project status.

DOMAIN IN EXCEL/VBA

⦿ Analyzed qualitative and quantitative data quickly and accurately by employing statistical concepts.
⦿ Worked independently on ‘Immuno-Oncology Analytics Tool’ for the Immuno-Oncology database for the client.
⦿ Developed various internal analytics tools (Data Management Tool, Data Insight Tool, Survival Analysis Tool) to fetch data from different sources, compile it into one master file and analyze it in graphical format.
⦿ Generated code for report automation and data export to excel/deployment.
⦿ Conducted Microsoft Excel training for existing team members and new hires.

DOMAIN IN R

⦿ Developed model for Survival Analysis with KM cure.
⦿ Developed several apps using Shiny.

DOMAIN IN MATLAB

⦿ Portfolio optimization using simulations in MATLAB.
⦿ Dynamic revenue forecast models (including NPV and P&L) for marketed and pipeline products, with an option to add market events and analyze their impact.
⦿ Extensively involved in Data Optimization & GUI development and its implications using M.
⦿ Conducted training sessions for the user group for the report.

Electrical & Electronic Manufacturing company, Research (May 2013 – Jan 2015)

⦿ Worked with the core team and invented methods for interacting with MATLAB code.
⦿ Created advanced interactive evaluation chain writing and tested modular code.
⦿ Led projects from initial design stages to delivery.
⦿ Evaluated new code and implemented them into the UI.
⦿ Reviewed processed data and developed metrics; Programmed applications for complex mathematical solutions.
⦿ Integrated MATLAB with various applications.
⦿ Wrote a multitude of Excel VBA scripts and queries to compile and standardize raw data into a clean entry format.
⦿ Utilized VBA to extract data, perform analysis and develop reports.
⦿ Wrote various Excel VBA scripts and accessed queries to massage raw data from carriers across the globe, standardizing the data input format and using pivot tables/charts extensively for presenting various trend analyses.
⦿ Created user manuals, technical documentation and trained users on application use.

Technical Skills

This image has an empty alt attribute; its file name is Divider-1.jpg
Statistical Software: R Programming, SAS/BASE, SAS/GRAPH, Excel/VBA, and MATLAB.
Statistical Techniques: Survival Analysis, Categorical Analysis, Descriptive Statistics, InferentiaI Statistics, Graphical reporting, etc.
Database Management: SQL and MS Access.
Additional Software: MS Office

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
Bachelor of Technology, Electronics & Communication
Rajasthan Technical University, Kota, Rajasthan (2011)
AISSCE
P.M.H. School, Patna, Bihar (2006)
AISSE
St. Xavier’s School, Muzaffarpur, Bihar (2004)
Get The Latest Updates

Subscribe To Our Monthly Newsletter

No spam, only the content you’ll want to read.

Details about how we process your Information is available in our 

Privacy Policy

Watch our latest webinar

Strategic Planning for Medical Affairs

Featured Speakers

More Profiles

TO LEARN MORE ABOUT THIS OR OTHER AVAILABLE RESOURCES, PLEASE CONTACT

melissa

Melissa ArchuIeta

Director of Accounts and Resource Management