Summary

• Over Nine years of experience in Database Architecture, Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2008/2005/2000/7.0 Enterprise Edition in Production, Test, Development, Replication Environment.
• Extensive experience in Installation, Database administration, Configuration, Backup & Recovery, Database Security, scheduling, log shipping, Data Transformation Services, Database designing and Query optimization, System Development Life Cycle(SDLC).
• Microsoft Certified DBA and Technology Specialist.
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 which includes migration from DTS to SSIS.
• Good experience in Creating and deploying DTS packages to schedule the jobs for batch processing, and automated the jobs to execute by SQL Server Agent Services, active batch processing and command line scripting, and developing database objects by Common Language Runtime (CLR).
• Experience in Automated bugs/white list apply in all Prod/Sandbox, automated tools for moving files between cross domains using active batch scripts and Pre-Prod environment using DOS batch script with PsExec and Robocopy utilities.
• Thorough knowledge of Clustering SQL Servers in Active/Passive environment.
• Good experience in data mining, Capacity planning, troubleshooting, backup and restore procedures from multiple databases CAMIS mainframe database
• Ample knowledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD) and good experience in conversion of non-relational database like ADABAS to relational database.
• Great Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, (Data Transformation Services)DTS, Bulk Insert and BCP.
• Good Experience in generating stylish, detailed, drill down and drill through reports in SQL Server Reporting Services (SSRS) 2008 and Crystal reports.
• Experience in Designing, Building the Dimensions, cubes with star and snowflake schemas using SQL Server Analysis Services (SSAS).
• Experience in Cube designer in Business Intelligence Development Studio (BIDS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Migration experience in transferring database from oracle and Sybase to SQL Server
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, and Validation issues.
• Expert in creating Tables, Views, constraints, Indexes, Replication, and SQL joins and query writing.
• Highly Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions in achieving high performance.
• Experience in Performance tuning, using Performance Monitor/Profiler to solve Dead Locks/Long running queries and query optimization.
• Experience in creating and optimizing tables, indexes, schemas, views.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases/file groups/files/transaction logs.
• Well experienced on BCP, DTS packages, Jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

Certifications & Education

• 70-431: Microsoft SQL Server 2005 -Implementation and Maintenance.
• 70-443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005.
• 70-528: Microsoft .NET Framework 2.0 - Web-based Client Development.
• Bachelors of Technology in Engineering

Professional Experience

Confidential,Charlotte, NC Mar’10-Till Date
Technical Lead MS SQL Server
Duke-Energy is one of the largest electric power companies in the United States, supplying and delivering energy to approximately 4 million U.S. customers. We have approximately 35,000 megawatts of electric generating capacity in the Carolinas and the Midwest, and natural gas distribution services in Ohio and Kentucky.
Responsibilities:

• Lead the Reporting Team, dealt with business requirements.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2008.
• Worked on large scale database’s transactions and done drill trough and drilldown reports using Reporting Services.
• Generated and managed reports using SQL Server 2008 Reporting Services (SSRS) on to SharePoint server and report manager.
• Build and Deployed cascaded and parameterized reports.
• Created SQL Server traces using SQL Server Profiler for optimal performance monitoring.
• Created Database Maintenance Plans for Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in the processes of high availability like backup-restore, clustering, log shipping, replication, and database mirroring
• Developed SSIS packages for migration of data between different environments like test, QA and production.
• Fine-tuned the database objects and server to ensure efficient data retrieval.
• Performed DBCC utilities and fixed data corruption in application databases.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer Pool hit-ratios.
• Captured long running SQL/runaway queries using SQL Profiler.

Confidential,Gainesville, VA Sept’09-Mar’10
MS SQL Server Developer/DBA
AHC, the sister company of Convergent is one of the largest revenue cycle management companies in the U.S., with more than 750 hospital clients. It is the pre-eminent provider of large balance insurance claims collections and also provides self-pay collections, workers compensation outsourcing, motor vehicle program outsourcing and Medicaid eligibility services.
Responsibilities:

• Created SSIS packages to for the extraction and transformation of data to the data warehouse from the production and development environments.
• Worked on performance tuning of queries used by developers.
• Scheduled the ETL packages for automatic process of extract, transform and load.
• Made drilldown, drill trough cascaded, ad hoc reports using SSRS 2005.
• Built queries, stored procedures for the extraction of the data.
• Made data quality and requirement analysis for creating new data warehouse.
• Exported the data from SQL SERVER 2000 to SQL SERVER 2005, SQL Server 2008.
• Configured of Database Mail in SQL SERVER 2005, SQL Server 2008
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for Tuning of indexes.
• Worked on MDX queries in the process of creating data ware house.
• Scheduled the backups for Databases and Transaction log. Done restoration operations and dealt with the backup strategies.

Environment: SQL Server 2008/2005/2000 Enterprise Edition, SSIS, SSRS, SSAS(MDX) and Windows Server 2003.

Confidential,Cincinnati, OH Jan’08-Sept’10
SQL Developer/DBA
Fifth Third’s bank history is rich in growth and innovation, reflecting the economic strength and vitality of the region the bank serves."Today, Fifth Third is widely recognized as one of the strongest top-performing banks in the nation. Fifth Third’s philosophy of quality continues as the bank expands, creating the standard for the banking industry.
Responsibilities:

• Created the centralized data warehousing server for reporting into SQL SERVER 2005 and SQL SERVER 2008.
• Created DTS package to schedule the jobs for batch processing using active batch processing.
• Created and deployed more efficient and stylish reports in reporting Services 2005 and SQL SERVER 2008.
• Upgraded the database from SQL 2000 to SQL 2008.
• Worked and large scale database’s transactions and done drill trough and drilldown reports using Reporting services.
• Generated and managed reports using SQL Server 2008 Reporting Services (SSRS).
• Build and Deployed cascaded and parameterized reports.
• Used ColdFusion like third party tool for the front end development support.
• Dealt with Customer relationship management (CRM) to improve customer relationship and increase the efficiency of services provided to customers.
• Created cubes in star schema and snow flake schema using SQL Server Analysis Services (SSAS).
• Developed Key Performance Indicators (KPI) to evaluate the business success using SSAS.
• Developed of SSIS packages which include extraction, transformation and loading.
• Exported the data from SQL SERVER 2000 to SQL SERVER 2005, SQL Server 2008.
• Done conversion of non-relational database to relational database using ADABAS
• Optimized the stored procedures to increase the performance and execution time.
• Done Estimation and planning of backup and restore of the databases.
• Developed the database objects using Common Language Runtime (CLR).
• Wrote Stored Procedures, Views, and Triggers to increase the performance.
• Configured of Database Mail in SQL SERVER 2008, SQL Server 2008
• Configured the replication between SQL SERVER 2000 to SQL SERVER 2005 & 2008
• Used other third party tools like Red gate and lite speed for efficient back up and integrated servers like BizTalk.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for Tuning of indexes.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested Backup strategies.

Environment: SQL Server 2008/2005/2000 Enterprise Edition, SSIS, SSRS, SSAS and Windows Server 2003.

Confidential,Wilmington, DE Mar’06-Dec’07
MS SQL Server Developer/DBA
DuPont Pharmaceuticals is a worldwide business that focuses on research, development and delivery of pharmaceuticals to treat unmet medical needs in the fights against cardiovascular disease, central nervous system disorders, cancer and inflammatory diseases. The company also is a leader in medical imaging. The­ Project was built to facilitate the data warehousing of various business departments like Sales, Inventory management, Budgeting, Production and Forecasting.
Responsibilities:

• Objects moving between Development, Staging, Pre Production and Production.
• Writing Stored Procedures & Functions based upon request.
• Created a batch processing to prepare data in staging area for final migration of application by applying various business logics into stored procedures, functions, and other SQL objects.
• Created new user databases, database files, database files groups in SQL Server 2005 via SSMS and T-SQL and monitoring clustering servers.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Responsible for creating the user friendly like drilldown and drill through reports and deploying them based on the requirements using SSRS 2005.
• Worked RAID Levels to increase the redundancy of the data
• Upgraded SQL Server 2000 Enterprise Edition to SQL Server 2005 Enterprise Edition.
• Maintaining existing SQL Server 2000 installations and new SQL Server 2005 installations.
• Granted, updated and revoked privileges to database users on database objects in SQL Server
• Created and managed Crystal reports.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Used ProClarity for the integration SQL Server Analysis Services (SSAS).
• Enforced referential integrity via creation of constraints on database objects.
• Populated user databases in SQL Server 2000 via DTS utility.
• Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases like CAMIS mainframe database.
• Configured database backups via Full, Differential and Transactional Log database backup in Maintenance Plan both in MS SQL 2000 and 2005.
• Automated the tools for moving files between cross domains using active batch scripts
• Scheduled backups configured database mail profiles for sending automatic mails to respective users upon failure of a database task.
• Configured and worked on log shipping, database snapshots and database mirroring.
• Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003.
Confidential,Newport Beach, CA Nov’04-Feb’ 06
MS SQL Server Developer
Pacific Investment Management Co LLC (PIMCO) is a privately owned investment manager with approximately $642 billion in assets under management. The firm provides its services to high net worth individuals, banking or thrift institutions, investment companies, pension and profit sharing plans, pooled investment vehicles, charitable organizations, corporations, state or municipal government entities, foreign clients, and pooled vehicles.
Responsibilities:

• Worked as a developer on Databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the Database using Erwin.
• Planed, defined and designed Data flow processes for Data migration to the Data Warehouse using DTS.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of Database objects and server to ensure efficient Data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.
Confidential,Chicago, IL May’ 04-Nov’ 04
SQL Server DBA
GE Healthcare brings practice management software, Electronic Medical Records solutions, E-Commerce services, an Internet portfolio of services, and business transaction capabilities to their customers like Healthcare Systems providers. Project centric physician office which included combining two separate applications EMR and practice management, running on different DBMS into one common back-end database. Systems\'enterprise-wide electronic health record solutionwith integrated, physician support-driven computerized physician order entry (CPOE) thatworks the way clinicians work—allowing them to save time, manage information and improve patient care.
Responsibilities:

• Involved in writing views, cursors and triggers.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Generated reports that could handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing Crystal Reports.
• Monitored and Scheduled Jobs
• Created DTS Package to transfer data from the Oracle source database.
• Responsible for maintaining the accuracy and quality of the data.
• Scheduled the ETL process using jobs. Created Alerts to notify the status of the process. As a Production support person, monitored daily ETL process and fixed the data issues.
• Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2000, Asp.Net and Hyperion Essbase BI tool.
• Reduced the overall ETL time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Created backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases.
• Used QNXT concepts to improve the rate of return and decrease the costs.
• Gathered functional requirements and complete program and system documentation
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Generated different reports using MS SQL Reporting Services.
• Monitoring the event logs and server error logs for troubleshooting.
• Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.
• Design and implementation of stored procedures and triggers for automating tasks.
• Work with end users to define, implement, and maintain their reporting requirements.

Environment: MS Windows 2000 Data Center ,MS Windows 2003 Enterprise Server, SQL Diagrams, Erwin, MS Access, MS Excel, HTML, HP ProLiant DL380 G4, , Dell Poweredge Servers.

Confidential,Delhi, India Mar’02- Apr’04
MS SQL Server Developer/DBA

Hero Honda Motors Limited, based in Delhi, India, is the world\'s third largest manufacturer of motorcycles after Honda and Yamaha. It has been the world\'s biggest manufacturer of 2-wheeled motorized vehicles since 2001, when it produced 1.3 million motorbikes in a single year. Hero Honda values its relationship with customers. Its unique CRM initiative, Hero Honda Passport Program, one of the largest programs of this kind in the world, has over 3 million members on its roster. The program has not only helped Hero Honda understand its customers and deliver value at different price points, but has also created a loyal community of brand ambassadors.
Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MSOLAP Services.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQL Server 2000, MS Windows 2000 Data Center ,MS Windows 2003 Enterprise Server, SQL Diagrams, Erwin, MS Access, MS Excel, HTML.