James P. Johnston, MCSE
2937 Old South Drive, Jonesboro, GA 30236
Home: (678) 545-0177, Cell: (678) 522-5613

Knowledge, Skills, and Abilities

Operating Systems
Windows 2003/XP/2000/NT/Terminal Server/9x/3.x, MS-DOS, UNIX (SCO, Solaris, DG/UX, BSD, Linux), OS/2, AOS/VS
Languages/Technologies
C#/C++/C, Visual Basic .NET/VB6/VBA/VBScript, Delphi/Pascal, COBOL, Assembler, Business Basic, HTML/XHTML/CSS, CGI Scripting (C, PERL, VB), ASP, PHP, Cold Fusion, Java/JavaScript/AJAX, UNIX Shell Scripting (bash, ksh, csh), WSH, WMI, XML
Applications
Microsoft SQL Server 2005/2000, Exchange 2000, Cluster Server, Office 2000, Terminal Server Services (Win2K), Citrix, Backup Exec, Legato, HP OpenView ManageX, Access, MySQL, Nmap, Nessus, Sniffer Pro, LanGuard

Projects and Work Experience

January 2002
to
Present / TechKnow Professional Services, Atlanta, GA
Owner/Sr. Technical Consultant
  • Identify high potential sales opportunities and prioritize them.
  • Build rapport and educate customer with the use of internal and external resources.
  • Articulate TKPS Value by providing advanced technical and/or business consultative services during the pre-sales and/or post-sales cycle.
  • Provide technical or business analytical leadership for specific product groups or business objectives in order to engage the customer or implement and maintain an engagement.
  • Insure high post sales satisfaction that enables repeat business and referrals from customers.

