SUMMARY:

• Over 8 years of total IT experience in Analysis of data, designing the data, Development of structured data, Documentation and Implementation of Business Intelligence applications.
• Good experience in Tableau Desktop and basics of Tableau Server in various version of tableau including Tableau 7 x and Tableau 8x.
• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analytics projects.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Histograms, Bullets, Heat maps, scatter plots, Gantts, Bubbles and Highlight tables.
• Involved in Trouble Shooting, performance basis checks of the reports, analyzing and rectifying issues within Tableau Server and dashboards.
• Extensive experience with Tableau Desktop, Reports and Data Visualization.
• Designed and published visually rich and interactive Tableau workbooks and dashboards for executive decision making. Work with Business Users to resolve queries and provide quick reports, analysis on critical issues.
• Hands on Experience in development of Dashboards and Storyboards in Tableau.
• Experience in sorting, grouping and formatting.
• Experience in creating various views in Tableau.
• Experience in creating Filters, Quick filters, Table calculations and Parameters.
• Worked on Symbol Maps, Filled Maps, Sets, and Bins, Sorting and Grouping.
• Working with Different types of Joins, Data blending, and Actions in tableau.
• Working with Different Types of charts like Tree maps, Gantt View, Bubble Charts, Area Charts and Pie Charts.
• Knowledge on Tableau Server creating users, groups, projects, site roles, publishing workbooks into tableau servers.
• Working With Clipboards, Pivot Transformation, What if Analysis.
• Creating schedules, permissions, data security using tableau server.
• Ease in dealing with end users while working on KPIs, Requirements and detail designs.
• Deploying interactive dashboards, visualizations and story.
• Extensive usage of Data Blending multiple data sources into a single dashboard.
• Experience on Custom SQL, Pivot, assume referential integrity, Join Culling.
• Experience on Tableau Analytical Issues including pitfalls and solutions.
• Outstanding team player with good interpersonal and communication skills and the ability to work in a team or as an individual.
• Excellent problem - solving skills with excellent business communication.

TECHNICAL SKILLS:

BI Tools: Tableau 7.0, 8.0, 9.0, QlikView11 (Trained), MS Excel, ROAMBI, Spot Fire, MS Office, Outlook, Cognos.

Relational Databases: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, ETL, Teradata, MS Access.

Tools: and Packages SQL Server Management Studio, Microsoft Visual Studio, Toad.

Languages: SQL, C, C++, HTML, CSS, PHP.

Operating Systems: Windows 9x/XP/2000/Vista/7, Unix, Linux.

Configuration Management Tools: Team Foundation Server, IBM Data Management.

PROFESSIONAL EXPERIENCE:

Confidential, Englewood, CO

Tableau Developer

Roles and Responsibilities:

• Developed interactive Tableau visualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
• Implemented data blending and joins to work with data from multiple databases in a single report.
• Implemented Data Representation using Visualization Techniques in Tableau using Alteryx (Graphs, Charts etc.)
• Involved in Data modeling, designing, and building relational databases.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
• Created and maintained several custom reports using Business Objects
• Understood underlying Data and reworked Data Analysis with PowerBI.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Developed & Implemented Reports using Tableau Server.
• Responsible for Creating of Users, Groups and Projects on Tableau Server.
• Created Customized and interactive dashboards (pulling data from multiple data sources)
• Used Java Script API to customize the views, selects, filters, date and time.
• Implemented tableau data extracts and created dependencies to trigger subscriptions once the extracts are finished through TABCMD utility.
• Leveraged tableau built in graphical capabilities to create bar charts, tree maps, area charts and also created custom visualization like donut charts, trellis plots etc.
• Worked on Visual Studio 2012 with SSIS and SSRS Integration.

Environment: Tableau Desktop 9.0/8.2/8.0, Tableau Server 8.2, Oracle 11g, MYSQL Server, MS SQL Server 2008, Excel, TSQL, UNIX, SQL Server 2008, MS Office.

Confidential

Sr. Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Granting permissions based on user role
• Automate monitoring & server job processes
• Handled Tableau Server Management (like Clustering, Load Balancing, User Management etc)
• Handled and monitored tableau migration and scheduling.
• Experience in taking back ups and restoration of Tableau repository
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems

Environment: Tableau Server 7, Tableau Desktop 8.1, MS SQL Server 2008, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, ROAMBI, Qlikview.

Confidential, San Jose, CA

BI & Reporting Developer - Tableau

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Scheduled data extracts on a daily basis.
• Support UAT and fix the identified defects prior to PRODUCTION migration.
• Worked on testing, validation of data and project documentation.
• Handing a Team of 4 members
• Preparing the Weekly Status Report and Work allocation to the Team
• Developed performance management dashboards internally and externally by using Crystal Reports.

Environment: Tableau Desktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, MS Office, Visual Studio 2010, ROAMBI.

Confidential, Phoenix, AZ

Business Intelligent Analyst/Data Analyst

Responsibilities:

• Involved in gathering the requirements from the business.
• Created specifications for systems to meet business requirements.
• Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements.
• ETL - extracting Data via SQL Queries.
• Supported SSAS cubes in Sql Server 2005.
• Created different types of reports based on requirements using SSRS 2005.
• Develop and utilize standard templates to accurately and concisely write requirement specifications.
• Environment: Sql Server 2005, SSIS, SSAS, Excel, Windows XP/Vista, MS Access, SQL Server, Teradata, MS Excel, MS Office.

Environment: Tableau 6.0, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows XP, Unix, ROAMBI, Micro-strategy.

Confidential

Business Intelligent /Crystal Reports Developer

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in documenting the changes to the universe and reports functionality.
• Designed and developed Crystal Reports such as Parameterized Reports, Cross tab Reports, Mail label, List reports based on base tables, views, involving Formulas, Sub Totals, Running Totals, and Sub Reports.
• Developed various types of Charts and Graphs like Bar Chart (Side by Side, Stacked), Line Graphs, Pie Charts, etc by using Chart expert of Crystal Reports.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Implemented Publishing wizard & Import wizard for migration of reports.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users and Free-hand SQL as data provider.
• Created New Classes and User Objects according to the requirements.
• Created various simple and complex reports using drill down, filters and alerts.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Expert in tuning the performance of SQL queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks

Environment: Informatica 8.6, Hyperion (Oracle), SQL, Oracle 10g, Windows XP/UNIX