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