Sitarama Raju Gottumukkala

Tableau Server Admin/Architect

Ph: 571-***-****, email: adcszz@r.postjobfree.com

Ln: https://www.linkedin.com/in/raju-s-gottumukkala

Location: Miami, FL

SUMMARY

Tableau Solution Consultant with 12+ years of professional experience in Business Intelligence Tools (Tableau, SAP Business Objects, SAP Data Services, Power BI) and in Information technology with skills in all phases of Data Warehouse lifecycle developments, Client/Server Applications and Internet Applications.

EXPERIENCE

Strong experience in installation, configuration, administration, technical support, troubleshooting and maintenance in a distributed environment and overall health of the BI Tools implementations.

Expertise in providing guidance in the design, development, planning, security, migration, upgraded analysis, trouble shooting, performance tuning, sizing and implementation of business intelligence products.

Experience in implementing patches including both minor and major upgrades to ensure the constant uptime and proper tuning and backups and restore.

Experience with reading through logs to work through problems finding root causes and rectifying.

Expertise in WINAD SSO, SAML SSO, Trusted Authentication and integration with other applications and Implementing SAP ECC/BW/HANA, MS SQL Server database SSO implementations.

Experienced in troubleshooting performance issues, capacity planning and load balancing both scheduled and ad-hoc reports.

Experience in end-user community, responding to help desk calls and trouble tickets, working with vendors to resolve HW and SW problems.

Detailed experience in understating database environments, SQL and data warehousing techniques/ETL to support partnership with Data Architects and DBAs for data architecture and database needs and configuration.

Excellent interpersonal skills, energetic team player with demonstrated proficiency for learning new tools with excellent communication and analytical skills.

CERTIFICATION

Tableau Server Architect Badge

https://www.youracclaim.com/badges/a5e2fa35-f0f9-44c0-aa19-913326b011f0/public_url

Tableau Server Admin Badge https://www.youracclaim.com/badges/c86d94e5-669c-48c2-ab2e-f5c6c980e746/public_url

SAP BObj Admin – Open SAP Certified

EDUCATION

MS Computer Science ~ 2006 - 2008

University of Northern Virginia, VA, USA

B. Tech Electronics ~ 2001 - 2005

Pondicherry University, INDIA

AREAS OF EXPERTISE

End to End Server Implementations in Linux & Windows operating Systems hosting on VMware, AWS, AZURE.

Upgrade and Migrations.

Implementation of SSL, WINAD SSO, Trusted Authentication, SAML SSO.

Configuration of SSO certificates to SAPBW/HANA for data level security.

Troubleshooting performance Issues, Memory tuning & Capacity planning.

SKILLS

Reporting Tools: Tableau, SAP Business Objects, Power BI, Crystal Reports, Lumira, Hyperion

ETL: SAP Data Services, SAPBW Informatica, DataStage

Databases Oracle, MS SQL Server, MySQL, PostgreSQL, DB2, AWS Redshift, Teradata, Couchbase

Tools & Languages: Dbeaver, SQL Developer, Eclipse Python, RServe, Linux Shell, HTML, CSS, Java Script.

Work Experience:

JAN-2019 – Current

Royal Caribbean Cruises Ltd., Miami/Miramar, FL

Sr. Tableau Server Admin/Architect

Responsibilities:

Installed & Configured Tableau 2019.4.1/2019.2.3 on RED HAT LINUX VMware & AWS REDHAT Linux servers on a 3-node cluster environment.

Configured & deployed tableau on to around 40 Royal Caribbean Individual Cruise ships.

Installed Tableau Prep Builder 2019.4.1 and created Schedule output flows using Prep Conductor

Created tabcmd scripts to publish reports to all 40 Royal Caribbean Individual cruise ships.

Configured VizQL Configurations settings for Report spin issues.

Created Couchbase Data Extraction shell script to extract data to .csv file utilizing the Couchbase Analytics REST API and connected Tableau to the extracted csv file.

Configured Tableau server processes to maximize the server performances as per sizing guidelines.

