SUMMARY

• Over 7 years of IT experience as a MS SQL Server Developer of SQL Server 2000/2005/2008 in various domains including 2+ experience as Database Administrator.
• Experience with Microsoft Hyper V (2008), MS virtual server (2003), MS virtual PC.
• Experience in installation, migration, up gradation using SQL Server Upgrade Advisor and configuration of Microsoft SQL Server 2000/2005/2008 and databases.
• Experience in using SQL Server 2005 Management Studio (SSMS).
• Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Experience in Database Administration activities like Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization, log shipping, data mirroring.
• Expert level skills in Data Modeling, Table Normalization, Optimization and Performance Tuning.
• Expert in Transact - SQL (DDL, DML) designing dynamic store procedures, cursor, triggers, functions, constraints.
• Expertise in Database design, Database Creation, Maintenance, Monitoring and Troubleshooting.
• Extensive experience in handling data in various environments (OLTP/OLAP, Data warehousing).
• Experience in Query Optimization, Client/Server connectivity and Database Consistency Checks with the help of DBCC utilities.
• Extensive experience in importing and exporting the data between homogenous and heterogeneous systems using Extraction Transformation and Loading (ETL), SQL tools (Data Transformation Services (DTS), Bulk Copy Program (BCP), Bulk Insert).
• Extensive use of ETL for data massaging/scraping, cleansing, scrubbing and manipulating using various SSIS packages.
• Experience in staging in data warehouse to get rid of null values and change data types. For organizing data.
• Expert in data massaging, sorting using SSIS data flow tasks like derived column, import column, conditional split, lookup, fuzzy lookup, pivot and UnPivot.
• Experience in Error logging and Event Handling: Precedence Constraints, Break Points, Check Points and Logging.
• Created Scripts for Restoring databases, Linked Servers and Transfer logins for the Data Center Move.
• Extensive experience in creating daily, weekly, monthly, quarterly and yearly reports using SSRS(drilldown report, drill through report, ad-hoc report).

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008 R2, 2008, 2005, 2000, MS Access

Database Technologies/Tools: SQL Server Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Client Configuration Utility, Data Transformation Services (DTS), Integration Service (SSIS), Analysis Service (SSAS), Reporting Service(SSRS), ODBC, ADO, Data warehouse

Operating Systems: Windows Vista, XP, 2003, 2000, MS DOS

Programming Languages: C/C++, XML, Visual Studio, T-SQL, PL/SQL

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook

PROFESSIONAL EXPERIENCE

Confidential, NYC NY

SQL Server Developer/SSIS/BI Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 Integration Services (SSIS).
• Enhanced and modified SQL server 2005, 2008 production database tables, views, stored procedures and ETL packages.
• Provided technical leadership and expertise in data mapping, database design, and implementation and maintenance phases.
• Created Database Backup Plans for Full, Differential and Transactional Database Backups with different recovery models (Simple, Full and Bulk).
• Planned and executed database integration, consolidation and modifications.
• Database monitoring and tuning.
• Checked Performance Tuning, Indexing, Query Optimization.
• Successfully implemented Database Mirroring in SQL Server 2005.
• Created and managed SSIS packages, and dynamic stored procedures.
• Used SSIS for data import and export data from SQL Server to Access, text and EXCEL files.
• Created and altered database objects like tables, views, indexes, stored-procedures, triggers, cursors.
• Converted various SQL statements into stored procedures thereby reducing the Number of database traffic (since Stored Procedures passes the whole block at one time).
• Ensured thatSQLsystem improvements are successfully implemented and monitored to increase efficiency.
• Created complex prototypes, code, test, debug, document, and implementSQLand web application development.
• Developed and assisted with designing all systems integrations using SSRS reporting and allSQL-based stored procedures and databases.
• Developed complex Queries & dynamic Stored Process for creating Maintenance Plans to Generate Reports everyday for Server’s Health check.
• Supported all departments with requests related to SQL database, such as ad-hoc reports, parameterized, drill-down and drill-through reports.
• AdministerSQLserver database environments and monitor site performance. Facilitate the performance, aggregation, and analysis ofSQLdatabases and statistics reports, in coordination with Operations and Information Technology.
• Developed new and provided support for existing secure data feeds with external parties.
• Implemented, maintained and responded to critical job notifications on failure.
• Designed and implemented scripts in SSIS MS Visual Basic .NET and C# .NET.

Environment: SQL Server 2008/ 2005 (SQL Server Management Studio, SQL Profiler, Integration Service (SSIS), Reporting Services (SSRS)), VB 6.0, .NET.

Confidential, New York

