Financial Analyst
Current• Managed and audited the net revenue data of five hospitals weekly with total net revenue of up to $15 million for each facility while focusing on data integrity and accurate reports• Analyzed net revenue and payor allocation data to maintain average profit ratios and utilizing data to catch mistakes or unpaid charges up to $50,000 for various facilities• Automated reports using Power Query, SQL and UiPath to decrease auditing time by approximately 12% for weekly reports and created training and documentation necessary for the creation of new automation techniques• Created payor allocation models, reports, and auditing worksheets for over 30 total facilities by modifying existing models and adapting to various changes in net revenue principles as the fiscal year concluded