Kiran Gill

Data Analyst -ii @Northwestern Mutual

US

Developed and implemented Risk Sales Strategy Dashboard to monitor key sales metrics across different advisor segments. Utilized visualizations and data analysis techniques to provide insights on campaign effectiveness by tracking the performance of Test and Control groups.•Leveraged clustering techniques in Python to identify and target potential non-Long-Term Care (LTC) selling advisors who exhibited similar characteristics and behaviors to LTC sellers. This look-alike analysis led to significant sales growth.•Developed interactive LinknetGPT dashboard to capture adoption, performance, and feedback metrics.•Developed KPI framework dashboard in power BI focusing on advisor and client demographics/behaviors to provide actionable insights and support strategic decision-making.•Led the Annuity Marketing Campaign, analyzing trends in annuity sales using python, resulting in a 7%+ increase in annuity sales within 3 months.•Developed interactive corporate HOPL Dashboard using Power BI, effectively presenting sales trends, and finding root cause analysis for any decline in sales.•Provided insights on Northwestern Mutual’s product line by identifying yearly and monthly trends, thereby informing decision-making for business partners.•Built performance matrices using python for advisor and conducted exploratory data analysis on advisor behavior.•Developed network office call analyzer dashboards in Power BI, contributing to a 5% reduction in incoming field calls.•Leveraged Nexidia for text analytics on NM Field Calls, resulting in a 2 full-time equivalent (FTE) saving.•Analyzed historical disability and Life claims data to identify gaps and improve claim processing time and efficiencies.

University of Wisconsin-Milwaukee

Master's degree, Management Information Systems, General

Panjab University

Bachelor's degree, Electrical and Electronics Engineering

Thapar Institute of Engineering & Technology

Master of Business Administration (MBA), Maketing & Finance