Colton Rogers

Problem Solver & Automation Specialist

I build effective solutions to solve painful problems. Collaboratively. Through whatever means necessary. Preferrably with software and AI.

Let's Talk

About

Highly motivated and results-oriented individual with a proven track record of success in bridging the gap between people and technology. I specialize in analyzing complex challenges, collaborating with stakeholders, and developing user-centric solutions that optimize processes, automate workflows, and drive efficiency.

My background is in collaboratively developing creative solutions that solve painful problems, with a passion for leveraging technology to unlock new possibilities and achieve business objectives.

Skills

Product Management

  • Agile Methodologies
  • User-Centric Design
  • Product Roadmapping
  • Requirements Gathering
  • Stakeholder Management
  • Process Optimization

Project Management

  • Project Planning & Execution
  • Process Improvement
  • Workflow Design
  • Change Management
  • Innovative Problem Solving
  • Critical Thinking

Technical Skills

  • Google Workspace
  • Microsoft Office Suite
  • Google Apps Script
  • JavaScript
  • HTML & CSS
  • SQL & BigQuery
  • E-commerce/OMS Platforms
  • ERP/MIS Systems

Communication & Collaboration

  • Skills Training & Development
  • Public Speaking
  • Documentation
  • Mentoring
  • Relationship Development
  • Networking
Let's Talk

Experience

RRD

August 2021 – Present

Systems & Processes Training & Support Specialist

  • Managed the development of reports and dashboards for KPIs, collaborating with stakeholders, including the VP of BU Optimization for the platform, to define requirements and optimize business processes.
  • Designed and implemented multiple automations and Google Apps Script solutions to streamline inter-company workflows and improve efficiency easily saving several hundreds of hours of human labor over the last 18 months.
  • Led training initiatives for teams across RRD's Packaging Print facilities, for groups as large as 300+, in their use of the software tools and SOP, providing comprehensive support and documentation.
  • Developed and maintained training materials, user guides, and process documentation to ensure successful system adoption and utilization of the systems and processes.
  • Provided support to users across the platform through troubleshooting and issue resolution.
Google Apps Script Process Optimization Training Documentation Automation

RRD

July 2019 – August 2021

RRD Associate, Operations, at McKay

  • Rotated through various departments (Plant Scheduling, Database/Direct Mail, E-commerce & Fulfillment, Bindery, Letter Press) to gain a comprehensive understanding of operations and identify areas for improvement.
  • Project managed the transition of major accounts to new e-commerce platforms, ensuring seamless integration and customer satisfaction.
  • Developed and implemented a digital process for managing receiving to the warehouse that replaced a very manual process, optimized for efficiency, access to paperwork, and improved flow of communication. Reduced pages printed by 73%.
Project Management E-commerce Process Improvement Operations

McKay Press

April 2017 – June 2019

Information Technology Project Manager

  • Managed e-commerce websites, including customer service, user accounts, product listings, and website settings for various fulfillment accounts.
  • Project managed three e-commerce site launches, including one with Coupa integration, ensuring successful implementation and functionality.
  • Provided exceptional customer service, addressing inquiries regarding orders, payments, shipments, and returns.
  • Assisted fulfillment clerks during peak periods to ensure timely order processing and shipping.
E-commerce Project Management Customer Service IT
View Full Résumé Let's Talk

Projects

HTML Sidebar for Google Sheets

Developed a sidebar to enable commenting on rows in Google Sheets, ensuring persistent feedback regardless of updates to the sheet data.

Google Apps Script HTML CSS JavaScript
HTML Sidebar for Google Sheets

Automated Daily Dashboard Updates

Created an automation to consolidate data from multiple large spreadsheets into a centralized dashboard, improving data visibility and analysis.

Google Apps Script Data Analysis Automation
Automated Daily Dashboard Updates

Travel Consolidation Tool

Built an advanced Google Sheet to track travel schedules across dozens of team members, identify overlapping trips or unavailability. Integration with Google Calendar using Google Apps Script allows anyone to view trips in their calendars.

Google Apps Script Google Calendar API JavaScript
Travel Consolidation Tool

MDTS Maker Google Workspace Add-on

Developed an add-on to automate the consolidation of records from numerous files into a single spreadsheet, saving hundreds of hours and eliminating opportunity for human error.

Google Workspace Add-on Development JavaScript
MDTS Maker Google Workspace Add-on

LookSmarter Google Chat App & Add-on

Created a tool to provide quick answers to common questions directly within Google Chat and other Workspace apps, streamlining information access and reducing search time.

Google Chat API Google Workspace JavaScript
LookSmarter Google Chat App & Add-on
View All Projects Let's Talk

Contact

Interested in working together? Let's schedule a 15-minute conversation to discuss how I can help solve your challenges.

Send a Message

Schedule a Call

Book a 15-minute conversation directly on my calendar.

Schedule Time

Or email me directly at colton.rogers.reach@gmail.com