• Strong experience of SSRS, SSIS, SQL and T-SQL.• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.• Experience in using SQL Server Integration Services (SSIS) for performing ETL by extracting data from different sources, applying various transformations, and loading into data warehouse.• Worked with various control flow tasks and containers (Data Flow Task, for loop, for each loop, Execute SQL task, Sequence Container, File System Task etc.) and transformations (Derived Column, Aggregate, Multicast, Sort, Lookup, Merge joins, Conditional Split etc.) and script tasks using C# or VB.• Implemented logging, event handling as and when required in various projects.• Worked with SQL Server Agent to schedule SSIS Packages and T-SQL Scripts.• Identifying long running queries, packages etc..., implementing appropriate tuning methods.• Created various types of simple, complex, parameterized, Dashboard reports using SSRS. • Worked with drill down and drill through, Dashboard Reports.• Experience with SSRS Report Server, Report Manager and SSRS deployment Process.• Experience in writing SQL and T-SQL Code such as Procedures, Functions, Triggers and tuning etc.• Capable to quickly learn new technology and adapt to a new environment.• Experience in DBA activities such as backup, restore, logins, user’s creation, and maintenance activities such as rebuilding or reorganizing indexes.

• Responsible to gather requirement, understand the expectation from product owner.• Worked with project managers, developers, quality assurance team and costumer to resolve any technical issues.• Worked on SSRS reports and created CTEs, views, functions, stored procedures required for reports.• Performance tuning on many SSRS reports and re-write the code to take exciting improvement.• Worked on SSIS package through script task load data into SQL Server from GraphQL API.• Worked on SSIS package have executed Gnupg script (to encrypt file), WINSCP script (upload file to client specific path) and Command prompt script (to run batch code) through Execute Process Task.• Created tableau dashboards as expected stakeholders with appealing and informative data visualizations in 2022.1.4.• Created tableau subscriptions for requested stakeholders, alerts based on the given axis conditions.• Created tableau dashboards in tabular so stakeholders can export the underline data in CSV format for further business use.• Developed Tableau workbooks from multiple data sources using Data Blending.• Restricted data for individual users using Row level security and User filters.• Created SSIS package and configured the MongoDB drive to get data from MongoDB collections into SQL Server.• Validate MongoDB data between Robo 3T and within SQL Server for accuracy of data.• Worked on create databases, tables, functions, and stored procedures in snowflake cloud platform from SQL Server on -premises as part of migration.• Querying snowflake using SQL.• Having strong technical thinking and provide initiative thoughts for concrete solution on re-occurring technical issues.