Our client needed an MIS reporting tool that would meet senior-to-top management’s reporting requirements. The tool would be used to generate reports on various insurance products, identify & analyze sales target, MTD, YTD sales, account receivables, account payable for various departments etc.

• Capture data feeds from isolated MS- Access database
• Translate data into staging database for checking data integrity using integration services in SQL server 2005.
• Capture and store data in SQL server 2005 as Enterprise Data Warehouse
• Generate the required cubes and process the data and reports using reporting services in SQL Server 2005.
• Data migration from Access database to SQL Server 2005