We provide IT Staff Augmentation Services!

Senior Data Modeler Resume

SUMMARY:

  • I am an Information Technology Data Professional, with proven performance and Data Centric expertise, in the following industries: Telecom, Wireless, Insurance, Mortgage, Finance/Banking, Government entities Confidential and Confidential .
  • Analyze data across multiple sources to update, design and document Logical and Physical Data models. Gather, document and define data requirements based on Business Requirements.
  • I have successfully demonstrated expertise in the following areas, Logical Data Modeling and Physical Data Modeling using Erwin and ER/Studio, Data Architecture development, Requirements Gathering and Design, reverse and forward engineer across multiple relational databases and source to target data mapping.
  • The Logical models are designed to be used across multiple RDBMS (Oracle, Teradata, DB2, SQL Server, etc.).
  • I work with ETL teams to create source to target mapping, data profiling and project management.
  • I have been the lead and also main contact point for translation efforts of Business Requirements into detailed systems specifications.
  • I have a strong knowledge and understanding of Data Modeling and Data Governance, Meta Data Management, Master Data Management and Data Management best practices.

PROFESSIONAL HISTORY:

Confidential

Senior Data Modeler

Responsibilities:

  • Responsibilities are to perform Requirements Analysis and maintain Domain and Metadata Reference Value data for National Carrier application within AGILE development environment.
  • Perform logical data modeling and Enterprise logical model data dictionary management.
  • Ensure data standards are followed and review new models to verify their compliance to standards.
  • Support Enterprise strategies for sharing metadata across applications.
  • Generate DDL for various client database environments.
  • Document databases and create PDM with functional Domain areas.

Confidential

Data Architect

Responsibilities:

  • Perform analysis manage Domain and Metadata Reference data.
  • Create logical data models and generate DDL for DBA.
  • Enterprise logical model data dictionary management.
  • Ensure data standards are followed and review new models to verify their compliance to standards.
  • Support Enterprise strategies for sharing metadata across applications.

Data Architect

Confidential

Responsibilities:

  • My responsibilities were to perform analysis on Metadata application that contained Enterprise Mortgage Data dictionary and recommend changes to redesign in order to support Enterprise strategies for sharing metadata.
  • Track mapping of data that would be migrated to a vendor hosting application.
  • As part of this Vendor integration project, I interfaced with DBA and the BI - Appliance team to ensure data was mapped and available and well defined for their usage.
  • This included communicating closely with Business Analysts and reviewing mapping of data across systems as well as downstream interfaces.
  • I created a Data Matrix Model and proof of concept database to track data across the Enterprise.

Metadata Manager/Sr. Data Modeler

Confidential, Fort Belvoir, VA

Responsibilities:

  • I worked as the Metadata Manager responsible for capturing and monitor the quality of metadata being captured and loaded into the enterprise platform.
  • Worked as part of Data Architecture team to create governance strategies and enforcement polices for metadata platform.
  • Part of the task also required consulting and performing data modeling function to assist various government programs where assistance was required
  • Using Erwin data modeler, I created and managed logical models and ensured they meet the governance standards and that those standards also include metadata mapping strategies.
  • I documented metadata strategies as they applied to enterprise Data for Interface and Enterprise Reporting.
  • Worked with shareholders across the enterprise to train and get their support to champion the Metadata data strategy across the enterprise.

Sr. Data Modeler

Confidential, Fort Lee, VA

Responsibilities:

  • I am one the Data Architects and Modelers working on the Enterprise Strategy and implementation plan for applications to support Commissary operations in the ODS and Data warehouse environment.
  • Using Erwin data modeler, I create and manage logical models and supported the creation of physical models on the Teradata platform.
  • This included meeting with the Business Systems Analysts and Product Manager for the verification of business requirements and processes across the Retail Enterprise.
  • I also support the creation of matrix documents to map Data requirements to Business rules and map requirements to Data models.

Sr. Data Modeler

Confidential

