Experience on Creating User Defined Functions, Stored Procedures, and Triggers. Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs. Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes. Using reporting services (SSRS) generated various reports Developed, deployed, and monitored SSIS Packages. Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server. Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services. Experience in MS SQL Server 2000/2005/2008, Business Intelligence in MS SQL Server Integration Services(SSIS), Microsoft Power BI, and MS SQL Server Reporting Services(SSRS). Proficient in using T-SQL for developing complex Stored Procedures, Tables, User Defined Functions, Data Cleansing, RDMS Modelling and Query Optimization and Performance Tuning. Experience in creating ETL Packages using SSIS and Scheduling of SSIS Packages through Windows as well as SQL agent job scheduler. Qualifications & Experience: Strong experience working in Microsoft SQL Server and the Microsoft Business Intelligence Stack (SSRS, SSAS and SSIS) Equal competence in Sql Server Integration Services and Sql Server Reporting Services. Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services. Hands on experience in Creating of Triggers, Stored Procedures, User Defined Functions in T-Sql and developing queries in SQL Server Management Studio using T-Sql. Experience in Developing a query for fetching the required data from Oracle database. Experience in Creating a SSIS package import data into a table in SQL SERVER using SSIS Experience in Developing sql queries to create new table, insert data from main table to backup table and deleting the data of main table post completion of successful transfer. Experience in Developing queries using T-SQL for extracting recharge data and storing the data day wise in another table in SQL SERVER using SSIS. Experience in Creating a matrix report using SSRS Required Experience: 2years to 4 years Skills: performance tuning,modelling,query optimization,data reconciliation,data cleansing,schema objects,etl
