A community bank had an uncontrolled data and reporting environment where Excel was used to create dimensional tables for various purposes.
The Challenge. A community bank had an uncontrolled data and reporting environment where Excel was used to create dimensional tables for various purposes. These table were stored on local computers, and in some cases, there were multiple and different copies of the same table. This uncontrolled environment failed internal control standards and was not compliant with Sarbanes-Oxley (SOX). In addition, users found reports inconsistent and unreliable.
The Solution. CT Global designed and built a SOX compliant portal using SAS Data Integration Studio and SAS Enterprise Guide. This portal stored and controlled all data needed for table update, reporting and analysis. Examples of tables included a product description table, and employee commission rate files. The portal was fully auditable and prevented individual analysts from manually changing data.
Only designated users with the appropriate level of security could access the portal and specific tables within the portal. Users were designated as either administrator, super user, designated user and auditor. All changes to table were logged. The portal was a single auditable source of accurate data available to all users and replaced the multiple versions of dimension tables previously used.