Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Clover, SC
Posted:
January 21, 2024

Contact this candidate

Resume:

THOMAS M. GRIFFIN IV

**** ***** **** **

Lake Wylie, South Carolina 29710

Home: 803-***-****

Cell: 980-***-****

ad2yx9@r.postjobfree.com

SUMMARY

An accomplished analytical electrical and software engineer with proficiency in developing creative, inventive and innovative solutions. Possesses technical expertise in troubleshooting and problem resolution. Investigates and evaluates technical difficulties by examining situations and implementing precise solutions.

TECHNICAL SUMMARY

Frameworks: Microsoft .NET Frameworks 6.0, 5.0, Core 3.1, 4.5, 4.0, 3.5, 3.0, 2.0, 1.1

Subsystems: Windows Forms (Winforms), Windows Presentation Foundation (WPF) and Silverlight using MVVM, Windows Communication Foundation (WCF), ASP.NET, ADO.NET, Angular, Aurelia, Durandal, Vue.JS, Node.js

Languages: C#, VB.NET, VB6, T-SQL, PL/SQL, XML, XAML, HTML5, CSS3, JavaScript, JSON, C/C++, BrightScript, Assembly Language, Ladder Logic, LINQ

Libraries: Enterprise Library 5.0, Prism 4.0, Unity 2.0 and 1.1, Entity Framework 4.1, MVVM Foundation Library, DevExpress and Telerik Control Libraries, jQuery, Kendo UI, Node.js, Express, Puppeteer, SocketIO, Nest

Databases: SQL Server 2019, 2016, 2012, 2008, 2005, Oracle 10

Software: Visual Studio 2022, 2019, 2017, 2015, 2013, 2012, 2010, 2008, 2005, 2003, Visual Studio Code, Visual Studio 6.0, Sublime Text, Team Foundation Server, Visual Source Safe, Git/GitHub, CVS, SQL Server Management Studio, SQL Server Reporting Services, IIS, RoundhousE, PM2, NPM

OS: Windows 10, Windows 8, Windows 7, Windows Vista, Windows XP Professional, Windows 2000 Professional

PCB Tools: Protel and OrCAD Schematic Capture and PCB Layout, SPECCTRA Auto-router

EXPERIENCE

BRIDGE TERMINAL TRANSPORT, Charlotte, North Carolina

XPO LOGISTICS, Charlotte, North Carolina

STG LOGISTICS, Charlotte, North Carolina

2013 to 2023 Senior Software Engineer/Lead Software Engineer

Worked for the same company for 10 years. The company was sold 3 times and changed names twice.

Used multiple Visual Studio versions for development and debugging for .NET using C#.NET.

Designed and developed the external company website www.bttinc.com using HTML5, CSS3, and JavaScript as well as Kendo UI and jQuery libraries. Developed backend REST web services using Web API to communicate with the SQL Server database. Data was passed between the website and web services using JSON files.

Designed and developed a content management system (CMS) to house the data for the company websites. Created an internal website to view and maintain this data which was designed as a single page application (SPA) using the Durandal framework.

Configured IIS to host the external facing websites. Using OpenSSL, created RSA keys and certificate signing request (CSR) files to be signed by the certificate authority. Installed the signed server certificates into IIS to secure websites using SSL. Used URL Rewrite to serve subfolders to different subdomains as well as reroute HTTP traffic to the secured HTTPS site.

Updated an existing internal website using ASP.NET, C#, and Telerik controls. This website was used by the collections department.

Developed several .Net processes and Windows services using C# that were used for integration between different systems and databases.

Implemented Elasticsearch index for fast text searching. Created SQL server database triggers to keep index up to date when specific tables and fields were updated.

Architected and developed general purpose screen-scraping WCF service for retrieving data from various websites. A WebAPI wrapper service was created to simplify use from JavaScript. The scraping configurations were stored in SQL server database tables.

Developed Node WebAPI service using Puppeteer library to launch a Chrome browser instance for the scraping of dynamic websites.

Created several .Net console applications that used the screen-scraping WCF service to scrape multiple Railroad, Port, and billing websites.

Developed Node WebAPI services for database CRUD functions using Express. Used TDS library for connection to SQL servers.

Developed .Net Core (and later .Net 6.0) WebAPI service as a replacement for the screen-scraping WCF service.

