Michael A. Rothwell

**** *. ******* ****** ** E-Mail: abmkf8@r.postjobfree.com

Meridian, ID 83642 Cell: 208-***-****

* *******

Over 2 decades in IT specializing in Databases with extensive experience in

Oracle and MS SQL Server database management, design, programming, data

warehousing, data transformation, data conversion and web enabled DB's.

Solid background in database design programming and warehousing for Windows

and Web clients. Experience in systems engineering, coding and integration

testing.

2 COMPUTER SKILLS

Operating Systems: RedHat, Solaris, HP-UX, Windows XP, Windows 2000

Server, AIX, VMS, MS-DOS

Software: Oracle 11g/10g/9i/8i/7x, PL/SQL, MS SQL Server 2000, ATG E-

commerce system, ETL procedures, DTS Scripts, Oracle Application Server,

Unix Scripts, Web Applications, SQL*Plus, SQL*Loader, SQL*Net, ERWin, DB

Artisan, ER Studio, TOAD, Delphi, C, Pro*C, HTML

1 PROFESSIONAL EXPERIENCE

PersonalShopper.com, Boise, ID

Sep 2007 -

Present

1 Oracle DBA/Developer

Responsible for Management, Programming of an Oracle database for on-line

merchandising system. Responsibilities include DBA roles and

programming/developing of database.

Load and maintain ATG specific tables.

Enhance performance of daily processing.

Wrote many PL/SQL and Unix scripts to maintain data for ATG Ecommerce

system.

Established and maintained multiple databases to ensure proper development,

test, production and historical/archival systems.

Data migration scripts to keep QA and Dev databases up to date.

Contractor - Hewlett Packard, Inc., Roseville, CA / Boise, ID

May 2004 - Sep 2007

2 Oracle DBA/Developer

Responsible for Management, Design and Programming of an Oracle database

and Data Warehouse used to track parts and products for the Printers and

Imaging Group. Responsibilities include DBA roles and

programming/developing of database.

Created many Unix scripts and PL/SQL routines to gather data and load it

into the data warehouse daily.

Re-wrote many scripts to enhance performance of daily processing of legacy

data.

Assisted in upgrade from Oracle 8i to Oracle 9i.

Wrote many PL/SQL and Unix scripts to convert database to new design, then

migrated many tables to new design.

Established and maintained multiple databases to ensure proper development,

test, production and historical/archival systems.

Contractor - Art and Logic, Glendale, CA

June 2003 - May 2004

3 Oracle Server DBA/Application Programmer

Responsible for Design, Programming and Management of an Oracle database

used for online scholastic testing.

Created scripts for database and all objects on clients systems.

Optimized SQL and database for faster Query response times.

Michael Rothwell Page 2

Contractor - American Package Xpress, Irvine, CA

January 2002 - October 2003

4 MS SQL Server DBA/Application Programmer

Responsible for Design, Programming and Management of a SQL Server database

and Data Warehouse used to invoice customers and track packages.

Responsibilities include DBA roles, programming, and data transformation.

Modeled and designed database to warehouse manifest and package tracking

information.

Created database and all procedures/DTS services to load database from

several remote locations and file types including other databases,

spreadsheets and other filetypes.

Programmed many stored procedures and user defined functions to clean data,

create billing information for use in invoicing customers, error reports

and management reports.

Automated database activity to be "hands off", including notifications to

DBA's and help desk of any irregular activity.

Provided information to correct past mistakes in billing.

Contractor - Hewlett Packard, Inc., Roseville, CA

January 1997 - September 2001

5 Oracle DBA/Oracle Application Server Programmer

Responsible for Management, Design and Programming of an Oracle database

and Data Warehouse used to track consulting engagements. Responsibilities

include DBA roles and programming of database for use in a 3 tier MIS

system.

Assumed DBA role of current system, re-modeled much of current system to

include normalization and table driven properties providing a more

functional system as well as being easier to modify.

Created many Unix scripts and PL/SQL routines to gather data and load it

into the data warehouse daily.

Assisted in database design and modeling of new application that would

