Luke’s CV

Luke Gerhardt

Information Technology Consultant


Programming Languages and Technologies

Internet
  • PHP
  • HTML5
  • CSS3
  • JavaScript
  • AJAX
  • WordPress
  • TikiWiki
  • Enpowi
  • PayPal PayFlow Gateway
  • Authorize.net
PC / Mobile
  • Microsoft C# .net
  • Microsoft Visual Basic 6 (VB6)
  • National Instruments Lab/Windows CVI 8
  • Microsoft Visual Basic for Applications (VBA/Microsoft Office)
  • Microsoft Access (2013/2010/2003/XP)
  • ADO
  • ODBC
  • TransactSQL
  • C++
  • Windows Phone 7.x
IBM iSeries / AS/400
  • IBM ILE RPG IV (incl. Free-Form RPG)
  • DB2/SQL
  • CGIDEV2
  • Advanced Function Printing (AFP)
  • Control Language (CLP/CLLE)
  • FTP scripting

Software

Development
  • JetBrains PHPstorm
  • Microsoft Visual Studio 2012
  • Microsoft Visual Studio 6
  • IBM Rational Developer for Power Systems
  • Websphere Development Studio Client for I (WDSCi) 7
Virtualization
  • VMware ESXi
  • Oracle VirtualBox
Data Recovery and Forensics
  • Photorec
  • GetDataBack FAT/NTFS
  • Wireshark
Administration
  • pfSense
  • Microsoft IIS
  • Microsoft Active Directory
  • Microsoft Exchange 2003
  • Microsoft Windows Server (2012 R2/2008/2003/2000)
  • IBM OS/400 (V7R1/V6R1/V5R4)
  • Linux

Current Operating Systems Deployed (%)

Microsoft Windows
Linux
Mac OS X

Microsoft Windows (% Detail)

  • Desktop
  • Server
  • Windows Phone

Linux (% Detail)

  • Desktop
  • Server
  • VMware ESXi
  • pfSense
  • Android
  • ChromeOS
Total Digital Consulting, LLC (December 2011 – Present)

Owner, Information Technology Consultant
Greencastle, Indiana, USA; Fairland, Indiana, USA

  • Ported AS/400 applications to .net to remove company reliance on aging AS/400 system.
  • Website back-end coding for design client.
  • Administration of Microsoft Windows domain services for remote clients.
  • Built custom servers for small business clients, tailor-made to their needs.
  • Built high-end CAD workstation for client.
  • Provided virus and malware removal for clients.
  • Provided migration services to move company from Windows Small Business Server 2003 to Windows Server 2012 R2 Essentials.
  • Provided installation and troubleshooting on Call Management Products’ PhoneSuite PBX systems in medium and large scale implementations.
  • Implemented customized Single-Sign-On (SSO) OpenID solution in existing corporate Tiki Wiki CMS Groupware installation.
  • Developed free and paid versions of Windows Phone 7 application for VGA Planets “Nu” messaging. (Planetary Communicator)
  • Developed free and paid versions of hybrid countdown timer / alarm application for public speakers.
  • Developed and implemented SQL Server-based production system to synchronize data between remote office server and IBM iSeries located at company headquarters. Production systems at remote office are all completely isolated from and no longer reliant upon connection to systems back at the main facility.
  • Trained administrators on how to implement and use Microsoft SharePoint 2010 to improve their client communication.
  • Analyzed SharePoint system design to troubleshoot critical issues and complaints from prior configuration.
  • Integrated Authorize.net and PayPal PayFlow Gateway solutions into custom websites and CRMs.
Heartland Automotive, LLC (January 2006 – January 2012)

