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

Confidential, NEWARK, NJ

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

Confidential

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

Confidential

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

Confidential

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