This project is for Department of Urban Planning and Municipalities in which there is an implementation of "Power BI Report Server" in Abu Dhabi – UAE (On-Site)

Responsibilities:
• Creating Data Models in Power BI Desktop for Data Modeling
• To develop reports, dashboards & provide end-to-end solution for OLTP.
• Developed reports & Dashboards for 4 modules:

1) Capital Projects, 2) Onwani, 3) Tawtheeq, 4) Real Estate on Power BI Report Server
• Alignment of the reports/dashboards on IPAD.
• Configured Power BI Maps
• Create Roles & implemented Security in Power BI Report Server

It was a small project for a week for the "Ministry of Housing & Local Government Kementerian Perumahan dan Kerajaan Tempatan (KPKT)"

Responsibilities:
• Gathering Business requirements.
• Listed down all the issues and provide them solution how to resolve them
• Detailed documentation provided to client for Corrective and Preventive Maintenance Report for Microstrategy.

Worked on Oracle Tools OBIEE 11g (BI Admin Tool for data modeling ,Users creation, Users security, BI Answer's for analysis and designing the dashboards), Oracle Data Integrator for data warehousing to implement the E-ARMS project (Logistic Management System integrated with E-Business Suite R-12)

• Setup of ODI Environment.
• Creation of ODI objects like Interfaces,Variables,Procedures,Functions,Packages and other ODI objects.
• Working with ODI Scenarios,Load Plans and Scheduling.
• Creation of validation test scripts for BIApps.
• Customization on Oracle BIApps.
• Installing and Configuring the BIApps on single node.
• Working with BIACM.
• Data modeling and RPD designing using OBIEE & OBIA administration tool.
• Deployments of OBIA dashboards and analytic for SIEBEL CRM.
• Analyzed and ensured data integrity of reports from heterogeneous data sources.
• Integration of BIApps with SIEBEL CRM.
• Monitoring & Error resolution of ETL

Implementation of Microsoft Power BI Report Server: Gathering Business requirements. Creating Data Models in Power BI Desktop for Data Modeling To develop reports, dashboards & provide end-to-end solution for OLTP. Developed reports & Dashboards for 4 modules, 1) Capital Projects, 2) Onwani, 3) Tawtheeq, 4) Real Estate on Power BI Report Server Alignment of the reports/dashboards on IPAD. Configured Power BI Maps

Corrective and Preventive Maintenance Report for Microstrategy Gathering Business requirements. Listed down all the issues and provide them solution how to resolve them Detailed documentation provided to client for Corrective and Preventive Maintenance Report for Microstrategy.

Implementation of Oracle Fusion Cloud Modules: i. Oracle Fusion Transactional Business Intelligence for Financials Cloud Services ii. Oracle Fusion Transactional Business Intelligence for Procurement Cloud Services Developed 5+ OTBI reports for Procurement Created a solution Design Document for OTBI (Financials & Procurement) Tested and verified 9 OTBI seeded reports of Procurement Tested and verified 11 BIP seeded reports of Procurement Tested and verified 22 OTBI seeded reports of Financials Tested and verified 200+ BIP seeded reports of Financials

Implementation of Fusion HCM Cloud (Core HR) Developed 20+ OLTP reports in BI Publisher for HRMS. Developed Parameterized OLTP Reports in BI Publisher. Developed 10+ OTBI Reports using Subject Areas on BI Answers. Attended training for HCM FUSION from Oracle. Developed Pivot Reports. Created complex data models in BI Publisher.

Implementation of OBIEE 11g Designing of Data warehouse for HRMS. Used MySQL as source Database. Creating RPD of OBIEE 11g from the scratch. Using ODI tool as an ETL tool. Scheduling of ETL in ODI (Oracle Data Integrator). Created 20-30 Reports with Advanced Features on analytics. Created BI Publisher Report for HRMS. Creation of new Users from Administration Console of OBIEE 11g. In-house training imparted to users.

Implementation of OBIA for Siebel CRM: Developing Business Intelligence Application (OBIA 11g) and Data warehouse for Sales and Services Module, Analyze the data from Siebel 8.1.1 to the target database. Creation of ODI objects like Interfaces, Packages and other ODI objects. Working with ODI Scenarios, Load Plans and Scheduling. Creation of validation test scripts for BIApps. Customization on Oracle BIApps. Working with BIACM. Data modeling and RPD designing using OBIEE & OBIA administration tool. Deployments of OBIA dashboards and analytics for SIEBEL CRM.

Implementation of OBIEE 11g I was on the Support for Christies (our client in UK), involved in the design phase of OBIEE up gradation from 10g to 11g and involved in the development phase of its up gradation. I also have developed 100-200 reports using OBIEE 10g and OBIEE 11g and have worked on the reports of BI publisher in a team.