
Subukt Shaikh
- Sr. Tableau BI Developer
- Montvale, NJ
- Member Since May 26, 2023
Subukt Shaikh
SUMMARY
· 9 + years of extensive IT Experience as a Tableau Developer and Business Intelligence applications in Retail, Banking, Financial and Healthcare industries.
· Around 6+ years of experience on Tableau.
· Extensive experience in working with Tableau Desktop, Tableau Server, and Tableau in various versions of Tableau 10.x,9.x/8.x/7.x
· Expertise in Tableau 10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0, Tableau Server, Tableau cloud, Tableau Online, Tableau Public, Tableau Reader, Tableau mobile.
· Worked on beta version of 10.4.
· Consulted on Tableau server performance enhancements; upgrades from version 9.0 to 10.3, 10.4 and server reconfiguration based on workbook complexity and data extraction.
· Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
· Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups & Conflict Management with Project team members.
· In depth understanding of the As-Is and To-Be business processes and experience in converting business requirements into Technical Specifications for preparing Test Plans.
· Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
· Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
· Held responsibility in participating daily activities like building workbooks, dashboard, published on server
· Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
· Created actions, customized Relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, Drill down analysis and in-memory in tableau.
· Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
· Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
· Performed auto-incremental refresh tasks for extracts of data on Tableau Online sync application and to maintain local network
· Expertise in web integration of Tableau Reports with HTML or Asp.Net.
· Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
· Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations.
· Good usage of Tableau JavaScript API for performance improvement of web page.
· Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
· Built Operational Dashboards strictly focused on tracking operational and financial performance
· Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
· Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
· Excellent experience in designing, developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using SQL and Oracle.
· Experience in development of user defined reports to provide on demand data analysis using excel, and created charts and pivot tables in Excel.
· Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan.
· Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
· Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
· Held responsibility in Setting up security profiles for various user groups and users using Tab admin and Tabcmd Tools.
· Performed Tableau server REST API to manage and handle Tableau server resources
· Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
· Published Workbooks and Dashboards to the Tableau server with appropriate access to teams
· Excellent communication and interpersonal skills. Ability to work effectively as a team member.
TECHNICAL SKILLS
|
Tableau |
Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau mobile, Tableau 10.2/10.1/10.0/9.3/9.1/8.0/8.1/7/6, |
|
Reporting Package |
MSBI(SSIS, SSAS, SSRS, Performance Point, Business Objects, Crystal Reports |
|
Data Modeling |
Erwin, Visio, IBM Rational Rose UML |
|
Computer Application |
MS-Word, MS-Excel, MS-Access, MS- Power Point |
|
Databases |
Oracle, SQL Server, DB2, Teradata, MySQL, Hadoop Hive, XML,AWS-RedShift,EC2, RDS, S3 |
|
Operating Systems |
Windows, Linux |
|
Languages |
SQL, PL/SQL, T-SQL, Transact SQL, Core Java, R Programming, C, PHP |
PROFESSIONAL EXPERIENCE
Sr.Tableau BI Developer
AT&T - Montvale, NJ July 2016 to Present
This project consisted to retrieve some sensitive data, perform many queries manipulation, create reports and perform auditing services before inputting the data in the data warehouse for further analysis.
Roles & Responsibilities:
· Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting Tableau applications.
· Involved in full project lifecycle of SDLC and coordinated with all project teams.
· Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.4/10.3/10.2/10.1/9.3/9.2).
· Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards.
· Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
· Analyzed requirements for various reports, dashboards, and scorecards and created the same using Tableau desktop server.
· Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau.
· Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
· Experience in creating and scheduling Tableau data extracts for auto refresh.
· Mentored business power users to create reports/dashboards using tableau desktop.
· Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
· Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
· Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
· Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
· Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.
· Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
· Scheduled frequency and time to refresh data, when sources are publishes or extracted to server.
· Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
· Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
· Oversee the performance of Design to develop technical solutions from Analysis documents.
· Provided post implementation production support.
· Designing and building the structure of dashboards, and suggested how to present the data, why and find opportunity to get attention to a chart.
· Positively influence others to achieve results that are in best interest of both internal/external stakeholders.
· Creating Dashboards according to the project functional requirements.
· Extracted information from different data sources like Oracle, SQL Server, MS Access and flat files, etc. by using different scripts like add, concatenate, Joins.
· Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
· Customized and tweaked the scripts for cross-tables and generic loads, and created simple and complex expressions.
· Tuning data loads Tableau application for efficient performance.
· Involved in Production support and maintenance phase.
Environment: Tableau (Desktop, Server) 10.1, SQL Server 2012 and Microsoft Office, MS VISO 2013, Profiler, Visual Source Safe, MS BizTalk Server, Microsoft Office (Word, Access, Excel, Outlook).
Tableau Developer
BCBS of Tennessee Nashville, TN December 2014 to June 2016
Roles & Responsibilities:
· Proactively communicated with the business users to understand the needs and develop requirement documentation.
· Involved in requirements gathering, analysis, and functional specification documents.
· Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
· Created Users, Groups and projects in Tableau environment.
· Created and managed schedules for users.
· Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the updated data.
· Created different views using Tableau Desktop which were published to the business stake holders for analysis and customization using filters and actions.
· Created different charts showing KPI by Color that were broken into regions allowing business user to understand which stores are the outperformers in different categories.
· Developed various data connections from data source to Tableau Server for report and dashboard development.
· Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
· Developed actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau.
· Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
· Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
· Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
· Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
· Built Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts with easy utilization of show me functionality.
· Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
· Performed Reference lines, Trend Lines, Statistics concepts. Groups, Sets, hierarchies to create detail level summary report and Dashboard using KPI's.
· Articulated best practices for Tableau report development and efficiently used data blending in tableau
· Configured Cache settings which improved the performance of the reports and Dashboards.
· Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
· Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
· Achieved performance tuning by implementing Caching, Aggregate tables and creating indexes on tables.
· Involved in preparing material and training Business users.
Environment: Tableau 8.x Desktop, Tableau server, SQL Server 2008R2, Informatica 8.x, SQL, T-SQL, Agile.
Tableau Developer CAREMARK, Lincolnshire, IL August 2013 to Nov 2014
Roles & Responsibilities:
· Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MS Visio 2013.
· Involved in integrating different Database Applications using SSIS packages.
· Created SSIS packages that involves migration from legacy systems to centralized Database.
· Designed and tested packages to extract, transform and load data (ETL) using SSIS.
· Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, for each Loop Container.
· Used work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications
· Validate data before performing ETL transformations and load into SQL server database.
· Worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS 2012.
· Designed and developed various analytical reports from multiple data sources by blending data from various sources on workbooks in Tableau Desktop and Power BI.
· Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
· Developed various reports using best practices and different visualizations such as Tornado Charts, Donut Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
· Created users, groups, projects, data connections, setting as a Tableau Administrator.
· Used LOD (Level of Details) functions like fixed, Include and Exclude in Tableau.
· Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
· Created and scheduled Tableau data extracts for auto refresh.
· Designed various Analytical Reports and Automated Dashboards to help users to identify critical KPI's and facilitates strategic planning in the organization.
· Designed and created Report templates, bar graphs and pie charts based on the inspection data.
· Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS2014/2012/2008, Microsoft Office, MS VISO 2013, Profiler, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server, Microsoft Office (Word, Access, Excel, Outlook).
Tableau Developer/Admin Wells Fargo - Los Angeles, CA June 2012 to July 2013
Roles & Responsibilities:
· Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
· Mentored business power users to create reports/dashboards using tableau desktop.
· Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau Desktop.
· Utilized advance features of tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
· Involved in new KPI generation for Scorecards.
· Data collection and leveraging on data manipulation teams for required data.
· Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
· Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
· Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
· Effectively used data blending, quick filters, actions, hierarchies' features in tableau.
· Executed and tested required queries and reports before publishing.
· Converted Metric insight reports to tableau reports.
· Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
· Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
Environment: Tableau Desktop 5.0/6.0/7.0, Tableau Server, SQL Server 2008/2012, Info view, Windows 2008 Server
Senior SQL BI Developer (SSIS/SSRS/SSAS) Crowley Maritime, Jacksonville, FL September 2011 to May 2012
Roles & Responsibilities: