Oracle Forms, 6i, 10g, 11g

Michael Ivy

Oracle Certified Professional (OCP) Developer -2001

** ***** ****** ********* * – Augusta, Maine 312-***-****, *******@***.***

SUMMARY OF QUALIFICATIONS

• I am people oriented. Very adept at establishing and following standards. I am very

comfortable with SDLC concepts.

• I have managed a variety of projects, in-house and external resources, utilizing MS-

Project in most of my endeavors.

• I believe in interacting with systems in a regulated, formal manner. My preference is a

structured environment, with well documented standards.

• My communication style is a team player, who is willing to sacrifice. I am a teacher by

nature and appreciate brainstorming sessions. I have spent 3 years teaching computers at

the college level.

TECHNICAL SKILLS AND CERTIFICATIONS

Databases: ORACLE 11g, 10g, 9i, 8.i.x/8.x/7.x, Personal Oracle 7.3/8i, ALLBASE, DB2,

Access, Turbo Image

Operating Systems: AIX 6.1, HP-MPE, DOS, HP-UNIX, Windows 3x/95/98/2000/NT/XP/XP

Pro, Windows 7, Vista

Applications: Manufacturing, Governmental, Accounts Receivables, Accounts Payable,

General Ledger, Insurance, Donor, Housing, Music Retail

Languages: COBOL85, COBOL, Visual Basic, Visual dBase, SQL, PL/SQL Version

10.1.0.4.2 (Production), Java 2 Platform, Standard Edition, v 1.5

Tools: Toad, SQL Developer 3.2.09, BEA Workshop for WebLogic Platform

Version 9.2.1, Oracle Form Builder [32-bit] Forms[32 Bit] Version 10.1.2.0.2,

Oracle Enterprise Edition Release 9.2.07.0 – 64 bit Production,

JServer, ODBC, JDeveloper, Developer 2000, Java Server Pages (JSP)

Certifications: ORACLE CERTIFIED PROFESSIONAL (OCP) DEVELOPER TRACK 2001

1

PROFESSIONAL EXPERIENCE

Robert Half Technologies Chicago, IL 05/12 – 8/12

Consultant

• Transforming web-based XML files to work with Oracle database for a project with a

design development company and large food company. Used Oracle 11g to create and

manage tables, indexes, views, sequences, triggers to correspond to data from design

development’s environment. Included design documents and documentation.

Camelwalk Productions/Harmonious Technology Chicago, IL 05/01-09/03 then 09/03-Present

Consultant

• Redesign of data entry forms for utility contractor using Microsoft Office products.

• Development, design, implementation, test, analysis and support of an Oracle database

for Federal facility at USMEPCOM military operations, based in North Chicago, Illinois.

Projects include eSecurity and 10g and 11g upgrade.

Worked on new development and maintenance on system for processing and projecting

recruit activity, using Oracle Form Builder.

Worked as Developer/DBA on a Web-based, centrally-located system used to

create orders for fee basis providers at each of the 65 Military Exam Processing System

MEPS) posts, to facilitate MEPS and vendor communication regarding the provider

schedule, to schedule an appropriate number of fee-basis providers based upon projected

workload, and to provide reporting and monitoring tools to the HQ USMEPCOM.

Heavy usage of PL/SQL forms triggers to validate and process entrant activities.

Created a series of PL/SQL program units to create aggregate test data for 65 MEPS posts

for FBP system that provided scheduling for medical providers associated with

USMEPCOM.

Created prototype for client’s entry forms that were used for printing documents remotely

at various workstations at each detachment. Then I used SQL*Loader to convert to

Oracle tables. Created and manage tables, indexes, views, sequences, procedures, functions,

triggers in Oracle databases

Working as System Developer on Mainframe Application Migration, which include

converting existing programs and job streams to Oracle/AIX PL/SQL and scripts.

Development, database design, implementation, Unit Testing, support and analysis of an

Oracle database for DJ/Music History, while using JSP, MHTML, Oracle’s Developer 2000

Forms and Reports. Installed new versions of the ORACLE DBMS (8i, 9i, 10g, 11g), and

configure and reconfigure existing versions; install and configure Oracle Agent and Oracle client;

