Senior VB.NET Developer/SQL Server Architect

Richard Coker
Satsuma, Al  36572
(251) 377-3157 - [Send email using form at bottom]

Experience

Independent Consultant - 2009
Various Clients

Project: Conde Systems, Inc. – .NET Application
Developed application for a technology developer and distributor of color
printers and supplies worldwide. The application allowed users to install printer
drivers without any technical “know-how”. The application, using a wizard type
interface to automatically download the appropriate printer driver from Conde
Systems website, made all necessary custom settings needed. The application
relieved technical support from having to manually walk customers through
technical steps of driver configuration.

• Microsoft Visual Basic.NET 2005

Project: G.A. West & Company, Inc. – SQL Server driven .NET App/Intranet Site
Developed application for a large general contractor to manage equipment
rentals. The system allowed superintendents the ability to request equipment via
Intranet site, request were then managed at corporate office using .NET desktop
application. Application allowed management to track equipment usage per job site
and minimize unnecessary rental expenses.

• Microsoft Visual Basic.NET 2005, Microsoft SQL Server 2000, ASP.NET,
Transact-SQL, HTML, CS, IIS Server 6.0

Senior Developer - Feb. 2008 – June 2009
Evonik Industries (Chemical Plant – Engineering Services)

Migrated existing COM components from Microsoft Visual Basic 6.0 to Microsoft
VB.NET 2008. Developed schema management tools for Oracle database servers using
Microsoft VB.NET. Developed XML mapping between Smart Plant P&ID to Smart Plant
Foundation to Smart Plant 3D. Developed custom dash board applications for DCS
plant controls using Microsoft VB.NET 2008, Microsoft SQL Server 2005, and
reports using Microsoft SQL Server Reporting services. Supported end users of
Smart Plant P&ID systems with custom components.

• Microsoft Visual Basic.NET 2008, Microsoft SQL Server 2005, Oracle 11g,
Intergraph Smart Plant P&ID, Intergraph Smart Plant Foundation, Intergraph Smart
Plant 3D

Independent Consultant - 2003 – 2008
Various Clients

Project: Konica Minolta - Online Ecommerce website
Working with SAP consultants, used Microsoft .NET SAP Connector to build ASP.NET
website integrated with SAP. Website features were browsing catalog of printers,
shopping cart, and ordering processing with SAP as the back end. Developed a
VB.NET catalog manager application which was primarily used to add/remove/modify
products displayed on the website and validate them against SAP. Catalog was also
used to store product pricing from SAP as well as allow marketing personnel to
enter copyright text for each product.

• Microsoft Visual Basic.NET 2003, Microsoft SQL Server 2000, SAP R3, ASP.NET,
Transact-SQL, HTML, CSS, IIS Server 6.0

Project: Konica Minolta – Barcode Scanning mobile application
Developed Windows Mobile VB.NET application used on Symbol handheld scanners to
scan product serial numbers and update SAP sales orders. Application evolved into
full product picking application to allow warehouse personnel to scan sales
orders and be directed to warehouse locations for each product and confirm
quantity picked. Scanners communicated with xml web services over wireless
networks, web services then communicated with SAP via .NET connector. BAPI calls
were also used to valid user credentials against actual SAP user accounts. This
allowed management to measure productivity of warehouse personnel since each SAP
user account was noted on each sales order.

• Microsoft Visual Basic.NET 2003, Microsoft Windows .NET Compact Framework,
Microsoft SQL Server 2000, SAP R3, ASP.NET, Transact-SQL, XML, IIS Server 6.0

Project: American Financial Resources – Mortgage Leads management applications
Developed Microsoft Visual Basic 6 application to import mortgage leads from
multiple formats into a Microsoft SQL Server database and allow loan officers to
select leads based on various criteria. Leads were then exported to a Pitney
Bowes mailing system for mass postage and postal code sorting. Stored procedures
were used to build routines for processing leads to format the leads coming from
multiple sources to one common format.

• Microsoft Visual Basic 6, Microsoft SQL Server 2000, Transact-SQL, HTML, CSS

Project: American Financial Resources – Mortgage application ASP.NET website
Developed ASP.NET website to accept mortgage applications and allow customers to
pick from various loan types and mortgage rates which were updated daily. Each
website visitor could select the state they were located in and pick from various
types of mortgages, enter their loan amount, and select from different rates and
points to determine the actual loan cost. Once visitors submitted their
application it was automatically entered into the leads database and a mortgage
application was created in Calyx Point (loan origination software).

• Microsoft Visual Basic .NET 2003, Microsoft SQL Server 2000, Transact-SQL,
HTML

Project: SyncSite – Sales Logix integration for Raymond James
Created a Windows service in Microsoft VB.NET to monitor a Microsoft Message
Queue and update records in Sales Logix, updating involved use of SAP .NET
connector to make BAPI call to SAP.

• Microsoft Visual Basic .NET 2003, SAP R3, Microsoft SAP .NET Connector

