Shubham Kolhekar

AI Variant Data Analyst Internship | Insurance Analytics Project ( Aug 2024 – Nov 2024) ● Collected and cleaned large datasets from policy records, claims databases, and customer information to ensure data accuracy and integrity. ● Analyzed claims trends and customer behavior, delivering insights through reports and dashboards using Excel and Power BI. ● Prepared and presented detailed, clear, and concise reports for team members and management. ● Conducted data analysis for business operations, including data cleaning, validation, and reporting across departments. ● Recommended process improvements to optimize claims processing and underwriting while ensuring compliance with industry regulations.

Counseled students on career goals, exam strategies, and course selection for competitive exams (SSC, Banking, UPSC, etc.), resulting in improved course enrollments. Handled inbound/outbound calls, chats, and emails to convert potential leads into paid users, consistently achieving monthly sales targets. • Provided personalized academic guidance and mentorship to help students stay on track and motivated throughout their learning journey. • Maintained accurate student records and lead data using CRM tools like LeadSquared/Salesforce, ensuring effective follow-ups and reporting. • Collaborated with product and content teams to relay student feedback and enhance course offerings based on learner needs. • Trained and mentored junior counselors to ensure consistent service quality and knowledge sharing across the team.