Installed MySQL,AWS Redshift, Oracle, Dremio ODBC Drivers and Fonts on REDHAT LINUX.

Installed Tabpy, RServe, R Studio, Python on linux environment for Tableau Integration with Python & RServe.

Configured Tableau Bridge service for Tableau online schedules and created scripts to refresh cache after the extract runs.

Configured & Integrated Tableau with LDAP server for user logins and smtp for sending emails.

Created Monitoring scripts to monitor CPU/Memory and Tableau services monitoring script to alert using email.

Created Tableau Repo Backup script, log cleanup scripts and weekly maintenance scripts for Tableau environment.

Provided infrastructure troubleshooting for Tableau Server (VMs, IPs, system/network, firewalls)

Provided application expertise and guidance for users and system engineers

Documented standards/best practices for development and administration of the Tableau platform

Utilized the JavaScript API Customized the Tableau landing page with site listing as icons and descriptions to create a customized portal for the Excalibur Executive Dashboards.

Consulted on Tableau server performance enhancements and server reconfiguration based on workbook complexity and data extraction.

Created/Managed Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.

Developed Tableau reports & Prep Flow for Hybris Operational Reports for ship & shore side.

Developed Tableau Schedule Alert Dashboard to send alerts when an extract/flow schedule fails.

Developed custom tableau report for summary of sales to download data with excel formulas.

Facilitated with tech Support to Formulate a Strategy for Implementing Good User support.

Worked with firewall team to open ports between Tableau server and Databases, validated ports using telnet command.

Implemented Trusted authentication for TV screens to login without ID and password.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Migrated Tableau using Content Migration Tool from TEST to Stage & DEV site to PROD site.

Used Tableau Content Migration Tool for Tableau content(Dashboards/Reports/Data sources) from one environment to another and Site to Site.

Configured Pager Duty email setup for Tableau to send Tableau service alerts to Email & Phone.

Provided 24x7 operational support for all production related issues, troubleshooting and system maintenance and ensured maximum uptime of the servers.

Environment: Tableau 2019.3/2018, Couchbase,MySQL,AWS RED SHIFT, Oracle 12x,MS SQL Server 2016, Google Sheets, DBeaver, Windows 2012/2016,REDHAT LINUX 6.7

APR -2018– DEC - 2018

Canon USA, Melville, NY

Sr. Tableau/BObj Admin/Systems Architect

Responsibilities:

Responsible for Tableau Server Administrative functions, upgrades, installations, configurations, license management, backup /restore of servers.

Installed & Configured Tableau 10.5.5 Patch on Tableau 10.3.3 on Insight Windows 2016 Servers

Installed & Configured Tableau 2018.2.3 on REDHAT LINUX 6.7 for CorpSys.

Configured Tableau server processes to maximize the server performances as per sizing guidelines.

Implemented Tableau – SAP BW SSO using SNC Trusted certificates.

Installed and configured Google certificates to do oAuth data connection with Tableau.

Increased Java Heap Size using Tabadmin set command from 128m to 256m for to increase load on number of user’s login.

Installed and configured Tabmon for Monitoring Tableau process memory & CPU Utilization and System Performance.

Created restart, backup, cleanup Batch scripts for to restart Tableau server to take Weekly to cleanup memory & CPU and take backup of repository.

Created/Modified/Managed data extraction by schedules and create schedules as per the business needs and scheduled extract during off-hours and enhanced performance of the server loads.

Imported tableau workbook UPPStarterKit.twb that was provided Tableau ELITE support to monitor tableau performance, user logins etc.

Used tabcmd to add users to import users in bulk to tableau server.

Restored Tableau server from a backup when user requested for a deleted workbook.

Responsible for maintenance activities like logs cleanup and archiving log files, taking tableau repository backs in prescribed intervals used for business continuity during a disaster.

Created/Managed Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.

Responsible to assist in troubleshooting application, database connectivity, networking, operating system issues.

Responsible to work with firewall team to open ports between Tableau environments & Database environments.

