SUMMARY

• 8+ years of experience in Database Administration and Database Development of Microsoft SQL Server 2008/2005/2000 in OLAP and OLTP environments.
• Expertise in Relational Database Management Systems concepts and to design and implement relational database models as per business needs using MS Visio and ERwin.
• Experienced in Database Design activities including File Group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Proficient in MS SQL Server 2008/2005 installation and configuration for Windows Clusters and Standalone servers, as well as migration of SQL Server 2000 databases.
• Experienced in Transact - SQL (DDL and DML) queries including Views, Triggers, Stored Procedures, User Defined Functions and Common Table Expressions (CTE’s).
• Expertise in Performance Tuning - Performance Monitor, Activity Monitor, SQL Profiler, Database Tuning Advisor (DTA), PSSDIAG, SQLdiag, System Stored Procedures, DBCC commands, Dynamic Management Views (DMV’s), Dynamic Management Functions (DMF’s).
• Expertise in Query Tuning - Analysis of: Index and Fragmentation, Statistics, Execution Plans, Stored Procedure Recompilation, Blocking, Deadlocks.
• Expertise in Database Backup, Restore and Recovery Procedures.
• Experienced in implementing Disaster Recovery and High Availability with Failover Clustering, Log Shipping, Database Mirroring and Replication.
• Experienced in ETL using BCP Utility, Bulk Inserts, SQL Server Integration Services (SSIS), DTS Packages and Import/Export Wizard.
• Expert in designingSSISPackages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided bySSIS.
• Proficient in developing, debugging, deploying SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Oracle, Flat Files etc.).
• Expertise in Administration of SQL Server Reporting Services (SSRS) including installation, configuration and managing security.
• Experienced in creating and deploying Standard and Ad-Hoc SSRS reports including Drill Down, Drill Through, Parameterized, Linked Reports and crystal reports.
• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers.
• Experienced in creating and managing Alerts, Operators, Jobs and Error Reporting through SQL Server Agent, SQL Mail Agent.
• Implemented new features of SQL Server 2005 like Data Partitioning, Snapshot Isolation, Online Indexing, Data Base Snapshot, DDL triggers and DMV’s.
• Implemented new features of SQL Server 2008 such as Filtered Indexes, Change Data Capture (CDC), Change Tracking, Partition Aligned Indexed Views and Backup Compressions.
• Motivated, enthusiastic and project oriented team player with excellent written and verbal communication skills.
• Worked withendusers/customersto understand business requirements,recommended technical solutions and documented functional requirements.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Experience in Performance Tuning in SSIS packages by usingRow Transformations, BlockandUnblock Transformations
• UsedTortoise SVNa version control software for windows to store, run, view, edit and revert back to different versions of the design

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008 R 2/2008/2005/2000, Oracle 10g

Database Technologies/Tools/Software: SQL Server Enterprise Manager, Query Analyzer, SQL Server Management Studio, Performance Monitor, Activity Monitor, SQL Profiler, Database Tuning Advisor (DTA), PSSDIAG, SQLdiag, SQL Agent, BCP, Bulk Insert, DTS, SSIS, BIDS, SSRS, Database Migration Wizard, Import/Export Wizard

Other Tools: MS Access, MS Visio, ERwin, LiteSpeed for SQL Server, SharePoint 2007, Macromedia Suite, IBM Lotus Notes, MS Excel, SCOM/OpsMgr 2007.

Programming and Scripting Languages: SQL, T-SQL, MS Visual Basic 2008, XML, HTMLOperating Systems Windows Server 2003/2008/2008 R2, Windows 9x/NT/2000/XP/Vista

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• InstalledSQL Serverand Management tools usingSQL ServerSetup Program.
• Creating SSIS packages and scheduling the SQL agent jobs to automat execution of SSIS packages.
• Implemented several SSIS (SQL Server Integration Services) packages for data feed from various servers and environments. Deployed the packages using deployment utilities.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• DesignedSSISPackage for extracting data from heterogeneous source systems, transform and finally load into the DW.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files,SQL Server, Excel and Access toSQL Serverusing Business Intelligence Development Studio.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Strong Data Warehousing and analysis skills including MDX language, OLAP, Dimensional modeling using Star Schema/Snowflake schema.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Migrated packages from development server to production server using package configuration.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Implemented AD HOC reporting with the report builder for the end users.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated reports using Expressions and Functions using SSRS.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Improved Performance of the database by creating Clustered and non clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• UsedSQL Serverprofiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery
• Developed an inventory management reporting system usingCrystalReportsto provide quick and accurate inventory analysis
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column.

Environment: MS SQL Server 2012, 2008R2, 2008/2005, SSIS, SSAS, T-SQL, SSRS-2008/2005, Erwin, Enterprise, VB.NET, Visual Studio 2008/2005.

Confidential, Wilmington, DE

MS SQL Server / SSIS /SSRS / SSAS Developer

