SUMMARY

Over 20 years of IT experience in Enterprise Data Architecture, Data Integration and Data Modeling. Designed and Implemented several large data warehouse projects utilizing a variety of methodologies, and technology design approaches providing a full range of enterprise services and solutions for both relational and multi-dimensional platforms. In-depth knowledge and expertise for Information Management in areas of Enterprise Architecture Planning, Data Governance, Master Data Management, and Data Warehousing. Design several large terabyte projects for various industries: Financial Services, Manufacturing, Retail, Energy Services Oil Gas, Pharmaceuticals, CPG, Telecommunications, Education Sector, Aerospace and DOD.

SKILL SET

• Data Warehousing EDW relational/dimensional modeling, star schema/cube design, MDM hub design, ETL and BI design
• DBMS Oracle, Netezza, Teradata, DB2/UDB, SQL Server 2008, Sybase, MS Access IMS
• Data Modeling Relational, Dimensional, Data Vault Modeling, MDM Hub, ODS, Structured/Unstructured and OLTP
• Operating Systems Linux, UNIX - Sun Solaris, Dec Alpha, HP-UX, NT, OS2, MVS
• Life Cycle Expertise Requirements analysis, BPR, design, coding, testing, database tuning and DB Admin
• Methodologies Inmon, Kimball, Zachman Framework, TOGAF-V9, IDEF, IE, and Six-Sigma
• Management Lead Enterprise Data Architect/Data Modeler, MIS Dept. Manager, DBA and Project Lead
• Languages SQL , VB, Assembler, COBOL, FORTRAN and CICS
• Other Products/Tools Erwin 9, Power Designer, ER/Studio, Informatica, Data Stage, MS Project, Business Objects

EXPERIENCE

Confidential

Role Senior Data Architect

Data Architect for Merck's Global Complaints project. Working with SME's I designed the enterprise data foundation layer for Merck's Manufacturing Division. The foundation blueprints support both current and future project development initiatives. Create the Semantic/Conceptual Data Models for customer product complaints using Erwin modeling tool. The model supports both transactional and master data structures. Develop a data dictionary that included the enterprise data subject areas and their related data objects. The dictionary included a traceability matric that mapped back to the data foundation blueprints. Coach the team using data integration leading practices approach.

Confidential

Role Enterprise MDM/Data Architect

MDM/Data Architect for Chevrons Upstream Appalachian Michigan Business Unit AMBU . Champion an enterprise architecture planning effort to outline the client's future state business model for data, process and technology. The plan included a 3-5 year road map. Define/design an MDM solution for well master data. Design the Data Warehouse and MDM hub conceptual, logical and physical data models in support of a future Data Foundation Strategy. The MDM hub supports the client's goal to improve Well exploration, development, production and field management and complies with regulatory environment, health and safety policies. Coach a team of data architects and business analysis using data architecture leading practices. Develop an approach utilizing Zachman's Framework that integrated their current project life cycle methodology and provided the foundation blueprints for future project development initiatives.

Confidential

Role MDM/Client Reference Data Architect

MDM Data Architect for Credit Suisse's client reference data change program within the investment bank. The reference model supports the client's goal to improve client service, operational efficiencies and regulatory response. Mentor the data modeling team in the art of conceptual and logical data modeling employing industry leading practices. Develop a methodology/approach that provided the framework for ongoing data model creation. Create normalized LDM's for MDM Hub that included Party, Portfolio, Document, Geography etc., including, complex Hierarchy structures. In addition, the design accommodates the MDM Coexistence style hub for a client master data solution. Defined history and future effective date process standards and incorporated approach into the data models. Developed and presented several work shop presentations for both business users and Information Technology developers and data architects.

Confidential

Role Lead Data Architect /Data Modeler

Lead Enterprise Architect for Caterpillar's Product Electronic Data Warehouse PEDW . Conducted top-down/bottom-up requirements analysis surveys and delivered the clients enterprise data requirements. Designed a target enterprise data model solution that will enable the client to create a single point of truth and establish an environment that can be easily extendable for both transactional and master data. Create conceptual, logical and physical data models that reflect a high level view of company business across multiple data subject areas. Present a data integration proposal with comparisons pros/cons between Kimball and Inmon approaches.

Confidential

Role Data Architect

Data Architect for Bank of Confidential Global Corporate, Commercial, and Investment Banking Technology GCCIBT organization. Decommission 2 data marts and expanded the data model of an existing Oracle DW used as their Data Mining and Metrics repository. Implemented a top-down/bottom-up analysis approach to assess the current warehouse environment and extend the to-be data models.

Confidential

Role Enterprise Data Modeler

Enterprise Data Modeler involved in Wells Fargo's mortgage servicing DW redesign effort. Design supports the bank's Mortgage Integrated Data Environment MIDE initiative to provide a single source of truth against which servicing data can be reported. Design conceptual/logical data models over 500 entities in Power Designer using Teradata's FSLDM template. Maintain the models in the Power Designer Repository. Map data requirements from the Fidelity Mortgage Servicing Platform on Oracle against target data models.

Confidential

Role Global EDW Data Architect

Enterprise Data Architect for Kimberley Clark's global enterprise data warehouse initiative. The design supports their strategic capabilities roadmap for innovation measurement, trade promotion, customer relationship, talent management etc. Develop processes, practices, data standards and a data modeling methodology. Utilize an approach that associates standard content, structure and format to the appropriate layers of the DW Architecture. Created data models consisting of over 1000 entities across 15 data subject areas of the enterprise including: conceptual, logical and physical design structures. Designed dimensional data models and integrated new data mart projects in parallel with the EDW design effort. Defined, implemented and centrally governed the data modeling standards and tool nomenclature for the enterprise including tool evaluations and recommendations. Mentor the team in data architecture principles.

