SUMMARY:

• IT Professional with 8+ years of experience in System analysis, design, development, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions.
• Strong experience on Tableau & Business Intelligence and Databases & Data warehousing concepts.
• Expertise in Tableau 10.2/10.1/10.0/9.3/9.2/9.1/8.0, Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Expertise in ETL tools like SQL Server Integration Services (SSIS) and Relational Database Management Systems.
• Good exposure with SSAS and creating views, cubes, and converting business requirements into logical data models
• Expert in performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.
• Versatile team player with excellent leadership, analytical, interpersonal skills with an ability to quickly adapt to new technologies and project environments.

TECHNICAL SKILLS:

Tableau Desktop: 10.2/10.1/10.0/9.3/9.2/9.1/8.0 used various tableau versions to create visualizations appealing to end users and customers

Tableau Server: 10.2/10.1/10.0/9.3/9.2 Installation and configuration of Tableau server on various versions, Service pack upgrades, Version upgrades and end to end architecture designAlteryx 11.0 & 11.3

ETL Tools: SSIS and SSRS DTS

Well versed: with various ETL tools and SQL on what to use according to requirements in the project

SAP: BOBJ 4.0/3.1, HANA, QlikView, BIRT, SPICE, C, C+ +, Visual Basic, ASP.NET, SQL, PL/SQL. Platforms Oracle, MS SQL Server, Access, DB2, Teradata, Mongo DB, Cassandra

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Lead Tableau Developer

Roles & Responsibilities:

• Worked on creating schemas and connecting tableau to AWS Red shift and Hive
• Developed complex visualizations and dashboards and presented them to client
• Created User Requirement Documents and Business Requirement documents for the project and been a part of client data presentation
• Configured tableau setup in the project and did KVI Documentation of the project.
• Converted all the existing tableau dashboards from 10.1 to 10.0 based on the tableau server requirement of the client.
• Created User filters to enable the security of tableau dashboards within client’s premises.
• Developed Alteryx modules for big data analysis of geospatial information and SQL queries
• Designed and setup user security for the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created 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.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 10.1/10.0/9.3 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T - SQL to provide definition, structure and to maintain data efficiently.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.

Sr. Tableau Subject Matter Expert

Roles & Responsibilities:

• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
• Partner with the Technology teams to deliver a stable and highly available reporting platform
• Plan and implement the overall analytics and business intelligence strategy
• Worked on design & development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Setup and configuration of Tableau server 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Used the multiple data sources joins in Tableau 10.0
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Worked heavily using TabAdmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Designed and setup user security for the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created 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.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Handled user licenses for projects
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
• Importing tables using Warehouse catalog and Creating Logical Tables
• Involved as a technical expert providing input to application design regarding performance tuning and administration requirements.

Sr. Tableau Consultant

Roles & Responsibilities:

• Deeply involved with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used various ETL tools to extract data into Tableau Desktop and data wrangling using SSIS in data preparation phase.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used data connectors that are already available in Tableau, to read any site that publishes data in JSON, XML, or HTML.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters.
• Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Implemented new features in Tableau 9.1 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Tableau Consultant

Roles & Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL Server to Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Effectively assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
• Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
• Created mockup dashboards and presented to the higher level end users to have them a look and feel of the dashboards
• Developed mappings to support incremental loading.
• Involved in designing the Data model for the Data warehouse and for different Data marts
• Performed End to end testing using SQL Queries in Oracle.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses

Tableau Consultant

Roles & Responsibilities:

• Conversion of extreme level design specifications to detailed technical, functional specifications and interacted with business users for gathering requirements for Tableau Workbooks and Dashboards.
• Prepared use cases in Tableau and look and feel documents and got reviewed with end client.
• Worked on editing data connections and changing data sources in Tableau
• Handled tableau admin activities like granting access to users, managing extracts and installations.
• Specialized in analyzing and editing metadata (dimensions and measures) and saving data sources.
• Created worksheets by creating join/data blending, custom SQL and data source filters.
• Used various join types (left, inner, right, outer joins) based on business requirements.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Created non-hierarchical quick filter with sets.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Used symbol maps, filled maps and other map options to plot geographical data.
• Worked on background images which include plotting data on image.
• Created Tableau field maps feature with specific geographical roles.
• Used Show Me for creating visual analytics.
• Created interactive visualizations by adding quick filters.
• Analyzed data using Filter Shelf, Conditional filters (by using formula), and Dynamic measure filters.
• Created worksheets using parameters and used features like sorting, grouping, sets.
• Made data analysis easy to client by generating crosstab, aggregating data, using trend line, using page shelf and forecasting data.

Senior BI Consultant

Roles & Responsibilities:

• Converted high-level design specifications to detailed functional and technical specifications
• Worked on creating Universes using the Business Objects and connected to the database using ODBC.
• Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill By and Drill Through.
• Worked on WEBI InfoView to create and modify the existing reports
• Submitted and presented the reports in user-defined formats like Tabular, Master Detail, and Cross Tab.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Designed, tuned and optimized the Star Schema to implement core database.
• Scheduled and monitor different session of loading data using Power Mart Server Manager.
• Trained end users in basic and advanced ad hoc reporting skill.
• Maintaining and updating database models, generating or modifying the database schemas Data Mapping and DWH loading Use case analysis. Database coding and implementation.
• Used workflow manager for session management, database connection management and scheduling of jobs
• Loaded data from various sources using different Transformations like Source Qualifier, Joiner, Router, Aggregator, Lookup, Expression and Update Strategy to store the data in target table.
• Developed various Mappings & Mapplets to load data from various sources using different Transformations.
• Created Dashboard’s using the Interactive Metric Trends (IMT) and the Speedometer.
• Generated Business Objects XI 3.1 (Webi Intelligence), dynamic report, which allows business users to select multiple dates, or range of dates.

Business Objects Consultant

Roles & Responsibilities:

• Provided technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation.
• Used Report level joins and unions in some of the reports, created prompts and calculations in RS and FM model.
• Validated the schema and found the errors present in the ETL and also took part in giving the recommendations to fix the problem.
• Modified existing Universes to meet user-reporting requirements.
• Interacted with Business Objects technical team to solve the bugs involved in Business Objects.
• Met with the Business Analyst, Users and Business leads to understand their needs. Modified universes and created reports for them accordingly.
• Worked on Data Extraction and transforming data from using Data Integrator.
• Implemented the best practices for Business Objects Environment.