|
An accomplished Database Architect and Programmer with
demonstrated success designing and implementing database solutions possessing
a diversified technical background. Proven ability to implement technologies
to increase user performance and provide system automation and a passion for
data cleanup and conversion and legacy system maintenance and debugging.
|
|
|
Qualification
Highlights
|
|
Ř
Expertise creating order from chaos in data and
database architecture and systems.
|
|
Ř
Resourcefulness in problem solving and error
correction.
|
|
Ř
Expertise in full project life cycle development for
implementation and integration.
|
|
Ř
Polished leadership skills, with ability to motivate
teams.
|
|
Ř
Deep understanding of technology with focus on
delivering business systems.
|
|
|
Technical
Expertise
|
|
Languages
|
Web: Perl,
PHP, JavaScript/DHTML, VB Script (ASP), ASP.Net, C#, ADO, COM
Mainframe/Server:
C, C++, COBOL, RPG, PL/I, Unix shell scripting
PC:
VisualBasic, ActivePerl, PHP
|
|
Databases
|
Oracle including
PL/SQL and development tools, SQL Server, Sybase, DB2, Ingres, IDMS,
Informix, MySQL, Msql, Postgres, Access, Raima, LDAP
|
|
Operating Systems
|
DOS, Windows (NT, 95,
98, 2000, XP, 3.1), SunOS, Solaris, MacOS,
HP-UX, AIX, MVS, TSO, CICS, VM, Linux (various forms)
|
|
Other Technical Experience
|
Database Design and
Performance Tuning
Web Server setup and management (IIS & Apache)
Package Evaluation
Database Modeling
Tools
|
|
Professional
Experience
|
|
Volt Technology, Seattle WA
Systems Analyst @ Microsoft/MSNIA
|
December 2003
- December 2004
|
|
Created ASP
system monitors to be used in conjunction with SiteScope for monitoring
various MSNIA (MSN Internet Access) applications. Debugged data variances
and outlined required code changes required to correct data problems.
|
|
·
Designed and implanted ASP scripts to execute
client DLLs and evaluate results for system monitoring.
·
Designed Java custom monitors using the SiteScope
SDK.
·
Debugged problems with ASP.Net code and SQL Server
stored procedures to correct problems with data being written to the
various database systems.
·
Created Business Intelligence scorecard and
baselines for MSNIA data.
|
|
|
|
|
Meridian Technology Group, Portland, OR
Consultant
|
October 2003
– November 2003
|
|
A six-week
project to migrate databases to new hardware and software for NetIQ.
|
|
·
Documented existing databases
·
Created migration plan and scripts for databases
·
Implemented migrations during off hours
|
|
Washington Mutual, Seattle, WA
Business Data Analyst
|
February 2002
– May 2003
|
|
Created a new data team within the Consumer Lending
Division business division of Washington Mutual supporting the needs of the
business division by making data easily accessible in a format for easy
reporting. As part of the business division the team is more responsive to
user needs.
|
|
·
Designed, implemented and administered data server
utilizing SQL Server 2000 and Erwin 4.0 for the Consumer Lending Division.
·
Designed, implemented and administered web server
utilizing Microsoft IIS to use for final front-end data access using .Net.
Prototypes were done using Microsoft Access.
·
Documented data flows required for the business
division use and implemented data sharing processes with data sources
(including Oracle and DB2) utilizing server linkage and DTS
·
Architected automated data cleanup, migration and
reporting processes
·
Served as technical architect and lead on division
data projects
·
Created production data and database standards and
processes for the division
|
|
|
Shiplogix, Seattle, WA
DBA
|
August 2001 –
December 2001
|
|
Created new Perl/SQL processes for database extracts,
maintenance and reporting for SQL Server customer database. Maintained and
administered SQL Server customer database. Created a disaster recovery plan
that had not previously existed. Administered and maintained test databases
for the programming staff.
|
|
·
Administered production, test and development SQL
Server customer databases
·
Acted as data technical resource for the
organization
·
Documented database using Erwin 4.0 and IIS to
provide more information to Java developers
·
Created automated extract procedures to meet
customer needs
·
Managed and administered Oracle product database
·
Created and maintained LDAP data store for product
customization
|
|
|
|
Hammock Consulting Services, Renton, WA
President
|
April 1997 –
July 2002
|
|
Served as a technical lead, data architect,
programmer and team management for client mission critical database
projects. Clients included AT&T Wireless, Cobalt Group, cti, Digital
Eve, Dream Factory Books, Microsoft, N2H2, NOAA, Watchguard
|
|
·
Designed, created and administered Oracle 7, Oracle
8i, SQL Server 6, SQL Server 6.5, SQL Server 7, SQL Server 2000, MySQL,
msql databases
·
Created data access and maintenance programs and
scripts for Oracle, SQL Server, Sybase, MySQL, msql databases
·
Installed, maintained, and administered IIS and
Apache web servers
·
Installed, maintained, and administered Solaris,
Linux and Microsoft systems
·
Created and maintained web front end code utilizing
JavaScript, DHTML, VBScript and CSS
·
Created and maintained web back end code utilizing
Perl, PHP, ASP/VBScript
·
Familiarity with Solaris and Linux Package
management systems
·
Programmed automated processes utilizing Informix
database and Acrobat SDK
·
Trained and mentored junior programmers
·
Provided project and team management on larger
projects
|
|
|
|
EC Direct, Seattle, WA
Senior Database Engineer
|
October 1998
– March 1999
|
|
Served as the database administrator and architect
for the SQL Server e-commerce database. EC Direct created shopping cart
software and the database included various aspects of the consumer
transaction.
|
|
·
Architected, implemented and administered the first
production version of the customer database in SQL Server
·
Designed middle-tier programming and database layer
to reduce the knowledge the programmers needed for the database and to
simplify database maintenance
·
Supported test databases for the development team
·
Created database standards
|
|
|
|
Adobe Systems, Seattle, WA
Business Systems Analyst
|
July 1996 –
April 1997
|
|
Created various database driven web sites for
customer support that provided search capability and support to data that
was unavailable via the interface.
|
|
·
Provided legacy system integration via the web for
Informix and Oracle data
·
Apache Server Installation and Maintenance
·
Created scripts utilizing Perl to reformat, cleanse
and display customer data
·
Installed and maintained Solaris system and
packages
|
|
|
|
|
Multicom Publishing, Seattle, WA
Database Specialist
|
September
1995 - May 1996
|
|
Worked with a team to build CD-ROM based cookbook
titles including The Best of Food and Wine, Cooking for Today (4
Titles - Chicken, Vegetarian, Stir-Fries, Pasta), Better Homes and
Gardens New Dieter’s Cook Book, and Better Homes and Garden’s
Healthy Cooking Deluxe.
|
|
·
Created data parsing routines to transform recipe
data to SGML format
·
Designed routines to intelligently parse ingredients
for recipe scaling and to learn from the data
·
Architecture and implementation of databases on the
CD-ROMs
·
Implementation of internal databases to data
cleansing
·
Scripted data access within the titles
·
Steam lined data build processes
|
|
|
|
Solutions for Government, Burnaby, BC, Canada
Database Specialist
|
March 1995 –
July 1995
|
|
Provided programming support of accounting software
package.
|
|
·
Maintained existing Cobol/Informix code base
·
Assisted Unix System Administrator as needed
|
|
|
|
Lexis/Nexis, Dayton, OH
Lead Software Engineer
|
May 1990 –
January 1995
|
|
Lexis/Nexis is an original online database provider
of legal, news, medical and patent data. Worked with teams to ensure the
data was on-line on time for customers throughout the world.
|
|
·
Worked as a 24x7 maintenance engineer to correct
problems as they arose within the data receiving, parsing, and upload
processes on Mainframe and Unix Systems
·
Provided integration and maintenance of mission
critical data processes for Lexis/Nexis online database system
·
Created automation procedures and parsing routines
to identify potential data problems
·
Lead a project to migrate source code from three
source code management systems to one system
·
Did maintenance programming, developing excellent
debugging skills, for many languages including C, C++, PL/I, Assembler, RPF
·
Programmed templates for developer use on new
generation system utilizing C++ with OODCE
·
Created build procedures to support HP-UX and
Solaris integrated systems
·
Created databases using Ingres, Sybase and Access
|
|
|
|
Prior Experience Available Upon Request
|
|
Education
|
|
University of Phoenix Online
Master of Science
Major: Computer Information Systems
|
September
1998 – June 2002
|
|
|
|
Loyola University Chicago, Mundelein College
Continuing Education - Java
|
September
2001 – December 2001
|
|
|
|
University of Dayton School of Law
Personal interest in the study of law
|
August 1993 –
July 1994
|
|
|
|
Sinclair Community College
Continuing Education – C and Unix Scripting
|
January 1992
– March 1992
|
|
|
|
Findlay College/University of Findlay
Bachelor of Arts
Major: Business Systems Analysis
|
June 1985 –
May 1987
|
|
|
|
Lima Technical College/James A. Rhodes State
College
Associate of Applied Science
Major: Data Processing
|
June 1983 –
June 1985
|
|
|
|
|
Teaching
Experience
|
|
Seattle Central Community College
·
Web Development/JavaScript
·
Web Programming with Databases
|
|
Almatech (including courseware creation)
·
JavaScript
·
XML
|
|
South Seattle Community College
·
Intermediate Web Development
·
Advanced Web Development
|
|
Other
Accomplishments
|
|
·
Programmer team management encouraging
brainstorming and creative approaches to enhance team members and the
project
·
Ownership of the overall quality, scalability,
consistency, cost, integration, maintainability and timeliness of mission
critical projects
·
Creation of problem tracking and development queue
systems to best utilize group resources
·
Management of consulting firm and subcontractors
·
Large scale project integration and cross
functional communication
·
Seattle Webgrrl of the Year 2000
|
|