Case Studies

FINANCIAL SERVICES

• Desperate Need for Data Anlytical Tools and Improvements in Mark to Market and Treasury Reporting

Issue
Client needed data tools to analyze mark to market reporting variances efficiently and timely. Additionally, their Treasury reports didn't tie out with one another and their Asset-Based Credit line reporting to the banks was manual and not reconcilied to the mortgage portfolio on hand.
Solution 
> Financial Data Integrity Analyst, supporting mark to market accounting function and reporting.
> Performed special project analysis to determine cause of data discrepancies.
> Developed sophisticated MS Access Analysis applications using ODBC connections to data warehouses to detect defined variance movements (threshold tolerances) in data.
> Researched data processing environment and data processing rules and procedures.
> Developed mission specific, user-friendly, menu-driven applications for data mining, analysis and product line reporting for use by accounting staff.
> Developed applications for data and reporting reconciliations for credit line reporting for asset backed and mortgage backed assets for use by ResCap Treasury Department employees.
> Developed application for mark to market reference tools for use by staff for routine research and analysis needs.

Benefits 
> Automated Asset Based Credit Line Reporting.
> Implemented single source of truth reporting for Treasury Department, eliminating reporting discrepancies.

Return To Case Studies