|
Port of Los Angeles (PQLA)
<br />Sierra tuna ana of77traeeonrPutttas to rvlu n aampalllCva hint Irr 20A9 to,provirla On-C'afl krfornratlmr Taclrnafary
<br />Services to I'OLA's Information Technology Divislon. Oita yeen- later, Sierra's cantruat fatting was inc, cased by
<br />67% and, necnrding to the fuarltng ragrrest nppravarf bur ilre fParbor Bofirrl gfDirector•>, fhe funding tncreose rpa.s
<br />necassary because Sierra has been the mast responsive afthe three contractors In responding to airdfirlfrh/ng
<br />courraetTnskOrtlers. ?nSksBfr}+pane[Ilrava7nclrnierithefulCurphrg:
<br />Help Dealt and Computer Operator Support -Sierra has provided 1" level computer desktop support to general users
<br />throughout PQLA. Personnel answer calls at the IT Help Dcsk, diagnose and repair user problems, and configure,
<br />deploy, and install PCs, printers, platters, scanners, and related hardware and software.
<br />Sierra's Computer Operator provided PQLA support managing customer service requests and escalating them to higher
<br />levels when appropriate. She provided basic troubleshooting for Microsoft Exchange, Office and Windows servers,
<br />She resolved username and password problems, She verified proper hardwarearid software set up and provided work
<br />notes in systems to ensure continuity for service desk support.
<br />Financial Systems Support- Sierra provides IBM COBOL software support to maintain and document a number or
<br />legacy financial applications from Infor Global Systems, including report development using Information Expert (IE).
<br />Capital Improvement Program (CIP) Applications Migration - C1P is a c➢ient-server application written In
<br />PowerBulider previously using Sybase an a Sclaris server, but now utilizing MS SQL Enterprise 2005• Siena migrated.
<br />the doiabuse and the PowerBuilder code from Version 8 to Version 11, including about 200 windows and menus.
<br />IT Administrative Support - Sierra augments the 11' Division's administrative staff will) responsibilities focused on
<br />coordinating ITO administrative functions with those across all PQLA Divisions, In addition to clerical tasks, efforts
<br />include contacting vendors to obtain equipment quotes and delivery schedules for hardware and software and
<br />coordinating equipment deployment with the IT staff.
<br />MS Access Database Sopport-Sierra supported POLA's Engineering Division and Construction Division to provide
<br />technical web application development, documentation, and training, particularly for the Project Information Control
<br />System (PIGS). Applications required proficiency in MS Access, SQL, Visual Basic, MS Project, and Xcelsius.
<br />(Carlos Gonzalez,)
<br />HEAT Upgrade-- HEAT is a commercial help desk issue management software, suite. Sierra led the upgrade from
<br />MEAT V8A.5 to HEAT 9.0, including the following modules: Call Logging, Manager's Console, Answer Wizard,
<br />Automatic Ticket Gonarator, and Web User Interface. Work also included migrating ilia Access database to SQL and
<br />training users and administrators in the upgradcs.
<br />Budget Systern Upgrade - Sierra led the upgrade fiornn the Infor Global Systems Performance Management Business
<br />Process Applications (BPA) V7,4.2 to 10.1.3. The migration was to a 3-tier configuration using Windows Server 2008,
<br />SQL Server 2009, and an Applications Server, all operating in a VM environment. BPA 17b ancial Reporting was part
<br />of the upgrade configuration, using Crystal Reports to create each downloaded view. Budget books were upgraded
<br />from purely it manual process to electronic in PDF. The process also stroanAned the export of financial data from BPA
<br />to the mainframe financial system for annual reporting,
<br />Budget System Forecasting -- With fhe help of a subcontracting firm, Siena led the forecasting tusk order to build and
<br />implement (lie forecasting requirements for PQLA by augmenting the existing Business Process Applications (BPA)
<br />database. It included a CFO assessment, a database development, data entry templates, rertin las forthe revenue
<br />forecasting model, reports, Excel services, testing, knowledge transfer and development support.
<br />Applications Maintenance- Siena provided a back -fill Programmer Analyst to support POLA's need for a multi-
<br />talented software developer to maintain a variety of applications using MS Visual Studio CO :Net, SQL Server 2005 and
<br />above, PowerBuilder 2005 and above, COBOL, CICS, and the Ideal database under the IBM Mainframe VSI, platform.
<br />SIERRA 6-6 SC20-011
<br />Santa Ana IT Professional Services.
<br />CYBERNFricS
<br />
|