lol world

Data Analyst

ICICI Lombard General Insurance Company Limited•  March 2023 - Present•  Kolkata, India

Managed analytics for 50+ clients in West Bengal, achieving a 15% YoY growth in insurance retention through advanced data-driven strategies. Designed and implemented Power BI dashboards, leading to a 15% reduction in operational costs by optimizing data reporting and process efficiencies. Conducted data analysis that led to a 10% improvement in claims processing time, directly impacting customer satisfaction and retention rates. Developed tailored solutions for cross-functional teams, driving data utilization and improving performance tracking across the organization. Implemented predictive analytics models, contributing to a 27% increase in inventory movement by optimizing discount strategies and clearance rates. Enhanced the effectiveness and reach of political and product ad campaigns, boosting campaign ROI by 9% through SQL and Excel analysis. Used statistical analysis and predictive modeling in ad targeting and segmentation to enhance campaign precision.

Analyst Intern

Forage•  July 2022 - December 2022

Utilized SQL, advanced Excel, and Python for data processing and analysis, successfully deploying a quality project focused on efficiency and accuracy in data handling. Analyzed, reviewed, and revised programs, improving operating efficiency by 30% and significantly enhancing system performance and user satisfaction. Employed advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation, reducing manual work by 2 hours and increasing workflow efficiency. Optimized SQL queries and developed BI solutions, reducing processing times by 50% and improving data management efficiency. Created custom Power BI dashboards for client projects, boosting campaign ROI by 9% by enhancing data clarity and utility. Innovated reporting processes using Python, resulting in a 17% increase in revenue by improving inventory management insights for key brands. Applied advanced Excel techniques to support ad hoc analysis, contributing to a 12% increase in revenue through strategic inventory optimization.