Confidential

Role Data Architect

Data Architect for Freddie Mac's financial data warehouse initiative. Design the Integrated Data Repository IDR including conceptual subject area and logical data models leveraging their Canonical Data Model CDM with 800 entities supporting over 40 legacy application systems. The design supports Single Family, Multi Family and Investment Capital Mgmt. LOB's. Create dimensional data model structures for Single Family Credit, T E and Forecast Planning. Create database objects for high performance reporting.

Confidential

Role Enterprise Data Architect

Enterprise Data Architect supporting Qwest Communications global enterprise data warehouse for sales, marketing, and overall churn new unit orders/disconnects of various products. Evaluate TELCO reference data model for an enterprise data solution. Define an approach for identifying, collecting, validating, and integrating requirements with the enterprise data model. Present standards and techniques for load performance, CDC, and history tracking. Developed data models supporting staging, integration and data mart layers

Confidential

Role Data Architect/Data Modeler

Data Architect for Yale Universities Capital Management Budget Planning initiatives. Create conceptual/logical models across multiple data subject areas. Translate analytic business requirements into dimensional designs. Solution extends the current Yale EDW Mart environment landscape. Develop data standards, data mappings, load strategies, CDC, and history tracking solution.

Confidential

Role MDM/Enterprise Data Architect

Tasked with enterprise designs for DW/BI and MDM solutions supporting client financial services and retail LOB's. The warehouse provides corporate level reporting for key business metrics across all segments and products. Create conceptual data model that reflects a high level view of the company's business across multiple subject areas. Develop MDM, ODS and EDW logical physical models over 1000 entities . Created dimensional models for loan activity, check cashing, collections, customer portfolios and sales. Design in parallel with a major client conversion of operational systems involving resolution of MDM data integration issues.

Confidential

Role Sr. Data Modeler

Design data marts for the Certified Pre-Owned CPO division. Create models that align with the current CPO EDW. Designed dimensional data models for tracking a visitor's web site activity i.e., number of clicks, searches, page views and prospects.

Confidential

Role Enterprise Data Architect

Hardware/Software Sun Solaris, Oracle, SAP, Erwin, PL/SQL Developer, Informatica and Business Objects

Enterprise Data Architect for Ameritrade/Waterhouse acquisition and data integration initiative. Develop conceptual subject area data models. Create executive scorecard showing key parts of organization's success with insight into the company's overall health.

Confidential

Role Data Warehouse Architect

Hardware/Software HP-8400 - Teradata, ER/Studio, Data Stage, Business Objects, People Tools MDM

Data Warehouse Architect for TBS financial data warehouse project. Design an integration layer supporting the Financial Reporting Data Mart for tracking revenues/expenses against forecasted and budgeted plans. Create data model using ER/Studio tool.

Confidential

Role Lead DW Architect

Hardware/Software HP-8400 - Oracle 10g, DB2, Erwin 4.1, Harvest CM, Informatica, IBM Info Integrator

Lead DW Architect contractor for BearingPoint. Supervised data modelers DBA's designing an ODS for the DOD Item Reference Data Warehouse project. The models included over 800 entities supporting both relational and dimensional tiers.

Confidential

Role Lead Enterprise Data Warehouse Architect

Hardware/Software HP-UX Superdome Server - Multi TB, UDB 8.1, Erwin, AB Initio, SAP, Cognos and IBI Web Focus

Design relational and dimensional layers for SunTrust EDW. Develop approach for implementing an EDW solution.

Confidential

Role Data Architect/Data Modeler

Hardware/Software Sun Solaris, Oracle 9i, Oracle 9i Lite, DB2, Erwin 4.1, Informatica, Business Objects,

Design an enterprise data architecture environment for the GE Rentals Division. Developed normalized relational and dimensional financial data models for job costing, customer history, fleet util., and project installation.

Confidential

Role Data Architect Consultant

Hardware/Software Solaris, HP, Teradata, Oracle 8.i, Access 2000, Erwin, Brio Enterprise, TOAD

Provide the Telco's with dimensional and OLTP data modeling support. Design multi-tier extensible data architecture and load strategies supporting top-down/bottom-up design implementations. Mentor various junior consultants in the art of Data Modeling.

Confidential

Role Senior Data Warehouse Consultant

Hardware/Software UNIX, NT, Oracle Express, Sales Analyzer, Designer/2000, Oracle Financials,

Design an environment that supports multi-tiered platform architecture for UNIX/NT, Oracle 8.i, and Oracle Express. Develop star schemas, multi-dimensional cubes and physical objects providing optimal performance. Design supports EDI from point-of-sale system.

Confidential

Role Relational Data Modeler

Designed dimensional models using Oracle Designer/2000 created physical database objects in Oracle 8i for Credit Risk Mgmt. DW.

Confidential

Role Dimensional Data Modeler

Hardware/Software HPUX10, SAP R/3, Oracle 8.0.5, TOAD, Hyperion Essbase Server, Brio Enterprise

Design dimensional models multidimensional cubes for Financial DW. Transform data from SAP into an Oracle database.

Confidential

Design Software Engineer Metrics DW to provide access to company software process metrics supporting their SEI/CMM Initiative.