We provide IT Staff Augmentation Services!

Oracle Programmer

4.00/5 (Submit Your Rating)
Hire Now

QUALIFICATIONS

  • Accomplished Software Engineer with an extensive background in data conversion and migration into Oracle database systems.
  • Known for creatively maintaining and upgrading Mainframe code.
  • Considered a specialist in ensuring data integrity and accuracy.
  • Superior communications skills for effective interaction with business leaders and in making teams successful and productive.

COMPUTER SKILLS

Database Skills: TSO/ISPF, Oracle, IMS, SQL, SQL Plus, PL/SQL, DB2, Toad

Language/Utility: Informatica, Unix VI Editor, Micro-Focus COBOL, COBOL, COBOL II, JCL, Korn Shell, Easytrieve Plus, Roscoe, Librarian, Assembler, PL/1, File-Aid, Unix Tools, MS Excel, MS Access, Powerbuilder, Oracle Discoverer, Focus

PROFESSIONAL EXPERIENCE

Independent Contractor / Oracle Programmer
Confidential,Dayton, OH 2008-2009

  • Maintained overall company warehouse, sales and inventory software.
  • Wrote and modified Micro-Focus Cobol, Unix scripts (in Korn Shell) and PL/SQL utilizing Unix VI editor.
  • Introduced major upgrades to the system including the functionality to add, update and delete rows in Oracle tables.

Confidential,Cincinnati, OH and Southfield, MI 1997-2008
Oracle / Mainframe Programmer (2004-2008)

  • Created custom data files for customers.
  • Utilized Oracle, PL/SQL and SQL to convert Cobol, JCL and PL/I mainframe code to open systems. Most of the code was mainframe and this was a sizeable effort.
  • Accessed and manipulated data and coding in the open systems environment with Toad.
  • Supported and ran existing Cobol, Assembler, JCL and PL/I mainframe production applications.

Mainframe Programmer, Confidential, (2003-2004)

  • Received and processed vehicle sales and registration records from states and manufacturers.
  • Converted imported data into format suitable for COBOL, PL/1, and JCL environment.
  • Wrote SQL to monitor and enhance data integrity and accuracy.
  • Converted mainframe programs to open systems utilizing Informatica ETL.

Mainframe Programmer, Confidential, (1999-2003)

  • Maintained database of car and light truck registration data.
  • Created custom data files for Polk’s customers.
  • Designed finished files for work orders in a fast-paced operations department.
  • Utilized COBOL 2, PL/1, JCL, TSO/ISPF, Assembler and Focus.
  • Manipulated data with MS Access and Excel. Burned data to CD or DVD for shipment to customer.

Mainframe Programmer, Confidential, (1997-1999)

  • Charged with ensuring all Polk mainframe computer applications were Y2K-compliant. This was a demanding high profile position.
  • Collaborated with business owners of various computer systems.
  • Examined, tested and converted entire mainframe systems (COBOL 2, PL/1, JCL and TSO/ISPF).
  • Identified at-risk computer code with Platinum analysis tools and then instituted changes.
  • Tested individual programs in parallel utilizing File-Aid and other tools. Tested entire systems as well.
  • Ensured remediated computer systems were up to corporate standards.
  • Set up several systems in Polk’s automated scheduling system (Control-M).
  • Brought old JCL up to par.

Y2K Mainframe Programmer
Confidential,Cincinnati, OH 1997

  • Developed software in a TSO/ISPF environment.
  • Created a ‘bridge’ between Y2K-compliant and non-compliant mainframe IMS programs or between the programs and an IMS database, in online or batch.
  • Utilized COBOL IMS and Assembler.
  • Coordinated activities with team members located in other parts of the US as well as abroad.

Y2K Mainframe Programmer
Confidential,Cincinnati, OH 1996-1997

  • Maintained Membership and Billing systems in a TSO/ISPF mainframe environment.
  • Coded complex situations in COBOL IMS DB/DC. Periodically maintained and enhanced coding.
  • Supported system as an on-call resource and corrected issues which caused an abend.
  • Diagnosed and corrected issues in an online system that was used to find healthcare providers within a certain distance of an entered zip code.
  • Utilized “Strobe” to discover that a DB2 COBOL program called by the IMS COBOL program was timing out because of the way the SQL call was written.
  • Coordinated with business analyst and fixed SQL code issues.

EDUCATION

Bachelor of Business Administration, Computer Systems & Finance

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship