Provided data modeling services utilizing E/R Studio referencing significant tables with supporting views,
stored procedures and SSIS solutions as required. OneNote was found to be an easy to use UI tool in
describing project scope, links to data models, system-to-system and data-to-application data flows.

1. Enhanced existing SSIS ETL packages supporting student, faculty and staff data associated with

   Oracle-based student registration, course management, student conduct and campus management.

2. Maintained campus wide Identity Management and Faculty Evaluation systems.

Assisted strategists in developing order attribution, marketing analysis via direct mail/email campaigns.

2 Participated as DA representative on a data warehouse engagements & quick impacts sizing team.

3 Provided data models and source mapping documents for several data warehouse projects such as
Consumer Price Optimization, Spanish Queue, Affinity, SFDC, Subscription Center.

4 Assisted with the initial implementation and change management of Dell’s enterprise data model based
on Teradata’s Manufacturing Logical Data Model utilizing Informatica and Business Objects

1 Oracle Datamart modeler and Ab Initio ETL graph developer supporting a Finance driven scorecard project
containing departmental performance metrics for Maintenance, Ground Ops, Flight Ops and Reservations.
2 Teradata data warehouse modeler for OLAP dimensional (star schema) passenger activity analysis and
terabyte sized relational airline operational data store.
3 Created prototype OLAP model supporting Cognos-based Revenue Management analytics.

1. Defined architecture and the build process for a new data warehouse focusing on insurance products and
   associated accounting systems. Profiled and documented data quality issues and assigned data stewards.

2. Recommended and purchased ER/Studio and Len Silverston enterprise data models in support of a model-
   driven, Inmon style architecture. Simplified and adapted the standard enterprise models in the creation of

3. NF logical and physical data models for finance, HR and sales data subject areas. Derived dimensional star
   schemas, a data aggregation strategy and associated source-to-target ETL specifications.