Mdm Reference Data Developer Resume
SUMMARY
- Experienced Data Modeler/Data Analyst adept in all stages of data management concepts (data governance, data modeling, data quality, data lineage, master & reference data management, metadata management, data analytics, etc.).
- Expertise in Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Dimensional (Star - Schema) Enterprise Data Warehouse data model design.
- Proficiency with all aspects of MDM implementation such as Data Profiling, Data Quality, hierarchy management, data enrichment with external sources, workflow development and management.
- As well as knowledge of REST API, Web Services, integration middleware. Able to effectively self-manage during independent projects, as well as collaborate in a team setting.
TECHNICAL SKILLS
Enterprise MDM Tools: Tibco (formerly Orchestra Networks) EBX
Data Modeling: Embarcadero E/R Studio 9.5, CA ERwin Data Modeler and Model Manager, SAP PowerDesigner
Tools: Business Objects, Cognos BI, Oracle Enterprise Manager, Developer 2000, Visual Basic, Embarcadero Rapid SQL, MS SQL Management Studio, TOAD, Informatica PowerCenter, Informatica Data Profiler, GitHub, Eclipse IDE
Applications: MS Office (Word, Excel, Access, PowerPoint), MS Project, Project Workbench, Lotus Notes, Remedy, VISIO, and HL7 Messaging, MetaCenter Metadata Management
RDBMS: IBM Netezza Appliance, MS SQL Server 2017, Oracle 12c, Teradata 13.x, IBM DB2/UBD 9.x, Sybase 16.x, and MS Access
Languages: Transact SQL, PL/SQL, Kshell scripting, C/C++ and Java
O\S: UNIX (HP-UX), MVS, Windows 10 and Mac OS X
PROFESSIONAL EXPERIENCE
Confidential
MDM Reference Data Developer
Responsibilities:
- Work closely with Product Owners to review the backlog and create sprints to provide short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
- Engage at the team level to ensure that release commitments are met in a fast-paced Agile environment
- Act as the business solution owner for the design and development of the Enterprise Reference Data Management (RDM) ecosystem, including tool configuration and operating processes
- Working with Data Governance team to define Enterprise Reference Data Values
- Map Source System Reference Data Values to the Enterprise Data Values
- Act as the business solution owner for the design and development of the enterprise reference data hierarchies (transaction taxonomies, industries, etc.)
- Accountable for data quality controls, measurement, validation, and issue resolution
- Partner with key roles, e.g. Data Trustees, Data Stewards, Data Integration team, and Database Administrators’ team to maintain a robust and sustainable RDM system
- Define detailed RDM processes, workflow tasks, data flows, and dependencies
- Tool administration and configuration, including rules and complex workflow for the TIBCO EBX suite
- Development and Maintenance of various Data Models, Data Spaces, Data Sets, and Workflow designs
- Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data integrity
Confidential
Enterprise Data Modeler
Responsibilities:
- Develop and publish an integrated subject area-based enterprise logical and physical data models in a 3rd Normal Form.
- Develop and publish Star-Schema dimensional data models that are based on the underlining design of the Enterprise Logical Data Model; and are fully aligned to business capabilities. Develop Virtual Data Mart (VDM) views that will support defined functional areas or project initiatives.
- Analyze and profile source application system data to understand the data structure definitions, relationships and derivation rules of the data.
- Collaborate with the Business SMEs, Business Analysis, and Business and Data Architects to understand and interpret architectural design and data requirements to develop a data model solution.
- Conduct source to target data mapping of data requirements to the enterprise logical data model, data movement, interfaces and analytics, with the goal of ensuring data quality.
- Developed and maintained data taxonomy and data asset catalogs within logical and physical data models that are completely aligned the enterprise business glossary.
- Collaborate with the business and technology partners to understand, analyze and document existing data models, as well as using this information to develop new data models for reporting and analytics purposes.
- Develop data management documentation for communication and education to the business and information technology communities.
- Develop and document the Enterprise Data Modeling standards and guidelines as part of the overall Enterprise Data Governance process.
Confidential
Sr. Data Analyst/Data Modeler
Responsibilities:
- Work with various business areas for capturing business requirements and creating Data Dictionary as part of modeling exercise.
- Lead the analysis and design of the HAMP Reconciliation implementation efforts using Data Dictionary to centralize HAMP data and related metadata.
- Design and developed transactional logical and physical models using Embarcadero E/R Studio based on business rules and data requirements (use cases) for deployment to the Development, SIT, UAT and Production environments.
- Design collection tables (current) and history tables for Corporate Data Marts.
- Responsible for data quality issues, generating DQ reports and getting approvals from user groups.
- Develop and documented source-to-target mapping and the development of all transformation rules to be applied to the source data to assist with the ETL design.
- Develop and built the business rules required to migrate data from base tables within the CDW, to be loaded in a custom data warehouse collection table.
Confidential
Senior Data Analyst
Responsibilities:
- Initiate and implement an enterprise metadata repository (MetaCenter Metadata Management System) that provides a single point of reference for information about data resources of projects both implemented and under development.
- Identify and document the different metadata sources and the types of metadata to be integrated into the MetaCenter Metadata Management System - metadata needs and specific integration methods.
- Organize and conduct user workgroups in order to define and gather metadata reporting needs/requirements for the different user groups (business and technical).
- Identify and define user roles and responsibilities as outlined within the ATC Data Governance workflow processes.
- Assist in the configuration and customization of the MetaCenter Metadata Management System to meet the requirements for the user-interface mock-ups.
- Configure and customize the tool APIs with 3rd party source systems (ERwin Data Models, Informatica ETL, MicroStrategy/CIB - BI Tool, Neteeza Appliance) in order to facilitate the real-time metadata extraction into MetaCenter.
- Captured and loaded business metadata into the metadata repository database - Metric Definitions, Calculations, Business Rules, etc. (metrics catalog).
- Wrote the standards guidelines and practices for users of the MetaCenter Metadata Management System.
Confidential
Lead Data Analyst
Responsibilities:
- The objective of this project involves the design, development and the implementation of the bio-intelligence system - BioSense - which is an early event detection system that interacts and sourced public health information (in real-time) from within the Centers of Disease Control (CDC) PHIN architecture.
- The design and development of the Data Reference Model (DRM) Metadata Repository was to store data element-level content of metadata housed in the BioSense DW databases.
- Design and develop the logical and physical model for the DRM Metadata Repository using ERwin based on defined business rules and data requirements.
- Identify and define all required metadata data sources - BioSense Messaging Guide Element of Interest (BMG EOI) based on their associations to the HL7 specification, XML Schemas, physical database tables and views (relational database schemas), ETL transformation rules, etc.
- Work with the Business SMEs and Business Analysts for gathering business requirements as part of modeling exercise.
- Interact with Business Analyst and Systems Analyst to analyze the requirements for designing and developing the models.
- Development of source-to-target transformation data mapping documents, gathering customer requirements to determine required data transformation rules to be applied to the migrated data source, as well as to understand the transformation/cleansing requirements and their impact to system resources.
- Design and generate the CREATE DDL scripts that were used to implement the target database objects within the Oracle 11g database schemas (generated from the ERwin data modeling tool).