Tableau Data

SUMMARY

Almost * years of experience in Software Engineering, Software Development, Business Intelligence technologies along with reporting and data visualization using Tableau.

Expertise in Tableau 2021/2020/2019/2018/10.x/9.x/8.x/7.x, Tableau Desktop, Tableau Server, Tableau Prep, Tableau Online, Tableau Mobile, Tableau Public and Tableau Reader.

Experience with Micro Strategy tool involving web analytics in creating reports, filters, prompts, and metrics.

Designed several data visualizations and business dashboards using Tableau Desktop.

Involved in administration tasks such as publishing workbooks, managing ownerships, providing access to the users, and adding them to the specific groups and projects, scheduling refreshes, and subscriptions in Tableau Server.

Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.

Ability to analyze and dissect user requirements and build front-end BI applications according to specifications.

Used Tableau Prep to cleanse, aggregate, merge or otherwise prepare the data from various sourcesand perform transformations on themfor analysis in Tableau.

Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts, and managing queries.

Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.

In depth knowledge in Tableau advanced analysis features like Actions, Filters, Calculations, Parameters, Trend lines and forecasting.

Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

Mastered the ability to design and deploy rich Graphic visualizations, Parameters using Tableau.

Built interactivedashboard using techniques like guided analytics and visual best practices provided by Tableau.

Data Preparation experience with Alteryx in such a way that it is suitable for reporting.

Used Alteryx used for Data Preparation and Tableau for Visualization and Reporting.

Been part in writing technical requirement documents and low-level design documents.

Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Interact with Database, ETL Informatica Administrators on environmental issues and work on fixing the issues.

Vast knowledge working onAgile, SAFe, SDLC and software engineering concepts.

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

Involved in Full Life Cycle Development of Reporting Projects includes Requirements.

Involved in Gathering/Analysis, Design, Development, Testing and Production rollover.

Experience in analysis, data aggregation, blending among other things, and deploy statistical methods in Tableau.

Experienced in writing queries, stored procedures and functions using SQL.

Identifying Business Data and requirement and modifying it to logical data models.

Exposure to Big Data Hadoop environment and its components Impala, HDFS, Hive, Sqoop, MapReduce, HBase.

Quick Learner with excellent analytical and problem-solving skills with a positive attitude towards new challenges.

TECHNICAL SKILLS

Web Development: HTML, XML, PHP, CSS, JavaScript, AJAX.

Operating Systems: Linux (CentOS, Ubuntu), Windows XP, 7/8/10.

Productivity Tools: Microsoft Word, Excel, PowerPoint, Access, OneNote, Outlook.

IDE: Eclipse, Dreamweaver, HUE, Notepad++, Visual Studio.

Languages: C, C++, Java, JavaScript, SQL, UML, PL/SQL.

Database: MySQL, Microsoft SQL Server, IBM DB2, Teradata, Impala, Hive, ODBC.

Web & Application Servers: MapR, AWS, Tomcat, WebSphere, VMware vSphere.

Methodologies: Agile.

Project Management Tools: MS Visio, MS Project.

Tracking Tools: JIRA, Confluence, SharePoint.

Reporting Tools: Tableau Desktop (2020.x, 2019.x, 2018.x, 10.x, 9.x.) MicroStrategy Web and Developer, Tableau Server, Tableau Reader, Tableau Online, Tableau Mobile and Alteryx 11.

EXPERIENCE

U.S Department of Veterans Affairs through Booz Allen Hamilton, VA Aug 2020 - Present

Tableau Technical Lead

Project Description: BINCA project is to convert all the existing Tableau dashboards to use cloud data sources from the current legacy systems on premise that are using the text files as data sources. Current manual loading of files involves lot of time and resources. Business currently is able to see the updated data only once every week and make decisions based of weekly data which is not totally efficient. By implementing this project, business will be able to get the up-to-date data every single day without any manual refreshing or loading of the data files. This ultimately saves a lot of time and helps the business to make more accurate and efficient decisions.

Further develop new Dashboards based of the newly set business needs and requirements to serve different VA departments. These new dashboards would serve a number of executives and leadership to understand the statistics and make better decisions in an effective manner.

Roles and Responsibilities:

Lead the team as a technical expert providing efficient ways to convert all the existing dashboards connected to the Super Cron files on prem to connect to the SQL views that are situated on the Oracle database in AWS platform.

Design data model from scratch to aid team in data collection to be used for Tableau visuals.

Participate in daily stand-up calls with clients on daily design and development effort as well as Interact with the business and product owners to understand their needs and requirements, plan and provide efficient solutions to their existing problems.

Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Read the DILT and ICD documents clearly to understand the design, structure and logics used to create the dashboards.

