Stratton Carroll Email & Phone Number

Bentonville, Ar, Us

Springdale, Arkansas, United States

As a System Analyst on the Community Quality Alliance (CQA) team at Northwest Health System, I specialize in analyzing Claim Line Feed (CCLF) and insurance payor data to drive improvements in patient outcomes and maximize shared savings for our Clinically Integrated Network (CIN) providers in the Value-Based Care space. My expertise in data analysis, process automation, and ETL has been key in providing actionable insights for providers, the quality team, and reporting directors, all aimed at… Show more As a System Analyst on the Community Quality Alliance (CQA) team at Northwest Health System, I specialize in analyzing Claim Line Feed (CCLF) and insurance payor data to drive improvements in patient outcomes and maximize shared savings for our Clinically Integrated Network (CIN) providers in the Value-Based Care space. My expertise in data analysis, process automation, and ETL has been key in providing actionable insights for providers, the quality team, and reporting directors, all aimed at enhancing the organization's financial performance.Responsibilities: ● Analyze Claim Line Feed (CCLF) data, and payor reports from five different insurance companies within a value-based care framework to identify opportunities for improving patient outcomes and achieving shared savings.● Utilized SQL, Python, and SSIS tools to build ETL processes, automate reporting tasks, and generate ad- hoc reports. ● Enhanced reporting task efficiencies by up to 80% through the deployment of automation processes.● Developed custom dashboards in Tableau for providers, the quality team, and reporting directors, providing them with the actionable data needed to make informed decisions.● Designed and implemented a dimensional data model in the organization’s data warehouse to streamline and enhance the efficiency of reporting processes. Show less

Springdale, Arkansas, United States

Dallas, Texas, United States

● Work closely with managing directors from departments across the company to understand their requirements and develop data-driven solutions to support their business objectives.● Utilized Salesforce to manage and analyze organizational data, including creating custom objects, fields, data flows, and building reports and dashboards using the platform's BI tools.● Developed and maintained Tableau CRM dashboards and reports to effectively communicate technical data insights to… Show more ● Work closely with managing directors from departments across the company to understand their requirements and develop data-driven solutions to support their business objectives.● Utilized Salesforce to manage and analyze organizational data, including creating custom objects, fields, data flows, and building reports and dashboards using the platform's BI tools.● Developed and maintained Tableau CRM dashboards and reports to effectively communicate technical data insights to stakeholders, peers, management, and non-technical team members.● Extract and analyze large datasets from various objects using reporting and SOQL skills.● Collaborate with cross-functional teams to identify trends and opportunities for data-driven decision-making and process optimization. Show less

● Assisted professors in collecting and analyzing data from scholarly publications in the field of Information Systems.● Designed and implemented surveys using Qualtrics for undergraduate capstone projects, facilitating insightful feedback for professors and improving overall project outcomes.● Contributed to data collection and entry efforts for academic publications.● Created and published course materials, including uploading content to the Blackboard website for… Show more ● Assisted professors in collecting and analyzing data from scholarly publications in the field of Information Systems.● Designed and implemented surveys using Qualtrics for undergraduate capstone projects, facilitating insightful feedback for professors and improving overall project outcomes.● Contributed to data collection and entry efforts for academic publications.● Created and published course materials, including uploading content to the Blackboard website for graduate-level courses. Show less

● Led the scraping, cleaning, and merging of product data using SQL Server, resulting in improved data quality and insights for product family owners.● Utilizing relational database concepts to normalize database tables and in designing efficient and effective database schemas.● Successfully managed remote work in an asynchronous environment, demonstrating adaptability and flexibility.

Fayetteville, Arkansas, United States

● Part of a team that generated hundreds of new leases while maintaining current resident relationships● Planned and integrated new customer prospecting initiatives to increase lead generation● Executed tours and follow-ups with future residents to accomplish leasing goals● Preformed frequent office tasks such as updating Entrata (Management Software), Excel, and scans

Certificate, Healthcare Business Analytics

Master'S Degree, Business Analytics

Activities and Societies: Sports Analytics Club (SAC) GPA: 3.7

Bachelor'S Degree, Information Systems

Activities and Societies: Sigma Phi Epsilon