Daniel G.

I am a Senior Clinical Analytics Specialist with extensive experience in healthcare data, retail data, and Epic systems. My expertise spans multiple areas of data analysis and reporting, allowing me to deliver accurate and insightful solutions tailored to your business needs. Key Qualifications: - Certified in Epic Clarity, Epic Caboodle, Revenue Integrity Data Model, Health Information Management Data Model, HB Revenue Cycle, Health Plant (Population Health) and more. - Also, Tableau Desktop Certified and Oracle SQL Expert-level Certification, with advanced knowledge in data querying and database management. - Proven track record of providing data-driven insights and implementing effective analytics solutions across various Epic modules and healthcare systems. - Skilled in optimizing workflows, streamlining data reporting, and improving healthcare information management. With several years of experience in healthcare and retail data analytics, I am well-equipped to handle complex data challenges quickly and with precision. My deep understanding of Epic modules and healthcare information management enables me to support your projects efficiently, ensuring the best outcomes. Example of top 15 high-impact Epic Clarity / Caboodle highly complex and important queries I have developed and delivered to HIM, Revenue Cycle, Compliance, Operations, and Clinical Leadership teams to support strategic organizational decisions: 1. Days in Accounts Receivable (AR Days) o Purpose: Measures the average number of days it takes to collect payment after a service is provided. o KPI: Average AR Days (target often < 45). o Example: Used by the CFO to monitor billing efficiency and cash flow performance; includes DNB balances and total charges. 2. Revenue Integrity Charge Reconciliation o Purpose: Identifies missing, delayed, or incorrectly billed charges. o KPI: Charge Lag, Missing Charges, Late Charges. o Example: Reconciles performed procedures with missing CPT/HCPCS codes or charges not posted within 3 days of service. 3. Claim Denials and Rework Report o Purpose: Analyzes claims denied by payer, department, denial code, and user. o KPI: Denial Rate, Rework Volume, Avoidable Denials. o Example: Revenue cycle leadership uses this to identify patterns and reduce future denials. 4. Release of Information (ROI) Turnaround Time o Purpose: Measures the time from receipt of a medical records request to fulfillment. o KPI: Average Fulfillment Time, Compliance with 14-Day Rule. o Example: Used by HIM leadership to evaluate vendor or internal HIM team performance and HIPAA compliance. 5. HIM Deficiency Tracking Report o Purpose: Tracks outstanding physician documentation deficiencies post-discharge. o KPI: Days to Completion, Deficiency Type, Suspended Charts. o Example: Supports physician follow-up and HIM compliance audits. 6. Patient Throughput and Length of Stay (LOS) Analysis o Purpose: Evaluates inpatient and observation LOS to optimize care efficiency. o KPI: Avg LOS vs. Expected LOS, ED to Bed Time, Discharge Delays. o Example: Used by quality teams to identify throughput bottlenecks and reduce readmissions. 7. Clinical Documentation Improvement (CDI) Query Tracking o Purpose: Tracks CDI queries, response times, and financial impact. o KPI: Query Response Rate, MCC/CC Capture, DRG Impact. o Example: Helps CDI teams quantify impact and target provider education. 8. Payer Mix and Financial Class Analysis o Purpose: Breaks down accounts by payer type and financial class. o KPI: % Medicare, Medicaid, Commercial, Self-Pay. o Example: Finance uses this to adjust for shifting reimbursement trends. 9. Hospital-Acquired Conditions (HAC) and Patient Safety Indicators (PSI) o Purpose: Identifies reportable safety events impacting CMS reimbursement. o KPI: HAC Rate, PSI 90 Composite. o Example: Supports Quality Improvement initiatives and risk mitigation. 10. Late Charges and Charge Lag Report • Purpose: Identifies charges posted after service or discharge dates. • KPI: % Late Charges, Average Posting Lag. • Example: Used by Revenue Integrity to reduce revenue leakage by targeting specific departments. 11. Patient Access Performance Dashboard • Purpose: Measures front-end operations including registration accuracy and authorization delays. • KPI: Clean Registration Rate, Authorization Turnaround Time. • Example: Helps Patient Access leadership monitor staff performance and minimize billing holds. 12. Revenue Integrity Charge Capture Dashboard • Purpose: Tracks undercoding, charge edits, and delayed entries across service lines. • KPI: Missed Charges by Dept, CPT/Rev Code Mismatches. • Example: Ensures completeness of charge entry across all care settings. 13. Inpatient Coding Productivity and Quality Dashboard • Purpose: Monitors coders' workload, accuracy, and audit outcomes. • KPI: Charts Coded per Day, DRG Accuracy, Query Rate. • Example: Used by HIM managers for staffing and productivity benchmarking. 14. Audit Trail and Record...