We provide IT Staff Augmentation Services!

Tableau Consultant Resume

Cleveland, OH

SUMMARY:

  • Deep experience building interactive dashboards using Tableau Business Intelligence Solutions and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • More than 8 years of Data warehousing experience with Business Intelligence Tableau 2018.1/10.x/ 9.x/ 8.x/7.x/6, OLTP and OLAP Microsoft SQL Server, Oracle SQL Server as a Developer in various companies.
  • Extensive experience in designing and deploying effective, visually appealing reports using Tableau Business Intelligence Solutions
  • Broad experience working in many aspects of the System Development Life Cycle (SDLC) including requirements gathering, proof of concept delivery, Implementation, user support and maintenance.
  • Deep experience improving performance of dashboards and creating incremental refreshes for data sources on Tableau server.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Designed effective dashboards using tableau and Data manipulation using SQL, and Altyrex.
  • Extensive experience in writing SQL Queries using CTEs, Dynamic SQL, Stored Procedures, and Functions
  • Well versed in writing Stored Procedures, Triggers, Views and Functions using SQL and PL/ SQL .
  • Good experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
  • Well versed in building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

TECHNICAL SKILLS:

Tableau Desktop 6/7/8,9,10, 2018 Tableau Server 6/7/8,9/10/218 Tableau Online, Tableau Public, Tableau Reader, TabCmd, Microsoft SQL Server 2012/2008 - R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0, Microsoft Visual Studio 2010/2008/2005, Microsoft Access, Microsoft Office(MS Word/ Excel/Powerpoint), MS Project, HTML, XML, Java, C++, C#

PROFESSIONAL EXPERIENCE:

Confidential - Cleveland, OH

Tableau Consultant

Responsibilities:

  • Created and published Tableau credit risk dashboards utilizing complex calculated fields, table calculations, action filters, parameters
  • Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
  • Employed performance tuning procedures to increase performance and help make dashboard more user friendly
  • Building customized Tableau charts such as Sankey Diagram, Pareto chart, Waterfall, Grouped Bar Charts, Donut Charts, and Bar-in-Bar Charts to create interactive and visually appealing dashboards
  • Connecting to multiple data sources using blends, joins, cross-database joins
  • Deeply involved in gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Designing Test Scenarios to validate Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Used Context filters and Created Geographic map reports which explains the company financial keys according to the members
  • Reviewing business requirements and analyzing data sources form Oracle/SQL Server/Hadoop for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Writing complex, tuned SQL queries using CTEs, Stored Procedures, UDFs, and Dynamic sql to generate data for dashboards
  • Working long hours and on some weekends to help resolve production related issues.
  • Connecting to databases using custom sql, tables, and views.

Confidential, Birmingham, AL

Tableau Consultant

Responsibilities:

  • Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
  • Increased performance of dashboards by utilizing performance tuning procedures
  • Built customized or unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
  • Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server in various versions of Tableau
  • Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
  • Worked closely with all team members in implementing Tableau BI tool in all IT projects
  • Generated reports using SQL queries in Tableau and published them to users in online through Tableau server.
  • Utilized, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau
  • Designed effective dashboards for Top Executives to give an overview current Trends
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
  • Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
  • Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
  • Configured User row level security for data in the Dashboard

Confidential - Mountain View, CA

Tableau Consultant/SSIS Developer

Responsibilities:

  • Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
  • Employed performance tuning procedures to increase performance and help make dashboard more user friendly
  • Developed Tableau workbook and publishing it on server
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Working long hours and on some weekends to help resolve production related issues.
  • Connecting to databases using custom sql, tables, and views.
  • Deeply involved in gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Writing complex, tuned SQL queries using CTEs, Stored Procedures, UDFs, and Dynamic sql to generate data for dashboards

Environment: Tableau Desktop, Tableau Server, Oracle, SQL, SSIS, Teradata, Workday, Cognos

Confidential, Orem UT

MS SQL Developer /Data Analyst

Responsibilities:

  • Created Stored Procedures, Views, and User Defined Functions to facilitate the automation and ETL processes
  • Created Entity Relationship (ER) Diagrams to the proposed database
  • Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
  • Worked on the performance tuning part, as most of our applications have issues with the PL/SQL stored procedures.
  • Designed, Developed and Deployed SSIS Packages
  • Worked as a DBA and created creating tables, users, and permissions.
  • Created database objects such as tables, views, stored procedures, Triggers etc.
  • Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Identified columns for Primary Keys in all the tables at the design time and create them.
  • Created functions to provide custom functionality as per the requirements.
  • Be aware of potential blocking, deadlocking and written code to avoid those situations.
  • Ensured that the code is written keeping in mind any security issues such as SQL Injection.
  • Identified and written best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
  • Participated in development and creation of Data warehouses.

Hire Now