Creation of SSRS reports using BIDS 2008
Adhering to standards of development, testing, and deployment of Report.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Developed various operational Drill-through and Drill-down reports using SSRS
Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
Error handling in Production Environment through log file saved in Text form.
Analyzing the Customer Issue in Production for SSIS Packages.
Monitoring and Maintaining the SQL Jobs Running on Various Server.
Design, develop, and implement SQL database instances for the development and production environments
Monitor, maintain database systems and troubleshoot problems that may arise
Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.