Victor Hugo Guerrero

Accomplished Business and Administrative Professional with extensive experience in office management and team leadership within higher education. Skilled in conflict resolution, scheduling, and financial reporting, fostering a collaborative atmosphere that enhances organizational effectiveness and supports educational initiatives.

• UTZ Customizations- Commitment Accounting-Initiate/view DBT change request (also process paper request) with HCM Budget department faculty funding. Run Human Resource Job Summary Reports for faculty/student employee analysis for individual/ department compensation rates, position and incumbent workload histories. Process General Ledger Reconciliation Reports for all department budgets, revenues, accounts payable, and expended wages.
• Run Workforce Administration Current Job Reports for faculty and student employees for specific data distribution and funding to positions, FTE, and assignments.
• Purchasing- Requisitions reviews/reports, Purchase Orders review/status and reports.
• Run Procurement Reconciliation Statements and Reports- account summaries, cardholder information and purchase details.
• Accounts Payable- vouchers, reports, pivot tables and payment status.
• Commitment Control- monitor and review departmental budget activities, details, and drill-down ledger overviews. Run budget status reports. Update, semi-monthly department budgets reports to internal ledgers. Run OPE-OPR budget & balance expense reports. Balance ledgers and reconcile accounts monthly.
• Ledgers- Detail Definition Ledger Reports.
• Financial Management Systems Reporting Tools and Queries (FMS)- management of departmental assets, reviews, and reporting. To include but not limited to the Visual Resource Collection and department print facility. Vendor DBA, listings and voucher status reports. Balance department accounts payable- expenditures, travel, HR payroll, employee fringe reports. Generate custom spreadsheets for internal ledger reporting and balance sheet.
• Human Capital Management Tools and Queries (HCM)- generate spreadsheets from-filled/vacant positions-positions with end dates- new hires/positions- permanent position budget funding- dept budget distribution earnings- work study end dates & new hire- FTE queries- VP active employee counts and distribution earnings- GTA expected end dates-Quarterly Reports.
• Monthly Financial Report Reconciliation.
• Managing Departmental Expenses and Revenue Budgets.
• Funding Positions.
• Charts of Accounts.
• Records Retention.
• Credit Card Compliance Guidelines.
• Supervisory Case Study- A Closer Look at Coaching Staff.
• Supervisory Series Training: Leadership Skills for Supervisors, Influence and Situational Leadership for Supervisors, Motivation and Communication for Supervisors, Teams for Supervisors, Strategic Planning for Supervisors.
• Administrative Support Toolbox Series Training: Human Resource Processing, Financial Processing, Communications, Marketing & Creative Services, Supervision, Academic and Student Processing.
• Work Study Supervisor Training.
• Interim Process- Time and Absent Reporting for Exempt Employees.
• Interim Process- Processing PO & Non-PO Order Vouchers.

• The University of Texas San Antonio Excellence Awards Recipient: The Extra Mile Award, 2016.
• Certificate of Achievement: Management Supervisory Series, 2015.
• Harmony Science Academy. The San Antonio 9th Annual Fair Juror- Sociology, 2014.