Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
Vikhyat Rai

Vikhyat Rai

Amherst,MA

Summary

Aspiring Data Scientist with 9 years’ experience in complex business problem-solving and people’s management. Proficient in Python, R, and SQL. Skilled in data analysis, machine learning, and statistical modeling. Strong problem-solving and communication skills. Proven track record of delivering data-driven solutions to complex business problems. Expertise in data visualization using Tableau and Power BI. Continuously learning and adapting to the latest trends in data science. Collaborative team player with excellent cross-functional collaboration abilities.

Overview

9
9
years of professional experience

Work History

Senior Marketing Analyst

Go Digit General Insurance Co. Ltd
01.2022 - 07.2022
  • Managed $15 million Non-Life insurance portfolio for major corporates, leading team of 4 members and achieving half-yearly growth rate of 26%
  • Developed Logistic Regression model to assess risk of claims for Auto Insurance Policies, reducing Auto claims by 14%
  • Developed and executed optimized SQL queries for data retrieval, filtering, sorting, and aggregation, resulting in streamlined reporting processes
  • Utilized Tableau to develop comprehensive Dashboards, presenting data-driven insights and recommendations to Senior Management for optimizing sales processes, enhancing customer targeting, and driving sales growth
  • Utilized Pandas and NumPy libraries for data manipulation, cleaning, and analysis, enabling data-driven decision-making
  • Implemented machine learning algorithms in Python using Scikit-learn and TensorFlow to develop predictive models for customer behavior analysis
  • Collaborated with cross-functional teams to understand business requirements and translated them into scalable Excel macro solutions, aligning data processes with organizational goals
  • Analyzed sales data to identify KPIs and trends, leading to sales strategies that drove 10% revenue increase
  • Conducted Market Research and Competitor Analysis to identify new sales opportunities and stay updated with Industry trends

Chief Marketing Analyst

Tata AIG General Insurance Co. Ltd
03.2018 - 01.2022
  • Spearheaded a team of three members & successfully managed a $25 million Non-Life insurance portfolio, achieving a year-on-year growth rate of 22%
  • Retrospective Analyses: Led multiple presentations for direct and in-direct (reseller) clients, helping them onboard or acquiring their businesses
  • Conducted data analysis using SQL and Tableau to identify trends, patterns, and anomalies in large Datasets of Health claims, reducing overall Health claims by 15% through targeted Health Campaigns
  • Designed and implemented Predictive models to forecast customer behavior, assess risk, and optimize pricing for Health, Property, and Marine insurance, resulting in 25% increase in small business base
  • Utilized Tableau to report findings, address stakeholder queries, and drive actionable business decisions
  • Conducted Market Research and Analysis to identify New Business opportunities and emerging trends
  • Cultivated and maintained relationships with key corporate clients, ensuring high client satisfaction and repeat business
  • Collaborated with cross-functional teams to identify business requirements and develop Data-Driven solutions for insurance products and services, resulting in 20% increase in client conversion
  • Created reports using Tableau to communicate results to stakeholders and answers product and business questions to drive business actions

Deputy Manager

Bajaj Allianz General Insurance Co. Ltd
07.2013 - 02.2018
  • Managed a $9 million Non-Life insurance portfolio for corporates, achieving a year-on-year growth rate of 20%
  • Prospected and acquired new clients, achieving 15% annual growth in customer base
  • Maintained accurate sales records and reports using CRM software, providing timely updates to Sales Management
  • Prepared and delivered sales presentations to potential customers, showcasing product features and benefits, and closing sales deals
  • Collaborated with cross-functional teams to develop Business Strategies and drive Growth
  • Analyzed large datasets to identify and explain patterns and trends in health claims, reducing claim ratio by 13%
  • Monitored competitor activities and market trends to identify opportunities for business expansion.

Education

Master of Science - Business Analytics

Isenberg School of Management, University of Massachusetts
Amherst, MA
08.2023

MBA - Marketing

ICFAI Business School
02.2013

Bachelor of Science - Statistics

University of Delhi
04.2011

Skills

  • Data Mining Tools: SQL, Python, R, Analytic Solver (XLMiner) & SAP Analytics
  • Database and Reporting: MySQL, Tableau, R/R-Studio, Excel, Microsoft Access, Power BI, Microsoft Excel
  • Techniques: Regression (Linear, Logistics, KNN), Decision Tree, Neural Networks, Cluster, Random Forest & Model Tuning, Association, Data Validation
  • Microsoft Office Suite Proficiency: MS Project, MS Word, PowerPoint

Projects

Business Intelligence & Analytics Project of Spotify (Isenberg School of Management)

• Analyzed data sets of ‘Spotify’ using ‘SQL Studio’ and ‘Tableau’

• Researched company's data in detail with a focus on statistical analysis using BI tools to derive actionable insights.

• Build a report and business implications on “How Spotify Can Improve User Engagement”


Data Science: Predicting California Housing Prices (Isenberg School of Management)

• Utilize data preprocessing techniques to construct a linear regression model that can forecast the Housing prices.

• During the process assessed multicollinearity, as well as evaluated the model's significance using the F-statistics

• Additionally, also utilized R-Squared and adjusted R-Squared values to determine the amount of variation in home value that the model explains

• Further tested: Mean of residual, Heteroscedasticity, Linearity of variables, Normality of error terms


Timeline

Senior Marketing Analyst

Go Digit General Insurance Co. Ltd
01.2022 - 07.2022

Chief Marketing Analyst

Tata AIG General Insurance Co. Ltd
03.2018 - 01.2022

Deputy Manager

Bajaj Allianz General Insurance Co. Ltd
07.2013 - 02.2018

Master of Science - Business Analytics

Isenberg School of Management, University of Massachusetts

MBA - Marketing

ICFAI Business School

Bachelor of Science - Statistics

University of Delhi
Vikhyat Rai