Data Tableau

Sindhu Ph: 717-***-****

Tableau Developer E-Mail: **.*********@*****.***

SUMMARY:

•Having 8+ years of extensive experience in IT with full System Analysis & Design, Development, Administration, Integration, Implementation, Performance Tuning and Maintenance of Business Intelligence and the related Database Platforms.

•Experience in Installation, Configuration, Upgradation and Maintenance of Tableau Server.

•Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop.

•Experience in Performance Tuning of reports within Tableau Server and Tableau Dashboards.

•Extensive Tableau Administrator experience including technical support, troubleshooting, server backups, maintenance and monitoring of system usage.

•Experience in Tableau Administration including managing Licenses, Site creation and Storage management, Subscription to views, Schedule Refresh tasks, Permissions to Users and User Groups and creating Custom Admin Views for the quick analysis of User activity and Load times for Views.

•Experience in creating

•Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source and Context Filters according to the end user requirement.

•Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of those statistical models.

•Conducted Gap Analysis, created Use Cases, Work Flows, screen shots and PowerPoint presentations of Tableau in the Client Web Applications.

•Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate strategic planning in all functional areas including Order Management, Finance and Planning, Process Management, Sales/ Marketing and Resource Management.

•Experience in generating reports by fetching data from different sources (RDBMS/ Text/ CSV/ EXCEL) using Data Blending.

•Established best practices for Enterprise Tableau Environment and development processes.

•Experience in writing SQL, T-SQL/PL SQL (Stored Procedures, functions and triggers) scripts for reporting, data analysis, and ETL validations and to support Ad-hoc business requests.

•Experience working on both OLTP and OLAP databases and strong understanding of Data Warehouse and Data Mart concepts, multi-dimensional schema (Star Schema and Snowflake Schema) and large datasets.

•Experience using SQL Server Management Studio, SQL Developer, Toad and Microsoft Excel.

•Experience with SDLC, Agile and ITIL Change and Incident management processes and tools.

•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•End to end experience in designing and deploying data visualizations using Tableau.

•Expert in tableau server commands like synchronization, Tamed and Tableau server backup activity.

•Deployed the reports and scheduled the reports for the use of end users.

•Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

•Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.

•Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

•Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact, and Dimensional Tables.

•Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.

•Ability to architect a custom solution. design, development, distribution of custom client-server and WEB solutions. Integrator of relational databases like SQL Server, ORACLE, Microsoft Access, and Excel spreadsheets.

•Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

•Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, Permissions, groups, sets and hierarchies.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop v 10,9,8, Tableau Server, Micro Strategy, Microsoft SQL

Server Reporting Services

ETL Tools: Oracle Warehouse Builder(OWB) 10g and 11g

Self Service BI: Tableau Desktop 9.2, Tableau Server 9.2 and Tableau Reader

Operating Systems: Windows XP, Windows 7, UNIX/LINUX

Programming Languages: SQL, PL/SQL

Relational Database: Oracle Database

SQL Tools: SQLPLUS, PLSQL Developer, Toad for Oracle

PROFESSIONAL EXPERIENCE

Change Healthcare, Chicago, IL Nov 2017 – Till date

Sr. Tableau Developer

Responsibilities:

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters

Participated in meetings, reviews, and user group discussions as well as communicating with business groups.

Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with the best plan of execution.

Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications.

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.

Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.

Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.

Used Custom SQL for joining the tables and selecting the required Data.

Creating users, groups, projects, Data connections, settings as a tableau site administrator.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards, Permissions.

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 quick filters to filter needed information.

Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation.

Responsible to create Aggregates, Hierarchies, Charts, Histograms, Filters, Quick filters, Table Calculations, Trend lines and calculates measures and more.

Responsible to develop reports and dashboards using Tableau Desktop and publish them using Tableau Server

Responsible to monitor Tableau Server infrastructure and support all user queries related to the availability of the server for use.

Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

Utilized SQL to develop new and debug existing Ad-Hoc reports. Migrated Crystal Reports into Web based Ad-Hoc reporting.

Developed donut charts for analyzing sales planning data.

Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions

Environment: Tableau Desktop 10, Tableau server 10, MySQL Workbench, Microsoft Excel 2012, Microsoft office 2010

Reyes Holdings, Rosemont, IL Apr 2017-Oct 2017 Sr. Tableau Developer

•Responsibilities:

•Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters

•Participated in meetings, reviews, and user group discussions as well as communicating with business groups.

•Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with the best plan of execution.

•Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications.

•Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.

•Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.

•Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.

•Used Custom SQL for joining the tables, and selecting the required Data.

•Creating users, groups, projects, Data connections, settings as a tableau site administrator.

•Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards, Permissions.

•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 quick filters to filter needed information.

•Responsible to create Aggregates, Hierarchies, Charts, Histograms, Filters, Quick filters, Table Calculations, Trend lines and calculates measures and more.

•Responsible to develop reports and dashboards using Tableau Desktop and publish them using Tableau Server

•Responsible to monitor Tableau Server infrastructure and support all user queries related to the availability of the server for use.

•Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

•Utilized SQL to develop new and debug existing Ad-Hoc reports. Migrated Crystal Reports into Web based Ad-Hoc reporting.

•Developed donut charts for analyzing sales planning data.

•Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions

