This is not a website project but rather a database development project. We are interested in obtaining assistance with a highly experienced programmer and report designer who is fully versed in the use of Microsoft SQL Report Server 2005. We are interested in fully taking advantage of the PDF generation and delivery capabilities of Microsoft SQL Report Server. We require the creation of a Trigger/Stored Procedure that checks one or many related tables to assess when a Case is Final, Addendum Final or Revised Final within our Microsoft SQL Server database. At any time that a Case reaches this Case Status level, the Stored Procedure will then execute the creation of a Report in Microsoft SQL Report Server for that Case which is then converted to PDF and transmitted to a Windows File Share on our network. We are using Microsoft SQL Server 2005 and would require that the selected candidate be fully versed in Microsoft SQL Server 2005 and Microsoft SQL Report Server 2005. The selected candidate should be fully versed in T-SQL, SQL, Microsoft Visual Basic for Appliations, Microsoft Visual Basic and possibly the Microsoft .NET Framework. There may also be the need for experience in the use of ActiveX Controls as the report involves not only a certain amount of layout skills but also an image from each Case. Microsoft SQL Report Server includes this functionality but it appears that image formatting/layout may be a somewhat weaker aspect of this product. We require that the selected candidate be fully versed in the use of Microsoft SQL Server Management Studio or Microsoft SQL Server Business Intelligence Development Studio in the creation of not only any and all Stored Procedures but also the design and implementation of the Report using Report Designer as well as the creation of the code that is used to create, convert and distribute the report within Microsoft SQL Report Server to PDF. The selected candidate will have significant previous experience in the design and implementation of a project that utilizes these exact Microsoft technologies. When applying for this project, please communicate your experience level with these technologies. We will require that all candidates supply at least three references from previous database development projects of this nature or scope. The deadline to complete this project is September 15th. You should only apply for this project if you would be able to meet this deadline. You should only apply if you will be available to work online via remote access during regular business hours (Pacific Standard Time). When applying, please provide your hourly rate to work on this project as well as the proposed number of hours that it would entail to complete this project. At the completion of this project, the steps that are used to realize the objective of distributing a PDF file in this manner should be fully documented. All development work that you perform should be open-source meaning that the methodology which you have developed can be easily viewed, modified and configured by anyone. There should be no compiled programming. If there is compiled programming, the source code should be made freely available to us without additional charge of any kind. Please also note that the selected candidate will most likely be working with us on additional projects in the future.