SUMMARY

• 6+ years of IT experience in Database Architecture, Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2008,2005,2000, 7.0 Enterprise Edition in Production, Test, Development, Replication & Cluster Server Environments.
• Good experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive Failover Clustering.
• Experience in using data modeling tools like Microsoft Visio and Erwin and developing logical & physical designing.
• Expert in creating ETL (SSIS) packages and schedule them.
• SQL database experience in a high transaction and multi server production environment, current experience with SQL 2008/2005.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Worked Extensively on ETL process using SSIS package.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Migration experience with DTS to SSIS 2008.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2000/2005/2008 RDBMS database development including T - SQL programming, Data mining, working with changing dimensions
• Developing reports on SSAS & SSRS on SQL Server ( 2000/2005/2008 ).
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Worked on OLAP Data warehouse, Model, Design, Implementation
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000, 20005 and 2008 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000,2005 and 2008 databases.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.

TECHNICAL SKILLS

Languages: C, C++, .NET, T-SQL, VB script 6.0, Active Scripting.

RDBMS and Database Tools: MS SQL Server 2000/2005/2008/2012 , MS-Access, Oracle, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP (Online Analytical Processing)-Cubes, Storage, Data Mining Models, Visual Source Safe, BCP and Business Intelligence & Develop Studio.

Front End: .Net, PHP, MS Visual Basics 6.0

Web Technologies: HTML, XML and Java Script

Middle Tier: MSMQ, Web Logic, Web Connect, Microsoft .Net Technology

Reporting Tools: Crystal Reports, SQL Server Reporting services (2005 and 2008)

Web Server Technologies: IIS 5.1/6.0/7.0

Data Modeling Tool: ERWIN 4.0, Visio 2002

Operating System: Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 2003/2008, XP

Other Tools: Idera Diagnostic Manager, Quest spotlight, foglight, VMware, OLAP, OLTP.

PROFESSIONAL EXPERIENCE

Confidential, MA

SQL Server Developer

Responsibilities:

• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Database Capacity Planning and space forecasting.
• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Involved in Data Modeling Using Erwin.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Designed packages using SSIS to generate data to reports.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server 2005 and 2008.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Created and maintained Database Maintenance Plans
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Wrote Query Scripts for business application to access data in an easy manner.
• Created Tables, Indexes and designing constraints.
• Extracting and Loading data into SQL Server Database using SSIS.

Environment: Windows Server 2003, MS SQL Server 2000, Microsoft SQL Server 2005, Reporting Services, XML, Crystal Reports 10, vb script.

Confidential, NJ

SQL Server Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Principle responsibility is to implement support, maintain, monitor and tune high available and clustered database systems.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Managing the use of disc space, memory and connection.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Maintain disaster recovery strategies for the database and failover methods.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2008 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000, 2003 and 2008 servers in very large environments.

Environment: Microsoft Windows 2003,2008 Advanced Server, Microsoft SQL Server 2008/2005 Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP, Hardware: Compaq Proliant 8500 Server, Visio, Crystal Report XI.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Installation SQL Server 2008 with the latest service packs.
• Database capacity planning and space forecasting.
• Migrated Database from SQL Server by using side by side migration.
• Creating tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Actively worked on SQL XML and X-path queries.
• Wrote scripts to review object permissions in all databases.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Created SSIS packages using Active X scripts and with Error Handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2005 and 2008
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans.
• Implemented Database Mirroring between Development and Test Server.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
• Good knowledge on SQL LiteSpeed a Backup solution for MS SQL Server.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function
• Reviewed Third Party tools Diagnostic Manager ( Idera ) and Site Scope so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs

Environment: SQL server 2008/2005, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL Lite Speed.