Summary:

• Over 5 Plus Years of IT Experience in Database Design and Development of SQL Server 2000/2005/2008
• Experience in Installation and Configuration of MS SQL Server 2000/2005/2008 Versions.
• Experience in Working with Windows Server 2003, Windows 2000 Advance Server and Windows NT Server Installation and Administration.

T-SQL

• Expertise in Scripting T-SQL Queries, Complex Stored Procedures, Used Defined Functions (UDF), Database Triggers.
• Experience in Implementing different types of Replication Models like Snapshot, Merge and Transactional
• Involved in Optimizing Code and Improve Efficiency of Databases including re-Indexing, Updating Statistics, Recompiling Stored Procedures and performing other Maintenance Tasks.
• Experience in taking Back-ups of Databases and Restoring the Databases.

SSRS

• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.

SSIS

• Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services (SSIS).
• Good Understanding in Database and Data Warehousing Concepts.
• Extensive Experience in Data Migration, Data Conversion, Data Extraction/Transformation /Loading(ETL) using DTS.
• Great Expertise in Creating and Managing Event Handlers, Package Configurations, Logging, System and Used-defined Variables for SSIS Packages.

Technical Skills:
C,T-SQL,MS Access, MS SQL Server 2000/2005/2008,SQL Server Management Studio (SSMS),Business Intelligence Development Studio(BIDS)/Microsoft Visual Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor ,SQL Server Integration Services(SSIS) ,SQL Server Reporting Services(SSRS), Data Transformation Services(DTS), HTML, DHTML, XML.

Educational Experience:
Masters in Management and Information Systems.

Professional Experience:

Confidential,Alton, IL Aug 2011-Till Date
MS SQL Report Writer
COPE Plastics Offers the Highest Level of Custom Fabrication and Application Solution Services.
Environment: MS SQL Server 2005, Windows XP, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), MS-Visual Studio, AX-Dynamics 2009, Excel.
Responsibilities:

• Installed and Configured MS SQL Server 2005 Version.
• Developed Complex programs in T-SQL, Writing Stored Procedures, Triggers and Queries with best Execution Plan.
• Worked on generating SSRS Reports with Parameters.
• Deployed the SSRS Reports into AX Dynamics using the AOT.
• Generated end-user Reports in AX Dynamics Environment.
• Worked with CTE, Temporary Tables for Creating Complex Scripts to generate various complex reports like Dynamic column Reports.
• Worked with Cascading-Parameterized, Drill-down, Drill-trough and various ad-hoc reports.
• Compared and Tested Legacy Data in Excel sheets and transformed the Data into SSRS Reports.
• Created Menus, Menu Items, Actions, Displays, Jobs, Labels in Microsoft Dynamics AX for Displaying SSRS Reports.
• Worked on Subscriptions of Reports through e-mail and automated the Jobs for Running the Reports.
• Optimized Performance and Capacity planning of Various Data processes related to Reports.
• Uploaded Reports on to Report manager and Organized them based on Business Rules.
• Generated and formatted stylish Report Layouts using Global Variables, Expressions and Functions.
• Identified and Worked with Parameters, Multi-Value Parameters for Parameterized reports in SSRS 2005.
• Worked on Performance of the Queries and reports using SQL Profiler.
• Generated Back-ups of the Production Database and refreshed the Training Environment.

Confidential,Boise, Idaho Oct 2010-July 2011
MS SQL SSIS Developer
Micron is best known for producing many forms of Semi-Conductor Devices.
Environment: MS SQL Server 2008, DTS, Windows XP, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), MS-Visual Studio.
Responsibilities:

• Developed Complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best Execution Plan.
• Rewrote SQL Queries to upgrade SQL Server Performance using SQL Server 2008.
• Created Used Defined Functions to Encapsulate Frequently and commonly used Business Logic making the system more Modular, Secured and Extensible.
• Involved in Configuring and Creating SSIS Solutions for ETL and Business Intelligence Process for Data Integration and Migration Services.
• Developed Packages for Data Extractions, Transformations and Loads using DTS/SSIS.
• Worked with creating and Managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Defined Check Constraints, Business Rules, Indexes and Views.
• Managed the Migration of SQL Server 2000 databases to SQL Server 2008.
• Worked in managing and Automating Control Flow, Data Flow, Events and Logging programmatically using Microsoft .NET framework for SSIS Packages.
• Involved in Performance Tuning and Monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to Optimize DTS Package Queries and Stored Procedures.
• Used highly Complex T-SQL Queries and SQL Scripts to perform Efficient Data Load based on Complex Business Rules. Extensively used T-SQL to Manipulate and Architect to produce results for users
• Used FTP (File Transfer Protocol) task to upload files to FTP Server.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet, and Flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.

