Banks are held to some of the highest compliance and regulatory standards of any industry. Internal systems are constantly scrutinized and must be managed via processes mandated by state and federal mandates, including Sarbanes-Oxley. The risk of being non-compliant is significant and cutting corners on your internal environment is not an option.
A community bank had an uncontrolled data and reporting environment where Excel was used to create dimensional tables for various purposes. These tables 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.
CT Global designed and built a SOX compliant portal using SAS Data Integration Studio and SAS Enterprise Guide. The 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 tables 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.
The more you tell us about your business and what problems you are facing, the better we can be prepared for our phone consultation. Please include the primary contact and the best time of day to reach you.
Note: consultation calls typically take 20-30 minutes.