Oracle Developer

JASON A. CHAPMAN *************@*****.***

* **** ******* **** ****, Lake Wylie, South Carolina 29710 ~ 803-***-****

QUALIFICATIONS

Focused, energetic IT veteran with over fifteen years of experience in

developing custom enterprise-level solutions through the entirety of the

SDLC and five years experience guiding/mentoring staff through business

critical application design and development. Aggressively pursues

corporate vision and professional development by volunteering for

challenging, critical assignments. Always ready to assist and advise,

contributing to a warm atmosphere of productivity, teamwork, and

learning.

COMPUTER SKILLS

Languages: PL/SQL, SQL*Plus

16 years

Scripting (UNIX shell, JavaScript, DOS, Remote Plus

FFG) 7 years

Visual Basic, HTML, XML, Java, Pro*C, COBOL, BASIC

1 year

Database & Tools: Developer 2000 Forms 3 / 4 / 4.5 / 5 / 6i / 10g

14 years

PVCS, VSS, PL/SQL Developer, TOAD 11

years

Oracle Reports 2.5 / 3 / 6i / 10g, SQL Loader

9 years

Retek RMS 8.0.3/Manhattan WMS v.9

3 years

Oracle Application Express/HTML-DB 3.0/3.1

2 years

Oracle Financials/Inventory Applications 11.0.3, MS

Access 2 years

Oracle 8 & 9i, 9i Application Server, Designer 2000,

ERWIN 4 years

Crystal Reports 3

years

Platforms & OS's: DOS 6.0, Windows 95, 98, NT, 2000, XP

10 years

Novell, UNIX, AIX, SunOS, VMS/VAX, OS/2 v2.11

7 years

Software: Word, Excel, PowerPoint, PC Anywhere, Remote

Plus 4 years

Positions Held: Team Lead, Project Lead, User Interface

Architect

Senior Programmer Analyst, Senior Oracle Developer

PROFESSIONAL EXPERIENCE

Senior Oracle Developer

THE CATO CORPORATION, Charlotte, NC Nov 2007 - Present

. Reduce cost by designing front-end solutions using Oracle Apex to

replace vendor applications including claims, label printing and store

supply chain system; Train programming staff on use of Oracle Apex

tool

. Help lead conversion of Retek RMS backend from Oracle 8i to 10g

. Convert MS Access application to Oracle Application Express leveraging

Oracle external table, Javascript, AJAX technologies, implement Adobe

Reader .pdf reports using XO format

. Development and maintenance of Retek RMS application front-end and

bolt-on applications

. Created a custom Oracle Forms application to track hardware/software

configurations

. Develop and maintain Crystal reports

. Create and maintain Unix shell scripts, Pro*C modules, Perl scripts;

Provide 24 hr. 7 days a week support

. Create ETL processes to transfer store supply data from mainframe to

Oracle DB, conform Telecheck vendor data for insertion into Oracle DB

Advanced Programmer Analyst

AEGON USA, Cedar Rapids, IA Jul 2007 - Oct 2007

. Developed/maintained Oracle 10g/9i web forms

. Developed/maintained Visual Basic 6 application

. Responsible for on-going Technical Specification documentation

. Implemented solutions using DOS and WISE install scripting

JASON A. CHAPMAN

PAGE 2

PROFESSIONAL EXPERIENCE (Continued)

3 Programmer Analyst - Contractor

TEK SYSTEMS, Cedar Rapids, IA Mar 2007 - Jul 2007

. Develop/Maintain various PL/SQL solutions

. Tune and create complex SQL statements

. Facilitate build and compilation of source code to distribute to J2EE

environment

. Create Regular Expression formulas to validate user input

. Modify VB.Net applet to alter functionality

Oracle Forms Developer

GALLUP ORGANIZATION, Omaha, NE 2005 - 2007

. Developed Java solution for validation of XML CLOB input through

schema validation

. Implemented PL/SQL process to facilitate batch report data through

HTML email delivery

. Responsible for establishing XML output from SQL query using XSQL and

DBMS_XGEN and transferring using SFTP protocol

. Build complex forms/reports utilizing ref cursors, pipelined functions

and 9i PL/SQL collections

User Interface Architect/Team Lead/Project Lead

AI SOFTWARE SOLUTIONS, Omaha, NE 2001 - 2005

. Led functional and technical analysis and design of many enhancement

projects, including a switch from Oracle Forms 6.0 client/server point

of sale and AAA club membership applications to Oracle Forms 6i

Internet-based business model, utilizing full SDLC processes.

. Mentor and supervise developers through user requirements gathering,

