SUMMARY:

• Around 9 years of experience in Business Intelligence, Business Analytics and Data Analytics.
• 6 years of experience working with various versions of Tableau including the latest 2018.1, 10.5, 10.4 and the previous versions 10.x, 9.x, 8.x.
• Extensive experience with Tableau desktop in creating highly interactive reports and dashboards using features like Quick filters, Data blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Involved in gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs. valuable experience in designing and developing Tableau Visualizations.
• Performed Tableau admin activities across a multi - server and multi-tier environment which involves Tableau Server Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Experienced in Tableau working with different Enterprise Data sources like SAP HANA, SSAS Cubes, Hadoop HDFS, SQL Servers, AWS Redshift, DB2 and the Extracts (auto/incremental).
• Experience in using Tableau functionalities for creating different Requests, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Proficient at using Confidential for Data Blending, Data Cataloging, Data Profiling and In- Database Processing.
• Published Tableau Workbooks by creating User filters and sites to give controlled access to user groups on Tableau Server.
• Worked on the API for the functionality enhancement on server for site users and sites on Tableau server.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Ensured effective communication of User Requirements.
• Strong understanding of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Inmon, Snowflake, Kimball, data modeling and SQL.
• Good understanding of Enterprise Data Warehouse Power insight data.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Skilled in Data Profiling, Data Cleansing, Business Domain Modeling, Logical Data Modeling, Physical Relational Data Modeling and worked on Entity Relationship Modeling.
• Used Oracle, SQL Server, Google Analytics and MS Excel as input data in Tableau database connection and used database extract for publishing database on Tableau Server.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Impact Analysis and providing corrective actions to meet business requirements.
• Played a key role in the agile team including overseeing job sprints on SCRUM based projects.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.
• Good understanding of business process management and business analytical skills with an ability to adapt modern technology quickly.

TECHNICAL SKILLS:

Data Visualization Tools/ Reporting Tools: Tableau Desktop, Tableau Server, Tableau Reader, Tableau online.

Programming Languages: SQL, T-SQL, PL/SQL, PostgreSQL, Python, HTML

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 11g/10g, Teradata, AWS Redshift.

Productivity Tools: MS Office, MS Excel, MS Visio, MS Project, Confidential

Methodologies: Agile, Waterfall, Scrum.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Tableau Consultant

Responsibilities:

• Studied and analyzed applications and brainstormed with the business team for gathering effective requirements for the system.
• Followed SCRUM (Agile) methodology and developed dashboards with value-added products.
• Created Complicated Calculation Based LOD (Level of detail) feature in Tableau.
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Designing and developing data warehouse and AWS Amazon Redshift BI based solutions.
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Worked in the application UI to present to the end users with Tableau dashboards and visualizations on multiple platforms.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Conducted Data blending, Data preparation using Confidential and SQL for tableau consumption and publishing data sources to Tableau server.
• Communicated effectively with team members and Business teams to table the requirements to ensure the correct functionality is achieved. Effectively communicated with team members and Business teams to table the requirements to ensure the correct functionality is achieved.
• Designed and implemented SSL server authentication for AWS Redshift clusters.
• Support ad-hoc requests; perform deep-dive analysis to identify areas of concern and debugging of data inaccuracies.
• Modelled User filters to enable the row level security in tableau within client's premises.
• Used Azure SQL Data warehouse which facilitated reading, writing and managing large data sets residing in distributed storage.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Developed Dashboards and published them to Tableau Server allowing end users to analyze the data on the fly using action filters for on-demand purpose.
• Connected Tableau to Azure which allowed to easily access the cloud storage and perform data visualization for that cloud data.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization
• Implements wireframe methodology to prepare prototype dashboards to design overall processes integration
• Acted as a Tableau Administrator, using Tableau Server for publishing the developed dashboards to server, authentication, authorization, security, Tableau Extracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as a Tableau Content Administrator.
• Involved in scheduling data refresh on Tableau Server on a weekly and monthly basis to ensure that the views and dashboards were displaying the updated data correctly.
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server

Environment: Tableau 10.x, SQL Server 2016, Amazon AWS Redshift, DB2, Azure, JIRA, Confidential, SQL.

Confidential, Chicago, IL

Sr. Tableau Consultant

Responsibilities:

