K. Madhav

Mobile: 860-***-****

Email id: ac5idg@r.postjobfree.com

Professional Overview:

Over 6+ years of experience in Analysis, Design, Development, Testing and Implementation of Business Applications and Client/Server applications.

Extensive experience in Tableau Desktop in various versions of Tableau 7.x/8.x/9.x/10.x

Proficient in Tableau Data Visualization Tool to Analyze and obtain insights into large Datasets, Create visually powerful and actionable Interactive Reports and Dashboards.

Worked on Data Blending and increased the Dashboard performance by extracting data.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Filters, Calculated fields, Sets, Groups, Bins, Parameters in Tableau.

Experience in developing complex visualizations like Waterfall Chart, Donut Charts, Parito Charts.

Labored at the improvement of Dashboard reports for the Key Performance Indicators for the management.

Scheduled the workbooks according to the requirement- scheduled the extracts to refresh automatically.

Worked on complex KPI Scorecards, Heat Maps, Tree views, Circle views, Bar Charts, Data Visualizations and interactive dashboard which helped business get a good handle on the team's productivity.

Good interaction with Clients, understanding Business Applications, Business Data Flow and Data Relations.

In-depth knowledge on SQL queries and working with SQL Server 2000/2005/2008.

Experience in working and coordinating with offshore team.

Experience in creating different Visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt Chart, Bubble Chart, Histogram Chart, Heat maps and Highlight tables.

Experience in development of Reports and Dashboards in Tableau, on Tableau Desktop and Server.

Experience in creating filters – Quick Filters, Data Source Filters, Context filters.

Experience in creating Parameters, Formatting, Sorting and Grouping.

Creating different type of reports including Cross-tab.

Created Customized and Interactive Dashboards using multiple data sources.

Experience on creating Clipboards and Data Source Filters in tableau.

Extensive experience on Data Blending in Tableau.

Implementing Individual Axis, Axis Blending, and Dual Axis in Tableau.

Extensive Knowledge in creating Data Visualizations using Tableau Desktop.

Proficient in creating Groups, Set and Data Bins.

Skilled in Tableau Desktop for Data Visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts and Packed Bubbles.

Strong Analytical, Problem-solving, Organizational, Communication, Learning and Team skills.

Strong communication, Collaboration & Team building skills.

Working Knowledge on POWER BI.

Technical Skills:

Languages:

SQL

Applications:

MS Word, Power-point, Excel, MS-Project

Databases:

SQL Server 2005/2008/2012, MS Access, Teradata

Operating Systems:

Windows Server 2003, Server 2008, Windows XP/7/8

Business Intelligence:

Tableau Desktop 10.x/9.x/8.x/7.x/6.x, Tableau Server

Work Experience:

PNC Bank, Pittsburgh, PA July’ 2016 – till date

Sr. Tableau Developer

Project Description:

PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. No matter how simple or complicated your needs, we’re sure to have the products, knowledge and resources necessary for financial success.

In this project, performed Analysis of Risk & Various Transaction happening across various LOB’s and Source System. Transform the Data and Build Interactive Dashboards on top of the transformed data. Interacted with the Client’s, worked with them and understanding their Business requirements and Finance/Banking/Risk Concepts. Analyzed the Finance Data & Transaction Date and gave reverse engineering to the team. Maintained Existing reports, User Groups, Extract Schedules etc. Extracted and Transformed the Data, converted them into user interactive Dashboards.

Project: CCAR – Comprehensive Capital Analysis & Review / Financial reporting.

The long-term objective of SCPI work stream 4 is to deliverable demonstrable qualitative improvements to the CCAR and DFAST submissions processes through the implementation of the target state goals for process automation, controls, and model execution and analytics.

Responsibilities:

Designed, developed, tested, and maintained Tableau functional reports based on user requirements for CCAR & DFAST 2016 submission.

Worked Closely with ETL Architecture and reporting BA in creating the Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.

Work with business in understanding the Nature of Data, accordingly will get the best possible way to create dashboards in Tableau for different Domains using Oracle and Essbase data sources.

Worked on data from multiple data sources including Oracle, Hyperion Essbase, CSV file and ODBC connections. Created Reusable dashboards to utilize the same process for all the PPNR & Mortgage Models for Different Source systems.

Created Data loads, Data Quality Checks for ensuring data accuracy and reproducibility.

Hands on experience on reports using micro strategy and Qliksense and analyzed with Tableau reports for data consistency.

Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.

Mastered in different Formatting techniques, using Annotations and Mark labels.

Developed effective and interactive Dashboards using Calculated Fields and Parameters across Multiple Data Sources

Strong Dashboard design experience and passionate practitioner of effective data visualization.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Published and shared views on Tableau server and Scheduled extract refresh and subscriptions.

Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

Environment: Tableau 9.0, 9.3,10.0, Sql Server

American International Group, Charlotte, NC. Oct’2015 – June’2016.

