Contractor Qualifying Questions :
1. Has this person worked for at least 4 years on banking data warehouse projects?
2. Does the person have experience with the IBM Banking Data Model and the associated M1 modeling tool?
3.Does the person have banking product knowledge on capital markets products (derivatives, options & futures, fixed income, etc.) or Core Banking products (loans, deposits, treasury – FX & Money Market, Trade Finance)
Erwin/M1 Data Modeling
IBM Banking Model
Description Of Services:
Need 5 of these resources current and direct experience with the IBM-Banking Data Warehouse data model and the accompanying "M1” software. M1 is a modeling/design product that comes with the IBM BDW model and contains all of the names/definitions of the BDW data elements. M1 is used in conjunction with the ErWIN toolset.
1. Banking product knowledge on capital markets products (derivatives, options & futures, fixed income, etc.) or Core Banking products (loans, deposits, treasury – FX & Money Market, Trade Finance)
2. Data Warehousing & Data Integration
3. Leadership qualities & Experience of 12 years of which last 4-5 years in Banking DW projects.
Job Summary:
The Data Modeler/architect will be responsible for the design and development of the logical and physical data model based on source systems. Architect data modeling solutions for MUB Data Warehouse and down streams. Facilitate consistent business analysis, data acquisition and access analysis and design, database management Systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the group level Essential Functions:
• Analyze Business Requirements, design logical data models and systems functions and present to stakeholders
• Coordinate and interact with technical and business groups within the department
• Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
• Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise.
• Review, verify and approve the Conceptual and Logical data models done by the owner teams for modeling standards, naming convention and properly defining all objects and relationships.
• Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database.
• Create complex views and materialized views and tune for performance.
• Administer and manage the users and privileges on Erwin or ER/Studio Data Architect tool & Portal Repository server.
• Manage the repository server and all projects to follow the best standards and to keep them in sync with Prod.
• Create/modify macros in the ER/DA tool to generate more user friendly reports in aiding the creation of the business glossary document in the format requested by business.
• Enable enterprise wide metadata management using the MDR and Colibra tools
• Publish data models, conduct training on DW model to developers, Client, DAs, and QA resources
• Mentor staff, direct and document application design strategies.Deliverables:
• Design logical data models and systems functions and present to stakeholders • Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
• Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database.
• Create complex views and materialized views and tune for performance.
• Create/modify macros in the ER/DA tool to generate more user friendly reports in aiding the creation of the business glossary document in the format requested by business.
• Publish data models, conduct training on DW model to developers, Client, DAs, and QA resources