Karthik Jayakumar

Project -1

• Name : Sales Analytics
• Environment: Tableau,Oracle,Excel

Description:

• Mercy Health is a non-profitable health care system serving Grand
• Rapids, Muskegon, the Lakeshore and surrounding West Michigan communities
• Improving patient outcomes while minimizing costs is a complex equation, Tableau helps health care systems uncover new ways to reduce costs and optimize payments, while delivering better patient outcomes
• Tableau Combine your financial and clinical data to ensure that not over- servicing and under-delivering care

Responsibilities:

• Coordinated with Onsite coordinator and offshore team for understanding of requirements
• Designing the reports as per client Requirement and created the reports using Excel files and oracle data base
• Analysis of Data, design and development of Views and Dashboards
• Created the required Extract Data source from data bases and tables
• To generate the dashboards which as Sales, Profit and claim information of the customers
• Created Scatter plot chart, filters, and actions on dash boards
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports
• Developed various dashboards, used context filters, sets while dealing with huge volume of data
• Developed Interactive Dashboards using various tableau objects like Actions,
• Parameters and Filters in various levels
• Created Independent filters, Sets, Groups, custom hierarchies, calculated fields to meet the requirement
• Involved in design and development of various reports utilizing Tableau
• Visualizations like bar chart, line chart, pie-charts, side by side bars, area charts, heat maps, tree maps and few advanced visualizations like Waterfall charts, Do nut chart according to the end user requirement
• Knowledge in Tableau server, to creating users, groups, assigning roles to the users, and entire groups
• Created action filters, parameters, advanced calculation, Data Blending, sets, Group,
• LOD for preparing dashboards and worksheets in Tableau Generated Dashboards by joining multiple complex tables.

Project-2

Environment:

• Tableau,SQL Server

Description:

• Erie Insurance a publicly held insurance company, offering auto, home, commercial and life insurance through a network of independent insurance agent
• As of 2017, Erie insurance Group is ranked 378th among the largest public U.S
• Companies, in terms of revenue, by Fortune magazine

Responsibilities:

• Use Measure Names and Measure Values field to create visualizations with multiple measures and dimensions
• Preparing Dashboards using Calculations, Parameters in tableau
• Used filters, quick filters, sets, parameters, and calculated fields on Tableau reports
• Used Trend lines, Aggregate Functions, table calculations and Filters,
• Create visually compelling and actionable interactive worksheets and dashboards
• Using Tableau desktop analyses and obtain insights into large data sets
• Developed Interactive Dashboards using various tableau objects like Actions,
• Parameters and Filters in various levels
• Find ways to make graphs and tables visually exciting, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in design and development of various reports utilizing Tableau
• Visualizations like bar chart, line chart, pie-charts, area charts, heat maps, tree maps and few advanced visualizations
• Create Actions, Parameters, Filters, and Calculation sets for preparing dashboards and worksheets