Create and maintain the repository for the Books & Records, regulation requirements, to satisfy the Re-profiling Letter Requirement.
Client account data is spread out over multiple legacy systems, FBSI - Fidelity, Image Works – IBM, Vantage & Vantage Life, with various degrees of information stored, integration of data and generation of letter is desired. The data cleansing thru verification and validation process is done using various Microsoft Technologies like .NET etc.

The biggest challenge in providing a solution to this project is Data Verification, Scrubbing, and Loading with complex business rules, analyzing the same in multiple phases for various Lines of Businesses. The following is the ETL process followed in the project.

1. Load the Flat File to a Single Table
2. Bifurcate the physical records to different tables
3. Data Mapping
4. Pumping the data to 2nd level Staging
5. Moving data from Staging to Testing and production (multiple iterations)

1. High Customer satisfaction is achieved
2. Letter Generation is completed
3. Consolidation of demographic data from disparate systems to a consolidated enterprise level central repository
4. Complete data mapping from legacy systems

Source Systems: Corporate legacy systems, Oracle databases

Hardware:

GUI/Front-end: ASP.Net, C#, XML, Jscript and HTML

Database: SQL Server 2000

Reporting: MS SQL 2000 Reporting Services

Project Methodology: IIDM (Iterative & Interactive Development Methodology)

Project Management: Microsoft Project 2003

Configuration Management: Microsoft Visual Source Safe 6.0

Problem logs and Change Management: Microsoft Exchange 2000 & 2003