Responsibilities:

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server 2008 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• Designed and developedSQLServer2008databases, including tables, stored procedures and functions.
• Created Packages that dealt with text files containing dynamic number of columns.
• Created, Implemented and Executed T-Sql statements including Triggers
• Generated reports from several tables and databases using Join statements
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Provided technical support to internal developers and external clients.
• Worked with financial systems team members to document systems and process environments.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Made sure that standards and best practices in database development were followed and maintained.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Experience in designing and developing relational database analysis and modelling.

Environment: MS SQL Server 2008 (SSMS), MS SQL Integration Services 2008, VB.Net, MS Excel, Window XP, MS Word, Visual Studio 2008, MS SQL Server Reporting Services (SSRS)

Confidential, Scranton, PA

SQL Server Developer

Responsibilities:

• InstalledSQLServer2008 with latest Service pack and established connectivity with the database.
• Created configured and maintained database maintenance plans and also database backup and recovery
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Create the clustered/non-clustered indexes on tables; created views, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Performed tune to optimizeSQLqueries usingSQLprofiler and query analyzer.
• Created Indexes Constraints and Rules on database objects.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Designed coded and implemented ad hoc reports using existing report models in SSRS
• Reports using Data Source Views in Report Builder 2.0
• Developed Reports Using SSRS on statistical data during migration of data.

Environment: MS SQL Server 2008 (SSMS), MS SQL Integration Services 2008, SSRS 2008, SSAS 2008, VB.Net, MS Excel, Window XP, MS Word, Visual Studio 2008.

Confidential, Addison, TX

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.Net, MS Excel, Window XP, Toad.

Confidential, Wilmington, DE

SQL Server Developer

Responsibilities:

• Installation and maintenance of MS SQL Server 2005 failover clustering which are built on top of Windows 2003.
• Supporting and managing servers in production & pre-production on fail over clustered and SAN environments.
• Migration the four major application and database servers from PNC environment to new BNY clustered environment
• 24/7 Production support and maintaining the production servers highly available and monitoring the servers.
• Building new servers, server migration, upgrading to latest windows OS on servers, SQL upgrade, IIS installation & configuration.
• Attaching the databases to newly built Fail over Clustered SQL Servers on 2005 server.
• Building the users on newly created servers for various active directory groups.
• Installing Security patches to servers & performing password reset for service accounts.
• Providing the access privileges for users on all applications depending on their access levels and company policies.
• Creating new databases according to the specifications and business requirements.
• Creating SSIS packages and scheduling the SQL agent jobs to automat execution of SSIS packages.
• Scheduling the backup strategies for all the newly migrated servers for disaster recovery plans.
• Setting up the Test, QA environments with test databases for developer, QA and BSA testing groups.
• Converting DTS packages to SSIS packages, validating the packages, and migrating to SQL Server 2005 Integration services.
• Creating new SQL Agent jobs and scheduling the jobs to run DTS and SSIS packages for various tasks.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Create the clustered/non-clustered indexes on tables; created views, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Place the huge table/non-clustered index on the separate file group to improve the performance.

Environment: Windows 2003, MS SQL Server 2005, DTS packages, SSIS packages, SSRS, Profiler, Index Tuning Wizard, LiteSpeed 6.0, IIS 7.0, .NET, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Set up SQL Server configuration settings.
• Contributed to the designing and implementing of comprehensive Backup plan and Disaster Recovery strategies.
• Used LiteSpeedforSQLServer to take database backups.
• Assisted in trouble shooting and fine-tuning of databases for better performance and concurrency.
• Monitored SQL Server performance using SQL Profiler.
• Used log shipping for synchronization of database.
• Utilized BCP, Bulk Copy, Select Into to move data from flat files to databases.
• Wrote Stored Procedures, Triggers and User Defined Functions.
• Rebuilt the indexes at regular intervals for better performance.
• Analyzed long running slow queries alongside DBA’s and tuned the queries to optimize application and system performance.

Environment: MS SQL Server 2000, T-SQL, Enterprise Manager, Query Analyzer, LiteSpeedforSQLServer, MS-Access 2000, Windows NT 4.0.

Confidential

SQL Server Developer

Responsibilities:

• As a developer I was responsible for the systems study, analysis, understanding systems design and database design.
• Involved in creating small DTS packages and scheduling them using jobs.
• Experience in re-writing the Stored Procedures by using control statements instead of Cursors.
• Experience in developing web forms using .Net Framework 2.0 and using C# using Agile Methodology.
• Wrote T-SQL for the retrieval of the data.
• Responsible for creating views to generate weekly and monthly reports for front end developers and non technical guys.
• Developed Master/Detail Reports and Tabular reports based on the user requirements using Crystal Reports.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Environment: SQL Server 2000, Windows 2000, Enterprise Manager, C#, .Net Framework 1.1, Crystal Reports, DTS, T-SQL.