SUMMARY:

• Over 8 + years of experience in Business Intelligence, Tableau, SQL server, Data warehousing concepts, Data modeling in various industries. Maintain positive and professional attitude always in communications and working relationship.
• Latest project was focused more on Vendor management within revenue cycle management of health care industry.
• Experience in visualization tool like Tableau in various versions of Tableau 7, Tableau 8, Tableau 9 and Tableau 10 .
• Experience in UI development in Tableau.
• Have always applied Best practices in Tableau for Businesses, to enhance the performance. Like using Extracts, hiding unused fields, relevant database, parameters and sets Etc.
• Excellent understanding of Tableau architecture, design, development, function and end business user experience.
• Experience in responsibility of Tableau Administration for user / group setup, permissions, security roles, managing licenses, data connections and Scheduling tasks.
• Involved in Tableau Server installations, configuration, server tuning and troubleshooting system issues.
• Extensively involved in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation and documentation.
• Experience in gathering user s requirements, analyzing and designing software solution based on the requirements using Agile methodologies .
• Experience in analysis, Data modeling, design, and development of Tableau reports and dashboards for analytics and reporting applications.
• Experience in connecting and using multiple database from multiple server such as Hive, SQL database, Oracle by using specific queries to each database. Have applied table joins blending for analytics as needed.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Excellent Knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes , ETL processes, dimensional modeling and reporting tools.
• Experienced in developing rich Interactive reports and complex dashboards integrating various reporting components from multiple sources.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau desktop report.
• Team player and quick learner with good communication skills and ability to work independently and as a part of the team.
• Has always fulfilled the commitment made in Agile board.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management.

TECHNICAL SKILLS:

Reporting Tools: Tableau 6, Tableau 7, Tableau 8, Tableau 9, Tableau 10, SSRS.

Databases: Oracle 11g/ 10g/ 9i, MS SQL Server 2012/ 2008/ 2005/2000, MS Access, Excel, Teradata, DB2, Hive.

Languages: SQL, PL/SQL, C#, Java, HTML

ETL Tools: Congo’s Decision Stream 6, SAP BODS, SSIS, Oracle Data Integrator

Operating System: Windows 2000, 2003, 2008, Solaris 9, Solaris 10, Red hat Linux

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential, Chicago, IL

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, unit test and implementation of Dashboard in multiple environment.
• Created Vendor Management Module to help business user, to understand the vendor analytics.
• Created multiple Dashboards to support Vendor Management Module to show vendors inventory, performance, transactions and scorecard using custom calculations.
• Created multiple metric/calculations and use various dimension for KPI metric analysis . Use Show me functionality to enhance the output.
• Created a Dashboard to compare performance of various stakeholders on different measures.
• Created a Validation Dashboard for ETL team, to help them see the flow of data from source table to main table.
• Publishing of various kinds of live/extract based interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers .
• Train user to interact, filter, sort, customize views and enable subscription on Tableau Server for an existing visualization generated through Tableau .
• Identified and solve the issues in coordinating with testing team within marked SLA.
• Prepared detailed documents for the Dashboard specifications.
• Created custom database connections, join tables as needed, create & manage Extract and Monitor Queries using SQuirreL SQL Client .
• Implementing best - practices for the dashboards with a solid understanding of the use of Contexts filter, hiding sheet functionality and their impact on performance.
• Develop Ad-hoc reports according to user’s requests and meet the expectation.
• Experience in publishing reports, data source and dashboards, scheduling refresh, create projects, groups, users, exporting the reports in different Formats in Tableau server.
• Experienced in data source transition and troubleshooting its impact .
• Experienced in using URL’s, Hyperlinks, action filters for developing Complex dashboards.
• Extensively created views using Aggregations, Calculated Fields and Table calculations, Totals, Percentages, Parameter and Measure.
• Maintained professional relationship with the Product and Technological team.
• Have always completed the committed story for the sprint while following Agile board .

