varghese johney

I am a Tableau-certified Desktop Specialist with 5+ years of experience. 

• Designed, developed, and tested various Power BI and Tableau visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.
• Expertise in data preparation with experience blending multiple data connections and creating multiple joins across the same and various data sources.
• Used and created various visualizations in reports like scatter plots, box plots, Sankey charts, bar graphs, Gantt charts, trend lines, waterfall charts, statistical models, heat maps, and geo-maps allowing end users to utilize the complete functionality of the dashboard. 
• Excellent SQL skills for daily testing of data using various SQL queries.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, and Table Calculations.
• Solid experience in building interactive reports, dashboards, and integrating modelling results and has strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Published and shared views on the Tableau server, scheduled extract refresh and subscriptions
• Involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to a specific group.   
• Develop simple/complex SQL queries and query tuning for data preparation for reporting.
• Expertise in working with data-building Groups, Hierarchies and sets.
• Clean, Transform and Prepare the Data with Tableau Prep and Alteryx
• SQL Development & Support - SQL Development, Reporting, Develop, Implement & Maintain Databases, Fixed Data load issues by creating, testing, and debugging SQL (MS SQL, MySQL, and Oracle) codes.

Post Graduate Certificate in Science | Sheridan college, Brampton.May’16 – Aug’17

Bachelor of Science | Calicut University, India.   Sep’08 – Dec’11