The objective of this project is to import actual hours submitted by resources to a legacy system. This was achieved by using a combination of SQL queries and HTTP calls to the Project Server Interface performed by a C# script.

In this project one of the objectives was to have MS Project automatically create projects that had been manually created in a legacy system, and exported via a flat text file. The projects were created via a Visual Basic script with SOAP calls to the Project Data Service API.
Once the projects were created on the server custom field data from recently edited projects needed to be exported, again to a flat text file. This was accomplished with Visual Basic, and SQL queries.

This project required installation of Internet Information Services (IIS), Microsoft SQL Server 2005, Microsoft Office SharePoint Services, Microsoft Office Project Server 2007. I also performed configuration and training on the newly deployed environment.

The objective of this project was to create a software solution to the problem of manually adding users to Windows SharePoint Services sites, specifically Project Webspaces. This was accomplished by a combination of SQL queries, and http calls to the Windows Sharepoint Services API.