Project: SyncSite – Sales Logix integration project for Medquist
Created a Windows service in Microsoft VB.NET to monitor Sales Logix for sales
opportunities and create quotes in SAP via use of SAP .NET connector making BAPI
calls.

• Microsoft Visual Basic .NET 2003, SAP R3, Microsoft SAP .NET Connector

Project: Konica Minolta – Parago XML Web service
Created an ASP.NET xml web service to allow 3rd party vendor to verify valid
serial numbers of printers used in the retail customer rebate program. 

• Microsoft Visual Basic .NET 2003, XML, Microsoft IIS 6.0

Project: Mitsubishi Polysilicon – Windows Service
Created a Windows service to monitor folders containing scanned invoices and
purchase orders. Service then retrieved document details from SAP and updated a
document management system (Documentum). Strongly typed datasets in VB.NET were
used in conjunction with T-SQL stored procedures to communicate with SQL Server.

• Microsoft Visual Basic .NET 2003, Microsoft SQL Server, Transact-SQL, SAP R3,
Microsoft SAP .NET Connector

Developer - 2001 – 2003
National Accounts (Long Distance Reseller)

Developed custom database applications and integrated websites for
telecommunications provider. Created classic asp web sites for customer
acquisition and backup account support. Design and implemented databases to
process long distance call logs and create monthly billing statements using
Microsoft SQL Server 2000 with extensive using of stored procedures. Developed
rich HTML email advertising campaigns. Developed database and website tools for
managing affiliates. Developed object models using COM in Microsoft Visual Basic
6.0 for use in websites and custom applications. Custom COM objects were used
with Microsoft IIS Server using COM+. Created custom IVR applications using
Pronexus VB Voice SDK.

• Microsoft Visual Basic 6, Microsoft SQL Server, Transact-SQL, MS Access, ASP,
Pronexus VB Voice

Developer/CAD Support - 1999 – 2000
Degussa Chemical (Engineering Group)

Developed custom software components for use with Intergraph Smart Plant P&ID,
using COM in Microsoft Visual Basic 6.0. Components developed required use of
Microsoft SQL Server 7.0. Supported end users of Smart Plant P&ID systems with
custom components. Developed several miscellaneous database applications for
chemical engineers to include pipe/valve specifications database.

• Intergraph Smart Plant P&ID, Visual Basic 6, SQL Server 2000, Transact SQL

President - 1997 – 1999
Net Solutions Group, Inc. (Network Management/Custom Software Development)

Employed a team of programmers and network technicians to provide service and
support to clients. Designed, installed, supported LAN/WAN solutions using
Microsoft Windows Servers. Implemented WAN TCP/IP networks with leased frame
relay and ATM circuits. Configured CSU/DSU devices and Cisco routers. Managed
team of developers building applications and websites using Microsoft Visual
Basic 6.0, Microsoft Visual Interdev (Classic ASP), Microsoft SQL Server and
Microsoft Access. 

• Microsoft Visual Basic 6, Microsoft SQL Server 7.0, Transact SQL, Microsoft
Access, Microsoft Interdev Classic ASP, HTML

IT Support/Programmer - 1995 – 1997
Ideal Technical Services (Contract Staffing Company)

Supported and integrated Lotus Notes databases for client/resume management
application. Supported 50 user Novell network, which was later migrated to
Windows NT 4.0. Utilized Citrix WinFrame 3.51 to deploy applications to remote
locations. Designed and implement WAN TCP/IP network between parent and branch
offices using frame relay circuits to include the Internet. Supported
applications for PC platforms to include MS DOS, Windows 95, and Lotus Notes.

• Microsoft Access, Lotus Notes, Microsoft Interdev Classic ASP, HTML

Developer/IT Backup Support - 1994 – 1995
Brown & Root (Piping Engineering Firm)

Developed custom Microsoft Access database applications. Supported network and
CAD users on 250 user Novell Network. Setup workstations, installed hardware &
software. Systems supported included AutoCAD, Intergraph Microstation, MS DOS,
Windows 3.1, Windows 95, MS-Mail, Unix servers.

• Microsoft Access, AutoCAD, Intergraph Microstation

Database Developer - 1993 – 1994
Rohr Aero Services (Aircraft Repair Services)

Developed custom database applications using FoxPro 2.6. Supported network users
on 50 user Novell Network.

• FoxPro 2.6, Visual FoxPro, Microsoft Access


Database Developer/Backup Network Support - 1991 – 1993
David Volkert & Associates (Civil Engineering Firm)

Developed custom database application (FoxPro 2.5) for back office management of
company 401k retirement plan. Application allowed accounting personnel to manage
contributions from employee payroll, process company matching, and maintain
employee balances. Developed multiple small database applications in FoxPro 2.5
for PC platforms on MS DOS and Windows 3.1. Backup network admin for Novell
network supporting 100 users. Supported CAD users on Novell Network, and
Intergraph UNIX Network. Software supported and used included Intergraph
Microstation, Lotus 123, WordPerfect, VAX/VMS backups and software upgrades.
Procured and installed new hardware and software purchases.

• FoxPro 2.5, Intergraph Microstation, Lotus 123