SUMMARY:

• 6+ years of experience in Business Intelligence, Information Management, Data Modeling & Data Analytics. Specializes in developing and deploying data visualizations using Tableau Desktop & Tableau Server with additional experience in database design (SQL Server, Oracle and Teradata) & data mining/analysis. I bring both technical and functional expertise with strong leadership & teamwork skills.
• Hands - on experience in building Analytic Dashboards using Tableau Visualization tool.
• Managing and leading the workshops for requirement gathering from Business.
• In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server
• New implementations and upgrade to Tableau reporting.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• End-End implementation experience in designing, developing and publishing visually rich and intuitively interactive Tableauworkbooks and dashboards using Agile methodology.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Working experience with ETL tools and Relational Database Management Systems (RDBMS) - Oracle, SQL server & Teradata.
• Has experience in creating and managing Tableau server and Sites.
• Ability to develop, designs, estimate, test and deploy ETL packages.
• Expertise in writing TSQL, SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Developed best practices guide for tableau server and tableau online
• Manages platform admin functionalities including Installations/ Configuration, Upgrades, Patches, Change management, Performance tuning, Standards/ Best Practices, Mentoring, Metadata Management, Cluster/Distributed Management, Cache/ History Management, User Management, Scheduling.
• Optimized connections, Data extracts, and schedules for background task and Data refreshes for corporate Tableau server for better performance of the workbook reports.
• Hands on experience with, ER Modeling, Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS)
• Development experience with strong understanding of Tableau Architecture and Administration.
• Good experience with tableau installations, configurations and administration, performed troubleshooting tuning and Disaster recovery.
• Excellent communication and leadership skills. Ability to work effectively as a team member and individually.

TECHNICAL SKILLS:

VisualizationTools: Tableau Desktop 10.1/9.3.6/ 9.0/ 8.1/8.0/7/0. Tableau server 10.1/9.3/8.0

Operating System: Windows XP/Vista, Mac OS, Unix/Linux.

Languages: C, C++, SQL, and Java.

Databases and related technologies: - SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010.

Data Modeling Tools: - Erwin

Reporting Tools: - SQL Server Reporting Services, Business Object.

WORK EXPERIENCE:

Confidential

Senior Tableau Developer/Admin Consultant

Responsibilities:

• Migration of PHP report to tableau.
• Experience in working with design and development of tableau visualization solution.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau desktop and server.
• Created complex formulas and calculations with in tableau.
• Implemented navigation and drill down features in Tableau dashboards.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Migrated existing reports to tableau Dashboards and stories, based on the requirement.
• As a System Admin performed site creation, Server maintenance/Upgrades/patches, Schedule control.
• Performed infrastructure sizing, including hardware and software requirements.
• Performed tableau installations, configurations as an admin, Performed troubleshooting tuning and disaster recovery.
• Planned, design and executed performance tests of the platform.
• Was involved in product performance and deployment issues when required, either during implementations or post go-live.
• Developed and documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Performed best practices during implementation and integration of Tableau Platform
• Change management including software, hardware upgrades, patches
• Platform monitoring, availability and performance management, and service reporting (KPI)
• Usage monitoring, technical policies set up and controls, admin best practices, technical audits
• Managing Tableau Sites and servers in with a clustered environment
• Updated Tableau server from 9.3 to 10.1 to all the instances
• Was responsible to create sites, projects and set user permissions,
• Experience on back-end, Oracle Server
• Installed Vizsql on the tableau server for data driven approach
• Experience working with API scripts and pulling data from Jason files.

Environment: Tableau 10.1/9.3, Oracle 11G, Teradata,ELK, MapR Hadoop Hive, Tableau server 9/10

Confidential, NJ

Senior Tableau Consultant

Responsibilities:

• Gathering the requirements and creating technical specification from functional requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting s to users.
• Resource monitoring and repository Audit reporting, Backup and restore. Performed network issues and troubleshooting.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Created Users, groups
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Environment: Tableau 9.0, SQL Server 2008/2008 R2, Linux, T-SQL, SQL Server Management Studio, Microsoft Excel

Confidential, Bartlesville, OK

Tableau consultant

Responsibilities:

• Understand client requirement and decide on the design and the feasibility of the dashboards.
• Created Tableau Semantic layer.
• Implement security in the dashboard based on client requirement
• Create Tableau dashboards based on requirements and publishing it to the server
• Create seamless drill down in the multiple dashboards that were the part of final Tableau file.
• Created multiple extracts to quickly access historical data.
• Created Tableau Extracts of historical data to quickly retrieve information for reports.
• Extracted data from different sources connecting them and used the same to create dashboard
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Met with the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created, customized & shared interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Used filters to display information from various time ranges such as YTD, MTD, QTD, WTD, and Fiscal Year-to-date
• Worked on preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Used Hyperlinks, Filters and URL’s, for developing Complex dashboards.

Environment: Tableau Desktop 8.0, 7.0, Tableauserver / Administrator, Oracle 11g, Microsoft Excel 2010,MS Access, Microsoft office 201.

Confidential, NJ

Tableau Consultant

Responsibilities:

• Involved in the design of the Application Business logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Implemented navigation and drill down features in Tableau dashboards.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Created visually compelling and actionable interactive reports and dashboards.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group/user level security standards for Tableau.
• Modified/maintained and created Products Universe.
• Created web based reporting using web intelligence.
• Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
• Developed, deployed, and managed Commerce applications for the Web.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.

Environment: Tableau Desktop and Server, Java API, Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, SQL Server 2005/2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel.

Confidential

 BI Developer

Responsibilities:

• Analyzed requirements to understand business needs.
• Coordinate with marketing, channel and operational managers to ensure campaigns are consistent with a customer-centric strategy & channel capabilities.
• Migration of SQL Server reports to Tableau.
• Developed visualization reports and story boards in Tableau.
• Extensively developed and used custom routines and enhance the existing projects for campaign management.
• Extracted customer data to suffice source data requirements for campaigning using complex SQL.
• Responsible for complete data integration with other systems developed for marketing.
• Define methodologies for performance improvement and device strategies for ETL and database optimization.
• Suggested efficient routes in extraction, load and data archiving strategy.
• Involved in Test Plan Preparation and Effort Estimation.
• Understanding and providing feedback for all allocated features / defects, including the work that may need to be completed by the offshore team.
• Involved test planning, test scenario development, and execution of E2E testing with the help of the offshore team as an onsite resource.
• Understanding and analyzing the release statuses and activities
• Provided review feedback for all aspect of testing (test plan, test case, test execution) to the offshore team.

Environment: Oracle, Tableau 7.0, Informatica, SQL Server, TOAD, UNIX, HP Quality Center, MS VISIO, Microsoft (Word, Access, Excel, Outlook).