Resume 15

Contract, technical lead position requiring extensive knowledge of Oracle database systems, strong analysis and design skills, excellent communication skills clients, developers, customers, etc , with proven record of getting jobs done right even under tight time and/or budget constraints. Willing to travel, work long hours.

Over eighteen years of database architecture/administration experience, fifteen years Oracle. Additional, extensive expertise in physical/logical modeling, data warehousing, project management, performance tuning, application architecture/coding, legacy system integration/migration, data replication and transformation ETL , documentation and training/mentoring. Have worked on both internal and commercial software development efforts in commercial/Internet, industrial and government environments.

Oracle 9i,8i,8,7,6, Oracle Enterprise Manager, ERWin, Designer/2000, PL/SQL, Stored Packages/Procedures/Table Triggers/View Triggers, Developer/2000 Ver. 6, 2.1, 1.4,etc. , export/import, SQL*Loader, database links/Oracle Gateway products, C, Pro*C, Pro*Fortan, Unix Sun/Solaris, Sun/SCO, HP, Compaq/DEC , Win 2000/NT/Me, Business Objects Designer/Reporter

Project: Develop two Internet portals J2EE/Weblogic for medical supply company client allowing medical facilities to place orders via online catalog, with real time order tracking currently producing over a million dollars in revenue per month . Also provide client with database expertise on existing OLTP and OLAP systems tuning, backup/recovery, partitioning, etc. as well as mentor their DBA staff.

Position: Senior/Lead DBA, Data Architect

• Designed/deployed two Oracle 9i/8i databases to support two different portal based on-line ordering systems with extensive interfaces to two existing JD Edwards ordering systems one JDE Oracle, other DB2 , interface used materialized views snapshots /database links/distributed transactions/Oracle DB2 Gateway product.
• Made heavy use of the ERWin design tool to produce logical and physical models with install and upgrade scripts.
• Designed and coded several major stored package/procedures/trigger systems consisting of a pricing engine, order submitter, full order tracking, co-branding support and a universal error handler.
• Heavily assisted in requirements gathering, client interaction, user interface design and project management.
• Designed/implemented data mart, extensive ETL routines and table-partitioning system for data warehouse.
• Tuned/rewrote existing queries in multiple existing systems.
• Designed/developed entire portal catalog maintenance system Developer/2000 including image/BLOB database storage, role based database security system and staging areas.
• Catalog staging areas consisted of working , review and production with high speed migration from one area to another packages/triggers .
• Supported database synchronization s between laptops and main database.
• Mentored client s DBA and Development staff on daily basis.
• Extensive Unix scripting.
• Repeatedly asked for by name from several clients departments to assist in troubleshooting system wide problems not related to the current project.
• Platforms included Win2000/ME, NT, Sun Solaris, HP-UX, Linux.

Project: Migrate older Sun/SCO Unix systems to new Sun/Solaris platforms Navy aircraft maintenance systems . Upgrade Oracle database, Developer tools and custom code, special emphasis on Y2K compliance. Migrate second system to Win NT platform.

• Sole DBA with duties including installing Oracle 8i 8 instances , optimizing memory and tablespace usage , installing and using Oracle Enterprise Manager, develop backup and recovery procedures, install Developer 1.6, 2.1, 6.0, train existing staff.
• Installs were on Sun/Solaris and Win NT.
• Also became project lead on the actual tools and custom code upgrade/conversions as well as lead on actual deployment team.
• Performed extensive optimization on existing inventory system.

Project: Deploy updated software and new HP Unix servers to 10 Graft food plant laboratories contract awarded to Raytheon .

Position: Lead DBA / Group Leader

• Performance tuning of database, developed procedures for migration of data for junior DBA s, installed concurrent instances for the database on most servers, assist project manager with scheduling, resource allocation, etc., came up to speed on Business Objects as quickly as possible designed the main Universe database interface to assure proper data retrieval for drag and drop report users.
• Assisted junior developers in design of Business Object reports.
• Prepared specification for, designed and wrote client/server Developer/2000 application to replace major portion of vendor s software deployed to 10 laboratories .
• Taught advanced PL/SQL and Developer/2000.
• Heavy emphasis on DBA skills/experience, Unix, PL/SQL, Developer/2000

Project: Commercially available client/server telephony software package. Including billing, service orders, customer care, inventory management, etc. Oracle based RDBMS-ver. 7.3, Developer 2000-ver. 1.4W, Pro*C , using UNIX and NT servers with NT/95 clients.

Position: Project Manager / Database - Application Architect

• Started as contract developer doing bug fixes for existing system followed by specification preparation, design and coding of major add-on module.
• Upon completion of the contract accepted offer to become permanent project manager / system architect.
• Designed entire telephony billing system Pro*C . Approved all new designs, database changes and maintenance efforts.
• Implemented software change control / configuration control systems.
• Other roles included Lead DBA, technical subject matter expert for customer presentations, technical authority on tool implementations.
• Developed interfaces to testing and documentation groups, final approval on all documentation.
• Led migration team converting entire package from Forms 3.0 to 5.0. As part of this migration, developed coding and design standards for new environment.
• Extensive multi-language ETL work due to east European clients.

Project: Design and build Oracle based Laboratory Information Management System LIMS for nuclear laboratory at government weapons plant for Department of Energy DOE . Large, multiyear project handled almost entirely by myself.

Position: Senior Software Engineer

• Application architect/developer, Data architect/administrator, VMS system administrator.
• Used Oracle Forms 3.0 to develop the interfaces used to configure the system, forms proved lacking for use as the front end for actual users so Pro*Fortran was used to create a high speed windowing system.
• Designed and wrote low level systems to interact with laboratory instruments, operating system and network to perform everything from real time data gathering to data exchanges with process control systems.
• Created an API for other software packages to feed data directly into the system.
• System consisted of multiple, networked databases.
• System had extensive, configurable security system that controlled access to software functionality as well as data.
• System is currently in use in two labs and was leading contender for the lab that would be associated with the new tritium reactor prior to it s cancellation.
• Prepared full user and system admin documentation according to DOE requirements.
• Prepared DOE acceptable document change control system.
• Conducted all user training.
• Oracle 6.x,7.x , Developer/2000, Pro*Fortan, VMS

Project: Laboratory Information Mgmt System LIMS , prepare specifications, evaluate available products, procure, implement, add functionality and train users.

• Project started out as an effort to procure an existing LIMS package. It was determined that considerable functionality would be needed beyond the existing system.
• Designed and wrote functionality that operated on top of vendor package.
• Over 85 of the vendors code was replaced. Set up second database, leased lines for a statistical multiplexer and brought a second laboratory in Mobile, AL online remotely from New Orleans using existing staff and hardware.
• Developed instrument interfaces to gather real time analytical data.
• Implemented system to handle labs through out the plant with controlled data and functionality access.
• Data control and definition was flexible enough that the Engineering used the system to track project statuses/costs.
• System was finally retired after 15 years due to operating system Y2K issues.
• Concurrent with LIMS project headed up effort that converted drafting department from paper to CAD.
• Became system manager for Integraph CAD system that used VMS as data server to Unix workstations.
• Three years as analytical chemist.

Bachelor in Chemistry, minor in Computer Science almost double major , Southern Illinois University, 1981