- Erwin data modeler major bug software#
- Erwin data modeler major bug Pc#
- Erwin data modeler major bug windows#
The goal of this project is to design Integrated Data Store IDS following Teradata FSLDM model, and also to extend the usage of IDS by feeding data to Finance EDW EDW and UN Sanctions downstream applications.ĬA ERwin Data Modeler, Informatica PowerCenter V9.1Īnalyse the Solution Outline Design SOD and gather both functional and non-functional requirementsĭiscuss with business and IT stakeholders and Prepare Logical Data Model using CA Erwin Data Modeler adhering to Teradata FSLDM
Erwin data modeler major bug Pc#
The Guidewire Implementation Project provides new applications for policy and claims administration comprising of Guidewire Polic圜entre PC and Guidewire ClaimsCentre CC integrated into the existing Aviva IT landscape. Perform comprehensive data analysis of 8 Source Systems Data present in legacy MI warehouse.Ĭreation of mapping documents for Informatica PowerCenter ETL tool for all 8 source systems.ĭesign Data acquisition and Data Integration Strategy for all 8 source systemsĬoordinate with Design and Developer Teams for smooth design and development efforts.Ĭreate PDL Data Marts for business needs using Dimensional Modelling Principles Prepare Logical Data Model using CA Erwin Data Modeler for Underwriting, Customer subject areasĪnalyse the existing database applications and design Enterprise Conformed Dimension Bus that works for both existing database applications and PDL.ĭesign Physical Data Model for Teradata using CA Erwin Data Modeler PDL is an agnostic data model designed to fit all lines of businesses of Insurance such as both Personal and Commercial lines of business.ĬA ERwin Data Modeler, Informatica PowerCenter v9.1Īnalyse the legacy data structure and its data elements and discuss with business and IT stakeholders about their usage and come up with data dictionary. As part of decommissions, existing DB2 marts are decommissioned and new data marts over PDL are being constructed to meet business user needs for reporting. The project's objective is to decommission existing legacy data warehouse present in Mainframe DB2 database and migrate both Policies and Quotes of Personal LOBs Homes, Motor and Travel to a new database PDL 'Personal Data Layer' on Teradata platform. The details of the various assignments that I have handled are listed here, in chronological order.
Erwin data modeler major bug windows#
Erwin data modeler major bug software#
Worked in complete Software Development Life Cycle SDLC using both waterfall model and Agile methodologiesĪ list of important hardware, software products, tools and methods that I have worked with are below:.Have done extensive data profiling for source system data to identify the data quality issues up-front.Have strong expertise in customisation of Insurance standard data models like IBM's IIW Insurance Information Warehouse, ACORD LAH data model, Teradata's FSLDM.Have designed data models using both dimensional modelling and relational modelling techniques.
Modelled data models for Enterprise Data Warehouse, OLAP, OLTP and MDM Master Data Management systems adhering to industry standards for data warehouses.Worked extensively in Data Warehousing and Business Intelligence areas as Data Architect, Data Modeller, ETL Designer and BI / System Analyst of Information systems.