Inform Diagnostics Senior Revenue Analyst / RCM Data Analyst
Oct. 2014 - Apr. 2018Irving, Texas- Primarily Responsible for Accurate Revenue Recognition, including:
o Monthly revenue close process, data integrity verification and journal entry preparation using SQL queries, Power Pivot, SmartConnect, GreatPlains and deFacto
o Monthly extraction, formatting and verification of data for reporting cube
o Extensive utilization of SSMS and SQL logic for reporting and variance analysis SQL
o Quarterly audit preparation and documentation, including reconciliation of transactional detail to financials and other reports
o Monthly AR and Cash Reconciliations Reporting
o Weekly Refund Processing - Modifying and optimizing processes, reports, and SQL scripts for Revenue Cycle, including: o Creation of Managed Care team SharePoint portal, including data integration / standardization, workflow automation, form creation, etc.
o Redesigning AR and Cash Reconciliation files used monthly to use more formulas and links; Redesign reduced time required for completion from several business days to approximately one business day in addition to increasing accuracy and readability.
o Reconstructing month end and flash files (Case Volume Report, End of Month Estimate, Accrual, Revenue Walk, Revenue Variance) to run more smoothly and quickly as well as reduce file size, while better meeting the needs of end users
o Optimizing weekly refund and vendor SQL queries and process
o Integration of acquisitions and new business lines into the MLS Revenue Process for close, flash (pre-close) and audit - Working with treasury and cash applications to reduce average monthly cash reconciling items by 90%
- Creation of Revenue Specific deFacto reporting cube and associated reports, including reports utilizing both GAAP and JGAAP requirements, reports by payor as well as business line, time comparitive reports, quarterly summaries, and audit reports
- Assisting other team members and/or training as needed with Excel, PowerPivot, and deFacto questions, issues and troubleshooting