Epic Finance Consultant

• May 2020 - Present

Epic Finance Consultant

• Apr 2019 - Apr 2020

• Convert and automate enterprise level dashboard (Excel) with 30+ KPI’s and 200+ Metrics to Epic Radar Dashboard using custom SQL metrics developed from multiple data sources. • Support hospital finance team by maintaining existing reports and creating new SQL reports used to close month end books. • Lead remediation efforts for over 100+ financial reports and design project tracker as source of truth to help organize and support implementation of two new hospitals. • Convert and automate enterprise level dashboard (Excel) with 30+ KPI’s and 200+ Metrics to Epic Radar Dashboard using custom SQL metrics developed from multiple data sources. • Support hospital finance team by maintaining existing reports and creating new SQL reports used to close month end books. • Lead remediation efforts for over 100+ financial reports and design project tracker as source of truth to help organize and support implementation of two new hospitals.

Senior Business Intelligence Developer

• May 2015 - Mar 2019

• Design, code, develop, implement, optimize and support enterprise wide Revenue Cycle and Radiology dashboards/applications using third party BI tool (QlikSense). Adoption rates as a team have far exceeded expectations with a projected 25,000+ sessions (avg. 25 min per session) and 1000+ users per year. • Collaborate with Subject Matter Experts and Senior Leadership (C-Suite) to conceptualize engaging visualizations, promote data discovery, gather business requirements and test dashboards/applications. • Clean, analyze and manipulate large data sets from source systems to develop automated data extracts and deliver ad hoc data requests using SQL Server, QlikSense and Microsoft Excel. • Lead reporting education workshops training end users on operational workflows and business analytics to drive adoption of dynamic analytical reporting. • Participate in BI Administration and Project Planning workgroups to define project timelines and identify project tasks. Provide input on data structure design and optimization, style guide, best practices, data presentation, data dictionary and security structure. Show less

Senior Financial Analyst

• Jun 2008 - May 2015

• Prepared monthly reports that were distributed to Faculty Members and Senior Administrators. Reports include Physician Financials with Service, Payment, RVU, Clinical Productivity, Press Ganey and Clinical Efficiency analysis. • Led the preparation and submission of year-end close and operating budgets (FY12 – FY15) using Hyperion Planning and Microsoft Excel. • Monitored productivity and financial performance of the department and individual physicians by ensuring that expenses and revenues meet budgeted financial targets and all expenditures accrue to the appropriate cost centers. • Supported senior management with ad hoc reports, SFRAR’s, Pro Forma requests and revenue and expense projection models used to determine profitability of Faculty recruits. • Processed and reconciled daily/monthly cash deposits, purchases and vendor invoices as well as departmental request for payments, reimbursements and interdepartmental transfers. • Assisted with other administrative tasks such as tracking staffing costs and payroll as the department timekeeper, inventory management (procurement and reconciliation) and querying the General Ledger. Show less