SUMMARY:

• Qualified IT professional with over 13 years of experience in managing Tableau / Tableau / ETL / BI projects across diverse roles in the organizational hierarchy. I seek a position where I can be active with new technologies that will utilize my experience and effectively blend personal goals with organizational objectives while providing professional solutions to my business partners by demonstrating a high degree of integrity and drive.
• Over 14 Years of experience in the field of IT with an emphasis on Business Intelligence concepts & Implementations like Data Reporting, Data Modelling, Analysis, Mining, Design, Development, Data Migration, and Testing of Database/ Data Warehousing/Client/ Server/ Legacy applications.
• Over 6 years of experience with emphasis on Business Intelligence Tools such as Tableau 2018.2/2018.1/10. 5/10.3/10.1/9.3/9.1/8.1 , Looker
• Over 14 years of experience on entire Business Objects suite including Business Objects XI R4.2/4.1/R3/R2/R1,6.5.x, 6.0, 6.1.x,5.1 Architecture, Design, migrations/Upgrades, Installations, Deployments, Development on Windows & Linux.
• Involved in Installation / configuration / customization / deployment ofTableauSoftware.
• Expertise with Tableau installation/configuration/scaling/sizing in Amazon EC2
• Extensive Tableau Experience in Enterprise Environment as a Tableau Architect /Administrator / Developer / Business Analyst
• Involved in Installation and configuration ofTableauSoftware.
• Implemented permission rules to control access to specific content on a site
• Experience in Migrating Tableau from older version to 10.x/2018.x versions
• Installation of Tableau on RedShift, Cloud data platforms, Hadoop and AWS.
• Experience inTableauAdministration for configuration, adding users, managing licenses, and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Deployment of Tableau Server in clustered environment and performing upgrades
• Connected to Hadoop systems using Tableau to leverage the power of Hadoop combined with fast tableau data engine for speed processing.
• Experience in setting up different authentication modes SAML/SSL in Tableau server.
• Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting
• Experience with Tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects
• Experience in connecting to Cloud from Tableau Server
• End to end experience in designing and deploying data visualizations usingTableau.
• Familiar and involved in working with Redshift OLAP & Aurora OLTP
• Expertise in Data Analysis, Data Extraction, Data Marts. Performed Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups ofTableaurepository & for managing extracts
• Integrated Tableau visualizations to external portals
• Created Tableau Automated Scripts for Synchronizing groups and Server backup
• Experienced with reporting tools, software, and other applications, including SQL Database & Looker
• Extensive knowledge in importing data for use in reporting software (Tableau&Looker) graphs, and flowcharts
• Implemented row level security for thetableaudashboards and used various advanced table calculations for the dashboards
• Configured backup primary, passive repository in the TABLEAU Server
• Load test critical reports before release using TABJOLT
• Worked extensively withTableausupport for several product issues
• Worked on data blending and increased the dashboard performance by extracting data.
• Experience in Performing R analysis for statistical analysis
• Implemented Python integration with Tableau and did Statistical analysis
• Integrated Tableau Visualizations with External Portals using Java API
• Created extracts, published data sources totableauserver, refreshed extract inTableauserver fromTableauDesktop.
• Involved in Tableau Administration and Development of Visualizations
• Skilled in setting up the Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts;
• Adroit in working on Client/ Server/ Legacy applications, writing, testing, and implementation of the triggers, stored procedures, views, cursors, packages, functions at Database level and form level using PL/SQL
• Highly organized, disciplined and task focused with fine - tuned analytical, troubleshooting and administrative skills.
• Personality traits include decision making ability and capacity to deliver under pressure
• Worked with onsite/offshore teams to get the projects to completion as a single point of contact.

EXPERTISE IN:

• SAP Business Objects/Tableau SDLC
• Tableau/BO server sizing & Scaling
• Tableau/BO Design & Architecture
• Tableau/BO Admin & Deployment
• Tableau/BO Security Expert
• Tableau deployment on RedShift, Hadoop and Cloud data platforms
• Tableau/BO Migrations & Upgrades
• Tableau Implementation in Cloud/AWS
• Analyze Tableau Server Repository (PostgreSQL Database)
• Expertise in Tableau Metadata
• Familiarity with Tableau API in JS
• Tableau/BO POC/Prototype
• Tableau/BO Solution Pre - sales Demo
• Integration with third party software
• Onsite & Offshore co-ordination
• Experience connecting to R from Tableau for statistical analysis
• Exposure to Hadoop Systems & Tableau connectivity to Hadoop
• Part of BI Center of Excellence team
• Universe, Reports/Dashboard Design
• WEBI, Crystal Reports Development
• Tableau Dashboards & Visualizations
• Create Assessment/Analysis documents
• Manage BI projects with multiple project teams for project completion
• Work with Tableau/SAP supports on critical issues
• Align with Business objectives with the BI capabilities
• Part of BI advisory board
• Fit Gap analysis
• Root Cause Analysis & resolution
• Requirement Gathering & Analysis
• SLA Compliance
• Data Warehousing
• Strategy Formulation
• Troubleshooting & Issue Resolution
• Risk Assessment & Mitigation
• Client Interaction
• Cross Functional Team Coordination
• Process Improvement
• Reporting & Documentation
• Root Cause Analysis
• Multi domain experience in BI