Responsibilities:

  • I lead the modeling task for the creation, reverse engineering and maintenance of data models to ensure compliance with Data Standards used by Confidential
  • Developed the logical data model (LDM) and assisted the DBA in developing the physical data model (PDM).
  • Responsible for facilitating JAD sessions to determine data rules and LDM and PDM Reviews with Data SMEs.
  • Responsible for the application of enterprise Data Naming Standards, checking models in and out of Erwin Model Repository, and documented data model translation decisions.
  • This included use of data profiling tools and techniques, and development of review and QA data requirements.
  • Worked closely with architecture to ensure standards were being followed.
  • Lead data modeling efforts to support Web Analytics projects in the Digital space.
  • I worked on the Enterprise Modeling team to integrate models from different lines of business into the Enterprise Logical Data Model.
  • Led effort to map Teradata FSLDM data model to determine viability with existing Enterprise model.

Confidential

Data Architect & Metadata

Responsibilities:

  • Reverse ddl files into data models and apply industry standard best practices.
  • Use Erwin and ER studio to update and convert models to new target environments, i.e. ORACLE, DB2, SQL Server, and ACCESS.
  • Update architectural diagrams and document migration plans for source data to target mapping.
  • Create high level ODS designs and map them to Data Warehouses.
  • Mapped requirements to Business rules and then mapped requirements to data model and create first phase of physical model.

Confidential

Sr. Data Modeler ­­­­­

Responsibilities:

  • I provided data governance and modeling support within Confidential .
  • I created, reverse engineering and maintenance of data models to ensure compliance with Data Standards set up by the Confidential .
  • Using Erwin I created models for new initiatives, major reengineering efforts and created Logical Data Model reports for the Program Management Offices and the Enterprise Data Administration groups.
  • CA Model Manager was used to store and manage models for the Enterprise.
  • I was responsible for coordinating the migration of new releases of Erwin Data Modeler and Model Manager across the U.S. Customs and Border Protection Enterprise.

Confidential

Data Analyst/Sr. Data Modeler

Responsibilities:

  • Facilitate requirements gathering sessions and ensured data models conformed to corporate data standards; ensured business requirements were accurately captured in the data model.
  • Performed logical data modeling using ER/Studio to forward and reverse engineer multiple databases platforms.
  • Developed and maintained business requirements.
  • Worked closely with Database Administrators to plan and ensure the implemented physical database models, were derived accurately from the data models.
  • Perform functional mapping of data from source system feeds.
  • Maintain logical models and documentation for interface translations within ER/Studio.
  • Worked closely with Data Governance Board and Enterprise Standards groups to trial and monitor processes that tracked data from source systems to target systems.
  • Supported and ensured processes that allowed for load of Metadata into Enterprise Repository.

Confidential

Data Analyst/Sr. Data Modeler

Responsibilities:

  • Facilitate requirements gathering sessions and ensured data models conformed to corporate data standards; ensured business requirements were accurately captured in the data model.
  • Performed logical data modeling using ER/Studio to forward and reverse engineer multiple databases platforms.
  • Developed and maintained business requirements.
  • Worked closely with Database Administrators to plan and ensure the implemented physical database models, were derived

Confidential

Business Analyst/Data Architect

Responsibilities:

  • Facilitate and ensured data models conformed to data standards and requirements were fully implemented on schedule.
  • Performed logical data modeling using Erwin to reverse engineer against multiple databases.
  • Developed and maintained Consumer Business requirements.
  • Worked closely with Database Administrators to plan and ensure that implementation of physical databases were derived from data models.
  • Promoted consolidation strategies and standards; Perform functional mapping of data from source system feeds.
  • Maintain logical models and documentation for data marts and interface translations within Erwin.

Confidential

Data Administrator/Data Modeler

Responsibilities:

  • Facilitate and ensured data models conformed to data standards and requirements were fully implemented on schedule.
  • Performed logical data modeling using Erwin to reverse engineer multiple databases.
  • Developed and maintained Consumer Business requirements.
  • Worked closely with Database Administrators to plan and ensure that implementation of physical databases were derived from data models.
  • Promoted consolidation strategies and standards; perform functional mapping of data from source system feeds.
  • Maintain logical models and documentation for data marts and interface translations within Erwin.

Confidential

Business Analyst/Data Architect

Responsibilities:

  • Facilitate and ensured data models conformed to data standards and requirements were fully implemented on schedule.
  • Performed logical data modeling using Erwin to reverse engineer multiple databases.
  • Developed and maintained Consumer Business requirements.
  • Worked closely with Database Administrators to plan and ensure that implementation of physical databases were derived from data models.
  • Perform functional mapping of data from source system feeds.
  • Maintain logical models and documentation for data marts and interface translations within Erwin.

Hire Now