John Madden Email & Phone Number

Chicago, Il, Us

Santa Barbara, California, Us

- Develop workflows and formulate code in the Databricks notebook environment via Spark SQL, Spark Scala, PySpark, and Python to conduct simple data analysis and implement complex algorithms. - Employed regression models to uncover the likelihood of consumer conversion based on various discount rates found within promotional offers.- Collaborate with global teams across five distinct departments within the organization to develop internal and external facing Tableau dashboards that accommodate upwards of 4,500 clients in the network. - Present regularly to global CJ teams of greater than 225 associates: seven product launches, over 20 Tableau dashboard demonstrations, two 30-minute topic discussions at CJ’s annual business conference.- Served as the Data Science liaison during the onset of the Influencer line of business: assisted in API creation, built an Influencer specific data warehouse, generated seven tables, and crafted a Tableau report to support stakeholder needs. - Coordinated with business leadership to build CJ’s cornerstone benchmarking report to improve storytelling, strategic planning, and financial analysis for client teams.

Santa Barbara, California, Us

Black Hawk, Colorado, Us

- Produced 12 SQL scripts that accounted for slot utilization, guest activity over three specified time ranges, and the five most popular slot machines over seven specified time ranges.- Developed dashboards via Power BI to compliment outputs from 12 SQL scripts and presented the findings to upper management.- Constructed regression models to predict player activity and future revenue based on demographic and slot machine data.- Using SSIS, performed ETL processes on four SQL scrips and stored the results in a data warehouse.

Chicago, Illinois, Us

- Interpreted over 3,500 lines of data in Excel from off-premise sampling events using descriptive analytics and noted four key observations regarding data integrity or correlations.- Crafted a memo and PowerPoint presentation for the CMO and promotions manager about the off-premise sampling events detailing how Mike’s could be more cost-effective.- Contacted over 30 Chicago companies and coordinated 10 promotional happy hour events to build brand awareness for Mike’s recently launched product, White Claw.- Leveraged Facebook to provide first-rate customer for Mike’s five brands by answering approximately 25 directly messaged queries per day and monitoring hundreds of public comments.

Wood Dale, Il, Us

- Organized and processed over 7,500 promotional orders for three premium brands in a timely manner and prompted internal and external action in cases of missed deadlines to ensure customer satisfaction.- Collaborated with three different departments, as well as three external clients and two distributors, to strengthen communication, foster valuable partnerships, and ensure smooth logistical planning. - Trained an existing employee to take over my position with minimal disruption to daily operations guaranteeing a smooth transition.

Master Of Science - Ms, Data Analytics

Bachelor’S Degree, Business Marketing, Operations And Information Management Certificate, Concentration In Psychology

High School