Information Systems ~ Programmer / Network Administrator
Greencastle, Indiana, USA

  • Developed and successfully implemented database schemas for financial, production, quality, and other departmental data collection needs.
  • Created and updated existing reports using SQL.
  • Made use of free, opensource network monitoring tools to detect network weaknesses and trace abnormal traffic patterns.
  • Consistently able to recover important data files from damaged desktop and laptop hard drives.
  • Integrated iSeries and PCs with both new and existing Industrial Automation systems for the purpose of data collection and process control.
  • Developed custom time tracking system using free, opensource database management system LibreOffice Base. System included fully relational tables, queries, input form and reports.
  • Engineered and executed new design cost-management system for maintaining financial records for individual customers and vendors. Significant parts of existing system were adapted to use this new system. Problems with cost-management were highlighted and were able to be corrected decisively
    because of this system.
  • Designed and implemented successful Just-In-Time production, shipping, and inventory management systems for Subaru of Indiana and Toyota, using iSeries (AS/400) and PC-based
    technologies to improve productivity and system reliability.
  • Saved company $17,000 in replacement costs by executing successful repairs on older equipment.
  • Designed, created, and debugged software systems written in Microsoft Visual Basic 6, iSeries (AS/400) ILE RPG IV, Control Language (CL), Query/400, Active Server Pages (ASP), Microsoft Access, and Microsoft Query in English and Japanese.
  • Maintained maximum server hardware and software uptime at remote office location.
  • Designed, created, and maintained corporate Internet, Intranet, Webmail, and FTP sites.
  • Configured Internet access and restrictions for users.
  • Repaired and rebuilt laptops, older computers, and other equipment to correct hardware and software problems.
  • Provided technical support for PC, MAC, and AS/400 users in person, via telephone, email, or long-distance remote connection from remote corporate location and from home.
  • Provided software training for in-house AS/400 applications, Microsoft Access, Excel, Outlook, MSDOS, PowerPoint, Query, Windows 95, Windows NT4, Windows 2000, Windows 2000 Server, Windows XP, Windows Vista, Windows 7, and Windows Server 2003.
  • Configured and performed troubleshooting for Japanese-language support on PC systems.
  • Configured network user and email accounts as well as AS/400 user profiles.
  • Performed setup and troubleshooting on PC hardware, software, printers, other PC peripherals, AS/400 hardware and software.
  • Performed troubleshooting and maintenance on ISDN-based teleconference equipment.
  • Performed troubleshooting on various network configuration issues.
Interior Design and Computer Technology Services (January 2006 – December 2009)

Joint Proprietor, Webmaster, Voice Artist
Greencastle, Indiana, USA

  • Launched company to provide design, technical support, and voice acting services to both local and international companies.
  • Provided design and onsite setup of both wired and secured-wireless network for local company.
  • Provided professional script editing and voiceovers for marketing and educational presentations for use by international businesses.
  • Assisted in development and maintenance of website for Indiana Chapter of National Kitchen and Bath Association (nkbaindiana.org).
  • Assisted in development and maintenance of website for Touchmark, Incorporated (touchmark-inc.com).
  • Administered core IDCTS (idcts.com) website CMS design and functionality.
  • Managed user email accounts and permission levels for all managed sites.
Heartland Automotive, LLC (July 2005 – January 2006)

Information Systems ~ PC Specialist
Greencastle, Indiana, USA

  • Wrote and debugged in-house AS/400 and PC-based applications.
  • Designed, created, and maintained corporate Internet and Intranet sites.
  • Configured Internet access and restrictions for users.
  • Repaired and rebuilt computers to correct hardware and software problems.
  • Provided technical support for PC, MAC, and AS/400 users in person, via telephone, email, or long-distance remote connection.
  • Provided software training for various Microsoft programs.
  • Configured and performed troubleshooting for Japanese-language support on PC systems.
  • Configured network user and email accounts.
  • Created and maintained AS/400 user profiles.
  • Performed setup and troubleshooting on PC hardware, software, printers, other PC peripherals, AS/400 hardware and software.
  • Performed troubleshooting and maintenance on ISDN-based teleconference equipment.
  • Performed troubleshooting on various network configuration issues.