Created Load Board website to display data from Elasticsearch. Node WebAPI service was used to fetch and update data. SocketIO was used to update multiple clients in near real-time when data was updated.

Used Process Manager 2 (PM2) to launch and monitor Node services

Created .Net Roundhouse project for SQL Server deployments. This also allowed script and Stored Procedure version control with GitHub.

MUZAK, Charlotte, North Carolina

2012 to 2013 Silverlight Software Developer

Used Visual Studio 2010 for development and debugging for .NET Framework 4.0 using C#.NET as well as BrightScript.

Although hired as a Silverlight developer, took over the embedded software development for a BrightSign player used in a Digital Signage System when another team member left. The existing embedded code was incomplete and several new features needed to be added before the initial release.

The embedded software was developed using BrightScript. The player received content from a Server based management system. The player was designed to play content on a single screen with multiple zones. The player polled for new content and commands using several REST based services. The new content was downloaded in the background without interrupting the playback of the current playlist. Also, status and proof-of-play data was sent back to the server using REST services as well.

Participated in the development and testing of the Silverlight 4 content management system that was written in C# and XAML. The content was stored using a SQL Server 2008 backend using WCF Services. The Server would publish playlists for the player as well as display the status and proof-of-play data. The Silverlight application was hosted using IIS 7.

WELLS FARGO, Charlotte, North Carolina

2011 to 2012 Software Developer 6

Used Visual Studio 2008 for development and debugging for .NET Framework 2.0 and 3.5 using C#.NET.

Developed a Windows application using C#.NET to convert documents from an older FileNet System to a newer FileNet system. Application was used to successfully convert over 300,000 documents.

Developed a WPF application using MVVM for automatic uploading of scanned documents to FileNet. This application used Prism and Unity libraries for IOC dependency injection, service location, and event aggregation. Configuration of the Unity container using an XML file allowed testing using mock objects and flexible logging using log4net (console, files, and databases) without recompiling. This application allowed the definition of multiple agents to be configured for different document types. Data Access Layer (DAL) interface was developed to allow connection to different types of databases (SQL Server, Oracle, MySql, and Access).

Took over a large ASP.NET Web-based application for a long running project with a large customer. Worked on fixing existing defects from the initial release as well as implementing new features for the second release.

ADVANTAGE SOFTWARE, Mooresville, North Carolina

2011 to 2011 Senior Software Engineer

Developed several Multi-threaded Windows Services using VB.NET.

Utilized Visual Studio 2010 for development and debugging for .NET Framework 4.0. Used ADO.NET and the Entity Framework 4.1 for database connections.

The Windows Services were used for reporting and notification from a SQL Server 2008 database used for Advertising Agency Management. These reports and notifications were designed to run both recurrently and on-demand.

The notifications were designed to be sent in both Text format and HTML. The HTML messages were required so that the notifications could be sent via E-Mail. These HTML messages were tested to be compliant with several different browsers including Microsoft Internet Explorer, Mozilla Firefox, and Google Chrome.

LINQ and PLINQ were used throughout for queries and data manipulation.

A single Winforms GUI application was developed for configuration, status, and synchronization of the multiple different Windows Services.

INTEGRATED HEALTHCARE SOLUTIONS, Fort Mill, South Carolina

2010 to 2011 Senior Software Engineer

Developed Windows applications and services using C#.NET and VB.NET. These applications were primarily designed to interface with SQL Server 2008 and HL7 messages.

Utilized Visual Studio 2010 for development and debugging of applications for .NET Framework, 3.5 and 4.0. Used Enterprise Library for database connections.

Developed a Windows Service using C#.NET to provide data transport for to/from an SQL Server 2008 database using several different transport mechanisms including Web-Service, SFTP, and file drop. This service was multi-threaded and supported many transport agents. Also, developed a status and configuration utility for the Windows Service using WPF and MVVM. Used Prism and Unity libraries for IOC dependency injection, service location, and event aggregation. Used named pipes for intra-process communication with the Windows Service. This utility displayed master-detail lists and required multiple Views and View-Models.

Developed another WPF Windows application using C#.NET and MVVM that displayed data from SQL Server 2008 database tables. This application also used Prism and Unity libraries. This application also required multiple Views and View-Models, scalable vector images for toolbar buttons, and Modal dialogs that were displayed from the View Models.

