Learn Data Skills
Beta
Bryan Kay

Bryan Kay

Data Analyst

Technologies

My Portfolio Highlights

My New Track

Data Scientist

My New Track

Data Scientist

Insights artist, transforming data into visually stunning masterpieces of knowledge.

My Work

Take a look at my latest work.

workspace

Lego Sets and Years over Time

1Upvotes
workspace

Competition - drinks promotions

1Upvotes
workspace

Lego Sets and Years over Time

1Upvotes

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to R
Intermediate Python
Introduction to ChatGPT

My Work Experience

Where I've interned and worked during my career.

Regional Transportation Commission of Southern Nevada | Nov 2018 - Present

Data Analyst

- Data analysis for business questions - Primary Tableau data source and dashboard builder for various departments - Data mart designer and ETL coder for three different data mart projects - Design, build, and maintain dashboard suite for database administrators, showing server performance trends compared to baseline behavior. - Analytical and monitoring dashboards to verify transit data is collected as expected. Research and identify anomalies, and how to handle for analysis and reporting purposes for the transit department.
Show More

The Cosmopolitan of Las Vegas | Jul 2015 - Jul 2017

Sr CRM Analyst

* Marketing campaign analytics - Quantify headcount, revenue, and profit results for DM campaigns - Recommend changes for underperforming campaigns - Create dashboards to monitor offer counts, response rate, and redeemer behavior * Ad hoc projects for CRM, Revenue Management, and Slots, such as - Dashboard to identify video poker players who “wash” their free play (redeem offer, wager free play, then leave) - Review requests from hosts to discontinue DM offers to a guest. (Is the host upset about one trip, or is there a pattern of “redeem no-play”?) - Create a Tableau dashboard with data from gaming, data warehouse, and offer system so teammates could review mail and email proofs faster. * Create “extended” version of guest dimension for analytics in Alteryx, so we wouldn’t have to wait for approval and deployment in the data warehouse. * Help data warehouse developer with new EDW development by conveying design requests and validating new database tables for data integrity and accuracy. * Pull customer lists for special events and tournaments based on event criteria. * DM and special event QA: - Review proofs against mailing labels and data files to validate processing by the direct mail vendor. - Check email proofs to validate campaign data before email deployments.

The Cosmopolitan of Las Vegas | Mar 2012 - Jun 2015

CRM Analyst

* Marketing campaign analytics - Quantify headcount, revenue, and profit results for DM campaigns - Recommend changes for underperforming campaigns - Create dashboards to monitor offer counts, response rate, and redeemer behavior * Ad hoc projects for CRM, Revenue Management, and Slots, such as - Dashboard to identify video poker players who “wash” their free play (redeem offer, wager free play, then leave) - Review requests from hosts to discontinue DM offers to a guest. (Is the host upset about one trip, or is there a pattern of “redeem no-play”?) - Create a Tableau dashboard with data from gaming, data warehouse, and offer system so teammates could review mail and email proofs faster. * Create “extended” version of guest dimension for analytics in Alteryx, so we wouldn’t have to wait for approval and deployment in the data warehouse. * Help data warehouse developer with new EDW development by conveying design requests and validating new database tables for data integrity and accuracy. * Pull customer lists for special events and tournaments based on event criteria. * DM and special event QA: - Review proofs against mailing labels and data files to validate processing by the direct mail vendor. - Check email proofs to validate campaign data before email deployments.

Harrah's Entertainment | Apr 2005 - Aug 2008

Database Analyst

* Created and maintained standard reporting and direct marketing tools for use by properties' marketing teams. * Ad hoc data analysis projects. * Managed 30 database table loads monthly, 5 weekly. * Checked Enterprise Data Warehouse database tables for data integrity.

My Education

Take a look at my formal education

Bachelor of Science in Business AdministrationCalifornia Polytechnic State University-San Luis Obispo | 2004

About Me

Bryan Kay

Data analytics professional with over a decade of experience in different industries: casino gaming, hotel, government, and transportation. Data analysis, dashboards, data warehousing. R, Tableau, SQL.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free