- Performed finance-related work as a Lead Finance Intern for three entities involved in a joint venture throughout Northeast and Central Ohio with collectively over 300 employees providing skilled nursing, physical, occupational, and speech therapies, geriatric care management and personal care aides- Analyzed marketing data, including the performance of correlation studies of marketing and sales staff activities in relation to account and patient referral acquisition to determine the efficacy of the sales cycle by an individual staff member- Analyzed account referral patterns, average reimbursement per patient for each account, and determination of costs based on acuity by patient and account to assist with internal ranking of accounts- Managed other interns in the performance of data analytics using Microsoft Excel and provided instruction on the use of Macro and VBA scripting, pivot tables/charts, and formulas and functions such as if/then statements, V/HLOOKUP, INDEX-MATCH, among others

- Filing and entering payables into Business Works database- Reconciling company credit cards- Comparing and analyzing relevant data - Created multiple excel programs designed to help sales teams create quotes more efficiently- Daily shadowing with the main accountant