Project #1

 Title                                          :                         CARS Cloud analytics

               Client                                                   :              GSK

               Duration                                     :                May2022 to Till

               Role                                                :                BI Developer

               Environment            :Cognos, Power BI, Oracle, Databricks

Description:   

GSK plc, (an acronym from its former name GlaxoSmithKline plc,) is a British multinational pharmaceutical and biotechnology company.GSK manufactures products for major disease areas such as asthma, cancer, infections, diabetes, and mental health. GSK is well known pharma company across worldwide. As a BI Developer we are helping organization to analyze and visualize the data.

Roles & Responsibilities:

Ø Working as a Developer on BI, Creating Reports and Dashboards.

Ø Creating Document and collecting requirements for the business and covering the data to required insights

Ø Design and develop creative and interactive dashboards which helps data analysis

Ø Analyzing Chargebacks, Trading partner and Rebates etc data to understand the business process and help the stack holder to know the transitions, scriptures and errors

Ø In Chargebacks data we are visualizing the payments and customer disputes the transactionand Rebates with detail descriptions

Ø Sales analysis to understand the business Sales, LTO sales And Total sales by brand with Detailed design of visuals

Ø Connecting to the oracle data source and creating reports in Cognos and power bi

Ø Creating Customer relations and services dashboards to know the required information and status of orders

Ø Providing flow charts and dynamic description to understand the product and service details with help and drill down reports.

Ø Creating Prompt pages and Detailed pages to provide described reports to the end users

Ø Resolving report issues and fixing the issues with in the short period and providing best user services.

Ø Resolving Issue by connecting with the related persons and providing solution for it.

Ø Deploying the reports in the different environments and scheduling refresh. handling the refresh issues