Ellis R

							Ellis R. Miller
5001 Polen Dr, Kettering, OH 45440
H: (937) 985-3816
C: (937) 830-6027
outlawdba@gmail.com

QUALIFICATIONS SUMMARY:
Experienced Oracle consulting professional with more than 12 years managing, leading,
and contributing to teams of both Database Administrators and Developers with more
than 10 years production DBA experience including Oracle 10G/11G RAC and MS SQL
Server.

ACHIEVEMENT HIGHLIGHTS:

      Proficient in using and interpreting Oracle Wait Interface including AWR reports,
       standard Oracle tracing, TKPROF, AUTOTRACE, and DBMS_PROFILER in
       conjunction with OS performance statistics to identify and eliminate critical SQL
       and PL/SQL bottlenecks
      In-depth knowledge of Oracle data dictionary for identifying invalid objects,
       materialized views, and extracting PL/SQL source code for reverse engineering
       and troubleshooting of database applications
      Led legacy system data profiling and cleansing recommendations for USAF
       ECSS project generating more than several hundred cleansing recommendations
       for technically and functionally inaccurate data
      Technical lead on Oracle 11.5.10 and r12 ERP implementations for USAF on
       ECSS and DEAMS projects
      Worked with GCSS-AF on USAF projects including FIRST, ECSS, and DEAMS
       to ensure Oracle ERP security scan compliance
      Identified and tuned worst SQL reducing batch processing time for Oracle 9i
       AMEX Name and Address matching application from eight hours to several
       minutes
      Reduced Wells Fargo Cost Recovery batch processing from 7 hours to
       approximately 70 minutes for Oracle 9i data warehousing web application
      Reduced HDS McKesson PL/SQL batch processing from 12 hours to less than 90
       minutes to comply with Bristol-Myers Squibb SLA (Service Level Agreement)
      Development PL/SQL and ETL coding standards for USAF ERP implementations
       as well as commercial organizations such as Arizona Public Service, American
       Express, Cyclone Commerce, Wells Fargo, Advanced Foodsystems, and NTI
      More than 5 years experience working with SSO including Oracle Portal, OID,
       and Active Directory integrated with APEX


EDUCATION:


MBA MIS, May 1997
University of Dayton, Dayton, OH

BS Finance and Accounting, May 1991
University of Dayton, Dayton, OH

EXPERIENCE:

NovaTech, Fairborn, OH, Oct 2009 – Present
DEAMS PMO - Sr Systems Analyst
Program Management Office Sr. Analyst managing portfolio of Interfaces and Data
Conversions including monitoring and troubleshooting BPEL, working directly with
FMO and SI (System Integrator), and authoring Sustainment and Scalability whitepaper
for Director of the DEAMS program.
     Managed portfolio of legacy system interfaces to Oracle Federal Financials
     Worked with SI (System Integrator) and FMO (Functional Management Office)
        to monitor and expedite creating, testing, and deployment of SOA-based
        interfaces
     Provided Program Director with Sustainment and Scalability analysis of DEAMS
     Worked with USAF legacy system Interface Partners to assist in validation of
        DEAMS BPEL outbound interfaces
     Assisted System Integrator in troubleshooting of BPEL related errors including
        BPEL processes not archiving inbound files to NFS mounted directory

CSC, Beavercreek, OH Apr 2009 – Jul 2009
Technical Lead
Led a team of 9 technical data migration programmers and developers in test loading
USAF legacy source data to Oracle EBS target.
    Defined all programming and best practices standards for Extracting
        Transforming and Loading USAF legacy data
    Led GCSS-AF integration team to ensure compliance with IA, security, and
        production migration standards
    Led development of CV.060 AIM template modifications to mirror our data
        migration process
    Worked with IA and Security to ensure compliance with USAF security standards
        for Conversions including source code scans for potential security vulnerabilities