Clients & Recent Projects
2002
to
2007 / Denta-CAD Corporation, Buford, GA
Provide technical & sales support, consulting, and custom programming services.
Entirely recoded their core product and extended its capabilities. (VB, C++, XML, Access)
Developed system for generating PDF format reports. Used within the DentaCAD 2000 Plus product, it allows high quality reports to be generated using PDF templates and emailed. (VB, Delphi, Access)
Wrote multilevel authentication system for web access to DentaCAD system technical and catalog data. (ASP, HTML, Access)
Created a web based system for updating rate information used in the DentaCAD 2000 Plus product to generate quotes for financing. Now the finance companies update their rates using this web application and DentaCAD users get the rate updates faster. (ASP, HTML, Access)
Developed and rolled out RepAlert product. It's used to keep the DentaCAD system and all data for manufacturers, dealers and financial information up to date and accurate. (C#, ASP.NET, VB, Access, SQL Server)
2002
to
2007 / WinesandRecipes.com, Atlanta, GA
Designed & developed website, database, and custom application for collecting, loading, and maintaining information in database. (VB, ASP, HTML, Javascript, Access, XML)
Developed in-store kiosk that should be showing up in stores later this year. (C#, VB, Access)
2002
to
2007 / North American Credit Services, Chattanooga, TN
Developed web based reporting system to be used by their clients to retrieve up to date collection status on their accounts. This system is automated and eliminates the need to send out printed reports to all of their clients at the end of the month. Now they just go to the NACS website.
(VB, ASP, HTML, Javascript, Access)
Developed a relay program to bridge NACS's backend via HTTPS over the internet to the TransUnion Network Access and Equifax application servers. This allows users of their backend scoring system to pull credit information used to qualify customers. (VB)
Wrote web based scoring application that integrates data from NACS databases, TransUnion, Equifax and Accurint. Provides credit score & history, account details, and skip tracing functionality. All NACS customers will be using this application exlusively by the end of October 2004. (VB, ASP, HTML, Javascript, SQL Server, IIS, Access)
Setup SSH server and java web client to allow secured connections to legacy credit scoring system.
2002
to
2007 / Nationwide Publishing Company (ClaimsPage.com), Inc., Tavares, FL
Developed software to automate their lead collection process. The program was designed to pull specific information off of the web and format it for easy import into a database to be processed before being turned over to their sales force. This program paid for itself four times over the first time they used it and continues to save them thousands every time it's run. (VB, Access, XML)
2002
to
2007 / GSP International Airport, Greenville, SC
Developed software to pull flight information out of their FIDS (Flight Information Data Systems) on a periodic basis, format the information, and post it to a web server on the Internet. (VB, HTML)
Developed software to synchronize GSP flight information with FlightView XML data feed. (VB, XML)
Designed flight information displays through-out airport. (ASP, XML, HTML, Javascript)
2004
to
2007 / ControlScan, Inc., Atlanta, GA
Designed and developed their Seal Management program. The Seal Management program is the heart of their day to day business. It allows them to manage and maintain all of the information related to their various certification programs, their customers and resellers. It is also responsible for the security and control required for displaying the seals on their clients sites. (PHP, MYSQL, Javascript, XML)
2004
to
2007 / MEDIASnatcher.com, Atlanta, GA
Designed and developed website and MEDIASnatcher software. Developed automation scripts for processing purchases so that the customer gets instant access to the program after purchase. The authentication mechanism was modelled after systems used by the satelite tv industry to prevent unauthorized access. Being so it has been one of the hardest products to pirate.
(C#, VB, ASP, PHP, MySQL, Javascript, HTML)
The cutom HTTP Transfer engine was developed as an ActiveX control to be used in other TKPS projects.
2005 / DeepNines, Inc., Dallas, TX
Developed the Edge Infection Quarentine (EIQ) module of the Infection Free Networking (IFN) product.
EIQ brings host-level control to IFN, without any software on the individual host’s computer. It allows administrators to block malicious hosts within the network to stop the internal spread of worms, viruses and other malicious traffic. (PHP, MYSQL)
2003
to
2004 / Marconi, Richardson, TX
Wrote software to provide Fail-to-Wire functionality that is used in the Sleuth9 product from Deep Nines ( (C, PERL)
Built custom Windows 2000/Linux configuration for Toshiba notebook computers used by the wireless group's consulting system engineers for conducting wired and wireless security analysis.
December 1997
to
December 2001 / EMC Corporation, Duluth, GA
Consulting Systems Engineer/Pre Sales Senior Systems Engineer
EMC is a worldwide leader in digital storage technology.
Consulting Systems Engineer (January 2000 to December 2001)
(Aviion Business Unit/Healthcare Professional Services)
  • Performed Meditech & PACS System Implementation & Upgrades.
  • Built web based tools to provide information regarding standard Meditech RAID configuration procedures. (HTML, VB Script)
  • Wrote scripts for automating printer setup in a Meditech environment. (VBScript, WMI)
  • Developed a custom network utility used by our support group for testing and benchmarking network connectivity for specific applications. (VB)
  • Created default ManageX policies use by our clients for capacity planning.
  • Implemented NT environments based on Aviion servers and Clariion disk arrays sub-systems.
Pre Sales Senior Systems Engineer (December 1997 to December 1999)
(Aviion Healthcare Channel Sales)
  • Represented the company as a member of the ActiveX for Healthcare committee.
  • Assisted in the design and implementation of a Multi-Terabyte Data Warehouse using SQL Server in a Windows NT clustered environment.
  • Created scripts for maintaining master pricing spreadsheets for McKessonHBOC (a partner). (VBA)
  • Provided technical support to healthcare sales team and worked with clients to resolve post sales issues.
  • Worked with VARs and ISVs on system design, testing, and security.
  • Represented the company at many trade shows. (MSHUG, International MUSE, Microsoft How-To)
  • Created a web based lead capture program to be used at the various conferences. (ASP, Access)
  • Wrote software to automate the calculation of uplifts for the sales force when generating quotes. (VB)
  • Designed and proposed NT environments based on Aviion servers and Clariion disk array sub-systems to prospective clients.

February 1996
to
December 1997 / The Publishing Company of North America, Inc., Lake Helen, FL
MIS Manager/Internet Commerce Manager
The Publishing Company of North America is a customer service driven organization that provides directory publishing, and internet presence services to the legal industry nationwide.
MIS Manager (October 1996 to December 1997)
  • Designed and implemented corporate and branch office networks and security systems.
  • Defined company info structure, and procedures.
  • Implemented corporate software for integrating departments.
  • Augmented corporate software to enhance reporting and data accessibility.
  • Assessed requirements for corporate and branch office networks.
  • Evaluated, ordered, and installed required hardware and software.
  • Wrote software to automate the lead processing procedures. (VB, Access)
    (Effect: Reduced the amount of time needed for processing from days to minutes.)
  • Wrote call accounting software that visually ranked all phone sales associates. (VB, Access)
    (Effect: Increased average phone time by 300 percent.)
  • Managed the development of a database replication system. (C++, VB, Access)
    (Effect: Allowed accurate and real-time data to flow to branch offices.)
Internet Commerce Manager (February 1996 to October 1996)
  • Developed Internet Department
  • Designed and Created websites for clients
  • Defined procedures for design and implementation of client websites.
  • Implemented dual NT systems for hosting WWW, and RAS services.
  • Implemented Linux system for hosting SMTP/POP3, DNS, FTP, HTTP (CGI Software), and IRC services.
  • Established working relationships with clients while evaluating their requirements for the design of their web site and other Internet resources.
  • Managed the scheduling and development of clients’ web sites.
  • Evaluated new technology for incorporation into the resources provided to clients.
  • Developed custom CGI, Java, and Cold Fusion applications to meet the needs of clients.
  • Promoted business by presenting our services to prospective clients and associations.

June 1992
to
February 1996 / The Atlanta Dental Supply Company, Atlanta, GA
System Manager
The Atlanta Dental Supply Company is a 130+ year old full service organization that provides everything from dental floss to an entire dental office filled with equipment and supplies to the dental profession. They also provide practice management and and equipment repair services.
  • Managed and maintained the Data General MV/15000 mainframe, then migrated to Pentium based Server, running SCO UNIX.
  • Developed software to perform company specific tasks under AOS/VS, SCO Unix, and PC platforms. (VB, Business Basic, C, Cobol)
  • Evaluated current technology to provide the most cost-effective solution for updating the company's computing resources.
  • Provided technical consulting during the conversion from the MV to the PC Server.

Education and Training

2006 / Visual Basic Expert Rating Test (4.0 GPA)
2001 / Achieved MCSE certification
1998 / Achieved MCP certification
1992 / Interactive Learning Systems(4.0 GPA)
Graduated as class valedictorian

References available upon request.