ENVIRONMENT: Tableau 9/10, Tableau Server, MS Excel, SQuirreL SQL Client, Hue

Tableau Developer and Admin

Confidential, Lowell, MA

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test, implementation and report.
• Build up Key Performance Indicators ( KPI's ) reports.
• Publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications.
• Train user to interact, filter, sort and customize views on an existing visualization generated through Tableau 8, Tableau 9 .
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau.
• Prepared detailed technical documents from the functional specifications.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending and show me functionality.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts filter and their impact on performance.
• Develop Ad-hoc Business object reports according to user’s requests.
• Experience in publishing reports and dashboards to Tableau server .
• Created report, schedules data connections, projects, groups, users in Tableau server.
• Administered user, groups and scheduled instances for reports in Tableau server.
• Experienced in Server monitoring, troubleshooting, Disaster Recovery.
• 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.
• 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.
• Experienced in using URL’s, Hyperlinks, action filters for developing Complex dashboards.
• Extensively created views using Aggregations, Calculated Fields and Table calculations, Totals, Percentages and Measure.

ENVIRONMENT: Tableau 8/9, Tableau Server, SQL Server 2008 R2, SSMS, MS Excel

Tableau Developer and Admin

Confidential, Holland, MI

Responsibilities:

• Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including interaction between the two charts for drill down analysis .
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Blended data from multiple databases such as MS Excel and Oracle, SQL database by assigning primary key from each database.
• Developed geographic maps showcasing demographics broken into age, race, and income category.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Good experience in using URL’s, Hyperlinks in dashboards.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered projects, user, groups, permission and scheduled instances for reports in Tableau Server .
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Experience in Tableau Server upgrades, taking backup’s and restoring
• Presented, interacted, and communicated with business user for explaining the dashboards that was created with the change timely fashion.
• Connect to SAP BW directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Provided 24/7 production support for Tableau users.

ENVIRONMENT: Tableau Desktop 7/8, Tableau Server, Oracle, SQL Server, MS Excel.

Tableau Developer

Confidential - Pleasanton, CA

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Develop reports, dashboards using Tableau Desktop for quick reviews to be presented to Business users.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and action.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Converted charts into Crosstabs for further underlying data analysis.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed Ad-hoc reports using Tableau Desktop.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Create views to calculate top ten product using filters and parameter.
• Build up views by using two measures for correlations .
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ extracts .
• Tested dashboards to ensure data was matching as per the business requirements.
• Participated in meetings, reviews, and user group discussions.

ENVIRONMENT: Desktop 7/8, Tableau Server, MS Office Suite, Oracle Sql server R2, MS Excel.

Tableau Developer

Confidential - New York, NY

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Involvement in start-to-end activity of dashboard development from requirements gathering to deployment phase.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server .
• Created action filters, parameters and calculated field, sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Involved in installation of Tableau desktop, Tableau server Application software.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Involved in creating Business requirement documents and plans for creating dashboards .
• Involved in creating ad hoc analysis and reporting requests, in a timely manner.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.
• Worked extensively with analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, filters, Groups, hierarchies, Sets to create Granularity level summary report and Dashboard.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Was positive and team player all times.

ENVIRONMENT: Tableau Desktop 7/8, Tableau Server, Oracle, SQL Server, MS Excel, T-SQL.

MS SQL Server/SSIS/SSRS Developer

Confidential, Plano, TX

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect used on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Created OLAP cubes and dimensions for the analysis, using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

ENVIRONMENT: MS SQL Server, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, MS Excel, MS word, MS SQL Analysis Services.

MS SQL Server/SSIS/SSRS Developer

Confidential

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (e.g. SQL Server, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2005 package execution.
• Created OLAP cubes sand dimensions for the analysis using SSAS .
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS .
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Tested and managed the SSIS 2005 and SSIS 2005 packages and was responsible for its security.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2005.

ENVIRONMENT: MS SQL Server, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, MS Excel, MS word, MS SQL Analysis Services.