Resume

Sign in

Software Developer VB, VB.Net, VBA, TSQL, Office Automation

Location:
San Antonio, Texas, United States
Posted:
October 17, 2016

Contact this candidate

Summary:

Currently self-employed as a software developer focusing on short term contracts, software maintenance, Transact-SQL( TSql ) code maintenance, VBA / automation, etc.

Experience with healthcare middleware for Laboratory Information and Reference Lab Systems using HL7 orders and results interfaces. Certification testing of HL7 interfaces for orders and results ( Quest, LabCorp )

Experience with document processing for purposes of legal review and discovery ediscovery. Including extraction and or conversion of common document, data and email formats.

Extensive experience working with Microsoft development technologies. Proficient in the design, development, testing and deployment of large scale desktop applications, robotic business data processing applications and backend components. Experience in development of SOAP/ASP.Net web services.

Currently using Visual Studio, VB.Net, Framework 3.5-4.6 and SQL Server 2005-2008/R2 as primary development tools.

Technologies Used:

VB.NET, C#, Visual Studio

Visual Basic for Applications VBA, VBScript

.NET Framework 1.x-4.6

SQL Server 2000-2008/R2

Microsoft Access

Visual Basic (classic) 1.0-6.x

Oracle 7.x-8.x

COM

XML and related technologies

ASP.Net, ASP

JavaScript

HTML

CSS

Microsoft Office automation objects

Adobe Photoshop CC, LightRoom CC and other imaging software

Certifications:

Microsoft Certified Professional

MCP Developing and Implementing Windows-Based Applications with Microsoft Visual Basic .NET

MCP Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0

MCP Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0

Training:

Training courses in Visual Basic .NET, C# and other languages

Microsoft Access certification training

Filenet Panagon desktop training (image services)

Filenet Panagon capture training (image services)

Host integration middleware (Mitem)

Professional Experience:

12/20115 – Present

Ken White Software Services (owner)

Software development, maintenance

Maintenance of software applications written in Visual Basic DotNet

Creation of HL7 viewer applications for Windows desktop

Development of web scraping utilities

Development of PhotoShop CC automation using Visual Basic

Maintenance of VBA code for MS Office use

TSql query modifications

Technologies: Visual Studio 2010-2015, VB.Net, .NET Framework 3.5-4.6, SQL Server 2005-2008, Python, HL7 2.x orders and results interfaces

8/2014 – 11/2015

ApexHealthware, LLC

Development of laboratory information and Reference Lab applications for healthcare

Modifications/maintenance of LIS and Reference Lab applications

Development of LIS and Reference Lab application components, database scripts and procedures

Maintenance of Web services for third party (single point) LIS/RefLab data integration

Certification and testing of HL7 order and results interfaces for reference labs ( Quest, LabCorp, iKnowMed )

Integration of orders and results HL7 messaging for EMR/EHR applications

Development of data import utilities for test codes and AOE

Development of HL7 viewers and testing utilities

Technologies: Visual Studio 2010, VB.Net, .NET Framework 2.0-4.0, SQL Server 2005-2008, HL7 messaging for orders and results

3/2014 – 8/2014

IBC Bank

Software Development

Updates and modifications to existing internal banking applications written in VB6

Modifications of SSRS based internal reports

Development of SSIS packages for nightly banking data updates

Technologies: Visual Basic 6.0, Visual Studio 2010, VB.Net, .NET Framework 3.5, SQL Server 2008

1/2014 – 3/2014

Friedrich Air Conditioning

Short term contract programming

Updates and modifications to existing VB6 inventory applications

Development of new supplementary inventory applications and reporting components using Visual Studio 2010 framework 3.5

Technologies: Visual Basic 6.0, Visual Studio 2010, VB.Net, .NET Framework 3.5, SQL Server 2000, COM Services, XML

4/10 – 12/2013

Legal Xtranet LLC, dba elumicor, San Antonio, TX

Lead Application Developer

Developed eDiscovery, Legal discovery software used by law firms and corporate legal departments in the United States

Responsible for development, testing, maintenance of litigation support software

Developed document analysis software capable of processing, imaging, storing large collections of business documents up to multi-terabytes for legal review.

Developed software to facilitate attorney review of business documents of all types

Developed software to formally produce document sets for attorney and court use. Including documents used in state litigation, federal litigation, congressional hearings and other legal purposes.

Technologies: Visual Studio 2010, VB.Net, .NET Framework 4.0, SQL Server 2008/R2, COM Services, XML, Citrix, Nuance, and other specialized document processing software toolkits.

11/09 – 3/10

WACHOVIA BANK, San Antonio, TX

FileNet Imaging Consultant - contract

Responsible for maintenance and testing of browser based applications implementing FileNet imaging technology

Technologies: Visual Studio 2003 -2005, ASP.NET, VB.NET, VB 6.0, JavaScript

.NET Framework 1.1- 2.x, SQL Server 2005 and 2008, COM Services, XML

08/07 – 11/09

ETS (Educational Testing Service), San Antonio, TX

Software Consultant - contract

Designed and developed bid proposal data management and reporting application for bidding of standardized testing products.

Designed and developed extensible plug-in based modular framework for desktop applications.

Designed and developed custom reporting plug-ins capable of producing formatted documents to screen, html, and SpreadsheetML

Designed and developed T-SQL stored procedures to support application and reporting functionality

Principle designer of bid proposal software application

Lead software developer for bid proposal software project

Designer and developer of technical and end user documentation for bid proposal software project

