Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Dayton, OH
Salary:
92K yr
Posted:
October 23, 2017

Contact this candidate

Resume:

James R Tracy II

*** ********** ***,

Englewood, Oh 45322 Cell:937-***-****

ac2wra@r.postjobfree.com

Summary

Software Engineer offering 27 years in the IT industry with a focus on product design and development. Highly dependable and enthusiastic team player dedicated to streamlining processes and efficiently resolving project issues.

Highlights

VB 6.0

SQL 2000

VB.net

SQL 2005

C/C++/C#

SQL 2008/2014

Fortran

MS Access

Cobol

● Oracle 9i to 10g

LinQ

Terradata

ASP.net

Open VMS

Assembler

Unix

HTML/CSS

Windows

VB Script

MS Office suite

Java Script/Ajax

Visual Studio 2013

Crystal Reports

● SQL Server Management Studio

● Visual Source Safe/TFS

Experience

Sr Software Engineer Jun 2017 to Oct 2017

Greentree inc. – Beavercreek, Oh

Integrate, design and develop Web apps using ASP, HTML, CSS, Java Script and Ajax.

Modify web pages in Content Server using various software tools and languages.

Responsible for upkeep and revisions of assigned software applications.

Develop, test and debug database triggers, views and stored procedures in an Oracle database.

Update, modify and expand existing software modules as required.

Responsible for implementing and testing change requests to Products.

Create routines for data validation and error handling for all software modul.es

Sr Software Engineer Oct 2014 to May 2017

Flairsoft, Inc – Fairborn, Oh

Integrate, design and develop Web apps using ASP, HTML, CSS, Java Script and C#.net.

Modify web pages using visual studio web forms.

Responsible for upkeep and revisions of 5 software applications.

C#.net with Visual Studio 2013, is used for all software development and maintenance

Develop, test and debug database triggers, views and stored procedures in SQL 2014 Server.

Update, modify and expand existing software modules as required.

Responsible for implementing and testing change requests to Products.

Use Try/Catch routines for data validation and error handling routines for all software modules

Sr Software Engineer Jul 2014 to Sep 2014

UNICON International Inc.

Debugged and modernized old VB 6 coded applications to make them VB.net compliant

Supported debugging and enhancement to Excel spreadsheet VBA code and macros

Created and maintained programs using win forms

VB.net with Visual Studio 2010 was used for all new software development and maintenance

Visual Studio VB 6.0 was used to support and enhance old code still in use

Developed, tested and debugged stored procedures using SQL Server 2008 R2

Responsible for implementing and testing enhancement requests to Products

Used Error handling routines for data validation on all software modules

Sr Software Engineer Oct 2013 to Jun 2014

CSCI Consulting, Inc – Indianapolis, In

Integrated, designed and developed Web applications using ASP, HTML, VB.net

Created web pages using visual studio web forms

Created and maintained programs using win forms

Accountable for upkeep and revisions of over 2 dozen software applications

VB.net with Visual Studio 2010, was used for all software development and maintenance

Developed, tested and debugged database triggers and stored procedures using SQL Server 2008 R2 and 2010

Updated, modified and expanded existing software modules as required.

Responsible for implementing and testing enhancement requests to Products.

Used Try/Catch routines for data validation and error handling routines for all software modules

Sr Software Engineer Jun 2013 to Sep 2013

Value Added Solutions, Inc – Piketon, Oh

Responsible for maintenance and update of multiple software programs

Designed and developed Web applications using ASP, HTML, LinQ and Java Script.

Used C# with Visual Studio 2010 for software development and maintenance

Developed, tested and debugged database triggers and stored procedures using SQL

Updated, modified and expanded existing software modules as required.

Responsible for Implementing and testing enhancement requests to products.

Created data validation and error handling routines for all software modules

Sr Software Engineer June 2007 to January 2013

ThomsonReuters – Beavercreek, Oh

Responsible for maintenance and update of software with over 1.5 million lines of code.

Used VB.net with Visual Studio for software development and maintenance.

Responsible for collecting customer requirements and for implementation into the current software design.

Updated all requirement, design and test documentation as needed.

Updated, modified and expanded existing software modules as required by customer change requests. Designed and developed software modules to facilitate the routing of data between systems.

Designed and developed the Graphical User Interface (GUI) required for multiple software modules.

Created data import and export functions that allow the programs to input data from various source files. Created the data validation and error handling routines for multiple software modules.

Implemented and tested enhancement requests to product functionality.

Resolved customer issues by establishing workarounds and code solutions. Successfully migrated from SQL Server 2000 to SQL 2005 and then to SQL 2008.

Developed, tested and debugged database triggers and stored procedures using SQL and PL/SQL.

Maintained, debugged and updated DTS packages in SQL Server.

Resolved customer data issues by locating corrupt data using SQL and PL/SQL.

Corrected bad or corrupt data using live data transactions.

Accomplished the database backups and recovery to restore databases as needed.

Software Engineer Septemberl 2001 to June 2007

Logtec – Fairborn, Oh

Produced documents according to AFI/AFR standards to include requirements, design and test.

Successfully migrated from SQL Server 2000 to Oracle 9i DBMS using Oracle workbench migration tool. Responsible for the Oracle PL/SQL Development.

Developed, tested and debugged Database procedures and triggers.

Provided database access and recovery to ensure minimal down time for customers.

Designed and developed software programs to facilitate the routing of data between USAF customers throughout the US, utilizing VB 6.0 with planned migration to VB.net.

Designed and developed the Graphical User Ingerface (GUI) required for multiple applications.

Created the data import/export functions that allow the programs to transfer data from one system to another.

Wrote the data validation and error handling routines to help ensure data integrity.

Corrected bad, corrupt data and added missing data to the databases.

Wrote generic helper routines that were used throughout the application. Accomplished all integration and testing of the system.

Software Programmer October 1998 to August 2001

US Air Force Weather Agency – Offutt AFB, Ne

Team Leader for developing and maintaining software to manage and interact with the world's largest real-time meteorological database.

Provided database access and recovery to ensure uninterrupted environmental support to the Department of Defense (DOD).

Designed and developed a software program, using VB 6.0 to facilitate the routing of real-time weather data between stations around the world.

Designed and developed the GUI required for the application.

Created the data import and export to transfer data from one system to another. Created the data validation and error handling routines.

Wrote helper functions used throughout the application.

Education

Bellevue University 1999

Bellevue, Ne, US

BS Management Information Systems

Graduated with a 3.8 GPA.



Contact this candidate