CSC, Beavercreek, OH Nov 2007 - Apr 2009
Sr. ERP Consultant
Data Team technical lead and embedded member of Delivery Return and OTM process
blueprinting team working directly with Air Force Subject Matter Experts. Assisted in
conducting Source to Target mapping data migration workshops for Customer, Price List,
Carriers, and Maintenance Programs with USAF legacy systems Subject Matter Experts.
Assisted in data mining, profiling, and test loading of Source legacy data across all ERP
modules.
    Assisted in authoring and editing Data Migration Strategy CDRL for USAF
       review and presentation to Pentagon
       Profiled legacy system data for mapping from source to target using Business
        Objects Composer, Business Objects Insight, as well as PL/SQL Developer
       Used PL/SQL and Oracle 10G regular expressions to profile, aggregate, and
        otherwise analyze USAF legacy system data for data cleansing recommendations
       Leveraged Business Objects Composer to map legacy data to Oracle r12 API
        interface tables
       Generated and assisted in editing AIM documentation including BR100sw,
        CV40s, and CV60s
    
       Assisted Solution Design Lab team with loading sample Air Force data for Air
        Force personnel on-hands training labs
       Led and conducted various Process Team sessions in completing deliverables for
        CRUD Matrix and mapping of Air Force external interfaces to business process
        flows

Raytheon Intelligence Information Services, Garland, TX Jul 2007 - Oct 2007
Database Engineer
Database Engineer on border security Enterprise Campaign for e-Borders program.

       Installed and assisted in administration of Oracle Designer
       Worked with Data Architects in designing of abstract, logical, and physical
        generation of 3NF database application schema
       Assisted in configuring Hibernate, mapping, and generating Java source files from
        application schema including installation of Hibernate, Ant, and Oracle JDBC
        drivers
       Assisted in Oracle 10G RAC administration and configuration on Red Hat Linux
       Used RunStats package to benchmark BULK COLLECT/BIND as well as general
        use of BEFORE triggers versus Hibernate sequence and timestamp generation on
        INSERT or UPDATE


Madison Research Corporation, Fairborn, OH Mar 2007 – Apr 2007
Oracle DBA
Assisted full time DBA team in installation, troubleshooting, and optimizing of Oracle
10GAS Air Force budgeting application. Provided recommendations to management
regarding application refactoring, scalability, and migration to CBO.

       Assisted in installation and configuration of Oracle 10G RAC lab environment
       Identified and created missing FK indexes to prevent locking and unnecessary full
        table scans
       Identified and created missing PK constraints including unique indexes
       Assisted full time DBA regarding AWR, performance tuning, and testing of 10G
        AS web cache


CNG Financial, Mason, OH Nov 2006 – Feb 2007
Lead Oracle DBA
Led DBA team in the backups, administration, troubleshooting, and performance tuning
of Oracle 10G RAC on Linux. Provided troubleshooting and SQL tuning assistance to
offshore team of Java Developers.

      Leverage Oracle 10046 tracing with TKPROF to troubleshoot Java Server Page
       freezing tracing and correcting bottleneck specifically tied to PL/SQL function
      Configured RMAN incremental and full database backups for two node RAC
       cluster
      Led and standardized all database DDL, DML, and PL/SQL related releases
       including coding standards and SCM workflow
      Worked with preferred vendors and IT Management to architect next generation
       release of STARS loan application for migration to local data center
      Benchmarked and tuned various PL/SQL packages, procedures, and functions
       used by core business for operational reporting
      Assisting in evaluating and staffing offshore team of Jr. Oracle DBAs and Java
       Developers


Northrop Grumman, Reston, VA Jun 2006 – Oct 2006
Oracle DBA Consultant
Assisted DBA team in support of Oracle 9i databases on HP-UX including capacity
planning, replication, and troubleshooting of various SQL based reports.

      Leveraged 10046 tracing to determine bottleneck in payroll processing and create
       missing yet required database link on remote client
      Authored VITA employee timesheet data extract from Data Basics payroll
       software as part of Federal requirement to track VITA hours and billable activities
      Assisted in SQL Loader scripts and syntax for migration template of LAWSON
       data to SAP as part of ERP migration
      Assisted in installing, configuring, and integrating APEX/HTML DB with Active
       Directory using custom AUTHORIZATION layer for SOX compliance


