Andy Yetzer Email & Phone Number

Bucyrus, Ohio

Mansfield, Ohio Area

Advising and selling Medica Individual, Family, and Medicare health insurance policies in 8 midwestern states that I am licensed. Have attained many related certifications including Medicare.

Medina, Ohio

Benefits advisor to companies and individuals.Licensed in Ohio to sell Accident and Health insurance.

Ashland, Ohio

Responsible for entering and auditing domestic and international freight shipping invoices. Assembled weekly shipping invoice audit reports including various domestic and international freight charges for submission to the customer. Created tools to help streamline the auditing and reporting processes. Authored two U.S. Customs and Border Protection (CBP) Customs Trade Partnership Against Terrorism (CTPAT) presentations aimed at providing an overview of the program and a study guide to an… Show more Responsible for entering and auditing domestic and international freight shipping invoices. Assembled weekly shipping invoice audit reports including various domestic and international freight charges for submission to the customer. Created tools to help streamline the auditing and reporting processes. Authored two U.S. Customs and Border Protection (CBP) Customs Trade Partnership Against Terrorism (CTPAT) presentations aimed at providing an overview of the program and a study guide to an employee certification test. Scored customers’ business partners on Minimum Security Criteria (MSC) for evaluation of level of security conditions and procedures for CTPAT certification. Show less

Mansfield, Ohio Area

Worked with internal sales, order entry, engineers, and customers to ensure that orders were completed from initial entry through final testing of new installations and upgrades to various levels of internet services. Monitored progress of numerous orders and communicated information through emails and phone calls. When problems or delays occurred deciphered where the problems were and decided on best course of action to get the project back on track.

Mansfield, Ohio Area

Second tier telephone support for AT&T business cellular device users. Provided education on the usage of various types of cellular equipment as well as network troubleshooting and device replacement. Responsible for learning and becoming adept at the use of AT&T software packages while speaking with customers on the phone. Had the ability to recognize the problem at hand and troubleshoot to a successful conclusion, escalated to the next level of support, or courteously transfered to the… Show more Second tier telephone support for AT&T business cellular device users. Provided education on the usage of various types of cellular equipment as well as network troubleshooting and device replacement. Responsible for learning and becoming adept at the use of AT&T software packages while speaking with customers on the phone. Had the ability to recognize the problem at hand and troubleshoot to a successful conclusion, escalated to the next level of support, or courteously transfered to the correct department. Placed first in the AT&T ranking system at Mansfield facility for a quarterly staffing evaluation period in a pool of approximately 80 other technicians with varying degrees of experience while earning several bonuses. Show less

Dublin, Ohio Area

Developed, enhanced, and repurposed new and existing Crystal, SQL Server Reporting Services (SSRS), and SQL scripted reports. Developed and maintained data uploads and downloads with various vendors either on an ad hoc basis or on a scheduled timetable. Worked closely with users and the vendor to support, maintain, and upgrade a medical care software package that tracked various diseases for hundreds of patients. Worked on the details to update the medical care software from an older version… Show more Developed, enhanced, and repurposed new and existing Crystal, SQL Server Reporting Services (SSRS), and SQL scripted reports. Developed and maintained data uploads and downloads with various vendors either on an ad hoc basis or on a scheduled timetable. Worked closely with users and the vendor to support, maintain, and upgrade a medical care software package that tracked various diseases for hundreds of patients. Worked on the details to update the medical care software from an older version to one several versions newer. This included working with the vendor, the nurses, the support staff, and the vice president of that department on timing, training, and new features and functions. Also, worked on ensuring that any customizations would also transfer over to the new version. Show less

Mansfield, Ohio Area

One of the leaders to move vendor software from Business BASIC/Unix to Windows Server and SQL based version of the copier industry ERP software. Worked closely with all levels of users and managers on the planning and implementation of this software conversion making sure that customizations would be reproduced or incorporated in the new version. Underwent extensive training on the new software, SQL Server, SQL scripting, and Crystal Reports both from the vendor and from an outside… Show more One of the leaders to move vendor software from Business BASIC/Unix to Windows Server and SQL based version of the copier industry ERP software. Worked closely with all levels of users and managers on the planning and implementation of this software conversion making sure that customizations would be reproduced or incorporated in the new version. Underwent extensive training on the new software, SQL Server, SQL scripting, and Crystal Reports both from the vendor and from an outside source.Changed, wrote, and adapted Crystal Reports and SQL scripts to accomplish user needs. Primary liaison between MT and vendor supervising any vendor written quotes and customizations. Oversaw installation and testing of customizations. Involved in connecting ERP system to other systems both internally and externally. Worked with other vendors to get data into and out of ERP system. Primary internal customer support contacting vendor when escalation was necessary. Show less

Mansfield, Ohio Area

Develop new reports and programs, re-purpose and rewrite existing reports and programs while working with users and the vendor to customize the stock ERP package to best suit MT's needs. Picked by software vendor to be part of a national team of super users that met quarterly over a period of two years to guide, critique, and make suggestions for new functionality on the Windows/SQL based version of the copier industry ERP software. As part of this team, made sure that MT’s voice was heard on… Show more Develop new reports and programs, re-purpose and rewrite existing reports and programs while working with users and the vendor to customize the stock ERP package to best suit MT's needs. Picked by software vendor to be part of a national team of super users that met quarterly over a period of two years to guide, critique, and make suggestions for new functionality on the Windows/SQL based version of the copier industry ERP software. As part of this team, made sure that MT’s voice was heard on desired changes to functionality and improvements. Show less

Mansfield, Ohio Area

Programmed on Pick based systems in Business BASIC and SQL-like languages. Internal customer support and customizations on hybrid proprietary and custom ERP system. One of the leaders of the transition from this legacy system to a new vendor supplied software package. Identified key reports and functionality that had to exist in some form in whatever software that was auditioned. Member of the team that reviewed various vendors’ software packages and made recommendations as to the… Show more Programmed on Pick based systems in Business BASIC and SQL-like languages. Internal customer support and customizations on hybrid proprietary and custom ERP system. One of the leaders of the transition from this legacy system to a new vendor supplied software package. Identified key reports and functionality that had to exist in some form in whatever software that was auditioned. Member of the team that reviewed various vendors’ software packages and made recommendations as to the appropriateness and functionality of the systems reviewed. Ultimately became the sole IT programmer that moved as much data as possible from the legacy system to the new system. Show less

Mansfield, Ohio Area

Develop, rewrite, and re-purpose Business BASIC programs and reports on two customizable ERP systems for external customers. Front-line customer help desk and support. Used a fourth generation program generator that created BASIC code and utilized tables, views, etc as modern SQL based software does today. Assisted, when necessary, to move customer from legacy system to these systems.