*

Summary

*+ years of Experience in PowerBI, Tableau (Desktop, Server). End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop.

Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.

Integrated Custom Visuals based on business requirements using Power BI desktop.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Knowledge in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.

Used SQL Queries at the custom SQL level to pull the data in tableau desktop.

Validated the results in Tableau by running SQL queries in Oracle SQL developer.

Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Para meters etc in Tableau.

Possess strong knowledge of database management in writing complex SQL queries, Joins, query optimization and resolving key performance issues.

Involved in reviewing business requirements and analysing data sources from Excel, Oracle, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.

Highly motivated team player and a Quick Learner with good communication, strong problem-solving skills and excellent in presentation and interpersonal skills.

Extremely well organized, meticulous, and highly self - motivated. Skills

Reporting Tools: Tableau, Tableau Reader, Tableau Server, Tableau Public, Power BI, SSRS ETL Tools: SSIS, SSAS, Informatica

Databases: Teradata, Oracle, MS-SQL Server

Tools: SDLC, Requisite Pro, MS Office, GIT, OLAP, TOAD, Waterfall, Agile Languages: SQL, PL/SQL, T-SQL, HTML5, CSS3

Operating System: Windows 7/8/10, Linux

Education

Master’s in Transport and Infrastructure

Marshall University, WV

Urvali Patel

Tableau/PowerBI Developer

Phone: 440-***-**** Email: add8cx@r.postjobfree.com

2

Experience

Cuna Mutual Group, WI Mar 2020– Current

Tableau Developer

CUNA Mutual Group is a mutual insurance company that provides financial services to cooperatives, credit unions, their members, and other customers worldwide. It sells commercial and consumer insurance and protection products and provides retirement plan services to small businesses and credit union employees. Roles & Responsibilities:

Generated Dashboards with Quick/context/global filters, Parameters, calculated fields and sets on Tableau to handle views more efficiently.

Generated context filters and data source filters while handling huge volume of data.

Built dashboards for measures with forecast, trend line and reference lines.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Participated in daily stand-ups with clients on daily design and development effort

Create detail level summary report and Dashboard using KPI's.

Created reports using Tableau functionality is like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server.

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts and Tabular reports using Tableau Desktop.

Created Tableau scorecards, dashboards, Heat maps using show me functionality.

Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau.

Worked on the data provider that forms the basis of the ad-hoc analysis. Environment: Tableau Desktop 2019.2.1, 2020.2.1, Tableau Server, MS Office Suite, SQL Server, MS Excel, SQL Server Management Studio 17.

Abbott Laboratories, IL Nov 2019– Feb 2019

PowerBI Developer

Abbott Laboratories is an American multinational medical devices and health care company. it sells medical devices, diagnostics, branded generic medicines and nutritional products. Roles & Responsibilities:

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from PowerBI Desktop to servers.

Implemented row level security on data and have an understanding of application security layer models in Power BI.

Designed PowerBI data visualization using crosstabs, maps, scatter plots, pie, bar, and density charts.

Utilizing Power Query in PowerBI to pivot and un-pivot the data model for data cleansing

Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

Integrated Custom Visuals based on business requirements using Power BI desktop.

Developed complex calculated measures using Data Analysis Expression language (DAX).

Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.

Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation, and allocation routines for delivering the desired KPI’s in the Cubes. 3

Environment: SQL Server Management Studio, Power BI Desktop, Power BI Service, MS Office Humana, OH Jan2019-Oct 2019

Tableau Developer

Humana is a health insurance company. We strive to meet different insurance needs for individuals, families, seniors, military personnel, and the self-employed.

Roles & Responsibilities:

Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.

Created ad-hoc reports to users in Tableau by connecting various data sources.

Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

Technically hands-on commercially experience mainly with full range of Tableau, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSRS, MS Performance Point Server and Informatica.

Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.

Used SQL tools like Toad, Pl/SQL to run SQL queries and validate the data in the warehouse and Datamart.

Created Tabular Matrix reports, Charts, and graphs as per customer requirements Using SSRS.

Made complex chart like Spider chart and funnel chart to better visualize the data.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Analysed the source data and handled efficiently by modifying the data types. Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.

Generated tableau dashboards with combination charts for clear understanding.

Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user-friendly in analysis purposes.

Environment: Tableau Desktop 8.0/7.0, Tableau server, SQL developer, SSRS, SSIS, Informatica, Microsoft Excel, MS Access, Microsoft office.

Stryker, WV Jun 2018 – Dec 2018

Tableau Developer

Stryker is one of the world’s leading medical technology companies and, together with its customers, is driven to make healthcare better. The company offers innovative products and services in Orthopaedics, Medical and Surgical, and Neurotechnology and Spine that help improve patient and hospital outcomes. Roles & Responsibilities:

Experience in design and development of Tableau visualization solutions.

Hands on development assisting users in creating and modifying worksheets and data visualization dashboards

Involved in creating a dual-axis bar chart with multiple measures.

Created report schedules on Tableau server.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.

4

Environment: Tableau 8.2, Microsoft SQL Server, MS Excel, MS Access. Metasystem, India Jan 2014 – Dec 2016

Tableau Developer

MetaSystems has been designing and manufacturing systems for computerized automated microscopic imaging. MetaSystems products are versatile platforms, ready to be used for many different applications Roles & Responsibilities:

Designed automated scripts in PL/ SQL, DTS and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

Exposed to data conversion from different data sources to SQL Server using SSIS.

Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server.

Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS).

Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created different KPI using calculated key figures and parameters.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Gathered user requirements, analysed, 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.

Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently. Environment: Tableau Desktop 8.0/7.0, Tableau server, SQL developer, SSRS, SSIS, Microsoft Excel, MS Access, Microsoft office.

Contact this candidate