Enterprise Data Integration Based on an Enterprise Logical Data Model and Service Oriented Architecture

An organization's focus on cost reduction and operational efficiency improvement drives to streamline data integration. The cost of change, lack of agility, and fragmented System of Records are the common symptoms of sub-optimal data integration capabilities. To integrate data in a large heterogamous environment comprising of hundreds of hybrid modern and legacy applications, databases, and End Use Computing has been a big challenge in industry. Freddie Mac Architecture Services has been making headway in streamlining enterprise data integration. This case study presents a solution in a multiyear strategic endeavor to integrate data in the Freddie Mac Multifamily Division.

A few new strategic systems and foundation have been ongoing to build toward holistic enterprise level data integration:

Multifamily Logical Data Model (MFLDM): a newly developed enterprise logical data model for the Multifamily business at Freddie Mac
Integration Middle Layer: an SOA WebLogic based middle tie to enable loosely coupling of application and systems
Operational Data Store: a data hub for integrated operational data
Operational Reporting: an application sitting on the top of the ODS to enable daily management and operational reports
Data Warehouse: enabling business analytics and business intelligence of both operational and finance historical data
A set of metadata driven data services and an orchestrating framework: including Metadata Services, Validation Services, Staging Servicing, Orchestrating Services, Change Tracking Services, Runtime Statistics, and Data Identify Service

Data moving between systems and persisting in the enterprise shared repositories conforms the MFLDM. This MFLDM has been developed through a close collaboration between the Business and IT at Freddie Mac.

Dr. Xinhua Deng is a Lead Architect at Freddie Mac Single Family Division. He has demonstrated expertise and experience in defining and delivering large scale enterprise architecture, information architecture, and data management solutions and governance in some of the largest financial companies, including Capital One, Fannie Mae, and Freddie Mac. Prior to his industry adventure, he was a faculty member at the School of Computational Sciences of George Mason University. He has published in peer-reviewed journals and presented at national and international levels.

Jeff Huang is an Architecture Director of the Federal Home Loan Mortgage Corporation (Freddie Mac). He received his Bachelor's degree in Computer Engineering from the National Chiao Tung University, Taiwan, and his Master's degree in Computer Science from Syracuse University, New York. Mr. Huang has more than 20 years of experience in Information Technology. He has held many positions in many IT departments, including development, research, architecture, engineering, and information security. He is currently the director of the Solution Architecture group in Freddie Mac. Under his supervision, a group of architects provides solutions for delivering business capabilities toward the Freddie Mac strategic objectives.