Taylor Lightfoot

mail@taylorlightfoot.com


https://www.taylorlightfoot.com | https://www.linkedin.com/in/gtlightfoot

PROFESSIONAL SUMMARY

Certified SAS programmer with over 10 years of experience in analytics fields. Proven ability to solve complex problems through advanced macro programming and data analytics techniques.

WORK HISTORY

Florida Blue (Blue Cross Blue Shield of Florida) – Jacksonville, FL

Senior Health Business Analyst, 12/2021 to Present

  • Promoted to lead position, creating monthly reports on the coding effectiveness of healthcare providers and value-based groups delivered to senior leadership, provider educators and approximately 150 provider groups.
  • Programmatically generate data visualizations that communicate the performance of health care providers using SAS, SQL and VBA.
  • Identify membership for prospective and retrospective Medicare risk adjustment campaigns, calculating expected ROI and summary statistics.
  • Develop and maintain new, creative approaches to processes, such as automating the extraction of CMS data by looping API calls.

Risk Adjustment Specialist IV, 07/2018 to 11/2021

  • Received promotion within the Medicare Risk Adjustment Analytics team.
  • Lead analyst responsible for all phases of data extraction and manipulation, validations, analysis, and delivery of enterprise health condition reporting, which supported Medicare Advantage risk adjustment activities.
  • Generated provider specialists mailing campaigns and Clinical Documentation and Improvement (CDI) datasets by analyzing chronic health condition data.

Risk Adjustment Specialist III, 09/2016 to 06/2018

  • Promoted to FTE position from contractor.
  • Measured the ROI of prospective risk adjustment activities, calculating risk score lifts based on CMS HCC risk models, which I reported to senior leadership.
  • Identified and selected members for risk adjustment in-home assessment campaigns.
  • Queried terabytes of healthcare data from disparate internal databases and external sources.

American Recruiting & Consulting Group (Client: Florida Blue) – Jacksonville, FL

Associate Data Analyst Contractor, 01/2016 to 08/2016

  • Prepared data for vendor ingestion through data mapping and by programming exceptions processes and monitoring trends.
  • Performed statistical analyses on campaign outreach data.
  • Improved and documented reporting processes, reducing time to generate datasets by 90%.
  • Presented analyses to business partners.

MECLABS – Jacksonville, FL

Data Scientist, 02/2013 to 8/2015

  • Served as project lead on data-related initiatives for the internal marketing team and provided recommendations to senior directors and executives.
  • Advised project teams on the validity of experimental designs and results.
  • Performed analyses for fortune 500 companies such as Verizon Wireless, the New York Times, Bank of America, and Expedia.
  • Calculated descriptive and inferential statistics to determine the risk of implementing experimental web page designs and the impact on revenue.

The Haas Center, University of West Florida – Pensacola, FL

Research Associate, 01/2012 to 01/2013

  • Led research on the community health and wellness of Okaloosa County, FL residents.
  • Assisted with analyses, data preparation, data visualizations and report writing for the Department of Defense, Department of Homeland Security, and Workforce Florida Incorporated (WFI).
  • Assisted with numerous economic impact studies for state and local government agencies to include the impact of the U.S. Navy Blue Angels to a regional economy.
  • Moderated focus groups and applied research knowledge to avoid experimenter biases and other validity threats.
  • Developed survey instruments and analyzed results.

SKILLS

  • SAS programming
  • SQL
  • Excel, VBA
  • Power BI
  • Data analysis
  • Statistical analysis
  • Process improvement
  • Risk Adjustment
  • Medicare Advantage

EDUCATION

Master of Arts: Industrial-Organizational Psychology, 08/2012
University of West Florida – Pensacola, FL

Bachelor of Arts: Government, 05/2007
University of Texas – Austin, TX

HOBBIES

Guitar, drums.