Item 14 - Agreements for As-Needed Information Technology Services

Home Browse Search

South Coast Air Quality Management District Sierra has performed ore frfleeto separate contractsfor the AQMD. Systems dev ftme►rl and 1T stafgsir personnel have supported the following tasks at the AQMD facility: Time Card System Sierra provided two .Net software developers who redid the Time Card system that the AQMD was using. The Time Card system was developed as a web based system available for AQMD users within the corporate network. The application was designed to: • Store information about employees' biweekly pay period timesheets. • Allow managers to take action on the timesheets submitted by the employees. + Allow a select group of users to perform administrative functionalities. The application was integrated with the current environment at AQMD, to include PeopleSoft and the document management system. The system was developed using a .NET MVC3 technology and was designed to use the existing database with no data model changes. It is as an intranet application with user authentication using Active Directory. Web Applications Our recent work has been mostly on projects that include web developments that can be used for generic applications on other projects. These web applications will be entered into the AQMD library for use by other projects that may need that particular application. Standardizing Web Products Most recently, Sierra has been working on interfacing with Systems and Programming Supervisors, Systems Analysts and Contractors as they construct, modify and repair web applications to produce wireframes, screen mockups and user flows. We have been preparing the new look and feel for web applications in order that the standards across all products have a uniform and consistent look and feel across all CLASS applications. We have been working to develop UI (including HTML prototypes) with desktops, laptops, tablets and mobile devices with different browsers_ CIS Maps - This web application shows the air quality index (AQI) within four different counties in Southern California. This web project was implemented using mapdotnet and Virtual ]earth APIs using C4 for back end coding and SQL Server and INGRES as the databases. Virtual Earth API was used to render the map and the shape files data was rendered on top of this map with the help ofmapdotnet API. Web Display of Air Quality Data — This web application made air quality monitored data accessible to public facilities like schools and colleges via www.agmd.gov, These facilities lookup data and the AQI for their respective regions before organizing events. This web application replaced a static website which displayed information with no dynamic functional ities. Sierra was involved extensively in the Data Access, Business Logic, and Air Details modules. Web Maintenance Support — Sierra worked on maintaining the AQMD website for over two years, doing most of the static content, email alerts, calendar scheduling. Sierra helped redesign the AQMD's current external website using SharePoint Team Services. Sierra was responsible for daily maintenance of external and internal AQMD websites including publishing daily updates to content and web applications Web Application Security Protocols - This project deals with building &. integrating security protocols to all the existing applications and upcoming applications at the AQMD. It has a reporting tool that lists the set of users based on the User permissions, The project uses ASP.net Role Based security, Visual Studio 2010, and Ingres. SCAQMD Contract Number 97084/970841/970842/001481746/07229/072281/072282/9130/12151/15446 Period of Performance; 28 March 1997 — Present, No Variance Original Value = $150,000 Billing to date = $4.5M+, No Variance, Added Taskings Personnel Assigned: Sr. Systems Analysts Technical Specialists System Architect Systems Analysts SharePoint Developer Programmers Web Content Designers System Designer Database Administrator Sr. SW Developers Project Manager Technical Writer SIERRA 6-5 SC20-011 CYBERNETICS Santa Ana IT professional Services