SAP, Scottsdale, AZ Jan 2006 – Mar 2006
Oracle Consultant
Provided both DBA and developer skills in working with newly acquired Financial
Services module.

      Assisted developers in export and import of tables, schema changes, and
       synchronizing of development schemas
      Wrote PL/SQL code for ETL on source data provided by Chase Bank.
      Write algorithm for comparing custom FICO ranges as part of ETL
      Optimized performance of ETL by BULK COLLECTING lookup tables


Accenture, Fairborn, OH Sep 2005 – Dec 2005
Oracle DBA Consultant
Provided expert Oracle DBA skills in optimizing database batch processing and overall
database performance for DOD budgeting application. Assisted in Oracle 9iAS
administration including Discoverer Plus report optimization and applying security
related patches.

      Used 10046 tracing to determine trace, document, and optimize ETL process in
       order to eliminate bottlenecks associated with Air Force budgeting data loads
      Installed and leveraged STATSPACK to collect Oracle 9i baselines
      Refactored Oracle 9i ETL package using BULK COLLECTING, BULK
       BINDING, Index Organized Tables, global temporary tables, direct path load, and
       commit frequency reducing load time by more than 50% for DOD budgeting
       application
      Used DBMS_MVIEW package with MV_CAPABILITIES_TABLE table to
       rewrite materialized views for FAST REFRESH reducing refresh time from more
       than 12 hours to approximately 2
      Implemented PL/SQL package to issue commit at set interval to optimize batch
       processing reducing redo log related waits
      Optimized Teradata ETL process using FastLoad with FastExport and
       MULTISET global temporary tables


Midmark, Versailles, OH Sep 2004 – Dec 2004
Oracle DBA Consultant
Oracle 11i DBA assisting developers in meeting custom reporting requirements defined
by end users and analysts in Finance, Order Management, and Accounting. Provided
expert assistance in troubleshooting various Oracle 11i performance issues as well as
application errors.

      Created Discoverer 4i reports for business analysts and management
      Leveraged STATSPACK to identify key bottlenecks in 11i modules
      Introduced Discoverer 4i summary management for long-running reports
      Provided reporting strategy for building Discoverer EUL against 11i


Westar Aerospace & Defense Group, Huntsville, AL Feb 2004 – Apr 2004
Oracle DBA
Oracle DBA for uniRAM application used by Army and DOD in testing, auditing, and
reporting of equipment reliability, availability, and maintenance. Provided Forms and
Reports 6i expertise as well as Discoverer SQL Server 2000 administration skills.

      Configured Advanced Replication to replicate application tables to remote bases
      Installed and configured Oracle 10G for Linux (Fedora) on Dell server
      Assisted in the development, troubleshooting, and refactoring of application 6i
       Forms and Reports
      Developed PL/SQL XML module for extracting and transforming uniRAM data
       using XSLT
       Configured Discoverer 4i Viewer for XP and Windows 2000 clients using IE 6.0
        browser with Microsoft JVM
       Assisted Sr. Web Developer in configuring ASP .NET application to connect and
        authenticate against Oracle 9i
       Leveraged Oracle Migration Wizard to convert SQL Server 2000 stored
        procedures to Oracle 9i


Network Technologies International, Scottsdale, AZ Jan 2004 – Feb 2004
Oracle DBA Consultant
Assisted in database migration from Sybase to Oracle 9i. Provided expert assistance and
direction to developers and Oracle DBA regarding database backups, hardware
requirements, and PL/SQL best practices.

       Converted Sybase stored procedures to Oracle 9i PL/SQL for government
        application used to reverse engineer various networks for both foreign and
        domestic governments
       Set up weekly backups using OEM 9i
       Configured OEM 9i Change Management baselines for scheduled
        synchronization between development and production databases
       Developed PL/SQL template for converting remaining Sybase stored procedures
        eliminating need for redundant coding efforts


