Custom Solutions

Work Profile
	Listed below is a sampling of solutions Sara Rea has recently been involved with. Please go to Contact if you would like more information about any of the solutions listed here.

		2006 - Redesigned and Implemented Company Portal In early 2006, as a consultant, Sara redesigned and implemented a portal web site to be used by the external partners of Ginger Mae Financial Services (GMFS). The portal utilized open source from the Rainbow community and was an ASP.NET application built with C#. Custom modules included a user management module that fed data to several back-end SQL Server databases on the GMFS servers.

		2005 - Created entire company website In late 2005, as a consultant, Sara designed and implemented a web site presence for Health Data Services, LLC. Even though the web site was created with ASP pages, Sara had to do extensive work with Adobe Photoshop to produce the custom graphics used by the web site. Also, by using ASP, a dynamic database-driven web site was developed very quickly and in a manner that is easy to update for the small company.

		2005 - XML Web Services In late 2004 and early 2005, Sara designed a set of web services that were intended to feed current legislative information to public web sites disconnected from a database. The project involved identifying what functionality and data was needed for the public interface along with designing the web pages that would consume the web services.

		2004 - Legisuite.NET In 2004, Sara was part of a team that redesigned the flagship product for Public Systems Associates (PSA) using Microsoft's Visual Studio .NET 2003 and ASP.NET. The new solution was a multi-tiered design based on the popular DotNetNuke design. The complex application utilized the Data Access and Exception Management Application Blocks available from MSDN. The solution also utilized Active Reports.NET and Oracle 10.
		2004 - Verity HealthNet As an independent contractor, Sara Rea was soley responsible for the design, development, and deployment of an online fee calculator for Verity HealthNet . The web based solution was written with ASP.NET and allows Verity HealthNet subscribers to calculate the allowable amounts for network provider claims. The application accesses data stored in a Microsoft Access database.
		2004 - Public Records As an employee of PSA, Sara Rea recently rewrote an existing ASP application to now use ASP.NET. The web based solution is used by subscribing members of the East Baton Rouge Parish Board of Realtors to easily access a series of public records through an online search. The solution not only consists of the ASP.NET application, but also other backend services and DTS packages that are used to move the data to a SQL Server 2000 database.
		2003 - Legisuite As an employee of PSA, Sara Rea was responsible for the development of several key components of their flagship web based product, Legisuite. The web solution was utilized by various State Legislatures to manage their Legislative Sessions. This included a full scale reporting solution that allowed users to create their own reports with a wizard based interface. Utilized Visual Studio 6.0, Visual Basic 6.0 Active Reports 2.0, Oracle 8 and 9i
		2003 - CourthouseSales.com As an independent contractor, Sara Rea is routinely called upong to make updates to the CourthouseSales.com website This web based solution uses Microsoft Commerce Server to access a SQL Server 2000 database. The site allows subscribers to easily access information from the public Courthouse.