John Royston

Data Analytics Professional

Transforming complex data into actionable insights with Tableau, SQL, and Python.

Contact Me View Projects
10K+
Dashboard Views Weekly

About Me

John Royston

Analytical professional with expertise in Python, Tableau, and SQL

Focused on data-driven insights in collaborative team settings. Passionate about contributing to organizations with a strong social, political, and environmental conscience.

Skilled in translating complex data into actionable recommendations and visualizations, seeking to enhance my impact in a mission-driven environment.

Location
Saint Clair Shores, MI
Email
john@johnroyston.com
Phone
616-540-3323

Technical Skills

Tableau

  • LOD Calculations
  • Row-Level Security
  • Dashboard Optimization
  • Data Storytelling

SQL

  • Complex Queries
  • Data Modeling
  • Performance Tuning
  • ETL Processes

Python

  • Pandas/Numpy
  • Data Automation
  • Scripting
  • API Integration

Additional Technical Skills

MS Power Automate
MS Forms
SQLAlchemy
pyodbc
Project Management
Data Visualization
Process Automation
Cross-functional Leadership

Professional Experience

Engineering Operations Analyst III – Enterprise Business Intelligence

2020 - Present
Comcast | Plymouth, MI (Remote)
  • Continual project management and analysis for Engineering Operations
  • Improved reporting from manually updated spreadsheets to database connected Tableau for automation and better insights
  • Built Tableau reports using LOD calculations and Row-Level Security for precise data callouts
  • Automated manual ad hoc reports through Python scripting (Pandas, Numpy, pyodbc, SQLAlchemy)
  • Built and maintained dashboards with over 10,000 weekly interactions by over 5000 users
  • Managed user data collection through MS Forms, MS Power Automate, and Python scripting
  • Assisted senior leadership with scripted data analysis for company resource planning
  • Led cross-functional team to develop new metrics and managed rollout to over 400 employees

Technical Operations Supervisor – Commercial Services

2007 - 2020
Comcast | Sterling Heights, MI
  • Led a specialized Commercial Services team ranging in size from 10-15 employees
  • Managed fundamental metrics – regularly ranked in the top 5% for the region
  • Onboarded new employees to Commercial Services environment
  • Performance management through one-on-one meetings and in-field training
  • Managed region accountability reporting for tool/ladder budgeting, inspection compliance, and payroll compliance
  • Created and managed easily distributable reports utilized by numerous technical operations locations

Web Programmer / System Administrator

2005 - 2007
Blue Sphere, Inc. | Ada, MI
  • Managed project to upgrade 4 development servers used for file management, web server, email server, and virtual computer platform
  • Supervised customer relations with designated accounts to drive customer satisfaction and repeat business

Software Support Engineer

2003 - 2005
Harris Corp formerly Encoda Systems, Inc. | Grand Rapids, MI
  • Oversaw and managed new revenue unit of proprietary web portal reporting product
  • Led onsite training at customer locations throughout the country - 50% travel

Featured Projects

Engineering Operations Dashboard

Transformed manual reporting processes into automated Tableau dashboards with database connectivity, serving 5,000+ users with 10,000+ weekly interactions.

Tableau LOD Calculations Row-Level Security

Dashboards

Data Automation Pipeline

Developed Python scripts to automate daily data updates and reporting processes, reducing manual work by 80% and improving data timeliness.

Python Pandas SQLAlchemy pyodbc
# Sample automation code
import pandas as pd
from sqlalchemy import create_engine

# Connect to database
engine = create_engine('mssql+pyodbc://...')

# Process data
df = pd.read_sql('SELECT * FROM metrics', engine)
df['new_metric'] = df['value'] / df['baseline']

# Output to dashboard
df.to_sql('dashboard_metrics', engine, if_exists='replace')

Cross-Functional Metric Development

Led a team to develop and implement new operational metrics adopted by 400+ employees, improving performance tracking and accountability.

Project Management Data Analysis Stakeholder Engagement
Metric Adoption Rate 92%
Process Efficiency Gain 35%

Technical Operations Reporting

Created and managed distributable reports for technical operations locations, improving compliance tracking and resource allocation.

Excel VBA Data Visualization
95%
Tool Compliance
98%
Inspection Compliance
100%
Payroll Accuracy

Education

Bachelor of Business Administration - Management

Grand Valley State University

December 2002

Emphasis in Organizational Information Systems

Get In Touch

Contact Information

Location

Saint Clair Shores, MI

Email

john@johnroyston.com

Phone

616-540-3323

Connect With Me

Send Me a Message