Andrew Zerber
E-mail: ***********@*****.***
Phone: 602-***-****
Skills
AS400
PDM - Program Development Management . SQL - Structured Query Language .
DFU - Data File Utility .
Query 400 . Operations Assistant . Command Line Structures . RPG - Report
Program Generating . ILE - Integrated Language Environment . CL - Command
Language . SST - Service Tools . FTP - File Transfer Protocol . SSL -
Secured Socket Layer . IPL - Initial Program Load . PTF Installation .
Backup and Recovery .
Disaster recovery . Client Access
PC/Server Skills
Hardware Expert . Windows XP Professional . Windows 7 . Excel
2003/2007/2010 . Word 2003/2007 .
DHCP - Dynamic Host Configuration Protocol . DNS - Domain Name Server .
Norton Ghost . Norton Endpoint Protection . Active Directories . IPSwitch
FTP Client . CUCM - Cisco Unified Call Manager . SAP . Manage Engine
(Sharepoint User)
Work Experience
Company Name: Primary Financial Services, L.L.C. Title: Computer
Operations Supervisor/
March 1997 - December 2014 System Support
Duties: I began employment as a computer operator and was eventually
promoted to Computer Operations Supervisor in 2004. After the department
expanded to three computer operators, my responsibilities were increased to
include all operations training. I created a document of all operations
tasks for staff and myself to use as a checklist of all of the tasks that
must be completed on a daily basis. Additionally, I have created software
installation instructions for help desk and IT staff to utilize. A manual
of all of the file layouts was created by me as a reference guide for the
operations staff. I also collaborated with various departments throughout
the company to implement processes that improve company systems and
software tools and provide necessary solutions to resolve problems and
issues.
I currently manage all aspects of a medium-sized relational database on an
IBM AS400/I-Series midrange system running AS400/I5 OS. I am responsible
for supervising operation staff's daily work production. Additionally,
responsibilities include all aspects of daily computer operations, which
include imports and exports from clients, processing of all files in
compliance with our individual client's standards, and all ad hoc reports.
I am also responsible for the resolution of error messages on the system
console as well as program error messages including job log research and
source code analysis. Query 400 and SQL programming are extensively
utilized to streamline processes that produce reports that have enhanced
accuracy and are easier to read in Excel. I created a library on the
AS400, for data files, that enables us to create query reports to be
written to tab delimited files and imported to Excel for management
analysis requests. Responsibilities also include production, performance,
and training of operations staff, maintenance of Windows Servers, and
maintenance and repairs of all PC's hardware and software. All PC's are
Windows XP Pro or Windows 7. In addition, programming staff has me test
programs prior to the program being placed into production. My immediate
superior is the Programming Manager.
Company Name: FM Services Title: AS400 Computer
Operator
1987 - March 1997
Duties: Performance of daily operations, file updates, processing of
uploads from clients, and downloads to clients. Weekly system maintenance
and backups were performed on three AS400s. Maintained and repaired all
PCs. This company had maintained 24-hour operation. I started out
learning and operating an auto-dialer system and after several years I was
promoted to AS400 operator. FM Services was purchased by Payco American
and then acquired by OSI Holdings, Inc. OSI Holdings were converting from
the AS400 to their proprietary system and all of IT was being downsized.
Awards
Awarded employee of the year by Primary Financial Services in 2008
Awarded employee of the month by FM Services in August 1996
Education
Arizona Institute of Technology 1987 - Technology-based classes which were
primarily database / programming - related.
Phoenix College 1985 - 1987 - Two years of classes in integrated
technology.
Maryvale High School - Graduated 1985.