Kirk Hopkins

hopkinks@MiamiOH.edu (adjunct faculty)
kirkhopkins0057@gmail.com (personal)

Education

Miami University

Oxford, OH 45056

Bachelor of Science in Business
Major in Marketing
Minor in Arts Management
Minor in Percussion Performance
August 1989-December 1992

Alpha Phi Omega - national co-ed service fraternity

Work History

City of Cincinnati

Computer Systems Analyst

March 2021-Present

Research and development including reviewing and selecting eLearning course creation software/video editing software, and video editing audio hardware
eLearning course development including script writing, video creation with transcripts and captioning, and assessments

March 2021-present specific accomplishments

Brought unique skills and talents to the CAGIS group not previously seen, including video production, audio/music production, script writing, and eLearning course creation experience
Researched, reviewed and selected video editing hardware (microphone) and software to be performed by multiple people using windows machines.
- Documented and standardized the process of creating videos.
- Created a training video on how to create CAGIS branded training videos.
Recorded and edited narration for videos.
Recorded, mixed, and produced music and other audio for videos.
Helped define the methodology for creating courses, created a template, and create content on the edX platform:
- wrote cohesive story-like scripts including light humor and animations to keep it interesting for learners for the "watch" section based on topics highlighted by co-workers expertise
- created "test your knowledge" with the group
- created "try it"
- created "learn"
- 119 videos
- 20 videos revised
- 16 screen recordings used in presentations/demos
Created video splash screens and other animations.
Created srt files for video captioning and transcripts on edX.
Created vtt files for closed captioning for public videos (and edX "learn more" about the course videos).
Presented CAGIS Academy (edX) to the CAGIS Advisory Board
Created textures for use in CAGIS Academy course cards and program cards
Data migration
- Assisted with creating views to migrate data from Permits Plus to CAGIS Edge
2022 Healthy Hero
- for exemplifying what it means to truly lead a healthy lifestyle
- for inspiring and motivating others to live a healthy lifestyle
- for leading by example and showing others how good it feels to be healthy
Presentations:
- CAGIS Academy on boarding sessions
- 12-21-2022 CAGIS TAC (Technical Advisory Council)

UNI creating solutions LLC

Owner

July 2020-Present

Software as a Service (SaaS), a housing management system for higher education
Stood a web server
Designed and developed all software using PHP and a Postgres database; software includes:
- Login page
- Logging
- Email capabilities
- Dynamic reporting
- API
- NoSQL style database
- Designed for mobile devices
- Simple to use interface
- Automated backups
System quantity and stress test performed to verify robustness of the design and hardware
Created video based end-user documentation
Direct email based targeted marketing
Commissioned a designer to create a unique font and logo

Miami University

Senior Lean Leader

February 2019-June 2020

Lean Certification information - I was part of Fall 2016 cohort
Learning Outcomes:
- Exhibit skills of a Lean Leader, and
- Ability to serve and apply Miami Lean principles as a recognized experienced Lean project team leader
- Possess advanced technical skills to effectively apply fundamental, technical, and acceptance tools to Lean projects
- Ability to manage process implementation plans
- Effectively serve as a resource and mentor for Lean Leader trainees
For completion of Senior Lean Leader level: all Lean Leader requirements (see above), additional training hours (including required courses and participation in approved seminars and conferences relating to Lean, Six Sigma, Agile, Leadership and Innovation and Creativity) to equal a minimum of 100 total hours, lead 2 additional projects, present a significant project to the Miami Lean Program Review Board
- Technical Training required (29 hr):
  - Agile Training (8)
  - Quality (14)
  - Innovation, Creativity and Immersion (7)
- Training Hour Electives (not previously taken):
  - Building and Maintaining Your Team (3)
  - Building a Reputation of Integrity (3)
  - Facilitating Effective Meetings (3)
  - Communications Role in Management (3)
  - Strengths Based Leadership (3.5)
  - Presentation Skills (7)
  - Conflict Management (3)
  - Participate in pre-approved seminars or conferences relating to Lean, etc.
- Successfully lead two traditional or Kaizen process improvement projects
- Present a significant project to the Miami Lean Program Review Board
Continuation at Senior Lean Leader level: 1 education (7 hours) requirement, 1 training requirement, and project involvement (1 project lead or 2 project participations) per year

Miami University

Senior Systems Specialist

September 2019-June 2020

Define, implement and execute standard technology support processes for all of Finance and Business Services
Manage and execute operational projects that focus on improving overall stability and functional enhancements of current Finance and Business Services systems
Provide 2nd level, technical support to end users on various technical issues and problems relating to Finance and Business Services applications
Responsible for responding to, documenting and resolving service tickets in a timely manner according to Service Level Agreements
Perform all routine and day to day operational tasks associated with assigned systems and integrations
Plan, design, and execute options to eliminate dependency on the support team to execute operational tasks via automation, conversion to self-service, or task re-assignment
Serve on the Change Advisory Board (CAB) where decisions are made regarding timing of changes, risk assessment for changes, and overall, governing changes for enterprise systems across the university

Miami University

Associate Director of Technology

November 2017-August 2019

Product management in the investigation of replacing the housing portion of MyCard, an in-house university-wide web system, with vendor purchased solutions
Future plans to identify and investigate replacing other areas of MyCard with vendor solutions
Presenter - 2018 Plug-in & Reboot Conference - "Web Page Assignment Viewer & Auto Grader"

