Curriculum Vitae
Summary
I am an enthusiastic and hardworking professional with data analysis and visualization experience in the healthcare insurance field.
Technical Skills
Programming, Analysis, & Visualizations
R | SQL | Python | SAS | VBA | Markdown | Tableau | Power BI | R Shiny | Quarto | Git | RStudio | Jupyter Notebook | Spyder IDE | GitHub
Database Mangagement
SSMS | GCP | Teradata | PostGreSQL | DuckDB | MS Excel | MS Access | Quickbooks | REDCap | Qualtrics
Other
Word | PowerPoint | Teams | Zoom | Outlook | SharePoint | Canva
Education
Bachelor of Science in Mathematics with an Emphasis in Actuarial Science and Mathematical Finance
University of Missouri | Columbia, MO (2018 - 2022)
Work Experience
Senior Analyst, Business Analytics
CVS Health (Aug 2024 - Current)
- Leveraged medical and pharmacy claims using an integrated R, SQL Server, and Tableau workflow to produce executive-level analyses, annual reports, and client presentations supporting the Accordant Complex Condition Management Program.
- Developed automated analytic processes, new client validation checks, and PDC-based medication adherence measures across member and client populations.
- Answered ad hoc inquires and evaluated program performance of client-specific pilot programs.
- Collaborated across product teams to deliver reports for Weight Management, Transforming Diabetes Care, Pharmacy Advisor, and Drug Savings Review.
- Identified and resolved data anomalies through exploratory analysis and comprehensive root-cause analysis, enhancing data quality, reliability, and stakeholder confidence in reporting outcomes.
Data Managment Analyst I
UF Department of Epidemiology (Nov 2022-Aug 2024)
- Conducted exploratory data analysis, statistical analysis, and data management for the All of Us database through the National Institute of Health.
- Created charts, tables, and other various visualizations to effectively present analysis for researchers and monthly data reports utilizing R.
- Provided statistical consulting to researchers and designed analysis workflows for them, and worked on creating materials to help them with the All of Us Researcher Workbench.
- Facilitated data consulting for investigators working on other projects from the CDC and NIH.
- Created interactive dashboards for tracking COVID-19 surveillance efforts.
Profit and Data Analyst Intern
Cox Automotive Inc. (June 2021-Aug 2021)
- Created weekly profit reports for each staff technician and documented weekly reported hours.
- Carried out quality assurance checks and filled out invoices.
- Calculated fuel usage metrics each week for staff technicians by validating gas purchase receipts.
Publications
Fenton MP, Swacil K, Striley CW, et al. Barriers to healthcare utilization among adults engaging in heavy drinking: Results from the All of Us research program. Prev Med. 2025;198:108356. doi:10.1016/j.ypmed.2025.108356
Scholarly Presentations
Click to Expand
LaMontagne L, Swacil K, Cottler L, et al. Pain and sociodemographic correlates of cannabis use among patients with insomnia in the ‘All of Us’ Research Program. Drug Alcohol Depend. 2025;267(suppl):112130. doi:10.1016/j.drugalcdep.2024.112130.
Fenton MP, Swacil K, Striley CW, et al. Barriers to healthcare utilization among adults engaging in heavy drinking: results from the All of Us Research Program. Prev Med. 2025;198:108356. doi:10.1016/j.ypmed.2025.108356.
Seegulam V, Swacil K, LaMontagne L, et al. Examining the associations of social determinants of health on lifetime non-medical prescription opioid use among older adults.
Seegulam V, Swacil K, LaMontagne L, Striley C, Cottler L. Sex differences in lifetime non-medical prescription opioid and cannabis use among older adults in the All of Us Research Program. Drug Alcohol Depend. 2025;267(suppl):111921. doi:10.1016/j.drugalcdep.2024.111921.
CV template created by: Piyush Chaudhari