Mackenzie Studebaker Email & Phone Number

Yarmouth, ME, US

• Deliver high-quality financial services to more than 30 external clients and 5 internal team members.
• Analyze client financials and classify accounts for clients for best reimbursement under governmentprogram rules.
• Compile and analyze financial and statistical information for both small hospital clients and largehealthcare networks to submit to government entities, including preparation of all expense, statistics,revenue, and.
• Create Settlement Comparisons customized for each client, analyzing projected vs. actual amountsreceivable or payable under certain government programs.
• Prepare annual Georgia Disproportionate Share Hospital Surveys and Hospital Financial Surveys fora wide range of clients, including Skilled Nursing Facilities, Rural Health Centers, Sole Community, andAcute Care.

Portland, Maine, United States

• Completed specific assigned responsibilities related to cost reporting through a combination ofMicrosoft Excel, EZ Workpapers, and Health Financial Systems software.
• Determined month-end contractual reserves and estimated third party receivables.
• Generated month-end financial analysis presentation for a PPS hospital in the system by accuratelyadjusting expected reimbursement and reserve amounts on Balance Sheet and P&L, based on contractedagreements with.
• Responsible for supporting and assuring accurate preparation and reconciliation of third party payerlogs, wage index contract labor, and related industry surveys using a combination of Excel, StrataDecision Technology.
• Enrolled facilities with out-of-state Medicaid and Medicare-replacement plans to ensure timely billingand reimbursement for provided medical services.
• Assisted in the completion of month-end accounts receivable analysis and yearly contractual allowancebudgeting.

South Burlington, Vermont, United States

• Prepared department for FY2020 Medicare Cost Report submission, reviewing and updating hospitalfinancial information in preparation for entry into HFS software.
• Inspired company to integrate HFS Software's Excel API Cost Report Tool with existing MedicareCost Report work papers, and spearheaded the effort to empower analysts to accurately share data on-demand between cost.
• Analyzed hospital data (finances, square footage, beds, births, etc.), and interpreted Medicare rulesto determine impact on hospital's finances and forecast Medicare Cost Report reimbursement.
• Facilitated collection of prior year Cost Report S-10 data for hired consultant firm.
• Reviewed and updated selected documentation to reflect current department processes.
• Maintained industry-related financial calculators to model potential impacts of changes betweenproposed and final rules, estimate returns from specific company programs, and determine net financial effect for year-end.

Portland, Oregon, United States

• Monthly closing for one hospital and a Visiting Nurses Association (Hospice) within the Legacy HealthSystem, to include the reconciliation and financial analysis of Medicare, Medicaid, Commercial, andGovernment.
• During Monthly Close, set account reserves via journal entries and investigated unusual account entries for explanations and accuracy.
• Presented reimbursement analysis of monthly closing data to hospital and system Finance executives.
• Prepared, reviewed, and filed annual Medicare Cost Reports for one hospital and two Rural HealthClinics (RHC's) within the Legacy Health System.
• Wrote and edited SQL and SQL-like reports for pulling and filtering large amounts of data.
• Tracked quarterly Medicare Credit Balance and RHC Wrap around payments, and ran PS&R data forall Legacy Health entities.

Portland, Oregon, United States

Portland, Oregon, United States