SUMMARY

• Having 15+ Years of IT professional experience in all aspects of Business Intelligence (BI) server architecture setup with: Tableau Server, Alteryx Server, Xceptor Automation Server, BO server, RPA - Automation Anywhere control room server and Qlikview with a strong background in Database development
• Expertise in Full Life Cycle Development including Planning, Analysis, Design &Development, Implementation and Support& Maintenance.
• 9 years of experience into Tableau-Tableau /Server Admin /Tableau Desktop/Tableau Prep/Tableau Online as senior tableau server administrator, creating tableau data /hyper data extracts (multi table) and its troubleshooting connected interactive Data Visualization Reports and Dashboards on the server.
• 7+ years of experience into Tableau Administrator as a Admin setup in on premise and Cloud infrastructure (AWS, Azure etc.,)
• Served as subject matter expert (SME) for the Tableau Server and Tableau Desktop version (2019.2/2019.1/2018.2 ) upgrade project, Tableau Server and Tableau Desktop version 10 upgrade projects.
• Designs the architecture of Tableau Server platform setup with High Availability, Failover and DR environments across enterprise level.
• Monitors Tableau server performance and user activities, backup and restore, configuring, upgrading, and patching Tableau servers.
• Manages Tableau user access, scheduling jobs, developing dashboards, data sources, testing workbooks, and end user support.
• Administers the virtual machines (VMs) of Tableau servers.
• Tableau server setup with Local/AD authentication with configuration of SSO SAML-OKTA integration, SSL and ELB
• Setup control and monitoring of Tableau server cluster with Nagios and Splunk.
• Helping to setup Tableau dashboard regression testing, tableau server load with using Kinesis, Tabjolt and Tabmon tools.
• Creating custom admin views using Postgre db and reporting to management leadership to make their quick decisions.
• Also extensively working on tableau server environment migrations(eg. QA, DEV, TEST/UAT and PROD).
• Supported Tableau Server audit, during which all project stewards for the 100+ projects submitted information to verify user access and send additional required governance information for their projects, requiring significant processing and processing nearly 500 Tableau server requests in 2016.
• Assisted the Windows team with patching Windows servers (Development, Test, Production)
• In-depth knowledge on Tableau Server, Tableau Desktop, Tableau Reader.
• Proficient in Installing Configuring and Administration of Tableau Server for high availability and performance.
• Performed analysis to build Tableau Extract data sources leveraging existing data marts and warehouses. Technical expert in the identification of solutions meeting complex business needs that facilitates automation and drives self-service.
• Supporting peers and stakeholders as a Tableau Subject Matter Expert (SME) through troubleshooting and analysis of results. Acting as mentor and Tableau SME for other Tableau users across the enterprise.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks embedding views by integrating with other platforms like SharePoint
• Experience with content administration and security administration.
• Extensively used TSM, Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Monitoring activities on Tableau application performance (extract refreshes, dashboard rendering, and email subscriptions) but can also include some aspects of the virtual machines such as CPU, storage, RAM
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level-of-Detail (LOD) expressions etc., in Tableau.
• Implemented Binning & Blending concepts in my Tableau Reports
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPIs) for the top management.
• Experience in using Tableau functions (Logical, Number, String, Type Conversions, and Table Calculation, LOD) when creating the calculated fields.
• Used AWS's Virtual Private Cloud (VPC) feature to set up a separate logically isolated network for to launch and run server.
• Used Tableau with AWS cloud connecting to AWS EMR and AWS redshift.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Restricted data for users using Row level security and User filters.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Extensively Used Horizontal, Vertical Containers and other dashboard components to make the dashboard more interactive and to make the dashboard look pretty
• Produced attractive visuals/dashboards to convey the Tableau story inside the data.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards and worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Used Kerberos for user authentication thru Active directory (Win AD).
• Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Extensively worked on the Data Extracts and aggregated Extracts, Incremental Extracts for high performance and Interactivity.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD/Aquastudio
• Strong database knowledge of SQL, stored procedures and triggers. Master SQL skills and ability to troubleshoot
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Outstanding analytical, technical, interpersonal, organizational, communication, problem solving, communication and self motivated skills, . Extensive experience working with senior management and client relations.
• Hands-on skills and deep experience working with the latest Tableau Server version, its Administration and the Maintenance. Experience working with Extracts, Live datasets, managing access privileges. Familiarity with Tableau SDK architecture.

TECHNICAL SKILLS

Tableau: Tableau Server, TSM,TSMCLI,TSM, TABADMIN, TABCMD, webUI, Tableau Desktop, Tableau Prep, Tableau Topology, Tableau Online, Tableau Public, Tableau mobile

Cloud Infrastructure: AWS, MS Azure

Reporting Package: Alteryx Server(DEV,TEST/UAT,PROD), Xceptor Server Automation, RPA-AAE Control room cluster server, Cognos 8 BI, MSBI(SSIS, SSAS, SSRS, Performance Point), Qlikview 10, Qlik Sense, SAP Business Objects Server, Microstrategy, Crystal Reports

Tableau Integrations with: Python (Tabpy), Salesforce, Sharepoint site, Tableau RESTAPIs

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

Databases: POSTGREs, Oracle, SQL Server, DB2, SAP HANA, Teradata, MySQL, Hadoop Hive, XML,AWS-RedShift,EC2, RDS, S3

Operating Systems: Windows, Linux

Languages: SQL, AQUA-STUDIO, PL/SQL, T-SQL,Transact SQL,Python R Programming, C, PHP

PROFESSIONAL EXPERIENCE

Confidential

Senior Tableau Administrator

Responsibilities:

