Tableau Developer/ Sql Resume
2.00/5 (Submit Your Rating)
PA
SUMMARY:
- 3+ years of experience in creating interactive Visualization/dashboards using Tableau desktop, dashboard designer, SQL.
- Expertise in designing and creating various analytical Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
- Expert in design/development using Tableau Desktop for data visualization, Reporting and Analysis; Tree Chart, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
- Strong Experience in Tableau Administration such as creating extracts, scheduling workbooks, granting access and creating user filters.
- Expertise in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau Server and Reports.
- Pro cient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
- Pro cient in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
- Advanced SQL queries experience using multiple tables joins, Stored Procedure and Functionalities.
- Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management i.e., Connections, Data Model.
- Result oriented, Multi Tasked, self - starter looking for challenges, ability to rapidly learn and apply innovative technologies and Excellent verbal and written communication skills.
- Extensive Knowledge in use of MS O ce tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project. Outstanding knowledge in writing complex SQL queries.
SKILL:
Business Intelligence Tools: Tableau Desktop, Tableau Reader, Tableau Public, Power Bi, SQL, Google Analytics, Google Sheets, SSRS
ETL Tools: Informatica Power Center, SQL Server, SSIS
Tools: TabCmd. Query Analyzer, Tera Data
Languages: SQL, Custom Sql, HTML, CSS
Operating System: Windows 7/8/10, Ubuntu, Linux
EXPERIENCE:
Tableau Developer/ SQL
Confidential, PA
Responsibilities:
- Maintained and Installed Tableau Server in all the environments.
- Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
- Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.
- Understanding the business requirements by interacting with the business users. Created own customized visualizations in tableau.
- Worked in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
- Created database triggers, cursors, procedures/functions and packages using PL/SQL according to business requirements. Developing packages and stored procedures using PL/SQL.
- Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
- Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
- Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
- Actively involved in the creation of users, groups, Sets, projects, workbooks and the appropriate
- Involved in Performance Tuning of the database, which included creating indexes, optimizing SQL statements and monitoring the server.
Tableau Developer
Confidential
Responsibilities:
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the y with the usage of quick lters for on demand needed information.
- Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services 2016/2014/2012 and deployed the reports to report server.
- Assisted in creating Tableau dashboards for presenting key metrics related to users and Order received status.
- Preparing Dashboards using calculations, parameters, calculated elds, groups, sets and hierarchies in Tableau.
- Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights. Creating data blending in case of merging two di erent data sets.
- Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
- Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report. Prepared user documentation for hands on training for end user community.
- Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.