Miami University

Associate Director of Technology

December 2015-November 2017

Continued development of MyCard, an in-house university-wide web system that provides a large number of solutions for students, faculty, & staff which includes interfaces to multiple systems, reporting, employee management/development, housing/meal plan management, and more
Definition, hiring, and management of 2 new technology positions for HDRBS (Housing, Recreation, Dining, and Business Services) department
Manage/prioritize/complete technology requests
ITservices FAST (Focused Action-oriented Solution-centric Tenacious) team to document, methodologies, tools, languages, and frameworks used in Solution Delivery
Budget work for technology in the department
Completed the Supervisor Development Series
Began Lean Certification process
Project owner for a spring 2016 student/class project with Doug Havelka's Information Systems and Analytics IT Project Management class (ISA406) to modify floor plans in MyCard to meet accessibility standards
Presenter - 2016 William Henry Harrison High School Career Day
Presenter - 2017 Lean Fair
Presenter - 2017 OHECC (Ohio Higher Ed Computing Council) - "Working Across Departments to Automatically Assign Students to a Class" at The Ohio State University
Presenter - 2017 OHECC (Ohio Higher Ed Computing Council) - "Home-grown Lean Tracking System" at The Ohio State University
Presenter - 2017 Plug-in & Reboot Conference - "Creating a WCAG 2.0 Level Web Form From Scratch"
Developing Great Managers - Certified

Miami University

Senior Systems Analyst

October 2013-December 2015

Development of MyCard, an in-house university-wide web system that provides a large number of solutions for students, faculty, & staff which includes interfaces to multiple systems, reporting, employee management/development, housing/meal plan management, and more
Prioritization and management of project/task list
Alpha-tester for GIT version control repository
FAST (Focused Action-oriented Solution-centric Tenacious) team participation
- OATS - Oracle Application Testing Suite
- Source Code Repository (GIT)
- Next generation automated password reset process
- Solution Delivery Accessibility Standards
- Solution Delivery On Boarding
Workshop - How to Listen Effectively
Presenter - 2015 OHECC
Back to School - tech help tent volunteer
Accessible Design using ARIA and HTML5 to meet WCAG 2.0 Requirements - sessions
Penn State Web Conference - Accessibility track
LEAN Participation
- Job Enrichment Application Kaizen
- HRS0016 Organizational Learning Lean Project
- HDR0001 Converting into MyCard forms for student facility supervisors
- HDR0010 Enhancements to Meal Plans for Increased Sales
- HDR0013 Enhanced Customer Service & Retail Space
- FIN0010 Student package delivery
- HDR0016 Summer Storage Improvements
- VPF0003 Lean Suggestion Program Phase 2
- VPF0001 Lean Suggestion Program
- JDI-Online Single Room Request - MyCard Update
- JDI - Connecting the Meal Plan and MUlaa additions with a link to the direct pages
- JDI-Enable Online Housing & Meal Plan Contracts for Relocation Students
- VPF0004 Lean Certification Curriculum Revision
- Improve Pre-Semester and Break Housing Billing Process
- HRS0011 Tracking lean participation and certification
- JDI-Update MyCard Group Housing & Meal Plan Request program to allow staff to edit requested dates

Miami University

Manager of Information Technology (also titled Manager of Meal Plans and Housing Information Technology)

March 1998-October 2013

Co-creator and developer of MyCard
Agile extreme pair programming
Design, develop, & maintain web content
Early adopter of responsive design allowing one web site to display properly for all devices
Work directly with clients to determine needs, timelines, and strategies to achieve common goals
15-time award winner for Audio/Video productions from The Videographer Awards, an international videographer competition
Graduate of the Collegiate Management Institute (Central Association of College and University Business Officers)
Awards: Pride in Service & Miami Pride
Certificate of Achievement for Information Builders WebFOCUS
Altiris Course Completion Certified
Presenter - CUCON conference (Card Users CONference)
Presenter - NACUBO (National Association of College and University Business Offices) regional housing conference
Support a MICROS POS (Point of Sale) dining system that averages more than 20,000 transactions daily
Evaluate, select, and implement new technology
Continuously seek new solutions to reduce costs while offering a better experience for clients

Miami University

Manager of Bookstore Computer Department

August 1994-March 1998

Student staff managing, scheduling, and training
Responsible for selecting, purchasing, managing, and sales of a multi-million dollar operation
Desktop publishing: design/publish brochures, posters, newspaper ads table tents, & flyers
Web publishing, early adopter of providing web pages at Miami

Circuit City

Sales Counselor

February 1993-August 1994

Database development used to send out thank you letters to customers
President's Club
Customer guidance on product selection

Visiting Faculty/Adjunct Professor

Spring 2021 IMS222 D (term 202120)

IMS - Interactive Media Studies (Department of Emerging Technology in Business and Design)
Course Name: Intro to Interaction Design
Online class using Zoom and extensive use of "Tell Me" - interactive polling in class
Zoom breakout rooms replacing Peer Assignment Review for collaboration
Added Tell Me Poll Cumulative Results to the class site home page
Offered extra credit for Project 02 (MyInterest.htm) and Project 03 (HireMe/index.php) for starting early
Online course teaching HTML5, CSS3, PHP, and Responsive Design

Fall 2020 IMS222 G (term 202110)

