Donald E Koller
**************@*****.*** 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