SUMMARY:

• Over 25 years’ experience as a Software Developer / Programmer with a broad range of computer expertise.
• Coded and tested Asset Suite Business Object programs using Business Object Workbench and Integration Framework Control Center.
• Coded and implemented PL/SQL database packages utilizing Oracle SQL Developer.
• Wrote Technical Design Documents and Test Scripts for Financial Transactions, Chart of Accounts and Time and Labor Asset Suite Integrations.
• Modified the appearance and behavior of the user interface (UI) provided by Foundation Architecture (FA) and Asset Suite pages using Compose for Asset Suite.
• Created new and modified existing Asset Suite panels using Analyst Workbench.
• Designed and developed database conversion load jobs using Oracle SQLPlus / DB2 Load Utility.
• Extracted data from Oracle tables and loaded into Mainframe files using Informatica.
• Designed and developed mainframe programs written in COBOL and EASYTRIEVE.
• Designed, coded and implemented Web applications utilizing JSP, Javascript and HTML.
• Performed project management duties including maintaining project plans, chairing implementation meetings and assigning job tasks on numerous projects.
• Strong background in writing SQL queries for DB2, SQL Server and Oracle databases.
• Performed application support including troubleshooting problems and assisting users.
• Developed client / server application in MS Access using MS Visual Basic for Applications - VBA.

RELEVANT SKILLS:

Programming Languages: COBOL, PL/SQL, VBA, JAVA, JavaScript, HTML and VBScript

Databases: DB2, Oracle and SQL Server

Operating Systems: UNIX, IBM Mainframe, Windows Server 2003 and Windows 7

Development Tools: Oracle SQL Developer, Compose for Asset Suite, Analyst Workbench, Programmer Workbench, Business Object Workbench, Integration Framework Control Center, Eclipse, Team Foundation Server, MS VBA Design, Animator, SPUFI/QMF, ISPF/PDF, File - AID, Informatica, EASYTRIEVE, MS Access, WebSphere, Dreamweaver

EXPERIENCE:

Confidential

Technical Analyst

Responsibilities:

• Added enhancements to VBA script used to Embed Documents that are loaded into Asset Suite BLOB table.
• Coded and Unit Tested Business Object COBOL program for Blanket PO and Contract Inbound Interface from GEP to Asset Suite.
• Applied bug fixes to PL/SQL database packages to resolve issues with Asset Suite Inbound / Outbound Interfaces.
• Developed and executed SQL Data Repairs against various Asset Suite tables to correct data that could not be changed via the Asset Suite application.
• Developed outbound interfaces from Asset Suite to Ariba for Contract Requisitions and Contract Change Requests.
• Developed Inbound Interface from Ariba to Asset Suite for Contracts.
• Designed and tested the Financial Transactions outbound interface from Asset Suite to WorkDay / PowerPlan.
• Designed and tested the Chart of Accounts and Time and Labor Inbound Interfaces from WorkDay / PowerPlan to Asset Suite.
• Assisted with Gap Analysis / Technical Assessments for Asset Suite upgrade to version 8.
• Applied Customizations to existing Asset Suite Panels using Analyst Workbench.
• Tailored existing Asset Suite FA Panels using Compose.
• Designed and developed new Asset Suite modules.
• Created procedures that extracted converted data from Oracle tables and loaded that data into existing Asset Suite DB2 tables.
• Developed and Executed DB2 SPUFI data fix scripts against Asset Suite tables.

Confidential

Software Engineer

Responsibilities:

• Designed, coded and tested COBOL batch programs.
• Coded Informatica Mappings / Workflows that extracted data from an Oracle database.
• Supported Oracle FLEXCUBE application for Multi-Currency transactions.

Confidential

Senior Software Engineer

Responsibilities:

• Developed and maintained COBOL programs for Safety and Compliance portion of Asset Suite product.
• Periodically performed code reviews to ensure modifications / enhancements conform to coding standards.

Confidential

Programmer / Analyst

Responsibilities:

• Designed, coded and tested COBOL / DB2 programs. Performed DB2 data migration. Converted data from one set of DB2 tables to a new set.

Confidential

Programmer Analyst / Software Engineer

Responsibilities:

• Designed, developed and maintained applications in mainframe, client/server and Web environments.
• Coded programs in COBOL II that accessed DB2 tables.
• Executed programs in batch environment utilizing JCL and PROCs.
• Utilized the following tools:ISPF/PDF, SDSF, QMF, PLATINUM, File-AID, EASYTRIEVE and ENDEVOR.
• Designed, coded and implemented applications in MS ACCESS and Lotus Notes.
• Also, supported an outside vendor software application that is written in VB and utilizes a SQL Server database.
• SQL Server Enterprise Manager (including Data Transformation Services), SQL Query Analyzer, Connect:Direct File Agent/Requestor, pcAnywhere and VB Script.
• Designed, coded and implemented applications in JAVA - JSP that utilize an Oracle database.
• Also, implemented and supported an outside vendor Web application written in VB - ASP that utilizes a SQL Server database.

Confidential

Programmer/Analyst

Responsibilities:

• Designed, developed and maintained Micro Focus COBOL programs in CICS OS/2 and UNIKIX environments.
• Developed Web front end for SupplyLink application using HTML and JavaScript.

Confidential

Programmer / Analyst

Responsibilities:

• Developed and implemented COBOL II / CICS programs.
• Converted VSAM file processing commands to DB2 embedded SQL statements in online and batch programs.
• Created various audit reports using EASYTRIEVE.