File Remediation Project for a Top 10 Commercial Bank

The Project

Tandym is providing subject matter expertise and analysis to develop recommendations and approach for remediating manual file processes for Regulatory Reporting.

The Problem

Provide recommendations and approach for remediating manual file processes for Regulatory Reporting. The client had 3000+ manual files and line-item files that either were not in use, did not have compensating controls, or proper source mapping. The project team was to take these files that were lacking proper source mapping or controls and provide recommendations for the data mapping and control remediations.

Project Objectives

• Identify/document manual files and line-item adjustments required for remediation for Regulatory Reporting.
• Identify/document if any Archer controls or compensating controls exist.  Provide recommendations for Archer-defined validation control(s) required for remaining manual file(s)/line item(s).
• Work with file preparer/owner and intermediaries to determine source system of data related to each manual file and line-item adjustment related to a regulatory report(s).
• Document the manual file and line-item adjustment attributes mapping from the source application(s) to Enterprise Data platform, as available.
• For new data elements not in FRDM, document the mapping from Enterprise Data platforms to FRDM Acquisition Layer and Life Cycle Layer.
• For existing data elements in FRDM, modify the existing FRDM mapping(s) to correct the logic for Life Cycle Layer, as applicable.