configure and maintain Oracle Net Services.

Created and administered user accounts, and create and manage control files, table spaces, data

files, redo logs, archive logs in Oracle.

2

Created and managed tables, indexes, views, synonyms, sequences, database links, packages,

procedures, functions, triggers in Oracle databases. Created and administered user accounts,

and create and manage control files, table spaces, data files, redo logs, archive logs on Oracle

RDBMS.

• Re-Engineered Oracle 8i Database converting it to Oracle 10g, including Data Modeling,

ERD, Database Design and implementation. Translated logical to physical database structures

using SQL*Loader. Database optimization, backup/recovery and tuning.

• Distributed work assignments to programmers. Assisted them in maximizing programming

techniques in PL/SQL and SQL. Provided training materials in SQL and PL/SQL to Oracle

programmers.

• Collaborated with the Black Metropolis Tourism Council in Chicago’s Bronzeville community

on a project that is affiliated with the Humanities Department of the University of Chicago.

This Project extracts from the Oracle Music database, data that is placed into HTML pages for

use on their website. Using MHTML pages.

Rebirth of Englewood CDC Chicago, IL 06/02 – 09/03

Director

• Responsibilities included strategic planning, staffing, site selection, program development,

equipment procurement, grant writing, employment placement and project monitoring.

• Directed staff of up to 10 employees in development of technical training and employment.

• Responsible for instituting the Bobby L. Rush Community Technology which includes

curriculum development for a number of technologies including Oracle, A+, CISCO, MSCSD,

etc.

The Huntington Group Memphis, TN 11/99 – 03/01

Consultant

• Development, design, implementation, test, analysis and support for LabCorp, based in

Durham, North Carolina.

• Developed a new tracking system for Vendor bonuses based on sales volume. Developed

tracking system for specific regional promotions tracking.

• Used HP3000 System.

• Provided user training and documentation.

• Development, design, implementation, test, analysis and support for Alcoa Aluminum,

based in Cressona, Pennsylvania.

• Developed a new, more flexible customer reserve system. A screen driven application

with two subprograms, which build and maintain new reserve programs.

• Used HP3000 System.

• Provided user training, support and documentation.

3

Butler Technology Schaumburg, IL 06/97-08/99

Consultant

• Development, design, implementation, test, analysis and support for First Penn Insurance,

based in Oakbrook, Illinois.

• Participated in a variety of new development and maintenance projects programming in

both on-line and batch settings.

• Converted from single policy to double policy holder systems.

• Reconstruction of the Annual Statements.

• Y2K windowing and conversion for both on-line and batch reports.

• Created utility programs that extracted, loaded and deleted individual agents.

• Created transmission file programs for agents to properly track sales commissions.

• Developed Surcharge Reporting to determine surrender dates for the Annuity System.

• Provided customer/user training and documentation.

•

Sentinel Technologies Downers Grove, IL 11/98-04/99

Consultant

• Development, design, implementation, test, analysis and support for consultant firm,

based in Downers Grove, Illinois, utilizing PL/SQL and SQL.

• Participated in a conversion project for the New York Transit Authority.

• Developed conversion programs from Wang platform to Oracle 8i/Unix platform, in the

Legal, Accounts Payable and Accounts Receivable areas.

• Provided maintenance for existing programs, troubleshooting and testing.

SPR Oakbrook, IL 09/96-06/97

Consultant

• Development, design, implementation, test, analysis and support for State Farm

Insurance, based in Bloomington, Illinois.

• Participated in Claims System redesign project, providing technical assistance in

planning, testing, coding and implementing Presentation and Update system for both Fire

and Auto insurance claims.

• Provided customer training and documentation.

Chicago Housing Authority Chicago, IL 04/96-09/96

Unit Manager

• Responsibilities included, strategic planning, staffing, bid negotiations, government

procurement and project monitoring.

• Directed staff of up to 12 employees in development of cultural and educational projects.

• I was responsible for instituting Adult Reading/Math and Computer Literacy Programs at

three Chicago Housing Authority locations.

4

LeClaireCourts RMC Chicago, IL 01/93-04/96

Homeownership Co-Ordinator

