KUNAL GHADGE

I have 1 years of experience in data analysis, working with large datasets, writing and fixing SQL queries, and turning data into clear, useful business insights. I am skilled in building interactive dashboards using Power BI, and performing data analysis tasks with Excel and SQL. I also have experience in market research, collecting business requirements, and doing both qualitative and quantitative analyses to support decision-making.

• Data visualization
• Data mining
• Database management systems (DBMS)
• SQL for data analytics, analytics
• Data governance and data integrity
• Excel for data analytics

Customer retention analysis – insurance policy lapse prediction (self-initiated project)

Tools: Excel, SQL, Power BI

Project overview: Led a data analysis project focused on reducing policy lapse rates in life insurance by identifying key risk factors and trends related to customer profiles and payment behaviors 

Key responsibilities and achievements

• Analyzed 30,000+ customer policy records to identify common reasons for policy lapses
• Cleaned and prepared datasets using Excel and SQL with variables such as age, policy dates, premium amounts, and product types
• Created interactive Power BI dashboards to visualize lapse trends by demographics, policy tenure, and premium size
• Identified early risk indicators for high-lapse policies through historical data analysis
• Helped develop a data-driven retention strategy projected to reduce lapse rates by 12% in upcoming quarters

Analytical tools: Excel, Power BI, Power Query, Tableau

Languages: Python, SQL

Technologies/frameworks: Jira, Pandas, NumPy

• Power BI certification — Simplilearn (Microsoft certified content) completed on January 20, 2025, focused on Power BI fundamentals, data modeling, and dashboard development
• Data Analyst Certification — Simplilearn (Microsoft Certified Content) covered essential data analysis concepts, data visualization, Excel, SQL basics, and Power BI