IMS - Interactive Media Studies (Department of Emerging Technology in Business and Design)
Course Name: Intro to Interaction Design
Online class using Zoom and extensive use of "Tell Me" - interactive polling in class
Random student pairing for Peer Assignment Review via PHP script
Offered extra credit for Project 03 (HireMe/index.php) for starting early
Online course teaching HTML5, CSS3, PHP, and Responsive Design

Spring 2020 IMS222 D (term 202020)

IMS - Interactive Media Studies (Department of Emerging Technology in Business and Design)
Course Name: Intro to Interaction Design
Addition of "Tell Me" - interactive polling in class
Random student pairing for Peer Assignment Review via PHP script
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design
Related student/class project with Dr. Byran Smucker's statistics class (STA475) to provide more data to students to be able to steer the class towards higher student learning that will be reflected in better grades.
Assist Jinghui Yang with a student project for Dr. Demarks' Interactive Media Studies Senior Degree Project (IMS452D) to provide more data to students to be able to steer the class towards higher student learning that will be reflected in better grades.

Fall 2019 IMS222 section C (term 202010)

IMS - Interactive Media Studies (Department of Emerging Technology in Business and Design)
Course Name: Intro to Interaction Design
Providing data about previous semester data
Peer Assignment Review added
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Spring 2019 IMS222 section D (term 201920)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Taking attendance via ID card
May allow for email notifications for upcoming assignments
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Fall 2018 IMS222 section C (term 201910)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Added 20 minutes of pre-class time and 20 minutes of post-class time for individual help
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Spring 2018 IMS222 section F (term 201820)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Moved course site to Bluehost
Student sites now off UDS
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Fall 2017 IMS222 section C (term 201810)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Spring 2017 IMS222 section D (term 201720)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Adapted recently re-worked course material to work in an online class setting
Created an automatic grader to grade mechanics of web pages
Online course teaching HTML5, CSS3, PHP, and Responsive Design
Added "class time" based on student feedback
Responsive Design

Fall 2016 IMS222 section UD (term 201710)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Re-worked all course material
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design
Teaching Assistant helped on Thursday 1:1 time

Spring 2016 IMS222 section D (term 201620)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

Fall 2015 IMS222 section UD (term 201610)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design
Teaching Assistant helped on Thursday 1:1 time

Spring 2015 section A IMS422/IMS522 A (term 201520)

IMS - Interactive Media Studies
Course Name: Advanced Web and Interaction Design
Online course teaching APIs, PHP, MySQL (database), and xAMP
Builds upon HTML5, CSS, and Responsive Design

Fall 2014 IMS222 section UD (term 201510)

IMS - Interactive Media Studies
Course Name: Web and Interaction Design
Hybrid course teaching HTML5, CSS3, PHP, and Responsive Design

CSE 311 Software Architecture and Design - Subject Matter Expert

Attended one class session and provided a general overview of MyCard
Attended a ten minute agile stand up scrum of scrums twice weekly to answer questions and help resolve issues/obstacles to progress
Provided source information and documentation necessary to understand and render the architecture views
Validated architecture renderings developed by the MyCard application team for completeness accuracy and usefulness
Attended a final showcase of CSE311 work with the IT Services Leadership Team at the end of the semester

Programming Languages and Databases

CSS3
HTML5
Javascript
MS SQL
MySQL
Oracle
PHP
PostgreSQL
Responsive Design

Software as a Solution experience (created the following solutions)

Academic course assigner
- Assigned over 2000 students to a specific UNV101 course each year based on their housing, major, and other factors to respective courses in Banner for 2 years
- Office involvement: Registrar and Office of Residence Life
Account transfers
- Transfers funds from one account to another in CSGold
- Dispersed funds management
- Office involvement: Bursar, Financial Aid, and the Campus Services Center
Additional deposits
- 117,322 meal plan account deposits during the semester
- Restrictions based on meal plan held, account balance (in CSGold), time left in the semester, and recent deposits
- Office involvement: Bursar and Campus Services
Attendance
- Attendance taken for 137,794 people at 1,641 events using ID magnetic stripe swipes, ID NFC taps, and UniqueID/password lookups
- Limits people to attending once per day or check-in and check-outs (for College of Creative Arts performance attendance tracking for music majors and minors)
- Associates events with courses and sections for academic needs
- Events created by Faculty or Staff, attendance taken by anyone with an active account at Miami (i.e. students can check people in)
- Office involvement: School of Business, College of Creative Arts, and Office of Residence Life
Battery level tracking (Door lock battery level data from ID card system)
- 4,015,224 records from 2017 thru 2020
- Office involvement: IT staff

Billing

AC Approval (Air Conditioning)

Approval system created to allow staff in the health center approve or deny requests
Totals that could be supported changed as buildings were renovated

Line	Academic Year	Transactions	Amount
1	2004	396	$29,680.94
2	2005	356	$70,085.94
3	2006	566	$83,753.37
4	2007	1,324	$173,905.29
5	2008	1,951	$270,379.30
6	2009	2,167	$332,651.09
7	2010	2,355	$359,028.23
8	2011	2,174	$333,127.27
9	2012	2,588	$379,608.34
10	2013	3,041	$426,602.47
11	2014	3,294	$452,574.28
12	2015	2,443	$381,767.28
Totals		22,655	$3,293,163.80

Additional Meal Plan Deposits (most done through MyCard)

Numbers changed as meal plans changed back and forth to/from counts and declining balance

