Wayne Phillips, FMVA

 Analyze results and make recommendations to senior management  Develop dashboard reports for decision support  Analytics projects as requested by Chief Financial Officer, Chief Insurance Officer, and Reinsurance Director

 Set the tone for a continuous improvement culture by mentoring staff and by leading cross-functional automation workshops teaching Power Query and advanced Excel skills (dashboards, pivot tables, slicers, and complex formulas).  Frequent presenter and participant in senior management meetings (Board of Directors, Investment Committee, Audit Committee, Enterprise Risk Management Committee, Internal Controls Working Group, and 401(k) Plan Committee).  Oversaw the company’s annual statutory audits with KPMG (previously with EY)  Responsible for Process Owner Certifications including Visio workflow updates for investments, treasury, and taxes.  Developed three-statement forecast models including statement of cash flows (direct method), regulatory and rating agency capital models, and sensitivity testing of key planning assumptions.  Implemented a rolling five quarter financial forecast methodology so a “first detailed look” at the upcoming year would be available at the beginning of the annual planning cycle.  Managed performance of external investment portfolio managers (New England Asset Management and Conning Asset Management) and outsourced investment accounting provider (Clearwater).  Worked closely with the Chief Actuary on reinsurance placements and other Enterprise Risk Management (ERM) initiatives to ensure the reinsurance layers adequately balanced catastrophe exposures with risk tolerances and financial objectives.

 Presentation of monthly financial analysis of financial results to Corporate Controller.  Projected capital position and shareholder dividend capacity of operating subsidiaries to ensure efficient allocation of capital.  Designed “waterfall” section of Strategic Plan model to individually isolate the impact on Shareholder Value (economic value added) of changes in key financial drivers (membership, premium per member per month, medical loss ratio, etc.).  Provided support and training to business units for shareholder value calculations and concepts.  Developed “Capital Allocation Resource Template” used by business units to request approval for capital projects > $1 million.

 Advanced financial modeling, including development of Five-Year Operating Plan model (income statement, balance sheet and cash flow), scenario planning, acquisition analysis and lease versus buy analysis.  Prepared pro forma projections and analysis on two acquired companies during the due diligence and integration phases.  Key technical member of Finance team that converted spreadsheet forecasting models into Oracle Financial Analyzer (OLAP planning software). Design was flexible to handle both bottom-up and top-down budget approaches for 400+ cost centers.  Development of regulatory and rating agency forecast models (A.M. Best’s BCAR’s and NAIC’s Risk Based Capital).  Designed time/expense tracking and cost allocation database for the accounting of internally developed EDP software.

 Performed sensitivity analysis, cash flow projections, capital expenditure analysis, and net present value calculations.  Coordinated annual budget and salary review processes.  Preparation of Quarterly Financial Review presented by the Chief Financial Officer to the Board of Directors.  Preparation of monthly budget variance, production, agent/broker, and market shares reports.  Investment, fixed assets, payroll, and general accounting duties, including journal entries, reconciliation, and variance analysis.  Statutory statement preparation, statistical filings, and Department of Insurance compliance.