Information Systems ~ Data Entry

  • Entered critical, time-sensitive data into AS/400 midrange database server for Quality, Production, Shipping, and Purchasing departments.
  • Printed reports and performed analysis on data as needed.
  • Provided technical support for PC, MAC, and AS/400 users.
  • Configured Japanese-language support on PC systems.
  • Prepared presentations for company meetings using Microsoft PowerPoint.
  • Maintained adequate stock of printer paper and ribbons.
  • Videotaped important company events.

 

Heartland Automotive, LLC (September 2002 – July 2005)

Information Systems ~ Data Entry
Greencastle, Indiana, USA

  • Entered critical, time-sensitive data into AS/400 midrange database server for Quality, Production, Shipping, and Purchasing departments.
  • Printed reports and performed analysis on data as needed.
  • Provided technical support for PC, MAC, and AS/400 users.
  • Configured Japanese-language support on PC systems.
  • Prepared presentations for company meetings using Microsoft PowerPoint.
  • Maintained adequate stock of printer paper and ribbons.
  • Videotaped important company events.

 

English

Native fluency. Can read, write, and explain complex ideas clearly. Actively engaged in public speaking role since 1987.

Japanese

Basic fluency. Can read and write Hiragana and Katakana syllabaries. Can read and write basic Kanji. Can communicate and respond basic thoughts.

Engaged in eight years of self-study while working at Japanese company.

Hudson Valley Used Tools & Equipment

http://used-tools-equipment.com/
(initial design and site layout)

Responsible for initial site design and layout adjustments.  Provided frontend and backend modifications to align with design modification requests.  Set up Woocommerce and modified it heavily for displaying vendor-specific fields and data charts on products.

Outdoor Transformations

http://outdoor-transformations.com/
(original site no longer hosted, cached version reposted for viewing at http://outdoor-transformations.lukegerhardt.com/)

Provided initial set up and website hosting administration. Responsible for email account administration. Implemented designer’s requirements via CSS and PHP coding.

Luke G’s Blog

http://www.lukegerhardt.com/

Performed initial set up and site design. Responsible for all administration of site, disaster recovery protocol and implementation, database backend, email accounts, and other online service functions.

Total Digital Consulting, LLC

http://www.totaldigitalconsulting.com/

Performed initial set up and site design. Responsible for complete ownership and administration of site, email, and all related functions.

PDK Financial Solutions, LLC

http://www.pdktax.com/

Performed initial set up, site design, and hosting. Responsible for all administration of site, email accounts, and remote support of other online service functions.

Touchmark, Inc.

http://www.touchmark-inc.com/

Provided initial set up and website hosting administration. Responsible for email account administration. Provides remote support for all issues.

Responsible for design and implementation of new site for release during the first quarter of 2012.

MultiPod Renamer

https://bitbucket.org/Koohiisan/multipod-renamer

This is a fork/modification of the source code for the JapanesePodRenamer project originally found on http://www.nihongonobaka.com/how-to-rename-and-organize-files-from-japanesepod101-com/. I’ve renamed the project and changed the way it handles file and naming errors.

Tiki Wiki CMS Groupware

http://info.tiki.org/

Assisted with development, implementation, and testing for TikiWiki adaption of ForwardLink-Protocol.

kB2KSkype / kB2KSkype.py

http://kb2kskype.sourceforge.net/

Active beta tester. Contributes to improvement of product through concrete suggestions and implementation strategies.

Mozilla Thunderbird

http://www.mozilla.org/thunderbird/

Tester on nightly build versions for Linux and Windows. Submits concise bug reports and provides general product assistance.

Google ChromeOS

Cr-48 Chromebook Beta Tester
http://www.google.com/chromebook/

Applied for and was selected to be part of the private beta testing of the first Google Chromebook prototype (Cr-48), running their cloud-based operating system, ChromeOS. Provided feedback based on thorough testing and evaluation.

Area 30 Career Center

Advisory Board Member (2008 – Present)
http://www.area30.k12.in.us/