"In a typical year, we deal with more than 100 million member and claims records," Joseph Randazzo, manager of actuarial services for Excellus BCBS, says in a statement. "The amount of data is too large to manage with Microsoft Office Access databases. With SAS, you can just kick off a process flow and work on something else while waiting for the results."
Excellus BCBS uses these data to forecast medical and membership trends that it needs when setting health insurance premium rates for the upcoming year.
"We were in an environment where we spent 70 to 80 percent of our time scrubbing, extracting, transforming and loading data – with less than 30 percent of time spent on analysis. With SAS, in many instances, those numbers have flip-flopped," Randazzo continues.
Excellus worked with SAS partner D-Wise to implement the platform in May, D-Wise reports.
Other health insurance plans that use SAS include Horizon BCBS of New Jersey, CareSource and Highmark.
Customer Retention: The Power of Insight