SUMMARY

• 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
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms
• Experience 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.
• Strong Expertise in using Tableau software as applied to BI data analytics, reporting and dash board 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.
• 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), … 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, Tableau Server 8/7/6/5, SQL Server … Oracle, SAS, Server Integration Services 2008, SQL server Reporting Service 2008, SQL Server Management Studio, MSExcel

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

Data Modelling: Microsoft Visio … ERWIN … SharePoint

Relational Database: Microsoft SQL Server … Oracle … Microsoft Access …

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

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Tableau Developer

Responsibilities:

• 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, Tableau server / 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, Redwood City, CA

Tableau Developer/Data Analyst

Responsibilities:

• 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 Up gradation 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, Tableau Desktop 9.0/8.3, Tableau Server, SQL Server … PL/SQL, Oracle, Toad, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential, Boulder, CO

Tableau Developer/Data Analyst

Responsibilities:

• 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 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 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.

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

Confidential, Arlington, VA

Tableau Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• 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 summarized menu options as tabs in home page where the users easily choose the required options.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau Desktop 8, Tableau Reader, Tableau Public, Tableau Server 8/7/6/5, SQL Server … Oracle, SAS, Server Integration Services 2008, SQL server Reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, SQL 2008R2, Oracle 11g, SharePoint, Crystal Reports 2008Microsoft office 2010, Windows 2007, Microsoft Access …

Confidential, Highland Park, MI

TableauDeveloper/ Business Analyst

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generatedTableauadhoc reports.
• Prepared use cases and got reviewed with state of Nevada.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.Generated Dashboards by joining multiple complex tables.
• Prepared different views for Small business Health Options Program (SHOP).
• Generated dashboard for Finance team, provided security by using user filters.
• Trained CSRs ontableausoftware.

Environment: TableauServer 6/7,TableauDesktop 6/7, MS SQL Server 2008, Oracle 10g, SQL BISuite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows

Confidential 

SQL Developer

Responsibilities:

• Programmed clients website and applications - worked collaboratively with clients. Teammates and web analysts to complete designs and estimates.
• Provided insightful ideas for developing effective and accurate codes - Evaluated latest technology on the market and made recommendations to clients to integrate new designs as available by new technology.
• Collaborated with end users and other related departments to ensure that the website is meeting the client's expectations and business requirements.
• Collaborated with technical team members to integrate back-end and front-end elements.

Environment: Windows 00/XP, SQLDeveloper, MS-SQL 2008 R2, MS-Access, MS Excel and