Resume'
John Palinski, OCP
 |
We only do consulting. No permanent job inquiries please.
|
BIOGRAPHY
 |
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 University.
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 articles. |
Certifications
Oracle Certified Professional Developer
Oracle Certified Associate DBA
Computer Proficiency
PL/SQL, SQL, Oracle Forms, Oracle Reports, Discoverer, Oracle Application Express, and Oracle and SQL Server database administration
Education
1989 - Master of Business Administration, Creighton
University
1981 - Bachelor of Science in Business Administration, University of
Nebraska at Omaha
1974 - Bachelor or Arts, University of Nebraska at Omaha
PROFESSIONAL EXPERIENCE
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
Division
• 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
trouble calls.
o Application that locates and displays aerial photos taken by the City of
Omaha.
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
project)
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)
Publications
Books
“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.
Teaching Background
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 Omaha
“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)