• Responsibilities included, strategic planning, staffing, bid negotiations, government

procurement and project monitoring.

• Organized, developed and staffed programs for the first Resident managed Public

Housing in Illinois, LeClaire Courts.

• Performed research and development in producing HUD’s HOPE I Home Ownership

Implementation Grant, Feasibility Study and Work Plan. Abovementioned activities led

to the design and initiation of a $20 million 5H Homeownership plan.

• I was responsible for instituting an on-site Adult Reading/Math and Computer Literacy

Programs.

Columbia College Chicago, IL 02/93-06/96

Adjunct Faculty

• Involved in teaching three (3) data processing courses in the Academic Computing

department at a private commuter college in the downtown area. Courseware consists of

word processing, operating systems, spreadsheets, databases, telecommunications and

graphic art packages. Course also provided historical/current event perspectives.

Wesley/Jessen Chicago, IL 08/89-01/1993

Systems Analyst/Project leader

• Development, design, implementation, test, analysis and support at this Fortune 150

owned eye care company, with responsibilities for providing information services to the

Sales and Marketing department.

• Managed staff of three while assisting in training initiatives.

• Maintained and created Powerhouse written Sales Reports using QUIZ, QTP and

QUICK.

• Participated in Sales and Marketing system redesign and conversion from Powerhouse

written applications to COBOL 85 and OMNIDEX.

• Provided strategy for downloading and uploading data from HP based systems to PC

based systems.

Stone Container Chicago, IL 05/86-08/89

Programmer Analyst/Project leader

• Development, design, implementation, test, analysis and support at this Fortune 100

company with responsibility to train and convert acquisition companies in financial based

applications, using a variety of COGNOS Powerhouse based applications.

• Also responsible for producing and maintaining cross platforms reporting from IBM

3090 system to the HP 960 system.

• Involved in conversion from CMS to MVS environment.

• Maintained and created Powerhouse written Sales Reports using QUIZ, QTP.

• Performed VSAM to DB2 monthly conversion processing.

• Responsible for maintaining Sales and Marketing, Profit & Loss monthly reports that

were directed to upper management

5

General Electric Barrington, IL 04/82-05/86

Analyst/Project leader

• Development, design, implementation, test, analysis and support at this Fortune 100

corporation.

• Planned, developed, tested, maintain on-line Collection system that resulted in

savings of $6 million.

• Planned, developed, maintained on-line Lease Message system that worked to allow

18 departments to communicate with each other company-wide.

Comsi, Inc. Oakbrook, IL 01/81-04/82

Consultant

• Development, design, implementation, test, analysis, support and technical assistance

for over 200 Naval staff and users in setup and operation of microcomputer system.

• Assisted in installation of Payroll/Personnel package at a variety of Naval

detachments.

• Generated an assortment of Sales reports for Senior Vice-President in regards to Steel

Manufacturing clients.

6

EDUCATION

MITS Schaumburg, IL 2009 and 2012

Oracle 11g DBA

DePaul University Chicago, IL 2007

Masters in Computer Science

DePaul University Chicago, IL 2007

Database Technologies Certificate Program

Computer System Institute Chicago, IL 2006

Database Developer

University of Illinois at Chicago Chicago, IL 1992

Masters in Urban Planning (final presentation incomplete)

Columbia College Chicago, IL 1979

Bachelor of Arts in Communications

PROFESSIONAL CERTIFICATIONS

ORACLE CERTIFIED PROFESSIONAL-DEVELOPER TRACK 2001

ORACLE CERTIFIED PROFESSIONAL-DBA TRACK (Completed 1 of 4 Exams) 2012

AWARDS/PHILANTROPHY

Al Weismann Scholarship Award, Columbia College 1979

HUD FELLOWSHIP AWARD, UNIVERSITY OF ILLINOIS AT CHICAGO 1990-1992

MAN OF THE YEAR, GUGGENHEIM’S MALE RESPONSIBILITY PROGRAM 1992

WALTER KAITZ FOUNDATION FELLOWSHIP 1996

DIVERSIFYING HIGHER EDUCATION FACULTY IN ILLINOIS FELLOWSHIP 2005

7

Contact this candidate