CIO

Consulted for IBM at AT&T / DirecTv as a data architect in the Big Data BI group, specializing in model driven development.

Worked at iHeartMedia's (formerly Clear Channel) enterprise data warehouse as the lead data architect. We followed Inmon's Corporate Information Factory approach. Embarcadero Data Architect was the modeling tool. Responsibilities included: logical modeling; physical modeling; DDL generation; source to target mappings; data profiling; virtual data marts; etc.

Worked on an enterprise data warehouse for a financial institution in Washington state. The warehouse follows Inmon’s Corporate Information Factory. My responsibilities include: working with the client, other data architects on the review of their solutions; logical and physical data models, ETL rules, etc.; DDL generation; lead JAD sessions.

Last assignment was with T-Mobile in Bellevue, Washington. We implemented Teradata's Communications Logical Data Model (CLDM), which follows Inmon's Corporate Information Factory model. I worked as the data architect for multiple projects, all related to the usage and expansion of the enterprise data warehouse implemented on Teradata.

Lead, enterprise data warehouse architect utilizing Inmon’s Corporate Information Factory model on Teradata, implementing Teradata’s FSLDM (Financial Services Logical Data Model) tailored to Washington Mutual. Erwin and Model Manager are used as the enterprise modeling software. Supporting the transition of the enterprise data warehouse from WaMu to JPMorgan Chase.

Was employed as the lead data architect for the ODS, data warehouse, and new application systems. In addition, serve as business analyst for new application systems. Following Inmon’s Corporate Information Factory model and Dan Linstedt’s Data Vault modeling approach to data warehousing . As listed below, we are using Oracle 9i and 10g, Oracle Designer, SQL Developer, Oracle Warehouse Builder, and Visio for UML modeling.

Was on assignment with Denver Public Schools as a lead data architect modeling an enterprise ODS integrating data from numerous sources. The ODS becomes the source of data for the data warehouse, using the Data Vault modeling technique. The data warehouse is then the historical, or point in time data supplier for both real and virtual data marts: 3NF and dimensional. We used Oracle 9i and 10g, Oracle Designer, Discoverer, Toad, and Oracle Warehouse Builder.

• Completed a 4.5 year assignment at the Boeing Co. in Seattle, working as a system architect / data architect for a data warehouse, a data mart, an ODS, and a custom ETL tool, all using Oracle Designer 2.1.2, 6.0, and 6i. The data was sourced from an object oriented database on top of Oracle, the warehouse and ODS were implemented relationally in TeraData with a dimensional model for reporting purposes, the data mart in SQL*Server for a separate group that wanted its own data for reporting purposes, and the custom designed ETL tool in Oracle. Responsibilities included: JAD session facilitator to work with users to model necessary data and processes; lead data architect / data modeler; lead process / function modeler; logical, physical, and dimensional data models; source to target mapping; web based forms generation from the documentation; DDL generation; mentoring. Worked with the DBA team for implementation of business rules and tuning.• 4 years working on an assignment at the Kellogg Company in Battle Creek. Helped create and was a key member of the Information Architecture team. Using Designer 2000, the team developed and implemented an enterprise wide data model for North America. This model integrated legacy, package, and custom applications into a centralized, enterprise database that all additional efforts’ data was sourced from. I was used to start the development of numerous systems based on the enterprise model, including order management’s distribution of data to the numerous warehouses for shipping. Responsibilities included: JAD session facilitator; lead data architect / data modeler; lead process / function modeler; logical and physical data models; forms and reports generation; DDL generation; mentoring. Was a leader in the spreading of the use of the enterprise data model to other project teams and user groups. • Other assignments included MMD in Kansas City; the US Navy; OMRDD, a division of New York State government.