January 2007 to March 2007
This was a short-term assignment contract (3 months). I was brought in to move all data access from SQL Server to an external data source via web services from another company providing a service called eTennant. At this time these were SOAP services using VB.Net, SOAP web services, Microsoft SQL Server and Transact-SQL. I was supervising two other developers. I developed standards, re architected the data and business tiers and mentored the other developers.
As they didn’t let me know until the last minute if I would continue, I had a accepted another contract. My mentoring left them in a good state though.
The design that I did not affect the presentation and business logic tiers but only the implementation of the data tier. I changed the data tier to return the same result sets but reimplemented the data tier to query SOAP services for the data instead of the SQL Server. Then I packed up that data into the same data sets that SQL Server was returning.