City

Data Normalization

Data Is the Core

Data is at the core of everything we do at CCC. That's why we continue to invest in our innovative, state-of-the-art technology platform. The foundation of this technology stack is the CCC Claims Database Application (CDA), which is a massively scalable, high-performance cluster built on MySQL and MongoDB technologies, containing more than two decades of historical class action data in billions of rows.

Inbound Data

Download The Presentation

The front door of the CDA is the Inbound Data Process, a set of applications that perform data ingest and transformation operations. To get data into the front door, clients most often use a secure data transfer, for example CCC's secure online data upload tools, or an automated extract that fits the client system. The Inbound Data Process includes an automated series of tests and transformations, as well as manual checks administered by the Data Operations Manager and his team.

How it Works

The initial data set is loaded into the database as is and assigned an internal identifier. This and all subsequent operations are recorded in the system along with the results and system generated metadata.

Using CCC's proprietary algorithms, the data set is isolated, analyzed and "normalized" into standard datatypes, tables, and other data structures. Using both automated and manual processes, the data transformation is completed, and mapped to standard data fields. Then the data is loaded and saved to the CDA.

The newly imported data is indexed and tested. Each step is analyzed for accuracy and logged. The Data Operations team quickly identifies any data issues including redundant, missing or incomplete data, formatting and character issues, missing relationships, and other data anomalies.

Throughout the process, the expertise and experience of the Data Operations staff are brought to bear. They monitor each step and verify accuracy based on a sequence of crosschecks and audit controls. Discrepancies are immediately flagged and reported. This enables common problems to be quickly identified and resolved, like name and address changes, or redundant rows. Some issues are fixed automatically, and some need to be verified with the client, or require deeper research. At all times the status of the Inbound Data Process is maintained by the system, including any issues and how they were resolved.

Data is Our Core, and Yours

Accurate data is key to efficiency, both in our business and yours. Therefore, we treat all these processes with the same level of care as you would. We treat all of your accounts and all of your clients as if they were our own. When you turn to the experts at CCC, you and your clients gain a teammate not only championing your class action claims, but the accuracy of, and access to, vitally important data.

Chicago Clearing Corporation

Since 1992

2,100 clients

And growing

5 million

Individual Accounts

5 Trillion

In AUM

1 Billion

Recovered from Clients

More News From the Class Action World

I could go on and on, but bottom line, the fees being charged are much less than what I was spending in house to file and this is just one less thing I have to spend time trying to figure out how to complete on a consistent basis. Dealing with the CCC staff has been a very positive thing.

- National Bank

We were spending countless hours on class action claims before we signed on with CCC in January. Matt Murray and their technical team ensured our data transmission was seamless and secure. We found everyone at CCC to be professional, courteous, and accommodating.

- Savings Bank

Signing with CCC has made a huge difference. Before, it was horrible. We had to print thousands of pieces of paper, invite clients to come in and sit down with us to show them where to find the transactions, how to input them into the Proof of Claim forms. Now it's simple. It’s very nice to be able to tell our client, “You can shred that Proof of Claim form because CCC has it taken care of.

- Registered Investment Advisor

Your client reporting portal and customer service is the reason we chose Chicago Clearing. I send the data on an annual basis to CCC and they take it from there. My clients are protected (if there is a class action, it is getting filed), the Bank is protected (we are meeting our fiduciary obligation by filing the claims).

- Bank

Contact Us

404 South Wells St., Suite 600,
Chicago, IL 60607 – United States
Phone: (312) 204-6970
Email:
info@chicagoclearing.com

About Us

Chicago Clearing Corporation is the
industry leader in class-action services.

2024 © Chicago Clearing Corporation. All rights reserved. Terms and conditions