SUMMARY

Accomplished and resourceful Enterprise Data Architectwith expertise in leading teams in the development of operational, transactional, and decision-enabling systems, specializing in conceptual, logical and physical data modeling, including star and snowflake schemas, master data management MDM , Meta-data management, data governance, data quality, project management, and cross functional joint application development JAD facilitation. Takes on increasing challenges, while implementing the criticalshort- and long-term organizational objectives, while working in a time-sensitive environment.

KEYSTRENGTHS

MANAGEMENT: Leadership, team and relationship building, customer and vendor management

DATA MANAGEMENT TOOLS:ERWin,Power Designer, ER Studio, CA Advantage Data Repository, IBM Websphere Information Integrator

DESKTOP TOOLS: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Project, Visio, Sharepoint

METHODOLOGIES: Waterfall, Agile, Service-Oriented Architecture SOA , Object Oriented, Information Engineering, Structured Analysis and Design, Total Quality Management

PROFESSIONALEXPERIENCE

Confidential

BI Project Manager

Confidential Enterprise Data Warehouse, and Account logical data models from an enterprise perspective in collaboration with business subject matter experts, data architects and other data modelers. Perform data mapping between source MDM data model and the target EDW data model. Utilize ERWin Model Mart to manage data models. Introduced business aligned model alternatives of concepts previously modeled from a legacy technical perspective leading to healthy debate on the direction of the logical data model. Uncovered client requirements and subsequently collaborated with Teradata for update to Standard Industry Model.

Confidential

Data Modeler Contract

Created and maintained logical and physical data models across the staging, MDM core, semantic layer, and data warehouse database environments to reflect business requirements for retail sales, distribution, and inventory, and technical meta data.Lead the MDM Product logical and physical data model validation and update process moving the project forward in the completion of Functional Design within the Product Data Management Program. Collaborated with business SMEs, business analysts, data analysts, information analysts, functional and technical designers to ensure the data model supported the business requirements. Proposed recommendations for and obtained project team consensus on data model updates. Used ERWin to implement 300 logical and physical data model updates. Created semantic views used to publish data for data consumption across the enterprise. Generated DDL for Teradata target DBMS.

Confidential

BI Project Manager

Led the development and delivery of Business Intelligence Competency Center using agile methodology. Created and maintained project plans, project tracking log of changes, issues, action items, and decisions. Facilitated daily scrum sessions and status updates to client management.Managed dependencies between business analysts, laboratory development, and operational development teams.

Confidential

Principal Consultant

Led the development and delivery of data requirements for a Managed Meta Data Environment in support of the Master Data Management program and related Data Governance. Developed and maintained project plans and weekly status report. Gathered and documented requirements and translated into conceptual, logical and physical data models using Erwin forMeta data subject areas of Data Structures, Data Lineage, Business Semantics, Business Data, Business Rules, Data Governance, Data Quality, Security Classification and Systems.Developed and maintained attribute list to requirements matrix. Created Use Case Diagram for the Input Layer of the Managed Meta Data Environment and Manage Data Lineage use case.

Confidential

Lead Data Architect - Contract

Developed conceptual, logical, and physical data models with ERWinfor the MDM Product Data Hub. Developed data architecture to integrate data from disparate product systems, manage the data in the hub environment, and to consistently and predictably publish and distribute the data from the hub. Facilitated workshops to gather business requirements from business subject matter experts.

Confidential

MDM Project Manager

Assumed project management responsibility for the Global Supplier Data Master, an MDM project, automating manual paper workflow process to maintain vendor data across the across the enterprise, and integrating data from 136 ERP systems within the Global Supply Chain Program. Entered the project as QA testing phase began for first production release. Planned and aligned resources for subsequent releases, in addition to managing the delivery of the current release. Quickly established productive working relationships with business and technical management teams, infrastructure, application development, data architecture, QA and training teams. Managed project resources, both internal and external.Maintainedproject timelines and status reports. Facilitate issue and conflict resolution.

Confidential

Lead Data Modeler/Architect - Contract

• Leading data modeling process improvement with a specific focus on data modeler DDL generation and hand-off to DBAs for the enterprise with the goal being 100 data modeler DDL generation for all databases.
• Developed data maps from conceptual data model levels 0 and 1 to physical data models, while working with other data modeler to develop logical data model for the EDW-CRM data warehouse using ER Studio.
• Led the development of the conceptual and logical data model for the Regulatory Evaluation and Validation business application from scratch. Facilitated data modeling sessions with subject matter experts to gather data requirements and meta-data. Utilized advanced functions of PowerDesigner to import and use the enterprise lexicon eliminating the time needed to enter table and column abbreviated names into the model.

Confidential

Manager, DataResourceManagement

• Collaborated with business and technical leaders to maintain resource alignment that reflected corporate priorities, goals, and objectives. Worked with Project Managers, Business Analysts, DBAs, developers, QA testers, vendors, and business users throughout the System Development Life Cycle to ensure on-time and within-budget system delivery.
• Assumed responsibility for 4 Master Data Management system applications.
• Developed and implemented department vision and strategic and tactical plans for attaining vision.
• Designed data warehouse model to track trends of credit attributes over time by various geographic areas.
• Facilitated workshops to design data warehouse for the Mexican Credit Bureau within the International Division for customer, product, and sales data over time.
• Developed logical data model using PowerDesigner transforming credit reporting database to a relational DB2 database with 24 x 7 availability, reduced database update cycle time to 1 day from 7 days, and provided capability for rapid enhancements to the database with new kinds of data allowing the business to offer new products and enhanced credit reporting services for additional revenue.
• Led and managed an enterprise-wide shared service data architecture team of data modelers, Master Data Management developer, and meta-data repository administrator. Established and continuously improved processes to manage 5000 tables for operational and business intelligence applications across the organization at the enterprise, business unit, and application area levels.
• Implemented 5 MDM solutions to improve efficiency, improve data quality, and reduce business risk.
• Transformed Enterprise Reference Data updates to a predictable process, while providing flexibility to update data in response to unplanned business needs, and application-specific release schedules.
• Led implementation of data distribution technology for, IBM WebSphere Information Integrator, for the MDM practice. Results were predictable updates to over 200 master reference tables and distribution of data updates across the enterprise, across DB2, Oracle and Sybase databases on mainframe and open systems environments, and elimination of redundant and inefficient ETL.
• Developed, implemented and managed data governance processes.

Confidential

JointApplicationDevelopmentFacilitator Contract

Held responsibility for the facilitation of 1- to 4-day sessions for various business units delivering project plans, business process models, business requirements, screen and GUI designs, problem analysis, test planning, and alternative prioritization.