We provide IT Staff Augmentation Services!

Sr.tableau Consultant Resume

4.00 Rating

Jersey City, NJ

PROFESSIONAL SUMMARY:

  • 8 + years of total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/ Data Mart Design, BI Solutions, OLAP, Client/Server and Web applications on Window and Unix platforms.
  • Designed, developed, deployed and supported ETL to load data into Data Warehouse from PostgreSQL Server.
  • Developed custom data verification process applied to the raw data, identifying data issues, fixing them wherever possible and/or moving data into error tables for future analysis.
  • 6+ years of experience in Tableau Desktop, Tableau Server, Tableau online.
  • Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
  • End to end experience in designing and deploying data visualizations using Tableau.
  • Expert in gathering external data to Tableau from different sources like Oracle,SQL Server & flat files etc., for data visualization.
  • Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Specialized in creating complex query reports using Oracle, SQL Server, SAP HANA, MS Access, local files, and various RDBMS.
  • Expert in generating on - demand and scheduled reports for business analysis or management decision using Tableau and Power BI.
  • Wrote and executed various MySQL database queries using Python MySQL connector and MySQL DB package.
  • Skilled at building and deploying multi-valued parameterized reports using Power Bi, Tableau.
  • Have good understanding of Tableau architecture, design, development and end user experience.
  • Worked extensively with Advance analysis like Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
  • Was actively involved in the Server migration and the Fresh Tableau Server Installation process.
  • Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
  • Administered user, user groups, and scheduled instances for reports in Tableau by controlling the access of resources to intended user.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Used REST API with Tableau Server to manage and change tableau server resources.
  • Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
  • Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

TECHNICAL SKILLS:

BI Tools: Tableau Suite of Tools 10.1/9.x/8.x/7.x which includes Tableau Desktop, online and Public. TableauServer 10.0/9.3/9.2/8.3, SAP Business Objectives 4.x/3.x. Power BI, Cognos.

Databases: Oracle 11g/10g/9i, MS Sql Server 2008/2005, MS Access, DB2, SAP HANA.

Environment: Windows, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr.Tableau Consultant

Responsibilities:

  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Connected to Tableau PostgreSQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
  • Utilized the Extract API in Tableau 9.3 to create dynamic Tableau data extracts using Python programming.
  • Performed data profiling, data Cleansing and data Analysis using complex SQL on various sources systems including Oracle.
  • Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
  • Maintained and managed Tableau and Power BI driven reports and dashboards.
  • Created few Tableau data extracts using Python programming and Extract API within Tableau 9.3.
  • Implemented code in Python to retrieve and manipulate data.
  • Actively involved in the Server migration and the Fresh TableauServer Installation process.
  • Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableaudesktop.
  • Provided continued maintenance and development of bug fixes for the existing and new Tableau and Power BI Reports.
  • Extensive experience in TableauAdministration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
  • Administered user, user groups, and scheduled instances for reports in Tableauby controlling the access of resources to intended user.
  • Strong Experience in SQL Performance tuning with Code optimization, Indexing, Execution Plan Analysis.
  • Executed and tested required queries and data before publishing Dashboard to Tableau Server.
  • Designed and developed the reports according to the requirements using Tableau and Power Map.
  • Defined best practices for Tableau report development.
  • Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.
  • Extensive experience in Tableau Interactive Dashboards, Tableau suite.
  • Provided support for Tableau developed objects and understand tool administration.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Manage Production, Test, Development environments and security administration and access controls in Tableau.
  • Designed and implemented SSO security model giving access to users from main application to Tableauusing Tableau API calls.
  • Consulted on Tableau server performance enhancements; upgrades from version 9.3 to 10.3 and server reconfiguration based on workbook complexity and data extraction

Environment: Tableau Server 10/9.3, Tableau Desktop 10/9.3, Python, Windows Server Standard R2,SAP HANA Server, Power BI 2013, Excel, SQL Server management studio, MS SQL Server 2008.

Confidential, Tampa, FL

Tableau Server Administrator

Responsibilities:

  • Responsible for Designing the Reports as per client Requirements and translated them to technical specifications.
  • Involved in the migration of content from old Tableau server to new Server.
  • Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.
  • Published and shared views on Tableau server. Scheduled extract refresh and subscriptions.
  • Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
  • Deployed Tableau Dashboards and worksheets in clustered environment using Google Analytics.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
  • Developed working documents to support findings and assign specific tasks.
  • Developed Tableau data visualization using Pareto's, Combo charts, Box and Whisker charts, Geographic Map, Cross tabs, Histograms etc.
  • Developed donut charts for analyzing sales planning data.
  • Created different KPI's using Table calculations and calculated key figures Manipulating's strings, arithmetic calculations, aggregation options and Logical functions

Environment: Tableau Desktop 8.3/7.0.11, Tableau server, SQL developer, SQL Server, Oracle11g/12c, Hive, NoSQL, Microsoft Excel 2012, Microsoft office suite.

Confidential, NJ

Tableau Developer

Responsibilities:

  • Created dashboards for analyzing data using Tableau 8.0.
  • Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
  • Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
  • Created Scatter Plots, Stacked Bars, Box and Whisker plots using, Bullet charts,Heat
  • Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
  • Created Custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
  • Scheduled extract refresh for weekly and monthly reports.
  • Worked on workbook Permissions, Ownerships and User filters.

Environment: Tableau Desktop 7.0.3, SQL Server 2008.

Confidential

SQL Developer

Responsibilities:

  • Managed database objects like stored procedures, views, tables etc.
  • Optimized queries that were taking long time to display desired result set.
  • Created groups, roles, users and assigning access privileges to users.
  • Created new stored procedures and modifying existing ones as per business requirements.
  • Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
  • Performed data analysis to generate various trend reports.
  • Performed identification, analysis and resolved report defects within time scope and established development guidelines.

Environment: SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS).

We'd love your feedback!