 Understanding and analyzing project requirements and translating it into reports and packages. Interact with client to gather the project requirements. Involved in developing and maintaining back end by database design and database objects creations. Responsible to perform query optimization using execution plan and optimization techniques. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate… Show more  Understanding and analyzing project requirements and translating it into reports and packages. Interact with client to gather the project requirements. Involved in developing and maintaining back end by database design and database objects creations. Responsible to perform query optimization using execution plan and optimization techniques. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate scripts. Create different types of reports as per client requirements using SSRS. Host reports using Reporting Services Configuration Manager Tool or integrate with dot net application using Report Viewer. Worked with Report Manager to create subscriptions, and edit, delete, and upload reports. Extracting data from multiple sources from multiple servers like SQL Server, Excel after that transforming and validating data and loading data into final destination using SSIS. Create SSIS package and deploy the packages under different environment to Integration Services Catalog using project deployment model. Created event handler for the packages using EventHandler tab for error handling and logging. Involved in scheduling the reports and subscriptions and packages as well. Monitoring the effects of changed code. Show less

 Understanding and analyzing project requirements and translating it into report and packages. Interact with client over phone call to gather the requirements and attending daily meeting with team members. Involved in developing and maintaining back end by database design or database objects creation. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate scripts. Create different types of reports as per… Show more  Understanding and analyzing project requirements and translating it into report and packages. Interact with client over phone call to gather the requirements and attending daily meeting with team members. Involved in developing and maintaining back end by database design or database objects creation. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate scripts. Create different types of reports as per client requirements using SSRS. Integrate created reports with dot net application using Report Viewer in Visual Studio. Extracting data from multiple sources from multiple servers like SQL Server, Excel after that transforming and validating data and loading data into final destination using SSIS. Create SSIS package and deploy the packages under different environment to Integration Services Catalog using project deployment model. Monitoring the effects of changed code. Show less

 Understanding and analyzing project requirements and translating it into SQL scripts. Interact with team lead to gather the requirements. Involved in database design, creating Tables, Procedures, Functions, Views etc. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate scripts. Create different types of reports as per client requirements using SSRS. Integrate created reports with dot net application using… Show more  Understanding and analyzing project requirements and translating it into SQL scripts. Interact with team lead to gather the requirements. Involved in database design, creating Tables, Procedures, Functions, Views etc. Writing complex queries and T-SQL statements as per requirement. Create database backups and generate scripts. Create different types of reports as per client requirements using SSRS. Integrate created reports with dot net application using Report Viewer in Visual Studio. Monitoring the effects of changed code. Show less