SUMMARY

• 8+ years as a technology professional with vast experience of implementation & administration of Tableau Business intelligence solutions.
• Experience working across various Domains/Industries including Oil & Gas, Healthcare, Retail, Banking, Finance, Insurance and Telecom.
• Strong experience in building Dashboards/Business Visualizations using various BI tools including Tableau against multiple data sources for What if Analysis, Interactive, Decision Support and other purposes. Extensive experience building Dashboards Using Advanced Multiple Drill Down, Dynamic Visibility, and Alert Features with Flash Variables, web services.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating data models to design Tableau solutions.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including installation, configuration, technical support, troubleshooting, report design and monitoring of system usage.Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement and involved in troubleshooting, performance tuning of reports and resolving issues within Tableau Server and Reports.
• Developed various visualizations Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, 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 the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive experience with SQL / PL/SQL, T-SQL language with major database systems, including Teradata, Oracle, Microsoft SQL Server developing complex Stored Procedures, Effective Triggers, Tables, Views, and User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Good Experience and understanding of Data Warehouse architecture (ODS, EDS, EDW, Data Marts), Business Intelligence, etc.
• Created functional specifications for ETL mapping, mock up for Dashboard and Visualization frames.
• Strong knowledge OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, SSIS processes, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data warehouse / Datamarts.
• Strong ability in Data warehousing tools like Erwin and also have experience in Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS Packages with proper control flow and data flow elements by using MS SQL Server
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Good experience in generating Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS
• Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
• Strong Experience with Business Objects connectivity methods including BICS connectivity, WSDLs and other database environments such as Oracle and SQL server.
• Self-learning ability, Leadership Quality, good team player and determination to learn new technologies and maintain positive relationships at all business levels.
• Possess strong problem-solving skills including analysis, evaluation, strong communication and interpersonal skills, responding quickly to requests, volunteering to help co-workers, and working well with team members to solve problems and bring projects in quickly and with quality.

TECHNICAL SKILLS

Business Intelligence: Tableau, Tableau Desktop, Tableau Online, Tableau Public, Tableau Server, Tableau Reader, Crystal reports, OBIEE, Business Objects, OLAP, OLTP, SAP BW, Xcelcius, HANA.

Programming/Scripting: VB, ASP.NET, ADO.NET, C#, C, C++, Java, PHP, XML, CSS, VBScript, JavaScript, JQuery and LINQ, Visual Studio.

ETL/Database/Query/Reporting: Informatica, Teradata, SQL Server, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Oracle, MS Access, T-SQL, PL/SQL., Erwin Data Modeler, ER Studio

Operating Systems: Windows, UNIX, Linux, OS X

Office Suite & Other: MS Office (Word, Excel, PowerPoint), MS Project, MS Visio, SharePoint, InfoPath

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Tableau Developer

Responsibilities:

• Involved in generating proper data in excel for Tableau Dashboard.
• Extracts data from multiple database to create Tableau Dashboards.
• Involved in installation and patch up gradation of application on servers.
• Responsible for efficient timely backups, project, groups' creation.
• Scheduled for auto refresh of dashboards on the application server.
• Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.
• Skillful at creating multi-level hierarchy in Tableau Dashboard.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Recommended Dashboards per Tableau visualization features.
• Efficient at using Parameter in calculation field to give flexibility to end user.
• Created global filter for the dashboard that uses different data source.
• Created different kinds of actions to make the worksheet invisible while there is no selection.
• Skillfully created different kinds of actions for navigation and drill down.
• Created custom color pallet, custom shapes to use in dashboard.
• Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create complex Dashboards.

Environment: Tableau 9.x, Windows 7 SP1, Microsoft Excel 2010, Microsoft Access 2010, SAP BW 3.0, Oracle 10g, SQL Server, SAP CRM

Confidential, Houston, TX

Tableau developer /Tableau Administrator

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems.
• Used SQL Queries at the custom SQL level to pull the data in tableau desktop.
• Validated the results in Tableau by running SQL queries in MS SQL developer.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Developed tableau functional design document.
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Environment: Tableau Desktop 8, Tableau Server 8, MS SQL Server 2008R2, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010.

Confidential, NY

Tableau Developer

Responsibilities:

