Responsibilities  Created complex Stored Procedures, and views to transform the Data and worked extensively in T-SQL for various needs of the transformations Designed and developed Complex SSIS packages using SQL SERVER 2012/14/17 Integration Services Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files, and Sybase databases. Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related, Dynamic SQL queries, etc. Deploy developed projects to catalog to multiple servers, create an environmental variable,  Using SQL Server Agent to create jobs and schedule the SSIS packages from the catalog or SP, VW, or any query Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task, Email Task, Execute Package Task, and Data Flow Tasks. Derived Column, Union All, Conditional Split, Row Count, Audit, and Script Component. Identifying long-running queries, scripts, and tuning. Develop to get Long running query more than the threshold time and send notification and email alerts also using pager duty Use pager Duty to send alerts and notify the scheduled support team to work on errors or job failures  Validated and modified the data using different Data Flow Transformations like Send Mail, Web --Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Experience in third-party SSIS Tools like ZappySys, used to email, zip/unzip, Download, Secure Ftp JSON File Sources, etc… Expertise in implementing complex ETL packages to extract data from various sources (SQL Server, Oracle, Excel file, DB2, SharePoint lists, and Flat File) and load into various destinations.  Proficient in creating dynamic packages for Incremental Loads & Data Cleaning in DW using SSIS.Experience in error & event handling: Precedence Constraints, Break Points, Check Points, and Logging.

 Created complex Stored Procedures, and views to transform the Data and worked extensively in T-SQL for various needs of the transformations Created ETL SSIS packages both design and code to process data to target databases. Debugging and troubleshooting technical issues while implementing the applications. Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load. Created packages in SSIS with error handling and worked with different methods of logging into SSIS Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.)  Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse. Responsible for Deploying, Scheduling Jobs, and Maintaining SSIS packages and Updating and maintaining Visual Source Safe. Created complex SQL joins for applications following SQL code standards. Responsible for data analysis, loading data from Data feed to Data Warehouse tables. Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance. Designed different kinds of reports from scratch depending on the requirements of the markets, vendors, providers, and scanners. Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reportsEnvironment: MS SQL Server 2016/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Enterprise Manager, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#, .Net, Visual Studio, MS Access, Crystal Reports, MS Excel.

 Involved in Planning, Defining, and Designing data based on business requirements and provided documentation. Created functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency. Built business logic into Database design and maintained it by using SQL objects like Stored Procedures, User Defined Functions and Views. Enhance existing stored procedures, views, functions, and database objects for additional requirements Of the latest releases Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases. Worked extensively on indexes and query optimization for performance Tuning. Developed SSAS Cubes and export them as pivot tables in Excel for data analysis. Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency/requirement.  Created OLAP models based on Dimensions and Facts for efficient loads of data.  Scheduled the reports to refresh and run on a daily, weekly, and monthly basis in the report manager. Developed MDX Queries in order to perform drill-down reports and for calculating measures and dimensions.  Supported ASP.NET team to build a credit card payment system prototype for a private bank. Developed Logical and physical data models using ER Studio and mapped the data into database objects. Created BI interactive Dashboard with Elkview Experience with creating Worksheets and Dashboard. Created the Test Evaluation and Summary Reports. Experience of Client-Interaction onsite/Offshore.Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), SharePoint 2013, Business Intelligence Development Studio (BIDS), MS Excel.