We provide IT Staff Augmentation Services!

Sql Developer Resume

Charlotte, Nc

SUMMARY

I have a total of 14 years experience in many areas of IT services. Recently, I have worked extensively with SQL Server, T - SQL, SSIS development, some C#.NET to produce decision data and financial data.development for console applications In addition, I have experience with many programming platforms as indicated by job requirements.

  • MS SQL Server 7.0 Programming
  • MS SQL Server 2000 Programming
  • MS SQL Server 2008 R2 Programming
  • MS SQL Server DTS Programming
  • MS SQL Server SSIS Programming
  • HTML Programming
  • ASP 2.0 Programming
  • ASP.NET Programming
  • ADO Development
  • VBScript 2.0 Programming
  • Microsoft VBA Programming
  • VB 6.0 Programming
  • C#.NET Programming

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC 

 SQL Developer

Responsibilities:

  • T-SQL programming on SQL Server 2008
  • SSIS programming for large pharmaceutical warehouse corporation
  • C# console development
  • Technical documentation
  • Testing and working with ITO and UAT testers

Confidential, Charlotte, NC 

 SQL Developer

Responsibilities:

  • T-SQL programming on SQL Server 2008
  • Crystal report enhancements
  • Technical documentation
  • Project documentation

Confidential, Charlotte, NC  

 SQL Developer

Responsibilities:

  • T-SQL programming on SQL Server 2008
  • Managed security audit for dev, testing, user testing and prod servers
  • Maintained, optimized and created development objects:
  • triggers
  • stored procedures
  • views
  • Managed code for existing applications

Confidential, Charlotte, NC 

 SQL Developer

Responsibilities:

  • T-SQL programming on SQL Server 2005
  • Managed security audit for dev, testing, user testing and prod servers
  • Maintained, optimized and created development objects:
  • triggers
  • stored procedures
  • views
  • Authored standards document for SQL naming conventions
  • Managed code for existing applications

Confidential, Spartanburg, SC

 SQL Database Administrator / Developer

Responsibilities:

  • T-SQL programming on SQL Server 2008 R2 Enterprise for fast growing company
  • up to 16 servers
  • Managed security for 12+ SQL servers creating proxies, credentials and logins
  • Maintained, optimized and created development objects:
  • Triggers
  • Stored procedures
  • Views
  • SQL server profile traces for troubleshooting and optimization
  • Setup db-mail accounts and profiles
  • Created detailed SSIS packages for use in daily ETL processes
  • Created and scheduled jobs, created maintenance plans, linked servers
  • Stored procedure management and creation and documentation
  • Program SSIS package to backup servers for test environments
  • Program SSIS package to feed data to an Electronic car title program
  • Program SSIS package to fetch and provide data for the pay by phone and online pay
  • Writing complex T-Sql queries for SSRS reporting team
  • Data Mapping from many platforms to MS SQL server
  • Manage and improve index performance
  • Create and maintain many backup solutions via RedGate and T-Sql
  • Performance monitoring and query optimization
  • Disk management
  • Database compression
  • Restore databases from nightly backups to reporting servers using T-Sql and SSIS
  • Made recommendations concerning disk space and memory configuration

Confidential,  Spartanburg, SC

SQL / Applications Developer

Responsibilities:

  • T-SQL programming for large financial software package
  • SQL Index optimization
  • SQL Profiler to identify and correct data and other issues
  • Stored procedure management, creation, refactoring and documentation
  • Program SQL solutions for Crystal Reports XI for Accounts Payable and Accounts Receivable
  • Extensive work with SQL 2000
  • Excel VBA Programming
  • VB.NET programming to move data applications from MS Access platform to .NET
  • Extensive work with Epicor Accounting software
  • Maintain and audit company procurement portal, eProcurement
  • Excel programming

Confidential, Charlotte, NC

 SQL Data Analytics Developer

Responsibilities:

  • T-SQL programming for large client
  • Stored procedure management and creation and documentation
  • Program sql reports per client account request for marketing information concerning large agricultural firm
  • Extensive work with SQL 2000 and export to Excel for delivery to client
  • Excel VBA Programming
  • Microsoft Maps
  • Excel programming
  • PowerPoint VB programming

Confidential, Greer, SC

 Applications Developer II

Responsibilities:

  • Maintain and develop sql DTS solutions to format and report data imported from all 350 stores in company
  • All store day to day transactional data
  • Import scheduling data to report in-store manager schedules
  • Develop and maintain DTS used to gather and format data to report all store financial information to deliver via hard copy and CD format
  • Maintain and develop all intranet reporting and applications for all stores, District Managers, Regional Managers
  • Maintain grid system intended to monitor each unit’s sales, profit, food cost and payroll expenditure
  • Create and maintain a set of calendars utilized by Regional and District managers to display store visit schedules and areas of focus using SQL Server stored procedures and triggers and VBScript and classic ASP
  • Create and maintain all maintenance technician information and provide a manner for each technician to access maintenance work lists for individual stores using ASP, VBScript and T-SQL programming and SQL stored procedures to gather data
  • Maintain web portal used to access Corporate information schedule meeting rooms search employee information and post corporate announcements and access operational data

Hire Now