Consulted on Tableau server performance enhancements and server reconfiguration based on workbook complexity and data extraction

Installed Tableau Desktop Client on Citrix Environment and Installed Database Client Software’s for DB2, Teradata, Oracle, MySQL, SAP BW, SAP GUI.

Monitor & Optimized enter Tableau Landscape including server sizing and configurations.

Updated backgrounder query limit Timeout value from default values7200 seconds to 10,000 seconds for the extracts to run that takes more than 2 hours, enable clickjack_defencse setting to true for to open iframes from tableau url`s using tabadmin set Command.

Created/Managed Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.

Monitored server activity/usage statics to identify possible performance issues/enhancements

Environment: Tableau 2018.1/10.3/10.5,SAP Business Objects, Oracle 11g,MS SQL Server 2012, TeraData V13, Mango DB, Google Sheets, SQL Developer 1.5, HP PPM, Windows 2012/2016,REDHAT LINUX 6.7

May - 2017 – Mar - 2018

Smithfield Foods, Lisle, IL

Sr. Tableau/BObj Admin

Responsibilities:

Installed & Configured Tableau 10.2.3 on clustered Environment with Primary & worker nodes on Windows 2012 Servers for High Availability (H.A).

Implemented & Configured Windows AD SSO for Tableau Environment’s.

Worked with Tableau Support for unresolved issues and Software bugs.

Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users in Tableau dashboard development

Created batch script using tableau refresh extract command to upload data from an excel sheet to server and scheduled to run.

Categorized the users such as Viewer, Interactor, Site Administrator and identified their roles and defined Tableau Security model.

Worked on creation of user groups, projects workbooks and the appropriate permission sets for Tableau server logons and security checks.

Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

Design and developed the most suitable user Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Installed Tidal Agent on Tableau Server and tested calling a Batchscript from Tidal to refresh Tableau extract once ETL jobs finishes.

Design, implement and maintained disaster recovery (D.R) strategies and plans including backup plans scripts, recovery procedures.

Facilitated with tech Support to Formulate a Strategy for Implementing Good User support. Worked with firewall team to open ports between Tableau server and Databases, validated ports using telnet command.

Provided technical support to IT management and developers to ensure efficient applications and adherence to standards.

Facilitate with tech Support to Formulate a Strategy for Implementing User support.

Tuned Tableau system at OS Level, Network level & Application Level and optimization for better performance.

Environment: Tableau 10.2.3/10.3, Oracle 11g,MS SQL Server 2012,SAP BW 7.4/SAP ECC, TeraData V13, MS Access 2012, SQL Developer 1.5, Remedy 8.1, Windows 2012

Mar 2011 – May 2017

CATERPILLAR, Peoria, IL

Sr. Tableau /BObj Administrator/ Architect

Installed Tableau 8.1.6 on clustered Environment with Primary & worker nodes on Windows 2008 servers & Tableau 9.2 on Windows 2012 servers.

Upgraded Patch Tableau 9.2 on Windows 2008 Clustered environment & Patch Tableau 10.1 on Windows 2012 servers.

Installed & Configured Tableau 10.1 on AWS Platform for POC.

Extensively used Tabadmin and Tabcmd commands in creating backups, restoring backups of Tableau repository and adding bulk users, refreshing extracts etc.

Implemented and configured SAML SSO for Tableau Environments.

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.

Responsible for creating/Mange Sites, User Groups, Data Connections, Server task schedules.

Involved in publishing of various kinds of live interactive data visualizations dashboards

reports and workbooks from Tableau Desktop to Tableau servers.

Involved in Creating Users Groups Projects Workbooks and assigned Access levels in Server.

Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Involved in creating dashboards and reports in Tableau 8.x/9.x & 10.x, Created report schedules on Tableau server.

Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Performed administrator duties including publishing reports, creating, modifying, or managing server task schedules, monitoring server activity and usage statistics to identify possible performance issues and enhancements.

Drew upon full range of Tableau platform technologies to design and implement proof of Concept solutions and create advanced BI visualizations.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Created dashboard views from provider information data to members

Helped customize Tableau Server with Company Logo.

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol

Maps according to deliverable specifications.

Incorporated a regional and national comparative / benchmark metrics to give context to

Horizon performance

Installed & Configured SAP Business Objects BI 4.2/BI 4.1 with CMS & Audit Data base on RED HAT linux 5.9 64 bit servers and Windows 2008 servers

Applied fixes/service packs for registered bugs and involved in tuning and monitoring the server performance.

Implemented BOBJ Monitoring script using Perl Script and deployed to all BObj Environments

Migrated Windows BObj Platform to Linux Platform by repointing old BObj Windows Platform CMS repository and FRS NAS Storage to New Linux Platform using Cmsdbsetup.sh & Serverconfig.sh

Categorized the user’s such as Power users, Casual Users, Authors and identified their roles and usage with Web Intelligence and crystal reports and applied rights accordingly and handled the user security for supporting various organization views.

Monitor / tuned Business Objects environment based on performance and usage levels.

Used Promotion Management Tool(LCM) to Promote Reports,universes, Publications, Infospaces, eviews from environment to environment

Configured & modified default connection timeout settings for Crystal processing server, Crystal Cache server, Web Intelligence Servers,BI launch Pad, Tomcat .

Tuned Business Objects system at OS Level, Network level & Application Level and optimization for better performance.

Environment: Tableau 8.x/9.x/10.x, Business Objects BI4.2/4.1/XI3.1,Crystal Reports 2013/2011/2008/XI, Xcelsius 2008, Dashboard Designer 4.0, Upgrade Management Tool,,Crystal Enterprise 4.0,SAP Data Services 4.2 Sp5,Tableau 8.x/9.x/10.x, Oracle 11g,MS SQL Server 2005,SAP BW 7.0.8/SAP ECC, TeraData V13, MS Access 2003, SQL Developer 1.5, Tomcat 7/6, Vmware 6.5,Remedy 8.1, RED HAT LINUX 5.9, AWS, Windows 2008/2012

Oct 2010 – Feb 2011

Auto Club of Southern California (AAA), Costa Mesa, CA

Sr. Business Objects Admin

Responsibilities:

Installed & Configured Business Objects XI 3.1 with CMS & Audit Data base on Windows 2003 64 bit servers .

Applied fixes/service packs for registered bugs and involved in tuning and monitoring the server performance.

Configured and Enabled Webdav services on BOXI servers to schedule reports from BOXI to Share point using UNC Path.

Involved in day to day Business Objects Server maintenance.

Installed and Configured the Multi server architecture of Business Objects XI 3.1, which involves high level tasks like clustering, Load Balancing, Disaster Recovery and Security setup.

Defined server statistics & load balancing test across enterprise environment.

Provided production support role with daily hands on support of production activities including system enhancements, break-fix, requirements gathering and end user support.

Installed Schedule Manger on BOXI 3.1 servers for Crystal Reports database configurations.

Developed web services using Query as a Web Service Wizard (Qaaws) and deployed it to the server for developing Xcelsius dashboards.

Monitor / tuned Business Objects environment based on performance and usage levels.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Actively involved in gathering server sizing requirements for software/hardware

Directed and implemented entire BO life cycle for migration and Universe & report development.

Used Import wizard in Prompting / Migrating Reports, universes, users, user groups from Development, to QA to Production.

Defined users and their profiles with appropriate access privileges.

Designed Production System support and handling opened user cases.

Implemented Best Practices for Using Business Objects Suite of Products.

Involved server sizing, load testing & performance testing of Business objects in shared environment. Done performance tuning of the reporting environment.

Used Import wizard in Prompting / Migrating Reports, universes, users, user groups from Development, to QA to Production.

Worked closely with the application users, Windows system administrators and DBAs from analysis through implementation.

Involved in communication of planned upgrades, enhancements and maintenance outage windows in collaboration with the infrastructure teams.

Used Peregrine Ticket Tracking system in resolving user incident, service request tickets and involved in creating RFC`s.

