Big Data/BI Consultant

As part of support and development activities
 Created new Facts and Dimensions and used some of the existing confirmed dimensions to build multiple data models for Supply Chain Analytics, Order Management Analytics. Involved in Scoping and Estimating of new custom Profitability and Advanced Order BI Subject areas.
 Gathering requirements from users/businesses to develop interfaces, procedures, packages, load plans.
 Used Yellow Interfaces in ODI 11g for developing the most complex interfaces.
 Registered New Tasks, Indexes, and Subject Areas and accommodated in the current existing execution plan in DAC.
 Involved in DW/BI related Development, Enhancement, Performance Tuning, System optimization, Impact Analyses, Production Failures.
 Implemented Oracle BI Apps in all phases customizing prebuilt mappings, ETL Designing, Data Validation after load completion, Load monitoring through DAC as well as in Informatica monitor, metadata management using DAC, OBIEE RPD development and customization, Developing reports and dashboard and customization of Reports and Dashboards.
 As a part of performance tuning using various techniques reduced the workflow execution time
 Worked on repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports).