You are here > Case Studies

    Did you know? Hundreds of dollars can be saved with "Fax by Automation"                                                                                       Did you know? Outlook Forms can be used to provide a seamless and paperless "Approval Process"
What our clients say?

Application and Database upgrade - SQL Server 2000 to 2005
  
 
The exceptional services and the quality of deliverables at USAT saved a great deal of cost and efforts in building our software product.
 
CEO, Crane Care Inc. MI
 
Your method of analysis and approaches to problem solving are impressive. We would not be able to develop our customized operations management software without your help. All our employees are very happy with the final outcome. The product we are now using and is saving tremendous amount of  time and cost in running our business. 
 
President
GemStone Real Estate Inc. MI
 
The quality and the stability of the project management system you developed is greatly appreciated by our Project Managers around North America. We recommend USAT to any company without reservation. The continuity of your support is helping our operations. 
 
We want to thank you for your help in entire project life cycle and continued support.
 
Sr. National Ops Manager
Building Technologies division of fortune 500 company.  


 

Client:

Construction division of fortune 500 company

 

Client's Industry:

Construction

 

Services Provided:

Application & Database upgrade from Microsoft SQL Server 2000 to SQL Server 2005

 

CASE STUDY

 

cd

Challenge: Building Technologies division of a fortune 500 company with its four sub-divisions Building Automation, HVAC Products, Fire Safety & Security Products and Security Solutions combines offerings for building security, life safety and building automation within one company as a service and system provider. The client is interested in upgrading it's custom build project management tool to work with Microsoft SQL Server 2005. Upgrading various data import / export mechanics associated with this application is also included in the challenge. 

Solution: As a premium Business IT Solutions provider, USATInc took the challenge and worked with the client in addressing the efforts and hurdles involved. The team of experts at USATInc analyzed the variables in the initiative and brainstormed with the client in deriving the right approach to meet the given task. Project execution is started upon the definition of the scope, schedule, budget and Quality measurements. The systematic approach and Project Management methodologies were put in place during the course of meeting the challenge. 

Result: USATInc was able to deliver the desired result while meeting the scope, time and budget constraints . The project lasted approximately six months from the kick-off meeting to the completion of project deliverables. Because of the improved technology and hardware upgrade done to meet the challenge, the end user will now enjoy the quicker responses while working on the tool and over all improved performance. The data integration is made faster and a greater drop in help calls and system problems is observed. Documentation defining the functionality and steps involved in migrating the solution to production were delivered. USATInc received 100% customer satisfaction and improved over all service reputation with the client.   

Technology: The technologies used by the project team at USATInc include  Microsoft SQL Server 2000 and Microsoft SQL Server 2005. SQL Service Integration Services (SSIS) along with Microsoft .Net framework is used to upgrade the data transformation mechanism of the system. Visual Studio and Microsoft Office 2007 Automation are used in upgrading the user interface and report generation features of the application to work with SQL Server 2005.