Provided support for hardware, software, and/or network connectivity problems.

Developed the entire Bo infrastructure and did Sizing and Capacity planning.

Used Java Web Application to pull some of the reports using Java SDK for users list, groups list, adding users in bulk & delete users in bulk, password reset application for users self serve.

Involved in enhancements and maintenance activities of the data warehouse including performance tuning.

Facilitate with tech Support to Formulate a Strategy for Implementing good User support.

Validated the application in multiple environments (QA, Stage and Prod) and also was actively involved in mock Go live and Go live activities.

Created Functional requirement document (FRD) and technical specifications for universe and reports.

Provided 24/7 on-call support outside normal business hours as needed.

Designed and delivered end-user training and training materials.

Environment: Business Objects XI 3.1/Xir2,Crystal Reports 2008/XI, Xcelsius 2008, Voyager, Informatica 8.6,Oracle 10g,MS SQL Server 2005, TeraData V2 R6.2, MS Access 2003, SQL Developer 1.5, Vmware 6.5,Peregrine 6.1, Windows 2008/2003.,RED HAT LINUX 5.2

Sep 2008 – Sep 2010

Kaiser Permanente, Pleasanton, CA

Business Objects Admin

Responsibilities:

Involved in day to day Business Objects Server maintenance.

Installed and Configured the Multi server architecture of Business Objects XI 3.1,R2 which involves high level tasks like clustering, Load Balancing, Disaster Recovery and Security setup.