• Plan, manage, and monitor all aspects of Enterprise Management support as the Reporting Lead Tableau Administrator Architect.
• Installation of Tableau Server on Single Server as well on the distribution/cluster topology (HA) environment with Backup primary in case of failover support.
• Installed Primary/initial node server and Worker/additional nodes for high availability, performance and scalability of the environment and configured Failover and DR plan.
• Expertise in Hardware configuration for AWS EC2 Instance Types and creating cluster security groups
• Configured Tableau server with Active Directory as the Authentication Source.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL, Oracle)
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Configured Tableau server with SMTP, SSL, SAML certificates for SSO
• Provide the user access to team for AWS console and SSH connectivity to the Edge node.
• Maintaining Security and Create/manage Users, Groups, Licenses and integrate with Active directory.
• Create Extracts in Tableau Desktop and published to Tableau server.
• Scheduled and maintained the data extracts (.tde),hyper data extracts, Content Extracts and Subscriptions on Tableau Server for Daily, Weekly and Monthly Reports.
• Prepared and documented AWS Migration document from Navi Site to AWS infrastructure .
• Monitoring and reporting weekly, monthly Tableau server usage statistics reports on Background Tableau Data Extracts.
• Setup Tableau server Repository to access various tables and custom admin views
• Tableau server integrated with TabPy(Python) and SalesForce.
• Actively involved and migrated content from one Tableau server environment to another.
• Upgraded Tableau server from 10.X v to 2018. 2 v to 2019.1 to 2019.2v
• Monitoring and fine-tuning of Tableau server key performance processes.
• Create the Data Source Connection (.tds) in Tableau Desktop and Published to the Server for adhoc reporting and other developers to use the connection
• Prepared automatic backups and restored backup s from the repository using Tabadmin and Tabcmd commands.
• Gathered requirements for Capacity planning and load balancing a multi node server installation.
• Monitored server activity/usage statistics to identify possible performance issues/enhancements.
• Monitored activities with heavy emphasis on Tableau application performance (extract refreshes, dashboard rendering, and email subscriptions).
• Developed Interactive custom Admin Dashboards, Workbooks and Stories using Tableau Functionality.
• Backup of the servers using the TSMCLI Commands, Tabadmin,Tabcmd Commands.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources
• Working experience with the following technologies: Amazon Redshift, Hadoop, HBase, Pig, SQL
• Coordinated with Development Team & Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.
• Ratios using key performance indicators, Claim Financial Highlights over the years.
• Work with customers to assist them with analyzing their data and defining performance management requirements.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Environment: Tableau 10.4/10.5/2018.0/2018.1/2018.2/2018.3/2019.1/2019.2 (Server, Desktop),TSM,TSMCLI, Tableau Prep (2018.1v) AWS Redshift, AWS EC2 Instances, S3 Bucket, ELB, SSO-SAML-OKTA, SSL, Alteryx Server, Xceptor Server Automation, Oracle,Oracle-Esbase cubes, Excel, DB2 Mainframe Data, Business Objects, Microsoft Windows 2018/2012 R2 Enterprise Server.

Confidential

Tableau Administrator

Responsibilities:

• Plan, manage, and monitor all aspects of Enterprise Management support as the Reporting Lead Analyst.
• Work with customers to assist them with analyzing their data and defining performance management requirements.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Installation of Tableau Server on Single Server as well on the distribution environment
• Installed Primary server and Worker nodes for high availability, performance and scalability of the environment.
• Configured Tableau server with Active Directory as the Authentication Source.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Provide the user access to team for AWS console and SSH connectivity to the Edge node.
• Maintaining Security and Create/manage Users, Groups, Licenses and integrate with Active directory.
• Create Extracts in Tableau Desktop and published to Tableau server.
• Scheduled and maintained the data extracts (.tde), Content Extracts and Subscriptions on Tableau Server for Daily, Weekly and Monthly Reports
• Create the Data Source Connection (.tds) in Tableau Desktop and Published to the Server for adhoc reporting and other developers to use the connection
• Prepared backups and restored backups from the repository using Tabadmin and Tabcmd commands.
• Gathered requirements for Capacity planning and load balancing a multi node server installation.
• Monitored server activity/usage statistics to identify possible performance issues/enhancements.
• Monitored activities with heavy emphasis on Tableau application performance (extract refreshes, dashboard rendering, and email subscriptions).
• Developed Interactive Dashboards, Workbooks and Stories using Tableau Functionality.
• Backup of the servers using the Tabadmin,Tabcmd Commands.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes .
• Used Sheet filters to produce multiple chart types in a single view .
• Developed several worksheets filled with Bar, Line, Pie, Maps Charts and Highlight Tables for rich visualizations and analyzing of the data.
• Used Sheet filters to produce multiple chart types in a single view .
• Used calculated fields extensively for different logics for Trend, Extended price calculation s for the different cost types.
• Defined relationships, created actions, filters, Level-of-Detail (LOD) expressions parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel.
• Convert business requirements into story-telling viz by developing views and dashboards in Tableau Desktop and publish them to Tableau Server
• Projected and forecasted future growth in terms of number of claims lowered based on upgrading to new plans by developing Area Maps to show details on which states were upgraded the most using Forecasting functionality
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards
• 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.
• Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using tableau desktop
• Extensively used Horizontal, Vertical Containers and other dashboard components to make the dashboard more interactive and to make the dashboard look pretty.
• Familiarity with stored procedures, query performance tuning and ETL (ideally on Oracle) in order to troubleshoot issues with dashboard.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources
• Working experience with the following technologies: Hadoop, HBase, Pig, SQL
• Coordinated with Development Team & Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.
• Ratios using key performance indicators, Claim Financial Highlights over the years.

Environment: Tableau 10.1 (Server, Desktop) Oracle 11G, IBM Data stage 8.1, Excel, DB2 Mainframe Data, Business Objects,Microsoft Windows 2008 R2 Enterprise Server.