Line	Academic Year	Transactions	Amount
1	2000	10,418	$1,768,526.80
2	2001	13,655	$4,096,411.88
3	2002	21,203	$6,052,146.78
4	2003	22,992	$7,006,077.54
5	2004	23,860	$7,251,052.43
6	2005	23,840	$7,776,336.82
7	2006	22,149	$7,550,383.98
8	2007	24,169	$8,940,191.50
9	2008	25,063	$10,054,300.41
10	2009	25,126	$10,978,652.43
11	2010	27,663	$13,032,967.60
12	2011	26,316	$13,228,746.94
13	2012	24,050	$16,565,943.78
14	2013	25,110	$17,260,551.95
15	2014	32,626	$15,946,980.35
16	2015	45,498	$22,328,885.93
17	2016	46,956	$20,894,723.31
18	2017	23,643	$4,512,437.35
19	2018	24,135	$4,364,399.00
20	2019	19,642	$3,330,554.13
21	2020	11,553	$2,031,707.17
Totals		519,667	$204,971,978.08

Break Housing

Line	Academic Year	Transactions	Amount
1	2002	1,854	$66,030.00
2	2003	964	$47,785.00
3	2004	1,363	$65,640.00
4	2005	1,418	$58,482.30
5	2006	1,036	$52,850.00
6	2007	1,145	$69,230.00
7	2008	1,470	$94,650.00
8	2009	2,225	$140,090.00
9	2010	2,029	$154,103.00
10	2011	2,193	$150,720.00
11	2012	3,415	$265,249.00
12	2013	4,159	$324,008.00
13	2014	12,759	$566,178.79
14	2015	7,798	$694,463.40
15	2016	8,951	$787,664.64
16	2017	10,557	$896,457.30
17	2018	9,842	$751,163.00
18	2019	7,302	$620,516.22
19	2020	4,968	$419,973.50
Totals		85,448	$6,225,254.15

Housing (and related services) and Meal Plans

Line	Academic Year	Transactions	Amount
1	2002	497,079	$54,018,713.59
2	2003	461,369	$51,446,187.80
3	2004	391,523	$50,483,311.60
4	2005	450,940	$53,735,681.01
5	2006	379,044	$57,729,976.62
6	2007	501,456	$71,060,159.22
7	2008	496,471	$75,981,996.44
8	2009	499,591	$80,657,992.47
9	2010	498,535	$96,438,969.49
10	2011	512,998	$114,814,091.89
11	2012	463,696	$119,771,815.77
12	2013	480,459	$126,535,550.05
13	2014	563,873	$136,899,924.26
14	2015	598,500	$142,762,325.24
15	2016	602,278	$141,294,330.75
16	2017	570,805	$114,981,851.09
17	2018	568,606	$125,528,109.90
18	2019	562,567	$130,022,963.81
Totals		9,099,790	$1,744,163,951.00

ID Card - Damage/Lost/Broken

Transactions via MyCard from June 2017 to June 2020

Line	Description	Transactions	Amount
1	Damaged ID Card: $10.00	3,555	$35,550.00
2	Lost ID Card: $35.00	9,426	$329,910.00
3	Returned Temp ID Card: Refund $5.00	208	$-1,040.00
4	Temp ID Card: $15.00	302	$4,530.00
Totals		13,491	$368,950.00

Laundry Service

Line	Academic Year	Transactions	Amount
1	2009	650	$78,733.89
2	2010	552	$117,726.26
3	2011	750	$151,228.34
4	2012	986	$189,407.97
5	2013	890	$185,621.60
6	2014	782	$173,238.10
7	2015	806	$182,795.68
8	2016	1,872	$265,415.03
9	2017	1,287	$289,605.24
Totals		8,575	$1,633,772.11

MUlaa (mostly non-meal declining balance account)

Line	Academic Year	Transactions	Amount
1	2002	5,540	$260,949.96
2	2003	7,000	$487,480.80
3	2004	8,505	$1,468,930.18
4	2005	9,826	$1,904,792.48
5	2006	11,768	$2,038,725.34
6	2007	14,350	$2,597,592.87
7	2008	16,780	$2,605,754.41
8	2009	17,309	$2,677,482.99
9	2010	18,892	$2,897,800.96
10	2011	20,911	$2,867,758.58
11	2012	17,588	$2,480,761.53
12	2013	23,954	$3,639,138.33
13	2014	41,913	$4,900,534.05
14	2015	38,888	$3,726,549.87
15	2016	41,860	$4,114,309.14
16	2017	37,039	$3,909,900.15
17	2018	36,118	$3,550,381.49
18	2019	34,422	$3,135,805.64
19	2020	27,166	$2,115,730.61
Totals		429,829	$51,380,379.38

Refrigerator Rental

Line	Academic Year	Transactions	Amount
1	2002	1,210	$48,444.50
2	2003	948	$39,331.00
3	2004	3,871	$143,834.05
4	2005	6,554	$237,862.53
5	2006	5,511	$212,774.39
6	2007	6,827	$242,869.78
7	2008	6,888	$242,761.65
8	2009	7,076	$244,771.48
9	2010	7,442	$251,078.59
10	2011	7,469	$256,411.15
11	2012	7,983	$266,962.90
12	2013	6,948	$300,165.76
13	2014	6,911	$302,818.27
14	2015	6,670	$315,318.30
Totals		82,308	$3,105,404.35

Room Cleaning

