OBJECTIVE:

To achieve professional excellence in the field of IT by continuous learning, innovation and become globally compatible professional contributing to the development of software industry.

PROFESSIONAL SUMMARY:

• A technology - driven professional with a total of 7.11 year of experience in Software Industry.
• Evaluation of Change Requests and Impact Analysis for projects.
• Expertise as a SQL DBA.
• Extensive experience on Monitoring SQL Server performance and finding deadlocks and blocking. Maintaining database-consistency using DBCC at regular intervals. Rebuilding Indexes for better performance, User Management, Granting Role and Permissions to the Users, Verifying all instances are up and running as per the checklist
• Expertise in Data Base & Cube Backups and restore.
• Implemented log shipping and verifying job failures.
• Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Identifying and resolving Blocking and dead lock issues for effective performance.
• Skill in Identifying long running queries and resolving for better performance.
• Creating and scheduling jobs for Database Maintenance.
• Working knowledge on clustering and handled issues in clustering.
• Experience in AlwaysOn Availability.
• Worked experience in Cluster environment.
• Extensive experience in Creating & deploying SSIS packages.
• High trouble shooting skills for any job failure or Package failure.
• Extensive experience in SSRS Reports creation & deployment.
• Experience in SSAS Cube Maintenance.
• Knowledge of MDX Queries.
• Good Business and System analysis skills to understand the client requirements
• Good team player with excellent interpersonal and communication skills.
• Team Lead experience.
• Experience in Retail Domain, Agriculture domain & others.
• Good programming & analytical skills.
• Capacity for work-meeting deadlines.
• Good team collaboration skills.
• Highly self-motivated & goal oriented professional.
• Always ready to accept challenges.
• Good written and verbal communication.

TECHNICAL SKILLS:

Programming Languages & Framework: SQL Server 2005/2008/2012 , SSIS, SSRS,, Teradata,C#, VB.NET, Asp.Net, SSAS,Dot NET

Scripting Language: JavaScript

Platform: Windows 7,Windows 8,Windows Server 2008, Windows XP, Windows 2000/2003 Server

Database: SQL Server 2000/ 2005/2008/2012 , TeraData,Oracle

WORK EXPERIENCE:

Confidential

SQL DBA

Technologies: Confidential SSIS 2005/SSIS 2008/SSRS/SSAS

Back End: SQL Server 2005/2008

Environment: Windows 7

Responsibilities:

• Maintaining database backups.
• Creating and deploying SSIS Packages
• Enhancement of Package.
• Implementation of new functionality requested.
• Data verification.
• Maintain performance & Optimization
• Report Creation.
• Trouble shooting issues like deadlock & blocking.
• SQL Server performance check.
• Daily Syncup with the client.
• Gathering requirement from client.
• Preparation of LLD based on the requirement.

Confidential

SQL DBA

Technologies: Visual Studio 2010, C# SSRS 2008, SharePoint, XML

Environment: Windows Server 2008

Responsibilities:

• To develop Utility.
• Configuring Logshipping.
• DataBase backup & tape backups.
• SQL performance
• Cluster maintenance.
• Check Maintenance plan.
• To Develop SSRS report & deployment.
• Data Analysis
• Develop LLD & HLD based on BRD.
• Hooked SSRS report to Share point Site.

Confidential

SQL DBA

Technologies:MS-SSIS, SSAS 2008, Dot Net Silverlight

Back End: SQL Server 2008

Environment: Windows Server 2008

Responsibilities:

• To gather requirement from On Site Coordinator.
• To Develop SSIS Package and deployment
• Configuring Always on feature.
• Data Analysis & Deadlock handling.
• Identify blocking process & troubleshoot.
• Worked in Maintaintenance plan.
• Database mirroring configuration.
• Develop LLD & HLD based on BRD.
• SQL SERVER Performance tuning & Optimization of queries.

Confidential

SQL DBA

Technologies: MS-SSIS 2008

Back End: Teradata, OracleReportingBO

Environment: Windows XP

Responsibilities:

• Worked on Hot Fixes.
• Implemented functionality requested.
• Views modification
• Optimizing Queries and Performance tuning.
• Bug Fixing.
• Validating client’s data and removing duplicates records if required.
• Creating, Modifying and deploying SSIS packages.
• Loading & Downloading the Clients data using SSIS packages.

Software Developer

Confidential

Framework: 2.0

Technologies: ASP.Net 2.0, C#, Ajax, java script, CSS, xml

Back End: SQL Server 2005,SSIS

Report: SSRS

Environment: Windows XP

Responsibilities:

• Analyzing the Requirement Document received - Document assists the company to encapsulate the required information from the client.
• Understanding the Specifications, Brainstorming with the team and mapping the criteria for developing a Quality based project.
• Successfully Designed and Developed various Web based projects.
• Unit Testing for compatibilities between the Product and Requirement captured which include Test Cases.
• Performing integration testing of the deliverables.
• Client interaction

Confidential

Software Developer

Framework: Dot Net 2.0

Technologies: ASP.Net 2.0, C#

Back End: SQL Server 2005

Environment: Windows XP

Responsibilities:

• Learning Portal, is e-learning solutions for IT best practices. solutions in local languages all over the world. These solutions have been implemented by well known corporate clients to train several thousands IT professionals and in attaining visible and sustaining cost savings and IT service quality improvements within their IT organizations.
• Companies which uses Products/Services