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