|
Orange County Superior Court
<br />Jn early 2pp7, Sierra tvon n cangretitdra corrtrac! to evahinte lire software gualltjr asyrtrance pritcltces of the
<br />Orwrga County Snporlar Coerb Prior to that thee, aN sntftvare testing activities tvfdrfn the Courts JT
<br />nrgartizattar+ were co+rdrretar! by the softwara devednpars. The Court regnested Sierra to raaar++neanrl n fowrrnl
<br />software QA ruatirodology to be petformerd by an inrlependent group wft/rh+ the JT Department. Asa result of that
<br />study anrf raenrnnraurinNon, Sierra was mvattled tlrefbllow-on work io provide QA staff personnel, which Gas led
<br />to ndildttannJrempornry JT persaartel slnfftnr eontraats. to support all branches of the IT Departmeni, h+cluding
<br />thefallo ving.,
<br />Software Quality Assurance -Siena provided a senior analyst since the original contract award plus temporary
<br />staff augmentation as needs and budget have required. Our staff participated throughout the entire Software
<br />Development Life Cycle (SDLC), with primary responsibilities in the areas of testing, quality oversight,
<br />requirements evaluation for testability, test case development and execution, and test results reporting. Larger
<br />specific assignments included the District Attorney's Interface enabling fire DA to electronically file complaint
<br />information and the Interactive Voice Response system to enable customers to conduct fundamental court business
<br />over the phone for activities such as basic fee payment, traffic school requests, and case extension requests.
<br />SQL Server Database Administration - Sierra provided a SQL Server DBA, with Oracle skills also, to assist the
<br />Court in identifying and installing patches and upgrades to the SQL Server database and to support transitions
<br />between Oracle and SQL Server. Other tasks involved heating and implementing appropriate security policies,
<br />database tuning, development of backup and restore policies, creation ortestenvironments, onsuring high
<br />availability of databases, utilizing ETL or web services or DB links for contraction, integration, and merging of
<br />various databases, establishing automatic monitoring and aotillcatlon of database status, providing diagnostics and
<br />debugging guidance for software dovelopment teams, documenting database architecture, usage, and licensing,
<br />charting plaits for future growth, and memoring other members of the DI3 staff.
<br />Power0nilder Case Management System Upgrades - Sierra has provided PowerBuilder developers to enhance
<br />and maintain the Court's Vision court case application, handling traffic and fwlony cases. Functionality covers
<br />Courtroom, Calendar, Person, Records, Exhibits, Fiscal, Warrants, Bail, and Reporting. The effort requires working
<br />with Court users to determine data needs and to formulate and refine enhancement requests, then to implement, test,
<br />and document modifications to application windows, reports, and backend processes, creating and modifying Oracle
<br />database triggers. Additional work efforts have included user training and coaching of less experienced developers
<br />in SQL or PLISQL programming. `i'eehnologics utilized have included Sybase PowerBuilder 11,5, Microsoft Visual
<br />Source Safe, Oracle IOg and I I& TOAD, Microsoft Orifice 2007 (Word, Excel, Outlook, OneNote), Oracles SOL
<br />Developer, SQL Anywhere, PoworDeslgner, SQL Server database. Visual Studio, ;NET framework, ASRNET,
<br />ADO.NET, SharePoint Server and SharePoint Developer,
<br />SharePoint Migration -Sierra converted a ColdFusion application (Judicial Raster) to reside in ShamPoint and
<br />connoet to a SQL Database. Previously there was no user interface and the 11' Department was entering data into the
<br />SQL database tables manually. We created various Web Parts that includedlists and data entry forms for data
<br />entry. The development environment was Visual Studio 3.5 Framework ASP.Net using Visual Basic and
<br />WSPBuilder to create the Web Parts and deploy to SharePoint 2007 within a Feature.
<br />Web Changes - conversion from ColdFusinn. We used out -of -the -box Web Parts and SharePoint Designer to create
<br />workflow. We converted data from SQL Server 2000 database tables into SharePoint Lists and Content Types using
<br />BIDS (Business Intelligence Development Studio) mad SS1S (SQL Integration Services) to Extract Transfer and
<br />Load data. Products used are Microsoft Visual Studio 3.3 Framework, ASP.Net, Visual BasiclCP/JavaScript, SQL
<br />Reporting Services, SQL Integration Services (SSIS), StrarrPart, and K2.
<br />Agreement SC 1716,Temporary Personnel Services - Information Technology Classifrcntions
<br />Period of Performance: 9 October 2009 _. Present, No Variance
<br />Original Value -No value assigned. Billing to Date m $1;9M+ No Variance, Added Taskings
<br />Personnel Assigned, Sr SW Developer Database Administrator SottwareQA Taster
<br />SC20-011
<br />SIERRA 6"4
<br />CYBERNETICS Santa nai nta Ana IT ProressioServices
<br />
|