Item 14 - Agreements for As-Needed Information Technology Services

Home Browse Search

Port of Los Angeles (POLA) Sierra was one of three companies to win a competitive bid in 2009 to provide On -Call In%r►nation Technology Services to POLA's Information Technology Division. One year later, Sierra's contract funding was increased by 67% and, according to the funding request approved by the Harbor Board of Directors, the funding increase ivas necessary because Sierra has been the most responsive of the three contractors In responding to and fulfrlli►rg contract Task Orders Tasks supported have included the following: Help Desk and Computer Operator Support— Sierra has provided I' level computer desktop support to general users throughout POLA. Personnel answer calls at the IT Help Desk, diagnose and repair user problems, and configure, deploy, and install PCs, printers, plotters, scanners, and related hardware and software. Sierra's Computer Operator provided POLA support managing customer service requests and escalating them to higher levels when appropriate. She provided basic troubleshooting for Microsoft Exchange, Office and Windows servers. She resolved username and password problems. She verified proper hardware and software set up and provided work notes in systems to ensure continuity for service desk support. Financial Systems Support — Sierra provides IBM COBOL software support to maintain and document a number of legacy financial applications from Infor Global Systems, including report development using Information Expert (IE). Capital Improvement Program (C1P) Applications Migration — CIP is a client -server application written in PowerBuilder previously using Sybase on a Solaris server, but now utilizing MS SQL Enterprise 2005. Sierra migrated the database and the PowerBuilder code from Version 8 to Version 11, including about 200 windows and menus. IT Administrative Support— Sierra augments the IT Division's administrative staff with responsibilities focused on coordinating ITD administrative functions with those across all POLA Divisions. In addition to clerical tasks, efforts include contacting vendors to obtain equipment quotes and delivery schedules for hardware and software and coordinating equipment deployment with the IT staff. NIS Access Database Support— Sierra supported POLA's Engineering Division and Construction Division to provide technical web application development, documentation, and training, particularly for the Project Information Control System (PICS). Applications required proficiency in MS Access, SQL, Visual Basic, MS Project, and Xcelsius. (Carlos Gonzalez) HEAT Upgrade — HEAT is a commercial help desk issue management software suite. Sierra led the upgrade from HEAT V8.4.5 to HEAT 9.0, including the following modules: Call Logging, Manager's Console, Answer Wizard, Automatic Ticket Generator, and Web User Interface. Work also included migrating the Access database to SQL and training users and administrators in the upgrades. Budget System Upgrade -- Sierra led the upgrade from the Infor Global Systems Performance Management Business Process Applications (SPA) V7.4.2 to 10.1.3. The migration was to a 3-tier configuration using Windows Server 2008, SQL Server 2009, and an Applications Server, all operating in a VM environment. SPA Financial Deporting was part of the upgrade configuration, using Crystal Reports to create each downloaded view_ Budget books were upgraded from purely a manual process to electronic in PD . The process also streamlined the export of financial data from BPA to the mainframe financial system for annual reporting, Budget Systems Forecasting — With the help of a subcontracting firm, Sierra led the forecasting task order to build and implement the forecasting requirements for POLA by augmenting the existing Business Process Applications (BPA) database. It included a CFO assessment, a database development, data entry templates, formulas for the revenue forecasting model, reports, Excel services, testing, knowledge transfer and development support. Applications Maintenance — Sierra provided a back -fill Programmer Analyst to support POLA's need for a multi- talented software developer to maintain a variety of applications using MS Visual Studio C# .Net, SQL Server 2005 and above, PowerBuilder 2005 and above, COBOL, CICS, and the Ideal database under the IBM Mainframe VSE platform. SIERRA CYBERNETICS -6 SC20-011 Santa Ana IT Professional Services CYBERNETICS