SUMMARY

Accomplished and resourceful Enterprise Data Architectwith expertise in leading teams in the development of operational, transactional OLTP , and decision-enabling systems, specializing in conceptual, logical 3NF and physical data modeling, 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, ASG Rochade Meta Data Repository, IBM Websphere Information Integrator, Information Analyzer

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

Data Management Business Analyst Contract

• Developing global strategy for Enterprise Data Management, including data architecture,
• Master Data Management, EDW, data modeling standards, meta data management, and
• Data Governance.Facilitating data discovery sessions with key subject matter experts.Reverse engineered LOB Data Warehouse using Erwin, and updated data model based upon Workplace Strategy and Property Management business reporting requirements. Developed model management and publishing process and introduced model review process with ETL, Reporting and DBA teams increasing system development productivity.

Confidential

Data Management Business Analyst Contract

Led analysis of current source data and mapping to target MDM IBM Insurance Industry database to master customer information transforming from policy centric data to customer centric. Facilitate business requirements gathering sessions with BA team and business subject matter experts. Utilizing Information Analyzer data profiling results to confirm and adjust source to target mappings. Capture and resolve issues, track and communicate progress and status to project management.

Confidential

Meta Data, Master Data Management Data Governance Project Manager Contract

Led selection and successful implementation of ASG RochadeMeta Data repository tool to manage business glossary, data governance workflow, and data lineage.Project delivered on time and under budget. Created and maintained project plan, status reports, change control, action items, issues and risks log. Utilized client PMO methodology to complete project management deliverables and pass project phase gates. Managed vendor, internal and external resources.LedData Governance program development and process implementation, andMaster Data Management tool assessment, RFP, and selection.

Confidential

Logical Data Modeler Contract

Maintain and validate Enterprise Guest MDM, 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

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.Maintained project 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.
• 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.
• 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.
• Implemented 5 MDM solutions to improve efficiency, improve data quality, and reduce business risk.
• 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 OLTP 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.
• 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.