![erwin data modeler versions erwin data modeler versions](https://www.accuwebhosting.com/blog/wp-content/uploads/2021/08/dbschema.png)
![erwin data modeler versions erwin data modeler versions](http://www.dwh-club.com/sites/default/files/brilliant_gallery_temp/bg_cached_resized_d7517684be42f71dc728246dd2fc928a.jpg)
![erwin data modeler versions erwin data modeler versions](https://amberrenew678.weebly.com/uploads/1/2/6/8/126801860/535364922.png)
Experience with design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence solution.
![erwin data modeler versions erwin data modeler versions](https://dbmstools.com/storage/screenshots/erwin-data-modeler-r22pgdzxxg8qserq.png)
Developed Test Plans, Test Cases, Procedures and Designed Documents within the given business requirements to ensure specifications and regulations.Having experience in Hadoop and Map Reduce Framework and Oracle database.Hands on experience on Distributed Processing of Big Data - Business Research Methods using Hadoop.Experience designing, reviewing, implementing and optimizing data transformation processes in the Hadoop and Informatica ecosystems.Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using ERwin tool.Strong Experience in ER and Dimensional Data Modeling to deliver Normalized ER and Star/Snow Flake schemas using ERwin, ER Studio, EA Studio and Oracle designer.Proficiency in Normalization to 3NF and Denormalization techniques for optimum performance of database environments like OLTP and OLAP systems.Experience in conductingJoint Application Development (JAD)sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.Data Modeler with strong Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.Data Management & Data Modeling experience in an Enterprise Data Warehouse/Data Mart application environment utilizing both the Ralph Kimball Star Schema Dimensional Modeling methodology and the Bill Inmon Relational Modeling methodology.61/2 years of experience in Information Technology with Expertise in Data modeling and Data Analysis for Data Warehouse/Data Mart development, Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.