Will Gray

Experience

• 

  HCA Healthcare

  Jan 2014 - Jan 2020

  • Dashboarding and Visualization – Designed and developed Tableau and Power BI analytics dashboards for use during financial and compliance audits. Led the design and creation of a supply chain expense dashboard that housed details for over $10 billion in annual accounts payable spend. This dashboard was utilized enterprise-wide for financial risk assessment and supply chain research. • Data Preparation and Migration Automation – Utilized T-SQL and Teradata SQL to query and combine disparate data sources into a single data model to be used for analysis. Automated data extraction, transformation, and load (ETL) processes using SQL Server Integration Services (SSIS).• Web Development – Designed and coded all HTML/CSS/JavaScript updates for Internal Audit’s internal and enterprise-facing websites. Led the implementation of a web-based training program designed to teach enterprise compliance processes to financial executives at over 180 hospitals. • Process Improvement – Decreased time dedicated to department technical support by over two FTE weeks per year by eliminating non-value adding activities in routine support processes.• Staff Upskilling – Advanced the use of data analytics throughout the department by creating and presenting trainings at internal seminars and to all new hires, reaching an audience of over 200 people. Show less • Risk Assessment and Auditing – Assessed technological risk to U.S. operations, engaged relevant parties in the audit process, and analyzed provided audit evidence to determine areas of concern.• Risk Reduction – Wrote and presented evidence-based recommendations to business and technical leadership with the objective of reducing risk to the enterprise.• Cross-Functional Collaboration – Collaborated with a diversity of leaders across the enterprise in order to foster an environment of trust, continual improvement, and mutual success throughout the audit process. Show less

  • Audit Data Analyst - Manager / Senior II

    Jan 2017 - Jan 2020

  • Information Systems Auditor – Senior II / Senior / Staff

    Jan 2014 - Dec 2016
• 

  Cigna Healthcare

  Mar 2021 - Mar 2025

  • Domain and Data Expertise – Recognized as having a deep understanding of care management data and how it relates to clinical and business processes. Built a strong working knowledge of data across multiple domains (medical and pharmaceutical claims, diagnoses, demographics, and insurance enrollment) and integrated these datasets into dashboards, reports, and models. • Data Preparation and Pipeline Automation – Developed trusted case management datasets from raw and noisy data by building well-documented SQL queries. Collaborated with leadership to add layers of business logic that enabled the development of key metrics. Automated dataset updates through Alteryx. • Dashboarding and Reporting – Delivered insights and data to leadership through Tableau dashboarding and Excel reporting. Led the creation of multiple dashboards that have been utilized by leadership to understand both the broad state and minute details of case management and clinical programs. • Statistical Modeling – Utilized regression modeling and coarsened exact matching to analyze factors associated with cost reduction following member enrollment into clinical programs and medication reviews. Modeling results were used to support organizational and affordability planning. Show less

  • Business Analytics Senior Advisor

    Jul 2024 - Mar 2025

  • Business Analytics Advisor

    Mar 2021 - Jul 2024
• 

  Health Care Service Corporation

  Mar 2025 - now

  Principal Analytics Consultant