IT FORTE:

Operating Systems: Windows NT/2000/2003,2008,2012,2016, Unix / Linux

BI Tools: Tableau 2018.2/2018.1/10. x/9.x/8.x Server/ Desktop, SAP Business Objects (R4.x/R3/R2/R1,6.5,5.x); UDT/IDT; Upgrade Management Tool (UMT), Import Wizard, Crystal Reports (2008, XI R3, R2, 10); SAP BW 7.3, SAP HANA Infoburst, System Profiler, Erwin

ETL Tools & Data Warehousing: Informatica (9.6, 9.1, 8, 7.1.3, 6.2); Business Objects Data services 4.2.x, DataStage 7.0, SSIS; Star-Schema/Snowflake Modeling, FACT, Dimension Tables

RDBMS Technologies: ORACLE (8i, 9i, 10g, 11g); SQL Server (2000, 2005, 2008), Teradata 13.10

Web Application servers: Websphere (6,7) Tomcat, IIS, Apache, WebLogic

Other software: Remedy Suite, Knowledge Management, MS Excel, Java, C++

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

Sr. Tableau & Business Objects Architect/ Administrator

Technology Used: Tableau 2018.x / 10.x, Teradata 11, Oracle 11, SQL Server

Responsibilities:

• Designed the architecture for scalability / load balancing with high availability
• Involved in sizing / installation / configuration / upgrades / support of Tableau servers
• Worked with other system architects to troubleshoot and tune tableau server performance issues for the heavy loads of peak data usage situations.
• Worked as a go-to person in creating the dashboards / visualizations by interacting with the business users.
• Installed and deployed the Tableau distributed services on AWS Cloud and Linux platforms.
• Troubleshooted the production tableau servers issues on amazon EC2 & Linux OS.
• Involved in setting up the tableau security by creating various groups in the tableau platform
• Scaled up the environment whenever there is more demand for a greater number of cores on the server and memory to speed up the tableau performance.
• Installed / configured Tableau on Tableau with RedShift, Hadoop and Cloud data platforms
• Worked with DBA's to create the backend Datamarts / summarized tables to improve the tableau response times
• Involved in integrating tableau with R to create the visualizations.
• Greatly enhanced the overall productivity if business users by leading Adhoc services team which supports the self-serve business teams by being the go-to person for tableau, data redundancy, high level analytics, Teradata query optimization, performance turning.
• Achieved the reduction of maintenance cost by optimizing the existing environments by developing usage dashboards for business and IT leadership in tableau which provided them insight into the usage patterns of application by the Analysts/user.
• Partnered with the infrastructure team (DBA / Windows team) and projected the growth forecast of the tableau server by analyzing the usage, CPU utilizations patterns and developed multiple tableau applications with advanced visualizations.
• Led a team of multiple developers and contractors for multiple projects and played a major role in collaborating with different teams and helped delivery of projects on time and on budget.
• Upgraded the Tableau environment from 9.3 -> 10.3->10.5.1
• Installed Tableau in Multi-node and Enterprise Deployments
• ConnectedTableauDesktop with SQL to extract data from stored procedures and custom SQL to plan refresh timings and publish totableauserver
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups ofTableaurepository.
• Worked extensively with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Worked extensively withTableauAdministration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views.
• Implemented the Proactive Tableau Environment Health Checks and Performance Threshold Alerting using third party tools Interworks and inbuilt TabMon tool
• Implemented SSO/SSL/SAML on QA and Prod & Ugraded ofTableauserver 9.3 -> 10.0
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks fromTableauDesktop toTableauservers.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance.

Confidential, FAIRFAX VA

Sr. Tableau & Business Objects Architect / Admin

Technology used: Tableau 10.x / Tableau 9.3, Oracle

Responsibilities:

• Configured/added users, managed licenses and data connections, scheduled tasks, embedded views by integrating with other platforms in Tableau.
• Experienced with reporting tools, software, and other applications, including SQL Database,Looker and Tableau
• Extensive knowledge in importing data for use in reporting software (Tableau&Looker) graphs, and flowcharts.
• Setup the Cluster environment in Prodin Tableau & Business Objects
• Installed Tableau on Cloud/AWS for enterprise wide deployments.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets usingTableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyse data in different perspectives.
• Defined and created procedures to installTableaudesktop and server.
• Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting
• Tableau User Group and User Entitlement Administration
• Experience with Tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects
• UsingTableauDesktop created Interactive-reporting dashboards by combining multiple views.
• Developing predictive statistical models using statistical analysis and other predictive modelling techniques.
• Created Workbooks and dashboards for analysing statistical billing data usingTableau.
• Performed statistical analysis using third party method R
• Developed wrapper inPythonfor instantiating multi-threaded application.
• Integrated Tableau with JAVA-API and Interacted with Dashboard with HTML web page and captured action
• Designed and deployed reports with Drill Down and Drop-down menu option and Parameterized and Linked reports using Tableau.
• Experience publishing dashboards and data sources to Tableau Server as well as managing access, user security, refreshing of Tableau extracts
• Optimized Tableau dashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Employed various Tableau Functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Trends, Hierarchies, Sets, groups, Calculations, Data Blending and Maps etc.
• Built Pilot project and demonstrated to business users on the capabilities of Tableau Visualizations.

Confidential, Minneapolis

Sr. Tableau / Business Objects Architect / Administrator

Technology used: Tableau 9.1 / 8.0, SAP Business Objects 3.x, Oracle 11g

Responsibilities:

• Collaborated with self-service BI teams and identified the inconsistencies with their reporting solutions against the enterprise patterns and provided consulting services in redesigning the existing solutions and built the frame work for future solutions.
• Involved in design, development, testing & maintenance of Tableau functional reports based on user requirements. Converted existing BO 4.x reports into tableau dashboards.
• UpgradedTableauserver from 8.0 to 9.1 in DEV and QA along with Migration of reports.
• Setup the sites and roles in Tableau
• PerformTableauServeradminduties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Involved in license management SLA's withTableausupport.
• Defined and created procedures to installTableaudesktop in silent mode.
• Installed Tableau’s TabCmd Utility to publish workbooks.
• Experience in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet inTableauDesktop.
• Used advance features ofTableausoftware like, link data from various sources, merged on one dashboard and to filter data in multiple views at once.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/ dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms, stories; donut charts for analyzing sales planning data.

Confidential, Chicago

Sr. Tableau Architect / Administrator

Technology used: Tableau 9.1/8.0, SAP BO 4.1 SP6, Oracle 11g, Informatica

Responsibilities:

• Developed data visualizations using Data Blending Feature and by joining multiple tables in Tableau as well as consolidating data from multiple sources of data.
• Extracted data from various sources like SQL Server, data files, Oracle by the use of data blending & joins in Tableau.
• Added users/groups from Active Directory; and scheduled instances inTableauServer including weekly data dump.
• Involved in license management SLA's withTableausupport.
• Created Server Backups and scheduled the Jobs
• Created multiple sites depending upon business needs
• Implemented/maintained and scheduling ofTableauData extracts usingTableauserver & TableauCommand utility
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Used Filters Shelf for filtering data within dimensions, facts and used it in sets of data.
• Implemented row level, column level and table level calculations intableaureports and dash boards.
• Published customized interactive reports and dashboards toTableauserver.

Confidential, Fort Lauderdale

Sr. Tableau Architect /Administrator

Technology used: Tableau 9.1, SAP BO 4.1 SP5, Oracle, SQL server, Toad

Responsibilities:

• Developed & implemented Tableau reports utilizing complex calculated fields, table calculations, filters, parameters including Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Worked on gathering Business Requirements and prepared Functional Design & Technical Design Documents.
• Developed Dashboards, Complex and business Critical reports for Sales, Inventory, Pricing, and Accounting Teams using Business Objects andTableautools.
• Created Complex Prompts in the Framework manager using Macros with the help of Parameter Maps.

Confidential, Chicago

Sr. Tableau / Business Objects Architect / Administrator

Technology used: Tableau 9.1, SAP BO 4.1 SP3, Oracle, Teradata

Responsibilities:

• Helped the client migrate reports to legacy databases to Tableau dashboards pointing to Oracle database
• Created tableau visualizations for easy decision making by the client
• Designed the architecture / solution for tableau load balancer
• Converted the SAP Business objects reports into Tableau for better performance.