SQL DEVELOPER Resume Drexel Hill, PA - Hire IT People

SUMMARY

Creative SQL Server Developer with two years of experience in analysis, design, coding, implementation, and support is looking for a challenging position as SQL Server developer that will allow my current technical skills evolve in a direction that would actively support the success of a company.
A dedicated learner in evaluating and applying new technologies in order to enhance content and functionality as well as a valuable contributor to a team.
Experience in designing and creating database, tables, views, stored procedures, functions and triggers.
Database modeling concepts and normalizing data by using techniques for keeping its integrity and fast data retrieval purposes.
Experience in T - SQL Querying, table joins and sub queries, using user defined functions.
Create, modify and maintain indexes to boost system performance.
Experience in importing and exporting data from data-sources such as Excel and delimited flat files.
Experience in creation SSIS packages for data manipulation and transformation purposes.
Experience in creation SSRS Reports.
Experience in restoring, recovering and backing up database.
Performance Tuning and Query Optimization by analyzing query execution plan.
Use SQL Server profiler to trace troubled queries.
Knowledge in table partitioning and data compression.
Passion for technology and a competitive, results-focused nature.
Detail oriented with the ability to multi-task projects.

PROFESSIONAL EXPERIENCE

SQL DEVELOPER

Confidential - Drexel Hill, PA

Responsibilities:

Designed and created the new database for the business, connecting tables using PK,FK and other constraints for data integrity purposes (normalized to the 3NF).
Accurately located indexes on tables in care of system performance.
Created number of user defined functions that can be call in stored procedures as well as views and triggers defined by business rules.
Designed SSISPackagesto transfer data from/to flat files to SQL Server using Business Intelligence Development Studio.
Used SSIS transformations such asLookup, Derived column, Data conversion, Conditional split, SQL task, Script task etc.
Improved performance of SQL server queries by analyzing execution plan and optimizing queries, rebuilding and reorganizing the indexes, updating statistics.
Performed database backup, restore &routine maintenance.
Designed and developed stored procedures, queries and views necessary to support SSRS reports.
Createdparameterized reports, Drill downandDrill throughreports using SSRS.