Line	Academic Year	Transactions	Amount
1	2009	462	$19,731.88
2	2010	334	$27,408.30
3	2011	406	$37,702.87
4	2012	350	$54,274.27
5	2013	305	$29,572.85
6	2014	365	$37,429.12
7	2015	353	$40,225.29
Totals		2,575	$246,344.58

Room Damage

Line	Academic Year	Transactions	Amount
1	2002	943	$21,292.42
2	2003	770	$19,603.58
3	2004	627	$12,350.98
4	2005	742	$18,034.71
5	2006	1,023	$20,215.53
6	2007	1,543	$33,242.92
7	2008	1,187	$25,030.61
8	2009	1,096	$18,588.62
9	2010	1,569	$27,980.18
10	2011	1,322	$26,769.99
11	2012	1,110	$22,254.92
12	2013	2,430	$55,729.69
13	2014	2,504	$61,200.65
14	2015	3,352	$80,829.14
15	2020	2,500	$63,903.58
Totals		22,718	$507,027.52

Start Fresh (laundry starter kit delivered to the room before check in)

Line	Academic Year	Transactions	Amount
1	2009	245	$8,277.97
2	2010	124	$4,595.40
3	2011	110	$4,795.20
4	2012	151	$5,244.75
5	2013	149	$6,343.65
6	2014	200	$7,992.00
7	2015	235	$9,440.55
Totals		1,214	$46,689.52

Summer Storage

Line	Academic Year	Transactions	Amount
1	2009	66	$2,630.01
2	2010	311	$41,002.05
3	2011	304	$46,970.50
4	2012	341	$55,460.05
5	2013	383	$75,989.00
6	2014	307	$58,288.23
7	2015	322	$59,872.79
8	2016	220	$42,227.16
Totals		2,254	$382,439.79

Stuff 4 My Room (linens, lamps, rugs, memory foam, fans - delivered to the room before check-in)

Line	Academic Year	Transactions	Amount
1	2012	686	$66,334.66
2	2013	655	$75,883.11
3	2014	647	$90,266.50
4	2015	750	$107,762.45
5	2016	983	$138,001.90
6	2017	2,055	$153,001.40
7	2018	1,422	$129,994.23
Totals		7,198	$761,244.25

Cardholder statements
- Replaced paper statements by automatically generating and reading a paginated report from an ancient system to create web statements back before it was cool
- 46,297,760 statement records provided from 08-13-2003 thru 06-30-2012
- Office involvement: Bursar and Campus Services
Cash sales
- Tally sheet for register/till balancing and recording
- 28,723 records
- Office involved: Shriver Business Office, Dining Services, and the Box Office
Contest tracking (Photo Book)
- Signup for a contest, 71 signups
- Used a previously existing table for signups
- Office involvement: Bookstore
Customer Relationship Manager (CRM)
- Track customer contacts
- 334,594 records of communication
- Office involvement: Campus Service Center
Dashboards
- System tracking for CSGold and Housing
- Office involvement: IT Staff and Campus Services
Digital display advertising
- 272 user created/submitted timed ads displayed every 8 seconds across 42 screens via text file automation to display one ad everywhere for 8 seconds from 2011 thru 2014
- Requests made by student organizations and departments
- ad request with size, format, and billing information requirements
- image upload via the web form
- ad approval and automated displaying of approved ads
- Office involvement: Marketing
Dining POS product control
- MICROS products governed by dining location managers via MyCard
- 91,851 changes managed from 2008 thru 2015
- CURL used to send/receive data
- Timed updates to allow product changes during off peak hours
- Approval process for pricing and naming verification
- Annual price increase option created for director of dining services with suggested changes using 5, 9, 0 ending prices based on a percentage from the director and other product-type factors
- Office involvement: Dining Services
Distributed admin/management of various system areas
- Groups created to allow non-IT staff to manage access in the system (basically a system administrator for a subset of the system) for 360 surveys, Lean Tracking, Loans, Patron Tracking, and Door Managers
- Programs duplicated and modified to allow for easy ID look-ups, addition, and removal of existing ID's for each group
Employee database
- Human Resources management for a large department of 700 people
- Automatic email notifications to managers when employees change locations
- Door access and meal plans automatically adjusted in the ID card system
- Office involvement: Campus Services
- Related applications
  - Innovative Leadership Awards
    - 75 nominations from 2008 thru 2018
  - Internal Reassignment Requests
    - 491 requests from 2009 thru 2014
  - Leave Request Approval (after annual vacation requests)
    - 70 requests from 2011 thru 2013
  - Location management
    - 231 records from 2004 thru 2020
    - A tool used by administrative staff to manage locations
  - My Employee Reports
    - Dynamic reports based on location, location groups, job type, status (active, terminated, resigned, etc), hourly or salaried, and full time or part time type hours
    - Option to add data to standard reports
    - Option to create XLS and CSV files
    - Option to send emails, add photos, and create a photo book
    - Option to re-sort results ascending or descending on one column
    - Additional summary report created automatically based on the sorted results
    - Access to report sections based primarily on groups
  - Overtime management
    - 3,565 request forms from 2000 thru 2020
    - 50,354 opportunity searches from 2000 thru 2020
    - 7,281 offers accepted/denied from 2000 thru 2020
    - Search by seniority based on job needs and staff abilities to meet Union guidelines
  - Student Employment Applications
    - 4,886 applications from 2002 thru 2009
  - Student Evaluations
    - 68,934 evaluations from 1998 thru 2020
    - email and PDF capability to send to the student worker
    - Evaluated by management and designated staff
    - Legend and time based dashboard used for hiring/re-hiring
  - Subsidized Meals
    - 1,641 department subsidized meals tracked from 2002 thru 2013
  - Surveys
    - 85 surveys with 97,476 responses from 2001 thru 2012
    - Reporting based on hall, gender, and response data
    - 2,687 (of the 97,476 responses were for) 360 (peer) survey responses from 2012 thru 2015
  - Vacation Requests and Approval
    - 8,791 requests from 2010 thru 2017
