Statement of Work/Project Goals:
The Lands & Buildings Division (LBD) is within the Department of Social and Human Services. The DSHS is responsible for the new construction, maintenance and upkeep of facilities used by the, Department of Corrections, and other agencies in Washington State. Managing capital projects is their primary responsibility and activity.
The LBD needed a new software solution for evaluating structures and components within buildings and building sites. The existing software was troubled by numerous bugs, limited to only 5 concurrent users, and required several manual processes to synchronize disconnected data. They realized they needed to spend less time an effort with their software and get the same or better results.
The LBD contacted CodeSmart to provide a fresh perspective to these problems. They need up-to-date technology that worked well in a web-based environment.
We started by evaluating LBD’s business processes for multiple user roles, assessing security concerns and interviewed stakeholders. Our goal was to build an effective solution from scratch despite the existence of the current software.
We created documentation of all their requirements, use-cases, and data model elements. We also developed multiple aggregate reports in SQL Reporting Services. In addition we created an intuitive user interface with for a scalable and secure web-based application. This new application was also designed to be able to be adopted by other agencies in the future.
Once we captured all the relevant requirements, we produced a comprehensive document of the requirements and known use-cases. This documentation provided screen-design specifications, a comprehensive testing plan, and a detailed data-model with a data-dictionary. We migrating the existing data from the legacy system to the new system.
We also developed a plan for to verify the accuracy of the data to ensure that data had been successfully migrated. We utilized the screen specifications to develop the user interface so it would be intuitive for the customers. We enforced the security authorization by using custom code that leveraged windows active directory for the authentication.
CodeSmart also standardized the web platform by leveraging Silverlight 2.0 and its corresponding toolkits. This allowed the team to utilize the power of the client- side processing and data storage for the users’ activities. CodeSmart also used Windows SharePoint Services 3.0 for file management and document versioning.
CodeSmart delivered a system that contained all of LBD’s legacy data with dozens of new features for improving the reliability and integrity of the inspections to be completed out in the field. This positioned the LBD to deliver more efficient and dependable projections on capital projects to the State Legislature for consideration.
Main Technical Skills Used:
- C#, SQL Server 2008
- Windows Server 2008
- IIS 7.0
- Silverlight 2.0
- WCF Services
- Windows Active Directory
- Windows SharePoint Services 3.0