Michael Vail

Michael Vail Email and Phone Number

Senior Manager Data and Analytics HMO at Blue Shield of California @ Blue Shield of California
Michael Vail's Location
Irvine, California, United States, United States
Michael Vail's Contact Details

Michael Vail personal email

n/a
About Michael Vail

It wasn't until my early 20's when I was showing a friend my personal budget excel sheet and all the exciting things it was capable of computing that I truly realized I had found my passion for analysis and modeling. I quickly mastered VLookUp, IndexMatch, Pivot Tables, and VBA to improve my Excel skills and automation. I picked up SQL to improve my database queries and technical background. I further honed my overall skills through Quality Assurance and Project Management which provided me with a foundation necessary to become the Financial Analyst I am today.Skills: Excel, VBA, Access, SQL, PL SQL, SAS, JavaScript, HTML, CSS, PowerPoint, Google Sheets, Salesforce

Michael Vail's Current Company Details
Blue Shield of California

Blue Shield Of California

View
Senior Manager Data and Analytics HMO at Blue Shield of California
Michael Vail Work Experience Details
  • Blue Shield Of California
    Senior Manager Data And Analytics Hmo
    Blue Shield Of California Apr 2021 - Present
    Oakland, California, Us
  • Blue Shield Of California
    Lead Data Analysis Consultant
    Blue Shield Of California Apr 2018 - Apr 2021
    Oakland, California, Us
  • Humana
    Finance Consultant
    Humana Feb 2016 - Apr 2018
    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
  • Humana
    Finance Analyst
    Humana Jul 2015 - Feb 2016
    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.
  • The Buddy Group
    Business Financial Analyst
    The Buddy Group May 2011 - Jun 2015
    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
  • The Armory (Ad Agency + Production Co)
    Quality Assurance Consultant
    The Armory (Ad Agency + Production Co) Aug 2012 - Oct 2014
    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
  • Ippa, Inc
    Project Manager
    Ippa, Inc Oct 2009 - Jan 2011
    • 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
  • Pokerblue
    Project Manager
    Pokerblue Feb 2005 - Feb 2007

Michael Vail Skills

Quality Assurance Digital Media Analysis Management Software Documentation Social Media Marketing Digital Strategy Data Analysis Project Management Training Microsoft Excel User Experience Web Project Management Marketing Strategy Strategic Business Initiatives Financial Reporting Strategic Data Analysis Budgets Financial Modeling Ms Excel Pivot Tables Vba Mysql P&l Analysis Cash Flow Forecasting Break Even Analysis Financial Analysis Online Advertising

Michael Vail Education Details

  • California State University, Long Beach
    California State University, Long Beach
    Finance - Investments

Frequently Asked Questions about Michael Vail

What company does Michael Vail work for?

Michael Vail works for Blue Shield Of California

What is Michael Vail's role at the current company?

Michael Vail's current role is Senior Manager Data and Analytics HMO at Blue Shield of California.

What is Michael Vail's email address?

Michael Vail's email address is mv****@****ana.com

What schools did Michael Vail attend?

Michael Vail attended California State University, Long Beach.

What skills is Michael Vail known for?

Michael Vail has skills like Quality Assurance, Digital Media, Analysis, Management, Software Documentation, Social Media Marketing, Digital Strategy, Data Analysis, Project Management, Training, Microsoft Excel, User Experience.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.