Michael Vail Email and Phone Number
Michael Vail work email
- Valid
- Valid
Michael Vail personal email
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
-
Senior Manager Data And Analytics HmoBlue Shield Of California Apr 2021 - PresentOakland, California, Us -
Lead Data Analysis ConsultantBlue Shield Of California Apr 2018 - Apr 2021Oakland, California, Us -
Finance ConsultantHumana Feb 2016 - Apr 2018Louisville, 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 -
Finance AnalystHumana Jul 2015 - Feb 2016Louisville, 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. -
Business Financial AnalystThe Buddy Group May 2011 - Jun 2015Costa 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 -
Quality Assurance ConsultantThe Armory (Ad Agency + Production Co) Aug 2012 - Oct 2014Austin, 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 -
Project ManagerIppa, 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
-
Project ManagerPokerblue Feb 2005 - Feb 2007
Michael Vail Skills
Michael Vail Education Details
-
California State University, Long BeachFinance - 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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial