Pros
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2014(BIDS) and Crystal Reports.
• Provided all configuration details, including the product version, product level, engine edition, database file sizes, and CPU and memory resource, of all the SQL Server 2005/2008 accounted for migration
Cons
• Installation and Maintenance of SQL Server 2008 R2/2005 on Test, Development and Production Environments
• Optimized query performance by creating indexes.
• Used query execution plan to optimize the store procedures to reduce the cost.