| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateChetanPHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEProfessional SummaryOver 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 ExperienceWorking as a Senior Data Analyst at Optum Global Solutions (United Health Group), from Feb2016 Aug2022.Working as a Software Engineer for Nextwave India Techno Solutions Pvt Ltd from June2012 Feb2016.Technical SkillsReporting Tool : Tableau, Power BIRDBMS : SQL Server, SnowflakeETL Tools : SSIS and Azure.Academic ProfileMS(MSIS) From Trine University, USA in 2023B.Tech (ECE) From JNTU, Hyderabad in 2012Project ProfileProject : Digital CapabilitiesDuration : Feb 2018 to Till DateRole : Sr Data AnalystEnvironment : 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 loyaltyResponsibilities: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 ReviewDuration : Feb 2016 to Jan 2018Role : Senior Reporting AnalystEnvironment : 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 ServicesClient : Ingram Micro, USADuration : June 2014 to Feb 2016Role : Tableau DeveloperEnvironment : 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, USADuration : June 2012 to April 2014Role : BI DeveloperEnvironment : SSIS, MS SQL SERVER, TableauDescription: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 dataAnd 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 requirementsDeveloped User defined Transformation and Mapplets for Reusability of code.Handled Multiple Database Connectivity including oracle, Teradata, SQL ServerDeveloped mappings as per the Requirement, Using the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc |