SUMMARY:

• 7 years of experience as Business Intelligence Developer with Tableau, Business Intelligence tools, Data Analytics and Dashboards.
• Experienced in working with Tableau Desktop, Tableau Server and Tableau Public
• Experience gathering client requirements, writing test cases and collaborating with developers to guarantee full understanding of internal/external client needs and delivering training to others on the utilization of Tableau.
• Designed, developed, and maintained reports and multi - level dashboards in Tableau.
• Experienced as a Data Analyst and in transforming client requirement documents into business requirement documents.
• Developed Tableau workbooks to perform Year over Year, YTD, QTD and MTD type of analysis.
• Working knowledge on optimizing the overall performance of dashboards with the aid of the usage of Tableau Performance Recording feature.
• Proficient in data visualization, Reporting and Analysis using Bar Charts, Line Charts, Tree Maps, Pie Charts, Heat Maps, Scatter Plots, Dual axis, Geographical Maps in Tableau Desktop.
• Installed Tableau Server and experience in adding Worker Nodes.
• Experienced in publishing workbooks with different User Filters to Tableau Server and managing Schedules, Permissions and Authorizations.
• Utilized the Configuration Utility to set up worker nodes in Tableau Server and worked on Users, Subscriptions and Schedule refreshes.
• Created actions, custom made relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis on Tableau Desktop.
• Extensive working knowledge on advanced Tableau features - Clustering, Level of Detail expressions, Parameters, Sets, Groups, Forecasting, viz in a Tooltip, Data Blending etc.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Experience in development of user defined reports to give on demand data analysis utilizing Excel and created charts and pivot tables in Excel.
• Proven capacity in Tableau, SAS, SQL and Excel.
• Worked with ETL Tools such as SSIS (SQL Server Integration Services) and experience in creating Custom SQL Queries on Tableau.
• Extensive hands on experience on BASE SAS, SAS Enterprise Guide and SAS Enterprise Miner in performing data analysis.
• Built users, groups, projects, data connections, settings as a tableau administrator.
• Proficient in building Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
• Skillful in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Informatica, MicroStrategy, SSRS.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.

TECHNICAL SKILLS:

Analytics Tools: Tableau Desktop v8.x/v9.x/v10.x, Tableau Server v9.x/v10.xTableau Online v9.x/v10.x, Tableau Reader, Tableau PublicTableau Mobile, SAS

Database Skills: SQL Server, Oracle, Teradata, Microsoft Access

Programming Languages: Python, R, SAS, SQL

Applications: Word, Excel, PowerPoint, SharePoint, Outlook, Open Refine

Data Modeling: MS Visio

ETL Tools: Informatica, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps, Gantt charts utilizing show me functionality and publishing them to tableau server and tableau Online.
• Extensively worked on metadata in Tableau desktop to alter data types, rename fields, joins, assign roles, refresh data and change extract data options to prepare data sources to be utilized by users.
• Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality: parameters, actions and tooltip changes.
• Created advanced analytical dashboards using Trend Lines, Forecasting, Linear Regression Models etc.
• Involved in Agile Scrum Meetings and Tableau Development with internal and external clients.
• Developed effective and interactive Dashboards using Dashboard objects and Dashboard Actions.
• Optimized current pivot tables reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble charts to enhance data analysis.
• Involved in upgrade of Tableau Server from 10.0 to 10.5 and created Users Groups, Projects, and assigned Access levels in Server.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Worked with pivot tables, v-lookup, graphs and charts to analyse large sets of data using Excel.
• Created SQL queries for data extraction and transformation to make certain that the data is properly extracted for building Tableau dashboards.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view current, forecast and past sales data.
• Worked with multiple data sources joins in Tableau Desktop.
• Created calculated fields, action filters and parameters in tableau dashboards and worksheets.
• Worked on designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using Oracle to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Working with a team of developers designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at the application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.

Confidential, Austin, Texas

Tableau Developer / Admin

Responsibilities:

• Worked on creating dashboards in Tableau by querying various ODBC connections such as Oracle and SQL Server.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Worked on setup and configuration of Tableau Server and used Tableau CMD and Tableau Admin tools for server configuration.
• Used Tabjolt for performance testing in Tableau Server.
• Documented all statistical findings and presented insights to management in the structure of Tableau stories.
• Involved in Agile Scrum Meetings and Tableau Development with internal and external clients.
• Analysed large and multidimensional datasets for data analytics using SAS and Excel.
• Developed systematic solutions for data clean-up using data mining techniques.
• Created users, groups, projects, Data connections, settings as a tableau administrator.
• Worked with R functions and R models in Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Coordinate with ETL support team to perform full refresh and manage database operations on Tableau server.
• Developed cross table, Bar chart, Tree map and complex reports which involves property controls, custom expressions.
• Manage the application's users, groups, and integration with Active Directory.
• Experience in writing SQL reporting skills with the ability to create SQL views and write SQL queries.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop.
• Created presentations to communicate findings and offer recommendations to management and external audiences using Tableau.

Confidential, Herndon, Virginia

Tableau Developer

Responsibilities:

• Created dashboards for scenario analysis, variance analysis, monthly and quarterly reports and ad-hoc reports.
• Created Histograms, Scatter plots, box plots, filled area charts wherever there was a need to show the distribution of data.
• Developed, Bar charts, stacked Bars, tabular chart, pie chart if the data had to be compared against few dimensions or variables.
• Created line graphs to show the trend over the period.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation
• Wrote reports using Tableau reporting system to extract data for analysis using filters based on the analysis.
• Developed Tableau reports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps.
• Created demo-able marketing database (logical and physical data modeling) to show BI tools (Business Objects and Tableau) functionality.
• Generated context filters and user-based performance actions while handling large volumes of data in the project.
• Interacted with business stakeholders, gathered dashboard requirements and managed the delivery.
• Documented various business requirements, deployment plans and organized several user’s courses to facilitate the users to learn and adapt to the new systems.
• Used calculated fields substantially for exceptional logics for Trend, Extended price calculations for the distinctive cost types.
• Analyzing raw data, drawing conclusions & developing recommendations
• Adept in data extraction and preparation methodologies.

Confidential

Tableau Report Developer

Responsibilities:

• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
• 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.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Strong verbal and written communication skills, ability to work effectively with user departments.

Confidential

SQL Server Developer / Data Analyst

Responsibilities:

• Experienced in creating SQL queries and optimizing the queries in SQL Server.
• Created Stored Procedures, Triggers, Cursors, Tables and Views and other SQL joins and statements for applications.
• Generated Reports on Weekly, Monthly, Quarterly Basis.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP
• Implemented Data Mart, Facts, Dimensions, Snowflake schema, Star Schema and OLAP cubes
• Experienced in creating actions, filters, data blending, sorting, grouping, establishing live connections from SQL Server to Tableau.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Worked in visually enhancing reports as per user requirements.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.