SQL Server (T-SQL, ETL/SSIS) Developer Resume Irving, TX - Hire IT People

SUMMARY

5+ years of Professional experience in Information Technology and over 6 years in database design, development of MS SQL SERVER 2000/2005/2008/2008 R2/2014/2017 with Business Intelligence tools SQL MS Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)
Expert with developing and designing ETL/Datawarehouse solution using Azure Data Factory/SSIS
Worked extensively on T - SQL Code, including creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.
Experience in writing SQL Queries, T-SQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/ 2008 R 2/2008/2005/2000 , 2017 ORACLE 10g/11g

BI Tools: SSIS, SSRS, POWER BI, SSAS, TABLEAU, POWERSHELL

Language: T-SQL, C#

Cloud: Azure (Azure Data Factory/Azure Synapse/Azure Databricks)

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Server (T-SQL, ETL/SSIS) Developer

Responsibilities:

Migrated Informatica ETLs to SSIS packages
Created SSIS packages to integrate data from Salesforce to SQL Server Datawarehouse. And SQL Server to Salesforce
Used SSIS to transform and push on prem SQL server data to Azure SQL

Confidential, Addison, TX

SQL Server (T-SQL, ETL/SSIS) Developer

Responsibilities:

Used PowerShell Script to automate file export/import process to SharePoint and executed using SSIS
Used control flow tasks such as for Loop Container, For-Each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks.

Confidential, Richardson, TX

SQL Server (T-SQL, ETL/SSIS, SSRS) Developer

Responsibilities:

Created user defined functions, views, stored procedures as per business requirements.
Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data.
Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

Confidential, Addison, TX

Application Developer (SQL/T-SQL/SSRS/SSIS)

Responsibilities:

Improved the logging of ETL packages with added OLEDB source logging on failure and also added on failure event.
Added incremental load process for existing ETL packages and
Added SSIS pkgs to existing datawarehouse to load data from Sharepoint, Oracle, Teradata, Dat files to SQL server datawarehouse

Confidential, Richardson, TX

Application Developer (SQL/T-SQL/SSRS/SSIS)

Responsibilities:

Analyzed and worked with databases in SQL Server, Sybase and Oracle to gather metadata on existing objects
Created User Defined Functions, Views, and stored procedures as per business requirements.
Created SSIS custom tasks using C# to implement business logic for data transformation.
Createdlogging,custom logginganderror handling packages.

Confidential, Plano, TX

Application Developer (SQL/T-SQL/SSRS/SSIS, C#)

Responsibilities:

Created User Defined Functions, Views, and stored procedures as per business requirements.
Created SSIS custom tasks using C# to implement business logic for data transformation.
Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data
Created SSIS Packages using Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, and Execute Package Task