SUMMARY

• Over 10+ years of experience in IT Software design, development, implementing, testing, reporting and production support.
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer/Administrator and Analyst. End to end experience in designing and deploying data visualizations using Tableau Desktop.
• Experience analyzing large data and creating visually compelling and actionable interactive reports and Dashboards using Tableau.
• In - depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations inTableau.
• Extensive experience in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) usingTableauDesktop.
• Experience in publishing Dashboards toTableauServer
• Extensive experience in Tableau Architecture and Administration, configurations and installations.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports
• Actively participated in clarification meeting with the Clients.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• 2 years of ETL Testing experience in Business Intelligence Tools like Informatica, Oracle and Business objects.
• Experience in Unit Testing and End to End Integration testing across various modules.
• Experience in Testing Transformations and Mappings usingInformaticaDesigner and processing tasks using Workflow Manager to move data from multiple sources into targets
• Extensively used Oracle SQL andworked with database tools like Sql Developer, Toad.
• Prepared technical documents for different components during the implementation
• Ability to work in team and independently with minimal supervision.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Heat maps and Highlight tables.

TECHNICAL SKILLS

BI Reporting Tools: Tableau 8.x/9.x,Business Objects XI 3.x

E T L Tool: Informatica Power center 8.6.1/9.1.0

Database: Oracle 10g/11g, MS SQL Server 2008

Languages: C, C++, SQL

Operating System: Windows 95/98/2000/NT/XP, UNIX/Linux, DOS.

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Performed requirements gathering, Source data analysis and identified business rules.
• Involved in the client meetings with other associates to discuss the schedules, progress of work, requirement changes and other deliverables issues.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Created customized Calculations, Sets, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Heat maps and Highlight tables.
• Work closely with Oracle apps teams and compliance team to understand their needs and creating visualization on Tableau.
• Data blending implemented on databases and generated interactive dashboards.
• Created Parameters to achieve desired functionality.
• Created conditional prompts and Action links to filter the data on dashboard.
• Designed aggregated tables on the most frequently queried data for Daily, Monthly & Yearly based reports.
• Recommend and take lead on new ideas of implementation/developing of reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server.
• Scheduling Tableau dashboards.

Environment: Tableau 8.2/9, Oracle 11g, Windows

Confidential, MA

Tableau Developer

Responsibilities:

• Designing the Reports based on the Requirement and developed the Tableau reports using Excel file and Oracle database.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Created Parameters to achieve desired functionality.
• Created conditional filters and Action links to filter the data on dashboard.
• Publishing dashboards on server Using Tableau Desktop.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Scatter plots, Heat maps and Highlight tables.
• Work closely with Quality team to understand their needs and creating visualization on Tableau.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Confidential

Responsibilities:

• Understand the business requirements and Functional Requirement, Design documents and actively participated in providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed universe using Information design tool (IDT)
• Having Good experience in Tableau Business Intelligence Tool for dashboard development.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, solution architects, and project managers.
• To understand Business requirements, analysis and translate into Application and operational requirements.
• Translates functional requirements of the reports build into technical specifications document.
• Involved in the complete process cycle; functional skills in analysing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Tuned Universes for Report level performance.
• Writing SQL validation queries for cross testing the resulting data from the reports.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Migrated number of reports from Dev /Test to Production environments.
• Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
• Revised the Group Structure in both Development and Production Environments.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Created alerts, filters and inserted Breaks in designing reports.
• Design processes to minimize data quality risks and proactively identify potential data issues.

Environment: Tableau 8.xInformatica 8.6.1 and Oracle 10g and Business Objects XI 3.1.

Confidential, MI

Tableau Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
• Gathered data from various data sources regarding electric vehicles and electric vehicle charging stations and provided analytical reporting using statistical modeling and Predictive analysis
• Implemented Tableau BI Dashboard reporting solution for different groups in the organizations like CARB,EPA and RRT
• Converted MatLab Reports to Tableau Reports and defined best practices for Tableau report development.
• Worked on Performance Tuning of the Workbook and improved the performance of the report running for 15 min to 90 seconds execution time
• Effectively used data blending feature in tableau to get data from Sql Server & MS Excel
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations
• Customized the Geo maps to use custom shapes and converted latitude/longitude sets to City/state using Reverse Geocoding utility.
• Created out of the box charts for complex end user Requirements. Converted Heat map to Funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
• Created TDE’s using Hadoop as the datasource and using Hive and Impala connectors.
• Improved the Performance of data extracts created from Hadoop using contexts and Action filters instead of quick filters
• Executed and tested required queries and data before publishing Dashboard
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Wrote Custom SQL to fulfill user Requirements and used Parameters in custom SQL for the Dynamic prompts as requested by the end users.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publishthem to server.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.2
• Deep experience with the design and development of Tableau visualization solutions
• Provided 24/7 production support for Tableau users.

Environment: Tableau Desktop 7.0/ 8.0, Tableau server / Administrator, tabcmd, SQL developer, Hadoop, Hive, SQL Server 2008

Confidential, Providence, RI

BI developer/ETL Tester

Responsibilities:

• As a CFS team member Interacted with Functional/End-user's to gather Requirement for Core reporting system by understanding Exceptional features, User Expecting with reporting system by designing Business requirement package (BRP's) to successfully implement Business logic.
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Resolved the loops using Contexts and checked the Integrity of the Universes.
• Exported the Universes to Repository for making it available to users
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Created Complex workbook to visualize sales report using scattered plots, bar charts by tableau desktop
• Applied Multi-dimensional analysis such as slice and dice, drill functions at report level.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0
• Identify risks associated with the testing strategy, then document and communicate such risk to stakeholders
• Involved resolving Error's in the reports like context error, Syntax errors, Multivalve Error, Timeout errors,
• Created custom Function's (Date range, Time functions, and Conditional formatting functions)in the reports.

Environment: Business Objects XI R2/ 3.1, Informatica, Microsoft Excel 2007, Tableau 7.0

Confidential

Business Objects Support Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Involved in the study of user requirements, analysis & review of designs and schema.
• Maintain/update current Business Objects end user reports.
• Create/develop special ad-hoc reports, database queries, status reports, etc. as requested using BOXI.
• Provide ad-hoc analysis and reporting to business units
• Created E-R schema by identifying entities and their related attributes.
• Worked on Erwin tool in created E-R diagrams.
• Designed and developed tables in MS Access Database.
• System documentation, program specification and testing.
• Analyzing requirements, technical design and development areas.
• Created tables, indexes, sequences and constraints
• Tested and documented the database created.

Environment: BOXIR2/6.5 Designer, Desktop Intelligence, Excel, Web Intelligence, Import WizardCMC, CCM, Oracle 9i, Toad.