PROFESSIONAL SUMMARY:

• Tableau Developer with around 8 years of experience in tableau data visualization, data discovery, report development, data analysis, MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration
• Strong Expertise in using Tableau software as applied to BI data analytics, reporting and dashboard projects.
• Professional in writing Complex Formulas, Sub Reports, Summary Reports in analyzing high - volume, high-dimensionality data from varying sources.
• Extensive Experience in various Tableau Desktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend Lines.
• Extensive knowledge in various reporting objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
• Combined Reports & views into interactive dashboards in Tableau desktop and presented to Program Managers, Business users and End Users.
• Expertise in design & development of various reports, dashboards using various Tableau Visualizations like Dual Axis, Bar Graphs, Box & Whiskers Plot, KPI Scorecards, Scatter Plots, Pie-Charts, Heat Maps, Gantt Charts, Bubble Charts, Tree Maps, Funnel Charts, Box-Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to business requirements.
• Worked extensively on data blending, and different table calculations for different scorecards, performance tuning Tableau Reports, published dashboards on Tableau Public
• Expertise in dealing with Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Expertise in Data Analysis, Data Extraction, Data Marts. Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts and Project Manager
• Proficient in Oracle 11g, SQL Server, PL/SQL on Windows platforms. Extensive experience in Database activities like Database Modeling, Data Mapping and Data Analysis. Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.
• Developed effective and interactive Dashboards using Parameters and Actions
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Effective Ability to create Custom Tableau reports using SQL and advanced Tableau mapping.

TECHNICAL SKILLS:

Business Intelligence tools: Tableau (Desktop & Server), 9.0/8.2/8.4/8.1, Tableau 7, MySQL Server, SQL Server 2008, Oracle 11g, PL/SQL, Microsoft Office 2007, Visual Studio 2010

Tableau Tools: Tableau Desktop 8, Tableau Reader, Tableau Public, SQL Server 2012/2008R2/2008,Oracle, SQL server Reporting Service 2008, SQL Server Management Studio, MS-Excel

Operating System: Windows2007, 2008, XP,UNIX, Windows 8.1

Data Modelling: Microsoft Visio 10.0/11.0, ERWIN 4.0/4.1/4.2/7.2, SharePoint

Relational Database: Microsoft SQL Server 2012/2008R2/2008/2005/2000, Oracle 9i/10g/11i, Microsoft Access 2007/2003

Methodologies: Data Modelling - ETL, OLAP, Complete Software Development Life Cycle, Waterfall, Agile, Iterative

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Tableau Developer

Responsibilities

• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Schedule data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Optimize Indexes, Views, Stored Procedures and Functions using Oracle.
• Understand the reporting requirements and provideTableaureporting solutions.
• Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications.
• Analyzed source data and handled efficiently by modifying data types.
• Used Excel Sheets, flat files to generate tableau adhoc reports.
• Generated Tableau dashboards for sales with forecast and reference lines.
• Created adhoc reports to users in tableau by connecting various data sources.
• Creating visually compelling and actionable interactive reports and dashboards.
• Design and development of interactive data, data visualizations, graphical dashboards and reports using Tableau.
• Created individual Worksheets and incorporated it into Dashboards with the appropriate filters
• Created the calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs with the base data.
• Documentation, Maintenance and Scheduling. Also preparing status report for the project Involved in the LLD and HLD of reports Column Mappings from one environment to other.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Created actions to navigate to various pages as per the user wish
• Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of scheduled jobs
• Created summarized menu options as tabs in home page where the users easily choose the required options.
• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.

Environment: Tableau Desktop 8, Tableau Reader, Tableau Public, Oracle, SAS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, SQL 2008R2, Oracle 11g, SharePoint, Crystal Reports 2008, Microsoft office 2010, Windows 2007, Microsoft Access 2007/2003

Confidential, Addison,TX

Tableau Developer

Responsibilities:

• Create Schedules and extract the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations.
• Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Effectively used data blending feature in tableau.
• Define best practices for Tableau report development.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Execute and tested required queries and reports before publishing.
• Develop parameter and dimension based reports, drill-down reports,charts, and Tabular reports using Tableau Desktop.
• Execute and tested required queries and reports before publishing dashboards.
• Provide support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively work on Tableau Desktop, by creating Complex reports & Dashboards.
• Create Tableau scorecards, dashboards, Heat maps using show me functionality
• Scheduling the monthly/weekly/daily reports to run automatically.
• Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Create procedures to ensure the quality, usability and accuracy of reports.

Environment: Tableau Desktop(Version 8.1.2 - Version 9.0.2), SQL Server, Microsoft Visual Studio, Microsoft Visual Basic, Oracle, SQL Server Management Studio, MS Excel, MySQL

Confidential, NY

Tableau Developer

Responsibilities:

• Going through Report Specification Documents and Understanding the User requirements.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sales
• Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.

Environment:Tableau Desktop 8.1-8.2, Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, Microsoft Excel 2007,MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0.

Confidential

Tableau Developer/Data Analyst

Responsibilities:

• Gathered Business Requirements Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, 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 strings, arithmetic calculations, aggregation options and Logical functions)
• Worked extensively with Advance analytics like Reference Lines and Bands,Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Published and shared views on Tableau server.
• Scheduled extract refresh and subscriptions.
• Installed and Configured Tableau server
• Involved in Upgradation of Tableau Server from v7.0.12 to v 8.0.7 and also Created Users, Groups, Projects, Workbooks and assigned Access levels in Server.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Environment:Windows Server 2012,TableauDesktop 9.0/8.3,TableauServer, SQL Server 2008/2012, PL/SQL, Oracle, Toad, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

Tableau Developer/Data Analyst

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards usingtableaudesktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Upgraded Workbooks and Dashboards from Tableau 6 to Tableau 7
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features ofTableausoftware 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 fortableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Effectively used data blending, quick filters, actions, hierarchy 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.
• Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.

Environnent: Tableau Server/ReaderAdministrator, Oracle 11i, Windows 2003/ XP, Tableau Desktop 7.0, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007