Senior Data Analyst with over 8 years of Experience.Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.
SQL
Python
Salesforce Cloud CPQ
SAS(Basics)
SSIS
PDI
Neo4j
Advanced Excel
Power BI
NumPy
Pandas
ETL
Data science pipelines
Panel Firm Project:
● Whenever there is a case where a claim needs to be resolved in the court, the company doesn’t know which Panel firm to approach. So, we have built a model which predicts the indemnity Savings for each Panel firm for a particular claim.
I have worked on Data part, where I need to collect the data from multiple Databases and then clean the data, add derived variables and also deployed the model in Flask and have built multiple clients (Streamlit, Excel and PowerBI).
Auto Subrogation:
● This model is used to predict the Subrogation Probability of claims where we have paid for the Third Party. The business then checks the referred claims and then sends the recovery letter to the third Party wherever required. In this the model will predict the Total Severity as well.
Third Party Deductible Recovery:
● This project aims at recovering the Deductible from the paid Third Party Claims. I have built a code where the data is fetched from multiple sources (Claims, Policy) and the combined data is divided into multiple categories based on the existing columns. Claims in few categories are referred to the business and a data pipeline has been built in SSIS to load the recovered information in the Database. PowerBI Dashboard has been built on Top of the Database to tract the recovered amount and also some other KPI’s.