Tina Harper Email and Phone Number

Member of Senior Leadership Team directing all financial activities and managing 6 direct reports. Preparation of annual hospital budget, financial statements, oversight of all accounting, close collaboration with all hospital leaders to keep staffing model in line with budget per patient volume, Administrator on call duties.-Accounts Receivable – Created tools to monitor account status on all claims allowing for directed collection activities. Improved collaboration between key team members through regular strategy sessions. AR balances now at the lowest point in over a year.-Innovation – Transformed outdated hospital tools enabling enhanced patient care coordination throughout the hospital. Overhauled patient account audit process from individual paper form to shared Excel workbook greatly reducing time spent in audit, improving the accuracy of patient accounts and reducing paper waste.-Team Education – Provided training to my team, peers, and other key staff members during Office 365 roll out. Taught staff accountant and accounts payable how to utilize advanced features of Excel.

Oncology Research program conducting 180 active clinical trials across 6 facilities in Arizona and ColoradoLeader providing overall direction of finance functions to support the achievement of program strategic objectives-Accounts Receivable – Developed new tools and guidance for team and increased payments collected by 52% in first year in role. Balances over 180 days past due reduced by 22 percent.Re-design of all Reporting – Utilized ETL to leverage available software tools to revamp all research finance reporting – resulting in a 50% reduction of time spent updating reports and increased accuracy by removing manual steps. -Charge Analysis – Developed claims analysis to evaluate which research charges were not processed correctly to the department. Provided direction to billing department on how to correct resulting in $4 million in corrections in our favor-Compliance – Ensure compliance with clinical trial contract agreements, Human Research Protection Program, company fiscal policies, and GAAP. Implemented new revenue journal entries to adhere to GAAP guidance on revenue recognition. Established weekly process to check Clinical Research Coordinators correctly log required visit and patient information.-Collaboration – Provide research finance onboarding overview for oncology research new hires, work with all oncology research leaders to achieve department goals, communicate with clinical trial sponsors, share best practices across other Banner Research departments, and provide research financial data and narratives with variance explanations to BMDACC leadership, Banner Corporate Research, and the individual facilities where our clinical trials are conducted.-Team Growth & Development – Manage 5 direct reports, quarterly individual meetings focus on their career development and goal setting, provide learning opportunities with external departments, individual and team training

Financial Planning & Decisions Support team member devoted providing analytical support to corporate leadership and facilities -Stewardship Reporting – Manage the production of monthly stewardship reporting for all acute facilities and medical groups; produce all reporting/slide decks from FPDS, significant improvements to existing reports, thorough review of all slide decks prior to release to entities.-Service Line Stewardship Reporting – Played significant role in development of this reporting for all standard service lines, developed separate Banner MD Anderson Stewardship Reporting-Stem Cell Committee Analyst – May 2019- Jun 2020, a committee mirroring the activities that occur in Surgical Stewardship meetings to tighten financial soundness of stem cell program. Discovered high cost genetic chimera lab tests were not being paid by Medicare due to incorrect billing practices which led to correction of the problem -Budget Report Development – Significant report building expertise contributing to development of multiple budget tools in 2019 and 2020, including BAT, DDT, Other Income-Expense Upload and Med Supplies Upload Tools, and Flex Forecast Tool. Built macros to enable production of reports for 30 separate facilities.-Ad Hoc Reporting – Compilation of data for pediatric cardiology program survey questions for multiple entities; develop methodology for identifying COVID-19 pts in cost accounting system through study of CMS documentation, cost analysis of COVID-19 patients with evaluations of vent days, patient days, drug cost; -Staff Training – Developed presentation and hands on examples to introduce analysts to Excel Add-ins: Power Query and Power Pivot, trained Decision Support and Budget departments and select analysts throughout Banner

- Physician Productivity Dashboard – Build analysis in multiple source data warehouse environment to display surgical oncology group productivity dashboard showing charges, hospital admissions, wRVU comparisons to MGMA, and month and year trends, macros produce the 50+ monthly productivity and procedure/E&M detail reports in minutes for individual surgeons and surgical groups.- Productivity Management – Identify opportunities for department leaders to improve productivity and performance, including improved charting education for nurses, additional management training for lower level managers. Evaluate whether hospital departments should add staff to meet budget and volume. Developed tool to forecast based on run rate or select historical or budget data for projections for both volume and work hours.- Oncology Care Model (OCM) Data Analyst, Value Committee Analyst - Thorough review of Medicare OCM participation agreement, CMS documentation, and participate in multiple CMS webinars to gain understanding of the OCM program. Provided analytical support to Value Committee evaluating patient outcomes- OCM Beneficiary Identification - Worked with OCM team – tumor registrars, nurse coordinator, and POS charge specialist to revamp process of OCM beneficiary identification. Wrote SQL queries, NextGen reports, and McKesson worksheets to pull more accurate data and assembled reports in Excel. Wrote M queries in Power Query to merge data, identify qualifying ICD-10 diagnosis codes, eliminate disqualifying comordities, added additional information to make reporting more accurate and efficient for other team members. Patient Upload errors to CMS Data Registry dropped from over 50 percent each month to near zero percent with the implemented changes. Expect MEOS recoupments to drop significantly- Oncology Grand Rounds Presentation – Role of Data Analytics in Evaluating Clinical Delivery of Care – Clinical outcomes: risk factors for increased emergency use for oncology patients.

