PENNY S. KOSCIUSKO

**** *. ****** ******

Prescott, AZ 86303

760-***-****

Professional Skills and Experience

PSK Solutions

May 19, 1998 – December 18, 2013

Sole Proprietor/Consultant

Contract position with Imperial Irrigation District in Imperial, California. Provided Oracle

Database Administration and Application development in a data warehouse environment.

Designed, developed and implemented several custom Windows based Client/Server

applications as required using various Oracle Developer tool sets and PL/SQL. Developed

numerous custom reports using Oracle Reports and Graphs and Crystal Reports. Created and

maintained batch processes using Unix scripts and PL/SQL. Imported and maintained historical

data from legacy systems into the data warehouse and developed user interfaces to this data.

Designed, developed and implemented a customer tracking system in compliance with the

Federal Safe Drinking Water Act. Performed several database upgrades from Oracle v7.1.1 on

an SCO Unix platform to Oracle v9.2 on Sun Solaris 5.9. Assisted the client in the selection,

installation and configuration of a new land management application system (Govern) utilizing

Oracle for the back end. Provided Oracle support and training (SQL) to client staff. Assisted

client with ad-hoc queries and SQL tuning.

Embry-Riddle Aeronautical University

February 28, 1996 – April 26, 1998

Systems Analyst

Maintained legacy Financial Aid system (SAFERS) written primarily in COBOL on an HP 3000

mini computer environment running MPE. Worked closely with F.A. technical liaison to design,

develop and implement custom applications on this platform using COGNOS Powerhouse

development tools. Began beta testing Datatel, Inc. new multi-location functionality of its

Colleague v. 14.0 integrated student system in 1996. Completed data conversion from the legacy

Financial Aid system and the migration of the remaining student system data from Colleague

12.8 to Datatel’s new Colleague product v. 14.1 in the Unidata database environment on

December 1, 1997. At the same time, migrated from an HP 9000 platform running HP Unix to

an IBM RS/6000 model F50 running AIX 4.3. Design, develop and implement new custom

applications utilizing Datatel’s Envision CASE tool set and UniBasic. One of five founding

members of the University’s first IT Council. The primary goal of the Council was to improve

communication both within the Department and externally to the University community.

Computer Professionals, Inc.

February 5, 1996 - February 16, 1996

Oracle Consultant

Two week Oracle DBA contract to upgrade and tune customer’s Oracle database to version 7.1

in a Unix environment. Customer was a technical support hotline operating 7 days per week, 24

hours per day.

Imperial Irrigation District

November 1978 - January 26, 1996

Programmer/Analyst

October 1989 - January 1996

Project Leader for the installation and development of an Oracle v7.1 Data Warehouse. Worked

with Oracle consultant to: 1) Install Oracle v7.1 RDBMS on an SCO Unix server. 2) Used

CASE methodology to design and implement the data warehouse. 3) Developed Client/Server

applications under Windows 3.1 using SQL*Plus, PL/SQL, Forms 4.5, Reports 2.5 and Graphics

2.5. 4) Performed Oracle DBA responsibilities including file system and tablespace

management, monitored database segmentation, performance monitoring and tuning, managed

user accounts, monitored database access and security and database backup and recovery. 5)

Developed and implemented methodologies to access data from the legacy systems.

Supervised Computer Services staff of three. Responsible for all Local Area Network and Wide

Area Network services and support for 100 pc’s in five Novell 3.1 and 3.12 networks. Service

and support included purchase, installation, configuration, maintenance, help desk and training

for all pc hardware and software. Acted as liaison between my Departments’ Managers to

assimilate data required for decision support.

Performed System Administration duties on an IBM RS/6000 Model 530 running ESRI Arc/Info

under AIX and also on a Prime 9755 running Medusa and Info under PRIMOS.

Engineering Technician, Engineering Aide, Drafting Technician, Clerical Technician

November 1978 - October 1989

Worked in the Engineering section of the Water Department. Automated engineering data and

records through various pc based applications. Assisted engineers by writing custom programs

in Fortran and Basic as per their specifications. Assisted users to determine best pc solution for

