SUMMARY

• Business Intelligence Architect with over 15+ years of IT experience in implementing BI solutions for Retail, Banking, Health Care, Design and Security companies.
• 11+ years of experience in Data Visualization, Analytics, Data Management, Data Integration with Tableau, Cloudera Hadoop, Amazon Red Shift, EC2, Impala, Alteryx, Informatica, Sisense and OBIEE 10g/11g.
• Expertise working in Agile methodologies and has a very good knowledge on the process.
• Worked on several Proof of concepts in the career and built optimal solutions to develop Dashboards using data from multiple platforms (SQL Server, Oracle, Amazon Redshift, AWSDynamoDB and Hadoop).
• Good knowledge in RDBMS concepts to the design and creation of database and database schema. Experience writing SQL Queries forDataValidation andDataIntegration.
• Organized numerousJoint Application developments (JAD),Joint Requirement Planning sessions (JRP),Interviews, workshops and Requirement Elicitation sessions with end - user/clients/stake holders, Subject Matter Experts and the technology group.
• Expertise in handling multiple teams with 15 team members who sits in different locations (Onshore, Offshore and near shore) and well Co-ordinated with them.
• Quick learner and Adaptive to the new technologies.
• Architect an Enterprise class Tableau Server capacity planning, designed for performance, scalability, having DR and HA components for 100+ developers and 25k+ interactors.
• Saved over $250k for the organization with right capacity planning. Handled various POCs, published many best practices, how to documents. Acts as checkpoint for Tableau performance both in terms of Tableau Dashboards and Tableau Server.
• Good enriched experience in working as Tableau Architect configuring the Tableau server and maintaining up to 6 worker machines in a distributed environments both in windows, Linux.
• Successfully deployed High available, Fail-Over Enterprise Tableau environments at Autodesk, Confidential and Confidential .
• Responsible for establishing best practices in Tableau server deployment in distributed environments.
• Familiar with Tableau Java Script API/Rest API/Document API.
• Expertise in administering Tableau server versions 2020.x, 2019.X, 2018.x, 10.X,9.X in Linux and Windows environments.
• Successfully Installed, migrated Tableau server from Windows to Linux environment.
• Extensive experience in Installation, configuration, upgradation, creation of sites, projects, groups, users, maintaining security levels, user permissions and administration of Tableau Server in both windows and Linux environments.
• Expertise in data modeling, TSM Commands, Tabadmin, Tabcmd, batch scripts for various requirements including an enterprise level Tableau Desktop license for audit compliance.
• Extensive Experience in working with Tableau technical support, troubleshooting and improving the performance of Tableau server.
• Automated many server admin manual tasks such as restart the server, Backup of logs/data, Tableau workbooks deployment, Extract failure alerts, PDF delivery to the business users, High availability for the Primary tableau server, etc.. using Batch/Shell/Python Scripting.
• Expertise in creating custom server admin views and performance tuning of tableau server, workbooks and tune the server processes/workbooks for better performance.
• Established Tableau Centre of Excellence for best practices and development for Tableau developers.
• Extensive experience in working with Tableau Desktop using Tableau 2020.x, 2019.x, 2018.X,10.x,9.x,8.x and 7.x versions.
• Proficient in Tableau Desktop in design and development of various dashboards, stories and reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and making use of actions, using local and global filters according to the end user requirement.
• Expertise in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots and Histograms.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in the organization
• Successfully integrated Tableau with various applications for e.g., Salesforce, SAP, SharePoint, R, Python and Kerberos.
• Good experience in using published data sources and Data blending techniques.
• Very good experience in integrating R, Python with Tableau. Also, creating the DataSource's using Alteryx.
• Expertise in creating the User level, Data source level, row level security filters for the workbooks, views, dashboards and data sources.
• Publish Tableau best practices, checklists and common testing scenarios to developers.
• Good understanding to use Javascript API’s for developing and maintaining the tableau reports.
• Proficient at usingAlteryxfor Data Blending, Data Cataloging, Data Profiling and In- Database Processing.
• Developed ETL Solutions using Alteryx.
• Participated in the architecture and design of features associated with collaboration and scaling of Alteryx across the business.
• Extracted data from a variety of sources and manipulated the data for dashboards presentation.
• Translated business logic from one system (Oracle, Sql, Excel, etc..) in to Alteryx in a quick and accurate manner.
• Performed elevation of Alteryx workflows to higher environments using SVN as a repository to host the Alteryx workflows, Config files and Macros needed to run the workflow.
• Expertise in gathering the requirements from the business users, coordinating the deliverables end to end with the technical team.
• Expertise in configuring and developing the Analytics/OBIEE Repository (.rpd), which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, Cache Management, Utilities, Subject Areas.
• Expertise in managing and maintaining the Oracle BI Server component, configuration features such as query caching, write backup, usage tracking and aggregate persistence.
• Experience in end to end implementations of BI solutions for implementing Financials, Supply Chain and Order Management, Procurement and Spend Analytics in OBIEE 11g.
• Extensive experience inOBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher and iBots within OBIEE Suite.
• DevelopedDelivers iBots/Schedulerto automate report delivery and provide alerts onInteractive Dashboards in OBIEE.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 2020.x, 2019.X, 2018.x 10.X,9.X,8.X, QlikView, Sisense, OBIEE 11g (Administration, Answers, Interactive Dashboards, Oracle BI Publisher, Briefing Books, BI Delivers, Web Catalog Administration, Analytics Server Administration).