Work on creating and modifying the queries of the views on the Oracle DB in AWS data warehouse using Oracle SQL developer.

Understand the join structures and conditions used on the legacy front end data files in Tableau and create the SQL queries accordingly in the backend views.

Create dashboards in Tableau Desktop based on the data collected from various data sources by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases in AWS.

Connect the Tableau dashboards to the newly created SQL views and update the connections by eliminating the need of using the legacy Super Cron text files.

Work with the developers, understand and assign tasks based of the stories created on JIRA and KANBAN boards in a proper time frame and in an agile way.

Perform peer review of code and testing in order to detect and minimize application problems.

Generate Dashboards with Quick filters, Parameters, context filters and data source filters to handle views with huge volume of data more efficiently.

Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.

Develop Tableau reports that provide clear visualizations of various industry specific KPIs.

Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.

Use Tableau Prep to clean and prepare the data for use in the dashboards for more efficient and accurate datasets in a customizable manner.

Implement advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending and dashboard actions.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Combine views and reports into Interactive Dashboards in Tableau Desktop that were presented to Business users, Project Managers and End Users.

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

Work in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.

Perform Tableau Server admin duties; maintaining users/groups from Active Directory; and schedule instances in Tableau Server including scheduling refreshes and extracting the data into Tableau Data Engine.

Manage the Tableau solution architecture, administration and actively manage the performance and usability.

Work on different Ad-hoc scenarios to come up with various functional specs / Demos for User acceptance.

Environment: v2020 & 2021 Tableau Desktop, Tableau Server, Tableau Prep, AWS, Oracle, SQL Developer, Excel.

Independent Purchasing Co-operative (IPC) – Miami, FL Jan 2018 – July 2020

Sr. Tableau developer

Project Description: Forecasting, analyzing, and reporting project. This project required technology to analyze daily data, forecast the data based on the daily analysis and then report using Tableau to the business. This reporting helps business to understand and achieve greater profits with efficient usage of goods and services.

Roles and Responsibilities:

Involvement as a technical expert providing input to application design regarding production tuning and administration requirements.

Gathering business requirements, having discussions with various cross functional teams, interactions with POs (Product Owner), Business users, Product Sponsors, to understand requirements, plan and assign tasks to individuals with user story points.

Conducting agile interactive meetings about the agile environment and about the tools used. Install and establish access to JIRA and Confluence.

Assign User Stories, Tasks and Epics, update on JIRA board with acceptance criteria for each sprint that lasts two weeks.

Worked on Teradata Store procedures and functions to confirm the data and loaded it on the tables.

Worked in the conversion of SQL server functions into the Teradata Store procedures for confirming the data.

Working on Impala to write SQL statements in the HUE interface to generate views, which then are used as datasets to creates reports and visualizations in Tableau.

Creating Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live and extract connections, and in-memory in both tableau and excel.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop.

Handling the new developments as well as enhancements for the existing dashboards in Tableau.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and Dashboards using KPI's.

Testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Design and development of various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Working in the MapR development environment where all the reports and views are created and published.

Establishing connections to various data sources in Hadoop environment using the ODBC connectors.

Responsible for maintaining Tableau application server running 24x7 and managing and administrating various sites on Tableau server.

As a Tableau Admin, performed duties including assigning privileges to view, create or publish reports to Tableau server and publishing the workbooks on the Tableau server for scheduled refreshes.

Upgrade and install Tableau Desktop, Tableau Server across different versions and handle all the administrative operations whenever and as required.

Created writeback functionality to write comments on Tableau Dashboards from Tableau to Hadoop using PHP and SQL scripts and in the IIS server environment. This feature served as a major requirement for business and helped them save time by avoiding manual entries on excel files.

Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting.

Testing the SQL Scripts for report development, Tableau reports and Dashboards handled the performance issues effectively.

Creating customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Interpreting the KPI definitions, and dashboard needs by sympathizing with the business team.

Define new KPIs and get approvals from the business team to make sure the new ones make business sense.

Using Micro Strategy web and developer, created schema objects, metrics, reports, and documents supporting client business goals.

Adhoc data cleansing and standardization using Alteryx.

Explored the MSTR interfaces like web and developer as a self-service for data discovery capabilities to blend data, analyze visually and share insights.

Provided governance to the review processes and effectively communicated out the project status.

Developing and white boarding wireframes, beta dashboards and presenting them to the business teams to see if they meet their requirements.

Documenting the dashboard needs, the critical success factors of the business, related KPIs and measures in the dataset, and the designs.

Analyze the data sources, be it an ODBC, RDBMS, XLSX file or a CSV file.

Perform the required data wrangling before connecting to the data source from the Tableau client.

Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.

Fine tuning of SQL Queries for maximum efficiency and performance.

