Data Analytics and Financial Analyst (Excel, VBA, SQL, R)

Eric Schmitz

Financial Analyst graduated from the University of Denver with a focus on the

intersection of Economics and Data Analytics. I’m seeking a job to combine my passion for policy and my experience with data analytics. 512-***-****

*********.*******@*****.***

EXPERIENCE

State Plan Financial Analyst- State of Colorado, Department of Healthcare Policy and Finance

November 2021 - Present

-Help create new medical benefits and determine the service’s fiscal impact and reimbursement amount

-Manage over eight different Medicare/Medicaid benefits including Behavioral Health, Durable Medical Equipment, and Dialysis

-Synthesize Colorado Medicaid policy with my own quantitative analysis to create a comprehensive reimbursement rate

-Lead my team in HCPCs rate setting every quarter where we build the rules and rates for every new Health First Colorado code

-Analyze bills drafted from the state legislature for their impact on the entire Finance Division

-Present and analyze reports to members of the Colorado Medicaid community and members of the State Joint Budget Committee EDUCATION

University of Denver, Political Science and Economics Majors September 2017 - June 2021

-Graduated with a 3.4 gpa and minors in international studies and public policy

-Capstone project analyzed the push and pull effects of Ukrainian migration to the Czech Republic and the impact of the 2014 Ukrainian Civil War

PROJECTS

Mobile Crisis and Secure Transport Benefit Creation

-Spearheaded the finance division team that created two brand new behavioral health benefits helping urban and rural Coloradans have access to mental health resources

Fiscal Note Process

-Reviewed over 100 bills through multiple iterations, determining their fiscal impact on the finance division

July 1 Fiscal Update

-Used SQL to simultaneously update over 22,000 different codes across SKILLS

SQL, VBA, and R Proficiency

Microsoft Excel Certification

Medicaid Management

Information System Expert

Fluency in legislative

processes and bill dissection

SME for multiple

Medicaid/Medicare benefits

including Durable Medical

Equipment and Ambulatory

Surgical Centers

Achievements

Selected for TCU Investor

Challenge from a pool of 40K

Spearheaded the creation of

the Secure Transport and

Mobile Crisis Benefit for

Colorado Medicaid members

Accepted to a competitive

study abroad program at

Charles University in Prague to

study the lasting economic and

policy effects of communism

Member of Delta Sigma Pi

Professional Business

Fraternity

every non-hospital benefit in the State

-Led the finance division in this process for the past 3 years

Contact this candidate