Date of Award

Spring 9-1-2003

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Terry Dennis

Second Advisor

Stephen Krebsbach

Third Advisor

Ronghua Shan


The main idea behind this real-world information systems project was to define and demonstrate the development of a fully functional production ready data repository that provided insurance users and management confidence in the insurance claim data contents complete with data audit controls, validation of data extractions and data loads. Another key development objective addressed was the assurance of daily database synchronization between the source system database and external systems databases to achieve long-term data integrity. This report defines the development and process stages my team have collectively worked on to achieve a Phase 1 SQL Server based Loss Data Repository (LDR) deliverable that satisfied the need to first capture and archive daily insurance based Claims Workstation (CWS) claim (loss) data entries, second to assure data integrity and third to supply the external internet, statistical and reporting interface systems. Finally, this report address the integration of this application system into the CATS Software Life-Cycle Test Environments, Central Release process integration test notification system known as Release Information Management (RIMS), an intranet notification board, and into Corporate wide periodic email notification process. Additional discussion is referenced as to what Phase II and beyond holds for this application and the value of the data contained in the Loss Data Repository. Without a doubt, this IT project has taught the author the true value of a DSU graduate education course of study, the importance of flexibility and the conviction of the author's beliefs that teamwork and perseverance can deliver a viable Information System even when many unknowns and budget limitations exist.