State Projects: (California, Georgia, Maine, Mississippi, New Mexico, Hawaii, Oregon, Virginia, Arizona, and Indiana), such as: ¨ Help to create win-win situations to guide new rates. Present findings and solicit feedback to providers/stakeholder groups throughout process, followed by in-depth survey to gather service-delivery cost information and data analysis for average wages, productivity, and more. Prepare fiscal estimate of new state budget and adjust as warranted. ¨ LEAD ANALYST: Home and Community-Based Services (HCBS) Provider-Rate Study, State of California: - Convert SAS datasets into multidimensional data model cube for processing analyses in Excel.- Reviewing rate variations numbering in the hundreds of thousands for over 60 service codes which vary by region.- Produce service utilization reports by twenty-one regional centers for each service included in the study.- Develop rate and unit type key to assign unit type to 33 million claim lines as California HCBS claims data does not include unit type.- Create maps identifying the regional centers and minimum wage deviations.¨ LEAD ANALYST: HCBS and Employment Services Provider-Rate Studies (for CMS approval), State of Oregon: - Wrote provider studies, conducted analyses, presented custom reports to stakeholders, co-developed rate models, and prepared fiscal estimates to guide programs changes intended to eliminate CMS non-compliance issues.- Conducted geographic analysis of driving distances between member residence and services. Identified lack of behavioral health (BH) services in rural areas that led to higher rates to incentivize BH providers in target areas.- Mined data from census and determined fair-market service rates also affordable to state and target population.- Employment rates implemented 2015; currently working on HCBS draft rate review process for IDD population.

 Responsibilities include financial statements, consolidated statements, cash flow and variance analyses, general ledger, journal entries, accruals, month-end close, account reconciliations, ad hoc reports for senior management, & process improvements Full budgeting process for 50+ departments in EPM software & capital budget Top Excel expert on staff: consulted by all levels from IT to the President and CFO for project work Municipal Market Access) Disclosures, state/city use tax reports Major contributor for audit prep, federal tax return prep and tax return review  Fixed Assets and Depreciation in four separate companies.  Reconciliation of A/P and Inventory modules with General Ledger. Audit of internal inventory count. Manage Other Revenue - invoicing, collections, and internal reporting on aging AR

 Streamlining accounting processes and data management procedures across multiple departments by converting a manual system of paper forms into a technology-driven process of Excel templates and Business Intelligence Software Facilitating data import into accounting and other software databases Utilizing Business Intelligence software to improve reporting and data tracking  Designing budgeting and forecast templates in Business Intelligence module Assisting with Budgeting and Forecasting

Bank reconciliations, account reconciliations - including bringing backlog of reconciliations current, researching and correcting long term errors, maintained multiple entities & intercompany account reconciliations, short-term coverage of controller duties including monitoring and reporting of cash balances and outstanding checks to presidentState/city use tax reports in AZ, A/P, set up fixed assets/depreciation and implemented a software upgrade, prepared audit papers and worked with external auditors, issue 1099's, completed month end journal entries, issued financial statements, variance analysisNon-profit accounting, recording fund donations & pledges, special projects included developing new procedures for recording, filing and managing gift-in-kind inventory in a coordinated effort involving several departmentsPeriodic review of outstanding A/R and followed up on resolution of issues with responsible departmentPayroll, and Human Resource duties such as new employee orientation, benefits, exit interviewsStreamlined expense report procedures and trained staff to use new spreadsheet format, resulting in fewer errors and faster input, saving hours of data entry time each month, implemented this technique in other areas of A/P for additional improvements in accuracy and speedNote in 2007, 2008 performed contract work on as needed basis only

Remotely from home office performed bookkeeping for multiple companies, payroll, payroll tax reports/payments, set up new companies in QuickBooks, bank reconciliations, state/city sales tax reports in AZ

Performed bookkeeping for several companies with multiple locations, set up a new company, inter-company transfers, bank reconciliations, state/city sales tax reports in NV, NM and AZIssued financial statements, managerial reports, and bankruptcy court monthly operating report

Corporate accounting, work with external auditors, 401(k) year end accounting, sales tax reportsAccounting manager for real estate division, budgeting, leases, sales, property improvements Month, quarter, and year end close; divisional, corporate, and consolidated financial statementsSpecial projects include developing a spreadsheet to transform sensitive payroll data into journal entries of a readable file format for accounting softwareFixed assets and depreciation for eight locations - overhauled filing system for fixed assets to accommodate auditors requests for data, resulting in dramatically reduced time spent providing information during the following audit

Journal entry, month end close, financial statements, account reconciliation, sales tax reports, AR reports, purchasing proposals, special projects, problem resolutionManage president's extensive personal finances, including financial statements, payroll, budgetingMaintain AS400 & PC's, troubleshooting, train users, day end and month end closes and saves

Computer programming, database and spreadsheet management, data analysis of trading systemsBookkeeper, financial statements, payroll, employment tax reports, AP/AR, deposits, budgeting Manage office, maintain compliance with Commodity Futures Trading Commission and National Futures Association regulations

'95Chicago Board of Trade - back office operations clerk, runner on grain and bond trading floors and in the meats at the Chicago Mercantile Exchange