Lead Software Architect and Developer, Executive

KEITH A. YARNELL

**** ****** *** *****, ********* NC, 28269

cell 954-***-**** – email *****@*******.***

OBJECTIVE

Currently seeking a position to leverage my experience as a Chief Technology/Information Officer, Senior Business Intelligence Analyst, and Developer/Software Architect. I am willing to work on-site and relocate if needed, or work in a remote or hybrid environment.

I am an expert in leveraging legacy systems and procedures while producing new state-of-the-art systems that provide new required features without business disruption.

I thrive in managing small to medium sized IT teams driving high-result environments and enjoy the challenge of designing and developing highly cost-efficient, feature-rich industry-specific software that provides insight and automation without sacrificing the human spark that lifts companies to the top of their business segment.

HIGHLIGHTS OF EXPERIENCE

37 Years of experience providing C-Level leadership, management, support and development of advanced software for diverse businesses.

Created integrated systems for the following industries as Primary Architect/Developer:

Fully Integrated Platform for Automobile Sales Management, Automobile Service and Refurbishment

Provided integrating service repair history, estimating, billing and cost reconciliation for 7 car dealerships and three repair facilities including an independent 21 bay repair shop

Fully Integrated Platform for Automobile Lending Services (specific service for C/D paper, specialty financing)

Supported 375 users in five facilities

Managed a portfolio of $175mm of automobile loans including collections and repossession where needed

Fully Integrated Platform - Repossession Management, Customer Service Secure Web Portal

Nationwide Real-Time Repo Dispatching (LPR License Plate Camera Networks)

SOAP/REST API Integration (local APIs inbound for 3rd partiy connection and remote platforms integration)

Forms Management, Image Capture Library Management, Telephony Integration

Real-Time Compliance and Auditing Systems including Automated Management Alarms and Reporting

Founding and Participating Partner in multiple companies (details below).

Controlled all aspects of IT purchasing and implementation including general office software and industry-specific or task-specific solutions for all companies.

Extensive Experience and Success -

Creating data-driven systems developed around the Microsoft SQL Database platform as well as MySQL/MariaDB based systems. I have personally designed and implemented several complete databases and the hardware environment to house them (including clustered, fault tolerant systems and environments that incorporated multi-site enterprise failover).

Designed and implemented multi-site Microsoft-based networks utilizing diverse hardware and security solutions (VPNs, point to point private long-distance networks and tunneled site-to-site solutions, and multi-factor fingerprint and keycard authentication systems driven via Active Directory).

Working with and integrating Microsoft Office products with custom production systems, including designing add-ons to connect real-time data to the Office applications, analysis, ETL, and multi-format data export..

Created reporting solutions to provide real-time alerts, dashboard, and daily/periodic reporting and analysis.

HISTORY

Resolvion LLC

Chief Information Officer and Partner

July 2018 thru January 2024

Company formed by merger with competitor

Primary Architect and Developer of the Wombat System, an integrated suite of systems driving a national automobile repossession company, replaced software used by competitor.

oLiving system which continued development from previous company and took over all aspects of operation of the company acquired via merger.

oSystem supported 500+ users in real time over multiple locations nation-wide

oSystem provided services for:

Skip Tracing and Location

Data Acquisition, management, and correlation from national NPPI Data Sources and through manual skip tracing efforts

Management of Repossession via local agencies

Post-Recovery asset management

Transportation Services

oManaged over 10,000 automobile repossessions monthly for national lenders (including JP Morgan Chase, Santander, Exeter, other national and regional lenders)

oManaged a fleet of contracted independent repossession agencies nationwide (at peak, nearly 9000 agencies)

oIntegrated with all commonly used national industry platforms used by clients and agents, allowed seamless and transparent cross-system operation in real time via proprietary APIs

oArray of real-time and analytic reporting over all business activities

oUpdated Web Portal to allow real-time interaction with other platforms, providing a single point-of-reporting for many repossession agent related functions.