Extracts
- CSV
- FTP
- sFTP
- txt
- Web services
- XML
Financial Aid processing
- Grabs records from the Student Financial Aid ID card system import and emails a Banner billing file to the logged in person
- Office involvement: Bursar and Financial Aid
Group housing and/or meal plans
- Allow faculty and staff to send requests for group housing and/or meal plans
- Requests are approved or denied
- Billing information is generated for groups and/or individuals
- 55,923 records from 2006 thru 2020
- Office involvement: Campus Services
Hotel-style accommodations (Plans for Break)
- Sign-up is done by the student
- 6 times a year students can ask to stay in their room during times not covered under their contract
- Rates varies per cohort, room type, and time period
- Approval process automatic and manual depending on needs
- Billing over-ride option exists
- Potential bills shown before manually sending over bills (by Campus Services)
- 636,844 records from 2006 thru 2020
- Office involvement: Campus Services Center
Housing
415,581 occupancy records from 2002 thru 2020
3,046,975 ID (people) records from 2002 thru 2020
- Buildings
- Campus map
- Current student contract
- Door access control
- Floor plans
- Housing change notification
- Incoming student contract
- Mass room changer
- Meal plan sign-up/management
- ODH (Ohio Department of Health)
- People
- Room assignments
- Room change requests
- Room selection
- Roommate checker
- Roommate finder
- Rooms
- Utilities to administer the system
- Various service sign-ups/management
- Office involvement: Campus Services Center
Job Enrichment/Staff Development
- 88,037 attendance records (includes imported) from 1972 thru 2020
- Application and status based on imported data and time frames
- My Job Enrichment Event Consolidater tool
- My Mass Job Enrichment Event Changer tool
- Office involvement: Human Resources, Physical Facilities, and Campus Services
ID Changes
- Notify students of their new ID # after a faculty member mistakenly published ID numbers for the incoming class
- 3,692 records in 2008
- Office involvement: Central IT, Bursar, and Registrar
ID checker
- Swipe ID to see their name
- Validates that the ID (magstripe) is really who you think they are (by showing their name)
- Looks in MyPeople for the ID read from the magstripe
- Office involvement: Bookstore computer department
Impersonate (login as) option
Kiosks
- Advertising/nutritional information
- Scoreboard Market
- Standalone (ASUS)
- 1,166,201 orders from 2007 thru 2017
- Office involvement: Dining Services
Lean tracking
- 36,392 records from 2014 thru 2020
- Used university-wide to track Lean ideas and projects
- Office involvement: Lean Office
List (ID) converter
- Utility to change IDs
- Can add some key information to the list
- Office involvement: IT staff
List comparison tool
- Utility to compare 2 lists, show matches and/or non-matches
- Office involvement: IT staff
Loans
- 276,348 loans from 2003 thru 2020
- ID swipe/tap to link to item loaned out
- Names and photo IDs shown for items still out on loan for the location
- Office involvement: Shriver Center, Rec Center, and Armstrong Student Center
Meal exchanges
- 869 requests to allow groups (usually teams) to use student meal plans for special meals and weekend roadtrips from 2003 thru 2020
- Validates IDs entered from lists
- Automatically deducts meals from student accounts on the day/meal period for the request(s)
- Office involvement: Campus Services
Meal Transactions/Reporting
- Imported dining location transactions from ID card system
- Dynamic reporting on student groups, conferences (via conference names in another system), lists, IDs in a series, by date range, location, location groups, time of day, day of the week, with selectable values added for count type transactions, with inclusions and exclusions, with 17 different report summaries
- 66,571,361 records from 2003 thru 2020
- Office involvement: Dining Services
Opening and closing checklists
- 77,365 records from 2012 thru 2018
- Staff used iPads to walk through the building and record the room status
- Office involvement: Rec Center
Ordering
- Better to Give
- Cake
- Me to You
- Pie sales
- Pizza
- 282,046 orders for 1,181,741 items from 2005 thru 2015
Parking
- 3,195 citation appeals from 2008 thru 2012
- 6,282 on campus student parking permit requests from 2005 thru 2011
- 17,185 staff parking permit requests from 2008 thru 2012
- 744 ticket void requests from 2016 thru 2019
- 14,154 vehicles recorded from 2008 thru 2012
Patron counts
- 31,060 periodic counts for the Rec Center of people by gender in different areas of the building from 2012 thru 2020
- 6,571 periodic counts for the Phillips of people by gender in different areas of the building from 2012 thru 2020
- Office involvement: Rec Sports
Pledge a meal
- Student signup to donate meals
- 15,479 meals donated
- Office involvement: Dining Services
Repair Request/Tracking
- Allow students to report problems in their room
- 87,643 records from 2004 thru 2018
- Office involvement: Housing and Physical Facilities
Replacement ID charger
- Allow staff to automatically bill for ID replacements
- 26,270 records from 2017 thru 2020
- Office involvement: Campus Services Center
Report Tracking
- 274,347 records (reports tracked) from 2007 thru 2020
- Office involvement: IT staff
Reporting
- Email
- Include photos
- PDF creator
- Static and Dynamic reporting
- XML
Room Inspection
- Allow students to inspect their rooms and highlight rooms where everyone completed an inspection or not
- Allow RAs to inspect their room, then switch over automatically to 'staff' mode
- Allow Housing Managers, Campus Services Center, and ORL (and RA) staff to inspect rooms and create/approve charges
- Shows students amounts for a list of potential charges
- Online Room Inspection and Roommate Agreement Quotes from November 2015
- Competitor information
  - www.chapps.com/en
  - 1 x fee $1,200
  - Annual fee per Inspector (RA, RD, Manager 322 people) @ $120 per person = $38,640
  - Annual fee per bed @ $3 per bed (7500 beds) = $22,500
  - roompact.com
  - 1 x fee $11,495
  - Annual Service Fee $23,999
