**** ******** ****, ******, ** *****

Phone 440-***-**** E-mail ac5q19@r.postjobfree.com

Gerald F. Voyten

Profile

Microsoft Office Specialist/VB.NET/MS-DBA specializing in database management and application design as well as over ten years of data conversion experience. Proven ability to communicate effectively with both technical and non-technical personnel from end-users to senior management. User software support, both internal and external. Experience in graphic art, desktop publishing, and demographic programs.

Perfect Practice Software Implementation Specialist working closely with the software manufacturer to support the implementation of their product for customers.

Technical Skills

Databases: MS Access, MS SQL Server (2000, 2005, 2008), Extended Systems Advantage Database

Languages:, Visual Basic for Applications (VBA), Visual Basic.NET, BASIC, SQL, Visual Basic Script (VBS)

Applications: MS Office, MS FrontPage, MS Visio, MS Publisher, MS Project, CorelDraw Suite, ADC Legal Perfect Practice, other proprietary applications

Operating Systems: MS-DOS, all versions of Windows (through Windows 10), working knowledge of MS Windows Server 2000/2003, 2008

Professional Experience Summary

April 2015 – May 2018 PNC Bank Highland Hills, OH

Visual Basic for Applications Programmer for MS Access and MS Excel

Maintained legacy applications for Loan Processing in the Rate Admin. group (VBA in Access).

Help process rate changes for all lending products.

Created four new applications to automate for the first time or replace existing legacy system products with new structures and functionality (VBA in Access).

Worked with outside vendors (like FICO) to create new products, table, and export file structures.

Created a number of tracking and conversion programs specifically in VBA in Excel.

Created user and technical guides for all departmental loan Access and Excel applications.

November 2014 – March 2015 ADC Legal Orlando, FL

Perfect Practice Software Technical Support

Was training specifically to be a SQL script writer for a specific aspect of the application to modify customer functionality to create specialty processing unique to each customer.

March 2014 – October 2014 Hughes, Watters, Askanase Houston, TX

Perfect Practice Software Implementation Specialist

Brought in to assist a company that had worked nearly a year to implement Case Management software and had failed.

Was able to get company functionally operational in six weeks. In production in three months.

Credited by ADC Legal Software and NetDirector electronic file transfer company as having accomplished the setup of this company in one of the fastest times they had ever recorded.

Wrote many custom Visual Basic Scripts to accomplish supporting tasks for interfaces and maintenance of system.

2009 – 2014 Weltman, Weinberg, Reis Brooklyn Hts. OH

Programmer/Analyst for ADC Legal’s Perfect Practice Case Management System

Primary support for specialized legal case management system. Custom SQL script creations and modifications to support new functions in application. Primary contact with ADC Legal and most other related vendors.

Extensive custom VB Script construction for a variety of different functions and utilities, including imports and application utilities. Extensive VBA coding in Access, Word, and Excel for custom automation and mail merging.

2007 – 2009 Franklin & Seidelmann Beachwood, OH

Senior Applications Analyst/MS SQL DBA

Project managed and developed new features for a company legacy teleradiology client tracking system using Access (VBA code) as a front-end to a SQL Server back-end. This included many advanced features for limiting input error and close turn around time tracking of the entire process.

DBA for six production SQL Servers including SQL Server 2005. Created and maintained backup and restoration systems. Modified data structures and created new elements as required for new features. Systematically scheduled conversion of data access queries from Access over to the SQL Server for faster throughput. Created and maintained SQL views and stored procedures.

Converted existing SQL 2000 Servers over to SQL 2005 Servers. Created implementation plan including risk analysis and full procedures to be coordinated between development and infrastructure staff. Designed implementation plan for creating SQL Server 2005 failover.

1998 – 2007 Metropolitan Bank & Trust Highland Hills, OH

Lead Applications Analyst/Programmer Analyst

Lead internal application developer with custom tracking and reconciliation projects used both internally and with outside vendors. Primary support of MS Office for 450 employees. Projects typically converted user project times from days to hours and created reporting mechanisms previously not available by manual methods.

Was told by Senior Vice President that my user loyalty was the highest of any employee he had ever worked with.

Lead for small group of other developers including interviewing and hiring.

Key Accomplishments:

Data conversion projects of millions of dollars enabled bank to leverage sales of loans and credit card portfolios under tight turn-around times.

Automated conversion projects for internal tasks changing jobs that had taken one week to less than five minutes with “single button” processing on the part of the end user.

Software support of both internal and external banking programs in every department in the bank. This included Web-based programs, such as the Federal Reserve Reconciliation System.

1989 - 1998 Summit Co. Dept. of Human Services Akron, OH

Programmer Analyst 3

As a Programmer Analyst I implemented two Unix servers by myself that supported 75 users and communicated through a TCP/IP backbone with each other. I trained those users in the function of the application software installed and also trained a number of individuals in Unix system administration procedures.

Wrote an Excel spreadsheet that helped the HR Department track accurate vacation accrual and usage.

Created a number of department-level Access database applications.

1983 - 1989 Sperry Corporation Brecksville, OH

Third Party Service Coordinator/Customer Engineer

Worked as a field service technician responsible for maintaining and repairing terminals and cluster controllers for synchronous terminal systems for many government agencies and private companies, including most police departments.

Was personally selected by a regional vice president of Sperry to assume the position of Third Party Service Coordinator where I was responsible for contracting and logistical support of service for a wide array of equipment from other companies.

I eventually became a high-level troubleshooter directly for the branch manager assigned to problems other customer engineers couldn’t solve.

1980 - 1983 Bailey Controls Wickliffe, OH

Quality Assurance Technician/FORTRAN Programmer/System Development Technician

Originally worked as a design prototyping technician but was hand chosen to become a Quality Assurance Technician and later to advance to become a FORTRAN programmer for performance calculations that operate in a nuclear power plant’s computer control system.

Education

Lakeland College - Mechanical Engineering

Pittsburgh Institute of Aeronautics – Airframe/Powerplant Mechanics Training

Capital Radio Electronic Institute - Electrical Engineering

New Horizons Visual Basic.NET/ASP.NET Certification Training (MCSD program)

New Horizons Microsoft SQL DBA Certification Training (MCDBA program)

Solutient Implementing and Maintaining Microsoft SQL Server 2008 Integration Services Training (SSIS)

Volunteer Experience

Lakeland Community College Mentoring 2001 class year

Volunteer for Project Plus Adult Literacy training for two years

Voluntarily instructed a class of 22 employees after hours at Sperry Corporation in PC hardware and software basics

Voluntarily instructed a class of 16 employees after hours at the Department of Human Services in hardware and software basics

Volunteer time at the Department of Human Services to train clients in computer science and desktop publishing.

Volunteer time at Franklin & Seidelmann to teach computer skills to employees on weekends.

Contact this candidate