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 have a very good knowledge on teh process.
• Worked on several Proof of concepts in teh 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 teh 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 teh 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 teh 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 teh 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 teh 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 teh performance of Tableau server.
• Automated many server admin manual tasks such as restart teh server, Backup of logs/data, Tableau workbooks deployment, Extract failure alerts, PDF delivery to teh business users, High availability for teh 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 teh 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 teh 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 teh 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 teh DataSource's using Alteryx.
• Expertise in creating teh User level, Data source level, row level security filters for teh 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 teh tableau reports.
• Proficient at usingAlteryxfor Data Blending, Data Cataloging, Data Profiling and In- Database Processing.
• Developed ETL Solutions using Alteryx.
• Participated in teh architecture and design of features associated with collaboration and scaling of Alteryx across teh business.
• Extracted data from a variety of sources and manipulated teh 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 teh Alteryx workflows, Config files and Macros needed to run teh workflow.
• Expertise in gathering teh requirements from teh business users, coordinating teh deliverables end to end with teh technical team.
• Expertise in configuring and developing teh Analytics/OBIEE Repository (.rpd), which involves Schema Import, Implementing teh 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 teh 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 teh organization to bring teh stability to teh 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 teh 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 teh performance comparision testing.
• Implement centre of excellence and best practices, recommendations.
• Used VMware tools, build VM machines from scratch, do teh patching, Security scans, install server and configure it.
• Developed multiple custom admin views by connecting to PostgreSQL database to improve teh 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 teh 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 teh issues related to teh product.
• Meeting business Users and multiple stakeholders for requirement gathering to plan and analyze teh projects.
• Interact with business users and understand all business requirements and convert them to requirement document, proposing design & effort-estimation as per teh requirements.
• Closely working with DWH/ETL Team for getting teh required Data to build visualizations.
• Transform teh required data using Alteryx tool and create teh tde files.
• Creating teh 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 teh 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 that only appropriate teams can view it.
• Manage Stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.
• Document teh 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 teh POC’s to halp teh team to resolve some of teh issues which they were facing.
• Write PostgreSQL queries and develop teh Usage report to study on how each user is using teh 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 teh filters only when they select a particular value in teh filter/parameter.
• Work with Sapient, Confidential UI designers and finalized teh Design, Colors we should use for teh Confidential Scorecard Landing page.
• Worked on a POC to ensure teh User security feature in Tableau works for Confidential existing data modelling and submitted teh results to teh management.
• Help teh existing team with all teh 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 their is an extract failure.
• Wrote PostgreSQL queries to halp Production support team for identifying whether teh 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 teh server content after each major or minor version upgrades.
• Extensively used Tabadmin and Tabcmd commands and automated some of teh tasks like taking logs, backup of teh content, Extract failure alert, refresh teh extracts, deployment automation.
• Creating/Managing teh Projects, Groups, Users, Schedules, tasks and assigning teh 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 teh ongoing issue which we faced with server/desktop product related issues.
• Proposed many ideas wherever their is a room for automating Tableau server admin related activities.
• Developed multiple custom admin views by connecting to PostgreSQL database to improve teh 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.