ABHIJIT GAIKWAD

• Project #1 : Reporting Dashboard Development for Operations Team
• Environment : Tableau, Snowflake, Excel, Jira
• Domain : Healthcare
• Project Description: Develop the monthly reporting dashboard for Top U.S. Healthcare client based on the different form name, form types, evaluation organization groups. Analysis of data for the calls & cases forms for the last three month. Identifying the key Takeaways & opportunities based on the question scores. Publish the monthly reports to the client tableau server & managing the subscriptions & changes in the dashboards if any.
• Responsibilities:
• · Analyze the client requirements from the reports. Discuss the problem statements with the team & prepare the dashboard requirements.
• · Development of the dashboards in tableau desktop as per requirements.
• · Publishing the developed dashboard to the tableau server & mange the extract refresh schedules.
• · Updating the dashboards as per suggestions by QA team.
• Provide support for the additional requirements in the already delivered dashboards

Project # 1 : Sales Profit & Revenue Insights

Environment : Tableau, Excel, My SQL, Jira

Domain : Sales

Project Description: Revenue analysis for customer business segment. To analyze Sales & Profit wrt YTD, QTD, MTD, WTD and YOY. Sales performance by different states, age group, business segment. Customer segmentation to get insights of hyper market chain.

Charts/KPI Used: YTD Sales & Profit, YoY Performance, Total Sales, Total Profit, Total Revenue, Profit Ratio, used charts like Line Chart, Bar Chart, Symbol Map, Butterfly Chart, Lollypop Chart, Area Chart, Onion Chart.

Responsibilities:

· Participated in project planning sessions with team members to analyze business requirementand outline the proposed solution.

· Creating multiple dashboards with different charts as per requirement.

· Worked on various LOD calculations and Table calculations, YTD, LYTD, MTD, LMTD,YoY

analysis, Drill down using set actions, creating groups and sets.

· Creating visually compelling and actionable interactive dashboards and worksheets.

Project #2 : Revenue analysis & insights

Environment : Tableau, Excel, Jira

Domain : Finance

Project Description: Revenue analysis of companies based on financial performance analyzing growth & region wise revenue flow.

Charts/KPI Used: Company with Max no of Employees, Total no of Employees, Median Growth, Max Revenue, Total Revenue. Charts used are Pie Chart, Box & Whisker Plot, Pareto Chart, Packed Bubble Chart, Tree Map, Stacked Bar Chart, Line Chart, Histogram, Symbol Map, and Custom Sankey Chart.

Responsibilities:

· Participated in project planning sessions with team members to analyze business requirementand outline the proposed solution.

· Developed different types of visualizations reports using Pareto chart, Box & Whisker Plot, Histogramfor revenue flow from industry to region.

· Worked extensively with advanced analysis using filters, actions, parameters, table calculations and calculation fields.