SUMMARY

Highly motivated Business Intelligence Professional using SQL Server 2005/2008 and Microsoft Technologies. Experience manipulating various data sources to support Senior Management decisions. Demonstrated leadership abilities andteam work skills as well as the ability toaccomplish tasksunder minimal direction and supervision.

Certification:

• Microsoft Certified in SQL Server 2005 Implementation and Maintenance.
• Microsoft Certified in SQL Server 2005 Business Intelligence.

Technical Skills:

Database MS SQL Server 2000/2005/2008, Microsoft Access, SharePoint 2007

Database Tools T-SQL, SQL Server Management Studio, Query Analyzer, SSRS, SSIS, DTS, SQL Agent, SQL Mail, SQL Trace, Performance Monitor, Client configuration Utility, Server configuration Utility.

Languages Transact SQL, SQL, MDX, COBOL, Visual Basic, C, Microsoft Visual
Studio 2005

Reporting Tools Web Intelligence, Business Intelligence Development Studio,
Performance Point Server, SharePoint 2007/2010

ETL tools DTS, SQL Server Integration Services (SSIS)

Operating System Windows 95/98/NT/2000/2003/XP, UNIX

Professional Experience:

Confidential,May/2011 – Present
SQL Server DBA

• Migrated more than 100 production SQL servers from Dell environment to Accenture environments
• Support Customers to build all SQL servers for more than 50 projects.
• Configuring multi node clusters for several customers on SQL Server 2000/2005/2008
• Migrated data through Log shipping, Replication methodology, SSIS, Backup and Restore, Attach and Detach and TSQL statement.
• Monitoring the database systems and jobs to ensure minimum downtime
• Automating tasks using job schedulers
• Setting up high availability (log shipping, database mirroring etc)
• Executing change control procedures (off business hours and weekends)
• Maintained and developed and tuning multiple SQL Server environments.
• Installed SQL 2005/2008 SQL servers, SQL cluster
• Analyzed and sustain capacity and performance requirements
• Analyzed, consolidate and tune database for optimal efficiency
• Restore and recover corrupted databases
• Installed and tested upgrades and patches
• provided support for critical situations
• Managed security Auditing.
• Designed and implementing Backup\\Restore Strategies for the SQL database.
• Managing large scale databases for several applications
• Familiarizing in Change management ITSM System process.
• Handling Root Cause Analysis tickets (RCA) after attending the Severity 1 tickets.
• Designing and Modeling Data Warehouse databases for Business Intelligence projects.
• Resolving many DR Issues, Cluster Issues, SSRS Issues, Replication Issues, MSDTC issues.
• Completing Health Checking as per business requirements.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005/2008 database. ETL capabilities of SSIS were used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Developing reports using SSRS. Used table control, matrix control for cross tab reports.
• Write queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Confidential,May/2010 – May/2011
SQL Server DBA

• Support Customers to implement several Business Intelligence projects for more than 25 customers.
• Managing large scale databases for State and Federal Governments projects.
• Familiarizing in Change management such as Maximo, Remedy, Peregrine, Impact, ManageNow R1, Manage now R2 and all customer’s Native Ticketing System process.
• Handling Root Cause Analysis tickets (RCA) after attending the Severity 1 tickets.
• Designing and Modeling Data Warehouse databases for Business Intelligence projects.
• Resolving many SSRS Issues, Replication Issues, MSDTC issues.
• Completing Health Checking as per business requirements.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005/2008 database. ETL capabilities of SSIS were used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Configuring multi node clusters for several customers on SQL Server 2000/2005/2008
• Migrating data through Replication methodology, SSIS, Backup and Restore, Attach and Detach, DTS, BCP, Logshipping, and TSQL statement.

Confidential,Houston, TX 06/ 2007 – 07/ 2009
SQL DBA

• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Tuned T-SQL queries for optimizing the performance.
• Created linked server for load balancing and increasing the performance of the Database.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS.
• Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Confidential,Houston, TX 04/2006 – 06/2007
SQL DBA

• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Converted logical Database Design into Physical schema using the balanced normalization in 2nd and 3rd Normal form for highest performance.
• Wrote Stored Procedures to implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created various reports using SQL Server 2005 Reporting Services.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Developed reports using SSRS, used table control, matrix control for cross tab reports.
• Write queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Handled production issues like data correction and resolved error handling.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

Confidential, 5/2003 - 11/2005
Database Administrator

• Actively involved in the complete software development life cycle for a design of database for new System.
• Handle performance tuning at the query and index level
• Transferred data from flat files, Excel spreadsheets to and from SQL Server using DTS.
• Responsible for database backup and security system.
• Designed and implementing Backup\\Restore Strategies for the SQL database.
• Configuration of client workstation with client operating system.
• Managed permissions for users and user groups.
• Monitored activity logs and system activity.
• Used DTS utility for Meta data transfer across servers.

Education

• Master of Computer Science
• Bachelor of Computer Science
• Certified Advanced Post Graduate in Computer Application
• Certified SQL Tomball
• Certified PC Trouble Shooting
• Diploma in Pharmacy