Environment: Tableau Desktop 10, Tableau server 10, MySQL Workbench, Microsoft Excel 2012, Microsoft office 2010, Teradata, Greenplum, Supply Chain, JAVA API, D3. JS, Hadoop Hive, Cloudera, Netezza, Alteryx, SAS, Excel, Flat files, Microstrategy, Qlikview.

Time Warner Cable Inc., Charlotte, NC Jan2017-Apr2017 Sr. Tableau Developer/Admin

Responsibilities

•Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, etc) using Tableau

•Develop load scripts for extracting, transforming and loading data into Tableau applications

•Design and develop new interface elements and objects as required, developed Macros, SET ANALYSIS to provide custom functionality using Tableau.

•Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.

•Created complex formulas and calculations within Tableau to meet the needs of complex business logic

•Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.

•Developed various data connections from data source to Tableau Desktop for report and dashboard development

•Created Technical Documentation for reports and maintenance/enhancements of existing Reports

•Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.

•Involved in project planning, scheduling for database module with project managers.

•Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.

•Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.

•Developed various SSIS packages for managing current and historical data using various transformations. Developed complex SSRS reports involving Sub Reports.

•Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.

•Analyzed data to determine trends and aide in improve product utilization practices.

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

•Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

•Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

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

•Effectively used data blending feature in tableau. Defined best practices for Tableau report development.

•SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.

Environment: Tableau 8.0.1 Desktop, MS SQL Server 2008R2/2005, SSIS, SSRS, SSAS, Windows 7/XP, Management Studio, Supply Chain, Greenplum, Netezza, SAS, JAVA API, D3. JS, Excel, Flat files, Qlikview, Hadoop, Tableau Desktop 9.2, Tableau Server 9.2, Tableau Reader, Microstrategy, SQL, PLSQL Developer, Oracle Database 11g and Unix, Alteryx,.

Centene Corporation, St. Louis, MO Oct2012– July2015

Tableau Developer

Responsibilities:

Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary

Created dashboards for the clients to measure performance of their services and financial management.

Created views and dashboards on end client's sales data. Produced powerful dashboards telling story behind the data in an easy way to understand format such as pie, bar, geo, and line charts.

Developed Scatter Plots and Area Maps to show investment/ROI by states.

Developed Geo/Area Maps to show Finance details by states.

Created Shared data sources for the users.

Installed and Configured Tableau 8.0 on multiple environments.

Verified the runtime user permissions on the Database.

Design, develop and support complex performance and capacity charts and reports using Tableau Tool.

Configured Cache settings which improved the performance of the reports and Dashboards.

Created calculations this includes from basic arithmetic calculations to complex Mathematic calculations.

Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Participated in regular Technical Reviews, Defect review and walkthrough meetings with important projects & business stakeholders throughout the project life cycle.

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server 2008.

Assurant, New York, NY Jan2011 – Sep2012

Tableau Developer

Responsibilities:

Designed Visual Reports and interactive Dashboards in Tableau for Analysis for the Individualized Program

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards

Administered user, user groups, and scheduled instances for reports in Tableau.

Defined group level security standards for Tableau.

Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1

Resolved various performance issues and analyzed the best process distribution for different projects.

Created and assisted users in Tableau dashboard development.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Created extract files for improving the performance.

Used different Mark types and Mark properties in view to provide better insights into large data sets. Created various types of charts for better visualization.

Created Bar Charts which are complied with data sets and added trend lines and forecasting data.

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Developed business process and technical design documentation for each reporting service developed in this project.

Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.

Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, MS Office.

Control Point Solutions - Chennai, Tamil Nadu Jan2010-Dec2010 Business Analyst / Business Objects Developer

Responsibilities:

Was personally involved in meetings with Business Team Managers and colleagues to define and scope list of reports, content desired in these reports, formatting and presentation standards for these reports, Time Line of Development and helped in assessment of Level of Effort with other team members.

Worked with Data Warehouse team to identify underlying Oracle database related to business requirements.

Documented UAT Process and worked with the Team to take Sign Offs on reports completed.

Document reports content with respect to data sources used and data reporting on.

Was involved in Weekly Meetings with Managers to update Status of report development.

Was proactive in updating all concerned stakeholders with respect to completed and pending tasks.

Worked with different team member and end user groups to better understand the system and developed usable reporting products and reported in a timely manner.

Worked on building Web Intelligence reports. Most of these reports prompted users to pass values to queries during execution and in some cases as were used for displaying or hiding a table or section.

For Tables and Sections used variables as filters so as to show data or hide if condition is not met.

In detailed reports which show holdings applied breaks at Sector Level to show Sub Totals for each Sector.

Applied Custom Number formatting for selected measures.

Used Pre-Defined Cells such as Page Numbers, Last Refresh Date and others on specific desired reports.

Used Documents Structure Map and Element Properties to custom name them so as to relate to which data set each table or chart is referring to. Organized this information which helped in detail documentation of report design and development process.

Updated Document Properties such as Refresh On Open and Auto Merge Dimensions to customize these and related setting for each specific report. Ideally used Refresh On Open for Dashboard Style Reports and used Auto Merge Dimensions only if applicable.

Created list of tables and their relationships for dimensional modeling identifying lookup tables and fact tables and scoped inventory of tables needed for creating the universe.

From time to time when ever any report needed upgrade either to underlying database changes and or business requirements change updated such reports and followed their development life cycle.

Environment: Oracle 9i, TOAD, Business Objects XIR3 XIR2 Web Intelligence.

EDUCATION

Bachelors of Pharmacy, JNTU-H, India, 2010

Contact this candidate