Client : AstraZeneca Project

Title : OFR (AZ)

Role : OBIEE Developer

Environment : ESS Base, OBIEE 12c

Description: AstraZeneca is medical was founded in 1999, have a global around with a in about 20 countries and 61,100 employees,The main head quarters was in United Kingdom London, AstraZeneca has a portfolio of products for major disease areas including cancer, cardiovascular, gastrointestinal, infection, neuroscience, respiratory and inflammation. Essbase was a source used in my project , it can be used to import the data & data validations can be checked in Excel page. We can be done the report by using cube data, it was mainly joined with dimensions and facts in Cube.

Responsible for:

 Created several reports including table view, pivot table view and chart view in answers

 Involved in the development of the Oracle BIEE Meta data Repository (.rpd) model with all subject areas which included creating Physical layer, Business Model and Mapping layer and Presentation layer

 Enabled caching for better performance of the reports Created several dashboards, dashboard pages and links to the reports in dashboard page.

 Created several BIP word Templates for Provider validations.

 Created various levels of prompts using Presentation variable.

Project Title : Science & Operations.

Client : Astrazeneca (UK)

Position : Power BI Developer

Environment : Power BI Desktop, Power BI Services, SQLSERVER, EXCEL.

Description : The Project is basically to convert old Reports that were in Excel into Power BI for making it more interactive and user friendly.

Responsible for:  Involved in Collect the Technical Specification Document and Analyzing the User requirement.  Connected data from excel datasets.  Designing, developing and implementing Business Intelligence reports.  Crafting and executing queries upon request of data.  Experience in creating various views like Line chart, Bar Charts, Pie Chart, Table, Matrix table.  Experience in Creating relationship between data sets by using relationships and Calculation on columns and measures using DAX functions like Date &Time, Filter,Mathematical, String, Text, Time Intelligence.  Creating Filters in Visual level, page level, Drill through and Report level.  Creating interactivity between the user and dashboards with the help of Slicer and Interactions to compare data against different views.  Creating dashboards, presentation and graphs.  Publishing reports in Power BI services.