SUMMARY:

• Proficient in Tableau Desktop with R environment, Crystal Reports, SSRS, and Excel Power Pivot Reporting tools.
• Administration of Tableau Server and experience in attending ad - hoc requests - creating individual sites, projects and managing report-specific and user-specific access, sync users with Active Directory.
• Over 6 years of extensive experience in report design, dashboard development, data analysis and data integration.
• Create complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Strong T-SQL programming ability to finish various complicated queries.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Access, MS SQL Server, Oracle, etc.
• Skilled in Tableau Desktop for data visualization, reporting and analysis; Proficient in creating calculations and formatting using Tableau Desktop.
• Extensive experience in interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Experience in building universes, stored procedures, free hand SQL methods and creating complex and Ad-Hoc Reports using MS SQL Server with strong T-SQL language skills.
• Proficient in designing techniques like snowflake schemas, star schema, fact and dimension tables, logical and physical modeling.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• BI tools: Tableau Desktop with R environment, PowerPivot, SAP Crystal Reports, and Data Mining for Excel 2010.
• Tableau Server Administration and maintenance.
• Microsoft Business Intelligence (BI) tools: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS).
• Strong knowledge with T-SQL coding, documentation, system performance and optimization.
• Proficient with Microsoft SQL Server 2012, Experience with database design including table structure, data types, indexing, and permissions.
• Experience with various kinds of ERP Systems, including the Human Resource, Payroll, Products, Sales and Financial bundles, etc.
• Other Statistical Package: SAS, ACCESS, EXCEL.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Tableau Developer/Administrator

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• 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 KPI's
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, UAT and Prod environments.
• Upgraded Tableau 8.1 environment to Tableau 8.2
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser, tablets or ipad.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Composed documentation related to visualization dashboards and performed end user training.

Confidential, Edison, NJ

Sr. Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• 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.
• Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.

Confidential, CA

Tableau Consultant

Responsibilities:

• Designed and set up the architecture for Alteryx and Tableau
• Created multiples sites DEV/QA/PROD and projects within each sites for content management
• Tableau user security enablement through windows Active Directory and user groups
• Data blending, preparation using Alteryx for tableau consumption, publishing to Tableau server
• Calculation of member LTV, associating it with various demographic attributes.
• Developed interactive dashboards using table calculations, Pareto, Waterfall, Bar charts, scatter plots and other Tableau features.
• Sales funnel, member journey, member growth, branch comparison dashboards with data from Sales Force, Banking systems, Demographic data and other data sources.

Confidential, San Diego, CA

Tableau consultant

Responsibilities:

• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Prepare Dashboards using calculations, parameters in Tableau.
• Proof-read all documents and maintain accuracy of information and preparing SOP.