• I hold 17 years experience in Data warehousing solutions using Siebel Analytic7.8.4(OBIEE) 12c/11.1.1.6 g/10.1.3.4, Tableau 9.0., Power BI, Informatica 9.1/8.1 ,ODI 12c, Python.
• Designed and developed several OBIEE Metadata Repository (.rpd) by importing database tables into physical layers, forming dimensional and fact table schemas in BMM layer and customizing table and column definitions in presentation layer
• Created several OBIEE dashboards to show complex lineage from source ([login to view URL]) to target (Oracle Warehouse), this process include creating a new RPD and merging into the original 7.9.6.3 RPD to create reporting from OBIEE Answers
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports, Sub reports and AdHoc reports in OBIEE, Tableau and Power BI Desktop
• Experience in providing the securities for reports/dashboards by assigning roles.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and etc of Informatica.
• Manage End to End Delivery of Requirements from clients.
• Consulting assignments on EDW/BI roadmap, DW/BI Architecture, Data Modeling & Implementation.
• Cross culture – US, UK, Middle East and across India.
• Experience in various domains like Finance, Procurement, SCM, Marketing, Telecom, Logistics, HRMS and Project.