Technologies: Visual Studio 2005, VB.NET, C#, .NET Framework 2.x, WinForms, SQL Server 2005 and 2008, COM Services, Windows API Services, XML, Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe, MS VBScript/Scripting objects

03/07 – 08/07

ECCA, LLC, San Antonio, TX

Software Developer

Designed and developed robotic components integrating inbound EDI 810 invoice transactions into the corporate database for updating of accounts payable system.

Designer and developer of technical and end user documentation for EDI project

Technologies: Visual Studio 2005, VB.NET, SQL Server 2000, COM Services, WinForms, Windows API Services, XML, Microsoft Office Applications, Microsoft Visual SourceSafe, MS VBScript/Scripting objects

05/06 – 03/07

ETS (Educational Testing Service), San Antonio, TX

Software Consultant - contract

Designed and developed bid proposal costing and reporting software supporting simultaneous entry of line item costs using direct data entry or spreadsheet template import. The application is used to prepare proposals for primary and secondary level educational testing requirements.

Principle designer of bid proposal software application

Lead software developer for bid proposal software project

Designer and developer of technical end user documentation for bid proposal software project

Technologies: Visual Studio 2003, VB.NET, SQL Server 2000,, WinForms, COM Services, Windows API Services, XML, Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe, MS VBScript/Scripting objects

07/00 – 05/06

SYSTEM 18, LLC, Scottsdale, AZ

Enterprise Software Consultant

Participated in the design, development and deployment of a suite of image enabled workflow applications and autonomous data processing robots for Kraft Foods, and Altria Corporation.

Designed and developed messaging services linking production plants and remote buyers with A/P workflow systems. Services deliver invoice inquiries and scanned A/P documents directly to buyers in the field.

Participated in the design and development of the Kraft business components object model facilitating rapid development of image enabled workflow applications.

Created prototype browser based applications designed to allow corporate buyers to directly access A/P invoice information and document images.

On-site consultant to Kraft Foods and Altria Corp.

Lead software developer for image enabled A/P applications

Technologies: Visual Basic v6.0, Visual Studio 2000-2005, VB.NET v2003-2005, VBScript, JavaScript, ASP.NET 2005, Oracle 7.x-8.x (VB 6 client apps), FileNet Panagon Image Services,

COM, COM+ Services, Windows API Services, Commercial Components (OCX, DLL), XML, MSXML DOM, HTML, Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe, Mitem middleware software for host system integration

01/00 – 07/00

PSYQUEL CORP., San Antonio, TX

Web Applications Developer

Created prototype online insurance billing application for physicians

Application design and development

Technologies: Visual Basic v6.0, VBScript, JavaScript, ASP, SQL Server, COM, COM+ Services, HTML, Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual, SourceSafe, Graphics Editing Tools

07/96 – 01/00

OPTISALES, INC, San Antonio, TX

Owner

Developed and deployed web based payment processing services for E-Business web sites

Created and marketed multimedia training materials for real estate appraisers

Developed and marketed commercial FAX broadcast software

Business owner/mgr

Project manager, lead developer

Technologies: Visual Basic v4.x-6.0, VBScript, JavaScript, ASP, SQL Server, COM, COM+ Services, HTML, Custom Controls (VBX, OCX,DLL) Windows API Services, Microsoft Office Automation, Objects, Microsoft Office Applications, Microsoft Visual SourceSafe, Graphics Editing Tools, Sound Editing Tools, CD Production Tools

11/96 – 01/00

IMAGES CONSULTING GROUP (ICG Consulting), Phoenix, AZ

Enterprise Software Consultant

Developed image enabled A/P workflow applications for Kraft Foods Inc

Developed robotic processing applications to interface host systems with A/P workflow system

Primary on-site consultant to Kraft Foods Shared Services Center, San Antonio, Texas

Designed, developed and maintained image enabled A/P workflow software

Technologies: Visual Basic v4.x-6.0, Oracle 7.x (VB 6 client apps), FileNet Desktop Image Services, COM, COM+ Services, Windows API Services, Commercial Components (VBX, OCX, DLL), Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe, Mitem middleware software for host system integration

08/93 – 07/96

MICROCOMPUTER CONSULTING SERVICES, Dallas, TX

Software Developer

Developed commercial real estate appraisal preparation and reporting software

Developed multi-user sales support and customer database application

Developed high capacity FAX broadcast software for sales support

Lead developer for Windows based appraisal preparation software

Database management and maintenance (dBase)

Technologies: Visual Basic v3.0-4.5, dBase, COM Services, Windows API Services, Commercial Components (VBX, DLL) Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe

05/91 – 08/93

LES GREY AND COMPANY, Garland, TX

Maintained networked PCs

Created bid preparation software

Network administration

Internal tech support

Technologies: Visual Basic, MS Access, Commercial Components (VBX, DLL), Microsoft Office Automation Objects, Microsoft Office Applications, Microsoft Visual SourceSafe

04/89 – 05/91

SELF EMPLOYED, Anaheim, Ca, Dallas TX Metroplex

Software Consultant

Developed software for analysis of California Public Utilities Commission (PUC) regulated tariffs

Created exhibits and technical analyses for California Public Utilities Commission (PUC) tariff hearings

Developed job estimating bid preparation software for commercial construction contractors

Software consulting

Technologies: Microsoft Professional Basic, VBScript, JavaScript, dBase, Commercial Components (VBX, DLL) Microsoft Office Scripting, Microsoft Office Applications, Borland Quattro, Borland TurboBASIC



Contact this candidate