Evan Moore Email & Phone Number

Denver, CO, US

London, GB

New York, NY, US

• Oversee a team of 10+ individuals working on client-facing engagements in the Deal Advisory and Strategy Analytics practice.
• Day to day responsibility for healthcare industry engagements that create analytics to help clients understand their performance relative to peers, how to improve, and how to grow.
• Created a revenue forecasting methodology for a risk-bearing medical group active in the Medicare Advantage market, re-building Medicare’s risk scoring algorithms that drive capitated reimbursement using Alteryx and.
• Developed a Databricks pipeline to ingest and transform client medical claims and transactional data into a custom accounts receivable dataset. Modeled the AR dataset as an absorbing Markov chain using custom Python.
• Helped guide the RFP process for the team’s largest 3rd party data expenditure (Commercial Medical Claims), serving as a key stakeholder with respect to product functionality and fit.

New York, NY, US

• Lead analytic workstreams on engagements, working both as an individual contributor, and overseeing and mentoring junior team members.
• Built member-level medical expense and revenue time series out of a risk-bearing provider group's claims and premium data, using Alteryx for data cleansing and normalization, and DAX/Power BI as a modeling tool. These.
• Wrote complex SQL queries against commercial and Medicare FFS claims data stored in Snowflake instances and Delta Lake tables to create analytical data pulls that powered insights around trends in commercial.
• Working cross-functionally with the Due Diligence practice, wrote an Excel VBA program to automate the creation of standardized revenue forecasting tools.
• Served as resident expert and on-boarding resource for all new co-workers as the team grew from two to 12 individuals.

New York, NY, US

• Used ETL tools, including Alteryx and Python, to ingest, clean, standardize, and enrich large claims andfinancial transaction datasets.
• Use these cleaned datasets to answer client questions around the health of the business, e.g. estimatedcollections on open A/R accounts, provider productivity.
• Worked alongside Strategy and Management Consulting counterparts to analyze provider availability templatesand visit data out of Epic instances for several large health systems. This analysis helped provide a view.

St. Louis, MO, US

• Supported the Revenue Cycle Management team at the largest health system in Missouri
• Maintained a portfolio of KPI and operational reports at daily, weekly, and monthly cadences that were distributed to audiences at all levels of the organization, from VP and hospital leadership to individual billing.
• Supported executive leadership’s key initiatives with custom Tableau dashboards and ad-hoc SQL queries.
• Wrote and optimized SQL stored procedures to replace manual queries in the data warehouse, reducing errors and hastening the report creation process.