• Data visualization (charts, graphs, dashboards, automation)• Create & manage budgets for 30 senior living centers (Independent, Assisted, Memory Care, Skilled) • Financial reporting for internal and external partners• Integrate and align new financial systems• Financial analyses, audits, debt service calculations

Financial Analyst: Support corporate financial department • Manage Blackline reconciliations for 40 commercial business teams ($137M/mo). Coordinate General Ledger tie outs, management reviews, discrepancy resolutions.• Manage General Ledger reporting for two lines of business with $90M/mo revenue. Treasury / bank reconciliations for Wells Fargo and Cybersource payment processing (credit card, EFT, checks, refunds, returns, etc). Resolve all outstanding accounting issues within 30 days. Coordinate check escheatment. Create journal entries and reconciliation items for General Ledger suspense accounts. Utilize data warehouse and Access databases to combine millions of datasets to apply and verify monthly member premium payments. • Receive and record CMS Risk Adjustment monthly payments ($20M-$40M) and apply to state health plans using complex Excel macros, pivot tables and formulas. • Create account reports and reconciliations for these projects and provide to senior management to assist Actuary in forecasting future network utilization and rates.• Created & implemented SOX-404 audit project and trained five employees to review third party accounting practices for Affordable Care Act health-exchange members, coordinate annual corporate audit processes.

(Coventry was acquired by Aetna in 2013)Health Insurance AuditorTPA First Health Audit Program:• Creation and implementation of network access audit program designed to ensure that clients are providing an accurate count and payment for lives with access to the First Health provider network, and that claims are being reasonably submitted and processed. • During that time I found $220,738.44 in lost revenue and successfully recovered $142,877.16 from erroneous data and fraudulent network use/abuse. • Creation of MS Access database to produce monthly A/R Base & Adjustment Report of transactions and tracking for 320 clients with 8000+ subgroups.• Expert level and daily use of MS Access, Excel, Outlook, Power Point, and Word, as well as internal revenue and claim tracking programs.HPS / Coventry Health Plan Audit Program:• Creation and implementation of A/R cycle audit program designed to evaluate billing and revenue report accuracies. In depth data mining via use of Excel formulas and pivot tables to obtain errors and provide statistics to management for: previous, current, and future agings, billings, cash received, refunds, returns, and adjustments. • Internal program controls created for and with SOX 404 guidelines.

Bilingual (English/Spanish) Financial Counselor Supervisor (2002-2011): Manage team of 12 financial counselors throughout Utah• In-house hospital financial counselor and supervisor in charge of high dollar ($100k+) self-pay accounts at the University of Utah, Mountain West Medical Center, LDS Hospital and Intermountain Medical Center.• Dedicated to efficient A/R processes, account auditing, data mining and state eligibility programs to recover lost revenue from self-pay hospital patients. • Coordinate financial and discharge processes with hospital management and state caseworkers to secure funding for patients while still in-house.• Review staff workloads, goals, and priorities to increase productivity from 40 to 60 accounts per day, and from 80 to 125 accounts funded per month. Audit accounts and provide recommendations for QA/QC improvements.• Subject matter expert: Medicaid, Medicare, Social Security, Crime Victims and various other state indigence eligibility programs. • New employee training: hospital staff, account representatives, new SME’s, QA team.