David Small

Experience

• 

  University of Texas at San Antonio

  May 2000 - Dec 2000

  Administrative Secretary

  • Accessed Historically Underutilized Businesses in ordering supplies• Created purchase orders online and via paper• Reconciled account statements from purchase orders and statements from higher administration• Assembled and networked computers for divisional staff• Responsible for troubleshooting software and hardware• Provided technical training for divisional staff for current and new technologies

• 

  Abilene Christian University

  Jan 2001 - Dec 2002

  Professor’s Instructional Assistant and Computer Lab Instructor

  • Computer Lab Instructor• Instructed freshman Business Majors in Microsoft Office: Word, Excel and PowerPoint• Guided mock small business projects for Introduction to Business courses• Designed and developed syllabi, assignments, projects, and instructional presentations to accompany professor’s lectures• Analyzed assignments, projects, presentations and tests for Introduction to Management and Human Resources professor• Provided career/educational consultation to students

• 

  Independent School Districts (multiple)

  Aug 2003 - Jan 2014

  State-Certified Classroom Teacher

  • Provided various levels of group and individualized instruction and assessment• Responsible for assessing each student’s instructional and content areas of improvement• Provided and implemented individualized growth and development action plans• Articulated student and parent advisory meetings to determine future educational plans• Pioneered new instructional software and instructional technology tools for classroom and laboratory settings• Assembled and networked computers for faculty, staff and campus administration• Responsible for troubleshooting software, hardware and technology tools• Provided technical training for faculty, staff and campus administration for current and new technologies Show less

• 

  Rev. Mary Frederick - Grace for All

  Feb 2014 - Jul 2015

  Information Technology Specialist (Part-Time)

  • Create presentation materials using computer and audio-visual equipment• Maintain online organizational forum• Conduct online research• Troubleshoot computer and audio-visual equipment

• 

  Tarrant County College

  Jan 2015 - Dec 2024

  I utilize my knowledge of Oracle PL/SQL, MySQL, T-SQL, and Microsoft Access SQL to design and execute individual SQL statements, SQL scripts, and create triggers and procedures to automatically insert and update data into the database tables for the Computerized Maintenance Management System (CMMS) and the Fuel Management System (FMS) which are housed on two separate servers. I analyze more efficient ways to enhance communication between the maintenance database and the fuel database. I configure automatically-generated preventative maintenance (PM) work orders (WOs), including new data collection and insertion, assigning crews, creating PM WO tasks and checklists, and assigning PM task frequencies and starting dates. I extract data from the SQL server database tables, and I use MS SQL Server Management Studio, Microsoft Office, Visual Studio, Microsoft Access, and Crystal Reports to create reports tailored specifically for each of the levels of management and administration using the extracted data. I train and support Facilities Technicians with iOS mobile devices to use the mobile maintenance management interface. I train and support managers, supervisors, and support staff to use web maintenance management interface on Windows 7 and Windows 10 PCs. Lastly, I troubleshoot any issues with the mobile user interface, the web user interface, the SQL Server database tables, the interaction or connectivity issues between interfaces and the SQL Server database tables, and troubleshoot any current communication issues between the two databases. Show less I utilize my knowledge of Oracle PL/SQL, MySQL, T-SQL, and Microsoft Access SQL to design and execute individual SQL statements, SQL scripts, and create triggers and procedures to automatically insert and update data into the database tables for the Computerized Maintenance Management System (CMMS) and the Fuel Management System (FMS) which are housed on two separate servers. I analyze more efficient ways to enhance communication between the maintenance database and the fuel database. I configure automatically-generated preventative maintenance (PM) work orders (WOs), including new data collection and insertion, assigning crews, creating PM WO tasks and checklists, and assigning PM task frequencies and starting dates. I extract data from the SQL server database tables, and I use MS SQL Server Management Studio, Microsoft Office, Visual Studio, Microsoft Access, and Crystal Reports to create reports tailored specifically for each of the levels of management and administration using the extracted data. I train and support Facilities Technicians with iOS mobile devices to use the mobile maintenance management interface. I train and support managers, supervisors, and support staff to use web maintenance management interface on Windows 7 and Windows 10 PCs. Lastly, I troubleshoot any issues with the mobile user interface, the web user interface, the SQL Server database tables, the interaction or connectivity issues between interfaces and the SQL Server database tables, and troubleshoot any current communication issues between the two databases. Show less

  • Manager of Computerized Maintenance Management System

    Jun 2023 - Dec 2024

  • CMMS Database Analyst

    Sept 2015 - Jun 2023

  • Senior Office Assistant

    Jul 2015 - Sept 2015

  • Administrative Office Assistant (Part-Time)

    Jan 2015 - Jul 2015