K-State Information Systems Office

1. K-State Information Systems Office Application Development Services Accomplishments for Calendar Year 2008 Last update: March 10, 2009

2. Systems Enhancements and Operational Support Activities • Used Remedy to identify, track, communicate, and complete service requests in a timely manner • Completed a record number (1,600) service requests in 2008 (a 56% increase over CY2007) • Maintained smooth operations of production systems • Applied vendor fixes and patches in a timely and accurate manner • Continued to cross-train team members to increase team knowledge and depth • Assessed FTE utilization across development teams and made adjustments when needed • Began supporting Environmental Health and Safety's web site and related technical initiatives

3. Project and Portfolio Management Enhancements and Activities • Created and filled the Assistant Director for Projects and Portfolio Management position • Assigned project managers to the largest projects • Completed the evaluation of the Enterprise Project Management system (MS Project 2007) • Developed and distributed an ISO Portfolio of Projects report • Distributed the ISO bi-weekly Project Status Report on a regular basis

4. Projects Completed Student Systems Team • Implemented iSIS per the project plan: • Financial Aid – February 2008 • Student Enrollment – March 2008 • SEVIS functionality – March 2008 • MarketPlace/Student Self-Service – March 2008 • Student Finance – June 2008 • Converted essential historical student data for go live • Completed essential reports and/or data queries • Addressed post-go live issues promptly • Monitored system performance and addressed issues • Began to develop operational and system enhancement strategies and procedures • Closed-out the project; moved ADS staff back to ISO

5. Projects Completed (cont.) Student Systems Team (cont.) • Ran KATS and iSIS student self-service in parallel • Completed the integration of DARS and iSIS • Completed CY07 Annual Tuition Stmt. (TRA97) • Completed BRS and FAMS data conversion to iSIS • Installed the final Financial Aid Federal Reg. changes in FAMS • Sunset selected mainframe systems

6. Projects Completed (cont.) HRIS, Budget, and RETORIC Team • Completed the HRIS upgrade to version 9 • Integrated HRIS into the WID creation and storage process Financials Team • Resolved FIS Oracle 10gR2 database issues • Reconstructed FIS materialized views to enhance performance and maintainability

7. Projects Completed (cont.) Facilities Management & Departmental Systems Team • Replaced SSNs with WIDs in FAMIS Key Control • Replaced SSNs with WIDs in PowerPark • Applied FAMIS FMM 7i patches • Completed the R25/iSIS interface • Supported the transition of SIS (spring/summer) and iSIS (fall 2008) room scheduling processes • Upgraded Computrition to version 17 • Redesigned Environmental Health and Safety’s web site using new K-State templates

8. Reduced Security Risks to ISO Systems • Increased staff awareness of new IT security policies and potential security threats • Eliminated SSNs from systems and interfaces when feasible • Implemented stringent TrendMicro and Windows firewalls on desktop computers • Required Virtual Private Network (VPN) be used for remote access to desktop computers

9. Enhanced Information Systems Resources • Reassigned one FTE to perform business process analysis for selected projects • Continued to invest in training in new technologies • Continued to cross-train staff to increase team knowledge and depth and reduce single points of failure • Consolidated ADS staff on the 2nd floor at the conclusion of the LASER Project and relocated many others to enhance communication and collaboration • Resolved H1b/green card sponsorship roadblocks

10. Contributed to Central IT Initiatives • IT Trouble Ticketing and Reporting • Identity Management • WID Expansion • Transaction Hub Expansion • Migrate to Microsoft Active Directory (RENEW Project) • Central IT Change Management Board