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 AssistantResponsibilities:
- 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.