Good experience in business analysis, reviewing, analyzing, evaluating business systems and user needs, business modeling.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Excellent experience in Data Modeling using Erwin r9.5/9.6/r9.1/r8/r7.1/7.3/4.5/4.1.4, Embarcadero ER/Studio.
• Coherent with normalization / DE normalization techniques for improved database in relational / dimensional environments.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Good amount of experience in PL/SQL programming: stored procedures, functions, packages, triggers, performance tuning and optimization.
• Experience in creating Materialized Views, Views, Lookups for the Oracle warehouse.
• Experience in performing Forward and Reverse engineering of physical data models from data, SQL scripts.