Robert Smith Email & Phone Number

United States

Merced, California, United States

• Provided staff with an interface for submitting Zoho Desk tickets via API by developing a Python (Flask)server on IIS (Internet Information Services), incorporating data validation and real-time feedback.• Implemented a database with Microsoft Access to more effectively manage travel requests. Reduced the frequency of lost or mismanaged requests and streamlined request processing time, resulting in substantial reductions of several days.* Implemented version management via network file storage.• Maintained database integrity and supported critical departmental functions based on existing SQL Server systems by constructing comprehensive datasets and designing up to 10 ad-hoc reports quarterly.• Integrated Power Automate and Power BI for consistent data availability and visibility, enhancing administrative awareness and cutting worker hours by up to 50%.

Merced, California, United States

• Designed a full-stack web app (React, Bootstrap, Sass, Firebase) to track student data, tutoring session evaluations, assessments, and mastery of California Common Core standards.* Provides essential functionality for the tutoring center’s daily operations.• Managed app updates and maintained separate client environments by developing a CI/CD pipeline with GitHub Actions and Firebase Hosting.• Enforced role-based access control by deploying custom Firebase security rules to ensure data privacy and appropriate access levels for administrators, tutors, and parents.

Merced, California, United States

• Assisted professors, TAs, and students in the use of classroom A/V technology with rapid troubleshooting in order to get classroom instruction, meetings, etc. on track.• Responsible for deploying, retrieving, and testing hardware like microphones and adapters for use inclassrooms and learning spaces on a regular basis.• Maintained communication with members of staff and other IT sub-departments in order to escalate,schedule, and delegate work and tasks in order to keep the campus running with optimized efficiency and effectiveness.

Merced, California, United States

• Conducted several tutoring sessions weekly, taught and fortified important skills through a combination of helping students with assigned homework and crafting practice routines based on students’ skill, comfort, and academic needs.• Assisted students in several circumstances including combinations of remotely over Zoom, in person,1-on-1, and group sessions.• Tutored over 50 different students in several disciplines of math leading up to and including college-level calculus, improving some students’ grades by more than 10%.