PROFFESIONAL SUMMARY:

• Around 5+of experience in IT having experience in Database Design, Development & Support ofMS SQL Server 2008/2005/2000for Production/development.
• Proficient inRelational Database Management Systems (RDBMS).
• Expertise inTransact-SQL (DDL, DML, DCL)and in Design and Normalization of the database tables.
• Experience in implementing business logic usingTriggers, Indexes, Views and Stored procedures.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Experience with tools like SQL Server management studio and SQL Server 2005/2008 integration (SSIS) and reporting services(SSRS).
• Proficient inTuning T-SQL queriesto improve the database performance and availability.
• Experienced hands inQuery tuning and performance tuning.
• Experience in monitoringSQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Expertise increating Packages using SQL Server Integration Services (SSIS).
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems toSQL server.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Education:

• Bachelors in Computer Science Engineering

Technical Skills:

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, SSRS,SSIS,SSAS RDBMS:MS SQL Server2005/2008, MS Access Programming Languages:C, C++, Java, SQL, T-SQL, PL-SQL Internet Technologies:XML. HTML Productivity Applications:MS Word, Excel, Access Reporting Tools:Crystal Reports 10, 11, SSRS

Professional Experience:

Confidential, Phoenix, AZ Sep 2009 -Present MS SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• Developed User Defined Functions and created Views
• Created Triggers to maintain the Referential Integrity.
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Reviewed existing business procedures and recommended and implemented changes.
• Responsible for setting preferences for various ad-hoc requests and distribution of tasks.
• Trouble shoot problems with the various teams including network related issues
• Creating and automating the regular Jobs
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Reviewed existing business procedures and recommended and implemented changes.
• Responsible for setting preferences for various ad-hoc requests and distribution of tasks.
• Maintained Windows 2003 Server for small business.
• Trouble shoot problems with the sales terminal including network related issues.

Confidential, Hyderabad, IndiaMay06 to Aug 2009 SQL Developer

Handled multiple applications and projects using SQLServer databases. Worked on the Call Center call center application (CMS)system. CMS helps the Delta agent to help the customer to book the flights tickets, as well as it maintains customer profile account, feature bookings, enquires etc.

Responsibilities:

• Gathered requirements from business analyst.
• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provided disaster recovery procedures and policies for backup and recovery of Databases.
• Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
• Created DTS package to schedule the jobs for batch processing.
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Monitored the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Used linked tables, pass through queries and many other access features also wrote code in Visual Basic to perform some complex reporting tasks.

Tools: MS SQL 2005, SSRS, SSAS,SSIS, SQL, MS Access, MS Excel, MS Word.