Michael Vail Email & Phone Number

Oakland, California, Us

Oakland, California, Us

Louisville, Kentucky, Us

• Manage 4 analysts who oversee 120,000 Medicare lives, $60 million of monthly capitation, andprovide analytical support to over 60 providers• Create financial models to determine and forecast most profitable markets of entry andappropriate pricing and expense ratios• Collaborate with Operations and Finance Director to improve and correct billing and expensingprocesses which resulted in $2 million in savings from errors• Revamp management reporting by implementing financial modeling capabilities includingautomation, optimized data queries, and validation checks to ensure data integrity• Develop and implement a business contingency plan including training and onboarding as wellas written procedures for reporting• Improve department response time to external client’s requests by 2 days through automationof reports and by developing future‐proof data pull queries

Louisville, Kentucky, Us

• Developed and maintained the Annual Enrollment Period forecasting membership report whichis used by senior leaders and multiple departments to predict sales, revenues, and profitability• Automated monthly reports utilizing custom VBA Macros resulting in a time savings of 60 hoursper month• Created SQL reference tables and scrubbed tables which allowed reports and analysis to bemore accurate and targeted to stakeholders’ needs and vision• Provided weekly SQL and VBA training to analysts to ensure standardization of queries, coding,and documentation.

Costa Mesa, California, Us

• Prepared actual-to-budget analysis and Excel reports on a weekly, monthly, and quarterly basis identifying areas for concern including department utilization or shortfall in revenues• Identified productivity and capacity constraints, calculated project break-even analysis, and conducted project postmortem analysis• Analyzed and forecasted company’s cash flow via modeling on a weekly basis to determine whether additional funds were needed to meet projected and actual expenses• Implemented audit process for external client billing, which resulted in $25k (8%) in additional revenue • Reduced risk within the billing process by implementing a checks and balances system that has resulted in no errors or missing invoices• Reviewed and analyze monthly income statement and balance sheet• Lead the Quality Assurance Department by completing all testing across various web and mobile based projects, created test plans and user experience documentation, and created training documentation for clients use of custom content management systems

Austin, Texas, Us

• Discovered, documented, and verified developer code errors on digital media website projects• Composed reports to the project manager of current project status and completion percentage concerning the testing phase• Developed quality assurance checklist test plans, user experience documentation, and documentation to create a best standard and practices testing methodology for The Armory• Completed Quality Assurance projects for clients: Wilson Baseball, Demarini, PEAK Antifreeze & Motor Oil, Plano Molding, and TORC series

• Managed a team of 6 individuals that worked together to create a video game project on a social networking site• Conceived and implemented a business plan, which contained all details of the game’s core features and projected budgets• Determined each team member’s weekly responsibilities, prioritized based on project timeline, and reviewed progress regularly with management• Constructed and presented weekly status reports to management, which analyzed overall efficiency of the project and provided possible solutions to setbacks with the creative or development.• Completed daily quality assurance testing to ensure the functionality of the game