Erwin data modeler resume software#
Erwin data modeler resume professional#

Worked with DBA to create the physical model and tables.Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.Reviewed the logical model with Business users, ETL Team, DBAРІР‚в„ўs and testing team to provide information about the data model and business requirements.

Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.

Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.

Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.

Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.

Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.

Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.

Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.

The goal of the project was to create and implement a Data Warehouse which will be used for implementing Business Intelligence through 12 detailed reports and 20 dashboards.

It is a multinational firm engaged in multi-level marketing, research, development, and distribution of glyconutrients, the company's name for blends of sugars. Mannatech is a fast-growing company focused on delivering better quality of life through scientifically tested wellness technologies.

Informatica PowerCenter 8.1/8.0/7.1/7.0/6.2/6.1/5.2, Informatica PowerMart 4.7, PowerConnect, Power Exchange, Data Profiling, Data cleansing, OLAP, OLTP, SQL*Plus. Excellent analytical, inter-personal and communication skills with a strong technical background.Р”Вimensional Data Modeling, Relational Data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling, ER Studio 7.1.1, ERwin 4.0/3.5.2/3.x, Power Designer.Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.Extensive Experience working with business users/SMEs as well as senior management.Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.

Erwin data modeler resume software#

Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.

Created DDL scripts for implementing Data Modeling changes.

Worked extensively on forward and reverse engineering processes.

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.

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.

Erwin data modeler resume professional#

An Information technology professional with more than 3 years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.