Facilities Space Inventory Manager - Amelia Whatley

Facilities Space Inventory Manager

Purpose

Purpose:

Responsible for the university facilities space inventory system using Computer Aided Facilities Management System (CAFM). Disseminate data and information to internal departments and external agencies.

Essential Functions

Function 1:

Maintain facilities inventory on CAFM System; review and process departmental space surveys; input data for new buildings, and modify existing data for renovations; modify data due to reclassification of room use not related to renovation or construction.

40% Time

Function 2:

Develop online training materials and provide training sessions for survey respondents. Coordinate annual Survey participation and provide technical support.

10% Time

Function 3:

Develop and publish reports utilizing SQL-based reporting systems. Involves managing, coordinating, and collaborating with university IT teams to implement database processes.

10% Time

Function 4:

Space Inventory Maintenance - Update space inventory based on modified autocad plans and/or department re-locations. Review and correct all error-catching reports prior to PeopleSoft s weekly import routine. Manually update PeopleSoft when autocad floor plans are unavailable but data is required by the Registrars Office for room scheduling

10% Time

Function 5:

Project Coordination-Verify changes to space utilization variables with the Registrars Office before updating space inventory. Coordinate with IRP to ensure PeopleSoft coding accurately reflects evolving THECB data requirements. Provide technical support for annual survey respondents and system end users. Provide THECB coding assistance to survey respondents and system end users. Provide THECB coding assistance to survey respondents

10% Time

Function 6:

Database Implementation-Manage and maintain both test and production environments. Configure intra-system processes (triggers and notifications). Coordinate modifications to bridge interface incompatibilities. Configure FMS-to PeopleSoft weekly import routines. Coordinate system upgrades with OIT.

10% Time

Function 7:

System Administration-Maintain and update both CASIM and Facilities Managements SIM website using HTML and PHP forms. Configure online survey enhancements and floor plans crosshatching for web-based queries. Confirm database integrity weekly and perform daily data backups. Define and manage user groups, data access, and web page permissions. Monitor database entries for accuracy and verify results. Create and format database queries and reports using SQL and VB language.

5% Time

Function 8:

Develop and document both SIM (Space Inventory Management) and DBMS (Database Management System) procedures

5% Time

Marginal/Incidental Functions

Marginal/Incidental Functions:

Other related functions as assigned.

Qualifications

Required Qualifications:

Bachelors degree in Business Administration, Public Administration, Computer Science, Engineering Management, Building Construction or related field. Two years experience in facilities planning or facilities project management and working knowledge of CAFM systems. Two years experience in SQL-based reporting systems.

Preferred Qualifications:

Five years experience in facilities planning and advanced knowledge of CAFM systems to include proficiency in Excel, Microsoft Reporting Services, Access, AutoCad, plus VB, SQL and HTML coding. Thorough knowledge of THECB reporting requirements.