SUMMARY

• 6 Years of extensive experience in SQL Server Development including writing T - SQL Programming, Physical and logical Database Design, SQL server 2008
• Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes
• Experience in Normalization & De-normalization of database, Performance Tuning and Query Optimization.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, Correlated sub queries, Cursors and Triggers.
• Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
• Good hands-on working experience wif using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Expert in implementing and planning Server Security and autantication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2005/2008.
• Proficient in using global variables, expressions and functions for teh reports.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Followed teh Microsoft recommended best practices in designing, developing, implementation and testing of teh ETL using SQL Server Integration Services.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Great Knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/Snowflake Schemas, ODS.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.

TECHNICAL SKILLS

Databases: SQL Server 2008, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MySql, data warehouse.

Database Tools: SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL, Litespeed.

Languages: T-SQL, C,C++, VB 6.0, HYPERLINK \t " blank" VB.NET, PL/SQL, C# 2.0, LINQ, HYPERLINK \t " blank" ASP.NET 2.0, Java, HTML, UML, XML, XMLA, Java script, MS Sharepoint, MS windows

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux

Miscellaneous Tools: Windows Server 2008, Informatica, PowerCenter 7.x, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Groton, CT

SQL DEVELOPER/DBA

Responsibilities:

• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Developed T-SQL queries and stored procedures wif multiple parameters to created data sets for reports.
• Created partitions of teh Analysis Services cube to improve performance.
• Created Event Handlers for teh SSIS package on Error, on Post execute.
• Used named calculations and new named query cubes to calculate values at run time.
• Worked wif T-SQL, DDL, DML and DCL
• Designed reports and tuned them for optimal performance when using multiple parameters.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Developed SQL scripts, ensured optimal performance of teh queries to generate reports from various relational databases like Oracle, DB2.
• Used Lookups Transformation to get teh data from reference data sets
• Created permanent tables, temporary tables and table variables
• Used teh Index Tuning Wizard periodically to determine teh optimal indexes for teh database.
• Supported Database Mirroring in SQL Server 2008 using Principal, Mirror and Witness servers
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages
• Created cubes and defined teh dimensions.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries dat retrieve data from more TEMPthan one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing teh calculations to aggregate physical measures

Environment: MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

Confidential, ATLANTA, GA

SQL Server Developer

Responsibilities:

• Participated in creating reports dat deliver data based on stored procedures.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Experience in creating SSIS packages using dashboard.
• Involved in writing classes for business logic layer using C#.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers, cursors, UDF’s.
• Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
• ETL capabilities of SSIS were used to define imports of teh data, build scheduling packages.
• Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Iteration planning for new features and user stories in Agile Development methodology.
• Configured and maintained huge OLTP databases.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Design and coding of web services, windows services and libraries (.Net C#, VB.NET).
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports dat draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2005/2008.
• Created SSIS Packages to migrate slowly changing dimensions.
• Did a C#, ASP.Net / VB.Net / SQL Server project converting their existing VB6 desktop application to a web application.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008.
• Worked on improving teh performance of teh system.
• Involved in teh tuning of teh existing Database Objects.

Environment: SQL Server 2005/2008, SSIS, SSRS, C#, VB.Net 3.5, MDX, OLAP, ODBC, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, Agile Programming, Shell Scripting, Oracle, Crystal Reports.

Confidential, CT

SQL Server DBA/Developer

Responsibilities:

• Involved in teh migration of SQL Server 2000 databases to SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Maintaining teh database consistency wif DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2005/2000, C#., VB, VBA, ASP, .NET, Windows 2003.

Confidential, St Louis, MO

SQL Server Developer

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on teh financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• We handled lo t of production issues like data correction and resolves error handling
• Checked teh configuration and performance of teh existing databases including data file allocation, index fill factor, fragmentation and teh impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created teh new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on teh existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into teh databases.
• Configured teh new servers using failover clustering and SAN technology.
• Migrated all teh databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency wif existing databases to meet teh functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet teh performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, .XML,Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Designed, developed and tested processes, which include teh creation of SQL views, scripts, stored procedures and DTS packages.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Extracted data using Query Analyzer and DTS packages.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Created DTS packages for transforming data from various data sources.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Suggested creating Clustered and Non Clustered indexes on tables.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.

Environment: MS SQL Server 2005/2008, ETL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) DTS, T-SQL, MS Office Components, Microsoft Visio Studio.

Confidential

SQL Server Engineer

Responsibilities:

• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Writing Stored Procedures, creating user defined data types, Triggers and Functions.
• Rebuilding teh Indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and Disaster Recovery strategies.
• Implemented and Scheduled Replication Processes for updating our parallel servers.
• BCP, Bulk Copy, Select into are used to move data.
• Monitoring/Troubleshooting teh existing DTS packages.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index Tuning.
• Recovering teh databases from backup in disasters.
• Maintaining teh database consistency wif DBCC at regular intervals.
• Using log shipping for synchronization of database.
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: MS SQL Server 2005, WINDOWS SERVER 2005.