We provide IT Staff Augmentation Services!

Sql Server Database Developer Resume

4.00/5 (Submit Your Rating)

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.

We'd love your feedback!