SQL Server Database Developer Resume

SUMMARY:

An Experienced developer with proven success in designing, programming, documenting and delivering solutions in SQL Server 2005, 2008,2008 R2, SSRS, ETL using SSIS, Has a long track record of completing projects on time, on budget, and with attention to detail.
Skilled communicator who can understand user needs.
A problem solver who is able to resolve difficult situations and think clearly under adverse conditions.
Thrives in fast - paced, challenging environments.
Learns new technologies and techniques quickly.

TECHNICAL SKILLS:

Databases: SQL Server 2003, 2005, 2008, 2008 R2, ADO.NET 1.0, 2.0

Reporting Tools: SSRS 2005, 2008, Confidential Reports IX

Development Tools: Visual Studio, 2005, 2008, 2010, Team Foundation Server, SharePoint

Application Areas: G/L, A/R, A/P, HR, Invoice and Statements, Order Entry and FulfillmentData Entry and Insurance Management / Accounting and CRM

Microsoft Office: Word, PowerPoint, Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Developer

Responsibilities:

Analyzed existing stored procedures to improve performance and produce correct results.
Re-wrote stored procedures to improve performance
Analyzed tables to determine, select and delete or archive obsolete records per Confidential record retention policies.
Created queries to delete obsolete Databases and tables
Refactored stored procedures to produce various SSRS reports.

Confidential, Huntersville, NC

SQL Server Database Developer

Responsibilities:

Worked with users to determine obsolete reports
Developed views to allow users (engineering and business staff members) to create and execute specialty queries using Excel
Assisted in creating and publishing database definitions for corporate ERP system (Baan)
Built user documentation in MS One-Note

Confidential, Charlotte, NC

Application Systems Engineer / SQL Server Developer

Responsibilities:

Developed T-SQL Queries to locate and troubleshoot system data issues
Developed Queries for use as input datasets in SSRS 2005 and SSRS 2008 R2
Developed Coding Standards for Stored Procedures and SSRS RDLs
Developed SSIS Packages to extract, transform and load (ETL) data from pre-existing vendor supplied database tables to new tables as part of a system refactoring effort.
Developed SSIS Packages to extract, transform and load (ETL) data fixes to production databases
Developed ad-hoc queries as requested by Business users and QA testing personnel
Extensive use of Profiler to determine what tables are being used by vendor provided canned reports and User Interface
Converted legacy Confidential Reports to SSRS reports

Confidential, Charlotte, NC

Teaching Assistant

Responsibilities:

Using SSIS, extracted, transformed and loaded (ETL) data from various file types and Access databases to SQL Server 2005 and 2008R2 databases
Developed database backup and recovery procedures to insure data continuity.
Improved data security by designing and implementing access control procedures.
Saved programmer time and expense by teaching users to write ad-hoc queries.
Developed custom reports, using SSRS 2005, SSRS 2008R2 and Confidential Reports, per user specification
Developed VB.NET applications to meet specific client needs on time and under budget.
Saved client’s money by designing applications to allow modifications without programmer intervention.

Confidential, Charlotte, NC

Teaching Assistant

Responsibilities:

While enrolled in the Internet Technology program assisted the Microsoft Academy instructor in VB.NET and SQL Server classes.
Delivered class presentations in the instructor’s absence (VB.NET and SQL Server).
Developed, facilitated and graded all lab exercises and examinations.
Assisted fellow students in completing practice exercises.
Provided regular feedback regarding student progress and special areas of interest.