Developer Oracle

MARC THOMPSON

Franklin, Ohio *****

Email: *************@*********.*** Home: 513-***-****

Cellular: 513-***-****

SUMMARY

Experienced applications developer utilizing Oracle Developer 2000, PL/SQL,

Oracle Forms 6i, and Oracle Reports 6i in Windows and Unix environments.

Extensive background in IBM mainframe development with programming

languages including COBOL II, CICS, ADS/O, and PL1. Solid experience with

mainframe databases including IDMS, DB2, TOTAL, SUPRA, and IMS. Successful

track record in all phases of the system development lifecycle.

TECHNICAL ENVIRONMENTS

Platforms Programming Languages Databases

SPARC SUNW SunOS 5.10 PL/SQL ORACLE 11i

RS/6000 AIX Version 5 SQL ORACLE 9i

Sun E450 Solaris/Sun OS COBOL II SYBASE

HP 9000/800 HP/UX Command Level CICS DB2

HP 712/80 HP/UX ANSI C IDMS

AMDAHL 5995 MVS/ESA PL1 SUPRA

IBM 3090 MVS/XA ZPL (Zebra Label TOTAL

Printer)

Development Tools

ORACLE Developer 2000 ClearCase TSO/ISPF

ORACLE Forms 6i ClearQuest LIBRARIAN

ORACLE SQL Developer Subversion INTERTEST

TOAD (Quest Software) PVCS Knowledgeware ADW Case Tool

ORACLE SQL Plus HostExplorer CA-ENDEVOR

WebFOCUS Developer Studio HP SoftBench IDMS: OLM, DML/OnLine, OLQ

PROFESSIONAL EXPERIENCE

KFORCE, Miamisburg, Ohio 2009-Present

Oracle Developer

. Performed design, development and maintenance on the FIRST (Financial

Information Resource System) system in support of the USAF budgeting

cycle and standardization of budget business processes across all

component organizations. All work performed using PL/SQL, Oracle Forms

6i, and Oracle 11i database.

. Developed Functional and Technical Specifications documentation for

system enhancements.

. Developed new and maintained existing PL/SQL packages, procedures, and

functions.

. Developed and executed unit test plans for all developed code.

. Obtained Secret level Security Clearance

MARC THOMPSON

PAGE 2

MIKE ALBERT LEASING, Inc, Cincinnati, Ohio 2005-2009

Oracle Developer

. Performed new development and maintenance on BYNX WILLOW ERP system used

to manage a major auto leasing enterprise. All work performed using

PL/SQL with Oracle Forms 6i front end and Oracle 9i back end.

. Developed Functional and Technical Specifications documentation for

system enhancements.

. Developed new and maintained existing PL/SQL packages, procedures, and

functions.

. Performed some application tuning including conversion of complex views

to pipeline functions.

. Contributed to design of Business Requirements Document template.

. Participated in creation of Development Standards for Application

Development Group.

. Performed analysis and problem resolution for failing production

programs.

. Developed custom reports using IBI WebFOCUS Development Studio.

. Assisted User Acceptance testers with issue resolution.

. Assisted Quality Assurance Test group with test plan preparation and

execution.

HEALTHIER RESOURCES, INC., Matthews, North Carolina

2004-2005

Consultant

. Clients: Gap Direct, Inc., Columbus, Ohio

Nexcom Corp., Virginia Beach, Virginia

. Performed new development and maintenance on Retek's RDM Warehouse

Management product.

. PL/SQL utilized in the development of Oracle Forms 6i and Oracle

Reports 6i programs

. Developed Functional and Technical specifications for system

enhancements

TMP/HUDSON GLOBAL RESOURCES, Dallas, Texas 2003-2004

Consulting Systems Engineer

. Client: Retek, Inc., Minneapolis, Minnesota

. Worked on-site for Retek's client, The Gap Direct Inc., in Columbus,

Ohio in support of Retek's

RDM product.

. Designed, coded, tested, and implemented PL/SQL solutions in Oracle

Forms 6i programs

RETEK, INC., Cincinnati, Ohio 1999-2003

Retek provides an enterprise solution for the management of retail

business. The Cincinnati branch was responsible for the development and

maintenance of the RDM part of that solution utilized to manage major

distribution centers.

Employed by RETEK as a consultant (Professional Computer Consultants).

1999-2002

Employed by RETEK as a permanent employee. 2002-2003

MARC THOMPSON

PAGE 3

Software Engineer IV

. Solved unique business problems posed by clients that were not solved by

Retek's core RDM product and solved business problems that were

implemented as part of the successive releases of the RDM core product.

All programming performed using PL/SQL.

. PL/SQL utilized in the development of new and the redesign of existing

Oracle 6i Forms programs running in Windows and UNIX environments.

. Developed and maintained PL/SQL procedures, functions and packages

containing common code used by development teams in customized and core

versions of the RDM product

. PL/SQL utilized in the modifications to Oracle Reports 6i programs.

. Developed and maintained UNIX shell scripts to perform batch

functionality.

. Developed and maintained SQL scripts to perform batch functionality.

. Presented training to colleagues related to my RDM areas of expertise.

. Developed programs to print Receiving and Shipping labels on Zebra and

Datamax printers.

. Consistently met extremely aggressive schedules on large development

projects.

PROFESSIONAL COMPUTER CONSULTANTS, Middletown, Ohio 1997-2002

Senior Consultant

. Performed consulting work at several clients in Cincinnati, Ohio and

Florence, Kentucky. Client list includes Retek, Inc., General Electric

Aircraft Engines, Cincinnati Bell Information Systems, AAGIS, and Square

D Co..

. From 1997 through 1998, most assignments were performed in an IBM

Mainframe environment, utilizing the COBOL programming language with

IDMS, DB2, and IMS databases.

. From 1999 through 2002, assigned to Retek, Inc. See previous RETEK entry

for responsibilities.

GENERAL ELECTRIC AIRCRAFT ENGINES, Cincinnati, Ohio 1988-1997

Systems Analyst

. Served on team that developed a major system used by Engineering in the

design and development of aircraft engines. Met with users, documented

requirements, prepared detail program specifications, and developed

programs using COBOL, ADS/O, and IDMS. Assisted less experienced

programmers with coding and debugging. Researched malfunctioning

programs and prepared specifications for correction. IBM 3081 OS/MVS

and 3084 MVS/XA.

. Maintained a Document Management application that stored and retrieved

engineering drawings and changes in design. HP 712/80 series, UNIX, and C

environment.

. Developed programs using COBOL II, CICS and DB2 as part of team creating

a Labor Cost System used by Finance Department.

. Participated in Joint Application Design sessions, wrote Requirements

Documents, designed IDMS Database solution, and developed programs using

COBOL II, CICS, IDMS as part of team developing a Mass Properties System

used to control the weight of an aircraft engine through the design

process.

MARC THOMPSON

PAGE 4

CAP GEMINI AMERICA, Dayton, Ohio 1988

Systems Analyst

. Client: Standard Register, Dayton, Ohio

. Prepared detailed program specifications and developed programs using

COBOL, CICS, TOTAL, and SUPRA as member of project team responsible for

the development of a Business Form Inventory System and its interface

with existing Order Entry and Shipment Systems.

IBM 3090/180 MVS/XA.

EDUCATION

BS, Information Processing

University of Cincinnati, Cincinnati, Ohio

Graduated Magna cum Laude

Member Delta Mu Delta Scholastic Honor Society

Contact this candidate