Involved in development of Stage, Dimension, and Fact table’s mappings using Connected/Unconnected LKPs, EXP, UPD Strategy, Filter, Router, and AGG, Joiner Trans formations.
Using ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Identify and tracked the slowly changing dimension tables, heterogeneous Sources and determine the hierarchies in the dimensions.
Understanding the Business requirements and Configuration of repository at all the three layers including Physical, Business Model and Mapping Layer, and Presentation Layer.
Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer.
Configured Joins in Physical and BMM Layers.
Configured Dimensional Hierarchies in the Business Model and Mapping Layer.
Configured Logical Table Sources by defining the physical sources and content in the BMM Layer.
Calculation measures in the business model using Time series.
Extensively used Oracle Answers in building various reports.
Designed and Developed new subject areas/ Customizations and front end reports.
Developed Reports with different Views (Pivot Table, Chart, Column Selector) using Oracle Presentation Services and Interacted with users, developed and maintained Reports and Dashboard.