We provide IT Staff Augmentation Services!

Senior Data Architect Resume

Houston, TexaS

SUMMARY:

A highly effective Senior Data Architect who meets challenges head - on and creates positive change. A creative and detail oriented professional with a record of success in data architecture, extract transform load (ETL) development, data modeling, data analysis, data profiling and master data management (MDM). A strong leader with a solid technical foundation and a reputation for developing teams, and leading them to achieve outstanding results in fast-paced, dynamic environments.

EXPERTISE AREA:

  • Data Archiving
  • Data Mapping
  • Data Lifecycle Management
  • Test Methods Development
  • Data Quality
  • Project Management
  • Employee Coaching/Training
  • Data Analysis
  • Data Governance
  • Unstructured Data Management
  • Process Design
  • Data Migration
  • Staffing
  • Design Verification
  • Dimensional Modeling
  • ER Modeling
  • Metadata Management

TECHNICAL EXPERTISE:

Extract Transform Load (ETL): DataStage 7.5, Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2005/2008R2

Data Modeling/Industry Models: ADRM Insurance Industry Model, Erwin, IBM Infosphere Data Architect, System Architect, PPDM Industry Model, Visio, ER/Studio

Master Data Management ( MDM): Master Data Services (MDS), Maestro, Data Relationship Management (DRM), Informatica MDM

Database: Access, SQL Server 2005/2008 Management Studio, Oracle, MySQL, Teradata, TOAD 12.5

Reporting: Cognos, SSRS, Business Objects 4.0, Essbase

Data Profiling: Trillium

Testing: Mercury Quality Center

Concepts: Data Warehousing (DW), Kimball Method, Star Schema, Business Intelligence (BI), Metadata Management, Master Data Management (MDM), TOGAF

Software: Excel, Business Intelligence Development Studio, Composite, SharePoint, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

Senior Data Architect

Responsibilities:

  • Worked with other key roles such as Business Analysts, Data Architects and DBAs to gather requirements and design and build the data models
  • Created architecture documents for different stages of the project life cycle which were used by developers to build the solution
  • Worked with OLTP and OLAP systems
  • Responsible for maintaining, updating and creating MDM data models
  • Designed Logical Data Model (LDM) using Erwin 9.6 data modeling tool

Confidential, Houston, Texas

Senior Enterprise Data Architect

Responsibilities:

  • Worked with other key roles such as Business Analysts, Data Architects and DBAs to gather requirements and design and build the data models
  • Created architecture documents for different stages of the project life cycle which were used by developers to build the solution
  • Responsible for the architecture of the project
  • Worked with OLTP and OLAP systems
  • Responsible for maintaining, updating and creating MDM data models
  • Designed Logical Data Model (LDM) using Erwin 9.5 data modeling tool
  • Evaluated existing data models and physical databases for variances and discrepancies
  • Used Erwin web portal to communicate to business users the current status of the data models
  • Designed Physical Data Model (PDM) using ERwin 9.5 data modeling tool and PL/SQL and T-SQL
  • Managed meta data for data models

Confidential, Houston, Texas

Project Lead Architect/Data Modeler

Responsibilities:

  • Worked with ERStudio and Composite to extend Confidential ’s architecture
  • Designed Logical Data Model (LDM) using ER/Studio data modeling tool
  • Created the data mappings for various upstream related data entities and attributes from source systems to Confidential ’s architecture
  • Designed Physical Data Model (PDM) using ER/Studio data modeling tool data and T-SQL
  • Upstream Production Revenue Accounting (PRA) Consultant (Client - Devon Energy) Worked with Devon monitoring daily issues that occurred in their PRA system.
  • Worked with PPDM 3.7 & 3.8 TOAD 10.6, SQL Server 2008, Informatica 9.1, Quality Center, SAP ECC 6.0
  • Responsible for Division of Interest Data, Volumes Data and Master Data
  • Used ER/Studio modeling tool and PPDM data model
  • Designed Conceptual Data Model (CDM)
  • Data Governance
  • Designed Logical Data Model (LDM) using ER/Studio data modeling tool
  • Designed Physical Data Model (PDM) using ER/Studio data modeling tool and ORACLE
  • Used PPDM data model for upstream industry best practices
  • Used ERWIN modeling tool and PPDM data model
  • Designed Logical Data Model (LDM) using ERWIN data modeling tool
  • Data Governance
  • Designed Physical Data Model (PDM) using ERWIN data modeling tool and ORACLE
  • Created the data mappings for Well Header and Business Associate related data entities and attributes from source systems to PPDM

Confidential, Houston, Texas

Upstream MDM Consultant

Responsibilities:

  • Provided consistent functionality to reduce existing maintenance
  • Aligned critical enterprise dimensions (Field & Account) across systems
  • Business Objects Consultant (Client - Lexmark) Worked with Lexmark client stakeholders to assess current reporting needs, put together a level of effort, gather requirements and scope the project.
  • Documented functional and technical designs of reports
  • Mapped columns from source to Teradata target database

Data Architect Consultant

Confidential

Responsibilities:

  • Designed Common Information Model (CIM) using IBM Infosphere Data Architect data modeling tool
  • Designed Logical Data Model (LDM) using IBM Infosphere Data Architect data modeling tool
  • Designed Physical Data Model (PDM) using IBM Infosphere Data Architect data modeling tool and ORACLE PL/SQL

Upstream MDM Consultant

Confidential

Responsibilities:

  • Provided a detailed handling of data versioning at both the entity and hierarchy levels in MDS
  • Data Governance
  • Developed a data security diagram indicating which actors had access to which enterprise data
  • Created mapping specifications of data from source, (PPDM) and (Excel Spreadsheets) to target, Master Data Services (MDS)

Confidential, Houston, Texas

Data Architect

Responsibilities:

  • Designed logical data model and physical data model using Visio and MySQL
  • Strong Functional Knowledge of Manufacturing Domain.
  • Possessed capability to understand existing data models and thereby understand the business model. Provided solutions for integrating and developing new data models by understanding customer's business.

Confidential, Houston, Texas

Data Architect

Responsibilities:

  • Turned application requirements into data model specifications which were used for developers to build the solution
  • Reviewed design documents to understand where data model structures can address requirements.
  • Designed logical data model and physical data model using system architect and T-SQL
  • Reviewed, updated and validated data model with key business/technical representatives and end users.

Hire Now