PROFESSIONAL SUMMARY:

• 3 years of experience in Tableau Desktop/Server.
• Extensive experience in development of DATAWAREHOUSING technologies.
• Having working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Experience in Insurance, Educational, Banking and Financial Service Domains.
• Extensively worked on databases like Oracle 11g, 10g, SQL Server, DB2. Strong programming and debugging skills in PL/SQL, SQL, MSSQL, Teradata.
• Knowledge on Google API development skills, SQL Server, ETL processes SSIS, SSAS and SSRS.
• Expertise in writing Store procedures, SQL Queries, Dynamic-queries, and complex joins for generating
• Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Having strong analytical, logical, Communication and problem solving skills.
• Ability to adapt to new technologies by self-learning.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.

SKILL:

Data Visualization Tools: Tableau Desktop 10 .X9.x/8.x/7.x, Tableau Server 8.x, 9.x, Oracle, SQL Server

ETL Tools: Informatica 8/9.x, ODI10g, SSRS, SSIS

Operating Systems: Windows 2000/XP-Pro/Vista/7/8/10

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, HTML 4.0

Database Tools: SQL Developer, PLSQL Developer, SQL* Plus, TOAD, T-SQL

RDBMS: Oracle 11g/10g/9i, SQL SERVER 2005/2008, DB2, Teradata, Netezza, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Tableau Admin/Developer

Responsibilities:

• Mentored business power users to create reports/dashboards using tableau desktop.
• Used forecasting feature to provide predictive information to model future based on the history which added value to our project.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Published reports/dashboards on Tableau server and created & managed tableau server groups and permissions.
• Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.
• Utilized Alteryx for blending data from multiple databases to create a single Data source.
• Provided insights of Time series forecasting data analysis of weekly sales for regions and retail users using R and Tableau.
• Built predictive models for various research using R, including trend analysis, linear regression and logistic regression.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in creating advanced Custom Filters by using Pass-Through Expressions in Micro Strategy. Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Built the DW environment using the Tableau and SQL server tables with Terabytes of Data. Using SQL Server Integration Services(SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Developed various views in Tableau like Tree maps, Heat maps, Scatter plots, Geographic maps, Line chart, Pie charts, etc.
• Created Special technically directed documents for better acceptance of the reports.
• Created reports based on Claims Data and EMR data from the Medicaid data base.
• Created jump plots to analyze the company’s market.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Generated Interactive dashboards with filters, Parameters and Actions to handle views more efficiently.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.
• Experienced with different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Hands on Experience on converting SAP HANA Files to Tableau
• Created incremental refreshes for data sources on Tableau server.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh etc.
• Provided technical support to all team members during project execution.
• Performed reports/dashboards performance optimization.
• Recommending optimized design and chart for specific requirement.
• Handling change requests and providing support/maintenance for deployed projects.

Environment: Tableau Desktop 10x,9x, Tableau Server 9, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel, Power Point), HP ALM. Tableau Desktop 8.x, Tableau Server, Windows Server Standard R2, Excel, Oracle, Hadoop)