Ujjwal Tuladhar

Coppell, TX

PH:469-***-**** Email: adm5uj@r.postjobfree.com work-Status: Citizen

Summary Of expertise:

·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)

·2+ years of experiences with Azure eco-systems (Azure Synapse, Azure Data Factory, Azure Databricks)

·1+ years of experience with Python, Spark, SparkSQL

·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 Skill:

Databases

SQL Server 2014/2012/ 2008 R2/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)

Education: Bachelor in Information Technology

Project Summary:

Mid-America Mortgage, Addison, TX September 2020– Current

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

Responsibilities:

Created Azure Data factory ETL solution to load source data to Azure Data Lake using Parquet format

Created Databricks notebook using PySpark to handle the schema drift and called through ADF

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.

Created database objects like View, Stored Procedures, and Functions. Check in Code into TFS (Source Control)

T-Mobile, Richardson, TX February 2020–June 2020

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.

Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks.

Used control flow tasks such as for Loop Container, For-Each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks.

Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

Bank of America, Addison, TX September 2019 -January 2020

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

American Express, Scottsdale, Arizona May 2019–August 2019

SQL Server Developer/BI Developer

Responsibilities:

Created user defined functions, views, stored procedures as per business requirements.

Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks.

Used control flow tasks such as for Loop Container, For-Each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks.

Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

Bank of America, Richardson, TX March 2018-October 2018

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.

·Created logging, custom logging and error handling packages.

Cottonwood Financials, Irving, TX July 2017 -January 2018

Application Developer (SQL/C#/SSRS/SSIS)

Responsibilities:

·Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill down Reports and charts using SSRS

·Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.

·Developed ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).

·Created Package Configurations to deploy packages from development to production ser

Bank of America, Plano, TX Nov 2016 - April 2017

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

Contact this candidate