S. Scott Wise

5434 S QUINTERO WY
CENTENNIAL CO 80015-2520
(303) 870-0078 scottwise@rocketmail.com
SUMMARY
  • 19 Years Electronics & Programming
  • 13 Years of Technical Management
  • Complete website production
  • Database Administration
  • Relational Database Design / Development
  • Mainframe & Client/Server expertise
  • Investment Management Systems
  • Process Control Systems
  • Production Management & Reporting
  • Inventory Control/Management Systems
  • Material Handling Systems
  • Training & Support
EXPERIENCE
Freelance Contract Work: Single-handed Design, Development and Deployment of Commercial Websites
  • Sushi Terrace - Sushi bar, 1999
  • Colorado University - Engineering Dept., 1997
  • Postal Service - HR Recruiting, 1996
* Use of Cold Fusion, Java, Java applets, Javascript, ASP, HTML

8/00 – present – Database Administrator: Design - Home Buyers Warranty
  • Development of data model for corporate transaction processing
  • Development of meta-data repository
  • Development of cross-platform interfaces
  • Database backups / recovery
  • DBMS and DBMS client installation and configuration
  • ISQL script development / tuning
  • Documentation
* Use of SQLServer2000, Windows2000, ISQL, SQL Enterprise Manager, ER Studio, Visual Source Safe

7/99 – 8/00 – Database Administrator: Data Warehouse - OppenheimerFunds
  • Development of process and data model for corporate website
  • Development of operations manual for website database
  • SQL Instruction
  • Analysis of OLTP SQL for performance improvement
  • Database tuning such as setting optimization levels, tablespace architecture, and etc.
  • Database backups / recovery / disaster recovery
  • DBMS and DBMS client installation and configuration
  • Unix script development / tuning
  • Documentation
* Use of DB2/UDB v5.2, Sybase 10.20, ISQL, IBM Platinum Analyzer, Computer Associates Autosys, Unix HP-UX 10

12/98 – 7/99 - Senior Analyst: Corporate Reports - OppenheimerFunds
  • Implementation of new corporate reporting system as part of a Y2K and database conversion
  • Development of data dictionary for a 300 Gigabyte Data Warehouse
  • Generation of tables, indexes in DB2 schema
  • Development of report designs and associated queries
  • Performance tuning of queries against massive data sets of distributed data
  • Developed corporate reports administration plan and report standards
* Use of DB2/UDB v5.2, Seagate Info, TSO, Crystal Reports, ERwin

11/97 to 12/98 - Engineering Specialist: Preventive Maint. Planning, Systems Support - U. S. Postal Service
  • Migration of various operations database platforms and reporting applications to Oracle 7
  • Design and creation of high speed conveyor based sorting [sortation] systems
  • Management of major construction, repair and alteration projects/programs
  • Management of Preventive Maintenance efforts involving statistical analysis
  • Data Mining and production of productivity reports for management use at national level
  • Design, Development and Deployment of HR hiring and bidding database applications
  • Produced department staffing, budget and activities scheduling plan
  • Writing of "statement of work" [requirements] clauses for contract RFP's
  • Data Mining: Process on-line Scheduling & Control Management Reporting
  • Administration of Novell LAN and applications creation
  • Administration of several large scale Database Systems incl. Oracle & Focus
* Full use of Microsoft suite of tools, including MS Project for project management

1/96 to 11/97 – Manager, Maintenance and Operations Support – U. S. Postal Service
  • Design & Development of attendance analysis application for 2,000 employees
  • Production scheduling application development, incl. maintenance scheduling
  • Automation of hardcopy forms linked to database application
  • Management of inventory control and purchasing for $2.5M inventory
  • Management of HR staffing efforts: interviewing, contracts, hiring, and promotions
  • Extensive SQL coding in Oracle & use of the Focus database product
* Full use of Microsoft suite of tools, including MS Project for project management

OTHER PROFESSIONAL EXPERIENCE
Other work experience may be provided upon request

EDUCATION
SYBASE Training February 2000
ASE 12: DATABASE AND SYSTEM ADMINISTRATION

IBM M/UX Training November 1999
CF241: DB2 UDB EEE ADMINISTRATION

IBM M/UX Training June 1999
CF030: DB2 FUNDAMENTALS

University of Colorado at Denver 1993 to 1998
DEGREE: BACHELOR OF SCIENCE DEGREE IN BUSINESS FALL 1998
EMPHASIS: INFORMATION SYSTEMS CUM LAUDE

Texas Tech University 1979
MAJOR: ELECTRICAL ENGINEERING

North Hills High School 1978
QPA: 3.50
RANK: 112/795