Company grew to an estimated market value of $100mm from merger to December 2023 and grew to over 400 employees with offices in Charlotte NC, San Diego CA, Dallas TX, Atlanta GA, and Shelton CT, plus an extensive off-shore team.

IT staff growth, by December 2023 had an internal IT team of three full time senior level developers, Scrum Master, Director of IT (Infrastructure), and technicians in three larger facilities (total of five people), and an on-staff BI Analyst.

Responsibilities Included:

oDesign, Implementation, and support of on-premise software infrastructure, including redesign and updating of older modules to new internal and external standards

oDesign and implementation or review of reporting and data tools used by various divisions

oImplemented specialty modules used for rural work

oImplemented specialty modules used for commercial specialty equipment work (i.e., construction equipment, etc)

oReview and approval of all work produced by other developers

oReview of emergency break/fix items repaired by other developers

oDocumentation of both IT modules and underlying business practices relating to same

oImplemented remote work policies and hardware infrastructure, and performed modification of systems to support moving from a primarily office-based workforce to a primarily remote-based workforce

oCarried various additional responsibilities during COVID-19 Pandemic commiserate with reduction of staff (repossessions halted across most of country for several months), including hands-on management of data center equipment as needed.

Reason for Leaving: Amicable parting after merger and post-COVID restructuring (I remain a partner with a substantial investment in the company and provide IT consulting services).

ALS/Resolvion

Chief Information and Technology Officer, Partner

July 2015 thru July 2018

Company formed by merger with competitor

Primary Architect and Developer of the Wombat System noted above

oLiving system which continued development from previous company. Added modules to allow data import in bulk from operational portfolios of business and subsequently took over all aspects of operation of the company acquired via merger.

oDuring period, system supported 200+ users in real time located in two locations (Charlotte, NC and Atlanta, GA) with software and hardware based real-time disaster failover and recovery certified by third party independent auditors. Company roughly doubled in size post-merger.

oManaged over 5,000 automobile repossessions monthly for national and regional lenders

oIndustry-leading software continuously expanded and adapted to rapidly changing industry as new lenders and techniques evolved

oEarly developer implementing real-time integrated services from third-party for license plate camera recognition services

oDesigned web-based customer service portal for clients which allowed secure manual entry of work items assigned to company

oDeveloped tools to allow bulk upload of work from clients as well as batch, portal based, and API based reporting mechanisms for clients

oDesigned secure API allowing clients and agents to update data and retrieve reports

oDocumentation of architecture, modules and underlying business practices

Outgrew our original facility, designed new IT infrastructure around purpose-built facility which included continuous on-site power systems and generator. Assisted in design of various aspects of facility including fault-tolerant infrastructure for executive offices and other design elements.

Senior Management Staff growth during this period, hired VP to take over HR and HR-facing security functions, but continued to manage IT-facing security. IT staff growth, added junior developer, Operations Manager for infrastructure, and three IT technicians to provide 24/7 helpdesk coverage (business model is a 24/7/365 model).

Responsibilities Included:

oDesign, Implementation, and support of all software infrastructure

oManagement of Microsoft SQL Server cluster and supporting systems

oManagement of fault-tolerant power systems including uninterruptable high capacity battery system powering servers

oManaged/produced monthly financial and business operation reporting

oResponsible for design, implementation, and operation of reporting and data tools used for all business decision-making.

oAssisted CFO with various aspects of financial reporting

oResponsible for all background checks and interviewing of potential employees, and for some employees making hiring decision

Reason for Leaving: Corporate merger and infusion of private equity resulted in new company, continued with resultant company as CIO/CTO (and continued as Partner).

American Lending Solutions

Chief Information and Security Officer, Board Member, and Founding Partner

2008 thru July 2015

One of four original founding partners

From original founding to merger with competitor, grew from four partners and three employees to approx. 50 employees in facility located in Charlotte, NC.

Primary Architect and Developer of the Wombat System noted above