Confidential,Westchester, PA Jun 2009-Sept 2010
MS SQL BI Developer
ING is a leading provider of retirement and insurance products and services.
Environment: MS SQL Server 2008, DTS, Windows XP, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), MS-Visual Studio.
Responsibilities:

• Worked with Auditing and Error Handling for SSIS Packages.
• Implemented SOX Checks for the database.
• Created Used defined Functions and Stored Procedures to meet the requirement.
• Worked with Exception Handling with @@Error and Try/catch.
• Created Various Indexes on Tables for better Query Performance.
• Worked with Running the VANet Engine (Works on C# application) to create CSV Files using SSIS.
• Re-Designed the File Naming Conventions according to the business user.
• Designed various Stored Procedures to work based on the run-types (SSR, CTE).
• Developed C# Scripts (limited) for Script Tasks in SSIS Packages.
• Transformed data from various data Sources using OLEDB Connection by creating Various SSIS Packages.
• Developed SQL Queries to fetch Complex data from different tables in remote databases using Joins, Database links and formatted the results into Reports.
• Deployed the SSIS Packages and Created Jobs for Efficient Running of the Packages.
• Involved in Performance tuning and monitoring of T-SQL blocks.
• Developed Database Triggers to enforce Data Integrity and additional Referential Integrity.
• Identified and Worked with Parameters for SSIS.

Confidential,Owing Mills, MD May 2008-April 2009
MS SQL BI Developer
BCBS is a health insurance company.
Environment: MS SQL Server 2005/2000,DTS,Windows 2003, SQL Server Management Studio(SSMS), Business Intelligence Development Studio(BIDS),MS-Visual Studio, ASP.net.
Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code like Joins for applications.
• Involved in installation and configuration of SQL Server 2005 with latest Service Packs.
• Normalized the database into small tables by applying rules of Normalization, defined Check Constraints and applied Business Rules.
• Used SQL Server Integration Services (SSIS) to perform Bulk Insert Operations from SQL Server 2005 databases to flat files/CSV and vice versa.
• Used SSIS to create ETL Packages (.dtsx files) to Validate, Extract, Transform and Load Data to Data Warehouse databases and Data marts.
• Improved Automation of existing processes of SQL using stored procedures and SSIS Packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used Various Kinds of Datasets with SSRS.
• Developed Custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Formatted the Report layout for the Requirement of the End User using SSRS.

Confidential,Boston, MA Oct 2007-April 2008
MS.SQL BI Developer
DentaQuest is an Oral Health Company.
Environment: MS SQL Server 2005,T-SQl, MS Excel, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Query Analyzer ,Windows XP.
Responsibilities:

• Transformed data from Various data sources using OLEDB Connection by Creating Various SSIS Packages
• Installation and Configuration of MS SQL Server on Windows Sever.
• Migrated from SQL Server 2000 to SQL Server 2005.
• Created new Database Objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production Environment for SQL Server.
• Developed Database Triggers to enforce Data Integrity and additional Referential Integrity.
• Wrote T-SQL Procedures to generate DML Scripts that modified database objects dynamically based on User Inputs.
• Involved in Performance Tuning and Monitoring of T-SQL blocks.
• Scripted the Database Consistency Checks (DBCC), scheduling the Scripts to run daily and Weekly basis.
• Scheduled transfer of backups and Log files to different Servers.

Confidential,Hyderabad, India May 2007- Sept 2007
SQL Server Intern
Environment: MS-Excel, MS-Access, SQL Server 2005,T-SQL, HTML, Windows NT.
Responsibilities:

• Installed and Configured SQL Server 2005 Environment.
• Reviewed Requirements and Detailed Design Documents.
• Created Complex Stored procedures, Triggers, Functions, Indexes, Views.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Conducted data import and export operations using the DTS wizard.
• Planned and implemented different SQL Queries required to fetch the data on different VB and JSP forms.
• Learnt performance tuning methods using SQL Profiler and Query Analyzer.
• Learnt execution plans and best way of writing T-SQL Code using Joins.