Developed installation packages using Visual Studio Setup Project framework. These installation packages required custom installation procedures and post-process modification of the MSI file. These MSI modifications allow different setup pages to be displayed based on choices made at install time.

Provided support and development for legacy VB6 applications. These applications interfaced between SQL Server databases and HL7 messages.

WELLS FARGO, Charlotte, North Carolina

2010 to 2010 Software Developer 5

Developed Windows applications and services using C#.NET. These applications were primarily designed to interface with SQL Server 2005, Oracle, and FileNet databases.

Utilized Visual Studio 2005 for development and debugging of applications for .NET Framework, 2.0. Used Enterprise Library for database connections.

Developed a Windows application to convert documents from several different SQL Server databases and upload them into a FIleNet database. Because of the large number of files to convert (1 to 2 million), this application was designed to be scalable. Multiple processes and threads run concurrently and in parallel. To avoid collision between the multiple processes, a Windows Service was developed to control access to the database records. This Windows service communicated with the conversion processes over TCP using sockets.

Developed an ASP.NET Web application that served as an Administration tool for a SQL Server 2005 database. This Web application required multiple pages and forward and back redirection.

Developed a Web-service to access data from this same SQL Server 2005 database. This web-service used Active Directory authentication to filter the returned results. It also used an XML file-based authentication method.

OKUMA AMERICA, Charlotte, North Carolina

2006 to 2009 Senior Software Engineer

Developed Windows applications and services using VB.NET and C#.NET. These applications were designed to run on our PC-Based Machine Tool’s control. Our own custom .NET API library allowed communication with the machine’s control system.

Utilized Visual Studio 2008, 2005 and 2003 for development and debugging of applications using Winforms and WPF for .NET Frameworks, 3.5, 3.0, 2.0, and 1.1.

Developed installation packages for many different products using Visual Studio Setup Project framework. Several of these installation packages required custom installation procedures.

Developed an application bridge between our API library and an OPC Server for a customer in Arkansas. Developed a Windows service using a third party OPC Client library. Traveled to the customer site in Arkansas for installation and testing.

Developed data collection service for customer in Romania. Traveled to Europe for installation at customer site in Romania and distributor training in Germany.

Developed application that allowed blind operators to receive audible messages from the machine’s part program.

Developed application for one-touch connection to service and support using Windows Presentation Foundation. This application required the creation of custom WPF control templates.

Reverse engineered a VB.NET application to use VB6. Project requirements specified that installation of .NET Framework on target platform was not possible.

Developed encryption scheme that allowed an application to only be executed from a specific USB Flash device. Application would not run if it was copied to the local Hard Drive.

Designed a proprietary Discovery protocol using TCP and UDP messages that allowed plug and play functionality for machine peripherals.

Produced ISO documentation including functional specifications, MS Project timelines, and unit test plans.

AVOCENT CORPORATION, Concord, North Carolina

2001 to 2006 Senior Software Engineer

Designed and developed embedded software for network devices with Phar-Lap and Linux multi-threaded operating systems.

Implemented network protocols over IP using TCP and UDP sockets.

Researched and implemented data encryption and user authentication using the open source libraries OpenSSL and OpenSSH.

Developed several core functions including circular buffers, linked lists and multi-factor user authentication. These core functions were developed to be portable for use in existing and future functions.

OKUMA AMERICA, Charlotte, North Carolina

1997 to 2001 Electrical Engineer

Developed CNC based control systems for machine tools.

Designed and built the control cabinet and peripheral I/O (sensors and solenoids) for a Vertical Lathe machine.

Created PLC software using ladder logic.

Traveled to home office in Japan to work on the development of the first PC Based control. Designed embedded circuit board using schematic capture and board layout for a Device Net panel interface for the PC-Based Control.

Produced documentation using AutoCAD.

Developed embedded software using C language.

Debugged and tested embedded software using in-circuit emulators.

COMPSEE, Mount Gilead, North Carolina

1990 to 1997 Electrical Engineer

Designed embedded hardware and software for barcode products.

Designed and developed a handheld battery powered data collection device with a three person engineering team.

Developed a compact barcode wedge for barcode data entry.

EDUCATION

CLEMSON UNIVERSITY, Clemson, South Carolina

1989 B.S., Electrical Engineering



Contact this candidate