Professional Summary

• Extensively worked on Active-Active and Active-Passive Clustering.
• Extensive experience in implementing High availability solutions like different Replication models Snapshot and Transactional , Log shipping, clustering and mirroring on physical and virtual machines.
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Over 7 years of Information Technology Experience in requirement analysis, design, development, testing of client/server, web and n-tier architecture applications.
• 6 years of experience with Object Oriented Programming OOP concepts like Abstraction, Encapsulation, Polymorphism and Inheritance.
• Strong in standard Software Development Life Cycle SDLC and software development methodologies.
• Experienced in different phases of Software Development Life Cycle SDLC including Strategic Systems Planning, Designing, Object Oriented Programming OOP concepts, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.
• Having good experience of Microsoft SQL Server 2008, Microsoft SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS using Business Intelligence Development Studio BIDS and Crystal Reports 7.0/8.0.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
• Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.
• Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2000, 2005 2008.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in Query Optimization and Performance Tuning.
• Experience in Data Base backup and disaster recovery procedure.
• Experience in Replication Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT, Dimensional tables and Operational Data Store ODS .
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Strong Business and Application analysis skills with excellent communication professional skills.
• A self -motivated Individual with exemplary analytical and problem solving skills.

Technical Skills

Professional Experience

Confidential

MS SQL Server DBA/ETL developer

Description: Confidential is the largest knowledge resource on Information Technology. The portal is a knowledge resource on all leading tools and technologies from within the IT world and contains a host of sections that aim at providing the global developer community a one source stop for all information within the IT domain.

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services SSIS Packages.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment : Microsoft Windows 2008 Server, Microsoft SQL Server 2012,Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2007 Server, Windows 2003 Server .

Confidential

MS SQL Server DBA/ Analyst Programmer

Description: Worked on the project Confidential used for bankers/managers who can help customers if they have any overdrawn in account.

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2005.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles
• Performed Database backups with tools like lite speed.
• Used SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Setting MAX DOP Max degree of parallelism to 8 for 28 GB memory.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, T-SQL, Microsoft Reporting Service.

Confidential MS SQL Server DBA/Analyst Programmer

Description: Worked on the project Meaningful use, it is set of standards defined by centers for Medicare and Medicaid services CMS incentive programs that govern the use of electronic health records and allows eligible providers and hospitals to earn incentive payments by meeting specific criteria.

Responsibilities:

• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Performance tuning of HMS e apps ERP on SQL Server 7.0 and 2000.
• Developed Database Backup Scripts and automated this process
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Partly Participated in system study and analysis of software applications.
• Experienced in support, applications and software development

Environment: MS SQL Server 2000/7.0, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0, Windows 2003 Server, Compuware QA Load test and HMS report Writer.

Confidential

MS SQL Server DBA/Analyst Programmer

Description: Confidential collections package is a complete web based, flexible, scalable, parameter driven, configurable and user friendly browser based application used for keeping track of customers, return checks and payment against the checks. Application is automated to handle multiple branches at a time. Daily reports or reports for specified time duration were developed for management review.

Responsibilities:

• Worked on Agile Methodology Scrum to meet timelines with quality deliverables
• Involved in gathering and preparing the requirements from clients for product design and enhancements.
• Communicated with client for daily updates, reviews and demos. Involved in user training programs.
• Managed 17 databases at the headquarters running on 10 servers
• Database version control using VSS.
• Developed SQL scripts for maintaining administration tasks.
• Created DTS packages to maintain central repository. Extensively used different SQL2005 DTS tasks.
• Backup and Recovery plans Involved in installation and configuration of SQL server 2005.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
• Supported production and development databases.
• Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
• Maintained 6000 tables, or Field office and Headquarters database servers
• Maintained the field office database backups through SQL mail Scripts.
• Converted the legacy data from mainframes and dbase by using DTS packages
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
• Created and maintained users and user groups
• Involved in Extraction transformation and loading of data using SSIS to create packages
• Involved in user trainings and implementation.
• Implemented application variables for application level reports.
• Involved in creating, deploying and managing reports using SSRS.

Environment: MS SQL Server 2005/7.0, Microsoft VC , T-SQL, DTS, Windows 2003 Server, Compuware QA Load test, SQL Server Integration Services 2008, SQL Server Reporting Services 2008.

Confidential

SQL Developer

Description: Confidential is one of the biggest companies that provide insurance with dental and vision plans. It has also policies for disabled, children, students etc. Confidential project provides the insurance policies, discounts to the veterans and their dependents. Benefits are provided for the people who enroll with particular vision plan

Responsibilities:

• Involved in Analysis, designing and development of UI ASP.Net pages Web Forms after interacting with users for requirements.
• Used .NET AJAX controls to dynamically render the content on web pages using C .
• Used Team Foundation Server for the whole System which can be utilized as a Reporting System, Source Control, and Data Collection.
• Designed web pages for Veterans project for enrollment process, registration, login, collecting payment information, FAQ's.
• Excellent understanding of WPF, WCF services.
• Implemented Data access layer DAL using SQL server 2005 by creating Functions, Triggers and Store Procedures in PL/SQL
• Used MVC design architecture and Validation controls to check the validation of the controls that are used in this project.
• Developed User Control for Step plan individual process to add, delete, and find number of dependents of a particular family member and utilized this control as modal pop up.
• Utilized Web services to figure out the Step Plans in particular state using Web services Studio tool.
• Created Unit test cases for the web pages to test the functionality that has been created for the classes and was able to debug them.
• Used VM Ware Client to test the cross browser compatibility for the projects.
• Utilized IIS Pro and Internet information systems for starting the website and creating virtual directories.
• Implemented Agile Scrum methodology for the System and used Version one tool for creating back log items and the duration of the issue that needs to be resolved.
• Gathered user requirements by interacting with users and prepared Software Requirements Specification SRS and other supporting documents.
• Involved in deploying the project and testing it on the test servers.

Environment: : SQL server 2005, .Net Framework 3.0, Visual Studio 2005, Version one, Secure FX, Web services, Agile scrum, Java Script, PL/SQL, JQuery, CSS, VM Ware Client, Ajax Controls, ASP.Net MVC, IIS, IIS Pro, TFS.

Confidential

SQL Developer

Description: Confidential private limited is the owner and service provider of the one of Confidential largest Electronic Health Record software including in Confidential. More than a decade years of experience in Health and Medical software.

Responsibilities:

• Prepared architectural designs for the components that were assigned for development.
• Designed and implemented various modules such as login module, checkout module, search module and transaction module.
• Responsible for designing, developing and testing the Due Date Module using ASP.NET, HTML, CSS, JavaScript and SQL Server 2005 as database.
• Vacation Services Module was designed developed and tested using C .NET, HTML, CSS, VBScript, JavaScript and SQL Server 2005 as database.
• Product Report tool was designed and developed using ASP.NET, XHTML, HTML, JavaScript and SQL Server 2005 as database.
• Most of the internal structure uses XML for generating input/output.
• Implemented the Session Management, Serialization, Single Sign-on, Caching, Security, Cryptography etc. features using ASP.NET.
• Communicated with so many groups in order to integrate the new enhancement into the regular flow.
• Reengineered the entire schema of the database and implemented new schema.
• Designed and developed rich User interfaces using ASP.Net.
• Designed and developed web user controls in .NET using C .
• Wrote complex JavaScript functions for the client side operation.
• Unit testing of all developed pages and modules.

Environment: SQL Server 2005, C .Net, ASP.NET, Microsoft Visual Studio, VB.Net, HTML, CSS, JavaScript, VBScript, XML, Microsoft Visual Source Safe.