SUMMARY

• 7+ Years of IT experience as a Database Developer/Analyst using MS SQL Server 2008, 2005 and 2000 in OLTP/OLAP environments working with various domains such as Retail, Insurance, Banking, Healthcare & Telecommunication.
• Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC).
• Strong experience in using Microsoft BIDS (SSAS, SSIS, SSRS).
• Hands on experience in database development using Stored Procedures, Cursors, Indexes, Views and User - Defined Functions to facilitate efficient data manipulation and data consistency.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Good experience in using performance monitor/SQL profiler for handling Performance Tuning of long running queries and dead lock issues.
• Experience in creating Jobs, Alerts and scheduling Packages.
• Experience in developing ETL packages using SSIS with various transformation tasks.
• Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Good experience in designing and scheduling complex SSIS Packages for data migration from various sources like SQL Server, Oracle Database, Excel and Flat file.
• Experience with SSIS performance tuning using counters, error handling, event handling
• Experience 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.
• Experience in building various types of SSRS reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Experience in Migrating MS SQL 2000 to MS SQL 2005 using SQL Server upgrade advisor.
• Exposure of Data Warehousing methodologies such as Multidimensional modeling (Star / Snowflake Schemas).
• Good Understanding of OLAP Cubes, Dimensions, Slowly Changing Dimension phenomenon, surrogate key assignment.
• Good communication skills, quick learner and good performer both in team and independent job environments with strong logical and analytical skills.

TECHNICAL SKILLS

Databases: MS-SQL Server 2000, 2005, 2008, Microsoft Access

Programming Languages: TSQL, Java, ASP.Net, C#.Net, HTML, DHTML, XML

IDE Tools: Visual Studio .Net 2005/2008, Team Foundation Server

Framework: Microsoft .Net Framework 2.0

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting Services (SSRS)

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export(DTS)

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows XP Professional

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

MS SQL Server Developer

RESPONSIBILITIES:

• Involved in the development of SSIS Packages & SSRS reports using BIDS.
• Developing code for the process of loading the data into our databases and following the process of cleansing the data before loading.
• Developing the queries and stored procedures for the Post Process and preview on the UI.
• Performing extract/transform/load routines using SQL Server Integration Services.
• Performing intensive data analysis, testing for quality assurance, and migrating releases into stage and production environments.
• Performing non-development work, as a great deal of the warehouse is already built and in maintenance.
• Creating new jobs or using the existing jobs, reviewing the results to determine success/failure, documents success/failure, troubleshoots failures, provides up-to-date communication and maintains documentation.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Embedded C# coding in various script component and script tasks to execute custom scripts according to business rules
• Developing Reports for Internal use or for the business based on the requirements.
• Worked on grouping, filtering and sorting the data in the repots using SSRS.
• Embedded C# code in SSRS report for customization of reports for background color, toggling etc.,
• Supporting the ongoing Aftermarket projects and handling the issues on a day to day basis for the Aftermarket team.
• Involving in daily scrum meetings and reporting to the manager status of the assigned work.

Environment: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, SQL Server Integration Services 2005,T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server

Confidential, Rochester, NY

SQL Developer/Analyst

RESPONSIBILITIES:

• Worked extensively on TSQL Code, including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
• SQL performance tuning by modifying SQL or adding/changing indexes.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Involved in documenting and designing the ETL process based on business requirements and system specifications and involved in automating the monthly data warehouse build by using ETL tool SSIS.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files using Business Intelligence Development Studio.
• Developed several SSIS packages (ETL) to extract, transform and to perform custom edits to certain fields.
• Designed and deployed various complex reports such as Tabular, Cross-tab, Pie Chart reports, Sub Reports, Drill down reports, and Drop down reports using SSRS.
• Created several stored procedures and views for Reporting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time..
• Created jobs and Alerts using SQL Server Agent
• Developed different Scripts for the Data analysts for verification of reports.
• Involved in gathering the business requirements from the end users and developing the test plan and test scripts.

Environment: MS SQL Server 2005, MS Reporting Services 2005, SQL Server Integration Services 2005,T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server

Confidential, Chicago, IL

SQL Developer/Analyst

RESPONSIBILITIES:

• Responsible for performing T-SQL tuning and optimizing queries for reports which were taking longer time in execution.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created Views and Index Views to reduce database complexities for the Reports.
• Wrote complex stored procedures and user defined functions for the reports using T-SQL.
• Extensively used complex joins involving multiple tables from different databases.
• Used SQL Profiler and Index Tuning Wizard for the performance tuning of SQL queries and Stored Procedures.
• Created SQL Server SSIS packages (ETL) to upload data to the ware house from the staging area.
• Scheduled jobs to run the SSIS packages on daily basis using SQL Server Agent.
• Utilized Pivot tables to provide structure to Reports in proper format.
• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Created Drill Down reports using Microsoft SQL Server Reporting Services (SSRS).
• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, Business Intelligence Development studio, Windows 2003, Visual Studio 05

Confidential, FL

Sr. Developer

RESPONSIBILITIES:

• Worked on writing complex Stored Procedures using T-SQL as well as analyzing and debugging existing complex stored procedures.
• Created User Defined Functions to encapsulate frequently and commonly used business logic.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Involved in designing and creating Web UI screens using ASP.Net, C#.
• Design and Development of Business Layer and Infrastructure Layer components in C# and ADO.Net
• Development of Microsoft Application Blocks for Logging, Exceptions using C#
• Identified various data sources and established the connections using SSIS and constructed data source view based on the required reports.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS)
• Involved in designing, developing and testing assigned reports using Microsoft Reporting Services (SSRS).
• Developed Sub Reports, Tabular Reports using MS SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, ASP.Net, C#.Net, .Net Framework 2.0, VB Script, XML, Java Script, Windows 2003

Confidential, CA

SQL Developer

RESPONSIBILITIES:

• Worked as a developer in creating complex Stored Procedures, cursors, tables, and views and other SQL joins and statements for applications.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Used Joins and Union concept for extracting data from multiple tables.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed.
• Configured SQL mail agent for sending automatic emails when a process is failed or succeed.
• Involved in Performance Tuning by analyzing, tuning and optimizing SQL Server Applications using SQL Profiler.

Environment: MS SQL Server 2000, DTS, Enterprise Manager, Query Analyzer, T-SQL, SQL Profiler, Windows 2000 Server.

Confidential, Delaware

SQL Server Developer

RESPONSIBILITIES:

• Installed and configured MS SQL Server 2000 Enterprise Edition in the main office at MD and MS SQL Server 2000 Personal Edition in all the eastern shore warehouses
• Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs
• Developed and created logical and physical database architecture for servers at main office and warehouses.
• All tables in database were normalized up to third normal form.
• Migrated data from Text files and Excel spreadsheets to SQL Server databases using DTS
• Successfully migrated data to new location using Snapshot Replication, and implemented merge Replication to support up to date record of Inventory Information.
• Created views to replace old tables and created new tables with triggers to support new business needs.
• Modified the current stored procedures using Visual Source Safe 6.0 to meet current design.
• Created indexed views, and appropriate indexes to cut the complex query time.
• Implemented new indexing system reduced report processing time by average of 35%.
• Automated scripts in TSQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: SQL Server 2000 Enterprise Edition and & 7.0, Microsoft Visual Safe Source, VBScript, Microsoft Visio, Windows 2000/XP, IIS 5.0.