Data Developer

Shashank

Tableau Developer

Email : ******************@*****.*** PH: 276-***-****

PROFESSIONAL SUMMARY

An organized, creative Tableau developer with a wide spectrum of experience in various domains for nearly 6 years.

Experienced in tableau development lifecycle like requirement gathering, design development and delivery.

Proficient in creating data visualizations, complex dashboards using multiple worksheets and reports.

Excellent knowledge of all the phases of Software Development Life Cycle (SDLC) • Insightful in devising customized interactive dashboards in Tableau using Actions, Calculated fields, Hierarchies, Sets, Groups, Filters, Parameters in Tableau.

Experienced in joins, data blending and dual axis in tableau.

Skilled in developing and designing reports applying Drill Down, Drill Thru, drop down Menu option, Parameterized and Linked reports using Tableau.

Good Knowledge on Tableau server and Publisher.

Worked on Scheduling reports on tableau server.

Experience in developing Folders, Groups, Users, Subscriptions, Scheduling and skilled in visualization in Tableau.

Competent in design, development, and implementation of various business intelligent applications including business analysis, dimensional modelling, repository management.

Experienced in designing dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard objects and views.

Experience in data usage and providing access to users using Row level security and User filters.

Good exposure in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Extensive knowledge in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with prompt pages and dashboards.

Published Dashboards onto Tableau Server based on consumers viewing medium (laptop, pc, IPad) • Worked on clear dashboards to communicate the information stored in storyboards.

Efficient use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Experienced in Data Interoperability, Analytics and BI and Production Support issue resolution.

Possess good knowledge in gathering Business Requirements, Mapping Documentation, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.

Extensive Knowledge in RDBMS concepts experienced in creating Tables, User Defined Data Types, Indexes, Indexed Views, Functions, and Stored Procedures.

Having strong Experience in writing SQL queries, TSQL and Exception Handling, understanding requirements and developing plans.

Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.

Extensively worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.

Prepared test plans and test strategies, executed and reviewed the test cases. Strong knowledge of OLAP, data warehouse design.

Strong in T-SQL writing stored procedures, user defined functions, views, joins, indexing, query writing, triggers and functions.

Proficient in documentation skills, created documents like design document, data flow diagram, implementation/release notes and operations support document/run books.

Expertise in designing techniques like Snowflake schemas, Star schema, fact and dimension

Excellent communication, teamwork, inter-personnel and presentation skills, fast and self-organized learner.

PROFESSIONAL EXPERIENCE

Tableau Developer

PRUDENTIAL, NEWARK, NJ June 2018 to Present

Responsibilities:

Designed dashboards using Tableau dashboard and created user stories to deliver compelling actionable insights.

Interacted with business stake holders, gathering requirements and managing the delivery.

Worked on creating database objects like tables, views, procedures, triggers, to maintain data efficiently and effectively.

Linked the tableau server share dashboard to a central location for portal integration and company internal portal and network folder.

Developing, publishing, customized interactive reports and dashboards, report scheduling using Tableau server.

Designed Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.

Hands on experience in building queries to retrieve data into Tableau from SQL Server and Oracle server • Generated interactive web sharing dashboards with simple drag and drop options.

Worked extensively on trend lines, statistics, dual axis, groups and sets to develop detailed level of summary reports.

Developed test scripts, test hierarchy to test the functionality in the applications.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Experienced in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and provide Server Analysis with customized views.

Worked on production on call support and played significant role in migration from DEV to FNT, FNT to Production.

Identified the granularity level of data based on business model and end user requirements.

Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.

Perform data/systems analysis to determine best solution (reports, dashboards, scorecards, data cubes, etc.) using Tableau.

Developed various data connections from data source to Tableau Desktop for report and dashboard development.

Documented solutions to issues encountered while migration, performance tuning.

Developed security matrix for dashboards/Answers users based on Individual responsibilities

Environment: SQL developer, Tableau 10.0, Tableau Desktop 9.3, SQL Server Management Studio, Oracle 10g, MS Excel, MS Access, Server OS: Windows 2003/2008; MS SQL Server 12, TOAD, UNIX.

Tableau Developer

Seacoast National bank, Stuart, Florida Jun 2016 to May 2018

Responsibilities:

Utilized Tableau BI Dashboard reporting solution for different groups in the organization.

Collaborated with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.

Defined best practices for Tableau report development.

Designed extensive joins for data blending from several different data sources

Extensively worked with Advance Analysis Actions, Calculations, Parameters, Background images, Maps

Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)

Hands-on experience in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Designed, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics

Used data blending on databases and developed interactive dashboards.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Created Report templates, bar graphs and pie charts based on the financial data using Tableau.

Tested Dashboard for data accuracy and Functionality.

Utilized Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.

Recorded complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Designed complex formulas and calculations within Tableau to meet the needs of complex business logic.

Implemented advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.

Migrated Reports & Universes from Development to Testing and to Production Environment using Import Wizard.

Environment: Tableau Desktop 8 & 9, Tableau server 9.2 / Administration, SQL Server, Oracle, Microsoft Excel 2007, MS Access, Windows 2007 server.

Tableau Developer

Source one Technologies Ltd, India Jan 2015 to March 2016

Responsibilities

Installation, maintenance and administration of Tableau Servers.

Hands on experience in tableau created Rapid Analytics and Reporting.

Expertise in Tableau Analysis • Designed Workbooks by creating user filters so that only appropriate teams can have access to the workbooks • Experience with Tableau for Data Acquisition and data visualizations for client and customers.

Skilled at creating Worksheets, Dashboarding and infographics • Expertise in BI interactive Dashboards and Tableau Publisher.

Utilizing Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

Good knowledge in developing Dashboard using OLAP cubes.

Designed, customized and share interactive web dashboards in minutes with simple drag & drop method and accessed dashboards from any tablet or browser.

Deployed, Tested and Scheduled SSIS Packages.

Generated symbol maps to understand the geo-spatial distribution with custom symbols made to represent the application category in the project.

Designed histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change all along.

Developed various kinds of reports (pivots, charts, tabular) using global and local Filters.

Involved in Test Evaluation, Summary Reports.

Live, optimized connections to Teradata to leverage the investments.

Experience of Client-Interaction on onsite/Offshore.

Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop 8.2/8.1, Tableau server / Administrator, UNIX.

SQL/ BI Developer

SilverCloud Technologie, India March 2013 to December 2014

Responsibilities:

Involved in requirement gathering and design documents for developing the project.

Created Stored Procedures, and other SQL queries for application using T-SQL • Performed tuning and optimization of queries for reports that take longer execution time using SQL Profiler, index tuning wizard and SQL Query Analyzer.

Created User Defined functions and used it for creation of stored procedures.

Wrote T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Imported and Exported data from one table space to another and loaded data from flat files to the staging area using SQL Loader in UNIX environment.

Build and monitored the indexes at regular intervals for better performance.

Developed reports using BI and tuned them for optimal performance when using multiple Parameters.

Created OLAP cubes on top of data warehouse based on facts and dimension tables for analysis purposes using SSAS.

Responsible for all reports creation, deployment and bug fixing.

Fixed defects and failures using methods such as modifying code, fixing incorrect joins and replacing sub selects with joins.

Wrote parameterized queries for generating tabular reports using expressions, functions, defining data sources.

Generated reports using SSAS that were used to send information to different vendors, Clients and mangers.

Deployed reports to report server, added subscription and snapshot for end users.

Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.

Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.

Performed effective Unit Testing and offered support during the production releases.

Environment: SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Data Tools, SQL Profiler, Windows 7, Team Foundation Server

Contact this candidate