Data Modeling

  • Home
  • Data Modeling

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


image

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.