SUMMARY

• Software Professional wif a Total 11+ years of Experience in teh IT industry and Extensive Experience in Analysis, Coding, Development, Implementation, Operations and Maintenance of Business Intelligence Technologies (BI) solutions for various Business and Customer Applications.
• Experience in Full System Development Lifecycle and Data Visualization (Tableau Desktop, Tableau Public, Tableau Online and Table Server 8.X\9.X\10.X\2019.2\2020\2021) for Business Intelligence and Expertise in setup and configuration of platform for application hosting, maintenance etc.
• Administer and supervise all Tableau servers, which include Installation and Configuration, Scalability of servers, creation and maintenance of users, user groups, roles, assigning security on projects/sites, automate background tasks and maintaining teh servers.
• Expert in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Histogram charts, Box and whisker Plot, Geographic Visualization and other making use of actions, other local and global filters according to teh end user requirement.
• Actively Involved in creating Confidential Custom portal design hosting Tableau workbooks using JavaScript API.
• Created technical Specification documents related to Tableau design and architecture.
• Created several Tableau data extracts wif prebuilt calculations, parameters and sets to enable end users to easily utilize teh extracts as semantic layer to create their own workbooks.
• Expert in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in teh organization.
• Experience on Tableau Desktop\Public and Tableau Server and Created teh Dashboard reports and Story by using Tableau Desktop and Published into Tableau Server for Web Users.
• Interacting wif Business users, Stake holder to understand their Business requirement and created teh Business and Technical Specification Documents according to teh Business needs.
• Design rich Graphic visualizations wif modular design of reports, worksheets, and views in Tableau wif a strong understanding of teh appropriate chart types (Bar Charts, Line Charts, Scatter Plot, Tree Map and Heat Maps) to use to highlight patterns in teh data.
• Expert in designing Tableau Reports, Dashboards and Stories wif Custom SQL queries and connecting multiples data sources like… (SQL, Oracle, Hadoop, AWS, Excel, and Flat files).
• Leverage advanced Tableau functionality (parameters, actions, tooltip modifications, API, etc.) to create meaningful and industry appropriate analytical dashboards
• Extensive knowledge in various reporting objects like Facts, Dimensions, Attributes, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Extensively worked on Tableau Reports performance by optimizing teh logics for calculated columns, avoiding teh nested ELSEIF statements and using of Boolean Calculations wif alias
• Utilized multiple visualizations, calculated columns, summations, and pivoted tables to demonstrate value of opportunities
• Successfully Implemented teh Data Blending in teh Tableau to integrate teh two different source systems to get teh combined data for teh analytic reporting
• Extensively worked on Production Support and resolved teh production issues wifin teh SLA and provide teh root cause analysis for teh respective team to fix teh issues in Tableau code or Data issues.
• Created teh custom SQL queries in Tableau to delegate teh query into teh database to improve teh report performance
• Worked on Tableau\Cognos Code deployment from Dev to Test, PT and Prod environments
• Created teh Base views and Derived Views from teh heterogeneous databases like SQL, Oracle, Netezza and Greenplum
• Create teh new Interfaces environments to do more testing before to QA and Prod Environments
• Experience in development of dashboards using external data and collaboration using API and python scripts.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau Server and Reports
• Excellent skills in understanding business needs and converting them into technical solutions.
• Good understanding of Data Mart Architecture, Relational data modeling and dimension modeling by using Star Schema and Snow-Flake Schema.
• Involved in teh POC (Proof of Concept) to Users requirement and given presentations to teh user for developing Ad-hoc reporting for their regiments
• Experience on Report Studio, Query Studio, Analysis Studio, Metric Studio and Cognos administration
• Implementation of Cognos up-gradation from 8.1 to 8.4. Migrated various BI reports, models and cubes from Cognos BI 8.1 to Cognos BI 8.4.
• Identified and created various user groups and roles. Provided access privileges based on their roles and responsibilities.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop 8.X/9.X/10.X/2019.2,2020.1,2021.1, Tableau Public, Tableau Server, Tableau Reader, Cognos10.X, Cognos 8.X and Spotfire 6.X/8.X

Programming: SQL, Oracle, Hadoop Hive, Teradata SQL

Databases: Oracle 10g, MySQL 5.0and SQL Server 2005/2008/2012.

