PROFESSIONAL SUMMARY:

• 8+ years of Experience in IT industry
• Experience in Database design and development using MS SQL Server

TECHNICAL SKILLS:

Operating System: Windows NT/98/2000/XP/2003 server

Languages: T - SQL, IBM Netezza Structured Query Language (SQL), Visual Studio 2010/2012/2013/2015

Tools: SQL Server Management Studio, IBM Netezza,Enterprise Manager SSIS, SSRS.

DATABASE: MS Access, MS SQL Server 2008R 2/2012/2012/2016 , IBM Netezza

Software: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000, Toad Data Modeller

Reporting Services: Excel, SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

SQL Server Database Engineer

Confidential

Responsibilities:

• Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T - SQL, IBM Netezza.
• Experience in MS SQL Server 2017/2016/2014/2008/2005 suite of products like SSIS and SSRS.
• Hands on experience with Database development in OLTP and OLAP.
• Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T-SQL.
• Creating Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Traced long running queries , Time out issues and deadlocks using SQL Profiler .

Confidential

Responsibilities:

• Creating SSIS Packages. Control flow items and data flow tasks.
• Using property expressions, variables and script tasks to customize data processing.
• Creating package configuration files.
• Importing and exporting packages to SQL Server and file system.
• Moving packages and configuration files across different environments.
• Creating audits/logging for SSIS packages on task level and package level.
• Configuring error handling, notifications, restart ability and checkpoints.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column, look up, merge etc.
• Improved slow running jobs with the help of redesign and better ETL processes to meet business needs

Confidential

Responsibilities:

• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Strong knowledge in Performance point server/Excel reporting.