PROFESSIONAL SUMMARY:

• Over 8 years of IT experience with 5 years of experience in Tableau Desktop/Server
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Hands on Experience on Data Visualization tools like Tableau, MicroStrategy
• Certified Tableau Desktop 10 Qualified Associate
• Gathered business requirements after meeting with senior Insurance partners and advised partners from accounting, financial services, marketing, retirement plans on the best course of action and followed through to direct partners
• Involved in creation of Data visualization reports, workbook prototypes for Business users and peer groups
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Strong experience with Agile methodologies and the ability to manage team, appropriate to meet business and technology needs
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Build and manage the experience design process, workflow, and integration with agile with SDLC
• Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.
• Knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Data blending implementation on EMPI databases and generated interactive dashboards.
• Creating adhoc reports to users in Tableau by connecting various data sources.
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, SQL Loader.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage
• Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop.
• Hands on Experience on ETL Tools like Informatica, SSIS,SSRS
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like 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 per the business/client requirement
• Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, SQL Server Netezza, AWS and Hive.
• Expertise in Tableau Data Extracts, Data Blending, Dashboard actions, Row Level Security etc.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses, data connections and scheduling tasks.
• Published of various kinds of interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau Servers
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed SQL database and BI solutions using T-SQL, SSIS, SSRS, MDX, query performance tunings, database development, support of data, and underlying data models

TECHNICAL SKILLS:

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, Camp Hill PA

Tableau Admin/Developer

Responsibilities:

• Designing the Visualization Reports as per business Requirement.
• Installed and configured TableauServer and TableauDesktop.
• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x. Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementing Tableau BI tool in all IT projects. Generated reports using SQL queries inTableauand published them to users in online thruTableauserver.
• Performed generating Daily/Weekly Sales & Finance trending reports usingTableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Involved in meetings with business users to discuss and finalize the requirement and design of reports.
• Worked on motion chart, Bubble chart, Drill down analysis usingtableaudesktop.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Published of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Worked extensively with Advance Analysis Actions, parameters, dynamics groups and sets, data hierarchies, context and global filters, calculated fields, ad-hoc calculations, forecasting, lines, table calculations, background images, trend lines and other custom function like string functions, date functions and logical functions
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Performance turning in Tableauto improve report response time.
• Coding Custom SQL scripts for creating aggregate tables and generating views.
• Responsible in designing and developing various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.
• Work with team members to understand and clarify visualization requirements needs and designing the database as per project requirement.
• Deftly designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports by Quality, Service, Cleanliness & Legal rating against compliance & supporting commentary per test, each carrying a weighting resulting in a total overall score, Bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc.
• Assisting users with questions and issues usingTableau. Working with various infrastructure teams andTableau support team to help improve dashboard response time.
• Advocate the use ofTableau 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, ExcelPower Point), HP ALM.Tableau Desktop 8.x, Tableau Server, Windows Server Standard R2, Excel, Oracle, Hadoop.

Confidential, Seattle WA

Tableau /MicroStrategy Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards
• Extensive use of data blending, filters, parameters, sets, groups etc., with best practices
• Knowledge on installation, configuration, procurement assessment, machine uplifts.
• Upgrades existing servers to 9.3, which facilitates automatic worker upgrades.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• 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.
• Experienced with different kind of Dashboard like traditional performance summary, traditionalmetric, dynamic content and dynamic visualization dash boardsapplications 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.

Environment: Tableau Desktop version 9.3, Tableau Server, MySQL, Microsoft SQL Server, MongoDB, Windows, Tomcat, Microsoft Visual Studio, ERWIN

Confidential

Business Intelligence Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1.
• Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features
• Worked closely with all team members in implementing Tableau BI tool in all IT projects
• Generated reports using SQL queries inTableau6.0/7.0 and published them to users in online through Tableau server
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint.
• Design and development of new MicroStrategy Reports for the new Retail BI system- created Schema objects / Application objects as well as configuration objects in Test environment.
• As MicroStrategy Architect Involved in building schema objects to supported business process change or enhancements throughout projects.
• Handling Daily user issues - Setting up and maintaining MicroStrategy web user roles and ps, helped in resolving daily issues in running Reports and Data Integrity issues.

Environment: MicroStrategy, Tableau, SQL Server, Teradata,Inforamtaica,SSIS,SSRS

Confidential

SQL Developer

Responsibilities:

• Worked on different stages of Project Life Cycle.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
• Conducted code review to ensure development standards.
• Used export and import utilities for logical backups.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used SQL *LOADER to load large amounts of data from external files to database.
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent. Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for
• Created different user level groups, and assigned appropriate permission level to the database.

Environment: Oracle Database 9i, MS EXCEL, T-SQL, UTL FILE, SQL*Loader, Windows XP