Medtronic Microelectronics Center, Phoenix, AZ Nov 2003 – Feb 2004
Principal DBA
Responsible for all Oracle database administration and integration including the
development of documented installation and configuration standards. Project lead and
principal architect on divisional Oracle database consolidation initiative.

       Configured and optimized RMAN Oracle backups on Solaris 8
       Leveraged RMAN with EM for cloning of production databases for development
        and test
       Architected and configured Sun Fire V1280 solution for migration and
        consolidation of Oracle databases running on OpenVMS
       Upgraded FACTORYworks Oracle 8.1.7.4 database and assisted in upgrade of
        clients
       Standardized Oracle file system and documented future OFA compliant naming
        standards
       Designed first draft of data mart star schema working with various Engineers and
        QA professionals


DHL Worldwide Express, Scottsdale, AZ Aug 2003 – Sep 2003
Oracle DBA Consultant
Provided expert assistance and documentation in troubleshooting and eliminating
reoccurring outages associated with mission critical e-commerce application responsible
for conducting business with large clients including HP. Analyzed and eradicated various
JDBC and Oracle related errors. Provided expert assistance to DHL Express in
cooperation with production Oracle DBA.
Accomplishments:

      Eliminated reoccurring outage in mission critical e-commerce application used to
       transact daily business between DHL and Hewlett Packard
      Reduced Cyclone Central UI (User Interface) response time from over several
       minutes to less than 10 seconds
      Eliminated severe bottleneck in mission-critical nightly archiving process
       reducing processing time from over two hours to less than three seconds
      Reset RESOURCE_MANAGER_PLAN initialization parameter to eliminate
       severe Oracle database hang
      Installed STATSPACK in order to provide baseline of performance monitoring
       and comprehensive metrics regarding overall throughput and peak concurrency


American Express Travel Related Services, Phoenix, AZ Jun 2003 – Aug 2003
Oracle DBA Consultant
Provided expert troubleshooting and performance tuning skills in identifying top five
waits as well as various JSP and Excel based web report errors. Served as Oracle
technical lead as well as Sr. DBA in optimizing and further developing Name and
Address matching application for American Express Tier II credit card markets.

      Leveraged 10046 tracing to troubleshoot and reverse engineer n-tier Java-based
       name and address matching application
      Configured all RMAN backups, OEM 9i events, and provided training to
       outsourced DBA team in India

      Configured RMAN backups integrated with Tivoli backup up directly to tape

      Identified most intensive SQL as well as code related dependencies reducing
       processing time for several reports from six to eight hours to several minutes
      Authored over two hundred PL/SQL audit reports for Java based Name and
       Address matching application being launched in tier II credit card markets
      Rewrote Mexico Match Report critical to validating Name and Address matching
       statistics for bi-monthly processing
      Mentored team of developers in BULK COLLECTING and BULK BINDING as
       well as Oracle PL/SQL best practices
      Leveraged Oracle tracing and TKPROF in tuning worst application SQL
      Optimized bi-monthly batch processing for Brazil eliminating prior snapshot too
       old errors as well as intensive parsing and table fragmentation


JDA Software, Phoenix, AZ Apr 2003 – Jun 2003
Oracle DBA Developer
Assisted in architecting and configuration of Oracle 9i release 2 database and UNIX
server for benchmarking and stress testing. Provided documentation and advice to Team
Lead in migrating the JDA Software development lifecycle to leverage Extreme
Programming and unit testing practices. Documented and mentored developers in using
utPLSQL, an open source unit-testing application.

      Installed utPLSQL and provided over thirty examples as well as documentation
       for unit testing of PL/SQL
      Extended utPLSQL API to include testing and comparison of Oracle collections
      Installed and configured STATSPACK for benchmarking and stress testing of
       retail software application
      Provided initialization parameters and best practices for initial configuration of
       Oracle 9i stress testing and benchmarking environment

      Configured NCOMP (Native Compilation) for benchmarking of mathematically
       intensive PL/SQL
      Configured Oracle 9i Directory Objects in order to avoid dependence on
       UTL_FILE_DIR
      Installed DBMS_PROFILER for stress testing and analysis of PL/SQL
       bottlenecks utilizing BULK COLLECTING, BULK BINDING, and RECORDs
       of COLLECTIONS


