SUMMARY

• Nearly 7+ years of IT extensive experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions.
• Experience in designing highly interactive visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in configuring reports from different data sources using Data blending.
• Training Tableau to my team to produce appealing data visualizations to clients and to help them make effective business decisions
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in creating tableau stories from multiple tableau dashboards.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Expertise in getting the data from different data source such as MySQL, MongoDB, Oracle, SQL.
• Good knowledge in configuration and administration of Tableau Server.
• Experience in creating Documents, reports and dashboards for various business environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Experience involving in Lead roles during requirement gathering phase, reviewing business requirement documents (BRD's) and lead the client meetings.
• Ability to be flexible and deal with changing priorities and timelines/due dates
• Have working experience on different platforms Windows and Linux.
• Maintaining Issue logs and participating in weekly meetings and tracking the progress.
• Excellent communication skills to effectively communicate technical information to end users and ability to work individually on multiple projects.
• Extensive experience in Tableau Administration Tool for creating users, groups, sites projects etc.
• Quickly adapt to new technologies and involve in development activities during resource crisis.

TECHNICAL SKILLS

Reporting Tools: Tableau 9.x/8.x/7.x/6.x (Desktop/Server/Mobile/Public), SSRSCognos,Qlikview, Business Objects, SSRS

ETL tools: Informatica, MS SQL Server Integration Services

Languages: C, C++, HTML

Operating Systems: LINUX, WINDOWS XP/7

Domain: Financial, Banking, Retail, healthcare, and telecom

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS ProjectErwin

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/MySQL for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• 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 using Tableau.
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MySQL, Oracle, SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes.
• Created reconsolidation reports for conversion purpose using various joins.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Rewrote various business process and tested result in MS Excel using various functions and sub query with not exists.
• Involved in updating functional requirement document after development and created documentation for deployment team.

Tableau Developer

Confidential, Charlotte, NC

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Perform Tableau Server admin duties; add users/groups from Active Directory
• Create Schedules and extract the data into Tableau server.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations.
• Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Implementation of Row level security using User Filters and Username( ) in Calculated fields.
• Worked on Parameters, Table Calculations and Hierarchies.
• Publishing Dashboards to Mobile Devices and user Training.
• Effectively used data blending, data joins and Level of Detail Expressions practices
• Define best practices for Tableau report development.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Execute and tested required queries and reports before publishing.
• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Schedule 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.
• Develop parameter and dimension based reports, drill - down reports, charts, and Tabular reports using Tableau Desktop.
• Execute and tested required queries and reports before publishing dashboards.
• Provide support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively work on Tableau Desktop, by creating Complex reports & Dashboards.
• Create Tableau scorecards, dashboards, Heat maps using show me functionality
• Scheduling the monthly/weekly/daily reports to run automatically.
• Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Create procedures to ensure the quality, usability and accuracy of reports.

Environment: Tableau Desktop, Tableau server, SQL Server 2008R2, Informatica 8, SQL

Tableau Developer

Confidential, Dallas, TX

Responsibilities:

• Worked extensively with business users to gather new requirements and solve existing issues.
• Analyzed the requirements to identify gaps between the requirement guidelines and technical design.
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Created Micro Strategy objects metrics, filters, prompts, templates, consolidations, transformations, and custom groups using Micro Strategy Desktop.
• Worked in developing reports, metrics, derived metrics, compound metrics and filters for complex reporting.
• Created Dashboards for various business requirements using widgets like Micro Charts, Bubble Graph, and Heat Map; as well as to personalize the reports as per user requirements, by using and editing several sets of individual grid reports.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Utilized auto prompt filter feature giving the end-user a choice of different filtering criteria each time they run the report.
• Created various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report, consolidation reports.
• Extensively worked on creating Report Services documents using multiple Grids and Graphs.
• Worked in tandem with offshore team to leverage capabilities and meet the business requirements.
• Built complex formulas in Tableau for various business calculations.
• Built reports by connecting against Single Table, Multiple Tables and Custom SQL.
• Experience in creating Tableau worksheets and dashboards based of requirements.
• Experience in creating Different maps, dual axis charts in Tableau.
• Unit tested the reports and closely worked with QA team in developing test cases and scenarios.
• Provided User support during project development & End user testing of reports.

Environment: Micro Strategy v9.0.2, Tableau, Teradata, Oracle, Quality Center 9.2, SQL Server 2005, PL/ SQL, Linux, XML.

SQL BI

Confidential

Responsibilities:

• Implemented ETL process to load the Data Warehouse and developed repositories (Microsoft SQL Server)
• Participated in stakeholder and project review meetings on weekly basis.
• Responsible for testing process of extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed and documented the test cases for ensuring quality of data and performed thorough validation.
• Created dashboards and reports using Micro Strategy for managers which involved corporate wide data related to environmental factors
• Performed dimensional modeling to help prioritize different business processes
• Developed several scripts and SQL queries to create various reports for administration
• Developed Micro Strategy reporting tutorial for employees to help them create their own customized report

Environment: Informatica Power Center 6.x/7.1, BO 6.5, Microsoft Visio, Oracle 9i.