Sql Server Data
Resume:
Hemanth Reddy Vanuku
( ***** Battleridge Place ( Montgomery Village, MD 20886 ( (301)-947-
0796
*************@*****.***
____________________________________________________________________________
__
Objective
I have put in a lot of time and effort to learn the fundamentals of sound
database development and maintenance practices. I am looking for an
opportunity to put my extensive training in SQL Server database development
to good use. Being fresh out of college, I have not had the opportunity to
prove my skills yet but I would love an opportunity to prove myself in an
interview.
Education
M.S., Software Engineering
Expected March 2011
Stratford University - Falls Church, Virginia
B.S., Biological Sciences
Graduated, June 2009 University of Maryland - College Park,
Maryland
Certifications
National Institute of Information Technologies (NIIT)
September 2009-January 2010
Tirupati, Andhra Pradesh, India
Related Coursework - C-language, SQL Server 2005, and Linux
SQL Server Development Skills:
1. Database Design Skills
. Translated business requirement into entities and the
relationships
. Created Entity Relationship diagrams using Microsoft Visio
. Converted an ERD into logical and physical database
. Familiar with Normalization/Denormalization techniques
. Familiar with various phases of Software Development Life Cycle
(SDLC) including Analysis, Design, Testing, Implementation and
Maintenance
2. T-SQL Development Skills
. Data Definition Language skills
. Created Databases and Tables
. Created Unique, Default, Check, primary key and foreign key
constraints
. Determined and Defined Indices on tables
. Used ALTER commands to change database objects
. Data Manipulation Language Skills
. Used Group By clause to aggregate data
. Experience using Inner Join, Left-Outer Join, Right-Outer
Join, Full-Outer Join, and Cross-Join as needed
. Combined select statements using Union, Union-All, Except,
Intersect
. Used Sub-Queries and Nested Subquery while writing SQL
scripts
. Created Views
. Experience using Local/Global Temporary tables
. Worked with Server-specific/Connection-specific
Global variables
. Experience using Convert/Cast, STR, COALESCE, ISNULL, NEWID functions in SQL queries
. Created Stored Procedures for queries involving join and
union of multiple tables
. Used system stored procedures in queries
. Transactions and Locking
. Begin, Savepoints, Rollback and Commit Transactions
. Setting up Replication
. Snapshot Replication, Transaction Replication, Merge
Replication
. SQL Server Agent
. Created Jobs to create test data in various tables
. Database Back up & Restore
. Worked with hierarchies, used Common Table Expressions
(CTE) to traverse up or down the hierarchies
. Extract Transform Load skills
. Assessed new date, update existing data and deleted data
from the database.
3. Performance Improvement Skills:
. SQL Profiler skills
. Can set up a trace
. Can analyze a trace file to identify slow running
queries using CPU, Reads and Writes
. Identify slow queries within a stored procedure
. Worked with Database Engine Tuning Advisor (DETA) to generate
indexes for queries
. Query Execution Plan reading skills
. Table scans
. Index scans
. Bookmark lookups
. Index seeks
. Used Dynamic Management Views (DMV) to find the missing indexes
in the queries.
Coursework Completed
1. Relational Database Management
. Worked on problems specific to Data Manipulation and Database
Design skills.
. Designed Entity-Relationship diagrams for related tables.
. Expressed queries in SQL, be able to embed SQL queries in a
PL/SQL program.
2. C# / ASP.net Programming
. Accessed Microsoft visual web developer 2008 Express to develop
a webpage that allows the students to be inserted, updated and
deleted.
. Worked with files and data streams
. Developed multi-page web applications
3. Project Management
. Effective organization of projects
. Tracking costs and time expenditures
. Overcoming potential obstacles
References Available Upon Request
Contact this candidate