Blue Origin Presentation

Background

Hobbies

Coursework

• Econometrics (R)
• Advanced Econometrics I & II (R & MATLAB)
• Applied Regression Analysis (R)
• Statistical Computing with R (R)
• Statistical Computing with SAS (SAS & SQL)
• Statistical Analysis of Time Series (R)

• Computing and Machine Learning for Economics (Python)
• Evidence Based Decision Analysis ( Python)
• Python for Analytics (Python & SQL)

Coursework

Teaching Assistant

Cal Poly: 2020 - 2021

Achievments and Responsibilities:

Cal Poly

• Converted PDF homework assignments into R Markdown templates

• Designed and developed an anti-cheating program with R

• Facilitated daily online tutoring and mentoring services in Econometrics

• Responsible for grading homework and exams.

Senior Financial Analyst

UW Medicine: June 2021 - Present

Achievments and Responsibilities:

UW Medicine

• Led the financial planning and analysis function for a large healthcare organization

• Perform financial analysis, including compensation benchmarking, forecasting, and cost-benefit analysis

• Prepare monthly financial reports & KPI summaries for executive leadership

• Track and monitor productivity (wRVUs/CFTEs) among clinical providers

• Mentored and coached junior analysts to ramp up their productivity

Situation

• Department leaders would like to conduct a comparison of their providers' compensation and productivity to a national benchmark

• Third-party companies provide data on the distribution of salaries and productivity based on provider specialty (i.e. CPSC, AAMC)

• Compensation measured in $

• Productivity measured by wRVUs/CFTE

• wRVU = Work Relative Value Unit

• CFTE = Clinical Full Time Effort

Situation

Task

• Prepare individual department reports by combining internal data sources with third-party benchmarks

• Analyze the data we've prepared to determine the percentile at which each department's compensation and productivity currently reside

• Based on the findings, calculate how many $s and/or wRVUs would be required to raise underperforming departments to the 50th percentile

• Present the findings to leadership, using this analysis as a basis for initiating discussions on potential changes to compensation and work structure

Task

Action

• Joined CFTE and wRVU data from internal sources

• Combined internal data with third-party Party Benchmarks

• Assembled files for individual departments and sent to leaders for data review

• After obtaining approval from department leaders, used the distribution of productivity and compensation to find the department level percentiles

• Additionally, calculate the required productivity and funding level to bring underperforming departments up to the 50th percentile

• Final report summarizes compensation and productivity variances of each department, identifying high and low performing departments

Result

• Enabled leadership to determine the relative rankings of each department in terms of productivity and compensation

• Assisted in identifying the specific areas where improvement is needed

• Provided insights into the necessary targets for funding and productivity enhancement

• Identified the constraints that departments encounter when attempting to increase wRVUs and funding levels

• These constraints shed light on the challenges that departments face in scaling up their productivity and acquiring additional resources

Situation

• Tasked with creating a research question, reviewing current literature, collecting data, and performing an analysis to answer the question

• Data must be collected by yourself (i.e. web-scraping, government websites, third-party websites)

• Write a paper detailing your methods and findings, along with a discussion of published research currently covering the chosen topic

Situation

Task

• Research question: Does access to recreational cannabis reduce opioid related deaths?

• Need to know the year that cannabis became legal in a given state, total opioid deaths, and demographic information (i.e. Average income, unemployment rate, percentage of people w/o health insurance, etc)

• Perform an analysis to see if access to recreational cannabis caused opioid related deaths to increase/decrease

• Write a paper to summarize the results and methods

Task

Action

• Collected state-year level data from 2008 - 2018 to create a panel of all 50 states over this period

• Estimated a generalized difference-in-differences model using R to see if there was a causal effect between access to recreational cannabis and opioid related fatalities

• Wrote a paper to summarize my methods and results

Action

Result

• Showed that states with access to recreational cannabis can expect to see between 4-6 fewer deaths per 100K people, per year

• For reference, the state with the highest opioid death rate per 100K was West Virginia with 42 deaths/100K people

• Washington state had 9.5 deaths/100K people

• Received award for "Outstanding Senior Project", along with publishing on Cal Poly's website

Result