Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

PRANAV KHOPADE

Senior BI Analyst
Mumbai

Summary

Data Analyst with 8 years of experience interpreting and analyzing data to drive successful business solutions. Adaptive enough to settle quickly into a dynamic environment with ability to work under pressure and deliver efficient solution to problem.

Overview

8
8
years of professional experience

Work History

Senior BI Analyst

Mastercard
Mumbai, Maharashtra
08.2021 - Current
  • Involved in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards
  • Revamped the legacy tableau report to make it more efficient and understandable
  • Created centralize fact table at data warehouse level
  • Defined best practices for Tableau report development and set up QA process for same
  • Daily collaboration with product owner and scrum teams in developing and executing solution to support the product vision and roadmap withing agile framework
  • Successfully leverage Atlassian tools like Jira, Confluence for dynamic reporting
  • Created Tableau report for PMO(Program management) by connecting to Jira API using ETL tool (Matillion).
  • Utilized data visualization techniques to present and explain complex data sets.

BI Analyst Reliance

Reliance Retail
Mumbai, Maharashtra
10.2020 - 08.2021
  • Interact with internal clients and stakeholder on a regular basis, gather requirements specific to business use case
  • Creating authorization model to handle use access
  • Migrated existing BO reports to tableau dashboards.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Provided technical support for troubleshooting analytics and reporting issues.

Data Analyst

BNP Paribas ISPL
Mumbai, Maharashtra
01.2019 - 10.2020
  • Developing solutions and dashboards utilizing the Tableau suite of product from Tableau desktop to Tableau server
  • Identifying opportunities to automate and convert raw data into intelligent dashboard for optimal decision making
  • Interact with internal clients and stakeholder on a regular basis, gather requirements specific to business use cases
  • Create and maintain development queue and communicate with all stakeholders regarding progress
  • Act as a subject matter expert on data refresh scheduling and work cross-collaboratively to modify schedules on Tableau server
  • Handling the user permission on tableau server
  • Involved in tableau data source creation and modifying existing structure
  • Ensure the data quality and integrity in database.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Created dashboards to monitor and track key performance indicators.

Associate Consultant

Atos-Syntel Pvt. Ltd
Mumbai, Maharashtra
11.2015 - 01.2019
  • Expertise in determining end user needs, converting highly Business oriented information into clear, concise technical view, which allows for effective development and support
  • Involved in creating database objects like tables, views, and functions
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau
  • Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis
  • Created different types of graphs in Tableau according to business need


Education

B.E - Computer Engineering

Mumbai University

Diploma - Computer Engineering

Dr. Babasaheb Ambedkar Technological University

SSC -

State Board

Skills

    Tableau Desktop/Server

undefined

Accomplishments

  • Received MasterCard value award for outstanding work in Jira project and setting up QA process. (MasterCard)
  • Received SPOT award from HOD in 1st quarter (2019) for timely delivering task. (BNP Paribas)
  • Received Syntel value award (Imaginative) for outstanding demonstration of the Syntel value. (Syntel)
  • Received Kudos award in quarter 1, 2016 for quick learning of application. (Syntel)
  • Received SPOT recognition for participating cultural event. (Syntel)

Timeline

Senior BI Analyst

Mastercard
08.2021 - Current

BI Analyst Reliance

Reliance Retail
10.2020 - 08.2021

Data Analyst

BNP Paribas ISPL
01.2019 - 10.2020

Associate Consultant

Atos-Syntel Pvt. Ltd
11.2015 - 01.2019

B.E - Computer Engineering

Mumbai University

Diploma - Computer Engineering

Dr. Babasaheb Ambedkar Technological University

SSC -

State Board
PRANAV KHOPADESenior BI Analyst