Worked on design and development of major
HR application for Credit-Suisse, a worldwide
bank. All deliverables were made on time
or ahead of time. All defects discovered
by QA were corrected easily and system went
into production with minimum effort.details

Designed code changes which reduced run time
on an ETL process from 45 hours to 10 hours.

Developed database packages to control
transfer of data between development, test, and production
databases. Procedures were required to be able to pick up new
columns that were added to tables without code changes or recompilation.details

Helped get a large data warehouse project
back on schedule. Project had gotten behind schedule and when
brought in helped get the project back on schedule.details

Diagnosed and corrected numerous problems
in the revenue and cost reporting software
system to streamline the month-end close
process, resulting in a 60% reduction in
month-end run-time. details

Was a technical reviewer of the book "Oracle
Built-in Packages" by Steven Feuerstein, Charles Dye, and John
Beresniewicz, published by O'Reilly & Associates.

Served as the designer of the database as
well as the developer of the Resource Manager
Software portion of the automated telephone
circuit testing system, improving the efficiency
of the overall testing process. details

Led development for the GUI database interface
to the automated telephone circuits testing
system, allowing users to query and update
the circuit characteristics, view which
circuits
were currently reserved, schedule and reserve
circuits for later testing, and query and
update the generic database.details

Designed and developed a generic database,
enabling users to create tables of data
and
then query the contents of these tables.
details

Designed and developed a call-tracking system
for a telephone help-desk operation that
enabled monitoring of time from the customer's
initial call to when they got a callback,
tracked support reps' time on the phone,
and number of calls taken, and provided
customer
phone number lookup and call history browsing.
The system allowed problem descriptions
and
solutions to be harvested into a knowledge
database for further support use. details

PROFESSIONAL EXPERIENCE

(04/2006-present) Credit-Suisse (contract)

Member of team to design and build three HR applications. The most
comprehensive of these was a web based application where employee objectives
and ratings were managed. Employee objectives are set by employees and managers,
managers approve objectives and yearly, employees received ratings. All three
projects were released on a tight time schedule and all deliverables were met
on time. Defects discovered by QA were corrected very quickly and systems were
put into production with minimum effort. Tools used included TOAD, PL/SQL,
PL/SQL Developer, ERWin, MS Visual SourceSafe, SQL*Loader, and korn shell.
Subsequently charged with support of that same system. Also worked as lead
database designer for Awards system and Promotions nominations system.

(08/2005-01/2006) Red Prairie, Inc. (contract)

Responsible
for customer support for Red Prairie Digital
Logistix software. Duties included diagnosing
and documenting customer support issues,
including finding solutions and root causes.
Tools used included PL/SQL, SQL*Plus, korn
shell, and CRON scheduling.

(07/2005-08/2005) Böwe Bell+Howell (contract)

Responsible developing PL/SQL packages
for use in critical downtime report. Short term contract required that I become
familiar with a very complex system in a minimal timeframe. Tools used included
PL/SQL, TOAD, SQL, Crystal Reports, and Visual Basic.

(Dec. 2003-present) Glaxo SmithKlein (contract)

Responsible for support of Weekly Sales Reporting
system while developing replacement system. Replacement system used PL/SQL and
Unix shell scripts with Oracle database on Unix platform. Once development was
complete for replacement system, took over support of it. Responsible for ensuring
that reports were correct and delivered on time, troubleshooting problems, tuning to
improve performance, and answering user questions. Tools used: Unix shell scripting,
PL/SQL, SQL, Visual Basic, TOAD, and Excel.

(Oct. 2002-Aug. 2003) Capital One (contract)

Development DBA for Capstone, a credit
decision managing application. Responsible for implementing data
model changes in development and test databases. Also developed
software to allow audited insert, update, and delete functions for
selected tables. Developed methodology to ensure development and test
databases were kept in sync. Developed PL/SQL packages to control
transfer of data between development, test, and production
databases.

(Jul.-Sep. 2002) Royal & Sun Alliance (contract)

Responsible for writing ETL code using PL/SQL for
a major business insurance vendor. Brought in
when a large data warehouse project for tracking claim history had
fallen behind schedule. Code was implemented in PL/SQL stored
procedures grouped into packages. Project deadlines were met.

(Sep. 1997-Nov. 2000) Nortel Networks Corp. (contract/full time)

Development team design leader in developing a telephone switch configuration
database. Developer of all stored procedures and packages, which were extensively
used in the database. This was an Oracle database and most of the application
programs were written in Pro*C and the rest in Perl. Prime support person for
Product Profitability, a financial reporting system consolidating data from diverse
company segments into corporate financial reports. Duties included: making sure all
programs in the process ran correctly, finding the root cause and correcting
problems, tuning queries, making code changes to implement new features and correct
bugs as required, and tracking down causes of discrepancies in numbers between
Product Profitability and other systems. Code was written primarily in Pro*C with
lots of embedded PL/SQL. In addition there were some C++ programs and some straight
PL/SQL programs. Also responsible for designing queries to pull data from an Access
database into Oracle. Y2K team for same database, and responsible for almost all Y2K
C and PL/SQL code changes. Y2K team for another Nortel customer billing database,
responsible for C and PL/SQL code changes including changes to stored procedures,
also developing and implementing test plans.

(1995-1997) Insight Industries, Inc. (full time)

Software Engineer. Designed and developed database for use in
phone circuit testing reservation/scheduling system to run on HP-UX.
Database made extensive use of triggers and stored procedures. This
was an Oracle database. Application programs were Pro*C and C++. User
interface programs were created using Oracle Forms (Developer/2000).

(1974-1994) Burroughs/Unisys Corporation (full time)

Customer support for LINC on A_Series, UNIX,
PCs. Customer support for V_Series, DMSII
(Database Management System) and Data Communications.
Designed, developed, and implemented a Call
Tracking System. Supported all system software
for B1000. Participated in numerous benchmarks
and conversions