Data Modeling

Data Modeling is probably a key factor of the future health of your BI solution.

We have good IT experience in System Analysis, Application Design, Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Database.

Offerings

• Excellent experience in Data Modeling using Erwin r9/7.3/4.5/4.1.4/3.5.2 and ER Studio.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Experience in developing data models which will serve both OLTP and OLAP functionality.
• Designed databases involving complex views, triggers in Oracle 10g/9i/8i/8, Microsoft Access, DB2, and SQL Server 2012/2008

Implementation

• Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes
• Solid experience in Relational Modeling, Dimensional Modeling, Conceptual, Logical Modeling, Physical Modeling, Star Schema, Snowflakes Schema, ERD(IDEF1X and IE notation) ER Diagrams, Granularity, Cardinality and Database Reengineering.

• Deployed naming standard to the Data Model and followed company standard for Project Documentation.
• Expertise in Normalization techniques for data consistency and Flexible Database design.