SUMMARY:

• Deep experience building interactive dashboards using Tableau Business Intelligence Solutions and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• More than 8 years of Data warehousing experience with Business Intelligence Tableau 2018.1/10.x/ 9.x/ 8.x/7.x/6, OLTP and OLAP Microsoft SQL Server, Oracle SQL Server as a Developer in various companies.
• Extensive experience in designing and deploying effective, visually appealing reports using Tableau Business Intelligence Solutions
• Broad experience working in many aspects of the System Development Life Cycle (SDLC) including requirements gathering, proof of concept delivery, Implementation, user support and maintenance.
• Deep experience improving performance of dashboards and creating incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Designed effective dashboards using tableau and Data manipulation using SQL, and Altyrex.
• Extensive experience in writing SQL Queries using CTEs, Dynamic SQL, Stored Procedures, and Functions
• Well versed in writing Stored Procedures, Triggers, Views and Functions using SQL and PL/ SQL .
• Good experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Well versed in building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

TECHNICAL SKILLS:

Tableau Desktop 6/7/8,9,10, 2018 Tableau Server 6/7/8,9/10/218 Tableau Online, Tableau Public, Tableau Reader, TabCmd, Microsoft SQL Server 2012/2008 - R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0, Microsoft Visual Studio 2010/2008/2005, Microsoft Access, Microsoft Office(MS Word/ Excel/Powerpoint), MS Project, HTML, XML, Java, C++, C#

PROFESSIONAL EXPERIENCE:

Confidential - Cleveland, OH

Tableau Consultant

Responsibilities:

• Created and published Tableau credit risk dashboards utilizing complex calculated fields, table calculations, action filters, parameters
• Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
• Employed performance tuning procedures to increase performance and help make dashboard more user friendly
• Building customized Tableau charts such as Sankey Diagram, Pareto chart, Waterfall, Grouped Bar Charts, Donut Charts, and Bar-in-Bar Charts to create interactive and visually appealing dashboards
• Connecting to multiple data sources using blends, joins, cross-database joins
• Deeply involved in gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Designing Test Scenarios to validate Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Used Context filters and Created Geographic map reports which explains the company financial keys according to the members
• Reviewing business requirements and analyzing data sources form Oracle/SQL Server/Hadoop for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Writing complex, tuned SQL queries using CTEs, Stored Procedures, UDFs, and Dynamic sql to generate data for dashboards
• Working long hours and on some weekends to help resolve production related issues.
• Connecting to databases using custom sql, tables, and views.

Confidential, Birmingham, AL

Tableau Consultant

Responsibilities:

• Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
• Increased performance of dashboards by utilizing performance tuning procedures
• Built customized or unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server in various versions of Tableau
• Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementing Tableau BI tool in all IT projects
• Generated reports using SQL queries in Tableau and published them to users in online through Tableau server.
• Utilized, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau
• Designed effective dashboards for Top Executives to give an overview current Trends
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Configured User row level security for data in the Dashboard

Confidential - Mountain View, CA

Tableau Consultant/SSIS Developer

Responsibilities:

• Designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions
• Employed performance tuning procedures to increase performance and help make dashboard more user friendly
• Developed Tableau workbook and publishing it on server
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Working long hours and on some weekends to help resolve production related issues.
• Connecting to databases using custom sql, tables, and views.
• Deeply involved in gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Writing complex, tuned SQL queries using CTEs, Stored Procedures, UDFs, and Dynamic sql to generate data for dashboards

Environment: Tableau Desktop, Tableau Server, Oracle, SQL, SSIS, Teradata, Workday, Cognos

Confidential, Orem UT

MS SQL Developer /Data Analyst

Responsibilities:

• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation and ETL processes
• Created Entity Relationship (ER) Diagrams to the proposed database
• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Worked on the performance tuning part, as most of our applications have issues with the PL/SQL stored procedures.
• Designed, Developed and Deployed SSIS Packages
• Worked as a DBA and created creating tables, users, and permissions.
• Created database objects such as tables, views, stored procedures, Triggers etc.
• Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identified columns for Primary Keys in all the tables at the design time and create them.
• Created functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and written code to avoid those situations.
• Ensured that the code is written keeping in mind any security issues such as SQL Injection.
• Identified and written best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participated in development and creation of Data warehouses.