Professional Summary:
Over *+years of experience in designing and developing data visualizations using Tableau.
Extensive experience in various versions of Tableau products Tableau Desktop 2018.x, 10.x, 9.x, Tableau Server, Tableau Online, Tableau Prep, Tableau Public, and Tableau Reader.
Experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
Proficiency in utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Histograms, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Page Trails and Density Charts.
Expertise in various Tableau functionalities like Tableau Extracts, Filters, Context Filters, Data Sources, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Level of Detail Expressions,Background images and Maps.
Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
Expertise in designing and creating interactive dashboards by combining multiple views.
Expertise in designing and deploying rich Graphic visualizations with Drill Down menu options.
Experience in configuring reports from different data sources using data blending.
Improved Reports performance in tableau using extracts and context filters.
Expertise in Using Table Prep.
Excellent in working closely with business leaders in soliciting business reporting requirements in various domains like Manufacturing, Insurance and Service.
Experience in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
Expertise in Trouble Shooting and Performance tuning of Tableau Dashboards and reports.
Coordinated system, integration testing, UAT to ensure reliable and quality dashboards, reports and visualizations.
Documented designs, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
Strong working knowledge of software development life cycle methodologies like AGILE and Waterfall.
TECHNICAL SKILLS:
Texas Instruments Oct' 2018 – Present
Germantown, MD
Tableau Consultant
Description: Texas Instruments Incorporated is a global semiconductor design and manufacturing company that develops analog integrated circuits and embedded processors. Project involved in building dash boards for the Supply Chain Management department to track inventory levels, logistics management, warehouse operations,KPIs and metrics.
Responsibilities:
Involved in Gathering business requirements, Analyzing business requirements and creating functional specifications.
Part of Business Analytics team, worked closely with supply Chain Management department and Created dashboards for all the corporate directors.
Created Dashboards for Cash-to-cash Time Cycle,Days Sales Outstanding, and Inventory Turnover metrics.
Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
Used Trend Lines, Reference Lines and Annotations to describe the data.
Created Data extracts for better performance and accessing data offline.
Used parameters and input controls to give users control over certain values.
Validated data from database tables by developing SQL queries and comparing results to Tableau dashboard.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
Generated Interactive Dashboards with Actions to handle views more efficiently.
Created Sets, Groups and Data Bins as per user requirements.
Created visualization for logistics calculation and department spend analysis.
Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
Performed unit testing, Coordinated system integration testing and UAT to ensure reliable and quality dashboard, reports and visualizations.
Documented designs, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
Environment: Tableau Desktop 2018.1.3, 2018.1/10.5, 10.4, Tableau Server, oracle12c, Flat files, Microsoft Excel 2016
Anthem Inc jan 2018 - sep' 2018
Richmond, VA
Tableau Developer
Description: Anthem, Inc. is one of the largest health benefits companies in the United States. Through its affiliated health plans, Anthem companies deliver a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts. BCBS Mandate for National Consumer Cost Tool (NCCT)is to support cost transparency, which involves making provider cost information available to members.
Responsibilities:
Involved in full life cycle Implementation of the project from initial phase to the production release (requirement gathering, design, development, testing and release).
Worked extensively with Medical economics team to create Health Informatics (HIA) Dashboards
Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
Developed Key Performance Indicators (KPI) dashboards that provides Trends of specific period
Created Relationships, actions, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, and live connections in Tableau 10.5.
Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
Created drill down and drill up in worksheets.
Projected and forecasted future growth in terms of number of Members, developed Area Maps to show details on which states had most members.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
Worked on YoY, QoQ, MoM reports which compare the insurance agent activity parameters from the
previous years, quarters and month in a fiscal year.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static data sets.
Worked with Front End Team for Embedding Tableau dashboards into website for internal teams.
Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
Performed unit testing, Coordinated system integration testing and UAT to ensure reliable and quality dashboard, reports and visualizations.
Documented designs, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
Environment: Tableau (Desktop/Server 10.5, MS SQL Server, MySQL, SAS, SharePoint, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint)
Poison Control June’ 2016 - Nov 2017
Mclean, VA
Jr.Tableau Developer
Description: The mission of National Capital Poison Center is to prevent poisonings, save lives, and limit injury from poisoning. In addition to saving lives, Poison Control decreases health care costs of poisoning cases. This was a support and enhancements project.
Responsibilities:
Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
Interacted with business to collect and understand Requirements and Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
Created Tableau worksheets, which involves Schema Import, Implementing the business logic by customization.
Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
Worked on Motion chart, Bubble chart, Drill down analysis using Tableau Desktop.
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 SSRS.
Worked extensively with advanced analysis is Actions, Calculations, Parameters, Background images, Maps.
Tested reports, uploaded tableau dashboards on to server, and provided production support for Tableau users.
Created different KPI's using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
Defined appropriate Hierarchies, measure groups, and KPIs & deployed cubes.
Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports.
Involved in administrative tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
Environment: Tableau 9.5 Tableau Server, MS SQL server 2012, MS Access, MS Excel, Teradata, Oracle databases, Windows Server 2012, SQL BI Suite (SSIS, SSRS), MS Office, T-SQL, Visual Studio 2010
Business Intelligence/Reporting Tools
Tableau Desktop 2018.2/10.4/9.8, Table Server, Table Prep.
OBIEE11g ( OBI Analysis, OBI Dashboards, OBI Delivers)
Database
Oracle 12c/11g/10g, SQL Server 2008/2012, MS Access, Teradata.
Programming Languages
C, VB, SQL, PL/SQL.
Web Technologies
HTML, java-script and XML
Database Tools
Visio, ERWin, TOAD and SQL Devloper SQL*plus
MS Office Tools
MS Word, MS Execl, MS Powerpoint
OS
Windows 10/7, Windows Server 08/12/16, Sun Solaris 10/11, Red Hat Enterprise Linux 5.