Tableau Data
Resume:
Snehitha N,
***************@*****.***
SUMMARY
**/* ***** ** ** experience with Data Analysis, Report Designing, Development and Testing. Tableau has been the backbone since I started work on for over 6 years now. Expertise in developing Tableau (Desktop/Prep/Online/Server, Mobile) 6.0,7.0,8.0, /9.0/,9.1/,9.2/,9.3/10.2/10.4/2018.2,2019.4,2020.1, Kofax, Teradata, Teradata SQL Assistant, SharePoint, Amazon Redshift, R, Python, Informatica, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Modeling Tools Power Designer, and MS Visio with strong SQL skills. Good experience with Agile and Waterfall environments. Skilled with SQL, PL/SQL, Partitioning, Data modeling, Logical and Physical Database Design.
SKILLS
Subject Matter Expert and also worked with statistical programmers in order to secure that data views are precise.
Skilled in Data designing, Data mapping, Data Manipulation and cleansing of data for achieving analytical dashboards
Interpreted data to draw conclusions for managerial action and strategic solutions
Optimized data collection procedures in order to develop monthly, weekly and daily based reports.
Created Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
Developed Geo/Area Maps to show Finance details by states
Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability
Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
Published Dashboards onto Centralized Tableau Server location and from there consumers would choose viewing medium (laptop, pc, IPad)
TECHNICAL EXPERIENCE
Tableau Admin / Developer (Consultant)
March 2020 – Present
Reef Technology
MIAMI, FL
Worked as part of Reef’s BI Analytics teams handling Kitchen, Real Estate and Parking Dashboards
Participated in requirement gathering by meeting with Business Users and base lining the details, preparing the BRD (Business Requirement Document) and conducting application demonstration. Based on the scope of business requirements, designed the System Requirement Specifications (SRS) documents
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
Wrote complex queries for reporting needs, testing validation and data analysis.
Created several Complex Dashboards and set up the Interactivity between different charts in the dashboard using Tableau Desktop
Worked with various infrastructure teams and Tableau support team to help improve dashboard response time.
Implemented Third Party Extensions like Super Tables and Sankey diagram charts within Tableau dashboards for better user interactive experience.
Provided support to different levels of Tableau developers
Involved in Performance tuning of the application to meet operational production requirements
Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
Assisted Business Users/Colleagues with dashboarding, best practices and publishing.
Tableau Admin / Developer (Consultant)
Royal Caribbean Cruises Ltd
Aug 2019 – Feb 2020
MIAMI, FL
Involved in gathering the requirements from Business partners, Directors and Managers of different Brands of RCL.
Trained offshore team in Manila and end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau Desktop and Tableau Prep.
Worked as a Tableau Administrator by managing Production, Test and Development environments for each of the Brands.
As part of Admin role, created different sites and projects based on business requirement on Tableau Online and managed the sites on everyday basis.
Maintained dashboards within each project after every feature was added and upgraded the tools whenever needed.
Created and modified Interactive Dashboards and Created guided navigation links within Interactive Dashboards.
Created custom Scorecards, Donut Charts, Geo-mapping, Bullet charts, Bars and Stacked bar charts, line charts, text tables, bubble charts, pie charts, scatter plots etc.
Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
Supported front and backend initiatives.
Connected to multiple data sources on the back end as well as the cloud and built out a single source.
On the front end, built out dashboards, taken the vision from the Director, and established the dashboards.
Tested dashboards developed by other team members and deployed them to Production after bug fixes.
Guided fellow team members and end users in investigation, diagnoses, and problem resolution
Communicated the vision with Stakeholders and presented information to leadership
Environment: Tableau Desktop 2019.4, Tableau Online, Tableau Prep 2020.1, Power BI, JD Edwards, Oracle – Peoplesoft, SQL Server Management Studio 18, Excel and other data wrangling tools.
Tableau Developer (Consultant)
April 2019 – July 2019
Charter Communications
St. Louis, MO
Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
Expertise with developing, designing and supporting interactive Tableau Interactive Dashboards and Storyboards.
Identify and analyze Business Requirements from documents and end-user discussions which involved in the review of Service Oriented Architecture and design of data models which include Staging in data warehouse.
Created custom Geo-mapping, Bullet charts, Bars and Stacked bar charts, line charts, text tables, bubble charts, pie charts, scatter plots, header metrics etc.
Worked with various reporting objects like Sets, Groups, Attributes, Hierarchies, Filters, Calculated fields, Parameters, Prompts, and Transformations etc.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
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.
Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
Worked on data blending and linking in case of merging different sources.
Experience with the design and development of Tableau visualization solutions.
Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
Mentored business power users to create reports/dashboards using tableau desktop.
Hands-on, results oriented team player with excellent communication skills.
Environment: Tableau Desktop 2018.3.2, Tableau Server 2018.3.2, Alteryx Tool, Shiny R, Splunk, Python, SQL Server Management Studio 14.0, Excel
BI Developer (Consultant)
Sept 2018 – March 2019
CIOX Health
Alpharetta, GA
Participated in scrum meetings and coordinate with Business Analysts to understand the business needs and implement the same into a functional design
Analyzed and created business models, logical specifications and/or user requirements to develop solutions for the application environment through mockup reports
Developed reporting dashboards using Tableau, Kofax and Power BI tools based on Health Source medical records data
Published the developed dashboard, reports on the Tableau Server, HS Application Production Servers so that the end users having access to the server and can view the data.
Performed ETL operations in order to provide search criteria through reporting for various projects
Schedule jobs in different projects for data refreshes from data warehouse into Kofax tool as well as loaded data for individual record levels while working on reports
Designed, developed and implemented software applications, create system procedures and ensure that the developed applications function normally
Create records, metrics and views in order to generate reports using Kofax
Review basic SQL queries and edit inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
Participate in monthly held workshops along with directors, manager and other team members to demonstrate workflows and demos
Train the other team members on Tableau Desktop 2018.1 and assist them in initial development stages with Production deployments and other issues
Review and suggest improvements for dashboards and visualizations developed.
Perform execution of functional test plan, validate test results, prepare documentation and data for analysis
Environment: Tableau, Altosoft Kofax Tool, Oracle, Amazon Redshift, Cognos, Power BI, SQL Server Integration Services (SSIS), Git Source Control.
Tableau Developer (Consultant)
December 2017 – August 2018
Celerity(End Client: Fresenius Medical Care)
Cranberry Township, PA
Created customized and interactive Tableau dashboards using multiple data sources - Oracle, SQL Server, CSV files
Understood the business needs so that it can be translated to open questions to solved insights that motivate entire team to do more.
Took board requirements and transferred into fast developed prototypes and working solutions
Provided expertise developing Tableau reports dealing with predictive results from analytical trending and modeling
Participated in design reviews, code reviews, brainstorming sessions and QA bringing an open mind to work and a helpful eye for others.
Defined and communicated best practices for report development
Worked with data architects to define report performance optimized data models
Developed detailed data mapping and end-to-end process flows and also worked with big data analytics, automation and machine learning technologies
Strong Data Analytics skills with an ability to analyze datasets with Microsoft Excel or Tableau and worked with customers to define KPIs for monitoring process improvement
Downgraded all the existing workbooks from Tableau 10.4 to Tableau 10.2 in order to publish them on the Fresenius Tableau Server.
Worked with customers to define reporting needs and implement Tableau reports to satisfy needs
Provided recommendations for data presentation within reports/dashboards
Identified opportunities to increase the efficiency of the reporting process – including automation of existing manual datasets
Environment: Tableau Server 10.2, 10.4, 2018.1, Tableau Desktop 10.2, 10.4, 2018.1, MS SQL Server 17.4, Oracle 10g, MS VISIO, Microsoft Office Suite.
BI Developer (consultant)
September 2016 – November 2017
Kohl’s Corporation
Milwaukee, WI
Participated in reviewing business requirements and analyzed data sources from Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Installed, upgraded and configured database solutions through OBIEE tools.
Developed data access queries through Oracle BI tools.
Generated Reports using procedures and views for faster execution and migrated reports from one version to another.
Also 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 by color that was broken into cities allowing business user to understand.
Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Applied Cascading Prompts and Multi-Level Prompts on dashboards.
Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
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.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Environment: Tableau Server 6, 7, 8 Tableau Desktop 6, 7, 8, Python, Oracle 10g, MS SQL Server 2008, SSDT, Share Point, TFS, Informatica 9.1, UNIX, SQL Server 10g, MS VISIO, Microsoft Office Suite.
Tableau Developer/Admin (Consultant)
July 2015 – August 2016
DC Health Benefit Exchange
Washington DC
Participated 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.
Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
Created various templates, reports, and prompts in BI Publisher.
Developed Oracle BI Metadata repository using BI Administration tool.
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 by color that was broken into cities allowing business user to understand.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Environment: Tableau Desktop 9, 8 & 7, Tableau Server, OBIEE 10.1.3.4, Oracle 10g, SQL, MS Office Suite, Teradata.
Tableau Developer (Consultant)
March 2014 – June 2015
Kettle Foods Inc.
Salem, OR
Interacted with business users and performed Gap Analysis of Client requirements.
Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
Worked closely with business 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 Tableau software 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.
Scheduled frequency and time to refresh data when sources are published or extracted to server.
System administration and programming skills such as storage capacity management, performance tuning
Designed and developed various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
Created Test Cases and documented the Test Results.
Participated in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
Environment: Tableau 8, OBIEE, Oracle 10g, Teradata, SQL Assistant, Python, Business Objects, PG admin, SQL, PL/SQL, MS Project.
Tableau/DataStage Developer (Consultant)
November 2012 – February 2014
Ally Financial Inc.
Detroit, MI
The company's Global Automotive Services offer retail auto financing and leasing; dealer lines of credit for vehicle inventory, equipment or facilities; insurance coverage including retail vehicle service contracts and commercial insurance; and re-marketing services through physical auctions and online services.
Used DataStage ETL tool to load data from flat files and source tables to the staging, dimension and fact tables.
Created DataStage parallel jobs and sequencers to load data into dimensionally modeled schemas (star and snow flake schemas) using Ralph Kimball methodology.
Created Dashboards and reports using Tableau.
Coded SQL, Pl/Sql queries for data validation, data massaging, data analysis and data loading.
Created tables in Oracle database for all the schemas designed.
Designed, developed and tested the DataStage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
Performed fine tuning, Trouble shooting, bug fixing and defect analysis in DataStage Jobs.
Resolved the defects which have been raised by QA.
Used advanced functions such as table calcs and LOD (level of detail) calculations wherever required.
Defined best practices for tableau environment to standardize maintain consistency and improve efficiency.
Published dashboards as tabs to group dashboards for every program.
Comprehensive tableau testing for reconciling measures and other values between database and Tableau environment (views and dashboards).
Environment: DataStage 8.0, Tableau 8 Desktop & Server, Oracle 11g, PL/SQL, SQL *Plus, Data Stage, Excel.
EDUCATION
Bachelor of Technology in Information Technology
Contact this candidate