World renowned watercraft manufacturer
Project Manager and Technical Lead for the design of a new data warehouse. Interviewed users, gathered requirements, and designed Logical Data Model. Analyzed Source data, an ERP system on AS/400. Developed detailed implementation plan from physical database creation to deployment of Data Warehouse to end-users. Recommended Hardware and Software solution.

Largest host of local news and information destinations
Project Manager and technical lead for new Clickstream data mart initiative. Designed and developed dimensional data model to support Clickstream analysis for 100 distinct web sites. Documented Business Requirements and Metadata. Hands-on leader of database implementation using Microsoft SQL Server.

National retailer and department stores operations
Provided review and recommendation for the data warehouse design, data extraction, transformation and load processes, and data warehouse project manager procedures. Advised Data Warehouse team in Slowly Changing Dimension strategies to optimize customer householding process. Recommended index strategies, proven dimensional modeling techniques, bulk load methods, and Hardware and software selection criteria. Environment was Sybase ASE, DataStage and BusinessObjects.

Pioneer dot-com company
Modeled Data Marts for several subject areas together with Clickstream web activity. Utilized DW-Bus Architecture, including conformed dimensions and standardized facts. Project included UNIX/Oracle8 OLTP and a mix of Hyperion Essbase and UNIX/Oracle8 targets. Also created meta topics, EIS screens and reports using Brio 6.1.

Leading e-commerce solutions provider
Technical adviser for this Data Warehouse project. Provided design review and recommended design changes for Clickstream and Sales data mart models.

Leading provider of strategic human resource solutions
Project Leader of new Customer Revenue data warehouse implementation. Modeled data mart and designed the ETL processes using Microsoft SQL Server 7 Data Transformation Services. Gathered requirements, planned project and maintained budget. Project included the migration of client data with demographic data purchased by Dun.

Leading manufacturer, seller and distributor of beverages
Lead Informatica Architect for migration from DataStage to Informatica. Developed Informatica Best Practices and Standards for the Data Warehouse ETL group. Recommended implementation strategy for maximum utilization of Power Center 5.0 features. Created project plan for conversion of approximately 200 DataStage jobs to Informatica mappings.

World-wide leading management consulting firm
Created logical ETL mapping of Source-to-target transformations and associated metadata for Enterprise Data Warehouse. Analyzed source systems and recommend data quality strategy for 70 years of data. Wrote ETL best practice and load strategy documents; worked with off-shore development team.

World renowned watercraft manufacturer
Directed the creation of logical Extraction, Transformation and Load mappings from source system to new Data Warehouse data model. Analyzed Source data, an ERP system on AS/400. Developed detailed ETL implementation plan. Recommended Hardware and Software solution.

Largest host of local news and information destinations
Project Manager and technical lead for new Clickstream data mart initiative. Hands-on leader of ETL development.  Project included consolidating and parsing web logs from web farm, integrating web site activity from load balanced environment to present cohesive and comprehensive representation of web site usage and user experience. Implemented ETL using Informatica PowerMart.

Pioneer dot-com company
Technical leader of database design and ETL process of new Data Warehouse initiative for the General Merchandise division. Modeled Data Marts for several subject areas together with Clickstream web activity. Utilized Data Warehouse-Bus Architecture, including conformed dimensions and standardized facts. Wrote data extract, transformation and load mappings using Informatica PowerMart. Project included UNIX/Oracle8 OLTP and a mix of Hyperion Essbase and UNIX/Oracle8 targets. Also created meta topics, EIS screens and reports using Brio 6.1.

Global financial services company
Developed extract, transformation and load mappings using Informatica PowerMart for the Global Assets Division Data Warehouse. The source was primarily from external vendors including Bloomberg L.P. The target was UNIX/Oracle8.
Leading provider of insurance and financial services

Directed a team of consultants and employees to successfully implement a data warehouse for the Marketing Group. Wrote specifications, designed and implemented a custom data extraction, transformation and load application. Scrubbed, transformed and loaded mainframe data into DB2/2 data warehouse on NT. Tuned and optimized DB2/2 data warehouse.

Leading dot-com company
Advised client on making the proper selection of ETL and user access products based on specific requirements and budget.
National retailer and department stores operations

Provided review and recommendation for the data warehouse design, data extraction, transformation and load processes, and data warehouse project manager procedures. Advised DW team in Slowly Changing Dimension strategies to optimize customer house holding process. Recommended index strategies, proven dimensional modeling techniques, bulk load methods, and Hardware and software selection criteria. Environment was Sybase ASE, DataStage and BusinessObjects.

Business intelligence
Business Intelligence application development projects. Largest Host of local news and information destinations.
Documented Business Requirements and Metadata. Hands-on leader of database implementation, ETL processes and analysis layer using ER/Win, Microsoft SQL Server 2000, Informatica PowerMart 4.7.2 and Brio Enterprise 6.2.2.

Pioneer dot-com company
Modeled Data Marts for several subject areas together with Clickstream web activity. Also created meta topics, EIS screens and reports using Brio 6.1.

Leading provider of insurance and financial services
Directed a team of consultants and employees to successfully implement a data warehouse for the Marketing Group. Created Cognos Impromptu Catalog. Developed canned Cognos Impromptu reports. Designed Cognos PowerPlay multidimensional Data Cube.

Leading marketing services company
Directed consultants on Business Objects Universe Design, SQL query optimization, SQL Server 7.0 Database optimization techniques, Data Modeling, and Entity Relational Analysis.