• Created Rich dashboards using Tableau Desktop and prepared story points to create compelling dashboards to deliver actionable insights.
• Two different roles like Dimensions and Measures are preformed to control the behavior of the fields when we use it in a view
• Applied different graph formats like Tree map, Bubble chart, Bar chart, Pie chart etc., on visual query for better representation of worksheets.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Used several objects - Vertical, Horizontal, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using tableau desktop.
• In order to improve the performance of the tableau desktop EXTRACT connection is used to get the data into Tableau data engine for faster retrieval of data. If the database is fast enough to retrieve the data then we usually go for LIVE connection.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Created good visualization for logistics calculation on fields by using table calculations, hierarchies, and pages.
• Created Maps to show the forecasting of the product sales in an organization.
• Generate KPI for customer satisfaction survey results and disease management.

Environment: Tableau Desktop 8.1, Tableau Server, Oracle 11g, SharePoint

Confidential, Plano, TX

Sr. Tableau Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled 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.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Creating reports using Webi
• (Web Intelligence) and Deski (Desktop Intelligence) using Business Objects XI R2 and R3.
• Develop Ad-hoc Business object reports according to user's requests.

Environment: Tableau7.0/8.0, Tableau Server, Crystal Reports, Xcelsius 2008, Web Intelligence, MS Excel, SQL Server, HANA DB.

Confidential, St. Louis, MO

Tableau Analyst

Responsibilities:

• Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating tableau reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Identify new metrics and enhance the existing KPI's.
• Statistical Analysis of the data provided by the company to compare and analyze various measures including merchant categories, location and fraud detection.
• Dashboard Visualization through Tableau BI application.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Experience using the Tableau tool to handle the various data feeds from different data sources using Tableau desktop.
• Involved in Exploring, Designing, Building, Testing and Deployment of high level dashboards for Directors, Marketing decision makers, Finance for critical metrics.

Environment: Tableau Desktop 7.0.2, MS Excel, Microsoft Office Suite (Word, Excel, Power Point, Visio), Windows, SQL, HTML, MS Access.

Confidential, Issaquah, WA

Data Analyst/Tableau Developer

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Worked on Metadata Modeling.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents to load Customer, Pre Campaign and Post Campaign data from CRM (Customer Data), Catalina (Promotions data), and UNICA (Campaigns Data) into Target DW environment.
• Designed different type of STAR schemas like detailed data marts, monthly summary data marts, etc. to suffice source requirements for BI reporting.
• Worked on source data profiling, designed Target tables and transformations, error processing to load source data into target tables.
• Designed and developed 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, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using customer and campaign KPI's.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Created, customized & shared interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Conducted data validation testing to ensure data quality.
• Involved in testing and fixing bugs on test and On-line data.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Teradata, Oracle, Informatica, Tableau ( Desktop/ Server), Teradata SQL Assistant, BTEQ, TOAD, AutoSys, UNIX, MS SQL Server, ERwin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Detroit, MI

Tableau Consultant

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to the Tableau server.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Migrated Workbooks and Dashboards from Tableau 6 to Tableau 7.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7.0/6.0, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX, Tableau Desktop 7, Tableau Server 7, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Ultra Edit tool.

Confidential, Deerfield, IL

Tableau Developer

Responsibilities:

• Understanding Business, Functional and System Requirements.
• Created reports using Tableau functionality's like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Created universe objects like Dimensions, Details and Measures, Conditional Objects and Prompts Functions to meet the requirements.
• Created charts to display summary of the data.
• Involving in preparation of UAT Plan for Universes and Standard Reports.
• Worked in System testing & UAT testing in 2 phases called Business confidence Review and Business confidence Test.
• Performing regular back-ups and Universe maintenance activities.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports
• Generated context filters and used performance actions while handling huge volume of data.
• Expertise to create Dashboards and Interactive Dashboards.
• Created relationship between two different Data Source's by using Data- blending.
• Interact with Tableau-Server to publish the data-view and scheduling the reports.
• Created various views in Tableau (Bar charts, Line charts, scatter plot, Heat Maps).
• Developed set analysis to provide custom functionality in tableau application.
• Expertise in creating Hierarchies for proving drill down option for the end user.

Environment: Tableau SQL Server, Oracle, SQL Server Management Studio MS Excel Windows.