Add Vantage Group, Inc. Phoenix, AZ Nov 2002 – Apr 2003
Sr. Web Developer
Assisted in architecting, authoring, and implementing web application for Scottsdale, AZ
Application Service Provider offering various advertising and promotional services.
Functioned as both web developer and MySQL DBA in developing PHP, Perl, and
JavaScript web application as well as configuring production Solaris 9 server.

      Designed 3NF data model using ER/Studio and IDEFX1 convention
      Assisted in authoring of PHP, Perl, JavaScript, and HTML code for MySQL
       database application serving as primary business application for Add Vantage
       services offering
      Assisted in the installation and administration of MySQL Max 3.23.54
      Installed and compiled PHP 4.3.1 as Apache 2.0 module on Solaris 9 test
       environment
      Provided expert advice and assistance to ISP in configuring Apache 2.0 and
       MySQL Max


AFS, Phoenix, AZ Oct 2002 – Feb 2003
Oracle Lead Architect
Provided integral expert benchmarking and scalability testing resulting in AFS being
acquired by Argentum Group, a New York based venture capital firm. Advised Vice
President, CEO, and IT Manager in identifying and eliminating severe ERP application
bottlenecks. Architected, documented, and recommended migration path to Board of
Directors.

      Utilized 10046 tracing to click through primary ERP modules to isolate and tune
       SQL bottlenecks and key waits
      Provided production Oracle DBA support to key customers in the US and Canada
       including RMAN, OEM, and basic database maintenance
      Configured RMAN backups integrated with Tivoli backup up directly to tape

      Identified and documented severe application bottlenecks in architecting long-
       term refactoring strategy for Velocity ERP currently serving as new strategic
       direction

      Providing benchmarking results and system architecture recommendation to
       Board of Directors under extremely compressed deadline of 30 days
      Authored custom benchmarking and load simulation scripts to document and
       validate limits of Velocity ERP application scalability
      Set undocumented SQL Server 1211 trace flag eliminating severe performance
       degradation and application hang occurring at customer site
      Performed all benchmarking and scalability testing of flagship ERP application
       running on Oracle 9i and Solaris 9

      Installed Solaris 9 and Oracle 9i on SUN FIRE 4800 loaner server for scalability
       testing


HDS McKesson, Scottsdale, AZ Jun 2002 – Aug 2002
Oracle DBA Consultant
Served as technical lead and mentor in eliminating business critical performance
bottlenecks for business-critical PAP OLTP application. Provided expert performance
tuning and PL/SQL programming skills to team of developers in implementing advanced
tuning recommendations. Mentored production Oracle DBA regarding application related
bottlenecks and new Oracle 8i features.

      Reduced OLTP application nightly batch processing from 12 hours to less than 90
       minutes
      Rewrote business-critical PAP application PL/SQL to eliminate recursive SQL
       and leverage index by tables along with BULK COLLECTING
      Tuned /etc/system Solaris 2.6 kernel parameters for OLTP database application
       including setting priority_paging=1, maxphys=1048576, and fastscan=131072
      Leveraged DBMS_PROFILER to explicitly identify and tune most intensive
       PL/SQL stored procedures and code routines in PAP application packages
      Recommended and documented strategy for migrating from Oracle 7.3.4 RBO to
       Oracle 8.1.7 CBO using stored outlines
      Developed and documented first import and export process allowing for dynamic
       synchronization of 255 table production schema with development environment
       using user defined subset of production data from driving tables
