WELCOME
Hello ! I am Bill Andrews. A thorough and meticulous Data Analyst passionate about helping businesses succeed. Recipient of a bachelors and master's in data science. Possessing strong data science skills rooted in substantial training in data science projects.
ABOUT ME
Work Experience 2018 - 2024
Life Insurance Company with 1,000+ Employees
Data Analyst
-
Examined data from web traffic, marketing campaigns, and sales performance to provide insights and recommendations that lead to actionable decisions.
-
Automated 20+ workflows with Alteryx.
-
Created 10 dashboards in Tableau for business leaders that has increased marketing leads by 25% YoY.
-
Created customer personas to provide specific targeting of our marketing campaigns.
-
Created a model to predict customers that are going to Lapse their insurance policy.
Bill Andrews
DATA ANALYST
4029688967
Email:
Address:
20906 Schofield Circle
Gretna, NE 68028
Date of Birth:
July 2nd, 1971
Phone:
EDUCATION
2019 - 2023
Master's Degree
1990 - 1995
Bachelor's Degree
Bellevue University
Data Science
University of Nebraska at Lincoln
Criminal Justice
SKILLS
Machinge Learning - Proficient
Logic and Analysis - Advanced
Tableau - Advanced
SQL - Proficient
Python - Proficient
Alteryx - Advanced
PROJECTS
CUSTOMER SEGEMENTATION
EMPLOYEE ATTRITION
Losing employees can be costly for an organization due to expenses such as job postings, hiring processes, paperwork, and new hire training. Additionally, high employee turnover can hinder the company's ability to expand its collective knowledge and experience, which can be especially problematic if the company serves customers who prefer to interact with familiar faces. Constantly hiring new employees can also increase the likelihood of errors and problems.
CUSTOMER LIFETIME VALUE
The average sales a company receives from a single customer is known as customer lifetime value. This metric helps in identifying potential loyal customers who can generate future sales. There are two types of LTV - historical and predictive approaches.