Jay Detroja

Developed and automated 5+ data pipelines in Google Cloud Platform (GCP), enhancing data processing efficiency by 15%. Created a real-time live dashboard using Looker Studio, increasing data accessibility and decision-making speed by 25%. Implemented advanced customer segmentation techniques for comprehensive data analysis, resulting in the development of 5 detailed customer personas. Utilized SQL for integrating multiple data sources and performed data manipulation using Python, improving data accuracy and consistency by 25%. Generated real-time business insights and visualized complex data, supporting strategic decision-making processes and reducing analysis time by 20%.

Efficiently managed claims from over 15 insurance companies, ensuring legitimacy and categorization of claims totaling ₹23,744.8M. Supervised 80+ field officers to oversee the claims process, improving processing efficiency by 35% and ensuring accurate claim evaluations. Developed and maintained dynamic dashboards using Power BI to visualize and analyze insurance data, which enhanced decision-making speed by 40%. Analyzed claim amounts by location and officer-incurred charges, tracked turnaround times (TAT), and identified patterns to optimize claim handling processes. Facilitated communication with major insurance companies by visualizing key metrics such as success rates, repudiated amounts (₹288.984M), TAT, and ratings, driving strategic improvements to combat fraudulent activities. Leveraged field officer feedback and comprehensive performance evaluations to enhance communication channels with insurance companies, increasing process transparency and raising the success rate (SR) to 40.29%.