 |
|
|
|
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
| - |
|
|
|
|
|
Case Study: Freddie Mac Data Quality Improvement
|
|
|
|
| Customer: |
Federal Home Loan Mortgage Corporation (Freddie Mac)
(Aquent, prime contractor) |
 |
| Goal: |
Provide business and management consulting services for Freddie Mac�s Single Family Division, the organization with line business responsibility for single-family loan operations and management
|
| Application: |
- Provide Freddie Mac�s Single Family Division with a solid business program for defining, measuring, and evaluating the quality of data used for making business decisions relating to division performance
- Improve the data quality contained within Project Enterprise, a key integrated business initiative
- Develop corporate data warehouse to store complex business and financial data
- Improve management reporting processes and provide ongoing operational support
|
| Challenges: |
- Heterogeneous technology baseline
- Large size ($568 billion) of Freddie Mac�s retained mortgage portfolio
- Identifying key business processes, policies and metrics required to evaluate business decision information quality
- Coordinating reporting efforts at the group, division and corporate level
- Working with cross-organizational teams on an ongoing basis to identify, resolve, and prevent process problems causing business data consistency issues
|
| FTI's Approach: |
- Information Quality Program Development and Implementation - The goal of this program was to provide Freddie Mac�s Single Family Division with a solid business program for defining, measuring, and evaluating the quality of data used for making business decisions relating to division performance. FTI personnel:
- Worked with group management and corporate policy-making specialists to identify all business processes, policies, and metrics currently used to evaluate the quality of information used in business decision-making; information was gathered using requirements gathering meetings, facilitated sessions, and written memos and questionnaires
- Evaluated and integrated the information collected, and used it to develop management and operational guidance for organizing and implementing an effective information quality program
- Issued these recommendations in the form of a formal study document, associated briefing, and a briefing summary for upper management
- Supported efforts of the Data Management Forum, a cross-organization group dedicated to cooperative efforts to standardize and improve business information quality across the corporation
- The Single Family information quality program was ultimately was used as a corporate model and received the highest possible rating from federal regulatory authorities.
- Project Enterprise Data Quality Improvement - The goal of this program was to improve the data quality contained within Project Enterprise; a key integrated business initiative. FTI personnel:
- Provided subject matter expertise in evaluating the concept of "Data Quality"
- Developed a set of 11 metrics for measuring and evaluating data quality
- Recommended one metric (business data consistency) as the initial area of program focus
- Developed and delivered both documents and briefings containing this program guidance
- Worked with cross-organizational teams on an ongoing basis to identify, resolve, and prevent process problems causing business data consistency issues.
|
| Products Used: |
IBM DB2, Microsoft Access database management systems, MicroStrategy Data Warehouse tools, various scripting languages under Windows, UNIX, and VM/CMS operating systems
|
| Benefits: |
Improved corporate data quality and consistency, regulatory compliance
|
| Delivery: |
On time, within budget. CMMI Level 3 project.
|
| Project Keywords: |
Data quality, consistency, data warehousing, regulatory compliance
|
|
|
|
|
|
|
