Database Administration, Analysis, Design & DBA Training for customer data warehouse

Designed, documented and trained users in the physical design, de-normalization, installation, migration, upgrade, performance tuning, backup and recovery, for fault tolerant data warehouse development and production systems. NT running on 2 processor DEC Alpha/2100 Hosts. Utilized Oracle 7.2 server for replication, and SQL*Net 2.2 for Client/Server connections. Provided the system design for calculating profitability for each individual bank transaction. Totals are then annualized for account & household demographics. Product test marketing what-if scenarios are then applied to the data. This illustrates the customers who are most likely to purchase, which new products and determines the best sample market for each product and service. Replication alerts are used to shuttle data between application databases. After test market verification, the data is extrapolated - to the entire customer universe for marketing.