oManaged over 2,200 automobile repossessions monthly for national and regional lenders

oSoftware was revolutionary in nature – instead of the business utilizing multiple in-place platforms provided by several companies, Wombat performed real-time management of platform data via API and presented a single, comprehensive view to employees.

oSystem was able to acquire consumer NPPI data from multiple sources using secure methods that removed direct employee requests on remote platforms.

oImplemented secure data handling and user tagging/identification methods that kept data highly secure – to date, system has never been a victim of a security breach and has never failed a client annual security audit.

Responsibilities Included:

oDesign, Implementation, and support of all software infrastructure

oSupervision of Hardware Infrastructure (Director of IT Operations direct report to me)

oSupervised management of Microsoft SQL Server cluster and supporting systems

oManaged/produced monthly financial and business operation reporting

oResponsible for interviewing of potential IT and some management-level employees, and making hiring decision for IT personnel

Evolution of System: Wombat was designed to be an evolving modular system that integrated a set of highly diverse platforms used throughout the industry into a single view, bringing huge efficiencies as a result. The system began as tracking platform for skip tracing work, and over the first few years evolved into a real-time hub for national repossession work with links to every major platform used by our clients and agents. The system provided real-time links to billing systems for major clients, our own internal accounting software, systems for requesting consumer reporting, and other industry-specific requirements in a compliant manner. I was the original architect for Wombat and the sole programmer for the system through 2012, at which time a junior developer and other IT staff members were added to our team. During COVID, our team was reduced to a team of four plus myself, managing east and west coast facilities and managing a quickly developed remote infrastructure for the majority of our staff. The team was restored in size post-COVID as business resumed and employees returned to work.

Reason for Leaving: Corporate merger and infusion of private equity resulted in new company, continued with resultant company as CIO and Chief Security Officer (and continued as Partner).

The Aurora Companies:

Flamingo Financing Company, Dandy Wheels, Car Plaza, and Kodata Corporation

Chief Information Officer, Board Member, and Founding Partner

1990 thru 2008

One of three original working/founding partners (six additional investing partners)

Primary Architect and Developer of Rapid, a system used to manage and integrate automobile lending, recovery, dealership management, and repair shop operations at facilities across the state of Florida. First system of its kind that provided real-time integration of all these vertical operations. Included communication modules to allow auto dealerships to communicate with Flamingo Financing to submit financing applications and receive decisions.

At peak of operation, company employed nearly 500 employees in ten locations

oOperated 5 Lending Offices located throughout the state of Florida, at peak managing a $175mm portfolio of C/D paper loans, operation primarily purchased loans originated at car dealerships across the state

oOperated a corporate operations center including a data center serving all offices and providing failover disaster operations

oOperated 3 car dealerships (primarily used to resell repossessed vehicles) with repair facilities integrated

oOperated a 21 bay repair/refurbishment center including paint and bodywork shops

Responsibilities Included:

oDesign, Implementation, and support of all software infrastructure

oManagement of Microsoft SQL Server cluster and supporting systems

oManagement of general IT infrastructure including shared file systems and resources

oManagement of fault-tolerant power systems including full building diesel generator and uninterruptable high capacity battery system serving data center and key management offices within central facility

oManaged/produced monthly financial and business operation reporting

oResponsible for design implementation, and operation of forward looking real-time analysis and prediction tools used for portfolio management and business decision-making.

oRegular annual production and updating of 1, 3, and 5 year forward-looking enterprise business models used for borrowing and business management purposes

oRapid system software licensed to car dealerships throughout the state, provided technical support

Evolution of System: The first subsystem for Rapid was the loan management system and was originally written using Superbase, a DBase-compatible database and development language running on Windows 3.x based systems. In early 1994, the entire system was re-written in the then-brand new Visual Basic object-oriented language and using an MS-SQL based database for Windows 95. The system was then subsequently converted to VB6 and Windows XP in 2002, and management for large-scale repair work was added at that point. I was the sole developer for the Rapid System through 2004, at which time a junior developer was added to provide continuity for the business.