business process documentation, functional and technical analysis &

design, provide estimates of time and costs relative to solution

recommended, development of ERD diagrams using ERWIN.

. Collaborate with senior management to devise project management

methodology, development standards and guidelines, implementation of

quality control procedures, unit testing and code signoff procedures.

. Exploit Java 1.2 functionality to develop solutions including

extensions for custom web form application, certificate key

functionality, and interaction with cash drawer hardware on client

machines.

. Led functional and technical analysis and design for inventory

enhancement project. Review and qualify development code of staff.

Create, modify and maintain 6i forms for custom web form application.

Interview candidates for employment.

. Install Oracle 9i Application Server on Windows 2000 server and

provide documentation to customer on installation instructions for

Oracle 9i Application Server.

Consultant - ConAgra

ANALYSTS INTERNATIONAL, Omaha, NE 2000 - 2001

. Design, document, develop, maintain, and implement custom Oracle

Forms, Reports and PL/SQL programs to interface custom applications

within Oracle Applications 11.0.300 including Oracle Financials GL and

AR modules and Inventory modules.

. Performed system administration setup to test modules, including

definition of concurrent manager programs, value sets, flex fields,

profiles, and security.

. Create Unix shell scripts to dynamically load data from text flat

files to Oracle 8.0 through SQL Loader.

. Developed and reviewed functional and technical designs for enterprise

solutions.

. Modified and tuned existing Oracle Reports and PL/SQL procedures for

greater efficiency and accuracy.

. Performed analysis, design, and development on a custom supply chain

management Oracle 5.0 forms and reports 3.0 application to be used

offline. Implemented PL/SQL packages and code to manage replication

from the client to the host database.

. Created and maintained installation scripts for client implementation

of supply chain management application. Analyzed shipping process of

orders in GEMMS to develop custom automatic shipping process and

inventory control.

JASON A. CHAPMAN

PAGE 3

PROFESSIONAL EXPERIENCE (Continued)

Consultant - Allstate Insurance Company

RENAISSANCE, Chicago, IL 1999 - 2000

. On-call to provide 24-hour weekday support of critical, high-profile

investments pricing application using Powerbuilder, PL/SQL Packages

and Unix scripted batch jobs, including documentation, analysis, and

enhancement recommendations.

. Monitored and enhanced scripted retrieval of remote stock market data

into company database.

. Assisted in executive information-gathering and decision-making,

interviewing and presenting to CEO and senior management to customize

data retrieval and presentation to reflect current business

environment and corporate priorities.

. Responded to business need through development of new stored

procedures, functions, database triggers, and additional tables in

Oracle 7.0 database.

Consultant

TUSC, Lombard, IL 1998 - 1999

. Contributed to in-house TUSC GUI Toolkit development through analysis,

recommendation, and coding of enhancements to library structure &

interfaces using Oracle Developer 2000.

. Supported sales and marketing efforts through design of an Internet

site outlining conversion project offerings and benefits.

Primary Projects:

. Village of Northbrook: Promoted staff development by conducting a 4-

week Developer 2000 training session; converted over 200 Oracle Forms

from 3.0 to 5.0 and 100 COBOL programs to Oracle 3.0 Reports.

. Caterpillar: Converted over 100 forms from 3.0 to 5.0 and 50 reports

from 1.0 to 3.0, as well as designing and developing custom forms &

reports using Developer 2000, and contributing to data schema analysis

& restructuring.

Senior Programmer Analyst

AEGON USA, Cedar Rapids, IA 1994 - 1998

. Chosen to lead Oracle Conversion project after isolating and

documenting data integrity issues with current database solution.

. Develop business process and function models, ERD diagrams using

Designer 2000.

Primary Projects:

. Oracle Conversion: Project Lead; Championed conversion from

prepackaged Telescript front-end / Foxpro back-end to Oracle based

business application utilizing Oracle Designer 2000, Oracle Forms 4.0

and Reports 1.2; managed in-house and outsourced developers;

collaborated with Vice President, managers, and users throughout

analysis and design.

. Remote Data Access: Main Data Structure Designer/Analyst;

Contributions included GUI interface and API calls for inter-

application communication using Visual Basic 5 and PL/SQL programming

for this project allowing mainframe access for sales associates

throughout the country.

. Roaming Agent Software: Analyst/Developer; Contributions included GUI

interface communication using Visual Basic 5 and MS Access database

for this project allowing sales agents to access/maintain customer

data remotely.

EDUCATION

Bachelor of Science - Computer Science, 1992

UNIVERSITY OF DUBUQUE, Dubuque, IA

Contact this candidate