- 187,429 inspection records from 2016 thru 2020
- Office involvement: Office of Residence Life and Campus Services Center
Roommate Agreement
- 179,498 inspection records from 2016 thru 2020
- Office involvement: Office of Residence Life
Specials (special order system)
- 136,973 special request records from 2002 thru 2020
- Office involvement: Dining Services
Staff development handbook
Summer Storage
- 32,273 storage request records from 2009 thru 2015
- Office involvement: Campus Services Center
Summer Conferences
- 4,435,797 records sent to CSGold and 270,802 records sent to Harco for summer conferences and other ID card related changes
- Interface between Conference Programmer (MS SQL) and the ID card system (proprietary database and then Oracle)
- Door access, meal plans, and declining balance
- Reporting for private and public distribution
- Office involvement: Conference Services
System documentation
- Automation on a daily basis to automatically track information about programs in the system
- 3,212,146 records from 2017 thru 2020
- Office involvement: IT staff
Ticket system (service and project management)
- Allow all faculty and staff to send requests to the general HDRBS IT to do list
- Ties into MyToDoList.php
- Added "Urgent" and share_with options so you can see things shared with you
- Goal, allow our customers to stay 'in the know' about questions/issues
- Allow them to do some trouble-shooting on their own
- Intake process for new requests, to be prioritized using MyToDoList.php
- 38,446 records from 2015 thru 2020
- Office involvement: IT staff
Utilities - automated and manually run
- My Admittance Code Batch Updater
- My Bookstore Importer
- My CSGold Count Plan Updater
- My CSGold Dining Dollars Updater
- My CSGold Extended Patron Info Checker
- My CSGold Hardware Setup Helper
- My CSGold MICROS Updater
- My CSGold Patron Group Access Refresher
- My CSGold Plan Closer
- My CSGold Plan Deposit
- My CSGold Plan Transfer
- My CSGold Report Research
- My Charge File Checker
- My Charge File Creator
- My Door Status Checker
- My Doors Presentation Research
- My Fall to Spring Rollover
- My ID Checker
- My Lean Personnel Manager
- My Lean Tracking Mass Unique ID Changer
- My List Comparison
- My List Converter
- My List Randomizer
- My Login As Someone Else
- My MUlaa Refund Banner File Creator
- My Mailroom Data Viewer
- My Marker
- My Mass Room Changer
- My ODH Info
- My Photo Lookup
- My Proration Chart
- My RAs With Roommates
- My Room Change Requests
- My Room Inspection Charger
- My Room Inspection Charger By Staff
- My Room Selection Group Assigner
- My Room Selection Time Controls Editor
- My Room Updater
- My ServiceRates Management
- My ServiceRates Rollover
- My Timeframe Editor
- My Waiting List Remover
- My XLCs Rollover
- My xLC Editor
Vending Refunds and Processing
- 840 requests from 2006 thru 2017
- 1,307 requests in a revised processing system from 2017 thru 2020
- Deposits made to ID card system (CSGold) for ID card purchase approvals
- emails sent out for verification for credit card refunds
- emails updates sent to customer for changes in their request (approval/denial)
- Office involvement: Vending
Waiting list
- 15,479 meal pledge records from 2004 thru 2012
- Office involvement: Dining Services
Web portal advertising
- Hard-coded targeted ads shown on the portal home screen

MyCard Stats

308 tables
System Cleanup Run time: 22.8500 min
338 million records (338,000,000)
Time to count records: 4.7 minutes
19 tables with over 1 million records
4 largest tables
- 87 million records (csgoldsvcandmealplanbalances)
- 66 million records (harcomeals)
- 37 million records (mylog)
- 33 million records (myguesttimeframepref)
Time to run a query on the 66 million record table with 8 case summations: 1 second
Time to insert 10,000 records: 53 seconds
5.47GB database backup zip file
2,958 php programs
2 Largest programs
- 37,909 lines of code (MyCardStatistics.php)
- 32,388 lines of code (MyScratchpadKSHcreateTestBillingFile.php)
MyCard folder size (php code): 33.8MB for 695 items
MyCardStorage folder size (images): 32GB for 342,179 files
MyCard birth history
- 1999 Web Cardholder Statements
- 2000 Employee Database & Overtime Systems
- 2001 My Account in place of Housing Assignment Letters for Incoming Students
- 2002 The birth of MyCard (i.e. separate systems incorporated in one portal and expanded into a full housing management system)
- MyCard and general technology history

