EDUCATION
Ohio University in Athens, OH
Bachelor of Science Degree, Economics, Summa Cum Laude
Internship with the Joint Economic Committee of the U.S. Congress
Extensive vendor-provided technical training in all aspects of Database
Administration.
Council Member, Ohio Univ. Arts and Sciences Dean's Advisory Council
TECHNICAL EXPERIENCE
Hardware: HP9000 Midrange Server, Sun Sparc Server,
NCR 3445 and 3450 Work Group Servers,
RS/6000 Midrange Server, DEC VAX, IBM
Compatible PC, Compaq Proliant 3000, DecAlpha
1200 and 4100, Assorted PCs/Workstations
Oper. Systems: HP-UX UNIX, NCR SVR4 UNIX, NCR SVR4 MP-RAS UNIX, AIX UNIX, Tru64
UNIX, Solaris UNIX, LINUX, NT, DOS, OS/VM, Windows
Databases: Oracle 6.x, 7.x, 8.x, 9.x, 10.x, Informix SE 4.0, dBase, FoxBase
Software: SQL*Plus, SQL*DBA, SVRMGR, SQL*Loader,
Oracle Import/Export, PL/SQL, Informix Wingz,
UNIX Shell Programming, dBase, Foxbase,
Designer/2000, PeopleTools 5.x, 6.x, 7.0x, 7.5x, 8.1x, 8.4x
PROFESSIONAL CERTIFICATIONS
Informix Standard Engine Certified Developer
Oracle Master Certification - Application Analyst
Oracle Master Certification - Database Administration
Oracle Master Certification - Designer/2000 Systems Analyst
Oracle Master Certification - Technical Support
PRIOR ENGAGEMENTS
SAFEAUTO INSURANCE COMPANY, COLUMBUS, OH
Work efforts included:
• Technical review of the organizations Oracle 10.2.0.4 database environment.
• Ongoing database administration support efforts.
CROW HOLDINGS, DALLAS, TX
Work efforts included:
• Ongoing application and database administration support of the organization’s
production PeopleSoft Financials environment deployed on an Oracle RDBMS.
• Served as upgrade Project Manager and PeopleSoft DBA for the firm’s PeopleSoft
Financials 7.53 upgrade to release 8 SP1.
• Served as upgrade Project Manager and PeopleSoft DBA for the firm’s PeopleSoft
Financials 8 SP1 upgrade to release 8.8 SP1.
• Served as upgrade Project Manager and PeopleSoft DBA for the firm’s PeopleSoft
Financials 8.8 SP1 upgrade to release 9.0 SP1.
• Full PeopleSoft Administrator and Security Administrator responsibilities.
• Patched the PeopleSoft Financials 8.8 SP1 code base up through Maintenance
Pack 9.
• Patched the PeopleSoft Financials 9.0 code base up through Maintenance Pack
7.
• Upgraded PeopleTools from 8.45 to 8.48 and Oracle from 9.2.0 to 10.2.0.
• Upgraded PeopleTools from 8.48 to 8.49 while migrating to an Oracle 10.2
64-bit environment.
DICKS SPORTING GOODS, PITTSBURGH, PA
Work efforts included:
• Technical review and assessment of the organization’s PeopleSoft Financials
environments in anticipation of an impending application upgrade to PeopleSoft
8.8.
• Technical review and assessment of the organization’s PeopleSoft HRMS database
environment on Oracle 9.2.x to identify potential Best Practices opportunities.
• Technical assessment, tuning, and rebuild of the organization’s production
PeopleSoft 8.8 SP1 Financials database following the organization’s upgrade to
Oracle 10.2.0 to resolve severe performance problems.
THE TIMKEN COMPANY, RANDLEMAN, NC
Work efforts included:
• Responsible for providing secondary Oracle DBA services in support of the
organization’s Asheboro Bearing Plan.
DONATOS PIZZA, COLUMBUS, OH
Work efforts included:
• Maintained current Financials 8.8 SP1 code base by applying Maintenance Packs
up through Maintenance Pack 8.
• Responsible for environmental cleanup, including resolution of problems
detected from execution of dddaudit, sysaudit, and alter audit reports.
THE LONGABERGER COMPANY, NEWARK, OH
Work efforts included:
• Technical review of the organization’s PeopleSoft Financials / Supply Chain,
HRMS, and CRM environments to identify potential Best Practices opportunities.
• Emergency database maintenance efforts to stabilize and improve system
performances of the organization’s Financials / Supply Chain and CRM
environments.
3PF, COLUMBUS, OH
Work efforts included:
• Technical review and evaluation of the organization’s Oracle RDBMS
environment.
• Configuration of automatic database exports, as well as misc. other
environmental cleanup efforts.
ZOOMAX, DUBLIN, OH
Work efforts included:
• Emergency support to address system performance issues immediately before and
after migration to a Baan application environment.
• Database upgrades to Oracle version 9.2.x and server rehosting to consolidate
environments onto a single physical database server.
• Ongoing Oracle DBA support for Baan, PeopleSoft, and other application
environments.
eSYLVAN, BALTIMORE, MD
Work efforts included:
• Ongoing database administration support of the organization’s custom-developed
applications residing of Oracle versions 8.0.5 and 8.1.7.
DUALITE SALES & SERVICE, INC., WILLIAMSBURG, OH
Work efforts included:
• Technical review and evaluation of the organization’s Oracle RDBMS/Baan
application deployment.
• Emergency problem resolution in support of the production environment.
MAERSK LINES LIMITED, NORFOLK, VA
Work efforts included:
• Online Application Upgrader work efforts in support of the organization’s
PeopleSoft application upgrade from Financials Release 7.53 to Release 8.4
HCR MANORCARE, TOLEDO, OH
Work efforts included:
• Technical evaluation/audit of the organizations PeopleSoft 8 Financials
architecture environment, with primary focus on optimizing performance,
stability, and security.
• Technical evaluation/audit of the organizations PeopleSoft 8.8 HRMS
architecture environment.
• Application tuning of various SQR programs in anticipation of production
deployment on PeopleSoft HRMS 8.8.
U.S. DEPARTMENT OF STATE, WASHINGTON, D.C.
Work efforts included:
• Technical evaluation of client's PeopleSoft HR deployment on Oracle/NT.
• Consultative assistance in identifying appropriate security and administrative
policies and procedures.
GENERAL CHEMICAL CORPORATION, PARSIPPANY, NJ
Work efforts included:
• Provided technical training to the organization's Oracle Database
Administrator.
• Emergency support / problem resolution.
• Ongoing Oracle Database Administration support for the organization’s
PeopleSoft 7.51 HRMS environment, PeopleSoft 7.0 Manufacturing environment, and
PeopleSoft 7.53 Financials environment.
VP BUILDINGS, MEMPHIS, TN
Work efforts included:
• Emergency database tuning and application tuning.
• Rapid analysis and execution of required emergency database maintenance
required to allow month end Financial System processing.
• Development of a strategy required to rehost the database, PeopleSoft Process
Scheduler, and Application Manager on a new production server.
BORDEN FOODS CORPORATION, COLUMBUS, OH
Work efforts included:
• Full Oracle8 Database Administration services in support of PeopleSoft
Financials, Supply Chain, and Distribution applications.
• Performed PeopleSoft PeopleTools, Applications, and SQR upgrades.
• Responsible for all aspects of PeopleSoft security administration.
• Responsible for all aspects of project migration and patch application.
• Implemented and administered multiple application servers, with round-robin
connectivity, in a three-tier physical architecture.
• Developed and administered multiple PeopleSoft Process Schedulers.
• Participated in the full life cycle deployment of the PeopleSoft
implementation, then provided both on-site and remote support services.
MEDIA GENERAL, RICHMOND, VA
Work efforts included:
• Optimized PeopleSoft-generated alter scripts to minimize execution duration
associated with a PeopleSoft HRMS upgrade from Version 5.1 to 7.0., while
concurrently minimizing the risk of upgrade execution failure due to object
sizing, temp space, or rollback segment failures.
• Assisted the organization’s Database Administrators in completing an Oracle
upgrade to Release 7.3.4 from Release 7.3.2.3.
• Provided technical assistance during the organization’s PeopleSoft
Financials upgrade from release 7.02 to 8 SP2.
• Provided technical assistance during the organization’s PeopleSoft HRMS
upgrade from release 7.51 to 8.3.
• Technical evaluation of the organization’s Oracle database environment to
identify causes of severe performance problems following their PeopleSoft
Financials upgrade to release 8 SP2.
• Provided application tuning services in support of the organization’s
PeopleSoft Financials application upgrade from Release 8 to Release 8 SP3.
• Pre-production release technical database review for a new application
environment deployed on an Oracle 10.2.0.3 RDBMS platform.
• Ongoing technical consultative assistance in support of the organizations
deployments on Oracle.
FIRST AMERICAN NATIONAL BANK, NASHVILLE, TN
Work efforts included:
• Conducted an audit of the organization's immediate pre-production deployment
of PeopleSoft Financial Application in an Oracle7 environment.
• Provided technical training to the organization's Oracle Database
Administrator.
• Provided managerial and technical recommendations required to address a
doubling of database contents resulting pending merger activity.
• Performed a tuning analysis of the SQL associated with a key, long running
PeopleSoft COBOL process.
• Participated in the organization's PeopleSoft application upgrade from release
6.11 to release 7.52.
SYLVAN LEARNING, INC., BALTIMORE, MD
Work efforts included:
• Database sizing and design analysis for a full PeopleSoft Financials
application environment.
• Logical and physical cleanup of the production Oracle7 database environment in
preparation for production deployment.
• Provided technical training to the organization's Oracle Database
Administrator.
• Performed tuning analyses of the SQL associated with a key, long running
PeopleSoft SQR process.
• Participated, as Project Manager, in the organization's PeopleSoft application
upgrade from release 6.11 to release 7.52.
• Developed Technical Architecture design definition, documenting the Current,
Upgrade, and To Be environments for the client’s impending PeopleSoft Financials
upgrade from release 7.52 to release 8.4 SP1.
• Performed multiple upgrades of PeopleSoft databases from Oracle version
8.1.7.2.0 to version 9.2.0.2.0.
• Performed work efforts associated with the organization’s PeopleTools upgrade
from release 7.6.1 to release 7.63.
• Served as Lead Architect for the organization’s PeopleSoft Financials
application upgrade from release 7.52 to release 8.4 SP1.
• Served as Online Application Upgrader for the organization’s PeopleSoft
Financials application upgrade from release 7.52 to release 8.4 SP1.
• Full Oracle DBA support of the organization’s PeopleSoft 8.4 SP1, PeopleTools
8.42, Oracle 9.2.0 production, development, and test environments during a
several month reassignment of internal DBA responsibilities.
• PeopleTools 8.45 installation and environment creation responsibilities.
• Efforts associated with the organization’s upgrade to PeopleTools 8.46.
• Ongoing full Oracle DBA support of the organization’s PeopleSoft 8.4 SP1,
PeopleTools 8.46, Oracle 9.2.0 production, development, and test environments.
AMERICAN ELECTRIC POWER, COLUMBUS, OH
Work efforts included:
• Project Technical Lead for the Leased Asset Management System upgrade from
PeopleSoft Version 5.1 to Version 7.0.
• Project Technical Lead for work efforts associated with integration of the
Leased Asset Management System with the organization’s other PeopleSoft Financial
System modules.
• Full Oracle 7.x Database Administration services in support of PeopleSoft
Financials applications.
• Team Leader on Data Conversion project efforts for the Leased Asset Management
System.
• Development of utilities to facilitate PeopleSoft version upgrade efforts.
• Systems Architect responsibilities on integrated infrastructure design.
• PeopleSoft/Oracle application tuning support to facilitate the organization’s
PeopleSoft Financials upgrade to version 9.0.
CONQUEST OPERATOR SERVICES, DUBLIN, OH
Work efforts included:
• Installation support for the Oracle RDBMS 7.3 and SQL*Net products.
• Logical and physical database design responsibilities.
O.M. SCOTT & SONS, MARYSVILLE, OH
Work efforts included:
• Full Oracle 7.x Database Administration support services in support of
PeopleSoft HRMS applications.
• Consultative assistance on heterogeneous database bridging alternatives.
• Application / database support for installed inventory tracking system.
NATIONWIDE INSURANCE, COLUMBUS, OH
Work efforts included:
• Full Oracle 7.x database design and implementation.
• Consultative assistance in mass data load efforts.
BOEING DEFENSE ENTERPRISE INTEGRATION SERVICES, COLUMBUS, OH
Work efforts included:
• Logical and physical design of VLDB Oracle 7.x database environments.
• Hardware and operating system software evaluations.
• Evaluation of CASE and other development tools required to facilitate platform
migration/reengineering.
• Analysis of technical alternatives associated with heterogeneous database
bridges.
• Data Warehouse database design and development.
LCI INTERNATIONAL, DUBLIN, OH
Work efforts included:
• Full Oracle 7.0 Database Administration responsibilities.
• Development of a database backup facility to allow backup of open databases
operating in Archive Log mode.
• Design, tuning, and configuration of large databases.
• Development of numerous utilities to facilitate database migration between
midrange computing platforms.
• Construction of an OLAP data repository for Executive Information System (EIS)
use.
CINCINNATI MILACRON, CINCINNATI, OH
Work efforts included:
• Conducted an audit of the organization's deployed Oracle 7.x-based PeopleSoft
Human Resources application environment.
PROCTER & GAMBLE, CINCINNATI, OH
Work efforts included:
• Full Oracle 6.x Database Administration and Systems Administration for an
HP9000 HP-UX UNIX environment.
• New development and support of existing mainframe, midrange, and PC based
applications.
MICRO INDUSTRIES, WESTERVILLE, OH
Work efforts included:
• Full Oracle 6.x Database Administration responsibilities.
• Full Systems Administration responsibilities for an HP9000 HP-UX UNIX
environment.
• Support for the firm's use of Oracle Financials applications.
• Development of an integrated payroll / cost accounting tracking system.
AMERITECH SERVICES, CHICAGO, IL
Work efforts included:
• Full Informix SE 4.0 and Oracle 6.0 Database Administration responsibilities.
• Full Systems Administration responsibilities for NCR 3445 and NCR 3450 UNIX
environments.
• Design, project management, development, and implementation responsibilities
for a large-scale Decision Support platform.
• Hardware and software evaluation/selection.
POPULAR CREEK MUSIC THEATRE, CHICAGO, IL
Work efforts included:
• Hardware and software evaluation/selection.
• Configuration and installation of the firm's personal computers and
peripherals in a small network environment.
• Hardware and software trouble shooting.
BOISE CASCADE OFFICE PRODUCTS, ITASCA, IL
Work efforts included:
• Management consulting to branch personnel at the organization's geographically
dispersed locations.
• Development of regional purchasing and warehousing strategies for the various
branch locations.
• Evaluation of potential purchasing and inventory management software tools and
applications.
• Subject matter expert on the organization's primary forecasting and
replenishment application tool.
|
