Donald E Koller

adw9zj@r.postjobfree.com 330-***-**** www.linkedin.com/in/DonaldKoller

Cuyahoga Falls, Ohio (open to remote opportunities)

IT Technical and Business Analyst (programmer)

Driving Maximum Business Value with Mission-Critical Systems, Software, and Support

Qualified IT Technical Analyst with a master level of experience in developing and implementing IBM mainframe accounting application systems. Extensive experience working with end-users to design, develop and support the business and reporting needs for manufacturers. Adept at building interfaces for loading and retrieving data between mainframe and server-based systems.

Technical Skills:

COBOL

IBM Mainframe

Microsoft Office Suite

VSAM

TELON

Syncsort

z/OS JCL

CA7/CA11

SharePoint

IBM IMS databases

ESP

Endeavor

DB2/SQL

Xpeditor

DLI (Data Language 1)

CICS

MVS/TSO/ISPF

BMP (Batch Messaging Processing) mode

Systems Supported:

COBOL Application Systems

North America General Ledger System

North America Budgeting System

Accounts Payable

Accounts Receivable (CARMS)

Fixed Asset and Project Accounting (IVIS)

Consolidation System (CONSCO)

Order and Shipping System

Taxware

Goodyear Retail Business Management System (GBMS) – (A point of sales System)

Goodyear Dealer Accounting System (DAS)

Goodyear Wholesale Billing

Other Systems

Global Expense Reporting System (GERS)

Global Expense Reporting System (Concur)

General Ledger Reconciliation (Blackline)

Global Financial Consolidation System (SAP Finance BFC)

Telecom Expense Management (TEM)

Professional Experience

INNOSOURCE (GOODYEAR TIRE RUBBER COMPANY in OHIO) 2016 – Present

IT Technical Analyst (COBOL Developer)

Member of the Run Team with the responsibilities of maintaining all Goodyear’s legacy mainframe (COBOL) applications: Wholesale Billing, Goodyear Retail Business Management System (GBMS), and Dealer Accounting System (DAS).

Troubleshooting and solving issues in a timely manner to ensure a successful monthly business cycle.

Assisted the accounting department with analysis, research, and correction of any accounting issues (invoices and taxes).

Monitored and assisted with the monthly and yearly closing cycle for the Retail application system.

Researched and documented the legacy Wholesale Billing system to assist with the retirement of the application.

Assisted with decommissioning of the GBMS and DAS applications.

Assisted Goodyear’s clients with the understanding of the mainframe applications and the data.

Created automatic processes for the mainframe to reduce manual processes and improved accuracy.

Provided after-hours support for all the mainframe applications.

PARKER HANNIFIN in OH 2002 – 2016

IT Tech Analyst (COBOL Developer) 2004-2016

Responsibilities include maintaining the legacy mainframe (COBOL) applications for General Ledger, Fixed Asset & Property Management. Also, provided secondary support for Accounts Receivable, Credit Collection, and Accounts Payable applications.

Key Projects and Impact:

Created processes for loading data to and from COBOL applications to other platform applications:

oGlobal Travel & Expense Reporting System (Concur)

oGeneral Ledger Reconciliation System (Blackline) for North American

oGlobal Travel & Expense Reporting System (GERS)

Project Leader: Mentoring college graduates with the creation of GUI North American POL Ledger Reporting System.

Assisted the tax department and auditors with various tax-related needs. This includes the balancing of data records in the Ledger system. I also helped with the sub-systems that loaded data into the ledger. This included several feeds from General Ledger, Accounts Payable, Accounts Receivable, and Fixed Assets into the General Ledger Reconciliation System.

Responsible for transferring historical data from the legacy mainframe CONSCO application system into the new SAP Finance BFC consolidation system. Created a new monthly interface from the North America General Ledger to SAP. This resulted in decommissioning of a legacy COBOL application system.

Assisted with creating a GUI interface for the Fixed Asset application system. I created new government reports and files for the tax department. Conducted team cross-training on all the Accounting Systems. Created DB2 shadow files from various sub-systems to balance the data records in the General Ledger system.

Sr Technical Analyst (COBOL Developer) 2003 - 2004

Became solely responsible for maintaining the Fixed Asset (COBOL) applications.

Completed various process improvements to eliminate manual intervention and improve data accuracy.

oRewrote the General Ledger year-end and monthly process to eliminate manual intervention.

oCreated a mass update process to load assets from acquisition into the Fixed Asset application system.

Outsource projects.

oPerformed upgrades on the North America General Ledger system to handle the needs of a $10 billion company.

oManaged several outsource projects, such as the Exchange Rates application system. The application was used for a one-stop entry system to update exchange rates for several mainframes and server-based systems. This in turn helped to reduce manual processes and improved accuracy.

Technical Analyst I (COBOL Developer) 2002 - 2003

Became solely responsible for maintaining several legacy (COBOL) applications:

oGeneral Ledger, CONSCO (a Consolidation application), and Order and Shipping.

Developed an audit trail application system for tracking journal vouchers entered in General Ledger. This allowed for better traceability of data in the ledger for auditors and government agencies.

Made significant enhancements to the Budget system for departments to improve next year’s budget forecast.

Assisted with creating DB2 shadow files from IMS database and VSAM files. Shadow files were then used as tools for Real-Time reporting. I also wrote several new COBOL TELON and batch programs using SQL to create accounting reports like Balance Sheet, Income Statements, Account Balances and Departmental Budget Reports.

Created TELON Programs to download data from the mainframe into Excel to give the accountants better analytical tools.

Education

Bachelor of Science in Industrial Management (with an Associate degree in IT) from University of Akron, Ohio

Associate Degree in ACCOUNTING GRADUATED from Stark State College, North Canton Ohio

Contact this candidate