SUMMARY:

• Around 7 Years of IT experience as a data visualization & report developer using Tableau (Tableau Desktop, Tableau Sever, Tableau Reader and Tableau online).
• Expertise in Tableau BI reporting tools &Tableau Dashboards Developments & Server Administration.
• Created Tableau dashboards and Storyboards like analytical and operational reports.
• Very good experience in Designing, building, publishing data analysis reports/dashboards for large volumes of data.
• Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Excellent experience in all phases of Data Warehousing including Project planning, requirements gathering, data modeling, development, deployment, maintenance and enhancement.
• Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.
• Worked with connecting multiple data sources like Oracle, Excel etc.
• Expertise in creating Key Performance Indicators (KPI).
• Developed dashboards with rich Graphic visualizations, Drill Down and Drop up menu options, Parameters using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in creating different Tableau visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, Waterfall charts, Donut Charts, Bar in Bar charts etc.
• Extensively Participated on moving Reports from Excel to Tableau.
• Hands on experience with Live and Extract connections.
• Expert in installing, configuring tableau server and using Tableau Command line utility for administrative tasks
• Experience in creating users, groups, and projects on tableau server.
• Handled Tableau server side for user permissions, grouping, scheduling reports.
• Scheduled data extracts and subscriptions on a daily basis.
• Provide technical documentation on the recommendation made and on the modification to existing reports due to the new user requirements.
• Delivery of Reports changes & testing & deployment with adequate documentation in relation with the request for changes or additional requirements
• Expertise in Trouble shooting & Performance Tuning of Tableau reports by following best practices in source data like data blending, custom SQL etc.
• Expert in modeling Transactional Databases and Data Warehouse.
• Strong understanding of project life cycle and SDLC methodologies Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Reporting Tools: Tableau Server, Tableau Desktop, Tableau Reader, Tableau Public, SSRS, Cognos.

Operating Systems: Windows, UNIX

Languages: C, C++, SQL, PL/SQL, Python

Web Servers: Apache 4.0, Tomcat 7.0

Database: My SQL, Oracle, Hadoop, Excel Flat Files, CSV, Oracle12G, MS SQL server, IBM DB2

ETL: Informatica power center 7.x/8.x/9.x, SQL server 2005 Integration services, Siebel DAC, Oracle, Dimensional Modeling, Star - Schema, Snowflake Modeling, Erwin 3.x, Microsoft Visio

BI Tools: Oracle Business Intelligence (OBIEE) suite 12c, 11.x, 10.x, Oracle Business Intelligence Applications(OBIA)

PROFESSIONAL EXPERIENCE:

Senior Tableau BI Developer

Confidential , Phoenix, AZ

Responsibilities:

• Worked thoroughly with the Business Partners to gather business requirements, understanding each capability of the requirement.
• Developed executive level HIIN Internal dashboard which is used by all HIIN Quality Agents and Internal users.
• Worked on refreshing the data and fixing Tableau related issues for the HIIN External Dashboard.
• Developed impactful presentations and documents.
• Created actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created Gantt charts, Donut charts, pie charts, heat map, bar charts, funnel, trend charts etc.
• Created Collapsible views for the chart to occupy the real-estate of the Dashboard.
• Created menu driven dashboard navigation between multiple dashboards.
• Created column selector for list view, enabling user to choose the columns to display on list view.
• Enabled Tableau Actions to drill down from Dashboard to worksheet.
• Developed OEI Full dashboards for each county in Ohio state.
• Generated PDF’s for the dashboards to share with the users.
• Proficient in table calculations and applying complex, compound calculations to large, complex big data sets.
• Testing the reports with data and Rectified the issues occurred.
• Solved Performance issues on Executive dashboards to increase the speed for filtering on the Dashboard.
• Converted existing Excel Reports into Tableau Dashboards.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Given training/demos to users on Tableau Desktop for development.
• Successfully delivered the dashboard on time, utilizing project management best practices.

Environment: Tableau 10.x/2018.x/2019.x, SQL Server, SAS, Oracle, MS Excel.

Senior Tableau Developer

Confidential , Westborough, MA

Responsibilities:

• The scope of the project is to create dashboards and reports to equip stakeholders to understand complaints, claims, and status and revenue comparison.
• Created dashboards using Tableau Dashboard & prepared user stories to create compelling dashboards to deliver actionable insights.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Develop Scripts to load data into tableau and work with multiple data connections including Hadoop/Hive by data blending.
• Involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations sorting, filtering, ranking, Top-N Analysis, hierarchies.
• Coordinated, resolved database middleware issues with DBA's, and data warehouse issues with data architects.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Created Actions, Parameters, Filters and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
• Experience with Scheduling Tableau Extracts, working with Multiple Data sources using Data Joining and Data Blending
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Performed report tuning using extracts, Cache options, removing unused fields.
• Created report schedules on Tableau server and Tableau Online.
• Created complex calculations including arithmetic calculations, custom aggregations, logic statements, LOD and quick table calculations.
• Used parameters and quick filters.
• Created sets to display top products based on their Complaints. Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Extensively used Marks, Filters and Pages, Add Reference line, Calculation Fields to create complex Dashboards.