Tableau Developer.

Project Description:

American International Group, Inc. (AIG), a world leader in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. In addition, AIG

companies are leading providers of retirement services, financial services and asset management

around the world.

Responsibilities:

Development of Tableau Visualizations and Stories in Tableau Desktop. Documenting Business requirements and plans for creating dashboards.

Experience in designing complex Tableau report packages and story publishing them on the Tableau Server.

Designed report that depicts top performers of the total client list in quadrant graph.

Designed Status Requestor Dashboard that provides status of specific request from end client which provides them tracking ability of their ad-hoc report requests.

Developing cohort analysis of claims data to estimate cost avoidance charges by connecting through virtual visit’s programs.

Developing KPI’s dashboard package to depict success of MD live program for the client.

Developed account specific reporting packages for client’s customers to track their spending on employee insurance.

Developed client accounts specific reports.

Enhancement of existing reports to improve performance by modifying the SQL code used in extraction of data.

Involved in design requirement meeting with clients and internal employees.

Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.

Working with Level of Details expressions (LOD’s) and Regular Expressions.

Migrating reports from standard reporting tools like Excel to Tableau.

Migrating all the reports from tableau 9.3 to tableau 10.2 and publishing them on the server.

Environment: Tableau Desktop 10.2/9.3, Tableau server 10.x/9.x, SQL Assistant.

Scientific Games Inc. Chicago, IL Dec’2014 – Sept’2015

Tableau Report Developer

Project Description:

Scientific Games is a leading innovator in the global lottery and regulated gaming industries. Beginning with the breakthrough technology that launched the world’s very first secure instant lottery game in 1974, the company has continued to advance the games, technology, programs, marketing research and security that have been a driving force behind the success of more than 300 customers on six continents over the last 40 years. Scientific Games is the industry’s only full-service provider offering diverse products, technology and services that can be customized to meet the unique requirements of virtually any lottery or gaming jurisdiction.

Scientific Games serves customers from advanced-technology manufacturing and operational facilities in North America, South America, Europe and Asia, with additional facilities located throughout the U.S. and around the world based on customer requirements.

Responsibilities:

Worked on multiple reporting tools include tableau, crystal reports and assisted ETL team

Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Building, publishing Customized Interactive Reports and Dashboards, Report scheduling using Tableau server.

Created action Filters, Parameters and Calculated Sets for preparing dashboards and worksheets in Tableau.

Converted metric insight reports to tableau reports.

Built complex formulas in Tableau for various business calculations.

Created Tableau reports based on existing Excel reports. Implemented best practices to improve dashboard visualizations and tableau performance.

Extensively used Data Blending in Tableau.

Administered User, User Groups, and Scheduled Instances for reports in Tableau.

Trend Lines, Reference Lines, Formatting and Axis. Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

Implemented data security by creating user filters.

Created report schedules, Data Connections, projects, groups in Tableau server and checking the task's daily on the server

Involved in creating database objects like Tables, Views, Procedures, Triggers, Functions using T-SQL to provide Definition, Structure and to maintain data efficiently.

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

Environment: Tableau (Desktop/ Server) Oracle SQL Developer, SQL Assistant, Microsoft office 2007, Business objects, SQL, PL/SQL.

Davita Healthcare Partners, Denver, CO Mar’ 2011 – Oct’ 2014

Tableau Developer

Project Description:

This project involves data files containing the claims and Health Care information for Members and Providers and then implement the data in the IIFP. Tableau is used for extracting the Data from database and to implement dashboards. The main aim of the project is to design active dataset to manage claim and patient details coming from various locations into Data warehousing engine in daily basis and prepare invoice for the orders. Calculate Medical Sales, Revenue, Net Profit and Gross Profited for decision making purpose.

Responsibilities:

Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.

Worked closely with Business Analyst in gathering various requirements

Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).

Building, publishing customized Interactive reports and Dashboards, report scheduling using Tableau Server.

Setting-up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.

Created adhoc reports to users in Tableau by connecting various data sources.

Generated Dashboards by joining multiple complex tables.

Created security parameters for tableau dashboards at row level.

Used excel sheet, flat files, CSV files to generate Tableau reports.

Generated Dashboards with Quick filters, Parameters and Sets to handle views more efficiently. Published Workbooks by creating user filters.

Hands-on development assisting users in creating and modifying Worksheets and Data Visualization Dashboards.

Created report schedules, Data Connections, Groups in Tableau server.

Generated Tableau Dashboards for Sales with forecast and Reference Lines.

Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.

Generated dashboard for Clinical Team, provided security by using user filters at row level.

Executed and tested required queries and reports before publishing.

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

Skilled in Tableau Desktop for data visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts and Packed Bubbles.

Environment: Tableau Desktop 10.2/9.3, Tableau server 10.x/9.x, Teradata Sql Assistant, Teradata 14, My SQL, Oracle, MS Excel.

Contact this candidate