| The client is (IN based) a reputed Organization, providing services and products to Insurance companies and Financial Institutions. SRA, being partners with Business Objects, automated the process of data entry and data import for the client. SRA also created a data warehouse to arrive at reports and suggestions in various dimensions.
SRA assisted the client in providing ETL programs to Extract, Validate, Transform and Load data into DWH from multiple sources and reporting tools based on various parameters. SRA developed query & reporting tools, user interfaces and programs to automatically load external data files on a monthly basis into the data marts.
The data gets extracted from source files, gets cleansed and loaded into the DWH data mart. Data was available in the data mart for reporting and maintenance. Import status monitoring of various files is possible.
SRA’s solution fulfilled the requirements of
the client with the help of 4 modules: Import, Maintenance,
Security and Reports.
| 