Testing, cleaning, and standardizing data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.

Thorough analysis, unit testing and integrated testing with other applications of database objects & SQL statements in Impala before deployment to the production server.

Environment: Tableau Desktop, Tableau Server, MapR, Impala, SQL, HUE, Teradata, MSTR, Hadoop.

Fresenius Medical Care - Lexington, MA May 2016 – Dec 2017

Tableau developer

Project Description:

Determine, analyze, validate, and lead the definition of critical business processes in support of developing integration components, integrating applications. Manage the implementation of integration tasks associated with the project in a framework consistent with other development efforts. Create and refine the products and services that helps the organization.

Roles and Responsibilities:

Involved as a technical expert providing input to application design regarding production tuning and administration requirements.

Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau 10.4 and excel.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau online.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 10.4.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Tableau 10.4.

Connected to the AWS Redshift directly from Tableau10.3 to access cloud data warehouse and quickly perform visual analysis.

Worked on conversion of SSRS reports into Tableau in various visualizations.

Created automated scripts for tableau workbook refresh when not using live connections.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Created users using Tableau Admin and assigning privileges to create report/publishing reports to Tableau server.

Preparation of data with Alteryx in such a way which is suitable for reporting.

Implemented row level, data-level, and user-level security in Tableau 10.4.

Worked on Global Sales and created monthly, quarterly, yearly sales across various regions.

Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.

Used R functions and models in Tableau 10.4 by creating new calculated fields that dynamically invoked the R engine and pass values to R where the results are then returned to Tableau.

Used R and its functions for statistical Analysis on Tableau Data.

Used R and exported data via a supported data source and then visualized that data in Tableau.

Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Partner with the Technology teams to deliver a stable and highly available reporting platform.

Plan and implement the overall analytics and business intelligence strategy.

Environment: Tableau 8.x/9.x/10.x, Tableau (server and desktop), SQL Server 2016, Microsoft Windows 7/8, Alteryx 11.

Zelis Healthcare - Bedminster, NJ Feb 2014 – Apr 2016

Tableau Developer

Roles and Responsibilities:

Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards with HANA as Data Base.

Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.

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.

Experience in integration of Python through TabPy, Tableau Python Server in Tableau 9.1.

Gathered Business Requirements by interacting with Business Users, Project Manager, and SMEs.

Analyzed metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.

Created python script for creating data source as .tde files.

Created python scripts for data push from Tableau/Teradata to S3.

Used Iron python scripts for few actions like carrying of filters from one filtering scheme to other, toggling between different visualizations etc. Handled user licenses for projects.

Designed workflow in ETL tools and data preparation using Python (2.7) & Tableau.

Importing tables using Warehouse catalog and Creating Logical Tables.

Used Tableau with AWS cloud connecting to AWSEMR and AWS redshift.

Actively involved in the Server migration and the Tableau Server Installation process.

Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.

Collecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platform.

Executed and tested required queries and reports before publishing.

Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

Worked on Teradata Store procedures and functions to conform the data and load it on the table.

Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications.

Worked with business team and technology team in substantiating the system Requirement specifications document.

Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective.

Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.

Environment: Tableau 7.0/8.0/9.0, SQL Server 2015, Visual Studio 2015, Windows XP/Vista/7, Excel.

POP HealthCare - Franklin, TN Nov 2012 - Jan 2014

Tableau developer

Roles and Responsibilities:

Upgraded Tableau 7.0 to tableau 8.0 and gathered requirements, analyzed from raw data.

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

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, Level-of-Detail (LOD), sorting, groupings, live connections, and in-memory in both tableau and excel.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Worked on motion chart, Bubble chart, drill down analysis using tableau desktop for Amazon.

Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.

Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Ability to work quickly and under tight delivery deadlines with focus on details.

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

Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.

Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.

Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.

Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.

Created and published packages for different functional areas and assigned security rules to them in Cognos Framework Manager.

Created Active reports using data deck, tab data button bar and sliders.

Created reports containing multiple data containers like List, Crosstab, and Repeater tables in Cognos Report Studio.

Created dashboards for a managerial overview with drill up and drill down capabilities.

Scheduled reports using Cognos scheduler and emailed to various recipients as required.

Lead BI work stream projects in the implementation and use of new BI software tools and systems.

Got involved in designing the Data model for the Data warehouse and for different Data marts.

Prepared many other reports by using master details, crosstabs, slice and dice and drill mode as per the requirement of the end-uses.

Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations.

Environment: Tableau Desktop 8.2/8.3, Cognos 6.0/7.0, SQL 2014, Windows XP, Vista, Excel

EDUCATION

Master of Science (MS): Information Technology, Southern New Hampshire University, Manchester, NH, USA

Contact this candidate