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
SQL
JIRA
Snowflake
Alteryx
Matillion
MS Office
Python
Custom Reporting
Business Intelligence Roadmap Design
[Programming language] expertise
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