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
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
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
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.
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
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)
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