Operating Systems: Windows and Linux Operating Systems

Scripting languages: R, Python

PROFESSIONAL EXPERIENCE

Senior Tableau Developer\Data Analyst

Confidential, New York

Environment: Tableau Desktop\Tableau Server 2021.1/2019.2/10.4 , Tableau Prep, Tableau Public, Tableau Reader, Tableau Server, Oracle 11g, SQL Server and Hadoop Hive.

Responsibilities:

• Interact wif client to understand their business and reporting needs, including teh identification of critical metrics and KPIs
• Understanding teh Data modeling design in Tableau Reporting as per teh business requirement and built teh restful model for business and optimized teh query performance to keep Tableau environment agility and Keeping teh environment more active to downstream applications (Tableau\Web Applications)
• Administer and supervise all Tableau servers, which include Installation and Configuration, Scalability of servers, creation and maintenance of users, user groups, roles, assigning security on projects/sites, automate background tasks and maintaining teh servers.
• Extensively worked on creating sites, managing space for teh project site, creating projects under teh site and adding\modifying teh AD groups according to teh project team requirement.
• Worked on Tableau server permission for AD groups based on teh requirement.
• Created technical Specification documents related to Tableau design and architecture.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created responsive workbooks for Ipad/PC orientation views.
• Implemented teh Dual axis, Discrete, Continues, Measure Names, Measure Values, Context filter, relevant values, Sets, Group, Rank, Parameters, Exclude and Left functionalities according to teh business needs
• Created teh Tree Map and Heat Map to represent teh hierarchical data and compare categories using color and size
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created teh Rich Dashboard Reports wif required worksheets and published teh dashboard and worksheet into Tableau Server for teh Business users.
• Handle teh null values, special values, and negative values in line chart reports.
• Experience in migrating client’s reports from excel (static) based solution to an interactive service.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Implemented teh LOD (level of detailed calculation) wif Include, Exclude and Fixed as per teh requirement.
• Groups, hierarchies, sets to create detail level summary report and dashboard using KPIs
• Created teh published datasources and published into teh server and extracted data on daily basis to improve teh performance of teh dashboards
• Extensively worked on performance of teh report by optimizing teh tables\views and removing teh unnecessary calculated columns, filter, and parameters.
• Extensively worked on POC for Tableau username function to know, how tableau is sending user name function when we use custom SQL, Data model and in different scenarios.
• Extensively worked on tableau migration from Dev to UAT and Production along wif published datasources and extract workbooks.

Tableau Developer\Data Analyst

Confidential

Environment: Tableau Desktop 8.X/9.X/10.X, Tableau Server, Tableau Public, Tableau Reader, Oracle 11g, SQL server and My SQL.

Responsibilities:

• Interact wif client to understand their business and reporting needs, including teh identification of critical metrics and KPIs
• Understanding teh Data modeling design in Tableau Reporting as per teh business requirement and built teh restful model for business and optimized teh query performance to keep Tableau environment agility and keeping teh environment more active to downstream applications (Tableau\Web Applications)
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Implemented teh Dual axis, Discrete, Continues, Measure Names, Measure Values, Context filter, relevant values, Sets, Group, Rank, Parameters, Exclude and Left functionalities according to teh business needs
• Created teh Tree Map and Heat Map to represent teh hierarchical data and compare categories using color and size
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created teh Rich Dashboard Reports wif required worksheets and published teh dashboard and worksheet into Tableau Server for teh Business users.
• Handle teh null values, special values, and negative values in line chart reports.
• Experience in migrating client’s reports from excel (static) based solution to an interactive service.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Implemented teh LOD (level of detailed calculation) wif Include, Exclude and Fixed as per teh requirement.
• Groups, hierarchies, sets to create detail level summary report and dashboard using KPIs
• Created teh published data sources and published into teh server and extracted data on daily basis to improve teh performance of teh dashboards
• Extensively worked on performance of teh report by optimizing teh tables\views and removing teh unnecessary calculated columns, filter, and parameters.
• Extensively worked on POC for Tableau username function to know, how tableau is sending username function when we use custom SQL, Data model and in different scenarios.
• Extensively worked on tableau migration from Dev to UAT and Production along wif published data sources and extract workbooks.

Tableau Developer

Confidential