Software

Mac OS
Adobe Creative Suite (photo editing)
Content Management Systems (various)
FileMaker Pro (database)
Final Cut Pro (video editing)
Firefox (web browser)
Google Chrome (web browser)
LibreOffice (word processing and spreadsheets)
Logic Pro (audio recording)
Picasa (photo editing)
Pixelmator (photo editing)
Safari (web browser)
Sibelius (music notation)
TextWrangler (text editing)

Other Technology Skills

Creating video tutorials/lessons
Photography
Videography
Personal Web Sites
- Blog
- gzuslivz (band website and band leader)
- Legacy Christian Church (plus "See How This Page Works")
- Photo Gallery (a way to share small, fast loading photos in a web friendly way and offers a way to download high quality versions of photos
- Songs/Chord Charts Responsive design allows using the system for live performances with an iPad (any tablet or phone) as well as wider screen devices
  Ad-free site
  Options for folks not logged in
  - Search for songs
  - Change the keys of songs
  Options for folks who are logged in
  - Add/Remove songs
  - Create/Remove/Order playlists/setlists
  - Invite others to see playlists/setlists
  - Option to add to playlists/setlists based on other "live" playlists/setlists
  - See past playlists/setlists
  - See songs recently added/updated
  - Personalize a song with a key change for your account and/or add notes about a song
  - Jump to any song in a playlist/setlist
  - Jump to the next song in a playlist/setlist
- The Perfect Website (a fully accessible sample website)
  - Meets (and shows how to meet) accessibility standards
  - Includes information about creating content in general, and specifically web content and semantics
  - Tells about 4 core learning styles
  - Shows examples of how a style sheet can quickly change the look of a site
- Class web sites
- Tell Me (polling software used primarily for classes that I teach)
- Master Site (a project that I'm working on)
- Files for Sharing (a way that I offer downloads for large files)
- Academic Team Scoresheet (a non-database, javascript heavy scoresheet that can be used for keeping score in southwest Ohio high academic team matches)

Awards & Honors

President's Club (Circuit City)
15 Videographer Awards
- 2014 Orientation Video - Award of Distinction
- (final year for creating videos - 2014)
- 2013 Miami Chef - Award of Distinction
- 2013 Orientation Video - Award of Distinction
- 2012 New ID Card Videos - Award of Distinction
- 2012 Orientation Video - Award of Excellence
- 2011 Miami Chef - Award of Distinction
- 2011 Orientation Video - Award of Distinction
- 2010 Advertising Campaign - Award of Excellence
- 2010 Orientation Video - Award of Distinction
- 2009 Miami Chef - Award of Distinction
- 2009 Orientation Video - Award of Excellence
- 2008 Advertising Campaign - Award of Distinction
- 2008 Orientation Video - Award of Excellence
- 2007 Advertising Campaign - Award of Excellence
- 2007 Orientation Video - Award of Distinction
- Sample News Release
Miami Pride in Service Award
Conference presenter
Graduate of the Collegiate Management Institute (Central Association of College and University Business Officers)
IT Consultant for CSE311, Software Architecture and Design (for MyCard)

Publications

Book: Drumset Lessons
Content provider for EasyWorship (Video loops and photos)
Music published as "Kirk Hopkins"
Music published with gzuslivz 5 albums licensed, composed, played, recorded, edited, mixed, and mastered
Past webmaster sites
- Personal Miami site
- Harrison Music Booster (past webmaster)
- gzuslivz (old site)
- gzuslivz on Facebook
- MyCard

Other Personal Info

Soccer coach for kids ages 5-10
Soccer referee for kids ages 5-10
Basketball coach for kids ages 5-12
Basketball referee for kids ages 5-10
Musician
Instruments
- Percussion
  - Concert percussion
  - Drumset
  - Hand percussion
  - Mallett percussion
  - Marching percussion
- Guitar (Acoustic & Electric)
- Bass Guitar
- Keyboards (some)
Ensembles
- Marching Band (Drumline)
  - Harrison High School - Cymbals (1 year)
  - Harrison High School - Bass Drum (1 year)
  - Harrison High School - Snare Drum (2 years)
  - Miami University - Tenor Drums (quads) & Auxiliary Percussion (1 year)
  - Miami University - Auxiliary Percussion (1 year)
  - Miami University - Tenor Drums (quints) (2 years)
- Jazz Band
  - Harrison High School - Drumset (1 year)
  - Miami University - Drumset and Auxiliary Percussion (2 years)
- Basketball Pep Band
  - Harrison High School - Drumset & Marching Percussion (4 years)
  - Miami University - Auxiliary Percussion (2 years)
- Percussion Ensemble & Soloist
  - Harrison High School (4 years)
  - Miami University (2 years)
- Pit Band (for a musical)
  - Harrison High School (2 years)
- Praise Team musician
  - First Christian Church which later became Legacy Christian Church (2 years)
- Praise Team Leader
  - Legacy Christian Church (20 years, January 2004 to March 2020 (Covid-19))
- Praise Team musician and periodic worship leader
  - Legacy Christian Church (4 years, March 2020 to the present)
Composer
Personal Instructor (drum, bass guitar, and guitar lessons)
- I first gave lessons while in high school
- I primarily give drumset lessons, but have taught guitar and a little bass guitar