• Worked with team of developers to design, develop and implement a BI solution for Wholesale Customer Account onboarding KPIs.• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)• Building, publishing customized interactive dashboards, report scheduling using Tableau server.• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.• Scheduled extract refresh for daily, weekly and monthly reports.• Created action filters, parameters and calculated sets for dashboards and worksheets in Tableau.• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.• Used Multiple Measures to create Blended Axes and Dual Axes.• Developed Tableau workbooks to perform year over year, quarter over quarter, month over month, YTD, QTD and MTD type of analysis.• Generated context filters and data source filters while handling huge volume of data.• Built dashboards for measures with forecast, trend line and reference lines.• Created Standard, Crosstab, Sub reports and TAT reports for wholesale department management.• Created various test cases to validate the data, performance and look feel of the reports.• Created user access guide documentation which provides to end users and developers to run their reports• Worked on workbook Permissions, Ownerships and User filters• Interacted with the existing database developers and DBA to understand the existing schema.

• Interact with end users, business analysts and Product Managers to gather the requirements• Developed various dashboards and detailed reports from the end user requirements received.• Effectively utilized Tableau features like parameters, calculated fields, filters to provide efficient data visualization solutions to the customer.• Upgraded the existing server version to Tableau 10.4 and successfully migrated existing workbooks.• Tableau dashboard layouts were effectively used to give interactive visual analysis experience to user.• Handled the huge data volume by using Tableau extracts.• Used advanced concepts - blending, LOD to meet the customer requirements.• Used dashboard filter actions, forecasting, table calculations to meet user requirements.• Scheduled data refresh on Tableau Server for daily and monthly increments.• Hands on experience in Cloud Databases and Data warehouses (Redshift/Oracle RDS).• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.• Developed initial sql queries for connecting to Redshift for performance tuning. • Created and managed S3 buckets and policies for storing workbooks and archiving to Glacier.• Worked with the data architects and ETL team to finalize data model and transformations for Redshift.• Assisted QA team in understanding business process and helped them in successful completion of Unit Testing and Integration Testing.• Extracted server logs and create splunk dashboards for various KPI’s

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.• Building, publishing customized interactive reports and dashboards, scheduling using Tableau server.• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.• Worked on Motion chart, Bubble chart, Drill down analysis using Tableau Desktop.• Worked extensively with analysis is Actions, Calculations, Parameters, Background images, Maps.• Tested reports, uploaded tableau dashboards on to server, and provided production support for users.• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.• Hands-on help assisting users in creating and modifying worksheets and data visualization dashboards.• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions).• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.• Involved in administrative tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.• Responsible for interaction with business, gathering requirements and managing the delivery.• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop• Created complex data views manually using multiple measures also used sort, Filter, group, Create Set functionality.• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Excel and SSRS.• Worked creating Aggregations, calculated Fields, Table calculations, window function, Totals, percentages using Key Performance Measures (KPI) and Measure• Extensively involved in doing user acceptance testing (UAT)• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.• Involved in doing security and negative testing of the application.

• Plan, design, and implement application database code objects, such as stored procedures and views.• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.• Created Cursors and functions to support application.• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.• Interacted with report owners to establish/clarify their requirements and developed report specifications.• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.• Connected Tableau server to publish dashboard to a central location for portal integration.• Created visualization for logistics calculation and department spend analysis.• Generated KPI for customer satisfaction survey results and disease management.• Created Test Scripts, hierarchy to represent features and functionality that need to be test in application.• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.• Involved in doing security and negative testing of the application.