Defined server statistics & load balancing test across enterprise environment.

Installed & Configured Business Objects XI 3.1 on Win 2003 & IBM AIX 5.3 UNIX

Applied patches for Business Objects XI R2 &Business Objects XI 3.1 registered bugs.

Installed fix packs and service packs on DEV, QA and PROD BOBJ server

Migrated BO Universes, Reports and User Profiles from BO 6.5.1/Crystal Reports 10 to Business Objects XI R3.1.

Created/Administered users/user groups/Security in Crystal Server XI CMC

Involved in all phases of migration from Crystal Enterprise 10 to Business Objects XI R2.

Provided production support role with daily hands on support of production activities including system enhancements, break-fix, requirements gathering and end user support.

Facilitated meetings across Departments for implementing a standard Architecture for deploying.

Used Report Conversation tool to convert BO 6.5.1DeskI reports to BO XI R2 WebI reports.

Directed and implemented entire BO life cycle for migration and Universe & report development.

Customized Business Objects Universes for Strategic Planning Scorecard and POC (Proof of Concept) modules.

Actively involved in gathering server sizing requirements for software/hardware

Implemented Row level, Object level security in the universe to make the sensitive data secure.

Created High-level and Detail-level documentation of the project.

Created users and groups in CMC and created user profiles.

Extensively worked on scheduling of the Business Objects reports, configured SMTP, FTP.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Actively involved in gathering server sizing requirements for software/hardware

Directed and implemented entire BO life cycle for migration and Universe & report development.

Extensively used Import Wizard, publishing wizard for Migration of Business Views and reports to PROD, SYS and DEV environments from Crystal 10 to XI version to their respective domains.

Defined users and their profiles with appropriate access privileges.

Designed Production System support and handling opened user cases.

Implemented Best Practices for Using Business Objects Suite of Products.

Designed Test cases for UAT of Reports for end users.

Defined metrics with goals for predictive analysis and set analysis.

Involved server sizing, load testing & performance testing of Business objects in shared environment.

Exported the Universes to the Repository to make resources available to the users.

Provided 24X7 production support.

Environment: Business Objects XI3.1/XIR2/6.5.1, Designer, Web Intelligence, Import Wizard, Crystal Enterprise 10, Informatica 8.1/7.1.3 (Power Mart &Power Center), Erwin 4.1, Oracle 10g, MS-SQL Server 2005, Teradata V12.0, TOAD 6.5, Erwin 4.1, Windows 2003,AIX 5.3, Web Sphere 8

Contact this candidate