• Took part in the end-to-end implementation and enhancements from gathering requirements to dashboards development in Tableau Desktop.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Wrote Python routines to log into the websites and fetch data for selected options.
• Transformed raw data into Visual Analytics with a projection of significant KPIs.
• Created Dashboards to allow the users to dynamically interact with the data to the lowest level of granularity.
• Created Tableau Semantic Metadata dashboard, acts as a self-service tool to quickly pull the Data Mapping of in-house Tableau Data Sources.
• Created crosstabs for displaying underlying data based on various graphs and charts for future data analysis.
• Optimized workbook using Work Book Tools (Performance Analyzer).
• Restricted data for particular users using Row level security and User filters.
• Worked on creating Tableau work books for data residing on Oracle source system.
• Created Custom Admin Views dashboard by connecting to Workgroup database and allowed the users to audit the usage of Workbooks, Data Sources and Views.
• Created Actions in Worksheets and Dashboards and enhanced the user interactivity.
• Built Excel, Confidential View and Domo reports in Tableau. Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Worked on editing Data connections and changing data sources in Tableau.
• Worked with unstructured data creating workflows in Confidential with documentation and implementation of the processed data.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields, to compare and analyze data in different perspectives.
• Developed and wrote elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure Database.
• Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.
• Designed and implemented SSL server authentication for AWS Redshift clusters.
• Involved in writing complex SQLs using windowing functions to extract data from AWS Redshift without Stored Procedure
• Developed and reviewed SQL queries with use of join clauses in Tableau Desktop for validating static and dynamic data for data validation
• Involved in reviewing business requirements and analyzing data sources from Excel/MySQL, AWS Amazon Redshift for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data.
• Built complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Worked on using different visualizations like Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat Maps, High Light tables and rendered the data into data visualization with high performance.
• Developed reports using multiple measures like Individual Axes, Blended Axes and Dual Axes.

Environment: Tableau Desktop 10.x, Tableau Server, MS SQL Server 2014, DB2, Oracle, AWS Redshift, Confidential, SQL Server Management Studio, SQL, PL-SQL, T-SQL.

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross-functional departments, business users and documenting them in the reports specifications document and report inventory.
• Worked on gathering and converting data over to Tableau using SQL /Excel data over to Tableau reports and Dashboards.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Worked with clients to better understand their reporting and dashboard needs and present solutions using structured Waterfall and Agile project methodology approach.
• Designing and developing data warehouse and AWS Redshift BI based solutions.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Involved in managing the application's users, groups, and integration with Active Directory
• In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics. Evaluated database performance issues and executed database optimization.
• Use various data sources like SQL Server, SQL Analysis server (cube), AWS Redshift, Hadoop and Hive.
• Utilized the Extract API in Tableau 9.3 to create dynamic Tableau data extracts using R, Python programming.
• Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Confidential view and Confidential Sense Environment.
• Administered user, user groups, and scheduled instances for reports in Tableau. Handling Big data loads to Confidential view and Confidential Sense and implemented impactful solutions.
• Acted as a Developer for designing and developing, prototyping the various dashboards using tableau desktop.
• Involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
• Experience with managing multiple Data Analytics work streams, spanning across Data Engineering, Data Science and Review of data visualization.
• Wrote heavy Netezza SQL scripts to load the data between Netezza tables and implemented ELT process for SCD type 1 and SCD type 2 dimensions.
• Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.
• Hands on experience with Confidential in developing sample Dashboards by connecting to Confidential .
• Involved in designing AWS Redshift DB Clusters, Schema, and tables.

Environment: Tableau Desktop 10.x, 9.x, Tableau Server, Teradata, SQL Server, Confidential, Oracle 10g, MySQL, Python, API Development Toad, Confidential View, Netezza, AWS Redshift, MS Access, Informatica.

Confidential, Marietta, GA

Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop. Worked on scheduling reports, managing data sources and refresh extracts.
• Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau.
• Generated Tableau dashboards with combination charts for clear understanding.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to the server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Published dynamic dashboard reports to Tableau server for navigating the developed dashboards on the web.
• Administered and provided production support for Enterprise-wide Tableau application consisting of multiple key functional business domains.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau. Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Oracle 10g, Microsoft Office Suite (Word, Excel, PowerPoint), Teradata Administrator.

Confidential, Long Beach, CA

Business Intelligence Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Build a common utility framework to handle all the exceptions in a Business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Designed and implemented the proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Discussed intelligence and information requirements with internal and external personnel.
• Data output - made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.

Environment: SQL Server 2008 Enterprise Edition, Python, T-SQL, SSRS

Confidential, Hingham, MA

Business Analyst

Responsibilities:

• Responsible for Requirements Gathering, Analysis, detailed Process Flow Design, User Acceptance Testing and rollout of new & modified feature functionality deployed on the e commerce website applications.
• Created Functional Requirement Document (FRD) for the process.
• Gathered and validated requirements for shopping cart, checkout and order management modules.
• Performed tactical hands-on work of creating concept sketches, interactive wireframes, visuals designs, user journey flows and more.
• Supported the quality assurance testing to ensure that business requirements were addressed in the Test Plans and tested various files for the scenario testing
• Clearly and concisely communicated business requirements to developers and interacted with IT team to clarify and resolve any issues.
• Prepared technical project documentation and reports to enable users to accomplish their tasks with ease without wasting time and effort.
• Communicated the project status through meetings and status reports and translated technical language into common language for staff and customers.
• Worked closely with Technical Architects, Developers, Test Managers, Business Stakeholders and Project Managers to achieve project objectives in defined time frames.

Environment: MS Office Suite, MS Project, SQL Server 2005, Agile, HTML, XML, JavaScript, MS Visio.