Chetan

+1-334-***-**** Email: adw3ra@r.postjobfree.com

Professional Summary

Over 10+ years of experience in IT industry.

Experience in creating aggregates, hierarchies, formatting, sorting and grouping using Power BI and Tableau Desktop.

Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision making.

Experienced in designing customized interactive dashboards in Tableau using Action, filters, Parameter and calculations.

Extensive knowledge in creating data visualizations using Power BI and Tableau Desktops and regularly publishing and presenting dashboards.

Experience in Creating Data Blending in Tableau.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets in Tableau server.

Experienced in Tableau to deliver NPS and KPI and trend information to business lines, sales development, and marketing groups.

Proficient with creating Tableau dashboards and Power BI.

Proficiency with Tableau Server and Publisher.

Good Knowledge in Designing and Development as Extraction, Transformation and Loading of Data in Structured format to Data Warehouse.

Data warehousing experience using ETL Tool-SSIS, (Source Analyzer, Warehousing Designer, Mapping Designer, Transformations).

Capable in working independently and within a team environment as well.

Professional Experience

Working as a Senior Data Analyst at Optum Global Solutions (United Health Group), from Feb’2016 – Aug’2022.

Working as a Software Engineer for Nextwave India Techno Solutions Pvt Ltd from June’2012 – Feb’2016.

Technical Skills

Reporting Tool : Tableau, Power BI

RDBMS : SQL Server, Snowflake

ETL Tools : SSIS and Azure.

Academic Profile

MS(MSIS) From Trine University, USA in 2023

B.Tech (ECE) From JNTU, Hyderabad in 2012

Project Profile

Project : Digital Capabilities

Duration : Feb 2018 to Till Date

Role : Sr Data Analyst

Environment : Tableau, Power BI, SQL Server, Snowflake.

Description:

Listening to customers to understand and respond to their needs is at the heart of our efforts to meet or exceed the expectations of those we serve.

To measure our performance and better understand how effectively we serve our customers, we use The Net Promoter System (NPS). This is a robust set of principles, feedback systems, processes, technologies and measurements used to fuel conversations, build customer relationships, improve customer experiences and generate lasting loyalty

Responsibilities:

Designed, developed and implemented Tableau Business Intelligence reports.

Representing data using the Cross Tabs, stacked Bars, Pie Charts and Bar Charts.

Developed Post contact and Kana Chat Reports as per customer requirements.

Experience on NPS (Net Promoter Score).

Use parameters and input controls to give users control over certain values.

Created summarized menu options as tabs in homepage where the users easily chose the required option.

Building workflows in Azure Data factory.

Responsible for dashboard design, layout, look and feel and development.

Project : Monthly Business Review

Duration : Feb 2016 to Jan 2018

Role : Senior Reporting Analyst

Environment : Power BI, Tableau, SharePoint, Windows Xp.

Description:

Simplify and streamline data collection and reporting for the Optum Technology Operations Report. The OT Operations Report is a monthly report prepared for senior leadership which provides summary and detail highlights for major programs that interest the senior leadership team.

Responsibilities:

Involved in gathering Requirements.

Designing and develop Tableau Reports, Documents, Dashboards and Story per specified requirements and timelines.

Creating Customized and Interactive dashboards using data sources and custom objects.

Implementation Planning and Execution.

Performance tuning and optimized extracts for dashboards.

Preparation of Test Scenarios, Test Cases and Execution of Test Cases.

Attending the Daily Status call with onsite team.

Deployed reports in Development and production.

Created end to end Active Reports.

Project : Sales Services

Client : Ingram Micro, USA

Duration : June 2014 to Feb 2016

Role : Tableau Developer

Environment : Tableau 8.x, Oracle 10g, Windows Xp.

Description:

Ingram Micro Inc. is the world's largest technology distributor and a leading technology sales, marketing and logistics company. As a vital link in the technology value chain, Ingram Micro creates sales and profitability opportunities for vendors and resellers through unique marketing programs, outsourced logistics services, technical support, financial services and product aggregation and distribution.

Responsibilities:

Involved in gathering Requirements.

Designing and develop Tableau Reports, Documents, Dashboards and Scorecards per specified requirements and timelines.

Developed various Reports as per customer requirements.

Experience on KPI(key performance Indicators).

Creating Customized and Interactive dashboards using data sources and custom objects.

Implementation Planning and Execution.

Performance tuning and optimized extracts for dashboards.

Implemented SDLC process in application development.

Preparation of Test Scenarios, Test Cases and Execution of Test Cases.

Attending the weakly Status call with onsite team.

Deployed reports in production.

Created end to end Active Reports.

Project:

Project : Data warehouse for Sales Depot Management System .

Client : Valeant Pharmaceuticals, USA

Duration : June 2012 to April 2014

Role : BI Developer

Environment : SSIS, MS SQL SERVER, Tableau

Description:

This project involves building of a Data Warehouse solution to meet the various requirements of Valeant Pharmaceuticals Sales depots, which are located across the country. The basic requirements for Valeant Pharmaceuticals with respect to sales and distribution are

• Stock availability across location and products

• Inventory Management

• Order Management

• Customer Accountancy

• Sales.

Responsibilities:

Extracting data from sources like Oracle and Flat Files, SAP, Tera data

And transforming them using the business logic and loading the data to the target warehouses.

Preparing interface design documents and ETL design documents for Mapping.

Analyzing Source Database Objects as per the warehouse Database requirements

Developed User defined Transformation and Mapplets for Reusability of code.

Handled Multiple Database Connectivity including oracle, Teradata, SQL Server

Developed mappings as per the Requirement, Using the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc

Contact this candidate