Databases: Oracle, MS SQL Server, DB2, DB2-UDB, MySQL, Teradata, Amazon Redshift, AWSDynamoDB, Hadoop Bigdata, HIVE

ETL Tools: Informatica Power Center 9.x and 8.x, Alteryx, POWER EXCHNGE 9.1 for DB2 Z/OS

Languages: SQL, PL/SQL, COBOL, JCL, DB2, CICS and Micro Focus COBOL, Rest API, R, SAS

Operating System: Windows, Linux, Z/OS, MVS/ESA

Data Modeling Tools: Erwin, Oracle Designer

Other Tools: HPOV for Change Management, HPQC for Defect Tracking, CA-Service Now, TOAD, SQL Assistant, SQL Developer, VSAM, Control-D, IMS-DB, Easytrieve, REXX, File-AID, Test Director, Expeditor, Intertest, Rally, Jira, Jenkins, Confluence, Amazon S3, Amazon EC2, Git-Hub.

PROFESSIONAL EXPERIENCE

Confidential

Tableau Architect/Sr Tableau Admin/Developer

Responsibilities:

• Received appreciations from top level executives(Senior VP level) on my work in fine tuning Tableau server performance and for implementing best practices across the organization to bring the stability to the system.
• Re-visit complete Tableau server environment which consists of 9 different tableau server installations and provide observations, recommendations.
• Formulate DR strategy and implemented it in all 3 Confidential data centers.
• Did capacity planning and Engineer Tableau application system in all the 3 datacenters and optimize it for better performance.
• Done multiple POC’s to migrate, upgrade Tableau server in all 3 Confidential datacenters from 10.5 to 2019.x version and to Linux operating system.
• Plan and setup Tableau Linux dev, UAT and PROD environments from scratch and did the performance comparision testing.
• Implement centre of excellence and best practices, recommendations.
• Used VMware tools, build VM machines from scratch, do the patching, Security scans, install server and configure it.
• Developed multiple custom admin views by connecting to PostgreSQL database to improve the Server performance and tuning it for optimization.
• Involved in performance tuning, Reports tuning, caching, Specifying query thresholds and report optimizations.
• Analyze Tableau server, performance issues and work with stake holders to fine tune the server and optimize it.
• Automate Server backups, logs, restart, deployments, sites migration using Python scripting.
• Work with Tableau professional and Elite support services and resolve the issues related to the product.
• Meeting business Users and multiple stakeholders for requirement gathering to plan and analyze the projects.
• Interact with business users and understand all business requirements and convert them to requirement document, proposing design & effort-estimation as per the requirements.
• Closely working with DWH/ETL Team for getting the required Data to build visualizations.
• Transform the required data using Alteryx tool and create the tde files.
• Creating the workflows using Alteryx and schedule them using task scheduler.
• Developing Tableauvisualizations on Healthcare KPI data usingTableau 2020.x, 2019.x, 2018.x and 10.x versions.
• Prepared best practices and conducted user group meetings to educate users how to develop the dashboards efficiently.
• Built various types of visualizations with Cross tabs, Donut Chart, Stacked Bar, Waterfall, Gantt View, Combo Chart, Scatter Plots, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, etc.
• Expertise in working with data building Hierarchies, Groups, Sets, Bin and worked extensively with Advance analytics like Reference Lines, Bands, and Trend Lines.
• Developed effective and interactive Dashboards using Parameters,TableauCalculations and use of Actions filtering effectively.
• Strong Dashboard design experience and a passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Published Workbooks to appropriate Project and Sites so dat only appropriate teams can view it.
• Manage Stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.
• Document the entire effort, including requirements specifications, best practices, design document, project planning, change history, unit testing documents.

Environment: Tableau Desktop 2020.x, 2019.x, 2018.x,10.4.1, Tableau server 2020.x, 2019.x,2018.x,10.4.1, VMWare VCenter, Alteryx, VMWare Web Sphere, Visual Studio, Hadoop, Jethro, SQL, MySQL, RHEL 7.2.3, Microsoft VSTS, Batch scripting, MS-Office suite, REST API, Javascript API, Document API, EXTRACT API and Python Scripting.

Confidential

Sr Tableau Consultant/Administrator

Responsibilities:

• Responsible for design, development of Landing page, Summary and detail reports using Tableau Desktop/Server with Oracle Datasource.
• Work on the POC’s to halp the team to resolve some of the issues which they were facing.
• Write PostgreSQL queries and develop the Usage report to study on how each user is using the Scorecard reports.
• Implement Column freeze pane concept in Tableau with multi-layer web object concepts.
• Implement Pop-Up feature in Tableau where users can see some of the filters only when they select a particular value in the filter/parameter.
• Work with Sapient, Confidential UI designers and finalized the Design, Colors we should use for the Confidential Scorecard Landing page.
• Worked on a POC to ensure the User security feature in Tableau works for Confidential existing data modelling and submitted the results to the management.
• Help the existing team with all the best practices, standards to follow while developing Tableau reports/dashboards.
• Involved in performance tuning, Reports tuning, caching, Specifying query thresholds and report optimizations.
• Responsible for Administering Tableau server and user management in Tableau server 10.x version.
• Automated Server backups, Server logs, PDF delivery to business users by using a Python script.
• Configured Viz Alerts to trigger email to Production support whenever there is an extract failure.
• Wrote PostgreSQL queries to halp Production support team for identifying whether the extracts ran successfully or not.
• Involved in Upgrade of Tableau Server from one version to another.
• Involved in Tableau Linux beta version testing using 10.5 version.
• Involved in Validating and Testing the server content after each major or minor version upgrades.
• Extensively used Tabadmin and Tabcmd commands and automated some of the tasks like taking logs, backup of the content, Extract failure alert, refresh the extracts, deployment automation.
• Creating/Managing the Projects, Groups, Users, Schedules, tasks and assigning the right permissions to them.
• Worked with Tableau professional services team and identify an optimized architecture for Confidential Tableau environment.
• Worked with Tableau Elite support and resolve the ongoing issue which we faced with server/desktop product related issues.
• Proposed many ideas wherever there is a room for automating Tableau server admin related activities.
• Developed multiple custom admin views by connecting to PostgreSQL database to improve the Server performance and tuning it for optimization.
• Involved in performance tuning, Reports tuning, caching, Specifying query thresholds and report optimizations.

Environment: Tableau Desktop 10.5, 10.0.1, Tableau server 10.5, 10.0.1, Tortoise SVN, Oracle, Jira for features/epics tracking, Linux, Batch scripting, MS-Office suite, REST API, Document API and Python Scripting.