A dedicated IT Professional with * plus years of experience in Finance and Insurance Domain. Well versed in using RDBMS, Database Development, Business Intelligence tools such as SSIS, Power BI and SSRS under fast paced environment. Currently working in an Agile Team and looking forward to join an innovative organization.

PROFESSIONAL SUMMARY

Skilled in Relational database design concepts and SQL programming

Strong experience in Business Intelligence and Data warehousing techniques

Experienced in all areas of SQL Server development including T-SQL Queries, Stored Procedures, User-defined Functions, Views, and Triggers.

Strong understanding of logical and physical data modeling

Extract, Transform and Load Data from different sources to Staging areas/ Data warehouse based on business requirements using SSIS tool

Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes using DDL and DML commands

Deep knowledge of different Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling.

Hands on in error handling and debugging coding issues and troubleshooting of production defects, on call support for Business people for production issues

Good knowledge of SDLC principles and Agile Frameworks

Skilled in performing data transfers between different heterogeneous systems (Excel, MS Access, Flat Files, MS SQL & Oracle) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.

Professional in usage of SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).

Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS 2017/2016/2012/2008 R2/2008.

Skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2017/2016/2014/2012/2008 R2/2008.

Good knowledge of DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases.

Working together with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Team Player, always interested to learn new technologies

TECHNICAL SKILLS:

MS SQL Server 2017/2016/2014/2012/2008 R2

T-SQL

MS Visual studio v 2015/2013/2010 for MS SQL Server Integration Service (SSIS)

MS SQL Server Reporting Services (SSRS)

Power BI

Oracle 11g/10g

Relational databases

PROFESSIONAL EXPERIENCE:

ETSS, Columbus, OH December 2019 - Present

ETL Developer

RESPONSIBILITIES:

Designing, implementing and maintaining database objects

Developing, testing, integrating and deploying ETL routines using ETL tools and external programming as necessary

Participated in data modeling meetings to help determine data modeling architecture and helped data modeling team to achieve best practices and performance.

Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.

Worked on SQL Server development including writing T-SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing T-SQL relational database models and data integrity.

Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, creating reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Datasets, calculating subtotals and grand totals for the reports using SSRS 2014.

Created user defined function and views in t-SQL (using PG Admin and SQL manager for t-SQL). Implemented best practices and performance tuning for t-SQL.

Created Drill through, Drill down, Matrix and Sub reports, added report mapping functionality to the reports using MS SQL Reporting Services

Created and Scheduled Date-Driven and Standard Subscriptions with different rendering options like PDF, CSV, EXCEL etc. using data sources from SQL Server, Oracle and HDFS.

Monitored and enhanced performance by using execution plans and SQL Server Profiler, implementing query optimization.

Worked with testing team to understand test cases and created processes (using stored procedures and SSIS packages) to automate ETL and SSRS testing.

Supported Extract, Transfer, Load (ETL) efforts using Integration Services tools. Created, configured, modified and tuned SSIS packages.

Created custom packages to load slowly changing dimension tables (for Type 2 and Type3 loads).

Used configuration manager in SSIS to dynamically move packages between environments, performed error handling for SSIS packages.

Used Tidal scheduling tool to schedule SSIS packages and SSRS reports.

ENVIRONMENT: MS SQL Server, Oracle 11g, T-SQL, SSIS, Data Warehousing, Kimball, Data Mining, Data Analysis, UNIX

GEICO, Washington DC Auguest 2018 to November 2019

ETL Developer

RESPONSIBILITIES:

Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in a given period.

Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.

Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.

Wrote T-SQL queries, created dynamic Stored Procedures by using input values.

Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.

Applied monthly patches and hot fixes.

Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.

Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

ENVIRONMENT: MS SQL server 2008, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2008, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler.

Contact this candidate