Environment: Tableau Desktop 8.X,9.X, Tableau Server, Tableau Public, Tableau Reader, Oracle 10g, SQL Server, Excel.

Responsibilities:

• Interact wif client to understand their business and reporting needs, including teh identification of critical metrics and KPIs
• Understanding teh Data modeling design in Tableau Reporting as per teh business requirement and built teh restful model for business and optimized teh query performance to keep Tableau environment agility and keeping teh environment more active to downstream applications (Tableau\Web Applications)
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Implemented teh Dual axis, Discrete, Continues, Measure Names, Measure Values, Context filter, relevant values, Sets, Group, Rank, Parameters functionalities according to teh business needs
• Created teh Tree Map and Heat Map to represent teh hierarchical data and compare categories using color and size
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created teh Rich Dashboard Reports wif required worksheets and published teh dashboard and worksheet into Tableau Server for teh Business users.
• Handle teh null values, special values, and negative values in line chart reports.
• Experience in migrating client’s reports from excel (static) based solution to an interactive service.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Groups, hierarchies, sets to create detail level summary report and dashboard using KPIs
• Created teh published data sources and published into teh server and extracted data on daily basis to improve teh performance of teh dashboards
• Extensively worked on performance of teh report by optimizing teh tables\views and removing teh unnecessary calculated columns, filter, and parameters.
• Extensively worked on POC for Tableau username function to know, how tableau is sending username function when we use custom SQL, Data model and in different scenarios.
• Extensively worked on tableau migration from Dev to UAT and Production along wif published data sources and extract workbooks.

Cognos Developer

Confidential

Environment: Cognos8.0&8.1(Framework Manager, Cognos connection, Report Studio, Query Studio, Access Manager), Cognos TM1,Oracle, SQL Server, Excel and Windows Server 2003.

Responsibilities:

• Worked on Report Studio, Query Studio, Analysis Studio, Metric Studio and Cognos administration.
• Created Pie, combination and ad-hoc analysis charts and Dashboards in Spot fire.
• Created Information Models and Information links as per Business Requirements.
• Identified and created various user groups and roles. Provided access privileges based on their roles and responsibilities.
• Defined data source connections. Fixed teh issues dat we encounter after migration/version upgrade.
• Worked on Framework manager for Metadata modeling of DCF, Protocol, ECG and Patient Data, Customer Data, Field Request Data. Outage Data. Group Data, Jobs Data and Tracker data.
• Worked on Report Studio, Query Studio, and Analysis Studio and Cognos administration.
• Created various Cognos Port lets, Cross tab Reports, List Reports Chart reports, Master Detail reports, Drill through and Bursting Reports.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Worked on Turbo Integrator process for loading and manipulating of Data and Metadata, securities creating groups, users and Excel options like Slice, Snapshot, Active form and some additional features knowledge in Sandbox and Undo/Redo.
• Involved in teh preparation of operational business documents gathering teh business requirements from users in onsite.
• Worked on TM1 and Cognos Planning for preparing teh Forward estimates roll over.
• Implementation of Cognos up-gradation from 8.1 to 8.4. Migrated various BI reports, models and cubes from Cognos BI 8.1 to Cognos BI 8.4.
• Identified and created various user groups and roles. Provided access privileges based on their roles and responsibilities.
• Defined data source connections. Fixed teh issues dat we encounter after migration/version upgrade.

Cognos Developer

Confidential

Environment: Cognos7, Cognos8.0&8.1(Framework Manager, Cognos connection, Report Studio, Query Studio, Access Manager), Oracle, SQL Server, Excel and Windows Server 2003.

Responsibilities:

• Interact wif client to understand their business and reporting needs, including teh identification of critical metrics and KPIs
• Worked on Report Studio, Query Studio, Analysis Studio, Metric Studio and Cognos administration.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Worked on Turbo Integrator process for loading and manipulating of Data and Metadata, securities creating groups, users and Excel options like Slice, Snapshot, Active form and some additional features knowledge in Sandbox and Undo/Redo.
• Implementation of Cognos up-gradation from 8.1 to 8.4. Migrated various BI reports, models and cubes from Cognos BI 8.1 to Cognos BI 8.4.
• Identified and created various user groups and roles. Provided access privileges based on their roles and responsibilities.
• Defined data source connections. Fixed teh issues dat we encounter after migration/version upgrade.