Computer Consultant Cobol
Resume:
Ron Ende
Halfmoon, NY *****
e-mail: ********@*****.***
Summary
I have worked in the IS field for over 20 years. My experience includes working as an Applications Programmer, System Designer, Systems Analyst, SQL Developer and some Database Administration work.
Certifications
Comp TIA XK0-002 LINUX+
Oracle 1Z0-007 Introduction to Oracle9i: SQL - 948
Oracle 1Z0-042 Oracle Database10g: Administration I
Oracle 1Z0-043 Oracle Database10g: Administration II
Education
Associates Program in Data Processing
Lakeland Community College, Mentor, Ohio
Work Experience
Computer Consultant
Software People Inc.
New York ITS Contractor 01/2018 – Present
Currently working on the SNAP E&T DATA GRANT PROJECT.
Used Oracle SQL and PL/SQL to update and maintain the ORACLE tables.
Wrote Micro Focus COBOL programs to edit data and load to the ORACLE tables.
These tables are used to add up data for federal SNAP reporting.
The Cleveland Plain Dealer
Senior Application Support Developer / Analyst 08/2014 – 08/2017
Worked with the Circulation System, which consists of adding new subscribers and when subscribers go on vacation or cancel their subscriptions, Starts/Stops.
The system is written in Micro Focus COBOL, running on a UNIX operating system.
Used Oracle SQL and PL/SQL to access the ORACLE tables.
Created extract programs to FTP (File Transfer Protocol) data to newspaper partners, Akron Beacon Journal, the Wall Street Journal etc.
Created load programs to load subscribers from third party marking firms.
Resume of Ron Ende Page Two
MediQuant, Inc.
Database Developer / Data Modeler 07/2013 – 05/2014
Used ETL (Extract, Transform, and Load) to migrate data into MediQuant Databases.
Manipulated data from a wide variety of client’s information format into the MediQuant data structure.
Created SQL scripts to create, modify and populate SQL Server databases.
Created and used stored procedures and functions to manipulate data.
Created and maintained statistical information on created databases.
Worked closely with our clients in resolving issues that may present themselves.
Computer Consultant
K-Force Consulting
Visiting Nurses Association 12/2012 – 05/2013
Worked as Senior Programmer Analyst on Microsoft SQL Server.
Write SQL Statements to insert/update/delete rows/columns in the Database Tables.
Worked on and updated SQL Server Manager/Scheduler (Runs night jobs).
Exposure to SSIS, SSRS and Crystal Reports.
Worked with the Horizon Homecare and Hospice system, a patient tracking system.
Met with users to resolve issues with the Horizon Homecare and Hospice Nursing System.
Computer Consultant
Solar Systems Consulting
Cleveland Division of Water 05/2011 – 06/2012
Worked with Oracle’s CC&B (Customer Care and Billing) Package.
Coordinated with programming staff on enhancements and updates.
Wrote and ran SQL scripts for reports.
Met with managers for CC&B system review and modifications.
Analyzed COBOL programs for enhancements.
Computer Consultant
Oxford & associates
Goodyear 08/2009 - 02/2011
Used UNIX as the operating system on the AS/400.
Converted COBOL programs from an IBM Mainframe to run on an AS/400.
Wrote JSP (Java Server Web Pages) to run on an AS/400.
Object Oriented Design was used when developing the JAVA web pages.
Programmed in Oracle SQL and PL/SQL to access Oracle 10g DBMS.
Resume of Ron Ende Page Three
Computer Consultant
MODIS Consulting Company
Sterling Jewelers 01/2007 – 02/2009
Used UNIX as the operating system on a HP3000.
Converted systems written in LINKS code into Micro Focus COBOL programs.
Converted systems using LINKS databases into ORACLE DBMS databases.
Programmed in Oracle SQL and PL/SQL to access the ORACLE databases.
Established triggers and stored procedures for ORACLE databases.
Contact this candidate