Our client’s Auto Insurance Reporting System is their main Underwriting Group and Claims Data System. All of their systems fed data to the Enterprise Data warehousing (Oracle DW) and Corporate Reporting System (CRS-DB2 DW).
There were a number of challenges faced by the organization such as understanding the different systems and business logic of all company divisions as well as dealing with a complex system environment containing Mainframe z/OS, IBM, DB2, WebFocus and EDW oracle 10g, J2EE.
Y&L created a framework definition for the EDW system and set up an ETL testing framework. In addition, we performed the design/development of Web Focus reports, performance testing and application tuning as well as end-to-end implementation testing and migration support.
Benefits Derived:

  • Provides a combined view of Premium and Loss dataAlerts reports about the critical customers
  • History reports and Latest Reports and policy level and transaction level
  • Renewal Premium Rate Change reports for various companies