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.