SOFTMASTER INC. - 2007 - Laserfiche WebLink

Home Browse Search

Environment: HP UX 10.2 /Oracle 7.3.4 & 8i environment. • Performed DBA administration duties including physical design, capacity planning, testing and implementation in development and test environments • Developed extensive PL /SQL and Unix scripts to populate the data warehouse • Developed database scripts for tuning, monitoring and data manipulation • Facilitated training sessions with respect to operation and maintenance of the Corporate Data Warehouse • Enhanced PL /SQL data load scripts, performed QA testing and implemented architectural modifications to improve data load times, anomalies and service levels • Prepared weekly documentation to support database change requests 01/98 06/99 Aames Financial Corporation Los Angeles, CA Sr, Oracle and Informix DBA Environment: HP UX 10.2 /NT/ Oracle 7.3.4 and Informix 7 • Revitalized a Mortgage Data Warehouse through expansion, training and improving system availability • Resolved data integrity issues by pro - actively developing and leading a data integrity task force • Managed Data Warehouse including administration of security policies • Implemented user requirements by adding measures, dimensions and data marts • Provided Oracle and Informix Software Installation, Upgrades and Patches • Developed reliable backup and recovery strategies and procedures of the mission critical system • Installed and configured MetaCube to produce standard and ad hoc reports used to facilitate decision support analysis 03/95 - 01/98 Cambridge Technology Partners El Segundo, CA Database Analyst Environment: HP UX 10.2 /Oracle 7.3.4 and Informix 7 • Conducted scope and design sessions and implemented data warehouse solutions in the following business areas Pharmaceutical, Manufacturing and Customer Based Mortgage Banking. • Performed Dimensional, Logical and Physical modeling • Built Star Schemas as the foundation of the data warehouse design • Aggregated fact tables for query optimization • Configured and performance tuned databases with partitioning and various indexing strategies • Developed extensive ETL based PL /SQL procedures used to perform daily loads of the data warehouse • Developed database scripts for tuning, monitoring and data manipulation • Developed and conducted training sessions and manuals for end users and key IT personnel for multiple front -end OLAP tools: MetaCube, MicroStrategy and Decision Suite 01/92 - 03/95 The Aerospace Corporation El Segundo, CA Database Engineer Environment: VMS /Oracle 7.3.4 • Provided database consultation to the United States Air Force and Missile Systems Center at Top Secret clearance level • Performed DBA functions including implementation, maintenance, and performance tuning April 2007 21