APS Energy Services, Phoenix, AZ Mar 2002 – Jun 2002
Oracle DBA Consultant
Served as Oracle lead and mentor to production DBA team in tuning both Oracle OTLP
and large data warehousing applications. Provided executive level Oracle data
warehousing best practices and tuning recommendations to DBA Manager and CIO.
Worked with Sr. UNIX administrators to implement Oracle and Solaris 8 best practices
including the purchase and installation of PowerBroker.

      Leveraged ER/Studio and OEM to model formal star schema dimensions and fact
       tables
      Analyzed and documented detailed refactoring strategy for Oracle data warehouse
       to leverage star schemas, valid dimensions, materialized views, query rewrite, and
       parallel DML
      Implemented first Oracle 8i data warehouse on Network Appliance F880 filer
       cluster
      Provided system architecture, design, and implementation of first enterprise
       database monitoring environment commissioned by CIO
      Converted Oracle data files to Veritas Quick I/O to reduce SWMS disk I/O
       bottlenecks
      Introduced and implemented Veritas Foundation Suite to APS DBA team
      Developed, documented, and communicated Oracle Best Practices including OFA
       (Optimal Flexible Architecture), Oracle Advanced Security, and naming standards
      Provided expert tuning and configuration parameters for implementing Oracle
       MTS (Multi-Threaded Server), connection pooling, and connection concentration
      Provided expert advice in eliminating memory leak and excessive parsing
       identified in business critical SWMS OLTP application at Palo Verde nuclear
       facility.


Wells Fargo, Tempe, AZ Apr 2001 – Mar 2002
Oracle DBA
Served as Sr. Oracle DBA providing sole database administration and 9iAS support for
web-based Activity Based Costing data warehouse. Provided expert database application
performance tuning, RMAN backups, as well as PL/SQL programming skills and
executive advice to Sr. Vice President of Wells Fargo Services. Interfaced with WANDA
team in SFO providing expertise and assistance regarding long-term refactoring of web-
based OLTP application. Assisted in planning, troubleshooting, and optimization of
Intranet reporting environment.

      Utilized STATSPACK with 10046 tracing to correct snapshot too old error and
       eliminate ETL related bottlenecks in PL/SQL packages
      Refactored 3NF schema using ER/Studio and IDEF1X convention to migrate to
       data warehousing schema having formal, valid dimensions
      Leveraged global temporary tables, Oracle collections, parallel DML, and larger
       redo logs reducing monthly batch processing of over 5 million records from
       almost 7 hours to 70 minutes and eliminating “ORA-01555 Snapshot Too Old”
       error
      Administrated, tuned, and documented business critical Oracle data warehousing
       application configuration and production processing steps
      Led high-profile 9iAS Portal Productivity Tool project for CEO of Wells Fargo
       Services serving as Sr. Developer and Data Architect
      Performed 9iAS upgrade specifically migrating to Forms and Reports 6i as well
       as Discoverer 4i
      Provided executive level advice to WANDA team in SFO in evaluating Business
       Objects and Oracle Discoverer
      Reduced batch processing undo from 7GB to approximately 400MB
      Leveraged Discoverer 4i utility to recommend, create, and refresh materialized
       views
      Introduced VPD and security policy to significantly enhance Intranet reporting
       performance previously hampered by use of views for end user authentication


Cyclone Commerce, Scottsdale, AZ Nov 2000 – Apr 2001
Oracle DBA Developer
Recruited by CTO and founder of Cyclone Commerce to scale J2EE e-commerce
application and provide expert mentoring to Senior Java developers regarding Oracle
internals and optimal JDBC coding practices. Assisted two teams of Java developers with
JDBC transactions, serialization, concurrency, and locking strategies. Recommended,
documented, and refactored various subject areas of application database schema.

      Installed and tested Oracle AQ with Oracle Message Broker for handling JMS
       based queuing service
      Refactored e-commerce data model to 3NF introducing referential integrity using
       Embarcadero ER/Studio
      Authored Java persistence layer for portion of commercial e-commerce
       application dramatically increasing application response time and scalability
      Tuned back-end Oracle 8i database and JDBC code to compensate for pessimistic
       locking and reduce enqueue waits
      Selectively tested and disabled Oracle DML locks at table level in order to
       improve EJB application scalability
      Tuned and documented backend Oracle 8.1.6 database for stress testing and
       certification of Monsoon application at SUN iForce lab
      Implemented and introduced Java developers to JDBC prepared statements, bind
       variables, and row prefetching to reduce parsing, network roundtrips, and
       excessive I/O
      Wrote Java API for streaming customer profiles to XML documents stored in
       Oracle CLOB


KnowledgeNet, Scottsdale, AZ Mar 2000 – Nov 2000
Oracle DBA
Reported to CIO of KnowledgeNet as Oracle DBA and Java Developer in scaling online
e-learning application. Served as primary Data Architect in designing backend database
schema. Worked with Sr. Engineer from TOPLink to optimize performance of J2EE
application persistence layer. Assisted Sr. UNIX Administrator in architecting and
implementing 24X7 production database environment.

      Utilized ERwin to model and otherwise modify e-learning application schema
       using IDEF1X convention
      Corrected chronic shared pool fragmentation by researching and setting new
       Oracle 8i CURSOR_SHARING=FORCE parameter to eliminate excessive
       parsing associated with the lack of support for bind variables by TOPLink
       persistence layer
      Assisted in refactoring of KnowledgeNet web site to JSP (Java Server Pages)
      Identified and corrected performance critical leak in Java connection pool
      Assisted in mapping TopLink persistence layer or Java objects to Oracle database
       tables
      Provided expert assistance to Sr. Java Developers to improve the response time
       and scalability of J2EE application including the use of bind variables and index
       hints
      Implemented Oracle MTS (Multi Threaded Server), connection pooling, and
       connection concentration in unit testing to optimize network performance
      Recommended and upgraded Oracle 8i database to utilize Veritas Quick I/O on
       dual E4500’s


America West, Tempe, AZ Mar 1998 – Mar 2000
Oracle Data Warehousing Manager
Provided instrumental advice and expert data warehousing skills to Sr. Director and Vice
President of Revenue Management in evaluating and selecting appropriate platform and
RDBMS for high-profile data warehousing project. Assisted in architecting first Revenue
Management Decision Support System. Developed and managed relationships with
outside vendors including Oracle, SAS, and Business Objects to coordinate the
evaluation of tools and champion the project with the various executive teams.

      Led first successful Oracle data warehousing project from requirements to full
       implementation using ERWIN in modeling Kimball star schema design
      Developed Discoverer and SAS reports for Manager of Pricing to accurately react
       to intra-day fare wars with Southwest and other competing carriers
      Led first successful Oracle data warehousing project at America West managing
       team of programmers and developers through entire lifecycle
      Worked with SABRE to ensure accurate cleansing of daily and monthly Advance
       Bookings and competitive fare data as defined in Service Level Agreement
      Assisted in training and mentoring of approximately 30 end users in developing
       both Discoverer and Business Objects enterprise reports
      Assisted in development of WebDB intranet site for CFO in championing the
       future development of web-based executive reporting
      Installed and administered Oracle Discoverer and Express Analyzer to develop
       exception reporting and DSS for executive management team
      Integrated SABRE advance bookings data with legacy scheduling database
      Led team of Oracle consultants in deploying MDDB using Oracle8i and Express
       Analyzer


OTHER EXPERIENCE:
US Airways, Arlington, VA May 1997 – Mar 1998
Analyst
General Motors, Moraine, OH May 1996 – Aug 1996
IT Auditor
AT&T GIS, Dayton, OH Feb 1995 – Sep 1995
Data Warehousing Analyst