Environment: Tableau 9.3/10.x, Oracle 11g, SQL Server, GIT, Hadoop, Squirrel Client, MS Excel.

Senior Tableau Developer/Administrator

Confidential, Framingham, MA

Responsibilities:

• Interact with Business users and understanding their requirements.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Created Tableau dashboard to compare forecast vs actual sales for units sold.
• Added filters to filter top 10 and bottom 10 performing promotions.
• Created forecast accuracy dashboard to show which promotions had better forecast.
• Recommending Dashboards per Tableau visualization features.
• In addition to the above mentioned standard reports, business uses will request for adhoc intra-day reports which was also developed using Tableau.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio .
• Designed SSRS bar graphs and pie charts, converted Access reports to SSRS reports.
• Develop Scripts to load data into tableau and work with multiple data connections including Hadoop/Hive and by data blending.
• Analyzed and troubleshoot hive Hadoop jobs if failed using Hadoop logs.
• Delivering reports to Business team on timely manner.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
• Streamlined the data supporting the dashboards using SQL server.
• Also developed in-house reports for management decisions.
• Involved in migration Project of legacy reports to Tableau.
• Designed multiple Dashboards with the help of tableau features like Sets, Parameters, Quick Filters, Actions, and Bins etc.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed Story boards for better visualization.
• Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Ensured projects were completed on time and within budget.
• Handled Tableau server side for user permissions, grouping, scheduling reports.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with Tableau Server and Reports.
• Scheduled data extracts on a daily basis.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows 7, Tableau 8, 9 Tableau Servers, SSRS, Hadoop, Hive SQL Developer, SQL-PLUS, Oracle 10/11g, MS-Excel.

BI Developer (Tableau)

Confidential, Far Hills, NJ

Responsibilities:

• Created multiple reports for Olympic Management System such as Finical reposts, Guest Registration reports, inventory reports, general reports...etc
• Created dashboards to showcase summary of package sold to individuals within one of the specific sales market channels.
• Collaborate with data architects for data model management and version control.
• Created reports to show the marketing trend between the customers showcasing their trial programs and the timing of conversions and also developed in-house reports for management decisions.
• Worked with business unit managers to translate client requirements into technical specifications.
• Created multiple reports for financial analyzing like Credit Refund Report, E-commerce Daily Unsold Report, and Accommodation Inventory etc.
• Delivered reports to Business team on a timely manner.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboard using KPI's.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Designed multiple Dashboards, helping them to convert from manual reporting.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows 7, Tableau 8, 9 Tableau server, SQL Developer, SQL-PLUS, MS-Excel, SQL Server, SharePoint

Tableau Consultant

Confidential, Washington, DC

Responsibilities:

• Understand the customer Requirements and the Technical specification documents.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations using Tableau to the senior management and executives.
• Validated the data results in Tableau by verifying the numbers against the healthcare data in the database tables by querying from patients' database.
• Created Dashboards from Tabular Models to help managers and various employees to identify critical KPIs and facilitate strategic planning in the organization. Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed executive level dashboard prototype for the Operations Research Consulting group which provided analytics.
• Provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview in the developed dashboards.
• Created histograms, pareto analysis charts, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Responsible for interacting with the users, gathering requirements and managing delivery.
• Created dashboards and visualizations using Tableau Desktop 9.X for key metrics.
• Published dashboards to the Tableau Server with custom auto refresh to extracts.
• Used groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations
• Developed a 360-business dashboard with Tableau with multiple panels and parameters that became a favorite analytical tool for most of the Fund Managers.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis.
• Developed Tableau workbooks from multiple data sources like RDMS databases (SQL Server & Teradata), Flat Files & MS Excel using Data Blending. Provided production support for Tableau users.
• Designed different charts in Tableau dashboard to show monthly Trade Data for Muni Bonds per Trading Desk. These charts helped the Wealth Management team to spot outliers.
• Wrote custom SQL within Tableau to support non-standard functionality requirements.
• Performed Tableau dashboard performance recording and tuned layout and queries accordingly.
• Delivered training to users and resources on Tableau features from basic to advance.

Environment: Tableau Desktop/Server, SQL Server, Oracle, Windows 2008/XP, MS Access, J2EE, JIRA.

Tableau Developer

Confidential

Responsibilities:

• Involved in requirement gathering/analysis from the on-site team leads, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Led information-gathering meetings with users to gather business requirements. Used event analysis and data modeling techniques to gather and document requirements. Delivered business requirements document and preliminary logical data model.
• Built charts like bar in bar, bullet, scatter plot, pie and bar charts, bins and histograms and dual axis charts.
• Documented the data requirements and system changes into detailed functional specifications, created data mapping documents from various source data feeds to the target databases.
• Designed database layers with aggregate tables and materialized views based on source data need for reporting requirements to improve performance of Tableau reports.
• Developed complex SQL scripts for fetching data in to Tableau as per the business needs.
• Generated dashboards to compare the expected weekly sales vs. projected sales used dual axis for comparison.
• Generated tableau dashboards for sales with forecast and reference lines.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the publishing of dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau (Desktop/Server), MySQL Server, SQL Server, Oracle 10g, PL/SQL, SQL Server Management Studio, UNIX, Visual Studio, Microsoft Office Suite (Word, Excel, PowerPoint).