John Harms Email & Phone Number

Ypsilanti, Mi, Us

Ypsilanti, Mi, Us

Livonia, Mi, Us

Managed and supported full stack platform and implemented changes for customer and business needs. Created and maintained database queries, tables, relationships, stored procedures, reports/audits, server log archival, and periodic clean-up. Responded to issues and requests within four-hour period and provided on-call coverage for evenings and weekends. Optimized top-tier customer support (typically solving issues within 30 minutes) with LMS integration into XanEdu platform. Mentored junior software developers.• Reduced fulfillment team overhead 40% by porting major functionality from legacy Perl system to new platform utilizing Python, Django, Oracle DB, JavaScript, and jQuery.• Developed a scalable, customizable e-commerce storefront using Perl, HTML templates, JavaScript, jQuery, and JSON, optimizing product ordering processes for diverse customer bases.• Facilitated remote learning during COVID-19 by developing a secure, customized cloud-based DRM solution leveraging Perl and third-party API integration.• Increased system stability, as well as responsiveness by over 20% with major system upgrade to modern Linux OS (Debian 10), Apache 2.4, Perl 5.8, and relevant libraries.• Reduced DRM processing time by over 50% and corrected copyright clearance gateway usage, by updating third-party API calls to integrate with more stable systems for DRM and copyright clearance.

Livonia, Mi, Us

Managed team of software developers, network and system engineers, help desk and tech support staff, and content and project managers. Served on Executive Leadership Team (ELT) to provide IT status updates and recommendations, schedule IT and product maintenance windows, discuss future projects, and provide brief updates during company-wide meetings.• Decreased overall department budget over 35% by utilizing contractors for database and network systems.• Increased speed and reliability for office internet connectivity and VOIP service while cutting overall telecom and ISP costs by 40% by working with underground utility company to bring in fiber.• Reduced overall costs and reliability by replacing POTS line fax servers with eFax integration on Linux.• Corrected dozens of issues within office server room, related to network wiring, power, cooling, battery backups, systems and data backups, and trained help desk staff to perform ongoing maintenance.• Supported Reduction in Workforce by traveling to remote office in Louisville to examine and analyze network and servers, and train staff to handle common issues.

Livonia, Mi, Us

Led small team of software and database developers and QA analysts. Responded to system outages, either remotely or physically. Performed postmortem reviews and provided detailed outage causes and solutions.• Saved over 25% of physical data center footprint, power, cooling and networking by using virtual environments (Xen and VMWare) to migrate existing servers to virtual.• Moved entire XanEdu platform to (leased) off-site data center and new office server room by collaborating with systems and network engineers to document and make the split.• Saved over $5K by switching from Red Hat Enterprise Linux 4 to CentOS 5.• Removed dependency on ProQuest for content search/delivery and financial systems by integrating with Microsoft Great Plains and Lucene.

Livonia, Mi, Us

Continued maintenance, support, and enhancements on a full stack platform, including back-end and front-end components. Mentored junior and contracted software developers and performed code reviews. Planned and executed maintenance windows to release software and system updates. Responded to and fixed system issues as needed during evenings and weekends.• Improved existing platform through integration with a CRM and copyright clearance using technology acquired and purchased.• Increased content publisher agreements by implementing a DRM system, adding key content collections from Harvard, Darden, and others to drive product adoption and sales.

Livonia, Mi, Us

Maintained pre-production environment for testing. Rotated on-call duty for production support during evenings and weekends. Attended OSCON conferences to relay corresponding information to my team.• Collaborated with database admins and developers to create faster and more reliable replacement for Java system using Linux, Apache, Perl, mod_perl, and Oracle.• Decreased queries/requests to software developers from customer service, tech support and fulfillment teams by supporting team leads to design internal administrative tools for analyzing common requests.• Added content to platform by integrating it with ProQuest search catalog, content pricing, and financial systems.• Developed new outage and uptime tracking system that demonstrated 99.9% uptime annually.

Ann Arbor, Mi, Us

Optimized and enhanced internal system and monitoring tools. Managed contractor-delivered Java system with deployment, created and executed capacity tests, and maintained, stabilized, and optimized product.

Bs, Computer Science

Python, Django