Michael Swarts

Analyzes Navy civilian labor cost data and builds Power Query transformation processes to standardize inputs. Designs Power Automate workflows to refresh and distribute recurring cost reports.

Partnered with Postal IT managers to design project budgets and supported the steering organization in completing IT program budgets. Served as procurement analyst for IT personnel resources and delivered analysis and reporting tools for budget visibility.

Served as lead budget analyst for forecasting Pennsylvania Medicaid expectations for a risk-bearing Medicaid managed care plan. Built financial models, provided recurring analysis of revenue and margin trends, and produced dashboards and forecast reporting.

Analyzed state Medicaid annual rate changes and advised leadership on financial impact. Partnered to redesign reinsurance models and developed a monthly procedure for Medicaid POWER account balances, improving reporting accuracy.

Constructed medical analysis models to manage CMS requirements and monitored hospital performance metrics against benchmarks. Developed interactive Tableau tools for end users and provided data analysis for improvement initiatives.

Grade: 3.90

MBA in Finance and Information Systems from Pennsylvania State University with a GPA of 3.90.

Bachelor of Science in Business with a minor in Economics from Lock Haven University of Pennsylvania.