The project aimed to develop a data mart for a Fortune 500 insurance company to consolidate policy-related information from various sources. The primary goal was to provide data-driven insights to improve decision-making and generate key business metrics such as suspended policies, total paid commissionable premiums, new and lost businesses, and policy summaries by broker districts. A robust ETL process was implemented to extract, transform, and load data into the data mart, and the project leveraged advanced data access and visualization tools to empower business users.

• The client’s data was spread across multiple sources, including Sybase SQL Server and flat files, making it difficult to generate consistent reports.
• Existing reporting processes were manual, time-consuming, and prone to errors, delaying the availability of critical insights.
• The business lacked a consolidated view of policy metrics, hindering its ability to assess performance, identify new business opportunities, and analyze customer trends.
• Ensuring high data quality during the extraction, transformation, and loading processes was crucial for maintaining the accuracy and reliability of the generated reports.

• Designed, developed, and maintained the data warehouse infrastructure tailored to the client’s enterprise-wide needs.
• Used Erwin to create data models and schemas that accurately
  represented business requirements for Service Management and Sales & Distribution.
• Architected ETL solutions using Informatica to efficiently extract and transform data from SAP, ensuring data quality through cleansing and validation processes.
• Installed and implemented Cognos Analytics for advanced reporting and provided mentoring to ensure smooth user adoption.
• Planned for scalable databases and optimized the data warehouse for performance, ensuring quick retrieval of analytical data.
• Designed custom reports and dashboards in Cognos Analytics, offering business users real-time insights into service management and sales operations.