Reason for Leaving: Conditions in Florida primarily caused by post-9/11 issues ultimately caused the company to cease operations. (I was requested by creditors to continue with the company and assist in the orderly shutdown of operations and collection of remaining collectable loans over the course of 18 months, which was completed.)

Highlights of other significant consulting and representative work:

1988 – Developed public service system to manage Volunteer Search and Rescue personnel across New England.

1991 – Published four articles for Superbase Developers Journal detailing the implementation of a multiuser loan tracking system in the Superbase language.

1992 – Conversion project for COBOL-based real estate financial application to multi-user Linux-based system

1994-1999 – Supporting Rapid Software, implemented custom conversions from existing systems at car dealerships throughout South Florida

1999 – Consulting Project for AT&T Wireless, designed database and data harvesting tool to query cell towers for configuration data daily and produce delta (change) reports as well as verifying correct configuration.

2002 – Guest Speaker for AT&T SE Annual Sales meeting, delivered tech/business talk to 5000 attendees

2003-2005 – Member, AT&T Small/Medium Business Advisory Board. Traveled to various cities with AT&T Sales Centers and participated (occasionally, chaired) roundtable discussions about data services in the Southeast United States, viewed demonstrations of new, unreleased technologies and provided input as to implementation, usefulness, and price points.

2005-2008 Member, South Florida CIO Council

2010 – Designed modules for the Asterisk Open-Source VoIP PBX system to provide outbound local line selection based on dialed number and enhancements to allow audit of recordings for call center management. (Modules provided to the Asterisk project and released to public domain.)

2014-2015 Oversight of merger of data and systems of former competitor post-merger, development of task-specific tools and conversion methodologies to absorb their business into our systems.

2019-2020 Oversight of merger of data and systems of former competitor post-merger, development of task-specific tools and conversion methodologies to absorb their business into our systems.

Corporate Technology Educator 2010-2024

Designed Materials and Taught Classes for:

oBeginner and intermediate user training for Wombat System

oPrincipals of Secure Coding (IT Department)

oWombat System Operations (IT Department)

oUser Security Principals

oAnnual Security Compliance Training

oUsage of Microsoft Office products in our Corporate Environment

Education

Assabet Valley Vocational - 1981-1985

Graduated with Certificate in Computer Science and Information Technology

System Operator Training: Data General Nova 840 System

System Operator Training: Digital PDP-11

Programming: DG Basic, DEC Basic+, Logo, Pascal, COBOL-77, 6502 Microprocessor Assembly

General exposure to early PC Systems (Apple, IBM)

Internship: The Computer Museum - Summer 1980, 1981, and 1982

Docent and Exhibit Maintenance Assistant

Responsibilities included demonstration of operating historical and then-current systems including:

DEC PDP-1, PDP-11, PDP-12

Leading Tours and educational information about Exhibits and Artifacts including:

MIT TX-0 (restoration of system to operational state)

Studied and provided tour information on various historical artifacts including flown Apollo Spacecraft Computer, Babbage Differential Engine, demonstrations of many operational historical systems, and assisting with special events and guest lecturers.

Internship: Digital Equipment Corporation - 1984-1985

System Operator and Group Assistant, SUDS Engineering Group

System Operator, VENUS Project (Development of VAX 8600 Mainframe System)

Responsibilities included: Management of Resources in the following environments: VMS, TOPS-10, TOPS-20. Managed system security (logins/passwords), resource allocation, servicing central printing and magnetic tape equipment, applying OS patches, software installation and maintenance.

Digital Equipment Corporation – Continuing Education Center - 1980-1982, 1984-1986

Certified System Operator: VAX Systems Operator (VMS Architecture)

Certified System Operator: VAX Systems Operator (Ultrix (Unix) Architecture)

Certified System Operator: PDP-10 (DECSystem-10/20), TOPS-10 and TOPS-20 Architecture

Courses Completed included:

