Jeffrey C. Hahne

P.O. Box 675
Strasburg, CO 80136

Phone: 303.915.0703
Email: jhahne@hotmail.com
Website: www.jeffreyhahne.com

Spire Systems

Oracle/Access Database Developer

8/04

1/05

Oracle 8i/9i Access 2000/97

VBA, SQL, Toad, Oracle Forms 6i, ODBC

Performed enhancement and maintenance on legacy systems as a consultant to Lawrence Livermore National Laboratory. Quickly analyzed the existing systems and identified significant improvement opportunities. Designed new database features data flows that improved reliability and data integrity while reducing maintenance requirements for the facilities tracking and purchasing systems. Developed PL/SQL packages and VBA modules. Tuned SQL to improve system performance. Revised Oracle Forms based UI meet new requirements and fix bugs.

Prairie Skies Technical Services

Web Site Database Developer

8/03

7/04

MySQL

PHP, HTML, PERL, SQL

Assisted in developing database driven web sites. Handled database design and dynamic web page development on real estate and ecommerce sites.

Truckload Management

Oracle Development DBA

3/01

8/03

Oracle 8, 8i, 9i

PL/SQL, SQL, OEM, Toad, Visio

Oracle Development DBA, on multi-million record, 3-tier web based and client/server applications for the transportation industry (document scanning, image retrieval, and Billing/Payroll workflow). Designed, scripted, and implemented 6 OLTP databases for new products including tables, foreign keys, triggers, packages, constraints, roles, and indexes.

Designed and developed PL/SQL procedures and packages to reduce embedded SQL and eliminate direct access to tables. This improved performance, enhanced security, and reduced the need for client/server product releases. Optimized SQL often improving performance by well over 100%. Helped developers redesign database intensive processes to improve use of indexes and reduce database load. Assisted in ETL implementations using SQL Loader and PL/SQL.

Planned, wrote scripts for, and performed data conversions as a result of product and database upgrades. Handled the migration of schemas between Development, QA, and Production. Acted as backup Production DBA on Oracle instances on Windows and Unix. Performed performance monitoring, tuning, and space management for 9 database instances on Windows and UNIX platforms.

Oracle

Principal Consultant (Oracle Developer)

3/99

12/00

Oracle 8, 8i

Oracle Designer, PL/SQL, SQL, Oracle Forms, Oracle Reports

South Dakota Job Service (SDWORKS) Engagement, 10/00 to 12/00. Analyzed existing forms and code to document requirements already implemented. Revised forms, with Oracle Forms 6i, to improve functionality and fix errors.

North Dakota Job Service (NDWORKS) Engagement, 8/00 to 9/00. Identified database, user interface, and functional changes required to implement Utah UWORKS in North Dakota. Identified scope and complexity of data interfaces required. Reviewed legacy RDBMS to identify requirements missed during JAD sessions.

Michigan Child Support Enforcement System, High Volume Assessment (CSES-HVA) Engagement, 9/99 to 8/00. Developed process models, functional hierarchy diagrams, system requirement documents, and

JAD meeting minutes. Performed as business analyst/scribe for Establishment, Location, Enforcement, Case Initiation, and Case Management JAD sessions.

One Stop Operating System (OSOS) Engagement, 8/99 to 9/99. Used Designer 6 to define modules and generate forms. Used Oracle Forms 6 to modify generated forms, develop object libraries, and develop template forms.

AT&T Undersea Network Admin (UNAD) Engagement, 5/99 to 7/99. Developed test scripts to verify software compliance with specification and test workflow handling. Performed end user testing on a major functional project area.

UCS Inc.

Sr. Software Engineer

10/96

2/99

Oracle 7

MS Visual C++

Developed and deployed pen-based software for ACE portion of NEMIS under contract to FEMA. System provided workflow and data collection capabilities to a disconnected work force on handheld computers. Designed and implemented the GUI, RDBMS, business and process logic.

Quark

Database Programmer

7/94

9/96

MS Access, Oracle 7

MS Access, SQL, PL/SQL, Oracle Forms and Reports

Designed and developed several client/server applications: Legal Document Management, IT Help Desk, and Product Information Guide. Designed and implemented IVR systems in the German, French, and UK offices. Provided support and enhancement for the Purchasing system. Performed requirements gathering and analysis for the BANDIT project (Customer database, Order Entry, Customer Service, Technical Support).

Oracle

7/8/8i/9i

Windows/Unix

5 years

4 years

2.5 years

MySQL

4

Unix

< 1 year

< 1 year

< 1 year

MS Access

2.0/97/2000

Windows

2.5 years

2 years

2 years

SQL Server

7/2000

Windows

Training

Mainstay (multidimensional)

1.0/2.0

DOS

4 years

4 years

3 years

PL/SQL

8/8i/9i

5

Windows/Unix

SQL

10+

Oracle Developer (Oracle Forms, Oracle Reports)

2000/6i

4

Windows/Unix

SQL *Plus

4

Windows/Unix

Oracle Enterprise Manager (OEM)

8/8i

2.5

Toad

1.5

Windows

SQL Loader

4

Windows

Oracle Import and Export

2.5

Windows/Unix

Oracle Designer

2.1/6

2

Windows

MS Access (Forms, Reports)

2.0/97/2000

3

Windows

Mainstay (Forms, Reports)

1/2

4

DOS

Visio

2003

8

Windows

PVCS (version control)

2

Windows

MKS (version control)

1

Windows

VBA

3

Windows

MS Visual C++

1.52/4.0

2

Windows

PHP

4/5

< 1

Windows/Unix

PERL

< 1

Unix

HTML

1

Java

Training

JavaScript

< 1

Unix Scripting

Korn shell

2

Sun

DOS Batch programming

5

DOS

XML

Training

Logical Database Design / Data Modeling

10+

Multidimensional Database Design

4

ETL and Data Conversions

4

Windows/Unix/DOS

Physical Database Design

10+

Entity Relationship Diagramming (ERD)

7

Business Analysis / Systems Analysis

10+