Vishakha Sonawane

Data Analyst

SBI General Insurance•  August 2022 - Present•  Pune

● Project Manager – Led a team of 10 members in executing a comprehensive Retail Health Claims Trend Analysis project. The initiative aimed to identify and mitigate fraudulent activities within the healthcare claims domain, involving sophisticated data modeling and visual analytics. ● Tools & Technologies : Excel: Data extraction, cleansing, and daily reporting SQL: Query writing, data manipulation, and database management Power BI & Tableau: Dashboard creation, trend analysis, and insights generation Python: Automation and statistical modeling • Achievements: Reduced fraudulent claims by leveraging data-driven insights and targeted fraud detection strategies. Enhanced operational efficiency through process automation, reducing manual effort in reporting by 30%. • Conducted Standard and Detailed analysis to deliver Claims insights as PowerPoint presentations to corporates monthly. • My primary responsibility is extracting data, model building, maintain data quality & integrity, generates insights to integrate innovative approaches where I have made 10+ automations. Retrieved, cleaned and transformed data to categorize claims, generating daily reports and proposing resolutions to respective teams using Excel, SQL & Python Offered Claims MIS and Customize Analysis reports to stakeholders for reviewing performance and determining optimal pricing strategies for policy renewals