Worked for Al Rajhi Bank Remediation project in Riyadh, KSA• Worked in roles of semantic layer developer and BI Lead.• Providing end to end solution in BI domain to end users.• Training my peers on OBIEE and resolving there day to day queries.• Develop common semantic layer for reporting and Data Marts• Perform RCA on common semantic layer and OBIEE reports to mitigate the errors and discrepancies in source and target layers.• Conducted the business UAT of EDW data marts for Retail Risk Analytics department of Al Rajhi Bank.

Lead the BI Team for actionable reporting for corporate clientsDeployed and configured Power BI Report Server for evaluation purpose.Utilised Power Query for data modelling and cleansing.Built custom dashboards in order to evaluate the utilisation and benefits of Power BI.Presentations to management for proof of concepts and benefits of the organisationsLead the Functional team for implementation of Hospital MIS.Implemented Kimball approach in Data warehouse.

Gathered reporting and analysis requirements, documented the report specifications, implemented the metadata layers including Physical, Business Model and Mapping, and Presentation layer (OBIEE).Defined Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developed Star schema.Installed, configured, and administration of the OBIEE platform.Developed Dimensional Hierarchies, Level Based Measures, and added multiple sources to business model objects.Created and scheduled iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.Configured OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.Designed customized interactive management dashboards in OBIEE using drill down, prompts, filters, and variables.Created management reports for Supply Chain , Marketing ,HR , General Ledger and sales using Oracle BI Publisher integrated with OBIEE and Oracle EBS.Worked on ETL techniques using Oracle Data Warehouse Builder (OWB).Created data marts, Mappings and monitored Sessions/ Workflows for data warehouse using (OWB).Gathered maintenance requirements and configured Oracle Enterprise Asset Management for Pakistan Oil Fields Limited (POL) as per requirement.Uploaded Asset BOMs and maintenance BOMs using EAM interface tables through SQL.Developed Oracle Enterprise Asset Management (EAM) reports in EBS using XML Publisher.