John Palinski, OCP
Palinski instructor comments
John is an Oracle Certified Professional
Developer, an Oracle Certified Associate DBA, Oracle/software
engineering instructor and author. John is a graduate of the
University of Nebraska at Omaha and he has an MBA from Creighton
He is an experienced database administrator,
Oracle Forms/Reports/Discoverer/Apex developer with 20 years of
professional IT experience including extensive systems analysis and
project management experience. Combining outstanding organization
and technical skills, John is a frequent instructor in Oracle
Development products. John has also authored three database
development books and has dozens of published web and periodical
Oracle Certified Professional Developer
Oracle Certified Associate DBA
PL/SQL, SQL, Oracle Forms, Oracle Reports, Discoverer,
Oracle Application Express, and Oracle and SQL Server database
1989 - Master of Business Administration, Creighton
1981 - Bachelor of Science in Business Administration, University of
Nebraska at Omaha
1974 - Bachelor or Arts, University of Nebraska at Omaha
InfoUsa (2007 - Present)
Database administrator – Administers approximately 30
SQL Server instances and 20 Oracle instances. Developed a SQL Server
monitoring system for the 160+ SQL Server instances in the company. This
application brought InfoUsa SQL Server administration under control. Set up
the company’s RAC clusters and migrated database to the cluster database.
Omaha Public Power District (1974 – 2007)
(2004 – 2007) – Database administrator.
• Led an effort to design and develop an effective data warehouse with fewer
overall objects. I also developed a program for a sound data administration
program in OPPD’s data warehouse.
• Designed and developed the extraction, transformation, and load programs
for the first data warehouse star schema at OPPD.
(1986 – 2004) – Supervisor, Computer Applications in the Engineering
• Managed the development of all Engineering requested applications. Several
of these are:
o A surface mounted equipment inspection database using
.Net, Java, and palm pilots.
o Implementation of a corporate drawing viewing product.
o A Java Server Page based web system that documents and tracks substation
o Application that locates and displays aerial photos taken by the City of
o Managed and completed the upgrade, testing, and deployment of the T&D
Equipment system to Forms 4.5, 5.0, and 6.0
o Developed and implemented the Y2K contingency plan for various
construction oriented databases and systems.
o Managed and implemented the Paperless Workflow project. This was a
multi-year project that replaced paper maps with electronic replacements.
Part of this effort consisted of installing and training users on Byers Map
Viewer, a product to view maps.
o Managed/developed a transmission and distribution business area
construction budget system.
o Managed and implemented a project to supply OPPD’s cable locator
contractor with an electronic copy of GEMMS facilities. This eliminated the
need to create paper maps for the contractor and increased the number of
personnel using mobile PC’s.
o Managed the design, development, and implementation of the GEMMS
Streetlight inventory. A major portion of this project consisted of managing
the inventory of
o Managed and implemented Release 2b of the WMS Project. This consisted
mainly of the Fixed Asset module. (This was a multi year project)
o Managed and implemented Release 2 of the WMS Project. This consisted of
project tracking and work requesting modules. (This was a multi year
o Managed and implemented enhancements that allowed the Ft. Calhoun
Maintenance Planning area to create Bills-of-material using WMS.
o Managed and implemented Release 1 of the WMS Project. This consisted of
the Work Estimating and Word Design modules. (This was a multi year project)
“Oracle 9i Developer: Developing Web Applications with
Forms Builder“, Course Technology, expected publishing date March 2003.
“Practical SQL Handbook For Data Administrators, Business Analysts, and
Developers”, Addison Wesley, 2002.
“Oracle Database Construction Kit”, QUE, 1997.
Sixty-two published web and periodical articles.
Contract Trainer 1998 – Present - Courses taught: SQL, PL/SQL, Oracle
Forms, Oracle Discoverer, Oracle Application Express, Database Design
(Normal and Dimensional), DBA I, DBA II
Summer, 2000 – Fall, 2003 - Adjunct faculty – University of Nebraska at
“Overview of the System Development Lifecycle”
Fall, 1997 – Spring, 1999 - Adjunct faculty –
Iowa Western Community College
Introduction to the Oracle Database (3 credit hours)
Developing Applications With Oracle Forms (3 credit hours)