VMS Installation and Maintenance

VMS/DECNet Networking

TOPS-10 System Operations (DECSystem-10) TOPS-20 System Operations

RSTS/E System Configuration and Operations

Programming Language Courses: BASIC+, BP2, COBOL-81, MACRO-11

Financial Publishing Company, Boston, MA - 1993

Financial Mathematics and Lending Computation Coursework/Advanced Calculation Coding

Completed coursework for advanced financial mathematics

Certified computation logic and processes used in Rapid System software for loan computations

Victory Lane Aviation School - 2015

Graduated September 2015

Licensed US Private Pilot License

Constant Continuing Education - 1993 - Present

Please see back page for continuing education coursework completed in last 12 months, including both refresher material and new learning courses.

Recent Refresher/Recertification Coursework

All the following courses/certifications have been completed since January 2024

Please Note: Most technologies below I have practical experience and have used extensively in my career (most of them recently). All certifications/courses shown below can be verified via LinkedIn Learning.

Programming Languages

C# Refactoring C# Best Practices for Developers

Refresher: Learning C# Advanced Threading in C#

Advanced C#: Thread-Safe Data and Concurrent Connections Python Parallel and Concurrent Programming

Node.js Training: Web Servers, Tests, Deployment Python for Data Scientists

Node.js Databases for Developers Python in Excel

Python Parallel and Concurrent Programming 1 Python Parallel and Concurrent Programming 2

Programming Foundations: Secure Coding .Net Concepts, APIs and Libraries (update for .Net 8)

Advanced .Net: Cmds, C# Enhancements, Web Apps, Libraries

Cloud Computing

AWS Cert Cloud Practitioner (CLF-C01) 1: Cloud Concepts Azure Fundamentals (AZ-900) 1: Cloud Concepts

AWS Cert Cloud Practitioner (CLF-C01) 2: Security Azure Fundamentals (AZ-900) 2: Architecture/Security

AWS Cert Cloud Practitioner (CLF-C01) 3: Core Services Azure Fundamentals (AZ-900) 3: Services

AWS Cert Cloud Practitioner (CLF-C01) 4: Billing and Pricing Azure Fundamentals (AZ-900) 4: Mgmt and Governance

Google Cloud and Data Storage Foundations Azure for Developers: Resource Planning

Google Cloud for Azure Administrators

MongoDB Cloud Essentials

Database Development and Management

Linux Engineering: Administering MariaDB

Databases for Node.js Developers Learning Snowflake DB

Advanced MS SQL Application Development Intermediate MS SQL Data Reporting and Analysis

Microsoft SQL 2022 Essentials and Administration Intermediate MS SQL For Data Scientists

MS SQL Server 2022 Advanced Administration MS SQL 2019 Essentials and Administration

MS SQL 2022 Essentials and Administration Azure Training for Developers

LINQPad Essential Training .Net Working with LINQ

Linux System Administration

Linux System Engineer: Kernel Tuning and Remote Logging Cert Prep: CompTIA Linux+ (XK0-005)

Linux System Engineer: Network Filesystems/NFS/Samba

Linux System Engineer: iSCSI Storage Area Networks

Linux System Engineer: Database Servers using MariaDB

Linux System Engineer: Networking and SSH

Microsoft Applications:

Microsoft Teams Essentials Visio 2021

Managing Projects with Microsoft Teams Advanced Visio

PowerPoint 2021 Outlook 2021

Word 2021 Excel 2021

Professional Improvement:

Tech on the Go: Ethics in AI What is Generative AI?

Increasing Collaboration on your Team Safeguarding AI

How to Manage Your Attention and Priorities Ethics in the Age of Generative AI

Eight Ways You Block Your Success How to Master Your Executive Presence

The New Rules of Work Communicating with Executives

Leading Yourself Communication Skills for Modern Management

Reframing: The Power of Changing Your Perspective Overcoming Decision-Making Traps

Leveraging Your Strengths

Contact this candidate