Developer Tableau

NIKUNJ PATEL

Tableau Developer

Summary

*+ years of Experience in Tableau 9 and 10 (Desktop, Server) as a Tableau Developer. End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop and Power BI.

Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Hands on experience on Tableau Desktop versions 9/10, Tableau Reader and Tableau Server.

Produced attractive visuals/dashboards to convey the story inside the data.

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer. Experienced in creating ad-hoc reporting in SSRS.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Used SQL Queries at the custom SQL level to pull the data in tableau desktop. Validated the results in Tableau by running SQL queries in Oracle SQL developer.

Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Para meters etc. in Tableau.

Possess strong knowledge of database management in writing complex SQL queries, Joins, query optimization and resolving key performance issues.

Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment. Communicate effectively with colleagues and business users.

Skills

Reporting Tools:

Tableau, Tableau Reader, Tableau Server, Tableau Public, Power BI, SSRS

ETL Tools:

SSIS, SSAS

Databases:

Teradata, Oracle, MS-SQL Server

Tools:

SDLC, Requisite Pro, MS Office, GitHub, OLAP, Waterfall, Agile

Languages:

SQL, PL/SQL, T-SQL, HTML5, CSS3

Operating System:

Windows 7/8/10, Linux

Education

Master of Science, Computer Information Sciences

New England College (NEC)

Experience

Humana, OH

Tableau developer Oct 2017 – Current

Roles & Responsibilities:

Experience in design and development of Tableau visualization solutions.

Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.

Working on generating various dashboards in Tableau server using various sources such as SQL Server/Teradata/Oracle.

Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Preparing Dashboards using calculations, parameters in Tableau.

Understanding of relational database structures, theories, principles, and practices.

Created drill down and drill up in worksheets in tableau. Created report schedules on Tableau server.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Prepared proof of concept for best practices in Tableau deployment.

Developing a Dashboards and preparing ad-hoc Reporting.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company. SQL Server Agent jobs are typically used to automate tasks that you perform repeatedly

Conducted meetings with business take holders, clients and director level members for requirement gatherings and presented various solutions using best practices. Good hands on experience with SQL Server 2016/2014/2012/2008/2005, SSIS, SSRS, SSAS and T-Sql.

Excellent skills in developing SSRS reports with functionality such as Drill Down, Drill through, and Parameters. Extensive experience in creating Drill-down and Drill-through Reports (SSIS/SSRS), writing Expressions in SSRS and Fine-tuning Reports. Measure groups and dimension members in SSAS using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.

Lamda, India

Tableau Developer Jan 2014 – Feb 2016

Roles & Responsibilities:

Worked as a Tableau admin, in charge of the report development and maintenance.

Independently worked on owning IT support tasks related to Tableau Reports on Server. Built and maintained many dashboards. Training classes to the employees on Tableau Software.

Creating dataflow diagram and documenting the whole data movement process.

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

Created Backup scripts to take periodic backups for the content on Tableau server.

Worked on the requirement gathering of the reports. Analysed the database tables and created database views based on the columns needed. Created dashboards displaying sales, variance of sales between planned and actual values.

Implemented calculations and parameters wherever needed. Published dashboards to Tableau server.

Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.

Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,

Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.

Good Knowledge and Worked on TABCMD TABADMIN, Database Maintenance and Troubleshooting.

Exported and imported data from Flat file, CSV file, Excel to/ from SQL Server Database using SSIS. Created tabular, list, matrix reports and writing queries stop form drill down operations in SSRS.

Used various report items like tables, sub report and charts to develop the report sin SSRS and upload into Report Manager.

Built SQL Server Queries for Power Pivot based reporting to deliver on managers reporting needs. Widely used Excel, Access and SQL Server to clean se, de- duplicate and format client files.

Provided complex reports using Excel, Access and PowerPoint.

Location: OH

Email: *********@*****.***

Mobile: 978-***-****

Contact this candidate