Daniel Harrell Email & Phone Number

• Provided monthly FP&A for the company’s Pharmacy Services Division, as well as supporting junior analysts with their assigned division reporting• Helped oversee budget planning and development process for a division with over 700 employees and $100M+ in annual spend• Worked with business partners to provide financial analysis for new contracts and projects• Acted as the contact point for details regarding the company’s PBM contract, including providing regular updates to executive leadership on performance related to contract terms

Portland, Oregon Area

- Supervise accounting processes related to the Company's prescription drug claims, direct investment portfolio, and one of the Company's start up entities- Responsible for reviewing and posting journal entries, as well as reviewing and approving of account reconciliations- Work with business partners to ensure that details regarding drug claims and rebates are well understood and properly incorporated into various actuarial and budgetary processes and estimates- Collaborate with finance team members on the valuation process for a portfolio of $60M worth of direct investments- Complete accounting research, analysis, and documentation regarding the necessary accounting treatment for each direct investment

Portland, Oregon Area

- Responsible for journal entry preperation, and related account reconciliations for the Company's prescription drug claims- Improved, and in some cases redesign, processes related to accounting for drug claims and rebates- Developed in depth monthly analysis to detail trends in claims costs and rebate projections across multiple businesses and product lines- Completed ad hoc management analysis requests related to budget vs actual performance, contractual vendor payments, and drug rebate performance

Portland, Oregon Area

- Subject matter expert for consolidation of all 30 entities under the Company's umbrella.- Completed a year long project to learn, document, and revamp the consolidation system to remove years of equity method accounting for wholly owned subsidiaries, as well as make other improvements and error corrections.-Responsible for journal entry preparation, and related account reconciliations.-Assist in developing budget and reforecast amounts related to inter-company activity, gain/loss on sale of assets, and other income, among other things.- Review asset purchases and help oversee fixed asset accounting and reporting

Boise, Idaho Area

- Performed audits of University-Wide, and Departmental, controls and processes- Independently completed all phases of assigned audits, including planning, audit testing and report issuance- Worked with Department Managers in a consulting capacity to develop improvements for current processes and controls- Performed follow-up engagements designed to asses process and control changes- Wrote audit reports, both collaboratively and individually, to inform University Management and the Idaho State Board of Education of any audit observations and recommendations- Assisted audit management with annual risk assessment used to develop annual audit plan for the University- Participated in fiscal misconduct and fraud reviews conducted by IAAS

Master Of Science (Ms), Accounting

Bachelor Of Business Administration (Bba), Accounting