SUMMARY:

• 7 + years of progressive experience in IT industry as SQL Server/BI Developer working on SQL Server 2014, SQL Server 2012, SQL Server 2008 R2 and older versions of SQL Server. Involved in Design, Code, and Test high performing & robust SQL Server Databases, Tables, Stored Procedures, Indexes, and Triggers.
• Experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading. Good knowledge in Upgrading and Configuring to Microsoft SQL server 2014/2012/2008 R2 from SQL server 2008 and SQL and SQL server 2005.
• Generated complex Transact SQL (T - SQL) queries, Sub queries and Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).
• Proficient in Performance Tuning/Query optimization & backing up databases & refreshing Data across environments. Huge Data transfers from & to SQL Server Databases using utilities/ tools such as DTS, SSIS, BCP, & Bulk Insert.
• Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers. Involved in usage of various SSIS components such as For-loop, For-eachloop, Variables, and Error Handling.
• Good knowledge of migrating data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS).
• Experienced in developing and deploying Cascading Parameterized, Drilldown, Ad-Hoc reports linking with sub reports in various file formats with respect to client’s requirement. Creating enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2012/2008.
• Experienced in developing SSAS tabular cubes, facts and dimension tables to perform analysis. Good knowledge of Star Schema and Snow Flake Schemas. Knowledge of Enterprise Data Warehousing and requirement documentation for Data Warehouse Design.

TECHNICAL SKILLS:

• SQL Server
• SSIS
• SSRS
• SSAS
• Performance tuning
• Query Optimization
• Server Monitoring
• Profiler
• Extended Events
• Locking, Blocking
• Deadlocks
• DataMart
• Data warehouse
• OLTP
• Replication
• Agile

EXPERIENCE:

Confidential

BI SQL Developer

Responsibilities:

• Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and T-SQL Queries to test and implement business rules. Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Created Non-clustered indexes to improve query performance and query optimization.
• Maintained and managed database/stored procedures using SQL server tools like Performance Tuner and SQL Profiler.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard.
• Extract data from Flat and Excel files and loaded to SQL Server database using Bulk Insert.
• Created SQL Queries to extract and compare data in the different sources.
• Created SSRS Reports from the SQL server tables, for different client’s needs for data analysis. Involved in data Analysis, comparison and validation. Created ETL Packages to validate, extract, transform and load data to data warehouse and data marts.
• Developed SSIS Packages for extracting the data from the file system, transformed and loaded the data into OLAP. Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services. Designed and deliver dynamic reporting solutions using MS SQL Server Reporting Services.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Heavy integration of ASW400 IBD DB2 with SQL Server and StarQuest replication tool.
• Used Report Builder to do Ad-hoc Reporting. Develop various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, and Sub Reports. Used Reporting Services to schedule various reports to be generated on predetermined time.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables. Created Views to enforce security and data customization.
• Debugged applications written in .NET whenever needed.

Confidential

SQL Developer

Responsibilities:

• Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and T-SQL Queries to test and implement business rules. Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Identified data issues & provided recommendations for resolution to ensure optimal performance. Worked on migrating SSIS 2005 packages to 2014 SSIS packages using project deployment module. Developed SSIS Packages for extracting the data from the file system, transformed and loaded the data into OLAP.
• Used power shell scripts to write database admin tasks such as Index Maintenances, to find out file sizes in the disc, alert the users with transaction log files and tempdb growth.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count transformations.
• Built / maintained SQL scripts, indexes, and complex queries for data analysis & extraction.
• Worked on trouble shooting on the server using profiler and extended events & extensive trouble shooting to find out locking/blocking & dead locks on the server.
• Heavily involved in Database Design for new applications using the best industry practice.
• Loaded data warehouse using SSIS Package & generate DataMart’s and send them to clients. Extracted data from Flat & Excel files and loaded to SQL Server database using Bulk Insert. Rewrote legacy SSIS packages using stored procedures/BCP.
• Configured and maintained Report Manager and Report Server for SSRS. Created SSRS reports from (SQL Server Analysis) SSAS Cube. Performance Tuning and optimization of the store procedure. Responsible for the Creation of the Ad-Hoc Reports using SSRS.
• Worked on C# for Confidential application development & involved in the setup and installation of the SQL Server.