integrate three current applications, reducing overlap and increasing

maintainability.

Modified several tables, Unix scripts, PL/SQL, and middleware programs to

achieve Y2K compliance throughout the MIS system.

Provided Web access to database reports via Oracle Webserver providing

access to consultants in the field.

Established and maintained multiple databases to ensure proper development,

test, production and historical/archival systems.

Contractor - International Pharmacuetical Services, Rancho Cordova, CA

May 1999 - Sep. 1999

6 Oracle DBA/Programmer

Responsible for maintaining database for tracking prescriptions, doctors,

and pharmacies for insurance companies.

Performed DBA duties including backup procedures, database tuning and

optimizing SQL statements.

Wrote several Unix and PL procedures to collect data from external sources

and loaded into data warehouse.

Wrote many packages and procedures to process raw data and create reports

for analysts.

Contractor - Access Billing, Inc, El Dorado Hills, CA

October 1997 - September 2001

7 Oracle DBA/Oracle Webserver Programmer

Responsible for design and development of web based on-line billing system

to accept payment of recurring bills and to track bill payment and accounts

receivable for small to midsize companies.

Designed and developed Oracle database to manage multiple companies and

their bill paying customers.

Designed and programmed web based application, using Oracle Application

Server with PL/SQL cartridge, for customers to pay bills on-line and

companies to have access to "near real time" accounts receivable

information.

Michael Rothwell Page 3

Advanced Microware, Inc., El Dorado Hills, CA

1996 -1997

8 Windows Programmer/Developer

Responsible for the development and testing of a computer aided shipping

and manifesting system for Hi-Tech companies.

Assisted in the design and development of a client/server shipping and

manifest system using Delphi as the Windows interface and an open

architecture to allow storage on any SQL compliant database.

Designed and coded several reports for shipping companies and U.S. Customs,

reducing paperwork for the shipping company.

Optimized a client/server application and SQL database, increasing

throughput of system by over 500%.

PRC, Public Sector, Inc., Orange CA

1993-1996

9 Database Administrator/Programmer

Responsible for the development and management of databases, application

forms and reports used to track incidents, staff and equipment of Police

and Fire Departments and NCIC/CCIC. Responsibilities included

installation, tuning, and optimization of Oracle RDBMS, application

development, data conversion, exports, backup and recovery of databases.

Designed and implemented a tracking system using Oracle RDBMS and Tri-Fox

for the County of Los Angeles Fire Department, reducing paperwork and

ensured that personnel have the proper qualifications and certifications.

Assisted in the design and development of a Client/Server Alarm Tracking

System using MS Access, Power Maker and Power Viewer to access data stored

in an Oracle Database.

Assisted in implementing a Client/Server based Records Management System

based on Oracle Tools for Windows accessing data stored in an Oracle

Database.

Tested various TCP/IP products and implemented a TCP/IP network for the

development of Client/Server database applications.

Designed and implemented database and data entry/reporting tools to track

Sheriff's department employees, employee training, and new applicants,

reducing paperwork significantly.

Designed and implemented database, using VAX Records Management Services

and C, to retrieve driver license and vehicle license information for the

Colorado Bureau of Investigation, improving access time by over 500%.

HUGHES TRAINING, INC., West Covina, CA

1989-1993

Database Administrator/Assistant Engineer

Responsible for database management and tracking information on all B-2

Simulator/Trainer components, including data conversion, exports, imports,

tuning and optimization of Ingres RDBMS.

Designed and implemented a database and reporting tools to track

components, improving data integrity and reducing data redundancy by 30%.

Modified existing tools to meet new requirements for document delivery,

allowing scheduled software design document delivery.

Trained users in database and system functionality, allowing use of both

operation and database systems, improving office efficiency.

PHOENIX COMPUTER, Walnut, CA

1988-1989

10 Computer Technician

Customized assembly and testing of personal computers to meet

specifications of the customer, providing operational systems.

1 EDUCATION

Bachelor of Science, Computer Information Systems, California State

Polytechnic University, Pomona

Electronics Technology, Idaho State University, Pocatello

Contact this candidate