Ruby Kushwaha Email & Phone Number

Pune, Maharashtra, India

Richmond, Virginia, United States

•Performed data analysis on customer data for executing marketing and servicing campaigns to drive customer acquisitions, and management using SQL, python, Snowflake, and AWS services.•Loaded the campaign data from the Fractal tool into Snowflake tables to further analyze the campaign results.•Imported data from Snowflake into Databricks to perform exclusions on the customers, prepare reconciliation and validation report using Python•Interfaced with fulfillment team, tech team, and… Show more •Performed data analysis on customer data for executing marketing and servicing campaigns to drive customer acquisitions, and management using SQL, python, Snowflake, and AWS services.•Loaded the campaign data from the Fractal tool into Snowflake tables to further analyze the campaign results.•Imported data from Snowflake into Databricks to perform exclusions on the customers, prepare reconciliation and validation report using Python•Interfaced with fulfillment team, tech team, and digital infrastructure team to identify the appropriate channel of communication for each campaign and handed off campaign data in the respective format.•Conducted research, prepared reports, and analyzed customer behavior and other sensitive data to shape the strategies with Business Analysts and higher management Show less

Hartford, Connecticut Area

Course: Predictive Modelling•Mentored 100 students for predictive modeling, ML algorithms, created exam papers, and graded assignments

Hartford, Connecticut Area

•Analyzed key attributes affecting lapse rate for 9M+ customer-base and created Tableau dashboard for reporting the same along with other policy KPIs to drive decision making and provide recommendations on insurance policy parameters•Performed feature engineering, did secondary research and studies to support analysis and developed Gradient Boosting model using Python with AUC of 81% to forecast potential members who are likely to lapse policy•Discovered States where the lapse is high… Show more •Analyzed key attributes affecting lapse rate for 9M+ customer-base and created Tableau dashboard for reporting the same along with other policy KPIs to drive decision making and provide recommendations on insurance policy parameters•Performed feature engineering, did secondary research and studies to support analysis and developed Gradient Boosting model using Python with AUC of 81% to forecast potential members who are likely to lapse policy•Discovered States where the lapse is high and helping clients to identify opportunities to sell more policy Show less

Storrs,Connecticut

Assisted in managing scope, budget, schedule, and resources for multiple projects using MS Project

Pune, India

•Engaged in client calls to gather requirements and spearheaded a team of 4 to provide data-driven business solutions•Worked on large datasets, analyzing data, performing root cause analysis, merge data from different sources, performing data extraction, transform and load process including data cleansing•Automated the process of refreshing materialized views and designed email notification system to notify stakeholders in case of any failure using optimized SQL queries, leading to… Show more •Engaged in client calls to gather requirements and spearheaded a team of 4 to provide data-driven business solutions•Worked on large datasets, analyzing data, performing root cause analysis, merge data from different sources, performing data extraction, transform and load process including data cleansing•Automated the process of refreshing materialized views and designed email notification system to notify stakeholders in case of any failure using optimized SQL queries, leading to process improvement and reducing workflow time by 30%•Generated reports about the market and license status of products, providing business insights to clients helping them make an informed business decision leading to a profit margin of 13%•Collaborated with DBA team and UAT team and successfully deployed the service to the production environment•Received “Performance Award” for exacting business requirements, performing detailed analysis and meeting deadline Show less

Master Of Science - Ms, Business Analytics And Project Management, 4.0/4.0

Relevant Coursework: - Data Science with Python - Big Data Analytics with Hadoop - Statistics using R - Visual Analytics using Tableau.

Bachelor Of Engineering (Be), Electrical Engineering Technologies/Technicians, 8.2/10

Passed with Honors