their needs. Trained users on various desktop office applications.

Responsible for all Department disaster damage assessment and recovery documentation.

Assisted FEMA representatives during the audit stage of disaster recovery.

Acted as on-site clerical coordinator and assisted with inspections during the construction of two

hydroelectric plants between April 1983 and August 1984.

Penny’s Promotional Products

Sole Proprietor

1982 - 1995

My husband and I started this business in 1982 as distributors of Garland pens. Immediately

after, we purchased a computerized engraver and added trophies, plaques and miscellaneous

engravables to our line of products.

Hardware Environments

• Intel Based PC’s

• IBM RS/6000 Model 530, F50

• HP 3000

• HP 9000

• Sun Sparcstation 1

• Sun E3500 RISC

• Prime 9755

Software Environments

Windows 98/ Microsoft Office, Oracle Enterprise Manager, Oracle Developer Server,

NT/2000/XP/ Oracle Developer 6i, Oracle Forms 4.5, Oracle Reports 2.5, Oracle

Windows 7 Graphics 2.5, CASE 5.1, SQL*Plus, PL/SQL, SQL*Net,

Oracle Designer 2000, Toad for Oracle, Toad for SQL Server,

Crystal Reports, Word Perfect, Professional Write, Lotus 123, Symphony,

Quatro Pro, dBASE, Harvard Graphics, Autocad, Microsoft Project,

Netscape, Frontier PC/NFS, Client Access (AS/400 Query), WRQ

Reflections, Reflections 5.20, Lotus cc:Mail, Netscape Mail, Lotus

Smartsuite

Novell v3.1 Installation, Configuration, Administration and Support, IPX/SPX

SCO Unix Oracle v7.1 RDBMS, SQL*DBA, SQL*Net, SQL*Plus, PL/SQL,

TCP/IP, NFS

Solaris 2.7 Oracle v8.1.5, Oracle v.9.2.6, Net8, Soltice Backup 5.1, Veritas Volume

Through 5.9 Manager, TCP/IP, Telnet, NFS, FTP, vi

HP Unix 9.04 TCP/IP, NFS, FTP, Unidata 3.3.2, Colleague 12.8, VI, ED

MPE, MPEX COGNOS Powerhouse tool set, TCP/IP, FTP

AIX 4 Unidata 3.3.2, Colleague 14.1, vi, ED, FTP, Envision 4.3

AIX/6000 System Administration, TCP/IP, NIS, NFS, DNS

SUN OS System Administration, TCP/IP, NFS

PRIMOS System Administration, Medusa Administration, TCP/IP, NFS

Programming Languages

PL/SQL, C, FORTRAN, COBOL, BASIC, ENVISION

Professional Training

Oracle Corporation:

Introduction to Oracle Complex Data Models

Develop Complex Queries Analyze Systems Requirements

Administer the Oracle7 Database I Design Relational Systems

Administer the Oracle7 Database II Implement Systems using CASE 5.1

Tune and Troubleshoot Oracle7 Generate Systems using CASE 5.1

Oracle Reports 2.5 Oracle Forms 4.5

Oracle Graphics 2.5

Wave Technologies

Novell Netware 3.1 System Administration

IBM

AIX/6000 System Administration

AIX/6000 Network Services, NFS, DNS, NIS

AIX/6000 Networking TCP/IP

Environmental Systems Research Institute

Introduction to Arc/Info

Prime

Medusa Administration

PRIMOS System Administration

Professional Awards and Certificates

Computer Science Certificate- Arizona Western College, September 1989

Distinguished Service, Employee of the Month, I.I.D., June 1988

Outstanding Student, Business Division - Imperial Valley College, May 1988

Outstanding Performance, On-Site Clerical Coordinator, I.I.D., December 1984

Netware 386 Administration, March 1991

Oracle Master, CDE Designer/Developer, CASE v5.1, October 1995

Oracle Master, Database Administrator, Oracle7, October 1995

Letter of Recognition, ERAU, I.T. Department, June 1997

Memberships and Affiliations

San Diego Oracle User’s Group

International Oracle User’s Group

References

Available upon request.

Contact this candidate