Upadhyay V.

BI Developer with experience in tools: Tableau, Power BI and SQL.

Delhi , India

Experience: 3 Years

Upadhyay

Delhi , India

BI Developer with experience in tools: Tableau, Power BI and SQL.

19200 USD / Year

Immediate: Available

3 Years

Now you can Instantly Chat with Upadhyay!

Chat Now

About Me

Overall 3 Years and 5 months of Experience in Business Intelligence, Data Modeling and Data Mining using (Tableau, Tableau Prep, Power BI, MSTR, SQL & Python).
Involved in Full ...
Involved in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Tableau Products.
Expertise on all Tableau products to maximize the user experience.
Expertise knowledge on Labeling & annotations, data blending, data extract, publishing & re-using data sources, applying use as filter actions, quick filtering, hierarchies, conditional formatting, groups the rows and Title and Caption.
Extensively worked in creating Complex Filters and Calculated felids for Complex reports.
Created workbooks and dashboards by using custom queries and multiple tables.

Knowledge of Commercial Analytics for Pharmaceutical and Financial Industry.
Worked on A/B testing methodologies for the analysis of the success rate of a product.
Knowledge of Cloud-based BI solutions for making the BI solution an independent product.
Exposure to Consulting: Client interaction, User Requirement Analysis and User Support.

Integration of Tableau with Python for advanced data analysis.

Skills

Positions

Portfolio Projects

Description

Project Name : Tresor Sales Analysis Dashboards

Role

Tableau Developer/Administrator

Database

Tableau 9.x, Ms SQL Database

Platform

Tableau

Team Size

Duration

2 months

Description

Developed and Deployed the Tableau Dashboard for Retail Analysis.

A Tableau dashboard for Sales & Commercial Analytics is a solution that enables the business users to view the status of their business with respect to various Activities, Trainings, Sales and Compensation. It also provides self-service BI capabilities to business user for their reporting and data requirements.

Responsibilities

Migrate Excel Report to Tableau Environment
Connect deferent views according to requirement
Created new views using different charts.
Created Dash board using views.
Prepare the calculated field to achieve the requirement.
Created quick filters
Involved in creating a dual-axis bar chart with multiple measures.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
Created Users, Groups and Projects on Tableau Server.
Created customized and interactive dashboards using multiple data sources

Show More Show Less

Description

Project Name : PNB Housings Finance LTD

Role

Tableau Developer

Database

Ms SQL Database & Excel Files

Platform

Tableau

Team Size

Duration

2 months

Description

Developed the Tableau Sourcing Dashboard and Automated Reports.

Tableau Sourcing Dashboard and Automated Reports is a solution that enables the business users to view the Daily disbursal calendar, total disbursement, Login to disb. TAT, Branch level analysis, disbursement trend, Login to disbursement TAT, and Avg. cibil score. It also provides self-service BI capabilities to business user for their reporting and data requirements.

Responsibilities

Interaction with the client on daily basis to understand their existing application and extensively worked to confirm and clarify requirements and business logic.
Worked with client to identify the KPIs and matrices to measure the business performance.
Creating the Dashboard and Report level prompts for CIO in the designated Organization.
Dashboard for Daily disbursal calendar, total disbursement, Login to disb. TAT, Branch level analysis, disbursement trend, Login to disbursement TAT, Avg. cibil score for approved applications.
Customized Reports look and Feel using Column Formatting, Conditional formatting.
Creating dimensional hierarchies as per business requirements.
Creating the requests in answers and see the results in various views like table view, view selector, chart, pivot table, ticker and legend.
Created the Business Users Reports, saved filters and prompts to improve the performance.
Dashboards mainly for the Login and Disbursal reports.
Tested and validated the reports.
Involved in Performance Tuning
Created reports using BI publisher as per user requirements