SUMMARY

• 9 years of extensive IT Experience as a Tableau Developer and Business Intelligence applications in Energy, Healthcare, Banking industries.
• Around 6+ years of experience on Tableau.
• Extensive experience in working with TableauDesktop, Tableau Server, and Tableau in various versions of Tableau 10.x,9.x/8.x/7.x
• Expertise in Tableau 10.5/10.4/10.3/10.2/10.0/9.3/9.1/8.2/8.0,Tableau Server, Tableau cloud, Tableau Online, Tableau Public, Tableau Reader, Tableau mobile.
• Consulted on Tableau server performance enhancements; upgrades from version 9.0 to 10.3, 10.5 and server reconfiguration based on workbook complexity and data extraction.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups & Conflict Management with Project team members.
• In depth understanding of the As - Is and To-Be business processes and experience in converting business requirements into Technical Specifications for preparing Test Plans.
• Experience in TableauServer Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableaufunctionalities like TableauExtracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Held responsibility in participating daily activities like building workbooks, dashboard, published on server
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Created actions, customized Relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, Drill down analysis and in-memory in tableau.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Performed auto-incremental refresh tasks for extracts of data on Tableau Online sync application and to maintain local network
• Expertise in web integration of TableauReports with HTML or Asp.Net.
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Built Operational Dashboards strictly focused on tracking operational and financial performance
• Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Excellent experience in designing, developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using SQL and Oracle.
• Experience in development of user defined reports to provide on demand data analysis using excel, and created charts and pivot tables in Excel.
• Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan.
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Held responsibility in Setting up security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• Performed Tableau server REST API to manage and handle Tableau server resources
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Published Workbooks and Dashboards to the Tableau server with appropriate access to teams
• Excellent communication and interpersonal skills. Ability to work effectively as a team member.

TECHNICAL SKILLS

Tableau: Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau mobile,Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.1/8.0/8.1/7/6Reporting Package: MSBI(SSIS, SSAS, SSRS, Performance Point, Business Objects, Crystal Reports

Data Modeling: Erwin, Visio, Confidential Rational Rose UML,Alteryx

Computer Application: MS-Word, MS-Excel, MS-Access, MS- Power Point

Databases: Oracle, SQL Server, DB2, Teradata, MySQL, XML,AWS-RedShift,EC2, RDS, S3

NoSQL Database Tools: Hadoop - HBase, Hive, MongoDB, Cassandra

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL, T-SQL, Transact SQL, Core Java, R Programming, C, PHP

PROFESSIONAL EXPERIENCE

Sr.Tableau BI Developer

Confidential, San Diego, CA

Roles & Responsibilities:

• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting Tableauapplications.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.5/10.4/10.3/10.2/10.1/9.3/9.2).
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableaureports/ dashboards.
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Analyzed requirements for various reports, dashboards, and scorecards and created the same using Tableau desktop server.
• Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau.
• Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Experience in creating and scheduling Tableau data extracts for auto refresh.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.
• Published the developed dashboard, reports on the TableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data, when sources are publishes or extracted to server.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.
• Designing and building the structure of dashboards, and suggested how to present the data, why and find opportunity to get attention to a chart.
• Positively influence others to achieve results that are in best interest of both internal/external stakeholders.
• Creating Dashboards according to the project functional requirements.
• Extracted information from different data sources like Oracle, SQL Server, MS Access and flat files, etc. by using different scripts like add, concatenate, Joins.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Customized and tweaked the scripts for cross-tables and generic loads, and created simple and complex expressions.
• Tuning data loads Tableau application for efficient performance.
• Involved in Production support and maintenance phase.

Environment: Tableau(Desktop, Server) 10.5,10.3,10.2,9.3, SQL Server 2012 andMicrosoft Office, MS VISO 2013, Profiler, Visual Source Safe, MS BizTalk Server, Microsoft Office (Word, Access, Excel, Outlook).

Tableau Developer/Admin

Confidential

Roles & Responsibilities:

• Proactively communicated with the business users to understand the needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination with Clients for feasibility study of the project in Tableauand drawing up the timelines as per project requirement.
• Created Users, Groups and projects in Tableauenvironment.
• Created and managed schedules for users.
• Scheduled data refresh on TableauServer for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the updated data.
• Created different views using TableauDesktop which were published to the business stake holders for analysis and customization using filters and actions.
• Created different charts showing KPI by Color that were broken into regions allowing business user to understand which stores are the outperformers in different categories.
• Developed various data connections from data source to TableauServer for report and dashboard development.
• Combined visualizations into Interactive TableauDashboards and published them to the web portal.
• Developed actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in TableauDesktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
• Built Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts with easy utilization of show me functionality.
• Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
• Performed Reference lines, Trend Lines, Statistics concepts. Groups, Sets, hierarchies to create detail level summary report and Dashboard using KPI's.
• Articulated best practices for Tableau report development andefficiently used data blending in tableau
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
• Achieved performance tuning by implementing Caching, Aggregate tables and creating indexes on tables.
• Involved in preparing material and training Business users.

Environment: Tableau8.x Desktop, Tableauserver, SQL Server 2008R2, Informatica 8.x,SQL, T-SQL, Agile.

Tableau Developer

Confidential

Roles & Responsibilities:

• Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MS Visio 2013.
• Involved in integrating different Database Applications using SSIS packages.
• Created SSIS packages that involves migration from legacy systems to centralized Database.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS.
• Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, for each Loop Container.
• Used work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications
• Validate data before performing ETL transformations and load into SQL server database.
• Worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS 2012.
• Designed and developed various analytical reports from multiple data sources by blending data from various sources on workbooks in TableauDesktop and Power BI.
• Designed the architecture of Tableausecurity by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Developed various reports using best practices and different visualizations such as Tornado Charts, Donut Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
• Created users, groups, projects, data connections, setting as a Tableau Administrator.
• Used LOD (Level of Details) functions like fixed, Include and Exclude in Tableau.
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Created and scheduled Tableau data extracts for auto refresh.
• Designed various Analytical Reports and Automated Dashboards to help users to identify critical KPI's and facilitates strategic planning in the organization.
• Designed and created Report templates, bar graphs and pie charts based on the inspection data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS2014/2012/2008, Microsoft Office, MS VISO 2013, Profiler, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server, Microsoft Office (Word, Access, Excel, Outlook).

SQL BI Developer(SSIS/SSRS/SSAS)

Confidential

Roles & Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.
• Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
• Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.

Environment: SQL Server 2012/200R2/2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS