PROFESSIONAL SUMMARY:

• Tableau Solution Consultant with 10+ years of professional experience in Business Intelligence Tools and Database Design in Information technology with skills in all phases of Data Warehouse lifecycle developments, Client/Server Applications and Internet Applications.
• Solid experience in development, installation, administration, migration, configuration, technical support, troubleshooting, maintenance and overall health of the Tableau implementations.
• Experienced with Create/Manage Groups, Users, Workbooks and Projects, Database Views, Data Sources and Data Connections in Tableau.
• Experienced in Add/Edit Sites and corresponding administration rights (System vs. Content)
• Experienced with Tableau backup and restore.
• Experience with reading through Tableau logs to work through problems finding root causes and rectifying.
• Experienced with alternative authentication providers such as Active Directory.
• Respond to and resolve tickets on technical issues related to Tableau Platform within defined SLAs.
• Co - ordinate with Tableau Support for any unresolved issues and tool specific issues or hot fixes/patches.
• Experience with reading through Tableau logs to work through problems finding root causes and rectifying.
• Installation, Upgrade, maintenance and support of all Tableau components.
• Experience in implementing patches including both minor and major upgrades to ensure the Tableau have constant uptime and proper tuning.
• Experienced in troubleshooting performance issues, capacity planning and load balancing both scheduled and ad-hoc reports.
• Expertise in configuring, administering, managing, maintenance all upgrades and support of the Business Objects BI 4.2/4.1/XI 3.1/XI R2,Crystal Reports 2013/2008, SAP Data Services 4.2 and in migrating the Business objects from 5.1.x/6.1.5/6.5,Crystal Reports 10/9 to Business Objects XI R2/R3, BO 4.x.
• Extensive experience in designing, implementing, and managing Business Objects user security in a large enterprise data warehouse environment.
• Experience in end-user community, responding to help desk calls and trouble tickets, working with vendors to resolve HW and SW problems.
• Extensive experience in creating BOBJ SDKs for User Extraction, CMS Data Extraction.
• Experience in identification of Business and Data requirements and converting them into conceptual and data models using Erwin, Oracle Designer, MS Visio etc.
• Extensive database experience using Oracle (11g, 10g, 9i & 8.x), MS SQL Server 2000/2005, DB2, Teradata and MS Access.
• Detailed understanding and experience with Data Transformation / ETL processes, JBDC and ODBC.
• Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau 8.x/9.x/10.x, Business Objects BI 4.1/4.0/ XI 3.1/R2/6.5/5.7

ETL: SAP Data Services 4.2, Informatica 8.6/7.1/6.2 (Power Mart &Power Center), Data Integrator XI/11.5

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2012/2005/2000 , Teradata V14/13/12, DB2 V9/10.5, MS-Access, My SQL 5.5

Languages: PL/SQL, T-SQL, VB Script, HTML, XML, Unix Shell Scripting

OS: Windows 8/7/2012/2008 , Redhat Linux 6/5.11, IBM AIX 5.1/5.3, Sun Solaris 8/9

Servers: TOMCAT 7/6/5.5, Web Logic Application Server 9.x,Web Sphere 8.0/6.1/5.0,IIS

Tools: Erwin 4.1/3.5,TOAD 6.5,SQL Navigator 4.1, SQL Developer, Load Runner 7.5/9.0

WORK EXPERIENCE:

Confidential, Lisle, IL

Sr. Tableau Architect/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.
• 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.
• Increased Java Heap Size using Tabadmin set command from 128m to 256m for to increase load on number of user’s login.
• 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 to monitor tableau performance, user logins etc.
• Used tabcmd add users command to import users in bulk to tableau server.
• Restored Tableau server from a backup when user requested for a deleted workbook.
• Created/Managed Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.
• 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 a excel sheet to server and scheduled to run.
• Monitor & Optimized enter Tableau Landscape including server sizing and configurations.
• 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.
• 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.
• 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 good 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 2005,SAP BW 7.4/SAP ECC, TeraData V13, MS Access 2003, SQL Developer 1.5, Remedy 8.1, Windows 2012

Confidential, Peoria, IL

Sr. Tableau Admin /BObj Administrator

Responsibilities:

• 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 Microsoft Azure cloud 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
• 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

Confidential, 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

Confidential, Pleasanton, CA

Business Systems Analyst (BO 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