Kanchan Panwar

Around 5 years of experience in Business Intelligence, Data Analytics and Data warehousing solutions. Good at Requirement gathering, Data Analysis, Dashboard Designing, Report Development and Maintenance. Extracting data from various sources, transforming as per business requirements and loading into desired destinations. Good Knowledge on Power BI to import data from various sources and create reports and dashboards on Power BI Desktop and Power BI Services and knowledge of Dax Queries to generate calculated columns, measures.

Supported different departments by providing reports and Dashboards as per business requirement.

 TEAM - Policy and Claim Management :

• Used SQL to create and maintain a database that stores policy-related information, such as policy details, coverage, premiums, and claims history of Motor and Non-motor LOBS.
• Written Queries to retrieve specific policy information based on different criteria such as policy type, customer details, or policy status, channel.
• Used Power BI to visualize and analyze policy data, enabling insurers to track policy trends, identify profitable segments, and monitor policy performance.

TEAM : Risk Assessment and Underwriting :

• Written SQL Queries to retrieve historical data related to risks, such as loss ratios, premium rates, and risk factors.
• Identify risk patterns, and evaluate underwriting guidelines.
• Created interactive reports and visualizations with Power BI that provides insights into risk exposure, profitability by risk category, or pricing analysis, assisting underwriters in making informed decisions.

TEAM : Customer Analytics and Compliance

• Used SQL databases for customer-related data, including demographic information, policy history, communication details, and customer interactions.
• Written SQL queries on various criteria to calculate customer metrics such as customer lifetime value, retention rates, or cross-selling opportunities.
• Used Power BI to generate customer-centric visualizations, such as customer segmentation charts or customer satisfaction dashboards, enabling insurers to understand and engage their customer base effectively.