cvenkateshsql

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.