SQL Server Developer/DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of SQL Server 2008 on windows 2003/2008 Servers.
• Created SSIS Templates for ETL to get data from homo and heterogeneous database, flat files, excel and XML data sources.
• Worked with change data capture (CDC) to load incremental data on hourly basis to make data warehouse near real time.
• Loaded SCD-1 and SCD-2 dimensions using best practices to make EDW load faster.
• Created Excel report framework using SSIS (using excel Interops) to generate excel reports for front office people based on business requirement.
• Used Execute SQL Task, For Each Loop Container, Sequence Container, Execute process task, Execute package task, FTP Task, Configuration, Custom Logging using Event handler, Package level error logging and Data level error logging, Aggregate transformation, Derived Column Transformation, Pivot, UnPivot, Look up, Audit Transformation and Precedence Constraint to support Business logic and data load logic.
• Created deployment script and deployed SSIS package, TSQL objects, SSRS objects on SIT, QA and PROD server.
• Created around 50+ jobs to support interface inbound and outbound feed, database load, import/export data, generate Excel reports based on custom calendar.
• Created SSRS - parameterized, sub-reports, drill drown, drill trough reports, linked & snapshot reports busing BIDS studio.
• Monitored the size of the transaction log. Managed databases on multiple disks using Database Mirroring.
• Implemented and Managed Transactional Log Shipping for disaster recovery.
• Implemented and Maintained Database Security - Creating users and Assigning Roles and privilege at Server and Database Level.
• Designed and Implemented Performance Tuning, Query Optimization and Maintenance plans for consistency checks, re indexing within defined Maintenance Window.
• Created database objects like tables, stored procedures, indexes, views, triggers, functions and cursors using T-SQL statements, worked with DML and DDL for retrieval and modification of the data.
• Transformed data to and from various data sources by creating SSIS packages. Used BCP command line utility for bulk data import/ Export.
• Responsible in checking query plans and making sure each and every query is using appropriate useful indexes.
• Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler.
• Provided 24/7 Support for Production, Development & Test Servers of SQL Servers. Detect, Diagnose, Repaired and Reported databases errors, Application errors and Connectivity issues.

Environment: SQL Server 2005/2008, T-SQL, SQL Server Management Studio, SSRS, SSIS, Query Analyzer, SQL Profiler, Business Intelligence Development Studio (BIDS).

Confidential, Waltham, MA

SQL Server, SSIS and SSRS Developer

Responsibilities:

• Participated in both data design and data processing sessions for assigned project and team.
• Developed and tested stored procedure to automate the database backup and scheduling tasks.
• Created Linked Servers to move data from one server to another.
• Created migration/conversion designs that met the project's business, system and data requirements.
• Worked for Designing and developing Transact-SQL processes, ETL (Extract, Transform and Load) processes using Microsoft SQL Server Integration Services (SSIS).
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Optimized ETL processes and T-SQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
• Used index tuning wizard to tune the indexes on various tables.
• Resolved Deadlocking, blocking and locking issues by looking into Profiler Trace.
• Investigated the reason behind blocking and provided detailed information and analysis to the application members.
• Installed and configured SSRS (SQL Server Reporting Services) deployed reports using the web interface and configured subscriptions for the reports.
• Generated Simple Reports, Parameterized Reports using SSRS ( Reporting Services)
• Responsible for creating SSRS reports using the wizard, list reports and managing security.
• To respond to data design and/or data processing problems and finding solutions in a timely manner.

Environment: SQL Server 2005 (SQL Server Management Studio, SQL Profiler, Analysis Service (SSAS), Reporting Services (SSRS), XML

Confidential, San Jose, CA

SQL Server Developer

Responsibilities:

• Upgraded SQL Server 2000 to SQL Server 2005 with Service Pack 2 and implemented it successfully in Testing /Production Environments.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services.
• Developed SSIS packages in SQL Server 2005 to successfully migrate data from DTS 2000.
• Maintained client data import/export processes.
• Maintained all redundancy and disaster recovery configurations for SQL systems.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Loaded the data into another data sources (Oracle, SQL Server or DB2) using SSIS.
• Developed and improved stored procedures, SSIS Packages and MS SQL Server databases.
• Written queries using Inner Join, Left-Outer Join, Right-Outer Join and Cross Join.
• To identify and troubleshoot issues and tune all SQL databases for maximum performance and up-time.
• Supported all departments with requests related to SQL database, such as ad-hoc reports, parameterized, drill-down reports.
• Developed and maintained up-to-date documentation of all SQL environments and processes associated with the database.

Environment: SQL Server 2005 (SQL Server Management Studio, SQL Profiler, Analysis Service (SSAS), Reporting Services (SSRS), XML

Confidential, Sioux Falls, SD

SQL Server Developer

Responsibilities:

• Installed SQL Server 2005 on Windows 2003 Advanced Server, on pre-production server.
• Monitored the performance of SQL Server 2005 on pre-production servers.
• Planned and Tested to Upgrade SQL Server 2000 Databases with SQL Server 2005
• Implemented Log Shipping successfully using SQL Server 2005.
• Setting up SQL Database Mirroring.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Created SSIS packages for loading the data.
• Created stored procedures, scripts, cursors and tested them on the test servers and then moved them to production servers.
• Written queries using Inner Join, Left-Outer Join, Right-Outer Join and Cross Join.
• Written Inline and Scalar User Defined Functions and implemented Instead Of and after triggers and specified their order of execution.
• Involved in Creating tables, indexes and designing constraints.
• Used system tables, system stored procedures and DBCC commands for database maintenance.
• Actively participated in database optimization, performance monitoring and index tuning.
• Reduced the Query Execution time by Monitoring and Tuning Indexes using Index Tuning Wizard.
• Actively participated in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Setting up SQL Database Mirroring.
• Created SSIS packages for loading the data.
• Generated reports using Crystal Reports, Parameterized reports and drilldown reports.
• Worked as a team member for 24X7 on call production support.

Environment: SQL Server 2005, SSIS, SSRS, SQL Server 2000 Enterprise Edition, Windows Server 2003, T-SQL