Naval Jassi Email & Phone Number

Toronto, Ontario, Canada

1. Prepared BRD and then transformed business requirements into technical intentions2. Created SUBSCRIPTIONS and ALERT for the report on the Tableau server3. Worked on multiple Data connections (MS SQL SERVER and EXCEL) and Validated data using SQL Server.4. Write custom SQL complex queries and subqueries by using Many SQL concepts using group by, window functions for data analysis and extraction5. Created a temporary table on SQL to perform select, insert, and delete till the time sessions are active to optimize the performance and extensively worked with CTE in SQL6. Expertise in scheduling the reports and deploying the Reports into the tableau server and giving access to the users7. Created an interactive dashboard using navigation and pagination8. Created Trend lines, Forecasting, and Reference Lines.9. Designed Individual, Dual, and Blended Axis reports.10. Created Filters, parameters, table calculations, calculated measures, and KPIs to monitor business analysis.11. Use of customized charts like Donut Chart, and Waterfall Chart to provide a better view of the analysis.12. Use the Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.13. Giving the dashboard presentation to the onsite coordinator and clients.

Toronto, Ontario, Canada

1. Used SQL Server as a data source.2. Used LOD expressions to see fixed disbursal loan amount according to the Disbursal date.3. Used date function calculation WTD, PWTD, MTD, LMTD, YTD, PYTD for how much loan amount disbursed.4. Implemented Row Level Security.5. Interacting with multiple stakeholders to gather business needs & developed technical specs.6. Conceptualizing and developing App Insight reports dashboards & KPI scorecards on Tableau.7. Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, and Heat Maps in Tableau Desktop.8. Implementing advanced Tableau features such as parameters, table calculations, sets, groups, and user filters.9. Performance Optimization of Dashboards.10. Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions.11. Blended data from multiple databases into one report by selecting primary keys from each database for data validation12. Created complex reports utilizing features like hierarchy, new calculated columns, drill functionality, tables, graphs, line charts, and bar charts13. Created sets, parameters, aggregate functions, and filters to achieve the desired functionalityImplemented joining & blending concepts in my Tableau reports14. Worked on dual axis concept while working with reports15. Created filters, groups, and sets on Tableau reports16. Used geographic view, which gives the performance of a particular country

1. Created visually compelling and actionable interactive worksheets and dashboards2. Used Tableau Desktop to analyze and obtain insights into large data sets3. Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel4. Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, and combination charts in Excel and Tableau5. Created views, stored procedures, and custom SQL queries to import data from SQL server to Tableau6. Created KPIs, goals, and dashboards in IBM Core metrics for three e-commerce sites7. Created interactive dashboards in Tableau using Marks, Actions, filters, parameters, Security Concepts, calculations, and Relationships