• Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using SQL.• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.• Excellent knowledge in creating Databases, Tables, Stored Procedures using Window Functions, DDL/DML Triggers, Views, User defined data types, functions, and Indexes using T-SQL.• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.• Have been creating complex Pipelines using ADF V2, Azure Databricks, source being On Prem Servers or flat files / or Cloud Storages such as ADLS Gen2, Blob storage, involving Stored Procs to control pipelines, creating notebooks and doing data transformations• Done ADF source code version control using Azure DevOps or Git• Done Azure services, destination was Synapse Data Warehouse and made ADF source code version control using Azure DevOps or Git• Assisted in implementing Azure Data Factory v2 for a major financial institution by ingesting their risks and control data into Azure data lake store.• Handling Azure Storage like Blob Storage and File Storage• Developed U-SQL Scripts for schematizing the data in Azure Data Lake Analytics• Ability to create scripts using Azure PowerShell during for automation and build process.

• Gathering, analyzing, and documenting the business requirements and business rules by directly working with end users/clients.• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in scheduling and deploying SSIS Packages.• Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database.• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint• Design, maintain and deliver SSRS reports sourcing from central database.• Created Application Tracking Systems, Surveys and Manual Data Entry Web Apps using ASP.NET Framework.• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS• Provided standard and ad-hoc reports on a regular basis and on demand.• Worked extensively on system analysis, design, development, testing, and implementation of projects.• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.• Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages. • Created SSRS reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.

• Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis. • Created database objects like tables, view, store procedures, functions, triggers using SQL server. • Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse. • Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse. • Optimization of queries by looking at Execution Plan for better tuning of the database. • Generated custom and parameterized reports using SSRS. • Used SQL Server Agent for scheduling jobs and alerts. • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table, and create view for end users. • Worked with Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning. • Performed Database Refresh tasks from production to Development and Staging Servers. • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning. • Provided scripts to DBA for production implementation of data warehouse and several other database objects. • Work with Business analysts to create data dictionary for end-user. • Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008/2012. • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS. • Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.