Will Gray Email & Phone Number

Nashville, Tn, Us

Nashville, Tennessee, United States

• 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.

Nashville, Tennessee, United States

• 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.

Nashville, Tn

• 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.

Master Of Science (Ms), Analytics, 4.00

Bachelor Of Science (Bs), Dual Finance And Marketing Majors, Entrepreneurship Collateral, 3.75

Activities and Societies: Hess Hall Resident Assistant, First Year Studies Peer Mentor, Delta Sigma Pi Co-Ed Professional Business.