Brandon Harms Email and Phone Number

• Maintained and enhanced proprietary software that allowed for Eligibility Checks, Insurance Verifications, Cost of Treatments, and Billing Reviews which increased efficiency by 30%.• Managed cloud environments on AWS, Azure, and colocations. This included EC2 instances, containers, file systems, VPC’s, Firewalls, and databases.• Maintained and provided analytics on Practice Management and EMR systems including OncoEMR, Unlimited Financials, G4 Studio, Athena, eClinicalWorks, AllScripts, Mosaiq, OpenPM, and Intergy. • Created interfaces and mapped multiple HL7 streams into a proprietary database through a managed SFTP server utilizing PHP in the Laravel framework.• Wrote Policy and Procedure, managed SOC II compliance audits and client/vendor assessments. • Held meetings with clients and C level executives to review financials and spot trends.• Extracted, cleaned, and transformed large datasets using SQL and MS Excel for analysis and modeling purposes. • Created interactive data visualizations and dashboards using Excel and PowerBI to facilitate data-driven decision making and monthly financials.• Conducted exploratory data analysis to identify key patterns and insights, leading to recommendations for process improvement and cost savings. • Designed and maintained multiple systems in FAMP and LEMP environments. These systems included Revenue Recovery, Document Repositories, Client/Vendor Communications, internal Time Tracker and a Helpdesk system which increased response times by 12 hours, employee efficiency by 25%, as well as employee satisfaction.

Worked in Business Intelligence. Created analytical tools that assisted clients in better focusing efforts and money to provide an efficient and effective workplace.

• Recruited, trained, and supervised sales staff. • Responsible for ordering and maintaining an inventory of over 200 new vehicles. • Implemented new sales process that increased the New Vehicle department’s net revenue from a break even to over $500K in just under a year. • Created and maintained sales logs to review trends and assist with inventory management. • Created and ran reports out of our DBMS for weekly PnL meetings.

• Designed and implemented statewide authentication system used by the South Dakota Library Network.• Trained with Sun Solaris to manage our library system servers. • Extracted and transformed data out of Oracle for modeling purposes. • Managed multiple FAMP and LAMP environments.• Designed scripts to manipulate registration data and maintain a statewide patron database.

• Improved our presence online by keeping up with photos, implementing SEO, and working with third party vendors to display our inventory.• Increased the closing ratio from 3% to 18% in the first quarter. • Trained with JM&A to backup Finance and Insurance, sell products, and write contracts with our lending institutions. • Trained and backed up sales management at the tower when needed. This included vehicle appraisals, writing deals, and closing.• Received multiple awards from General Motors for outstanding sales in Chevrolet and Buick.